yt/yql/tests/sql/suites/optimizers/drop_unessential_map.yql


1
2
3
4
5
6
7
8
9
10
11
12
13

USE plato;

PRAGMA yt.FuseMapToMapReduce="normal";
PRAGMA warning("disable", "4510");

SELECT * FROM Input0 WHERE YQL::Unessential(value != "not present", true);
SELECT * FROM Input0 WHERE YQL::Unessential(value != "not present 1", true) AND YQL::Unessential(value != "not present 2", true);
SELECT * FROM Input0 WHERE YQL::Unessential(value != "not present 3", true) OR NOT (value != "not present 3");
SELECT * FROM Input0 WHERE YQL::Unessential(YQL::Unessential(value != "other not present 4", true) OR NOT (value != "other not present 4") OR value != "not present 4", true) OR NOT (value != "not present 4");

$mapreduce_output = SELECT key FROM Input0 WHERE YQL::Unessential(key != "not present 5", true) GROUP BY key LIMIT 1;
-- optimizer must not go beyond operation bounds
SELECT * FROM Input0 WHERE key || Unwrap($mapreduce_output) != "not present 5";