hash-threshold 8
statement ok
CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER, d INTEGER, e INTEGER)
statement ok
INSERT INTO t1(e,c,b,d,a) VALUES(NULL,102,NULL,101,104)
statement ok
INSERT INTO t1(a,c,d,e,b) VALUES(107,106,108,109,105)
statement ok
INSERT INTO t1(e,d,b,a,c) VALUES(110,114,112,NULL,113)
statement ok
INSERT INTO t1(d,c,e,a,b) VALUES(116,119,117,115,NULL)
statement ok
INSERT INTO t1(c,d,b,e,a) VALUES(123,122,124,NULL,121)
statement ok
INSERT INTO t1(a,d,b,e,c) VALUES(127,128,129,126,125)
statement ok
INSERT INTO t1(e,c,a,d,b) VALUES(132,134,131,133,130)
statement ok
INSERT INTO t1(a,d,b,e,c) VALUES(138,136,139,135,137)
statement ok
INSERT INTO t1(e,c,d,a,b) VALUES(144,141,140,142,143)
statement ok
INSERT INTO t1(b,a,e,d,c) VALUES(145,149,146,NULL,147)
statement ok
INSERT INTO t1(b,c,a,d,e) VALUES(151,150,153,NULL,NULL)
statement ok
INSERT INTO t1(c,e,a,d,b) VALUES(155,157,159,NULL,158)
statement ok
INSERT INTO t1(c,b,a,d,e) VALUES(161,160,163,164,162)
statement ok
INSERT INTO t1(b,d,a,e,c) VALUES(167,NULL,168,165,166)
statement ok
INSERT INTO t1(d,b,c,e,a) VALUES(171,170,172,173,174)
statement ok
INSERT INTO t1(e,c,a,d,b) VALUES(177,176,179,NULL,175)
statement ok
INSERT INTO t1(b,e,a,d,c) VALUES(181,180,182,183,184)
statement ok
INSERT INTO t1(c,a,b,e,d) VALUES(187,188,186,189,185)
statement ok
INSERT INTO t1(d,b,c,e,a) VALUES(190,194,193,192,191)
statement ok
INSERT INTO t1(a,e,b,d,c) VALUES(199,197,198,196,195)
statement ok
INSERT INTO t1(b,c,d,a,e) VALUES(NULL,202,203,201,204)
statement ok
INSERT INTO t1(c,e,a,b,d) VALUES(208,NULL,NULL,206,207)
statement ok
INSERT INTO t1(c,e,a,d,b) VALUES(214,210,213,212,211)
statement ok
INSERT INTO t1(b,c,a,d,e) VALUES(218,215,216,217,219)
statement ok
INSERT INTO t1(b,e,d,a,c) VALUES(223,221,222,220,224)
statement ok
INSERT INTO t1(d,e,b,a,c) VALUES(226,227,228,229,225)
statement ok
INSERT INTO t1(a,c,b,e,d) VALUES(234,231,232,230,233)
statement ok
INSERT INTO t1(e,b,a,c,d) VALUES(237,236,239,NULL,238)
statement ok
INSERT INTO t1(e,c,b,a,d) VALUES(NULL,244,240,243,NULL)
statement ok
INSERT INTO t1(e,d,c,b,a) VALUES(246,248,247,249,245)
query I rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
query IIIIIII rowsort
SELECT e,
abs(a),
b,
abs(b-c),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2,
a+b*2+c*3+d*4
FROM t1
WHERE a>b
query III rowsort
SELECT abs(b-c),
b,
a+b*2+c*3+d*4
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (a>b-2 AND a<b+2)
query IIII rowsort
SELECT a,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4+e*5,
d
FROM t1
WHERE a IS NULL
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d-e
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (a>b-2 AND a<b+2)
query IIIIII rowsort
SELECT a+b*2+c*3,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR b IS NOT NULL
query I rowsort
SELECT abs(b-c)
FROM t1
query I rowsort
SELECT a+b*2
FROM t1
WHERE (a>b-2 AND a<b+2)
AND b IS NOT NULL
AND a>b
query IIIIIII rowsort
SELECT c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d-e,
c-d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4+e*5,
abs(a)
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND coalesce(a,b,c,d,e)<>0
AND c>d
query IIIIIII rowsort
SELECT d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(b-c),
c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2,
b-c
FROM t1
WHERE b>c
AND (e>c OR e<d)
query IIIIIII rowsort
SELECT e,
b,
a,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b,
(a+b+c+d+e)/5
FROM t1
WHERE b IS NOT NULL
AND coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3,
a-b,
d-e
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND c>d
AND c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
abs(a),
d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND (e>c OR e<d)
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query III rowsort
SELECT d-e,
c-d,
(a+b+c+d+e)/5
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR b>c
OR b IS NOT NULL
query IIIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b,
a+b*2+c*3+d*4,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d-e,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a-b
FROM t1
query III rowsort
SELECT a+b*2+c*3+d*4+e*5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
e
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR b>c
OR a>b
query III rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d-e,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND b IS NOT NULL
query IIIII rowsort
SELECT a+b*2+c*3,
a+b*2+c*3+d*4+e*5,
e,
a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c>d
query IIIII rowsort
SELECT e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
d-e,
d,
a+b*2+c*3+d*4
FROM t1
query III rowsort
SELECT e,
a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND d NOT BETWEEN 110 AND 150
query IIIIII rowsort
SELECT a+b*2,
abs(b-c),
c,
d-e,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE (e>c OR e<d)
OR (e>a AND e<b)
OR a IS NULL
query III rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR c>d
query IIII rowsort
SELECT abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE a IS NULL
OR d NOT BETWEEN 110 AND 150
query IIIII rowsort
SELECT a,
c-d,
a+b*2+c*3,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE (a>b-2 AND a<b+2)
OR b IS NOT NULL
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIII rowsort
SELECT a-b,
a+b*2+c*3+d*4+e*5,
b,
abs(a),
a
FROM t1
WHERE b>c
AND coalesce(a,b,c,d,e)<>0
AND (e>a AND e<b)
query IIIIII rowsort
SELECT abs(b-c),
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b,
a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query IIIIIII rowsort
SELECT a-b,
b-c,
abs(a),
abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b,
d-e
FROM t1
WHERE b IS NOT NULL
AND e+d BETWEEN a+b-10 AND c+130
AND c BETWEEN b-2 AND d+2
query II rowsort
SELECT a+b*2+c*3+d*4,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query II rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3+d*4
FROM t1
query IIIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(a),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2,
a,
d-e,
d
FROM t1
WHERE a IS NULL
AND d>e
query IIII rowsort
SELECT (a+b+c+d+e)/5,
c-d,
e,
a
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR (a>b-2 AND a<b+2)
query II rowsort
SELECT (a+b+c+d+e)/5,
d
FROM t1
WHERE b IS NOT NULL
query II rowsort
SELECT a+b*2+c*3,
c-d
FROM t1
WHERE b IS NOT NULL
OR coalesce(a,b,c,d,e)<>0
OR d NOT BETWEEN 110 AND 150
query IIII rowsort
SELECT e,
a+b*2,
c,
b-c
FROM t1
WHERE a>b
query IIIIII rowsort
SELECT c,
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4+e*5,
a,
(a+b+c+d+e)/5
FROM t1
WHERE b>c
AND (e>a AND e<b)
query IIIIII rowsort
SELECT (a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
abs(a),
d-e,
b-c
FROM t1
query IIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(a),
a+b*2+c*3+d*4+e*5,
a-b,
a+b*2,
c
FROM t1
query IIIII rowsort
SELECT c-d,
b-c,
a+b*2+c*3,
abs(a),
a+b*2+c*3+d*4
FROM t1
query I rowsort
SELECT d
FROM t1
WHERE c>d
AND (c<=d-2 OR c>=d+2)
AND (e>c OR e<d)
query I rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE b>c
query I rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query IIIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4,
abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
a+b*2,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR coalesce(a,b,c,d,e)<>0
query III rowsort
SELECT (a+b+c+d+e)/5,
e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE (a>b-2 AND a<b+2)
OR (e>a AND e<b)
query IIIII rowsort
SELECT b-c,
a+b*2+c*3,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE a IS NULL
query III rowsort
SELECT c,
a+b*2+c*3+d*4+e*5,
c-d
FROM t1
query IIII rowsort
SELECT a+b*2,
d,
abs(b-c),
e
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND d>e
query I rowsort
SELECT c-d
FROM t1
WHERE c>d
query II rowsort
SELECT a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR c>d
OR (e>c OR e<d)
query I rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE a IS NULL
query IIIIII rowsort
SELECT a+b*2,
d-e,
a-b,
abs(a),
(a+b+c+d+e)/5,
c
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND c BETWEEN b-2 AND d+2
AND coalesce(a,b,c,d,e)<>0
query III rowsort
SELECT a+b*2+c*3,
b,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR a>b
query I rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE (e>c OR e<d)
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d-e
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND (e>a AND e<b)
query II rowsort
SELECT b-c,
c
FROM t1
WHERE (e>a AND e<b)
query IIIII rowsort
SELECT d-e,
a+b*2+c*3+d*4+e*5,
a+b*2,
a,
b-c
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2,
a+b*2+c*3,
(a+b+c+d+e)/5,
d-e
FROM t1
WHERE (a>b-2 AND a<b+2)
OR b>c
query I rowsort
SELECT c-d
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(a+b+c+d+e)/5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c-d
FROM t1
WHERE d>e
OR a>b
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query I rowsort
SELECT e
FROM t1
query I rowsort
SELECT a+b*2
FROM t1
WHERE c>d
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query IIII rowsort
SELECT c-d,
a+b*2,
d-e,
a+b*2+c*3+d*4
FROM t1
WHERE b>c
AND b IS NOT NULL
AND (a>b-2 AND a<b+2)
query III rowsort
SELECT a-b,
abs(b-c),
abs(a)
FROM t1
WHERE a>b
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR d>e
query II rowsort
SELECT d-e,
abs(a)
FROM t1
WHERE (e>c OR e<d)
query III rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(a+b+c+d+e)/5,
b-c
FROM t1
query IIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b
FROM t1
WHERE a>b
AND b>c
AND (c<=d-2 OR c>=d+2)
query IIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
b-c,
a+b*2+c*3,
a+b*2+c*3+d*4
FROM t1
WHERE c>d
query III rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c,
a+b*2
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND a>b
query IIII rowsort
SELECT a-b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4,
d-e
FROM t1
WHERE (e>c OR e<d)
query I rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE a>b
AND coalesce(a,b,c,d,e)<>0
query III rowsort
SELECT a+b*2+c*3+d*4+e*5,
abs(b-c),
a+b*2
FROM t1
WHERE (a>b-2 AND a<b+2)
query IIIIII rowsort
SELECT d-e,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c,
e,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(b-c)
FROM t1
WHERE a IS NULL
query III rowsort
SELECT d,
c-d,
e
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR (e>a AND e<b)
OR a IS NULL
query III rowsort
SELECT a+b*2+c*3+d*4,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c
FROM t1
query IIIII rowsort
SELECT b,
d,
abs(a),
abs(b-c),
d-e
FROM t1
WHERE (e>a AND e<b)
OR e+d BETWEEN a+b-10 AND c+130
OR b IS NOT NULL
query III rowsort
SELECT a+b*2+c*3+d*4+e*5,
a+b*2+c*3,
c
FROM t1
WHERE b>c
AND a>b
AND e+d BETWEEN a+b-10 AND c+130
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4+e*5,
a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b
FROM t1
query II rowsort
SELECT d-e,
abs(b-c)
FROM t1
WHERE b IS NOT NULL
query III rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (e>c OR e<d)
query IIIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a,
d,
b-c,
b,
a+b*2+c*3+d*4,
a+b*2+c*3
FROM t1
query I rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE (a>b-2 AND a<b+2)
OR (e>a AND e<b)
query III rowsort
SELECT a+b*2+c*3+d*4+e*5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(b-c)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR c BETWEEN b-2 AND d+2
query II rowsort
SELECT c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR a>b
query III rowsort
SELECT b-c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4
FROM t1
WHERE (a>b-2 AND a<b+2)
query IIIIIII rowsort
SELECT abs(b-c),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
b,
d,
e,
c,
(a+b+c+d+e)/5
FROM t1
WHERE d>e
AND (c<=d-2 OR c>=d+2)
AND a>b
query IIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
e,
d-e,
(a+b+c+d+e)/5,
a-b
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND b IS NOT NULL
AND c>d
query IIIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
e,
d,
c-d,
a
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT (a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2,
c-d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR d>e
query I rowsort
SELECT d-e
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND coalesce(a,b,c,d,e)<>0
AND c BETWEEN b-2 AND d+2
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d,
b-c,
c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b,
abs(b-c)
FROM t1
query IIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(a+b+c+d+e)/5
FROM t1
WHERE (a>b-2 AND a<b+2)
AND (e>a AND e<b)
AND a>b
query IIII rowsort
SELECT c-d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3,
b
FROM t1
WHERE (a>b-2 AND a<b+2)
AND d>e
query IIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b,
d-e,
a+b*2+c*3+d*4
FROM t1
query IIII rowsort
SELECT d,
b-c,
abs(b-c),
b
FROM t1
WHERE c BETWEEN b-2 AND d+2
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(a)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR e+d BETWEEN a+b-10 AND c+130
query I rowsort
SELECT b-c
FROM t1
WHERE a IS NULL
AND (e>c OR e<d)
query IIIIII rowsort
SELECT abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c,
c-d,
a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE a>b
query I rowsort
SELECT d
FROM t1
WHERE (e>c OR e<d)
query II rowsort
SELECT c-d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND e+d BETWEEN a+b-10 AND c+130
AND (c<=d-2 OR c>=d+2)
query IIIII rowsort
SELECT a+b*2+c*3,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2,
d,
c
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR a>b
OR (a>b-2 AND a<b+2)
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(b-c),
d,
a-b,
a+b*2+c*3+d*4+e*5,
a+b*2,
abs(a)
FROM t1
query IIIIII rowsort
SELECT a+b*2,
d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d-e,
a-b,
a+b*2+c*3+d*4+e*5
FROM t1
query IIIIIII rowsort
SELECT abs(b-c),
a+b*2+c*3+d*4,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3,
c,
e,
d
FROM t1
WHERE a>b
OR (e>c OR e<d)
OR b IS NOT NULL
query II rowsort
SELECT a+b*2,
a+b*2+c*3+d*4
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR b>c
OR (a>b-2 AND a<b+2)
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2
FROM t1
WHERE b>c
query IIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
e,
a+b*2,
abs(a),
c-d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND c BETWEEN b-2 AND d+2
query III rowsort
SELECT b-c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
d-e
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND c>d
AND a>b
query IIIIII rowsort
SELECT d-e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
e,
b-c,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query I rowsort
SELECT a
FROM t1
WHERE (e>c OR e<d)
query IIIII rowsort
SELECT a+b*2+c*3,
abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a
FROM t1
WHERE b IS NOT NULL
query III rowsort
SELECT a+b*2+c*3,
d-e,
(a+b+c+d+e)/5
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (e>c OR e<d)
AND e+d BETWEEN a+b-10 AND c+130
query III rowsort
SELECT abs(a),
abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query IIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a-b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(a+b+c+d+e)/5,
c
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR a>b
OR b IS NOT NULL
query I rowsort
SELECT abs(b-c)
FROM t1
WHERE b IS NOT NULL
AND e+d BETWEEN a+b-10 AND c+130
query IIIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
a+b*2,
d,
a+b*2+c*3+d*4,
a-b,
b-c,
a
FROM t1
WHERE b>c
OR a IS NULL
query I rowsort
SELECT a+b*2+c*3
FROM t1
WHERE a>b
query IIIIIII rowsort
SELECT a+b*2,
a,
b,
c,
abs(b-c),
abs(a),
d
FROM t1
query II rowsort
SELECT b-c,
abs(a)
FROM t1
WHERE b IS NOT NULL
OR e+d BETWEEN a+b-10 AND c+130
OR c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT c-d,
b-c,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND (a>b-2 AND a<b+2)
AND a>b
query IIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
d-e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b,
abs(b-c),
d
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR e+d BETWEEN a+b-10 AND c+130
OR a>b
query IIIIIII rowsort
SELECT abs(a),
d,
e,
a+b*2+c*3+d*4,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c,
a
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIII rowsort
SELECT d-e,
abs(b-c),
a+b*2+c*3,
a+b*2,
a-b
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT a+b*2+c*3+d*4,
b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d-e
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR (e>c OR e<d)
OR c>d
query IIIII rowsort
SELECT (a+b+c+d+e)/5,
c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3,
d-e
FROM t1
WHERE a>b
AND (e>c OR e<d)
AND a IS NULL
query IIIII rowsort
SELECT a+b*2+c*3,
a+b*2+c*3+d*4+e*5,
d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(b-c)
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND a IS NULL
AND d>e
query IIIIIII rowsort
SELECT d,
b-c,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4,
c,
a
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4+e*5,
a+b*2+c*3,
b-c,
e
FROM t1
query IIIII rowsort
SELECT a+b*2+c*3+d*4,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR d>e
OR coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT a+b*2+c*3+d*4,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a-b,
c-d
FROM t1
WHERE (a>b-2 AND a<b+2)
AND (c<=d-2 OR c>=d+2)
query IIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
d-e,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query IIIIII rowsort
SELECT c,
b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3,
e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query III rowsort
SELECT (a+b+c+d+e)/5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b
FROM t1
WHERE c>d
query III rowsort
SELECT abs(b-c),
(a+b+c+d+e)/5,
d
FROM t1
WHERE (e>a AND e<b)
AND a IS NULL
query I rowsort
SELECT b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (c<=d-2 OR c>=d+2)
query IIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3+d*4+e*5,
c-d,
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4
FROM t1
query IIIII rowsort
SELECT a-b,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND d>e
AND coalesce(a,b,c,d,e)<>0
query II rowsort
SELECT a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND d>e
query IIIIII rowsort
SELECT abs(a),
(a+b+c+d+e)/5,
a+b*2,
c,
b,
d
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND (c<=d-2 OR c>=d+2)
query II rowsort
SELECT d-e,
a
FROM t1
WHERE b>c
AND (e>c OR e<d)
AND (a>b-2 AND a<b+2)
query IIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
a+b*2+c*3+d*4,
a+b*2+c*3,
d-e,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a-b
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND d>e
AND d NOT BETWEEN 110 AND 150
query I rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query IIII rowsort
SELECT a+b*2+c*3+d*4,
d,
d-e,
a-b
FROM t1
query II rowsort
SELECT d-e,
a-b
FROM t1
query III rowsort
SELECT abs(a),
a+b*2+c*3,
c-d
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND b IS NOT NULL
AND c>d
query III rowsort
SELECT a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d-e
FROM t1
WHERE a>b
query IIIIIII rowsort
SELECT c-d,
d-e,
a-b,
(a+b+c+d+e)/5,
b,
a,
abs(b-c)
FROM t1
WHERE d>e
AND b IS NOT NULL
AND coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT a,
d,
a-b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query IIII rowsort
SELECT d,
c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4+e*5
FROM t1
query IIIIII rowsort
SELECT b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2
FROM t1
WHERE a>b
query III rowsort
SELECT (a+b+c+d+e)/5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b
FROM t1
WHERE a>b
query II rowsort
SELECT abs(a),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query III rowsort
SELECT a-b,
b-c,
abs(b-c)
FROM t1
query I rowsort
SELECT c
FROM t1
WHERE (e>c OR e<d)
OR a>b
query IIIIII rowsort
SELECT (a+b+c+d+e)/5,
c-d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a,
c
FROM t1
WHERE (e>c OR e<d)
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE (a>b-2 AND a<b+2)
AND d>e
AND b>c
query I rowsort
SELECT a+b*2
FROM t1
WHERE (e>c OR e<d)
query IIII rowsort
SELECT a+b*2+c*3,
c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2
FROM t1
WHERE d>e
query I rowsort
SELECT d
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR b>c
OR c>d
query IIIII rowsort
SELECT c,
e,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d-e,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE a>b
query III rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c,
e
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR a>b
query IIIIIII rowsort
SELECT b,
d,
a,
c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4+e*5,
abs(a)
FROM t1
WHERE d>e
OR a IS NULL
query IIII rowsort
SELECT a+b*2+c*3+d*4,
c,
c-d,
b-c
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR a>b
OR b IS NOT NULL
query IIIII rowsort
SELECT abs(b-c),
b-c,
a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(a)
FROM t1
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2,
c,
d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND (c<=d-2 OR c>=d+2)
query II rowsort
SELECT d-e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE (e>c OR e<d)
query III rowsort
SELECT abs(b-c),
b,
e
FROM t1
WHERE (a>b-2 AND a<b+2)
query I rowsort
SELECT abs(b-c)
FROM t1
WHERE (e>a AND e<b)
AND c>d
query IIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
b,
c-d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT (a+b+c+d+e)/5,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(b-c)
FROM t1
WHERE (e>c OR e<d)
OR coalesce(a,b,c,d,e)<>0
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIII rowsort
SELECT a-b,
b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(a),
a+b*2
FROM t1
query IIIIIII rowsort
SELECT a+b*2+c*3+d*4,
abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (e>c OR e<d)
OR b IS NOT NULL
query I rowsort
SELECT c
FROM t1
WHERE b>c
OR b IS NOT NULL
OR (e>c OR e<d)
query IIII rowsort
SELECT d-e,
c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2
FROM t1
query IIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4,
c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE a IS NULL
query I rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
query I rowsort
SELECT d-e
FROM t1
query IIIIII rowsort
SELECT b-c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
c-d,
e,
b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR a IS NULL
OR c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(a),
a+b*2,
a
FROM t1
query IIII rowsort
SELECT d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
b-c,
a+b*2+c*3+d*4
FROM t1
WHERE (e>c OR e<d)
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND b>c
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4+e*5
FROM t1
query I rowsort
SELECT a+b*2+c*3
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND d>e
query IIIIII rowsort
SELECT d-e,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3,
a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(b-c)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR c BETWEEN b-2 AND d+2
OR (c<=d-2 OR c>=d+2)
query IIIIIII rowsort
SELECT abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d-e,
(a+b+c+d+e)/5,
b,
a+b*2+c*3,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query IIIIIII rowsort
SELECT e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
c-d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query III rowsort
SELECT c-d,
a-b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query IIIIIII rowsort
SELECT b,
a+b*2+c*3+d*4,
c-d,
a,
b-c,
a+b*2,
d-e
FROM t1
WHERE (e>a AND e<b)
OR b IS NOT NULL
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIII rowsort
SELECT a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(a),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query IIIIII rowsort
SELECT abs(b-c),
c-d,
c,
d-e,
abs(a),
b-c
FROM t1
WHERE b IS NOT NULL
OR (e>c OR e<d)
OR d NOT BETWEEN 110 AND 150
query I rowsort
SELECT a+b*2+c*3+d*4
FROM t1
query I rowsort
SELECT c-d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIIIII rowsort
SELECT a+b*2+c*3+d*4,
b,
a-b,
e,
c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE a>b
OR b IS NOT NULL
query IIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2,
e,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR e+d BETWEEN a+b-10 AND c+130
OR a>b
query II rowsort
SELECT d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE b>c
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT abs(b-c),
e,
b,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4
FROM t1
WHERE a>b
OR e+d BETWEEN a+b-10 AND c+130
OR d NOT BETWEEN 110 AND 150
query IIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
e,
b-c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE (e>c OR e<d)
query IIII rowsort
SELECT c-d,
d,
a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c>d
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR (e>a AND e<b)
query I rowsort
SELECT a-b
FROM t1
WHERE c BETWEEN b-2 AND d+2
query IIIIII rowsort
SELECT d,
a-b,
c-d,
a+b*2+c*3,
e,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE (e>a AND e<b)
OR a IS NULL
query I rowsort
SELECT a
FROM t1
query IIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2,
abs(a),
a+b*2+c*3+d*4+e*5,
d-e
FROM t1
query IIIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a,
abs(b-c),
abs(a),
c-d
FROM t1
WHERE c BETWEEN b-2 AND d+2
query III rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
d-e,
c-d
FROM t1
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b,
(a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d,
c-d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT c,
a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d
FROM t1
WHERE b>c
OR c>d
OR a>b
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
c,
e,
abs(a),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE a IS NULL
OR (e>a AND e<b)
query IIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3,
b-c,
abs(a),
a-b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query III rowsort
SELECT e,
a+b*2+c*3+d*4+e*5,
d
FROM t1
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
e,
b-c,
d-e,
abs(a)
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query III rowsort
SELECT d,
abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE a IS NULL
AND a>b
query IIIIII rowsort
SELECT b-c,
c-d,
d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query IIIII rowsort
SELECT a,
a+b*2+c*3,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
b
FROM t1
WHERE b IS NOT NULL
OR d>e
query IIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b,
abs(b-c)
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND c>d
AND a IS NULL
query III rowsort
SELECT a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
e
FROM t1
query IIIIII rowsort
SELECT d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a,
c,
e,
a+b*2+c*3
FROM t1
query IIII rowsort
SELECT (a+b+c+d+e)/5,
abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4+e*5
FROM t1
query IIIIIII rowsort
SELECT c-d,
abs(b-c),
b,
abs(a),
a,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query IIIIII rowsort
SELECT a+b*2+c*3+d*4,
e,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a-b,
c-d,
abs(a)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query I rowsort
SELECT (a+b+c+d+e)/5
FROM t1
query IIIII rowsort
SELECT a+b*2,
c-d,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (e>a AND e<b)
OR (c<=d-2 OR c>=d+2)
OR c BETWEEN b-2 AND d+2
query II rowsort
SELECT e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query IIIII rowsort
SELECT c-d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE a IS NULL
query II rowsort
SELECT d,
c-d
FROM t1
query II rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a
FROM t1
WHERE b>c
AND a>b
AND coalesce(a,b,c,d,e)<>0
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
(a+b+c+d+e)/5,
e,
a+b*2,
c-d,
a,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
query IIIIIII rowsort
SELECT e,
d-e,
a+b*2+c*3+d*4,
c,
d,
a-b,
abs(b-c)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query III rowsort
SELECT abs(b-c),
d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query IIII rowsort
SELECT c-d,
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
e
FROM t1
WHERE c>d
OR a IS NULL
OR (e>c OR e<d)
query IIII rowsort
SELECT abs(b-c),
(a+b+c+d+e)/5,
b-c,
a+b*2
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND d NOT BETWEEN 110 AND 150
query IIIII rowsort
SELECT (a+b+c+d+e)/5,
d,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3
FROM t1
WHERE b IS NOT NULL
query IIII rowsort
SELECT c,
a+b*2+c*3,
b-c,
a-b
FROM t1
query I rowsort
SELECT abs(a)
FROM t1
WHERE (e>c OR e<d)
AND d>e
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4,
a-b,
c-d
FROM t1
query IIIIIII rowsort
SELECT a+b*2+c*3+d*4,
abs(b-c),
d-e,
abs(a),
a,
e,
c-d
FROM t1
query I rowsort
SELECT c
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND (c<=d-2 OR c>=d+2)
AND (e>c OR e<d)
query IIIIIII rowsort
SELECT a+b*2,
(a+b+c+d+e)/5,
c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(b-c),
e
FROM t1
WHERE a>b
OR a IS NULL
OR b IS NOT NULL
query IIII rowsort
SELECT a+b*2+c*3,
d-e,
(a+b+c+d+e)/5,
a+b*2+c*3+d*4+e*5
FROM t1
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4+e*5,
abs(b-c),
a+b*2,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE b>c
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE c BETWEEN b-2 AND d+2
query I rowsort
SELECT d-e
FROM t1
WHERE (e>a AND e<b)
query III rowsort
SELECT b,
c-d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query III rowsort
SELECT d-e,
d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND (e>a AND e<b)
AND (a>b-2 AND a<b+2)
query IIIII rowsort
SELECT d-e,
abs(b-c),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
abs(a)
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND d NOT BETWEEN 110 AND 150
AND d>e
query IIIII rowsort
SELECT b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(a+b+c+d+e)/5,
a+b*2+c*3
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (e>a AND e<b)
query IIIII rowsort
SELECT d,
d-e,
a,
b-c,
e
FROM t1
WHERE (e>c OR e<d)
OR a IS NULL
query III rowsort
SELECT a+b*2+c*3+d*4,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4+e*5
FROM t1
query IIII rowsort
SELECT d-e,
d,
c,
b-c
FROM t1
WHERE a IS NULL
AND b>c
query IIIII rowsort
SELECT abs(a),
a+b*2,
a+b*2+c*3,
c-d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
query III rowsort
SELECT a+b*2+c*3+d*4+e*5,
a+b*2+c*3+d*4,
abs(b-c)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query I rowsort
SELECT c-d
FROM t1
query IIIIIII rowsort
SELECT abs(a),
a+b*2+c*3,
a+b*2,
c,
d,
a-b,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE b IS NOT NULL
query IIIII rowsort
SELECT a,
a-b,
a+b*2,
a+b*2+c*3,
(a+b+c+d+e)/5
FROM t1
query II rowsort
SELECT d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query III rowsort
SELECT a,
a+b*2+c*3,
d-e
FROM t1
WHERE d>e
AND b IS NOT NULL
query IIIII rowsort
SELECT b,
d-e,
(a+b+c+d+e)/5,
d,
a
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query IIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
e
FROM t1
WHERE a>b
OR b>c
OR c BETWEEN b-2 AND d+2
query IIIIII rowsort
SELECT d,
b-c,
a+b*2+c*3,
abs(a),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b
FROM t1
WHERE (e>a AND e<b)
OR d>e
OR (c<=d-2 OR c>=d+2)
query I rowsort
SELECT a+b*2
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND e+d BETWEEN a+b-10 AND c+130
query IIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(b-c),
(a+b+c+d+e)/5
FROM t1
WHERE d>e
OR (c<=d-2 OR c>=d+2)
query IIII rowsort
SELECT d,
a-b,
b-c,
c
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND a>b
query III rowsort
SELECT a+b*2+c*3+d*4,
e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
c,
abs(a),
abs(b-c),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR b>c
query II rowsort
SELECT abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE a>b
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query II rowsort
SELECT a+b*2+c*3+d*4,
c-d
FROM t1
WHERE c>d
query III rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
e
FROM t1
WHERE c BETWEEN b-2 AND d+2
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(b-c)
FROM t1
WHERE b IS NOT NULL
OR a>b
query III rowsort
SELECT a-b,
a+b*2+c*3+d*4+e*5,
a+b*2
FROM t1
WHERE c>d
AND b>c
AND (c<=d-2 OR c>=d+2)
query IIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d-e,
a+b*2+c*3+d*4,
a+b*2+c*3,
a-b
FROM t1
WHERE d>e
AND a>b
AND b>c
query I rowsort
SELECT abs(b-c)
FROM t1
query III rowsort
SELECT abs(a),
d-e,
a+b*2+c*3
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND (a>b-2 AND a<b+2)
AND (e>c OR e<d)
query IIIIII rowsort
SELECT b,
a+b*2,
c-d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(a)
FROM t1
WHERE b>c
OR (c<=d-2 OR c>=d+2)
OR d NOT BETWEEN 110 AND 150
query III rowsort
SELECT e,
b,
(a+b+c+d+e)/5
FROM t1
WHERE (e>a AND e<b)
OR b>c
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d-e,
abs(a),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE (e>a AND e<b)
OR (e>c OR e<d)
query IIIIIII rowsort
SELECT d-e,
a-b,
b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2,
b-c,
d
FROM t1
WHERE a>b
OR (a>b-2 AND a<b+2)
query IIIII rowsort
SELECT abs(a),
abs(b-c),
c-d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4+e*5
FROM t1
WHERE c>d
AND (a>b-2 AND a<b+2)
AND b>c
query IIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
abs(b-c),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2,
a-b
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND c>d
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(b-c),
e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
b-c
FROM t1
query II rowsort
SELECT a,
c
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND a IS NULL
AND (a>b-2 AND a<b+2)
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE c>d
query IIIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
b-c,
b,
a,
c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(a+b+c+d+e)/5
FROM t1
query IIIII rowsort
SELECT abs(b-c),
d,
c-d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
b-c
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE c>d
OR c BETWEEN b-2 AND d+2
query IIIII rowsort
SELECT b-c,
c-d,
d-e,
(a+b+c+d+e)/5,
d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIIIII rowsort
SELECT b,
e,
a+b*2+c*3+d*4+e*5,
d-e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query IIIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
c,
c-d,
a-b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(a+b+c+d+e)/5,
a+b*2+c*3
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND d>e
AND coalesce(a,b,c,d,e)<>0
query IIIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b,
a+b*2,
abs(b-c),
abs(a),
b-c,
d
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND (e>a AND e<b)
query I rowsort
SELECT a
FROM t1
WHERE b IS NOT NULL
AND d>e
AND e+d BETWEEN a+b-10 AND c+130
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d-e,
b-c,
a,
c,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query IIII rowsort
SELECT d-e,
abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR b IS NOT NULL
OR a>b
query III rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d
FROM t1
WHERE d>e
OR (e>c OR e<d)
OR coalesce(a,b,c,d,e)<>0
query I rowsort
SELECT a-b
FROM t1
WHERE (e>a AND e<b)
query IIIII rowsort
SELECT a-b,
(a+b+c+d+e)/5,
a,
a+b*2,
e
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIII rowsort
SELECT c,
c-d,
a,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query IIIII rowsort
SELECT (a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIIII rowsort
SELECT e,
b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c-d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query IIIIII rowsort
SELECT (a+b+c+d+e)/5,
a,
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(b-c),
d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (e>c OR e<d)
query I rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE d>e
AND a>b
AND a IS NULL
query IIII rowsort
SELECT (a+b+c+d+e)/5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3,
d
FROM t1
WHERE (e>a AND e<b)
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR a>b
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
e,
b-c,
c-d
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR c BETWEEN b-2 AND d+2
query II rowsort
SELECT abs(b-c),
b-c
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND coalesce(a,b,c,d,e)<>0
AND (e>c OR e<d)
query II rowsort
SELECT b-c,
(a+b+c+d+e)/5
FROM t1
WHERE c BETWEEN b-2 AND d+2
query IIIIII rowsort
SELECT a-b,
d-e,
b-c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c,
d,
abs(b-c),
e,
a+b*2+c*3+d*4+e*5
FROM t1
query I rowsort
SELECT a+b*2
FROM t1
WHERE (e>a AND e<b)
query IIII rowsort
SELECT a+b*2+c*3,
c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND c BETWEEN b-2 AND d+2
AND (c<=d-2 OR c>=d+2)
query IIII rowsort
SELECT a,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(b-c),
c-d
FROM t1
WHERE a>b
query IIIIII rowsort
SELECT c-d,
a+b*2+c*3,
d-e,
a+b*2+c*3+d*4,
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE b IS NOT NULL
OR (e>a AND e<b)
OR (e>c OR e<d)
query IIII rowsort
SELECT c-d,
a,
a+b*2+c*3,
a-b
FROM t1
query IIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3+d*4,
a+b*2+c*3,
e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE a IS NULL
OR c BETWEEN b-2 AND d+2
OR a>b
query I rowsort
SELECT e
FROM t1
WHERE c>d
AND coalesce(a,b,c,d,e)<>0
AND a>b
query IIIIII rowsort
SELECT d-e,
a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
b-c,
a+b*2+c*3,
c
FROM t1
WHERE (a>b-2 AND a<b+2)
query IIII rowsort
SELECT abs(a),
d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
e
FROM t1
WHERE (a>b-2 AND a<b+2)
OR coalesce(a,b,c,d,e)<>0
query III rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR a>b
query IIII rowsort
SELECT a,
e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(b-c)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR (e>a AND e<b)
query IIIII rowsort
SELECT d-e,
c,
(a+b+c+d+e)/5,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND (c<=d-2 OR c>=d+2)
query III rowsort
SELECT b,
c-d,
a+b*2+c*3+d*4+e*5
FROM t1
query III rowsort
SELECT a,
a+b*2,
a-b
FROM t1
query IIIII rowsort
SELECT e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(a),
a+b*2+c*3,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE c>d
OR e+d BETWEEN a+b-10 AND c+130
OR d>e
query IIIII rowsort
SELECT c-d,
a-b,
(a+b+c+d+e)/5,
b-c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query III rowsort
SELECT d-e,
b-c,
c
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND a>b
AND a IS NULL
query I rowsort
SELECT a+b*2+c*3+d*4+e*5
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query II rowsort
SELECT (a+b+c+d+e)/5,
a+b*2
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query I rowsort
SELECT (a+b+c+d+e)/5
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND a IS NULL
AND d NOT BETWEEN 110 AND 150
query IIII rowsort
SELECT b-c,
e,
c-d,
a-b
FROM t1
WHERE b>c
OR a IS NULL
OR b IS NOT NULL
query III rowsort
SELECT (a+b+c+d+e)/5,
abs(b-c),
d
FROM t1
WHERE a>b
OR a IS NULL
OR b>c
query IIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d,
a-b,
abs(b-c),
(a+b+c+d+e)/5
FROM t1
WHERE b IS NOT NULL
OR d NOT BETWEEN 110 AND 150
query IIII rowsort
SELECT d,
d-e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE b>c
OR c BETWEEN b-2 AND d+2
query IIIIIII rowsort
SELECT a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b,
c,
(a+b+c+d+e)/5,
a+b*2+c*3+d*4+e*5,
abs(b-c)
FROM t1
query II rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
abs(b-c)
FROM t1
WHERE a IS NULL
query IIIIII rowsort
SELECT a+b*2,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(a+b+c+d+e)/5,
a+b*2+c*3,
b-c,
a
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query IIIIII rowsort
SELECT abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
e,
abs(b-c),
b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE (e>c OR e<d)
OR c BETWEEN b-2 AND d+2
query III rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE b>c
query IIIIIII rowsort
SELECT c,
b,
a+b*2+c*3,
a+b*2+c*3+d*4+e*5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND coalesce(a,b,c,d,e)<>0
AND e+d BETWEEN a+b-10 AND c+130
query IIIIIII rowsort
SELECT c-d,
a-b,
a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(b-c),
d,
a+b*2+c*3
FROM t1
WHERE (a>b-2 AND a<b+2)
AND b>c
AND b IS NOT NULL
query IIIIII rowsort
SELECT a-b,
b,
a+b*2,
a+b*2+c*3+d*4+e*5,
d-e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR d>e
query II rowsort
SELECT (a+b+c+d+e)/5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE c>d
query IIIIII rowsort
SELECT a+b*2+c*3,
a+b*2+c*3+d*4,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(a),
b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE (a>b-2 AND a<b+2)
OR d>e
OR a>b
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b,
d,
a+b*2+c*3,
c,
(a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE (e>a AND e<b)
query IIIIII rowsort
SELECT a+b*2+c*3+d*4,
a+b*2,
d-e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(a),
a
FROM t1
query II rowsort
SELECT a+b*2+c*3,
(a+b+c+d+e)/5
FROM t1
WHERE (e>c OR e<d)
query IIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
a,
abs(b-c),
a+b*2+c*3+d*4
FROM t1
WHERE (e>c OR e<d)
query IIIII rowsort
SELECT abs(b-c),
abs(a),
a+b*2+c*3+d*4+e*5,
a+b*2+c*3,
c-d
FROM t1
WHERE (e>c OR e<d)
OR coalesce(a,b,c,d,e)<>0
query IIIIIII rowsort
SELECT b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d,
b-c,
abs(b-c),
a+b*2+c*3+d*4
FROM t1
WHERE (a>b-2 AND a<b+2)
AND b IS NOT NULL
AND d NOT BETWEEN 110 AND 150
query IIIII rowsort
SELECT a+b*2,
abs(b-c),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (e>a AND e<b)
OR a IS NULL
query IIIIII rowsort
SELECT a,
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d-e,
d
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR d>e
query I rowsort
SELECT d
FROM t1
WHERE c>d
OR b>c
query IIIIIII rowsort
SELECT d-e,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c-d,
c,
a
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query IIIIII rowsort
SELECT e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2,
d-e,
abs(a),
a+b*2+c*3
FROM t1
WHERE b>c
OR a>b
query IIIIIII rowsort
SELECT a+b*2+c*3,
(a+b+c+d+e)/5,
b-c,
e,
abs(b-c),
c-d,
b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND (e>c OR e<d)
AND b>c
query IIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
c,
abs(a),
a+b*2+c*3+d*4,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND b>c
query III rowsort
SELECT a+b*2+c*3,
a+b*2+c*3+d*4+e*5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE d>e
AND coalesce(a,b,c,d,e)<>0
query IIIIII rowsort
SELECT e,
d-e,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a-b,
b-c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE d>e
OR c BETWEEN b-2 AND d+2
OR (e>a AND e<b)
query III rowsort
SELECT a+b*2+c*3,
a-b,
d-e
FROM t1
WHERE a IS NULL
OR b>c
OR c BETWEEN b-2 AND d+2
query I rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE (e>c OR e<d)
query III rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
e,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE d>e
OR e+d BETWEEN a+b-10 AND c+130
OR coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d,
a-b
FROM t1
query IIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a-b,
d-e,
c,
a+b*2
FROM t1
WHERE (a>b-2 AND a<b+2)
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT a-b,
a+b*2+c*3+d*4,
c-d,
b-c,
abs(a),
e
FROM t1
WHERE a IS NULL
query II rowsort
SELECT d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE d>e
OR e+d BETWEEN a+b-10 AND c+130
query III rowsort
SELECT b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2
FROM t1
query I rowsort
SELECT b
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND a IS NULL
query IIIII rowsort
SELECT c-d,
abs(a),
a+b*2+c*3,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
query IIIIII rowsort
SELECT abs(b-c),
a-b,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(a),
b-c
FROM t1
query III rowsort
SELECT d,
c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query I rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (e>a AND e<b)
query III rowsort
SELECT a+b*2+c*3,
abs(b-c),
a+b*2
FROM t1
WHERE c BETWEEN b-2 AND d+2
query I rowsort
SELECT d
FROM t1
WHERE (a>b-2 AND a<b+2)
query III rowsort
SELECT a+b*2+c*3+d*4,
c-d,
a+b*2+c*3
FROM t1
query IIIII rowsort
SELECT (a+b+c+d+e)/5,
abs(b-c),
a+b*2,
d-e,
a+b*2+c*3+d*4
FROM t1
WHERE c>d
query III rowsort
SELECT a-b,
abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE (a>b-2 AND a<b+2)
query I rowsort
SELECT (a+b+c+d+e)/5
FROM t1
query IIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(a+b+c+d+e)/5,
a
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR d>e
OR (a>b-2 AND a<b+2)
query I rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query IIIIIII rowsort
SELECT a+b*2+c*3,
abs(a),
c,
a+b*2+c*3+d*4,
e,
a,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE a IS NULL
AND coalesce(a,b,c,d,e)<>0
AND (c<=d-2 OR c>=d+2)
query IIIIII rowsort
SELECT c-d,
b-c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
c,
a+b*2+c*3+d*4+e*5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND (a>b-2 AND a<b+2)
AND d>e
query IIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
abs(a),
a-b,
a+b*2,
b,
c-d
FROM t1
WHERE a>b
AND c BETWEEN b-2 AND d+2
query IIIIII rowsort
SELECT c-d,
e,
a+b*2+c*3+d*4,
c,
a,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query IIIIIII rowsort
SELECT d,
d-e,
a+b*2+c*3+d*4+e*5,
abs(a),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2,
b
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR b>c
OR a>b
query IIIIII rowsort
SELECT d,
c,
a+b*2+c*3+d*4,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
abs(a),
e
FROM t1
query IIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
e,
d,
a+b*2+c*3+d*4
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR (e>a AND e<b)
OR b IS NOT NULL
query IIIII rowsort
SELECT d,
e,
a+b*2+c*3+d*4+e*5,
abs(a),
c-d
FROM t1
query IIII rowsort
SELECT b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
c,
d
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query IIIIIII rowsort
SELECT e,
a+b*2,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(a+b+c+d+e)/5,
a-b,
abs(a),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query II rowsort
SELECT c-d,
a+b*2+c*3+d*4
FROM t1
WHERE d>e
OR a IS NULL
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT e,
d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
(a+b+c+d+e)/5,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE b>c
AND d>e
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT d,
e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4+e*5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(b-c)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND c>d
query I rowsort
SELECT a+b*2+c*3
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(a+b+c+d+e)/5,
abs(a),
d-e,
b-c,
a
FROM t1
WHERE (a>b-2 AND a<b+2)
query III rowsort
SELECT b-c,
abs(b-c),
a-b
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(b-c),
c,
b,
a-b
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND c BETWEEN b-2 AND d+2
AND d>e
query IIII rowsort
SELECT abs(b-c),
a+b*2+c*3+d*4,
e,
b-c
FROM t1
WHERE a IS NULL
OR coalesce(a,b,c,d,e)<>0
OR b>c
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query II rowsort
SELECT c-d,
a-b
FROM t1
WHERE d>e
query IIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3,
c-d,
d-e,
a+b*2
FROM t1
WHERE d>e
OR (e>c OR e<d)
OR d NOT BETWEEN 110 AND 150
query IIIIIII rowsort
SELECT b,
a+b*2+c*3+d*4,
a+b*2,
d-e,
abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d
FROM t1
WHERE c>d
OR (c<=d-2 OR c>=d+2)
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3,
a
FROM t1
WHERE (e>c OR e<d)
AND d>e
query II rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4
FROM t1
query II rowsort
SELECT e,
c-d
FROM t1
query I rowsort
SELECT d
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR c>d
query I rowsort
SELECT abs(a)
FROM t1
query IIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a
FROM t1
WHERE (a>b-2 AND a<b+2)
AND d NOT BETWEEN 110 AND 150
AND d>e
query II rowsort
SELECT a,
a-b
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d-e,
a,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b,
abs(a)
FROM t1
query IIIIII rowsort
SELECT d-e,
b-c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(a),
e
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query IIIIII rowsort
SELECT abs(a),
b,
abs(b-c),
a+b*2+c*3,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2
FROM t1
WHERE (a>b-2 AND a<b+2)
query IIII rowsort
SELECT c-d,
a+b*2+c*3+d*4,
a,
b-c
FROM t1
query IIIIII rowsort
SELECT a+b*2,
abs(a),
b,
c,
d,
a+b*2+c*3
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND c BETWEEN b-2 AND d+2
AND b IS NOT NULL
query III rowsort
SELECT d-e,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4
FROM t1
query IIIII rowsort
SELECT e,
a-b,
b-c,
b,
(a+b+c+d+e)/5
FROM t1
WHERE a>b
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d-e,
c-d,
a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a
FROM t1
WHERE c BETWEEN b-2 AND d+2
query II rowsort
SELECT a+b*2,
abs(a)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query IIII rowsort
SELECT (a+b+c+d+e)/5,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(a)
FROM t1
WHERE a>b
query IIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(a+b+c+d+e)/5,
d-e,
a,
a+b*2+c*3
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
b,
a,
d-e,
e,
c
FROM t1
WHERE c>d
query IIIIIII rowsort
SELECT b,
c,
abs(b-c),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a-b,
e,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE (a>b-2 AND a<b+2)
OR b>c
query IIIII rowsort
SELECT (a+b+c+d+e)/5,
a+b*2+c*3+d*4,
abs(a),
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE a IS NULL
AND (e>c OR e<d)
query IIIIII rowsort
SELECT a,
c-d,
b,
a+b*2,
b-c,
a-b
FROM t1
WHERE b IS NOT NULL
AND b>c
query IIIIII rowsort
SELECT b-c,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b,
a,
abs(b-c)
FROM t1
query II rowsort
SELECT a+b*2,
e
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR d NOT BETWEEN 110 AND 150
query IIII rowsort
SELECT abs(a),
a+b*2+c*3+d*4,
d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query II rowsort
SELECT e,
abs(b-c)
FROM t1
query IIII rowsort
SELECT d-e,
a+b*2,
c-d,
e
FROM t1
query IIIII rowsort
SELECT c-d,
abs(b-c),
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d
FROM t1
WHERE b>c
OR c>d
OR d NOT BETWEEN 110 AND 150
query II rowsort
SELECT a+b*2+c*3,
(a+b+c+d+e)/5
FROM t1
WHERE (e>a AND e<b)
OR e+d BETWEEN a+b-10 AND c+130
query III rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE (e>c OR e<d)
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND (a>b-2 AND a<b+2)
query IIIII rowsort
SELECT a+b*2,
d-e,
d,
abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query IIIIII rowsort
SELECT b-c,
c,
a-b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
c-d,
abs(a)
FROM t1
query III rowsort
SELECT a+b*2+c*3+d*4+e*5,
c-d,
abs(b-c)
FROM t1
query IIII rowsort
SELECT a,
c-d,
b,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE a>b
AND (c<=d-2 OR c>=d+2)
AND b>c
query IIIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(a+b+c+d+e)/5,
abs(a),
abs(b-c),
c-d
FROM t1
query II rowsort
SELECT a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query I rowsort
SELECT b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND a>b
query IIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b-c
FROM t1
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
c-d
FROM t1
WHERE d>e
OR a IS NULL
query I rowsort
SELECT abs(b-c)
FROM t1
WHERE b IS NOT NULL
OR (c<=d-2 OR c>=d+2)
OR d>e
query III rowsort
SELECT a,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query II rowsort
SELECT a+b*2+c*3+d*4+e*5,
a
FROM t1
query IIIII rowsort
SELECT (a+b+c+d+e)/5,
a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a
FROM t1
query III rowsort
SELECT d,
c,
a-b
FROM t1
WHERE a IS NULL
query IIII rowsort
SELECT a,
c,
d-e,
d
FROM t1
query IIIII rowsort
SELECT b,
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
a+b*2+c*3+d*4
FROM t1
WHERE a IS NULL
AND (e>c OR e<d)
AND d NOT BETWEEN 110 AND 150
query II rowsort
SELECT abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query III rowsort
SELECT (a+b+c+d+e)/5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND b IS NOT NULL
AND (e>a AND e<b)
query III rowsort
SELECT b-c,
a-b,
d-e
FROM t1
WHERE b IS NOT NULL
AND (e>a AND e<b)
AND (c<=d-2 OR c>=d+2)
query IIIII rowsort
SELECT a,
b-c,
c-d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
e
FROM t1
WHERE d>e
AND c BETWEEN b-2 AND d+2
AND a>b
query IIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
c,
a+b*2,
a+b*2+c*3+d*4
FROM t1
query I rowsort
SELECT abs(b-c)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (e>c OR e<d)
query III rowsort
SELECT a+b*2,
c,
(a+b+c+d+e)/5
FROM t1
WHERE a>b
OR b>c
query IIII rowsort
SELECT a-b,
b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query I rowsort
SELECT abs(b-c)
FROM t1
WHERE a IS NULL
AND e+d BETWEEN a+b-10 AND c+130
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(b-c),
b
FROM t1
WHERE c>d
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIIII rowsort
SELECT abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4,
b-c,
d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE (e>c OR e<d)
AND coalesce(a,b,c,d,e)<>0
AND e+d BETWEEN a+b-10 AND c+130
query IIII rowsort
SELECT e,
a+b*2+c*3,
abs(b-c),
a+b*2+c*3+d*4
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (a>b-2 AND a<b+2)
query II rowsort
SELECT b-c,
a+b*2+c*3+d*4
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR (e>c OR e<d)
OR a IS NULL
query II rowsort
SELECT (a+b+c+d+e)/5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
query II rowsort
SELECT a+b*2+c*3,
b-c
FROM t1
WHERE (e>c OR e<d)
query IIII rowsort
SELECT e,
a+b*2+c*3+d*4+e*5,
d-e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE b>c
AND d NOT BETWEEN 110 AND 150
AND coalesce(a,b,c,d,e)<>0
query I rowsort
SELECT a+b*2
FROM t1
query I rowsort
SELECT d-e
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (c<=d-2 OR c>=d+2)
query I rowsort
SELECT (a+b+c+d+e)/5
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (e>a AND e<b)
AND b IS NOT NULL
query IIIII rowsort
SELECT abs(b-c),
c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
e,
b-c
FROM t1
WHERE (a>b-2 AND a<b+2)
AND coalesce(a,b,c,d,e)<>0
query II rowsort
SELECT a+b*2,
(a+b+c+d+e)/5
FROM t1
WHERE b IS NOT NULL
AND c>d
AND c BETWEEN b-2 AND d+2
query IIIIII rowsort
SELECT c,
a+b*2+c*3+d*4,
b,
abs(b-c),
(a+b+c+d+e)/5,
abs(a)
FROM t1
query II rowsort
SELECT c-d,
abs(a)
FROM t1
query IIII rowsort
SELECT a-b,
a+b*2+c*3+d*4,
c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND c>d
query IIIIIII rowsort
SELECT d-e,
(a+b+c+d+e)/5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
abs(b-c),
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE d>e
OR d NOT BETWEEN 110 AND 150
OR e+d BETWEEN a+b-10 AND c+130
query III rowsort
SELECT c,
b-c,
a+b*2+c*3
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR d NOT BETWEEN 110 AND 150
OR c BETWEEN b-2 AND d+2
query II rowsort
SELECT b,
(a+b+c+d+e)/5
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query IIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d-e,
a+b*2,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query II rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(a+b+c+d+e)/5
FROM t1
WHERE a IS NULL
OR (a>b-2 AND a<b+2)
query IIIIIII rowsort
SELECT a+b*2+c*3,
e,
c-d,
d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a,
a+b*2+c*3+d*4
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND b IS NOT NULL
query IIII rowsort
SELECT b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c-d
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND c BETWEEN b-2 AND d+2
query I rowsort
SELECT d-e
FROM t1
query II rowsort
SELECT abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE b IS NOT NULL
OR coalesce(a,b,c,d,e)<>0
OR a IS NULL
query IIIIII rowsort
SELECT d-e,
a+b*2+c*3+d*4+e*5,
b-c,
a,
d,
b
FROM t1
WHERE b IS NOT NULL
OR d NOT BETWEEN 110 AND 150
query IIIIIII rowsort
SELECT a,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b,
(a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b,
d
FROM t1
WHERE b>c
query II rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4+e*5
FROM t1
query IIIIII rowsort
SELECT a+b*2,
c,
d-e,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (c<=d-2 OR c>=d+2)
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR a IS NULL
OR (c<=d-2 OR c>=d+2)
query II rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query III rowsort
SELECT a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
e
FROM t1
query IIII rowsort
SELECT e,
d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4
FROM t1
WHERE d>e
OR c BETWEEN b-2 AND d+2
query I rowsort
SELECT c-d
FROM t1
WHERE a>b
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
b-c,
a,
abs(a)
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR e+d BETWEEN a+b-10 AND c+130
OR d>e
query IIIIIII rowsort
SELECT a+b*2,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b-c,
c-d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d-e,
(a+b+c+d+e)/5
FROM t1
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a
FROM t1
WHERE b>c
OR c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
e,
b-c,
d
FROM t1
WHERE (a>b-2 AND a<b+2)
OR d NOT BETWEEN 110 AND 150
query II rowsort
SELECT c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR d NOT BETWEEN 110 AND 150
query IIII rowsort
SELECT a,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE c>d
OR (e>c OR e<d)
OR (a>b-2 AND a<b+2)
query II rowsort
SELECT c,
e
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND d NOT BETWEEN 110 AND 150
query IIIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c-d,
abs(a),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b-c,
a-b,
b
FROM t1
WHERE a>b
OR (a>b-2 AND a<b+2)
OR d>e
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query II rowsort
SELECT d-e,
(a+b+c+d+e)/5
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND (c<=d-2 OR c>=d+2)
query III rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND d NOT BETWEEN 110 AND 150
query I rowsort
SELECT a+b*2+c*3+d*4
FROM t1
WHERE d>e
OR e+d BETWEEN a+b-10 AND c+130
query IIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
e,
a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query IIII rowsort
SELECT a+b*2+c*3+d*4,
c,
a+b*2+c*3+d*4+e*5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE b>c
AND (e>c OR e<d)
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE b>c
AND (e>c OR e<d)
AND coalesce(a,b,c,d,e)<>0
query IIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
e,
c-d,
b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a-b
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND d NOT BETWEEN 110 AND 150
AND b>c
query IIIIIII rowsort
SELECT e,
a+b*2+c*3,
a+b*2,
a,
abs(b-c),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b
FROM t1
WHERE b>c
query I rowsort
SELECT e
FROM t1
WHERE b>c
query II rowsort
SELECT abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a,
a-b,
a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE d>e
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a
FROM t1
query IIIII rowsort
SELECT c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(b-c),
a+b*2+c*3+d*4+e*5,
a
FROM t1
query IIIIII rowsort
SELECT a+b*2,
c-d,
e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b,
(a+b+c+d+e)/5
FROM t1
WHERE (e>c OR e<d)
query IIIIIII rowsort
SELECT b,
(a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
c,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d-e,
a-b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (c<=d-2 OR c>=d+2)
query III rowsort
SELECT c,
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query IIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
(a+b+c+d+e)/5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c-d
FROM t1
WHERE (e>c OR e<d)
AND b>c
query III rowsort
SELECT d-e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b
FROM t1
WHERE a>b
OR e+d BETWEEN a+b-10 AND c+130
OR (e>c OR e<d)
query III rowsort
SELECT a+b*2,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query II rowsort
SELECT b,
a-b
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND a>b
AND d>e
query I rowsort
SELECT b
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query III rowsort
SELECT abs(a),
abs(b-c),
a
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query IIIIIII rowsort
SELECT (a+b+c+d+e)/5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
b-c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4+e*5,
a+b*2,
a+b*2+c*3+d*4
FROM t1
query IIII rowsort
SELECT a+b*2,
a-b,
b,
d
FROM t1
WHERE d>e
OR d NOT BETWEEN 110 AND 150
OR (c<=d-2 OR c>=d+2)
query III rowsort
SELECT a+b*2+c*3+d*4+e*5,
a+b*2+c*3+d*4,
a+b*2+c*3
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (a>b-2 AND a<b+2)
query IIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(b-c),
d,
e,
d-e
FROM t1
query IIIII rowsort
SELECT a+b*2,
b-c,
c,
b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND c>d
AND b>c
query IIIIII rowsort
SELECT c-d,
a,
a+b*2,
abs(a),
(a+b+c+d+e)/5,
c
FROM t1
WHERE a IS NULL
OR (c<=d-2 OR c>=d+2)
OR b>c
query III rowsort
SELECT b-c,
a+b*2,
a+b*2+c*3
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR a IS NULL
OR d NOT BETWEEN 110 AND 150
query I rowsort
SELECT e
FROM t1
WHERE (e>a AND e<b)
OR (e>c OR e<d)
query II rowsort
SELECT a+b*2+c*3+d*4+e*5,
a-b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query II rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(a+b+c+d+e)/5
FROM t1
WHERE b IS NOT NULL
AND d NOT BETWEEN 110 AND 150
query I rowsort
SELECT a+b*2+c*3+d*4+e*5
FROM t1
query IIIIII rowsort
SELECT a-b,
c,
(a+b+c+d+e)/5,
b-c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR (c<=d-2 OR c>=d+2)
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c,
d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2,
c-d,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE a>b
OR d>e
query IIIII rowsort
SELECT a,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a-b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE a IS NULL
query IIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d-e,
a+b*2+c*3,
c-d,
(a+b+c+d+e)/5
FROM t1
query IIII rowsort
SELECT abs(a),
c,
abs(b-c),
b-c
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR c>d
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c,
abs(a)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND c>d
AND (c<=d-2 OR c>=d+2)
query IIIIII rowsort
SELECT a+b*2+c*3+d*4,
a+b*2+c*3+d*4+e*5,
b,
a-b,
a,
a+b*2+c*3
FROM t1
WHERE a IS NULL
OR b>c
query IIIIII rowsort
SELECT a+b*2+c*3+d*4,
a-b,
b-c,
b,
(a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
c,
a+b*2+c*3+d*4,
abs(b-c),
d-e
FROM t1
query III rowsort
SELECT abs(a),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c-d
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query I rowsort
SELECT d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND d NOT BETWEEN 110 AND 150
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query II rowsort
SELECT c-d,
abs(a)
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query II rowsort
SELECT abs(b-c),
c-d
FROM t1
WHERE b IS NOT NULL
query IIIIII rowsort
SELECT b,
c,
e,
abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query IIIII rowsort
SELECT a-b,
c,
b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3
FROM t1
query IIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c-d,
a+b*2+c*3+d*4+e*5,
d
FROM t1
query III rowsort
SELECT a-b,
(a+b+c+d+e)/5,
abs(a)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND b IS NOT NULL
AND (a>b-2 AND a<b+2)
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(a+b+c+d+e)/5
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query IIIII rowsort
SELECT a+b*2+c*3+d*4,
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(b-c),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE b IS NOT NULL
query II rowsort
SELECT a+b*2,
a-b
FROM t1
WHERE a>b
AND d>e
AND (a>b-2 AND a<b+2)
query IIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c-d
FROM t1
WHERE (e>a AND e<b)
OR coalesce(a,b,c,d,e)<>0
query IIIIII rowsort
SELECT d,
c-d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4,
(a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE c>d
AND b IS NOT NULL
AND a>b
query IIIIIII rowsort
SELECT a-b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
e,
(a+b+c+d+e)/5,
d-e
FROM t1
query IIII rowsort
SELECT a,
abs(a),
a+b*2+c*3+d*4+e*5,
a+b*2
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR c>d
query II rowsort
SELECT c,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query IIIII rowsort
SELECT b-c,
a+b*2+c*3+d*4,
b,
c-d,
a+b*2+c*3
FROM t1
WHERE d>e
AND c>d
AND coalesce(a,b,c,d,e)<>0
query IIIIII rowsort
SELECT b,
(a+b+c+d+e)/5,
a-b,
a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d-e
FROM t1
WHERE d>e
query IIIII rowsort
SELECT c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a,
a+b*2
FROM t1
WHERE a IS NULL
query I rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query III rowsort
SELECT a+b*2,
b-c,
c-d
FROM t1
query III rowsort
SELECT (a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query III rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d-e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE d>e
query III rowsort
SELECT a,
c-d,
abs(a)
FROM t1
WHERE d>e
query IIIII rowsort
SELECT abs(b-c),
a-b,
c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c
FROM t1
query IIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
d-e,
a+b*2+c*3
FROM t1
WHERE b>c
OR d NOT BETWEEN 110 AND 150
OR (a>b-2 AND a<b+2)
query I rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query IIIIIII rowsort
SELECT (a+b+c+d+e)/5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
b,
c-d,
d,
a+b*2+c*3+d*4,
a+b*2+c*3
FROM t1
query IIIIIII rowsort
SELECT a,
d-e,
e,
a+b*2+c*3,
abs(b-c),
c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (a>b-2 AND a<b+2)
OR c>d
query I rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
query IIIIIII rowsort
SELECT c-d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3+d*4,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a-b,
d-e
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query I rowsort
SELECT a+b*2+c*3
FROM t1
WHERE a IS NULL
query IIII rowsort
SELECT (a+b+c+d+e)/5,
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
c-d
FROM t1
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIIII rowsort
SELECT b,
d-e,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE a IS NULL
AND d>e
query IIII rowsort
SELECT e,
a+b*2,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4+e*5
FROM t1
query IIIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b,
e,
c-d,
b-c,
d
FROM t1
WHERE d>e
AND a>b
AND d NOT BETWEEN 110 AND 150
query IIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c,
(a+b+c+d+e)/5
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query II rowsort
SELECT c,
a-b
FROM t1
WHERE a>b
query IIIIIII rowsort
SELECT (a+b+c+d+e)/5,
abs(b-c),
c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a,
b,
abs(a)
FROM t1
WHERE c>d
OR c BETWEEN b-2 AND d+2
query II rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b
FROM t1
WHERE a IS NULL
query IIII rowsort
SELECT (a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4+e*5,
a
FROM t1
WHERE (a>b-2 AND a<b+2)
AND (c<=d-2 OR c>=d+2)
AND (e>a AND e<b)
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2,
a+b*2+c*3,
d-e,
(a+b+c+d+e)/5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE (e>a AND e<b)
OR b IS NOT NULL
query IIIIII rowsort
SELECT d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a,
c-d,
a-b,
(a+b+c+d+e)/5
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR a>b
OR c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT a-b,
c-d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d-e
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query III rowsort
SELECT c-d,
a+b*2,
d-e
FROM t1
WHERE c>d
query IIII rowsort
SELECT (a+b+c+d+e)/5,
abs(b-c),
a+b*2+c*3,
a+b*2+c*3+d*4
FROM t1
query II rowsort
SELECT a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE d>e
query I rowsort
SELECT a-b
FROM t1
WHERE (e>c OR e<d)
query II rowsort
SELECT d-e,
c-d
FROM t1
query IIIIII rowsort
SELECT c-d,
d,
abs(b-c),
d-e,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (e>c OR e<d)
query IIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4+e*5,
b,
abs(b-c),
abs(a)
FROM t1
WHERE b IS NOT NULL
OR (a>b-2 AND a<b+2)
OR (e>a AND e<b)
query IIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4,
e,
d
FROM t1
query IIIIIII rowsort
SELECT c-d,
abs(a),
a+b*2,
a+b*2+c*3+d*4,
d-e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query III rowsort
SELECT a,
a+b*2+c*3+d*4,
d
FROM t1
WHERE b IS NOT NULL
query IIIII rowsort
SELECT a+b*2+c*3+d*4,
(a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b,
abs(b-c)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND d>e
query IIIIIII rowsort
SELECT e,
abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR (c<=d-2 OR c>=d+2)
query IIIIIII rowsort
SELECT abs(b-c),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b,
c,
a
FROM t1
query IIIIIII rowsort
SELECT abs(b-c),
d-e,
a+b*2+c*3,
a+b*2+c*3+d*4+e*5,
a,
b,
abs(a)
FROM t1
WHERE c>d
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
d-e,
abs(b-c),
(a+b+c+d+e)/5
FROM t1
query IIIII rowsort
SELECT a+b*2+c*3+d*4,
d-e,
c-d,
abs(a),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND (c<=d-2 OR c>=d+2)
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3,
a,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(a+b+c+d+e)/5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE c>d
OR b>c
query IIIIII rowsort
SELECT b,
a+b*2,
b-c,
a,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d-e
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query I rowsort
SELECT a+b*2+c*3+d*4
FROM t1
WHERE (a>b-2 AND a<b+2)
query IIII rowsort
SELECT d-e,
b-c,
a-b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query I rowsort
SELECT b
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND d>e
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(b-c)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query I rowsort
SELECT a+b*2
FROM t1
WHERE (a>b-2 AND a<b+2)
query I rowsort
SELECT d-e
FROM t1
WHERE c>d
AND d NOT BETWEEN 110 AND 150
query II rowsort
SELECT (a+b+c+d+e)/5,
c-d
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND d NOT BETWEEN 110 AND 150
query I rowsort
SELECT a-b
FROM t1
WHERE b IS NOT NULL
AND c>d
query I rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE a>b
OR c>d
query IIIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
abs(a),
e,
a+b*2+c*3,
abs(b-c),
a-b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE (e>c OR e<d)
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT a+b*2+c*3+d*4,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b,
d,
c-d,
a+b*2
FROM t1
WHERE a>b
OR (c<=d-2 OR c>=d+2)
OR a IS NULL
query II rowsort
SELECT b-c,
a+b*2
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT (a+b+c+d+e)/5,
a,
b-c,
a+b*2,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c-d
FROM t1
WHERE d>e
OR c BETWEEN b-2 AND d+2
OR (e>a AND e<b)
query IIII rowsort
SELECT a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
e,
(a+b+c+d+e)/5
FROM t1
WHERE (e>a AND e<b)
OR a>b
query IIIIIII rowsort
SELECT b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d,
a-b,
a+b*2,
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE (e>a AND e<b)
query IIIII rowsort
SELECT c,
a+b*2+c*3,
(a+b+c+d+e)/5,
a-b,
d
FROM t1
WHERE (e>a AND e<b)
OR c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT abs(b-c),
d-e,
b,
c
FROM t1
query IIIII rowsort
SELECT abs(b-c),
c-d,
d-e,
e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE (a>b-2 AND a<b+2)
AND d>e
AND b IS NOT NULL
query IIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a,
abs(a),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND d NOT BETWEEN 110 AND 150
AND b IS NOT NULL
query IIIIII rowsort
SELECT a+b*2+c*3,
a+b*2+c*3+d*4+e*5,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
(a+b+c+d+e)/5
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query III rowsort
SELECT a+b*2+c*3+d*4+e*5,
a-b,
abs(a)
FROM t1
query II rowsort
SELECT a+b*2+c*3+d*4,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIII rowsort
SELECT a-b,
c,
abs(a),
a+b*2+c*3+d*4
FROM t1
query IIIIIII rowsort
SELECT a+b*2+c*3+d*4,
a+b*2,
b,
b-c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query IIII rowsort
SELECT b-c,
abs(b-c),
a+b*2+c*3+d*4+e*5,
d
FROM t1
WHERE d>e
query III rowsort
SELECT d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(b-c)
FROM t1
WHERE b>c
AND d>e
AND coalesce(a,b,c,d,e)<>0
query IIIIIII rowsort
SELECT d-e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4+e*5,
a+b*2+c*3,
abs(b-c),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
b
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR a IS NULL
OR d NOT BETWEEN 110 AND 150
query IIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c-d,
d-e,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query IIII rowsort
SELECT a+b*2+c*3+d*4,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4+e*5
FROM t1
WHERE (e>a AND e<b)
AND d NOT BETWEEN 110 AND 150
query IIII rowsort
SELECT d-e,
e,
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE (a>b-2 AND a<b+2)
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE (e>c OR e<d)
OR a IS NULL
query II rowsort
SELECT a+b*2+c*3,
abs(b-c)
FROM t1
query I rowsort
SELECT d
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c,
b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4+e*5,
(a+b+c+d+e)/5
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT b-c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE c>d
query IIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c,
a+b*2,
a+b*2+c*3
FROM t1
WHERE (e>c OR e<d)
query II rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3
FROM t1
WHERE a IS NULL
OR (c<=d-2 OR c>=d+2)
OR (e>a AND e<b)
query II rowsort
SELECT a+b*2+c*3+d*4+e*5,
a+b*2+c*3
FROM t1
query I rowsort
SELECT b
FROM t1
query IIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c-d,
a+b*2+c*3+d*4
FROM t1
WHERE a IS NULL
AND c>d
AND (e>a AND e<b)
query I rowsort
SELECT c-d
FROM t1
WHERE (e>c OR e<d)
AND d NOT BETWEEN 110 AND 150
query II rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c
FROM t1
WHERE a>b
OR a IS NULL
query III rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a,
c-d
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND b>c
query IIII rowsort
SELECT e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a,
(a+b+c+d+e)/5
FROM t1
WHERE d>e
query IIIIIII rowsort
SELECT a-b,
(a+b+c+d+e)/5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2,
b
FROM t1
WHERE c BETWEEN b-2 AND d+2
query IIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2,
b,
d-e
FROM t1
WHERE b IS NOT NULL
query IIIII rowsort
SELECT e,
a+b*2+c*3,
a+b*2+c*3+d*4,
b-c,
d-e
FROM t1
query IIIII rowsort
SELECT c,
abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c-d,
a+b*2
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR c>d
OR a IS NULL
query II rowsort
SELECT b-c,
abs(a)
FROM t1
query IIIII rowsort
SELECT d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(b-c),
a-b,
a
FROM t1
WHERE b>c
OR d NOT BETWEEN 110 AND 150
query II rowsort
SELECT a,
c
FROM t1
WHERE d>e
AND b>c
query I rowsort
SELECT b-c
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR c BETWEEN b-2 AND d+2
OR (c<=d-2 OR c>=d+2)
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT a+b*2+c*3+d*4,
a-b,
a+b*2+c*3,
e
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR c BETWEEN b-2 AND d+2
query IIIIIII rowsort
SELECT d-e,
a+b*2+c*3+d*4,
a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d,
abs(b-c)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR (e>c OR e<d)
query III rowsort
SELECT (a+b+c+d+e)/5,
d,
c
FROM t1
WHERE b>c
query II rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2
FROM t1
query IIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4+e*5,
d,
e
FROM t1
WHERE a IS NULL
query I rowsort
SELECT a+b*2+c*3+d*4
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR a IS NULL
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query I rowsort
SELECT abs(a)
FROM t1
WHERE d>e
AND a IS NULL
query IIIII rowsort
SELECT a+b*2+c*3,
a+b*2+c*3+d*4,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
abs(a)
FROM t1
query IIIII rowsort
SELECT b-c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c-d,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query I rowsort
SELECT a+b*2+c*3+d*4
FROM t1
query IIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(a),
a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b,
d
FROM t1
WHERE (e>a AND e<b)
OR (a>b-2 AND a<b+2)
OR c BETWEEN b-2 AND d+2
query IIIIIII rowsort
SELECT d-e,
(a+b+c+d+e)/5,
b,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(a),
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query I rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query III rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
b-c,
a+b*2+c*3
FROM t1
query III rowsort
SELECT c-d,
c,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query II rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(a+b+c+d+e)/5
FROM t1
WHERE b>c
query I rowsort
SELECT a+b*2+c*3
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR coalesce(a,b,c,d,e)<>0
OR (e>c OR e<d)
query III rowsort
SELECT a+b*2,
abs(b-c),
a
FROM t1
WHERE a IS NULL
AND (e>c OR e<d)
AND c>d
query IIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c,
a+b*2+c*3,
d,
d-e
FROM t1
WHERE (e>a AND e<b)
query I rowsort
SELECT d-e
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND b>c
query II rowsort
SELECT abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT a+b*2+c*3+d*4,
a,
b,
abs(b-c)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query I rowsort
SELECT a
FROM t1
query I rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE b IS NOT NULL
OR c BETWEEN b-2 AND d+2
OR (e>c OR e<d)
query III rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3,
a+b*2
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND a>b
AND b IS NOT NULL
query IIIIIII rowsort
SELECT a-b,
a+b*2+c*3,
c-d,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c
FROM t1
query I rowsort
SELECT c
FROM t1
WHERE a IS NULL
AND (c<=d-2 OR c>=d+2)
AND c>d
query IIIIII rowsort
SELECT e,
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d-e,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR e+d BETWEEN a+b-10 AND c+130
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query III rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b,
d
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT c-d,
a+b*2+c*3+d*4+e*5,
b,
d
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND b IS NOT NULL
query I rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
query III rowsort
SELECT c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE b>c
query IIIII rowsort
SELECT a+b*2+c*3+d*4,
a,
abs(b-c),
d-e,
a+b*2
FROM t1
WHERE b IS NOT NULL
AND a>b
AND c BETWEEN b-2 AND d+2
query I rowsort
SELECT a+b*2+c*3
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR d>e
query IIIIII rowsort
SELECT c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3+d*4,
a+b*2,
c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR coalesce(a,b,c,d,e)<>0
query I rowsort
SELECT a+b*2
FROM t1
WHERE (e>a AND e<b)
OR (a>b-2 AND a<b+2)
query II rowsort
SELECT a+b*2+c*3+d*4+e*5,
e
FROM t1
WHERE (e>a AND e<b)
AND (e>c OR e<d)
query II rowsort
SELECT d-e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c>d
OR (c<=d-2 OR c>=d+2)
OR e+d BETWEEN a+b-10 AND c+130
query III rowsort
SELECT (a+b+c+d+e)/5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b
FROM t1
query IIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4
FROM t1
WHERE a IS NULL
AND b IS NOT NULL
AND c BETWEEN b-2 AND d+2
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c,
c-d,
a+b*2+c*3,
abs(b-c)
FROM t1
WHERE (e>a AND e<b)
query IIIII rowsort
SELECT b-c,
a+b*2,
b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE (e>c OR e<d)
query II rowsort
SELECT c,
a+b*2+c*3+d*4
FROM t1
WHERE d>e
AND b IS NOT NULL
AND (e>a AND e<b)
query I rowsort
SELECT a+b*2+c*3+d*4
FROM t1
query II rowsort
SELECT d-e,
b
FROM t1
WHERE a>b
query IIIIII rowsort
SELECT d-e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE a>b
OR b>c
OR c BETWEEN b-2 AND d+2
query I rowsort
SELECT a-b
FROM t1
query IIII rowsort
SELECT c-d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d-e,
(a+b+c+d+e)/5
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND b>c
AND a IS NULL
query III rowsort
SELECT abs(b-c),
c,
a+b*2+c*3+d*4+e*5
FROM t1
query II rowsort
SELECT abs(a),
d
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND d NOT BETWEEN 110 AND 150
AND c>d
query IIIII rowsort
SELECT d-e,
c-d,
a+b*2+c*3+d*4+e*5,
a+b*2+c*3+d*4,
a
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query IIIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3,
b-c,
e,
a-b
FROM t1
query II rowsort
SELECT c-d,
d
FROM t1
WHERE (a>b-2 AND a<b+2)
AND b>c
query II rowsort
SELECT a+b*2+c*3+d*4+e*5,
abs(a)
FROM t1
WHERE a>b
OR (e>c OR e<d)
query III rowsort
SELECT d,
(a+b+c+d+e)/5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query III rowsort
SELECT abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (e>c OR e<d)
AND (a>b-2 AND a<b+2)
query IIIIII rowsort
SELECT d,
b-c,
a-b,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a,
a+b*2
FROM t1
WHERE c BETWEEN b-2 AND d+2
query IIIIIII rowsort
SELECT a+b*2,
d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a,
a+b*2+c*3+d*4
FROM t1
query III rowsort
SELECT abs(a),
a+b*2+c*3,
d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (a>b-2 AND a<b+2)
query IIIIIII rowsort
SELECT a,
a+b*2,
a+b*2+c*3,
b,
abs(b-c),
c-d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query I rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE (e>a AND e<b)
OR c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c-d,
a-b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query II rowsort
SELECT a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (a>b-2 AND a<b+2)
OR a>b
query IIIII rowsort
SELECT abs(a),
a+b*2,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4
FROM t1
query I rowsort
SELECT c-d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIIII rowsort
SELECT b,
b-c,
a+b*2+c*3+d*4+e*5,
abs(a),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE b IS NOT NULL
AND coalesce(a,b,c,d,e)<>0
query I rowsort
SELECT e
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR b IS NOT NULL
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a,
a+b*2+c*3,
c-d,
e,
a+b*2+c*3+d*4+e*5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT abs(a),
a-b,
a+b*2+c*3+d*4,
a+b*2
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a,
(a+b+c+d+e)/5,
a+b*2+c*3+d*4+e*5,
a-b
FROM t1
WHERE a>b
OR d NOT BETWEEN 110 AND 150
query III rowsort
SELECT abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a
FROM t1
WHERE (e>a AND e<b)
OR (e>c OR e<d)
query IIIIII rowsort
SELECT d,
b,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a-b,
(a+b+c+d+e)/5
FROM t1
WHERE b>c
OR d>e
query IIIII rowsort
SELECT e,
b-c,
abs(b-c),
c,
c-d
FROM t1
WHERE a>b
query IIIIIII rowsort
SELECT b,
a-b,
d,
a+b*2,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c,
a+b*2+c*3
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query IIIIII rowsort
SELECT d-e,
a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2,
abs(b-c),
c-d
FROM t1
WHERE (e>a AND e<b)
OR a IS NULL
OR c>d
query I rowsort
SELECT a+b*2
FROM t1
WHERE c>d
OR a>b
OR d>e
query IIII rowsort
SELECT c-d,
b-c,
e,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE d>e
query I rowsort
SELECT e
FROM t1
WHERE a>b
OR coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT a+b*2+c*3+d*4,
a+b*2+c*3,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND a>b
AND e+d BETWEEN a+b-10 AND c+130
query I rowsort
SELECT c
FROM t1
WHERE c>d
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR (c<=d-2 OR c>=d+2)
query IIIIII rowsort
SELECT e,
a+b*2+c*3+d*4+e*5,
(a+b+c+d+e)/5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a,
b-c
FROM t1
WHERE a>b
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND d>e
query IIII rowsort
SELECT e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(b-c),
a-b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND (c<=d-2 OR c>=d+2)
AND (e>a AND e<b)
query III rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(b-c),
abs(a)
FROM t1
WHERE a>b
OR c>d
query IIIIII rowsort
SELECT c,
b,
abs(b-c),
e,
d-e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query III rowsort
SELECT c-d,
d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (a>b-2 AND a<b+2)
AND d NOT BETWEEN 110 AND 150
query III rowsort
SELECT a-b,
a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE (e>c OR e<d)
OR d NOT BETWEEN 110 AND 150
OR (e>a AND e<b)
query III rowsort
SELECT (a+b+c+d+e)/5,
c,
a+b*2
FROM t1
query IIIII rowsort
SELECT a+b*2+c*3+d*4,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a-b,
abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR e+d BETWEEN a+b-10 AND c+130
query II rowsort
SELECT a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE b IS NOT NULL
query IIIIIII rowsort
SELECT a,
e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(a),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(a+b+c+d+e)/5
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR e+d BETWEEN a+b-10 AND c+130
query IIIII rowsort
SELECT d-e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2,
abs(b-c),
a+b*2+c*3+d*4
FROM t1
WHERE (a>b-2 AND a<b+2)
OR (e>c OR e<d)
OR b>c
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c,
d,
b-c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4
FROM t1
WHERE d>e
OR b IS NOT NULL
OR d NOT BETWEEN 110 AND 150
query III rowsort
SELECT a+b*2+c*3+d*4+e*5,
c-d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND (c<=d-2 OR c>=d+2)
query IIII rowsort
SELECT (a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2,
b
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR b IS NOT NULL
query IIII rowsort
SELECT c,
a+b*2+c*3+d*4+e*5,
b,
a+b*2
FROM t1
query IIIIII rowsort
SELECT b-c,
b,
a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c,
d-e
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query IIIII rowsort
SELECT a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(a+b+c+d+e)/5,
a+b*2+c*3+d*4,
abs(b-c)
FROM t1
WHERE a IS NULL
AND coalesce(a,b,c,d,e)<>0
query IIIIII rowsort
SELECT b,
b-c,
e,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a
FROM t1
WHERE a IS NULL
OR (c<=d-2 OR c>=d+2)
query II rowsort
SELECT a-b,
d-e
FROM t1
query I rowsort
SELECT a+b*2+c*3+d*4+e*5
FROM t1
WHERE (a>b-2 AND a<b+2)
query IIIII rowsort
SELECT d-e,
a,
b-c,
e,
d
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query II rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2
FROM t1
WHERE d>e
OR (c<=d-2 OR c>=d+2)
query IIIIIII rowsort
SELECT a-b,
a+b*2+c*3,
abs(b-c),
d,
(a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE b IS NOT NULL
query I rowsort
SELECT a+b*2+c*3+d*4
FROM t1
WHERE (e>c OR e<d)
AND (a>b-2 AND a<b+2)
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(a+b+c+d+e)/5,
abs(b-c),
a+b*2
FROM t1
WHERE a>b
query I rowsort
SELECT abs(a)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND coalesce(a,b,c,d,e)<>0
AND a IS NULL
query IIIIIII rowsort
SELECT a+b*2+c*3+d*4,
c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(a+b+c+d+e)/5,
b
FROM t1
WHERE c>d
query IIII rowsort
SELECT a+b*2,
a-b,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR d NOT BETWEEN 110 AND 150
query IIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
b-c,
a+b*2+c*3+d*4,
d-e,
a+b*2+c*3
FROM t1
WHERE a>b
AND c BETWEEN b-2 AND d+2
query IIII rowsort
SELECT a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c-d,
b
FROM t1
query III rowsort
SELECT c-d,
abs(b-c),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND a>b
query II rowsort
SELECT b,
a
FROM t1
WHERE (a>b-2 AND a<b+2)
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2,
a,
b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
d-e
FROM t1
WHERE b>c
OR (e>a AND e<b)
query IIIII rowsort
SELECT (a+b+c+d+e)/5,
abs(a),
d-e,
e,
b
FROM t1
query IIIII rowsort
SELECT d,
abs(a),
c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
e
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND a>b
AND (e>c OR e<d)
query IIIIIII rowsort
SELECT d-e,
a+b*2,
b-c,
abs(b-c),
c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3
FROM t1
WHERE b>c
query I rowsort
SELECT a+b*2+c*3
FROM t1
WHERE b IS NOT NULL
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query II rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c-d
FROM t1
query IIIIIII rowsort
SELECT abs(a),
b-c,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(a+b+c+d+e)/5,
a-b,
c,
c-d
FROM t1
WHERE a>b
AND (a>b-2 AND a<b+2)
AND c>d
query III rowsort
SELECT (a+b+c+d+e)/5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d-e
FROM t1
query IIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
e,
a
FROM t1
query III rowsort
SELECT b-c,
e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR c>d
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3,
a+b*2,
a,
a-b,
b,
e
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query IIIIIII rowsort
SELECT a+b*2+c*3,
a+b*2+c*3+d*4,
a+b*2,
d-e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND b IS NOT NULL
query IIIIII rowsort
SELECT d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c,
a+b*2+c*3,
b
FROM t1
WHERE b>c
OR c>d
query IIIIII rowsort
SELECT e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
abs(b-c),
d
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND b>c
AND d>e
query I rowsort
SELECT a+b*2
FROM t1
WHERE a>b
AND coalesce(a,b,c,d,e)<>0
AND a IS NULL
query IIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a,
e,
a+b*2+c*3
FROM t1
WHERE (a>b-2 AND a<b+2)
query IIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
e,
a+b*2+c*3+d*4+e*5,
a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR coalesce(a,b,c,d,e)<>0
OR (a>b-2 AND a<b+2)
query II rowsort
SELECT c-d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query II rowsort
SELECT c-d,
b-c
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND b>c
query IIIIIII rowsort
SELECT b,
a+b*2+c*3,
(a+b+c+d+e)/5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2+c*3+d*4,
a+b*2,
c
FROM t1
WHERE d>e
query IIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b,
c-d
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR b IS NOT NULL
query IIIII rowsort
SELECT b-c,
abs(b-c),
d-e,
a+b*2,
c-d
FROM t1
WHERE a>b
AND (e>a AND e<b)
query II rowsort
SELECT c-d,
b
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR a IS NULL
query I rowsort
SELECT b
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query I rowsort
SELECT abs(a)
FROM t1
WHERE b IS NOT NULL
OR a>b
query IIIIIII rowsort
SELECT c,
b-c,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3,
a,
c-d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND b IS NOT NULL
query IIIIII rowsort
SELECT a+b*2+c*3+d*4,
abs(b-c),
b-c,
d-e,
a+b*2,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR b>c
OR c BETWEEN b-2 AND d+2
query IIIII rowsort
SELECT c-d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a-b,
c,
a+b*2+c*3+d*4
FROM t1
query IIIII rowsort
SELECT d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4+e*5,
c-d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
query IIIII rowsort
SELECT b,
a+b*2+c*3+d*4,
c,
a+b*2,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query I rowsort
SELECT (a+b+c+d+e)/5
FROM t1
WHERE b IS NOT NULL
AND b>c
query I rowsort
SELECT d-e
FROM t1
WHERE (e>a AND e<b)
query IIIII rowsort
SELECT a+b*2+c*3,
c,
a,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a-b
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND (a>b-2 AND a<b+2)
query IIIIIII rowsort
SELECT e,
c-d,
(a+b+c+d+e)/5,
a+b*2,
b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
c
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND (a>b-2 AND a<b+2)
query III rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a-b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR a>b
query I rowsort
SELECT a+b*2+c*3+d*4
FROM t1
query IIIII rowsort
SELECT c-d,
a,
b,
d,
b-c
FROM t1
query IIIII rowsort
SELECT a,
c,
a+b*2+c*3,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (c<=d-2 OR c>=d+2)
query IIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
(a+b+c+d+e)/5,
abs(a)
FROM t1
WHERE b IS NOT NULL
AND (a>b-2 AND a<b+2)
query IIIII rowsort
SELECT a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND e+d BETWEEN a+b-10 AND c+130
query IIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
abs(a),
c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR (c<=d-2 OR c>=d+2)
query IIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4,
c,
d,
b
FROM t1
WHERE b IS NOT NULL
AND c BETWEEN b-2 AND d+2
query IIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3,
d,
abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
b-c
FROM t1
WHERE a IS NULL
query IIIIIII rowsort
SELECT a+b*2+c*3+d*4,
a-b,
(a+b+c+d+e)/5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b-c,
a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query I rowsort
SELECT abs(a)
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR a IS NULL
query IIII rowsort
SELECT abs(a),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c,
e
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIII rowsort
SELECT (a+b+c+d+e)/5,
a+b*2+c*3,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query IIIII rowsort
SELECT abs(a),
(a+b+c+d+e)/5,
a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b
FROM t1
WHERE (a>b-2 AND a<b+2)
AND c BETWEEN b-2 AND d+2
AND b>c
query IIII rowsort
SELECT b-c,
a+b*2,
d,
abs(b-c)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND b>c
AND (c<=d-2 OR c>=d+2)
query IIIII rowsort
SELECT d-e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(a),
a+b*2+c*3+d*4+e*5,
b-c
FROM t1
WHERE b>c
query I rowsort
SELECT b-c
FROM t1
WHERE c>d
OR d>e
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIII rowsort
SELECT c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2,
a-b
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR e+d BETWEEN a+b-10 AND c+130
query IIIII rowsort
SELECT abs(b-c),
d,
a+b*2+c*3+d*4+e*5,
b,
a
FROM t1
WHERE (c<=d-2 OR c>=d+2)
query IIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a,
a-b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE a IS NULL
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query II rowsort
SELECT (a+b+c+d+e)/5,
a+b*2+c*3
FROM t1
query IIIII rowsort
SELECT b,
abs(a),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(b-c),
d-e
FROM t1
WHERE (e>a AND e<b)
OR d>e
query IIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
c-d,
e,
abs(a),
a+b*2+c*3,
abs(b-c)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND (e>a AND e<b)
query III rowsort
SELECT d-e,
a+b*2+c*3+d*4+e*5,
a
FROM t1
WHERE (e>c OR e<d)
AND a IS NULL
AND a>b
query IIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2,
c-d,
b-c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query IIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2,
a+b*2+c*3+d*4+e*5,
(a+b+c+d+e)/5,
d-e,
abs(b-c)
FROM t1
WHERE b IS NOT NULL
query I rowsort
SELECT abs(b-c)
FROM t1
query I rowsort
SELECT b-c
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query III rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR c>d
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c,
a,
a+b*2+c*3+d*4+e*5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (e>c OR e<d)
AND a IS NULL
query IIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(a+b+c+d+e)/5,
a+b*2+c*3+d*4+e*5,
b
FROM t1
WHERE c>d
query II rowsort
SELECT d-e,
a+b*2+c*3+d*4
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR (e>c OR e<d)
OR b>c
query IIIIIII rowsort
SELECT abs(b-c),
a-b,
d-e,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4,
a
FROM t1
WHERE c>d
OR b>c
query IIIIII rowsort
SELECT b,
a-b,
a+b*2+c*3+d*4+e*5,
a+b*2+c*3,
c,
c-d
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query IIII rowsort
SELECT a,
a+b*2,
a-b,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR a IS NULL
OR d>e
query IIIIII rowsort
SELECT a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2+c*3+d*4,
b,
b-c,
d-e
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query IIIIIII rowsort
SELECT abs(a),
(a+b+c+d+e)/5,
c,
d-e,
a+b*2,
e,
b
FROM t1
WHERE a>b
query III rowsort
SELECT a-b,
abs(b-c),
a+b*2+c*3
FROM t1
WHERE (a>b-2 AND a<b+2)
OR (e>a AND e<b)
OR c>d
query III rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(a+b+c+d+e)/5,
a+b*2+c*3+d*4+e*5
FROM t1
query IIIII rowsort
SELECT a+b*2,
e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
b,
c-d
FROM t1
query III rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
(a+b+c+d+e)/5,
b
FROM t1
query II rowsort
SELECT d,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR coalesce(a,b,c,d,e)<>0
query IIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
(a+b+c+d+e)/5,
a+b*2+c*3+d*4
FROM t1
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d,
b
FROM t1
query I rowsort
SELECT d
FROM t1
query IIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
c-d,
a,
b-c,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query I rowsort
SELECT a+b*2+c*3+d*4+e*5
FROM t1
WHERE a>b
query III rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND d>e
query III rowsort
SELECT c,
b-c,
a+b*2+c*3
FROM t1
WHERE b>c
AND coalesce(a,b,c,d,e)<>0
query I rowsort
SELECT a
FROM t1
WHERE a IS NULL
OR b IS NOT NULL
query IIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a-b,
b-c,
c-d,
abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND d>e
AND a>b
query II rowsort
SELECT b,
(a+b+c+d+e)/5
FROM t1
WHERE a>b
query I rowsort
SELECT (a+b+c+d+e)/5
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query IIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a-b,
c
FROM t1
query I rowsort
SELECT a-b
FROM t1
WHERE a>b
AND c BETWEEN b-2 AND d+2
AND (e>c OR e<d)
query IIIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c-d,
b,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(b-c),
a-b
FROM t1
WHERE d>e
OR (a>b-2 AND a<b+2)
query III rowsort
SELECT a+b*2+c*3+d*4,
e,
a+b*2+c*3
FROM t1
WHERE a>b
query III rowsort
SELECT b,
d,
b-c
FROM t1
WHERE a IS NULL
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3,
a+b*2+c*3+d*4,
a-b,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(b-c),
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (c<=d-2 OR c>=d+2)
query I rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (a>b-2 AND a<b+2)
AND (e>c OR e<d)
query IIIIIII rowsort
SELECT c-d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
(a+b+c+d+e)/5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
c,
a,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE (e>a AND e<b)
OR b>c
OR (c<=d-2 OR c>=d+2)
query I rowsort
SELECT d-e
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND e+d BETWEEN a+b-10 AND c+130
AND a IS NULL
query IIIIIII rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4,
a+b*2+c*3+d*4+e*5,
a,
(a+b+c+d+e)/5,
e,
d
FROM t1
query I rowsort
SELECT a
FROM t1
query I rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c>d
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR (a>b-2 AND a<b+2)
query IIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c,
b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR b IS NOT NULL
query III rowsort
SELECT d,
c-d,
a+b*2
FROM t1
WHERE (e>c OR e<d)
OR d>e
OR a>b
query IIIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
c,
abs(a),
a+b*2+c*3+d*4,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a-b
FROM t1
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
e,
a+b*2+c*3+d*4+e*5,
a+b*2+c*3,
a-b,
b-c,
d
FROM t1
WHERE b>c
query IIIII rowsort
SELECT a+b*2,
abs(b-c),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d,
(a+b+c+d+e)/5
FROM t1
query II rowsort
SELECT a,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (e>c OR e<d)
AND (a>b-2 AND a<b+2)
query IIIIIII rowsort
SELECT e,
b-c,
a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
d-e,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(a+b+c+d+e)/5
FROM t1
WHERE a>b
AND e+d BETWEEN a+b-10 AND c+130
AND d>e
query II rowsort
SELECT d,
b-c
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND d>e
query IIIIIII rowsort
SELECT b-c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c,
a+b*2,
d-e,
a+b*2+c*3+d*4,
c-d
FROM t1
WHERE a IS NULL
AND c>d
query III rowsort
SELECT b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a+b*2
FROM t1
query IIIIII rowsort
SELECT e,
b-c,
abs(b-c),
abs(a),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
d
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (e>a AND e<b)
query IIIII rowsort
SELECT d,
c-d,
abs(b-c),
b-c,
a+b*2+c*3
FROM t1
WHERE b>c
query IIIIII rowsort
SELECT a-b,
a,
a+b*2+c*3,
abs(a),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b-c
FROM t1
WHERE b IS NOT NULL
AND (e>c OR e<d)
AND c>d
query IIIIIII rowsort
SELECT abs(b-c),
e,
a+b*2,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(a),
c-d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query IIIIIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d,
e,
c-d,
a,
abs(a),
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query IIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
a+b*2+c*3,
b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(b-c),
(a+b+c+d+e)/5
FROM t1
query IIII rowsort
SELECT b,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(b-c),
a+b*2+c*3
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT abs(a),
c,
(a+b+c+d+e)/5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE a IS NULL
query IIIIIII rowsort
SELECT abs(b-c),
d,
a+b*2+c*3+d*4+e*5,
a-b,
c-d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(a+b+c+d+e)/5
FROM t1
WHERE d>e
query IIIII rowsort
SELECT c,
a-b,
a+b*2+c*3+d*4+e*5,
e,
abs(a)
FROM t1
query IIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b,
c,
a+b*2
FROM t1
query IIII rowsort
SELECT a-b,
b-c,
a+b*2,
c-d
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR d NOT BETWEEN 110 AND 150
query IIII rowsort
SELECT a+b*2+c*3,
a+b*2,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
d-e
FROM t1
WHERE (e>c OR e<d)
query II rowsort
SELECT (a+b+c+d+e)/5,
c-d
FROM t1
WHERE d>e
AND c>d
AND a IS NULL
query IIII rowsort
SELECT b,
a-b,
d-e,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE c BETWEEN b-2 AND d+2
query IIIII rowsort
SELECT a+b*2+c*3+d*4,
b,
a,
e,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR b>c
query IIIIIII rowsort
SELECT b-c,
a,
(a+b+c+d+e)/5,
c-d,
a+b*2+c*3,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR d NOT BETWEEN 110 AND 150
OR (e>c OR e<d)
query IIIIII rowsort
SELECT a-b,
c-d,
(a+b+c+d+e)/5,
a+b*2+c*3+d*4+e*5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d
FROM t1
query III rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4+e*5,
a+b*2+c*3+d*4
FROM t1
query I rowsort
SELECT c
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR c>d
OR a>b
query III rowsort
SELECT a+b*2+c*3+d*4,
b,
abs(a)
FROM t1
query I rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE b>c
AND c>d
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d,
(a+b+c+d+e)/5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE b>c
query IIIII rowsort
SELECT (a+b+c+d+e)/5,
d-e,
a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE (a>b-2 AND a<b+2)
OR d>e
OR b>c
query III rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3+d*4,
a+b*2
FROM t1
WHERE b>c
query I rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (e>c OR e<d)
OR b>c
OR e+d BETWEEN a+b-10 AND c+130
query III rowsort
SELECT d-e,
a,
d
FROM t1
WHERE (e>c OR e<d)
AND a IS NULL
query IIIII rowsort
SELECT a,
(a+b+c+d+e)/5,
b-c,
a+b*2,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE (e>c OR e<d)
query III rowsort
SELECT abs(a),
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
e
FROM t1
WHERE b IS NOT NULL
query IIIII rowsort
SELECT d-e,
a-b,
c,
c-d,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query IIIIII rowsort
SELECT abs(b-c),
a+b*2+c*3,
a+b*2+c*3+d*4,
abs(a),
a,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query III rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
query IIII rowsort
SELECT a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
(a+b+c+d+e)/5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(a),
a+b*2+c*3+d*4,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b-c
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND c>d
query IIIII rowsort
SELECT d-e,
a,
a+b*2+c*3+d*4+e*5,
abs(a),
b
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND c>d
AND d NOT BETWEEN 110 AND 150
query III rowsort
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND c>d
query II rowsort
SELECT c-d,
e
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIIII rowsort
SELECT a+b*2+c*3+d*4,
d-e,
abs(a),
a+b*2,
c
FROM t1
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR (c<=d-2 OR c>=d+2)
query IIIIII rowsort
SELECT a-b,
a+b*2+c*3+d*4+e*5,
a+b*2,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
c-d,
b-c
FROM t1
query IIII rowsort
SELECT abs(a),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(a+b+c+d+e)/5
FROM t1
WHERE (e>c OR e<d)
AND a IS NULL
AND e+d BETWEEN a+b-10 AND c+130
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
query IIIIIII rowsort
SELECT a+b*2+c*3,
c-d,
a+b*2+c*3+d*4+e*5,
a+b*2,
abs(a),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
e
FROM t1
query III rowsort
SELECT abs(a),
c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE (e>c OR e<d)
OR c>d
query IIIII rowsort
SELECT d,
b-c,
c-d,
a+b*2+c*3+d*4,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (e>c OR e<d)
query IIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
b,
abs(a),
a+b*2+c*3+d*4
FROM t1
WHERE b>c
AND (e>a AND e<b)
AND b IS NOT NULL
query II rowsort
SELECT a+b*2,
abs(a)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND a IS NULL
query IIII rowsort
SELECT c-d,
abs(b-c),
a-b,
a
FROM t1
query IIIIII rowsort
SELECT a,
a+b*2+c*3+d*4+e*5,
e,
a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(b-c)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIIIIII rowsort
SELECT abs(b-c),
d,
abs(a),
a-b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c-d,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE b>c
OR c>d
query IIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
e,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
query IIII rowsort
SELECT a,
a+b*2+c*3+d*4,
c,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE a>b
AND c>d
AND b IS NOT NULL
query I rowsort
SELECT c
FROM t1
WHERE (e>a AND e<b)
query II rowsort
SELECT (a+b+c+d+e)/5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND d>e
AND c>d
query I rowsort
SELECT b-c
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND d NOT BETWEEN 110 AND 150
AND a>b
query IIIII rowsort
SELECT e,
a-b,
b-c,
d-e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE a IS NULL
OR (e>a AND e<b)
query IIIII rowsort
SELECT a+b*2,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
c-d,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR c BETWEEN b-2 AND d+2
query III rowsort
SELECT d-e,
a-b,
b-c
FROM t1
query I rowsort
SELECT c
FROM t1
WHERE b>c
OR b IS NOT NULL
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
e,
d-e,
a-b,
a+b*2+c*3,
a
FROM t1
WHERE c>d
OR d>e
query III rowsort
SELECT a+b*2+c*3,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE (a>b-2 AND a<b+2)
OR c>d
query IIIIIII rowsort
SELECT c,
a+b*2+c*3,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b,
d
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR d NOT BETWEEN 110 AND 150
query IIIII rowsort
SELECT a+b*2+c*3+d*4,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(b-c),
e,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE (e>c OR e<d)
query III rowsort
SELECT (a+b+c+d+e)/5,
d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR c BETWEEN b-2 AND d+2
OR a>b
query IIII rowsort
SELECT a+b*2+c*3+d*4,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
(a+b+c+d+e)/5,
e
FROM t1
WHERE (a>b-2 AND a<b+2)
AND b>c
query IIIIII rowsort
SELECT a+b*2+c*3,
a+b*2,
e,
c,
abs(a),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE (e>c OR e<d)
AND c>d
query IIIIII rowsort
SELECT d,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
e,
a+b*2+c*3+d*4+e*5
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
query II rowsort
SELECT a+b*2+c*3+d*4,
a-b
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (e>c OR e<d)
OR c>d
query I rowsort
SELECT (a+b+c+d+e)/5
FROM t1
WHERE (e>c OR e<d)
query IIII rowsort
SELECT a+b*2,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
abs(b-c),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
query IIIIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(a+b+c+d+e)/5,
c,
a,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c>d
query IIIIII rowsort
SELECT a+b*2+c*3,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a-b,
a+b*2+c*3+d*4+e*5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
b
FROM t1
WHERE d>e
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query IIIIIII rowsort
SELECT a+b*2+c*3,
b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
(a+b+c+d+e)/5,
a,
d
FROM t1
query IIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a+b*2,
(a+b+c+d+e)/5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE a>b
OR c BETWEEN b-2 AND d+2
OR e+d BETWEEN a+b-10 AND c+130
query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND d>e
query III rowsort
SELECT a+b*2+c*3+d*4+e*5,
a+b*2+c*3,
d
FROM t1
WHERE b>c
AND (c<=d-2 OR c>=d+2)
query I rowsort
SELECT a-b
FROM t1
query IIIII rowsort
SELECT c-d,
abs(a),
a,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR b>c
OR c>d
query IIII rowsort
SELECT c-d,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a+b*2+c*3+d*4+e*5,
d
FROM t1
WHERE (a>b-2 AND a<b+2)
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR b>c
query IIIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
b-c,
abs(b-c),
e,
a+b*2+c*3,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(a+b+c+d+e)/5
FROM t1
WHERE (a>b-2 AND a<b+2)
OR a IS NULL
OR d NOT BETWEEN 110 AND 150
query III rowsort
SELECT a+b*2+c*3+d*4,
(a+b+c+d+e)/5,
abs(b-c)
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR (e>a AND e<b)
OR d NOT BETWEEN 110 AND 150
query III rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
abs(a),
c-d
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (c<=d-2 OR c>=d+2)
OR b>c
query IIIIII rowsort
SELECT a-b,
d-e,
abs(b-c),
e,
a+b*2,
b-c
FROM t1
WHERE a IS NULL
AND b>c
AND (a>b-2 AND a<b+2)
query III rowsort
SELECT b-c,
a+b*2+c*3,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE b>c
OR e+d BETWEEN a+b-10 AND c+130
OR (a>b-2 AND a<b+2)
query IIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
c-d,
e
FROM t1
WHERE c BETWEEN b-2 AND d+2
query III rowsort
SELECT d,
a,
b
FROM t1
query IIII rowsort
SELECT b,
a,
a+b*2+c*3+d*4,
(a+b+c+d+e)/5
FROM t1
WHERE b>c
AND (a>b-2 AND a<b+2)
AND e+d BETWEEN a+b-10 AND c+130
query IIIIII rowsort
SELECT a,
a+b*2,
b-c,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
b,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE (e>a AND e<b)
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
b-c,
c-d,
a+b*2+c*3,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE d>e
OR a IS NULL
OR d NOT BETWEEN 110 AND 150
query IIIII rowsort
SELECT abs(a),
d,
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
c
FROM t1
WHERE a IS NULL
AND c>d
AND a>b
query IIIIIII rowsort
SELECT abs(b-c),
(a+b+c+d+e)/5,
a-b,
c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
b-c,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
WHERE a IS NULL
AND coalesce(a,b,c,d,e)<>0
query II rowsort
SELECT b-c,
abs(a)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR (e>a AND e<b)
query I rowsort
SELECT b-c
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR (e>a AND e<b)
OR coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT a+b*2+c*3+d*4+e*5,
a,
a+b*2+c*3+d*4,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE (c<=d-2 OR c>=d+2)
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query I rowsort
SELECT a+b*2+c*3
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND a IS NULL
AND coalesce(a,b,c,d,e)<>0
query IIIII rowsort
SELECT e,
a+b*2,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b
FROM t1
query IIIIIII rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(a),
a+b*2,
a-b,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
d-e
FROM t1
query IIIII rowsort
SELECT (a+b+c+d+e)/5,
a+b*2+c*3,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
a-b,
abs(b-c)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
AND c>d
query I rowsort
SELECT abs(a)
FROM t1
WHERE c>d
query IIII rowsort
SELECT e,
a+b*2,
c,
d-e
FROM t1
query IIII rowsort
SELECT d-e,
d,
a,
a+b*2
FROM t1
query I rowsort
SELECT a
FROM t1
WHERE c>d
query IIIIII rowsort
SELECT c-d,
a+b*2+c*3,
a+b*2+c*3+d*4+e*5,
a,
b,
a+b*2+c*3+d*4
FROM t1
WHERE d NOT BETWEEN 110 AND 150
query III rowsort
SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
abs(a),
a+b*2+c*3
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
query IIIII rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
abs(a),
b,
a-b,
a+b*2+c*3+d*4
FROM t1
WHERE (a>b-2 AND a<b+2)
AND (e>c OR e<d)
AND a>b
query IIIII rowsort
SELECT a+b*2+c*3+d*4,
a+b*2+c*3+d*4+e*5,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
(SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
(a+b+c+d+e)/5
FROM t1
WHERE a>b
OR (a>b-2 AND a<b+2)
query IIIII rowsort
SELECT d,
abs(b-c),
b-c,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
b
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND a IS NULL
AND c>d
query IIII rowsort
SELECT b,
d-e,
a+b*2,
b-c
FROM t1
query IIIIII rowsort
SELECT c,
e,
a+b*2,
abs(b-c),
b-c,
a
FROM t1
WHERE a IS NULL
AND (e>a AND e<b)
AND b IS NOT NULL
query IIIIIII rowsort
SELECT (a+b+c+d+e)/5,
a+b*2,
a+b*2+c*3+d*4+e*5,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3,
a-b,
a
FROM t1
WHERE b>c
query IIIIIII rowsort
SELECT e,
b-c,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a-b,
abs(b-c),
abs(a)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR b>c
query IIIIIII rowsort
SELECT a-b,
c,
b,
b-c,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
(a+b+c+d+e)/5,
d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR (c<=d-2 OR c>=d+2)
query IIIII rowsort
SELECT abs(b-c),
d-e,
c-d,
a+b*2+c*3+d*4+e*5,
d
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
OR c>d
OR d>e
query IIIIIII rowsort
SELECT a-b,
(a+b+c+d+e)/5,
abs(b-c),
c,
abs(a),
e,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
OR a IS NULL
query IIII rowsort
SELECT a+b*2,
c,
e,
b
FROM t1
WHERE (e>a AND e<b)
OR coalesce(a,b,c,d,e)<>0
query IIII rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
d,
(a+b+c+d+e)/5,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
FROM t1
WHERE a>b
AND (e>a AND e<b)
query I rowsort
SELECT a+b*2+c*3+d*4+e*5
FROM t1
WHERE (a>b-2 AND a<b+2)
OR d NOT BETWEEN 110 AND 150
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query II rowsort
SELECT b-c,
a+b*2+c*3+d*4+e*5
FROM t1
query I rowsort
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
query III rowsort
SELECT a-b,
(SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
a
FROM t1
query I rowsort
SELECT abs(b-c)
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND b IS NOT NULL
query II rowsort
SELECT c-d,
abs(b-c)
FROM t1
WHERE (c<=d-2 OR c>=d+2)
AND e+d BETWEEN a+b-10 AND c+130
AND b IS NOT NULL
query IIIIII rowsort
SELECT (a+b+c+d+e)/5,
e,
c-d,
a+b*2+c*3,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
a-b
FROM t1
WHERE c BETWEEN b-2 AND d+2
OR coalesce(a,b,c,d,e)<>0
OR a IS NULL
query II rowsort
SELECT a-b,
a
FROM t1
WHERE c>d
query IIIIII rowsort
SELECT (a+b+c+d+e)/5,
a+b*2+c*3+d*4+e*5,
d-e,
a+b*2,
CASE a+1 WHEN b THEN 111 WHEN c THEN 222
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
c
FROM t1
WHERE c BETWEEN b-2 AND d+2
AND b>c
AND a>b
query I rowsort
SELECT a+b*2+c*3
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR c>d
OR a IS NULL