

SET enable_analyzer = 1;
SET single_join_prefer_left_table = 0;

SELECT '--- no name clashes ---';

CREATE TABLE t1 (id2 UInt64, id1 Int64, val UInt64) ENGINE = Memory;
INSERT INTO t1 VALUES (1, -1, 11), (2, -2, 22), (3, -3, 33), (4, -4, 44), (5, -5, 55);

SELECT '--- name clashes ---';

SELECT '-- using --';

SELECT '-- on --';

SELECT '--- unsupported and illegal conditions ---';
