summaryrefslogtreecommitdiffstats
path: root/yt/yql/tests/sql/suites/optimizers/keepworld_absorb_logical.yql
blob: 6090d1ed5fa23cf8f5c252f655aa4de5067adf05 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
PRAGMA config.flags('OptimizerFlags', 'KeepWorld', 'CheckMissingWorld');
PRAGMA AnsiInForEmptyOrNullableItemsCollections;

USE plato;

SELECT key FROM Input
WHERE (key NOT IN (SELECT key FROM Dict) AND key != "0") OR key != "0"
ORDER BY key;

SELECT key FROM Input
WHERE (key != "0" OR key NOT IN (SELECT key FROM Dict)) AND key != "0"
ORDER BY key;