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 ---- 30 values hashing to efdbaa4d180e7867bec1c4d897bd25b9 query IIIIIII rowsort SELECT e, abs(a), b, abs(b-c), CASE WHEN ab ---- 119 values hashing to 46c6841abfae8913a6759ec6f454ab0f 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 at1.c AND x.db-2 AND ab-2 AND ab ---- 391 475 502 544 595 685 query IIIIIII rowsort SELECT c, CASE WHEN a=d+2) AND coalesce(a,b,c,d,e)<>0 AND c>d ---- 35 values hashing to b523d6b6df543010b45626657adada9d query IIIIIII rowsort SELECT d, (SELECT count(*) FROM t1 AS x WHERE x.bc AND (e>c OR e0 ---- 189 values hashing to e421c85cd0132772b0b7762c78066abb query IIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dd AND c BETWEEN b-2 AND d+2 ---- 24 values hashing to 83cde3379decb55b28d3ac450c6f9881 query IIII rowsort SELECT a+b*2+c*3+d*4+e*5, abs(a), d, CASE WHEN ac OR et1.c AND x.d0 OR b>c OR b IS NOT NULL ---- 90 values hashing to 7be06d7255991a0b921d169b65e408c0 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 a0 OR b>c OR a>b ---- 90 values hashing to f2ff447495c871e67c605d2c0b5e70ec query III rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE c>d ---- 65 values hashing to 5ed50f9b86136acfad54696420ffa1f0 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 ---- 150 values hashing to a030f689f5a0035d4db42d5da9f4b7a7 query III rowsort SELECT e, a, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dc OR ea AND e(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, CASE WHEN at1.c AND x.dd ---- 45 values hashing to a15fae7379de155bbaeb251f575a7db0 query IIII rowsort SELECT abs(b-c), (SELECT count(*) FROM t1 AS x WHERE x.b(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 ---- 72 values hashing to 12fdbfddf3f67b7da4a8224b4e2798a6 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.db-2 AND ac AND coalesce(a,b,c,d,e)<>0 AND (e>a AND e(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(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 ---- 1120 NULL 555 NULL NULL 4 114 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 a0 OR d NOT BETWEEN 110 AND 150 ---- 60 values hashing to 56503929d5f9ae519d6cd57dbc46fd31 query IIII rowsort SELECT e, a+b*2, c, b-c FROM t1 WHERE a>b ---- 68 values hashing to 002e43f0dae181922fce672d6b46bce4 query IIIIII rowsort SELECT c, b-c, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dc AND (e>a AND e(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 ---- 180 values hashing to 0e9c742378241574ced59b33a5434334 query IIIII rowsort SELECT c-d, b-c, a+b*2+c*3, abs(a), a+b*2+c*3+d*4 FROM t1 ---- 150 values hashing to 7fe27233559679a19eeea3d0344a0a75 query I rowsort SELECT d FROM t1 WHERE c>d AND (c<=d-2 OR c>=d+2) AND (e>c OR ec ---- 13 values hashing to 26ce2a46fa9ea4ff61793fcfe9ac0168 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 ---- 30 values hashing to 0075716954dbc259c5e8ac65568a6fa7 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.b0 ---- 210 values hashing to 782245bb6ba30992ede7e5b5f0b3a770 query III rowsort SELECT (a+b+c+d+e)/5, e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.db-2 AND aa AND e(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 ---- 10 values hashing to f4e0215d63da3cf742c6994add1a57ab query III rowsort SELECT c, a+b*2+c*3+d*4+e*5, c-d FROM t1 ---- 90 values hashing to 506e2afe06127463d88f196da2943a89 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 ---- 20 values hashing to 43c185bc3c298eb1f985ac13c0bafe63 query I rowsort SELECT c-d FROM t1 WHERE c>d ---- 13 values hashing to 4f440d60ba96ec329ca81db364624811 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+2) AND c BETWEEN b-2 AND d+2 AND coalesce(a,b,c,d,e)<>0 ---- 36 values hashing to d2d3b4e04efb177f21490dcb8d52ada5 query III rowsort SELECT a+b*2+c*3, b, (SELECT count(*) FROM t1 AS x WHERE x.bb ---- 54 values hashing to b8c57644f5bc8e0f2140fe80814027d3 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 et1.c AND x.da AND ea AND eb-2 AND ac ---- 75 values hashing to 0fad8b78ab2dd2f61c26a27190ce19c0 query I rowsort SELECT c-d FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.bt1.c AND x.d(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.bd ---- 13 values hashing to a9f003d45f26b5b6764ef22f16260fdf query I rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dc AND b IS NOT NULL AND (a>b-2 AND ab OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.be ---- 81 values hashing to daf8222f368b8af911b2ea0205aff651 query II rowsort SELECT d-e, abs(a) FROM t1 WHERE (e>c OR et1.c AND x.db AND b>c AND (c<=d-2 OR c>=d+2) ---- 333 1391 23 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.dd ---- 78 values hashing to d3cef94ca3dc1b45729489b9ffa60d3f 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 ---- 24 values hashing to 66a81d76eae1ab608302f07cd95c35e2 query IIII rowsort SELECT a-b, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dc OR e(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 ---- 17 values hashing to baeb6fdb5d575870fddf7d11fa9e02f3 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 aa AND ea AND ec 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(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, b FROM t1 ---- 210 values hashing to 9b296f0c2d63eb2d8663ebbf98fe7462 query II rowsort SELECT d-e, abs(b-c) FROM t1 WHERE b IS NOT NULL ---- 54 values hashing to d476ace2c3b8cf05ff5893bf63e088e9 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 eb-2 AND aa AND e(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 ---- 66 values hashing to d667c19a8db947e8d78da6f211a32b33 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 ---- 36 values hashing to b3abed6fa7975f32cea35c1c82052613 query III rowsort SELECT b-c, CASE WHEN ab-2 AND ae AND (c<=d-2 OR c>=d+2) AND a>b ---- 21 values hashing to ddf3c7563b358cce0af4f01125706ce0 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.bd ---- 55 values hashing to 4d1e4b4b34120f5c6bb0c0e4fe30fdbd 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.bt1.c AND x.d(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 ---- 96 values hashing to 5d1b031c85c8e443a475c8bf4d3c62ac query I rowsort SELECT d-e FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b0 AND c BETWEEN b-2 AND d+2 ---- 14 values hashing to eb0d3d5abd4ff4a559c13f43d12f55fc query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.b(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.db-2 AND aa AND eb ---- query IIII rowsort SELECT c-d, (SELECT count(*) FROM t1 AS x WHERE x.bb-2 AND ae ---- 12 values hashing to 383eb65446347ea6e607173208759bd4 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 ---- 120 values hashing to 063f5e8d2c0f3169b9c191380f3d3322 query IIII rowsort SELECT d, b-c, abs(b-c), b FROM t1 WHERE c BETWEEN b-2 AND d+2 ---- 60 values hashing to 1d4f85009c12a1a99a445c4d2f49a07e query II rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bc OR et1.c AND x.db ---- 102 values hashing to 90fa34da0f47adbe685546e0538a64b5 query I rowsort SELECT d FROM t1 WHERE (e>c OR e=d+2) ---- -2 333 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 at1.c AND x.db OR (e>c OR ec OR (a>b-2 AND at1.c AND x.dc ---- 26 values hashing to f9aa7b0682d2155a61d91f6c3e3aa0f6 query IIIII rowsort SELECT CASE WHEN a0 AND c BETWEEN b-2 AND d+2 ---- 75 values hashing to 20ec583d2295fd5f84a509c8bb33045d 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.bd AND a>b ---- 15 values hashing to 4ae979f02ba8355cc00e1b6009f7f07c query IIIIII rowsort SELECT d-e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d0 ---- 180 values hashing to 47d6e3c44547d5c5dcbd19d1dd9f15d5 query I rowsort SELECT a FROM t1 WHERE (e>c OR e(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, a FROM t1 WHERE b IS NOT NULL ---- 135 values hashing to 15138e5915e2fe5ed2c0c820de7579ce 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(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.db OR b IS NOT NULL ---- 135 values hashing to 9e262611553407ecce8e397969dd1bce query I rowsort SELECT abs(b-c) FROM t1 WHERE b IS NOT NULL AND e+d BETWEEN a+b-10 AND c+130 ---- 1 4 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 ---- 105 values hashing to 53754235cfffd05233b4d3a2403881a5 query I rowsort SELECT a+b*2+c*3 FROM t1 WHERE a>b ---- 17 values hashing to e237372cbf981454a9240fd99e73b8e4 query IIIIIII rowsort SELECT a+b*2, a, b, c, abs(b-c), abs(a), d FROM t1 ---- 210 values hashing to b34e0001ad4bdd914341ae317c613e1c 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 ---- 54 values hashing to 3755533386c14db52aa1ef57fb5c7dfe 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 ab ---- 12 values hashing to 9d90bcb98a18bc4f2c6c648b57d9a0b5 query IIIIII rowsort SELECT a+b*2+c*3+d*4+e*5, d-e, (SELECT count(*) FROM t1 AS x WHERE x.b=d+2) OR e+d BETWEEN a+b-10 AND c+130 OR a>b ---- 132 values hashing to 1438bde5aab9a47b1027ed6cd08d3080 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.b0 ---- 150 values hashing to 2187ecb4988b726899c40305e68659be 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=d+2) OR (e>c OR ed ---- 104 values hashing to a14dd901528761d99a178f3831e86c6f 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(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 ---- NULL NULL 114 1120 1 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=d+2) ---- 70 values hashing to b0d4bbdac1bb95cff2c4e05adbb5da90 query IIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.b(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 ---- 180 values hashing to a0916b6a52dd9dbdcc5e8e5abbf13dc2 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(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, (SELECT count(*) FROM t1 AS x WHERE x.be OR coalesce(a,b,c,d,e)<>0 ---- 150 values hashing to 7513fd547e90170855946a451500730f query IIII rowsort SELECT a+b*2+c*3+d*4, CASE WHEN ab-2 AND a=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(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.bd ---- 39 values hashing to 68c3d5e1a20acbe40e43b4cb004bd223 query III rowsort SELECT abs(b-c), (a+b+c+d+e)/5, d FROM t1 WHERE (e>a AND e=d+2) ---- 10 values hashing to f4e6e43c2b8b813ce50d6662923d4fc0 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.be AND coalesce(a,b,c,d,e)<>0 ---- 45 values hashing to c9265d596fbcbad28442ec6b998fb740 query II rowsort SELECT a+b*2+c*3+d*4, (SELECT count(*) FROM t1 AS x WHERE x.be ---- 18 values hashing to da91174780bb14b5dedff6e117705ee5 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) ---- 12 values hashing to a84ed43f5c663d693a9c3bea9318231a query II rowsort SELECT d-e, a FROM t1 WHERE b>c AND (e>c OR eb-2 AND a0 AND d>e AND d NOT BETWEEN 110 AND 150 ---- 42 values hashing to c39888e7e799f07421b58acd0c14b335 query I rowsort SELECT CASE WHEN a=d+2) AND b IS NOT NULL AND c>d ---- 12 values hashing to d1f97e065d3318f1c905ff5f404c259e query III rowsort SELECT a, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.db ---- 51 values hashing to c3ff7d2b20e04fd75f074ea1f41137bc 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 ---- 77 values hashing to fcdd05c347f43f87c33b71e758491765 query IIII rowsort SELECT a, d, a-b, CASE WHEN a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, a+b*2+c*3+d*4+e*5 FROM t1 ---- 120 values hashing to ed44bad18fcadef3387f16249b2c8188 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 at1.c AND x.db ---- 102 values hashing to 35b3e42da41d41da850ff27225d1add2 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 ---- 51 values hashing to b86029f47418c16af4cf2b938795cf9d 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 ---- 34 values hashing to b9f27e2692846c7cf82160112dc817a1 query III rowsort SELECT a-b, b-c, abs(b-c) FROM t1 ---- 90 values hashing to c67a9b35c13fbe0e2c787e8b298e0cc7 query I rowsort SELECT c FROM t1 WHERE (e>c OR eb ---- 25 values hashing to 12ac2528d0176d140f899db83beeae4a query IIIIII rowsort SELECT (a+b+c+d+e)/5, c-d, CASE WHEN a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, a, c FROM t1 WHERE (e>c OR eb-2 AND ae AND b>c ---- 5 query I rowsort SELECT a+b*2 FROM t1 WHERE (e>c OR ee ---- 44 values hashing to 6eb821a9c64425c2015710ca063f859d query I rowsort SELECT d FROM t1 WHERE e+d BETWEEN a+b-10 AND c+130 OR b>c OR c>d ---- 23 values hashing to 83c121f8dfa4054cd315db02a5a0da66 query IIIII rowsort SELECT c, e, CASE WHEN ab ---- 85 values hashing to 6916e65d511015d6aa52a62b4a666ba3 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 ---- 72 values hashing to 20a4b8aec8f3063b4950f5c7d01cf17c query IIIIIII rowsort SELECT b, d, a, c, CASE WHEN ae OR a IS NULL ---- 84 values hashing to 5bce68a9cb274f51217904d5c72a6671 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 ---- 108 values hashing to 2d4310983fffbe49ff8a05e91ff7336c 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.dt1.c AND x.d=d+2) ---- 14 values hashing to 08aca67746baa979d75bd8d3a8f212cf query II rowsort SELECT d-e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dc OR eb-2 AND aa AND ed ---- 1 1 query IIIII rowsort SELECT CASE WHEN a0 ---- 150 values hashing to 362a2f78bba70bae1f727da6185db9e1 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.dc OR e0 OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.bt1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE (e>c OR ec OR b IS NOT NULL OR (e>c OR et1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 ---- 30 values hashing to efdbaa4d180e7867bec1c4d897bd25b9 query I rowsort SELECT d-e FROM t1 ---- 30 values hashing to 9e2d6381b04ea314cd79c5fc9325b30e query IIIIII rowsort SELECT b-c, CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, CASE WHEN at1.c AND x.dc OR ec ---- 36 values hashing to 942b2c182279b08bb67984c403d5f2e3 query II rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d0 AND d>e ---- 11 values hashing to 968b47b57dececa1c36ea07df5744ccb query IIIIII rowsort SELECT d-e, CASE WHEN a(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) ---- 180 values hashing to 2960873e6fcd668c017046579722e727 query IIIIIII rowsort SELECT abs(a), (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dt1.c AND x.d(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 ---- 210 values hashing to 95e81aefa1435b01ca795dd01fa37055 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 ---- 90 values hashing to 4ee92dc4498bf0bde48f9fe510e0eefb 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 et1.c AND x.dc OR e0 ---- 30 values hashing to 5597b8fa34613aadc270053ea54637e5 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.db OR b IS NOT NULL ---- 162 values hashing to 86497e82dae5464fd3ffbb6a17945399 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 ---- 150 values hashing to 352a74ab89b39257e03af042d19053ca 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.bb OR e+d BETWEEN a+b-10 AND c+130 OR d NOT BETWEEN 110 AND 150 ---- 150 values hashing to 8b990284f465e87fb0bacddac6be6b32 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 ac OR e(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.ba AND ea AND e(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, d-e, c-d FROM t1 ---- 90 values hashing to 3c2e29c1a62828371d108fc2db0e9637 query IIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d0 ---- 180 values hashing to f26f35b2777ee4f09e0e1e36a80f73df query IIII rowsort SELECT c, a+b*2, (SELECT count(*) FROM t1 AS x WHERE x.bc OR c>d OR a>b ---- 112 values hashing to e7ee87f5a21f10c5ba46c5523a4e3fc1 query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bt1.c AND x.da AND e(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, CASE WHEN a=d+2) ---- 70 values hashing to 29806c31c20e32638f689ff9b0074bbc query III rowsort SELECT d, abs(a), (SELECT count(*) FROM t1 AS x WHERE x.bb ---- query IIIIII rowsort SELECT b-c, c-d, d, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(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) ---- 60 values hashing to 1d97218927132ea6eeb68998798765dd 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.de ---- 135 values hashing to 951e266b40b8150f48baec623f0a686d query IIIII rowsort SELECT a+b*2+c*3+d*4+e*5, CASE WHEN a(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.bt1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE (e>a AND e=d+2) OR c BETWEEN b-2 AND d+2 ---- 95 values hashing to 9c84288c31e030804a75653e160c1629 query II rowsort SELECT e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dt1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE a IS NULL ---- 10 values hashing to 7ee51b913f9e7c82957dd58131b1b053 query II rowsort SELECT d, c-d FROM t1 ---- 60 values hashing to 91395206c5a9ae2e3ba90eaaf9fbcad3 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 ---- 12 values hashing to d8e53c3de9f066cbd7c55b75853ee395 query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.b(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 ---- 210 values hashing to 61699457c79288b3b884493fcc1312c0 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 ---- 14 values hashing to 524440442f030d3deaeba575dcdfa474 query III rowsort SELECT abs(b-c), d, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d=d+2) ---- 30 values hashing to af433230b7fed89ab6f38404c00cf2a1 query IIII rowsort SELECT c-d, a+b*2+c*3, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dd OR a IS NULL OR (e>c OR et1.c AND x.dc OR ee ---- 11 values hashing to 91e1a4121a8a99224ec3880f8f82538f query IIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d=d+2) AND (e>c OR et1.c AND x.db OR a IS NULL OR b IS NOT NULL ---- 189 values hashing to 1a6eadef60af9a484ef356b4dbe18111 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 ---- 120 values hashing to d5410dc1707e456075f961d75c8373e3 query IIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.b(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, CASE WHEN ac ---- 78 values hashing to f52714b3be854536a6021f8399270892 query I rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.da AND e(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE d NOT BETWEEN 110 AND 150 ---- 51 values hashing to 3f10f53291c4c4332957f5fbb29105f3 query III rowsort SELECT d-e, d, CASE WHEN aa AND eb-2 AND a(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 ---- 20 values hashing to 3cde23794ae5812c647b191dce114ef9 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 ec OR e(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, a+b*2+c*3+d*4+e*5 FROM t1 ---- 90 values hashing to caf4160422e6c04f33f5dee76a5ee6ba 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 a0 ---- 90 values hashing to fe561dee28440461c7db2b4bbe966e6d query I rowsort SELECT c-d FROM t1 ---- 30 values hashing to 5597b8fa34613aadc270053ea54637e5 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 ---- 189 values hashing to e3666393489dac8e3e03edb06718f10f query IIIII rowsort SELECT a, a-b, a+b*2, a+b*2+c*3, (a+b+c+d+e)/5 FROM t1 ---- 150 values hashing to 2f3a15a8e97ebcf855a829bc06b4b32c query II rowsort SELECT d, (SELECT count(*) FROM t1 AS x WHERE x.b0 ---- 60 values hashing to b3bf42b26da3b06aa3b50178db6c5697 query III rowsort SELECT a, a+b*2+c*3, d-e FROM t1 WHERE d>e AND b IS NOT NULL ---- 33 values hashing to 3a32b8d5a3ecfe962caef1637978eb7e 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 ---- 10 values hashing to de89b94580a889b31f615d74825bf75b query IIIIII rowsort SELECT CASE WHEN ab OR b>c OR c BETWEEN b-2 AND d+2 ---- 162 values hashing to 5387d6edebdd989ccaefbb09e17a4489 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 ee OR (c<=d-2 OR c>=d+2) ---- 96 values hashing to 00c6ced20f2eeff721db25271eae6fb3 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 ---- 317 385 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.be OR (c<=d-2 OR c>=d+2) ---- 80 values hashing to 53ec7c69fa7066b8d13cba3190a01566 query IIII rowsort SELECT d, a-b, b-c, c FROM t1 WHERE c BETWEEN b-2 AND d+2 AND a>b ---- 32 values hashing to f82ab87aa91c92197efafacd537934bc query III rowsort SELECT a+b*2+c*3+d*4, e, (SELECT count(*) FROM t1 AS x WHERE x.bt1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.bc ---- 130 values hashing to 32e82da0c738e8e4864716e5bce71c70 query II rowsort SELECT abs(b-c), (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.db ---- 34 values hashing to 17af39f9188adb8ce97fb72e6c8356ee query I rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bd ---- 26 values hashing to 7423c13b5fcb65e9953181f0cea5a006 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 at1.c AND x.db ---- 54 values hashing to 24f085b29e652f1489e82b92cd2a3f18 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) ---- -3 2878 579 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 ae AND a>b AND b>c ---- 555 333 3 2323 1391 2 query I rowsort SELECT abs(b-c) FROM t1 ---- 30 values hashing to c289bcde2e1a495d6cc09dde069c6c87 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.bb-2 AND ac OR et1.c AND x.dc OR (c<=d-2 OR c>=d+2) OR d NOT BETWEEN 110 AND 150 ---- 150 values hashing to f046070b061166d9a9445ac1be175e05 query III rowsort SELECT e, b, (a+b+c+d+e)/5 FROM t1 WHERE (e>a AND ec ---- 42 values hashing to 4415e43a6216d494659df3c3af052083 query IIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.ba AND ec OR eb OR (a>b-2 AND at1.c AND x.dd AND (a>b-2 AND ac ---- 10 values hashing to 5bdbcd20f9b8b742c3afd186710bd1ba 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 ad ---- 48 values hashing to a4d0a38ede3fe0f188f7321970a8f4dd query IIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.db-2 AND ad ---- 26 values hashing to 663683e4f7954e2f02d662e397617a1a 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 ---- 210 values hashing to d8d3fdc7da9f9940577c907ddc46ffce query IIIII rowsort SELECT abs(b-c), d, c-d, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dt1.c AND x.dd OR c BETWEEN b-2 AND d+2 ---- 18 values hashing to ed081fa5a86710d0e9371bd21e57b60e 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 ---- 150 values hashing to 3c56becf91b5255ea828187ff5b098f4 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.de AND coalesce(a,b,c,d,e)<>0 ---- 49 values hashing to e5f10ba8d31c39afeed33abfce4615f4 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 ee AND e+d BETWEEN a+b-10 AND c+130 ---- 127 query IIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.db ---- 108 values hashing to aca58d046c3974c5452267788f36253d query III rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bt1.c AND x.de OR (e>c OR e0 ---- 90 values hashing to 831ec57d0eab9076adedbe5a7b29e5bf query I rowsort SELECT a-b FROM t1 WHERE (e>a AND et1.c AND x.d0 ---- 150 values hashing to c76015113477b90a604969958de72e28 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 at1.c AND x.d0 AND (e>c OR ee 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 eb ---- 108 values hashing to 978db612dff384a225a87254a55c893f query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(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.b0 AND (e>c OR e(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.da AND et1.c AND x.d=d+2) ---- 20 values hashing to 8b8de03297a4e9b601746a08dccab3da 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 ---- 68 values hashing to 059bff8962702d7f8ec171a2b6710523 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.da AND ec OR e(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 ---- 120 values hashing to 3fb73a6642c453dc019d87cb69d8ce65 query I rowsort SELECT e FROM t1 WHERE c>d AND coalesce(a,b,c,d,e)<>0 AND a>b ---- 132 173 180 189 210 query IIIIII rowsort SELECT d-e, a, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.db-2 AND ab-2 AND a0 ---- 120 values hashing to f4530e16c6d59dfaeee60435bf008b02 query III rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d=d+2) OR a>b ---- 66 values hashing to affa3f7c8cca946ae71f450ca6822fc1 query IIII rowsort SELECT a, e, (SELECT count(*) FROM t1 AS x WHERE x.ba AND et1.c AND x.d=d+2) ---- 40 values hashing to a24ad9a2815293e785c73b1daaa0e8ad query III rowsort SELECT b, c-d, a+b*2+c*3+d*4+e*5 FROM t1 ---- 90 values hashing to b4c390cf4b2cfb24ddd6e3f132c39aaa query III rowsort SELECT a, a+b*2, a-b FROM t1 ---- 90 values hashing to 49d12b03e799cc0ee6e76a2a9f7c33a8 query IIIII rowsort SELECT e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dd OR e+d BETWEEN a+b-10 AND c+130 OR d>e ---- 100 values hashing to df3961211ec3a646a12da616ad3fadc0 query IIIII rowsort SELECT c-d, a-b, (a+b+c+d+e)/5, b-c, CASE WHEN ab 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.bc OR a IS NULL OR b IS NOT NULL ---- 108 values hashing to 7e30de55cc8c8fecffab160dec37f6cf 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 ---- 78 values hashing to 63edb99176cba2defed12c703539f05a 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 ---- 145 values hashing to 63be192e3efa764f76ad645bbc0072f1 query IIII rowsort SELECT d, d-e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(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 ---- 92 values hashing to a5b6a8f716fa56ad6172f74a7ea0e544 query IIIIIII rowsort SELECT a+b*2, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dt1.c AND x.dc OR ec ---- 39 values hashing to 0a7270cbb622612fe7d21399b291ea34 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.d0 AND e+d BETWEEN a+b-10 AND c+130 ---- 106 105 635 1612 333 0 333 query IIIIIII rowsort SELECT c-d, a-b, a+b*2+c*3+d*4+e*5, CASE WHEN ab-2 AND ac AND b IS NOT NULL ---- 42 values hashing to 292d19ab365220a4c3e6c8d933cded12 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 ---- 72 values hashing to 3e177272e34b49de0d456303ee9c5a3e query II rowsort SELECT (a+b+c+d+e)/5, CASE WHEN ad ---- 26 values hashing to bbcf40e5d9193aabcea50a283e717c13 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.db-2 AND ae OR a>b ---- 138 values hashing to 36061e61f6fb65be552999cbc8a62109 query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.da AND e(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, abs(a), a FROM t1 ---- 180 values hashing to 4a8f3f5cc7acabba999f282a682e4df3 query II rowsort SELECT a+b*2+c*3, (a+b+c+d+e)/5 FROM t1 WHERE (e>c OR ec OR ec OR e0 ---- 150 values hashing to 2ebddea9b425cce206f5389f0b39fd13 query IIIIIII rowsort SELECT b, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.db-2 AND a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE (e>a AND et1.c AND x.de ---- 72 values hashing to 880fbd81a41a9c85a5eae4cce9eb38a7 query I rowsort SELECT d FROM t1 WHERE c>d OR b>c ---- 22 values hashing to 37894839dede35f650b00286a84a36c1 query IIIIIII rowsort SELECT d-e, CASE WHEN a=d+2) ---- 70 values hashing to dc257c0ed350a49a5fc2d03ed4017bce query IIIIII rowsort SELECT e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dc OR a>b ---- 144 values hashing to 9bef3a2da8ca8adaf6ac27a55656e1d4 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 ec ---- 760 127 4 126 4 -3 129 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 ---- 25 values hashing to a319c940b7c0dad8385a5d2d235e0ac9 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 ---- 33 values hashing to cccc2fc956ba31f21063f4ed5504c7d5 query IIIIII rowsort SELECT e, d-e, CASE WHEN a(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 ec OR c BETWEEN b-2 AND d+2 ---- 69 values hashing to 59bf333ae0b98d58bcae7a31cd5557cc query I rowsort SELECT CASE WHEN ac OR ee OR e+d BETWEEN a+b-10 AND c+130 OR coalesce(a,b,c,d,e)<>0 ---- 90 values hashing to bf0b1691880199579089ce2f5732550a 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 ---- 120 values hashing to 2e71f1d3ef553efa731e74493491b43e 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 ae OR e+d BETWEEN a+b-10 AND c+130 ---- 24 values hashing to 39f21bf43fd60cb6f414344a0ebf8c6e query III rowsort SELECT b, CASE WHEN a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 ---- 150 values hashing to f04293c115149822ce94d0701e876523 query IIIIII rowsort SELECT abs(b-c), a-b, (SELECT count(*) FROM t1 AS x WHERE x.b(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE (e>a AND eb-2 AND ad ---- 65 values hashing to 7d1010ffd2bac09eacbd2c9fba7ac5e3 query III rowsort SELECT a-b, abs(b-c), (SELECT count(*) FROM t1 AS x WHERE x.bb-2 AND at1.c AND x.de OR (a>b-2 AND a0 AND (c<=d-2 OR c>=d+2) ---- query IIIIII rowsort SELECT c-d, b-c, CASE WHEN a(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 ae ---- 18 values hashing to 0863cee9de2d56270775813a3a17b7e5 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 ---- 48 values hashing to 94f74078907e78ef572fa0e510484e77 query IIIIII rowsort SELECT c-d, e, a+b*2+c*3+d*4, c, a, (SELECT count(*) FROM t1 AS x WHERE x.b0 OR b>c OR a>b ---- 210 values hashing to c3a28a29943cda0b0369096bc4217587 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 ---- 180 values hashing to 5654e95b1947f195d63ec22ce973e453 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 et1.c AND x.d(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 ---- 210 values hashing to c3150ef8bcd2ba7d6850a2e90e8429d2 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.bt1.c AND x.dc AND d>e AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b(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 ---- 78 values hashing to aea9f3b24ac690b7ca61dde6e38d4087 query I rowsort SELECT a+b*2+c*3 FROM t1 WHERE coalesce(a,b,c,d,e)<>0 ---- 30 values hashing to 445b0172de37f3ca0ed777000309cef8 query IIIIIII rowsort SELECT CASE WHEN ab-2 AND a0 ---- 90 values hashing to b695930cba779990506825371a4cb6f0 query IIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.b=d+2) AND c BETWEEN b-2 AND d+2 AND d>e ---- 20 values hashing to f36747a922a64a45b6021838f71a7404 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 ---- 120 values hashing to a66e96aaa5e2333eada2f94e14e11d19 query II rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.de ---- 22 values hashing to 6d5296bf2990e2c542cb932b111e58b0 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 et1.c AND x.dd OR (c<=d-2 OR c>=d+2) OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.bc OR ee ---- 66 values hashing to 29bf444784eb00e33aec085b59443fcf 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 ---- 60 values hashing to 9dab3921e761fb6aeea4e154dd53814c query II rowsort SELECT e, c-d FROM t1 ---- 60 values hashing to 52b55195fd2cbf5a5724611d48a47b4d query I rowsort SELECT d FROM t1 WHERE c BETWEEN b-2 AND d+2 OR c>d ---- 18 values hashing to 10a54676f8fc9c6839ddbb6078163c29 query I rowsort SELECT abs(a) FROM t1 ---- 30 values hashing to 9a6afb6b859fc856aafb6a7af11a38e4 query IIIII rowsort SELECT a+b*2+c*3+d*4+e*5, (SELECT count(*) FROM t1 AS x WHERE x.b(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, a FROM t1 WHERE (a>b-2 AND ae ---- 2728 14 184 364 182 query II rowsort SELECT a, a-b FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b(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(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, CASE WHEN ab-2 AND a=d+2) AND c BETWEEN b-2 AND d+2 AND b IS NOT NULL ---- 36 values hashing to 94312feb4471e360fb2f52d49629c3c6 query III rowsort SELECT d-e, CASE WHEN ab ---- 85 values hashing to 80d90d98b5254af7ad522b74fdb17712 query IIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bt1.c AND x.db ---- 68 values hashing to abcb35b2a0d7934c081beb8189cf1b95 query IIIII rowsort SELECT CASE WHEN ad ---- 78 values hashing to 1b520683f74b5530a6d329a42c3b086c query IIIIIII rowsort SELECT b, c, abs(b-c), CASE WHEN ab-2 AND ac ---- 105 values hashing to 93621982a8d1f310b8a2c14097620bf2 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.dc OR ec ---- 78 values hashing to 1dcb8480bfa52a7ff3eeadb8e5f9d6b7 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=d+2) OR d NOT BETWEEN 110 AND 150 ---- 38 values hashing to 87d92ebb256f91f8fcff006e1de357c6 query IIII rowsort SELECT abs(a), a+b*2+c*3+d*4, d, CASE WHEN ac OR c>d OR d NOT BETWEEN 110 AND 150 ---- 130 values hashing to 22615879d395d9f85a5d5410a52cbade query II rowsort SELECT a+b*2+c*3, (a+b+c+d+e)/5 FROM t1 WHERE (e>a AND e(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.dc OR eb-2 AND at1.c AND x.db AND (c<=d-2 OR c>=d+2) AND b>c ---- 234 -2 232 3473 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 ---- 210 values hashing to 3c8f4a1535d3f43a24c81afe21c184e4 query II rowsort SELECT a+b*2+c*3+d*4+e*5, (SELECT count(*) FROM t1 AS x WHERE x.bb ---- 105 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 ---- 120 values hashing to 901ba045211faeea092345b7ad51c0d5 query II rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.de OR a IS NULL ---- 24 values hashing to e2a022b7bd74795bc490bcc51a206498 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 ---- 28 values hashing to 13f8270a8f89d6e944f5090daeadabd0 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.bc OR e(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 ea AND e=d+2) ---- -1 -3 1 1 -3 -2 query IIIII rowsort SELECT a, b-c, c-d, CASE WHEN ae AND c BETWEEN b-2 AND d+2 AND a>b ---- 25 values hashing to 419cd8bb5dda32eae9bca394f90dde33 query IIII rowsort SELECT CASE WHEN ac OR eb OR b>c ---- 72 values hashing to f845b36d538bfc88079f0cb5eef060a2 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=d+2) ---- 40 values hashing to 80e350db406b6c89ef984d914c33e892 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.bt1.c AND x.dd AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.bt1.c AND x.dc OR e0 AND e+d BETWEEN a+b-10 AND c+130 ---- 14 values hashing to e86dd9a09988eb25ea97879396caf6b1 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 a0 OR (e>c OR e(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 ---- 60 values hashing to 18f2933597761b47c2c692da942192f4 query II rowsort SELECT a+b*2+c*3, b-c FROM t1 WHERE (e>c OR e(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 ---- 24 values hashing to 47e330569be3eb481186c0d6c28073c5 query I rowsort SELECT a+b*2 FROM t1 ---- 30 values hashing to fbca95e5a969d3d61cef1ebdfb618461 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) ---- 10 values hashing to 6e82ac65b16043b22b77cce5a6b54b85 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(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, e, b-c FROM t1 WHERE (a>b-2 AND a0 ---- 40 values hashing to 37f20a64c7fb356dece2c07d46d1ab67 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 ---- 20 values hashing to 5f495935b071bd704ed9f2508972775f 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 ---- 180 values hashing to f54645bfc786b7ace563665760407aba query II rowsort SELECT c-d, abs(a) FROM t1 ---- 60 values hashing to fe78e4b1ff081fd27c3224d12fcc9ce5 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=d+2) AND c>d ---- 20 values hashing to a6f5b07700b91337d455fc7b74670969 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.be OR d NOT BETWEEN 110 AND 150 OR e+d BETWEEN a+b-10 AND c+130 ---- 147 values hashing to 940512b6145ce091c8d1f82874510cfb 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 ---- 72 values hashing to 0f242e9e2f56c89d9c9be56b8e43ccd9 query II rowsort SELECT b, (a+b+c+d+e)/5 FROM t1 WHERE e+d BETWEEN a+b-10 AND c+130 ---- 105 107 129 127 query IIIIII rowsort SELECT CASE WHEN a(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.db-2 AND at1.c AND x.d(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.bt1.c AND x.d0 OR a IS NULL ---- 60 values hashing to 7a1089974412491aad2bf8edc19d0344 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 ---- 174 values hashing to 03fe0d3bbd39567ee4199b3e3b15c9e0 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.bc ---- 91 values hashing to 126317fd31fb97a1f067200b291595e8 query II rowsort SELECT CASE WHEN a=d+2) ---- 60 values hashing to 85fd30e621d2979629fdff750ef890c6 query II rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.b(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) ---- 38 values hashing to 2cb9992dd2e1efb568d5c05c75270eae 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 ---- 333 105 333 129 query III rowsort SELECT a+b*2, (SELECT count(*) FROM t1 AS x WHERE x.b(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 ---- 68 values hashing to 85ffb6504ac3b87c0fb31d02076bb13e query I rowsort SELECT c-d FROM t1 WHERE a>b ---- 17 values hashing to 339d4bd65b5ceb69bc4f771072510b73 query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.de ---- 119 values hashing to c1050f64689e52b52a4fd459eef9efca 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.dt1.c AND x.dc OR c BETWEEN b-2 AND d+2 ---- 46 values hashing to 18f24ebfbe56b03b99e19ec7f35bee15 query IIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bb-2 AND a(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 ---- 44 values hashing to 436aec0b8f293a2a9e9f2d2d27d983e8 query IIII rowsort SELECT a, CASE WHEN ad OR (e>c OR eb-2 AND a(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 ae ---- 161 values hashing to f5decf8ff88f038062422376c736ce1e query I rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.b=d+2) ---- -1 107 2 127 query III rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(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 ---- 51 values hashing to fe6b57844f6bca2c80db86f273233b7f 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 ---- 12 values hashing to 3297975eebdf7bdaa556ca71560c6bad 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(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE b>c AND (e>c OR et1.c AND x.dc AND (e>c OR e0 ---- 9 values hashing to 8b75136b2b51c77345c03804ec1cda5c 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 ac ---- 36 values hashing to 1dfab01a2a3cde1a0fb099a13ee8f260 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 ---- 91 values hashing to 2510a4574e6b6031bf8b31706569fd18 query I rowsort SELECT e FROM t1 WHERE b>c ---- 13 values hashing to 4d4acfcd99942f84e7e344dc0cf97feb query II rowsort SELECT abs(b-c), (SELECT count(*) FROM t1 AS x WHERE x.be OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b0 ---- 150 values hashing to 7a10803f8ac1862746a5dfd7761068ec 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(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 et1.c AND x.d=d+2) ---- 70 values hashing to a30d10c6e226154b4f8a0a602394c523 query III rowsort SELECT c, a+b*2+c*3, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, c-d FROM t1 WHERE (e>c OR ec ---- 36 values hashing to 79335442c361dccabc252e74f3e843e2 query III rowsort SELECT d-e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.db OR e+d BETWEEN a+b-10 AND c+130 OR (e>c OR e(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 ---- 90 values hashing to 68d0758e12aa7de3bf098c50b1020325 query II rowsort SELECT b, a-b FROM t1 WHERE d NOT BETWEEN 110 AND 150 AND a>b AND d>e ---- 10 values hashing to 3c965ff7e782f60c038c785b61f762ec query I rowsort SELECT b FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b(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 ---- 210 values hashing to 211250250d77b776c079d3ae1530f040 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) ---- 88 values hashing to 5cede43346ad9a3e7df350a2905a234e 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(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 ---- 126 values hashing to a0c2526cbe79a2234e194925721595ac 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 ---- 90 values hashing to e930affe853f103637032aeca0d8bbed query I rowsort SELECT e FROM t1 WHERE (e>a AND ec OR e(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=d+2) ---- 168 values hashing to e1a831887ece1fd1a76178b4e62c96d3 query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bb OR d>e ---- 154 values hashing to b3c2481d8ea84ad257e77907a46f4575 query IIIII rowsort SELECT a, CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, CASE WHEN a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, (SELECT count(*) FROM t1 AS x WHERE x.bd OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b0 AND c>d AND (c<=d-2 OR c>=d+2) ---- 20 values hashing to 8f4e8cad16d912e4afabac29308ba86b 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 ---- 90 values hashing to aae88e03ac5ada995ab449e794fe5dbd 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=d+2) ---- 60 values hashing to fccfe38217c9336da83a72e1e38466e9 query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, c-d FROM t1 WHERE d NOT BETWEEN 110 AND 150 ---- 51 values hashing to 9f89c5db1a39fdf0128d784a415b7aec query I rowsort SELECT d FROM t1 WHERE coalesce(a,b,c,d,e)<>0 AND d NOT BETWEEN 110 AND 150 ---- 17 values hashing to 6753fb8eb6def51fd8dded76e76af57a query II rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.b=d+2) ---- 20 values hashing to aa007d94cb84743d77f13a517ac1c0a2 query II rowsort SELECT abs(b-c), c-d FROM t1 WHERE b IS NOT NULL ---- 54 values hashing to 0769f1f2c8be954b6c9fa17d55b37ee4 query IIIIII rowsort SELECT b, c, e, abs(a), (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, a+b*2+c*3 FROM t1 ---- 150 values hashing to 47c99b2a96a0b1135bfe580e677eeea1 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 ---- 120 values hashing to 48c8a67b9e81a901a1f13db6fda04911 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.bb-2 AND at1.c AND x.dt1.c AND x.db AND d>e AND (a>b-2 AND a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, c-d FROM t1 WHERE (e>a AND e0 ---- 120 values hashing to 8ab46353ee866e071bf1b7af72db7e40 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.bd AND b IS NOT NULL AND a>b ---- 30 values hashing to fdd011a2e0a18abb3227e4326df8ecdd query IIIIIII rowsort SELECT a-b, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, e, (a+b+c+d+e)/5, d-e FROM t1 ---- 210 values hashing to 51eb4c6f118a3cd801249a8cd6d255c6 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 ---- 72 values hashing to 082358e17e9e36e6e9d5b0c79eee1ea6 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 ---- 60 values hashing to 19f43f5d16381a382e6f42d423819d43 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 ---- 25 values hashing to 299e3455af3896f73b4c030343e18557 query IIIIII rowsort SELECT b, (a+b+c+d+e)/5, a-b, a+b*2+c*3+d*4+e*5, CASE WHEN ae ---- 66 values hashing to 63f9ad9303fb8a4a7b347b0e62fdff94 query IIIII rowsort SELECT c, (SELECT count(*) FROM t1 AS x WHERE x.bt1.c AND x.dt1.c AND x.de ---- 33 values hashing to ea6c8f3411332788326ec19211e7f3ca query III rowsort SELECT a, c-d, abs(a) FROM t1 WHERE d>e ---- 33 values hashing to a1f305de18a165327a59c4b3250a373e 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 ---- 150 values hashing to 2b4eff4fda2993558a9c12090b664627 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.bc OR d NOT BETWEEN 110 AND 150 OR (a>b-2 AND a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE (a>b-2 AND ad ---- 119 values hashing to 7343926d6c48db22db873f7d5ee38428 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 ---- 15 values hashing to a879d0436172411bd1ff79ad23bcf6c5 query IIIIIII rowsort SELECT c-d, (SELECT count(*) FROM t1 AS x WHERE x.bt1.c AND x.dt1.c AND x.d0 ---- 60 values hashing to b339e36127a64202a49f498513dd40e3 query IIIII rowsort SELECT b, d-e, a+b*2+c*3+d*4, (SELECT count(*) FROM t1 AS x WHERE x.be ---- 112 4 NULL 1 444 query IIII rowsort SELECT e, a+b*2, CASE WHEN a(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 ---- 35 values hashing to be86deef0c7e820d495982d5c6b880da query IIIII rowsort SELECT CASE WHEN a(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.bb ---- 34 values hashing to d2068136b2985ee7c04a8c9b78209dad 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 ---- 126 values hashing to adb8714e6ea266fe29ae95aa6fd92d4d 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 ---- 1120 112 NULL 206 query IIII rowsort SELECT (a+b+c+d+e)/5, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.db-2 AND a=d+2) AND (e>a AND et1.c AND x.da AND eb OR c BETWEEN b-2 AND d+2 ---- 162 values hashing to a0366f44c0f21a5de9e307e2f3a2b965 query IIII rowsort SELECT a-b, c-d, (SELECT count(*) FROM t1 AS x WHERE x.bd ---- 39 values hashing to b3af61dbda8d2d8b5489597c7f233424 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 ---- 120 values hashing to cca0428a4957294dfd510fc7266ea92d 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 ---- 22 values hashing to efc2b46a59d1aa24c732442ab6e2e534 query I rowsort SELECT a-b FROM t1 WHERE (e>c OR e0 AND (e>c OR eb-2 AND aa AND et1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, a FROM t1 WHERE (c<=d-2 OR c>=d+2) ---- 70 values hashing to 25f32304c1bc47764dd68ff331ed7b3d query III rowsort SELECT a, a+b*2+c*3+d*4, d FROM t1 WHERE b IS NOT NULL ---- 81 values hashing to 43ef865ccee93beaef9b0531bbe27ea1 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.d0 AND d>e ---- 55 values hashing to 629632d72a0b69e9ce52cf46e7961dc2 query IIIIIII rowsort SELECT e, abs(a), (SELECT count(*) FROM t1 AS x WHERE x.b(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=d+2) ---- 133 values hashing to 4c7875a7b6b7999ecba73c9123945b6f 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.dd ---- 91 values hashing to 1039be830093d12f37a63093d04e1547 query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bt1.c AND x.d(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 ---- 210 values hashing to b2e9cef39d103d581c325552c1fad51e 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=d+2) ---- 40 values hashing to 0a56263b4e542487aed6eda155f85f2a query IIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, (a+b+c+d+e)/5, CASE WHEN ad OR b>c ---- 132 values hashing to 677b478959906ed745c9582fe57c8429 query IIIIII rowsort SELECT b, a+b*2, b-c, a, CASE WHEN a=d+2) ---- 60 values hashing to 43cc8289cc0d7aa27dd7ca100b418c79 query I rowsort SELECT a+b*2+c*3+d*4 FROM t1 WHERE (a>b-2 AND ae AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.bt1.c AND x.db-2 AND ad AND d NOT BETWEEN 110 AND 150 ---- -2 -2 -4 1 2 3 NULL NULL 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 ---- 16 values hashing to 2c838c66b1922cc5ef8d87bbd634c2e1 query I rowsort SELECT a-b FROM t1 WHERE b IS NOT NULL AND c>d ---- 11 values hashing to a727bc0a71dc5f6847d30cb017bdbf58 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 ---- 25 values hashing to 41af91f684d2199c66e7c6d300ada96b 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 ac OR e(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 ---- 144 values hashing to ce0260b129a5febb9ede5c74aea550c5 query II rowsort SELECT b-c, a+b*2 FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.be OR c BETWEEN b-2 AND d+2 OR (e>a AND ea AND eb ---- 80 values hashing to 782160babf2c361f1ed87683e525e840 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.bt1.c AND x.da AND ea AND eb-2 AND ae AND b IS NOT NULL ---- 15 values hashing to 7c787a6339d303da1db7c981873e544b query IIII rowsort SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, a, abs(a), CASE WHEN a0 AND d NOT BETWEEN 110 AND 150 AND b IS NOT NULL ---- 60 values hashing to 2007f05c0a6e062701e09fdfa0713122 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.b0 ---- 180 values hashing to 9b776a59385a5b6e30c0e39547af4166 query III rowsort SELECT a+b*2+c*3+d*4+e*5, a-b, abs(a) FROM t1 ---- 90 values hashing to fef98e4832a2f229da033f1bc8cf44b0 query II rowsort SELECT a+b*2+c*3+d*4, CASE WHEN ae ---- 44 values hashing to 0a0d670d28969de28ede7d2e1e51ba1f 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 ---- 12 values hashing to 09562012bae47f170d9275f0d6912571 query IIIIIII rowsort SELECT d-e, (SELECT count(*) FROM t1 AS x WHERE x.b=d+2) OR a IS NULL OR d NOT BETWEEN 110 AND 150 ---- 140 values hashing to 7b013cbc35b21bdb59f96aff7f278d57 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 at1.c AND x.da AND et1.c AND x.db-2 AND at1.c AND x.dc OR et1.c AND x.dd ---- 78 values hashing to e47956172c8fa5c59837e680b8bf0cc7 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 et1.c AND x.d=d+2) OR (e>a AND e(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 ec OR eb OR a IS NULL ---- 38 values hashing to c780d393ba03d9efcbfb54dfb435ce6b 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.bc ---- 39 values hashing to 43e0495dd149fef637b37182902a70b0 query IIII rowsort SELECT e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.de ---- 44 values hashing to a0bbce0efbadffac94910fe5daccf705 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.dt1.c AND x.d=d+2) OR c>d OR a IS NULL ---- 95 values hashing to 3e4cd208357eddf8ec1f9c0f4886f421 query II rowsort SELECT b-c, abs(a) FROM t1 ---- 60 values hashing to f81a96674d5188e29e9a2725a491cbee query IIIII rowsort SELECT d, (SELECT count(*) FROM t1 AS x WHERE x.bc OR d NOT BETWEEN 110 AND 150 ---- 120 values hashing to a8ac31c7c91b1d87db3fcf5623afa85b query II rowsort SELECT a, c FROM t1 WHERE d>e AND b>c ---- 127 125 138 137 234 231 245 247 query I rowsort SELECT b-c FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b=d+2) ---- 28 values hashing to 1ff878f032c5cfd9be2e7d1739fd5bb1 query I rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bc OR ec ---- 39 values hashing to 3a3a06de0e9583c7ab3290f3dec6e38f 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 ---- 60 values hashing to 268ffae5bbd280974bcf34ff00a53ce8 query IIII rowsort SELECT CASE WHEN a0 OR a IS NULL OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.be AND a IS NULL ---- NULL query IIIII rowsort SELECT a+b*2+c*3, a+b*2+c*3+d*4, CASE WHEN a(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(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.da AND eb-2 AND at1.c AND x.dc ---- 26 values hashing to ac1ac27954b3ddbc82d232af3766a94b query I rowsort SELECT a+b*2+c*3 FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b0 OR (e>c OR ec OR ed ---- 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 ec ---- -4 1 2 3 NULL query II rowsort SELECT abs(a), (SELECT count(*) FROM t1 AS x WHERE x.b0 ---- 120 values hashing to 8af952a15dc09ac334e0d82042a24df9 query I rowsort SELECT a FROM t1 ---- 30 values hashing to 9a6afb6b859fc856aafb6a7af11a38e4 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 e0 AND a>b AND b IS NOT NULL ---- 51 values hashing to fb13c2384756bc5e8255d1d7d244b5a8 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=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(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=d+2) AND b IS NOT NULL ---- 36 values hashing to 06e77c39107ea08444e134ef0f89067a 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 ---- 15 values hashing to 24301db3251cc0181759db55e6ca955d 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 ---- 39 values hashing to 03a1cfda7ff971e7feec2aae616af091 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 ---- 40 values hashing to 367c01752379b26b48a5796d10d16ee8 query I rowsort SELECT a+b*2+c*3 FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.be ---- 26 values hashing to 5c41d2c888f71bdfb301a5449bb2316d 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 ---- 180 values hashing to 90084eaaa4371d329e7a2ac1a0ed1c5f query I rowsort SELECT a+b*2 FROM t1 WHERE (e>a AND eb-2 AND aa AND ec OR e(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 ---- 36 values hashing to 1fa798dc51e11d6e3131bf0c82349e7d 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 ---- 90 values hashing to 1db270b129edfe2a9cbfb25cb5406519 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 at1.c AND x.da AND ec OR ee AND b IS NOT NULL AND (e>a AND eb ---- 34 values hashing to 61ae510be58bcd19ca005e792d30db99 query IIIIII rowsort SELECT d-e, (SELECT count(*) FROM t1 AS x WHERE x.b(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 ---- 162 values hashing to d3bb54ee120d9244f04682c3992fe447 query I rowsort SELECT a-b FROM t1 ---- 30 values hashing to a8508bcdf86e494dd5feccb5ca8d9768 query IIII rowsort SELECT c-d, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dc AND a IS NULL ---- query III rowsort SELECT abs(b-c), c, a+b*2+c*3+d*4+e*5 FROM t1 ---- 90 values hashing to 4a1cb86e3b2d0a16b93a4a43e4862ea7 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 ---- 12 values hashing to 1db451b4f2b6f6a00ca68c20c8f5a10a 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 ---- 10 values hashing to 0f2bcf5dd0b4e7c0d86e4dea51b3669d query IIIIIII rowsort SELECT a+b*2+c*3+d*4+e*5, CASE WHEN ab-2 AND ac ---- 12 values hashing to 29cac38b69c814d477ac32eec447ae65 query II rowsort SELECT a+b*2+c*3+d*4+e*5, abs(a) FROM t1 WHERE a>b OR (e>c OR e0 AND (e>c OR eb-2 AND a0 AND (a>b-2 AND aa AND e(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.dt1.c AND x.db-2 AND ab ---- 40 values hashing to 4ff7b2fb85463226b58936d09fcc37e8 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.b0 ---- 30 values hashing to 5597b8fa34613aadc270053ea54637e5 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 ---- 135 values hashing to 75d9abddd431af42ba006b25f9f77c64 query I rowsort SELECT e FROM t1 WHERE (c<=d-2 OR c>=d+2) OR b IS NOT NULL ---- 28 values hashing to d2d7ee3c92135bb07a4e693017a465fa query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.b(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE c BETWEEN b-2 AND d+2 ---- 105 values hashing to a1b6d1f25e288ac504cdf45104e5bcea 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 ---- 120 values hashing to cae2effd4f5bfa6d7cc193ec4fec967d query IIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bb OR d NOT BETWEEN 110 AND 150 ---- 120 values hashing to 47ef020bd750bd779fc3a87e56ca1e40 query III rowsort SELECT abs(a), (SELECT count(*) FROM t1 AS x WHERE x.ba AND ec OR ec OR d>e ---- 120 values hashing to 094387372652ced028edd125dc034efc query IIIII rowsort SELECT e, b-c, abs(b-c), c, c-d FROM t1 WHERE a>b ---- 85 values hashing to cf909c6ca2632f334d02ace97fe65161 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 ---- 119 values hashing to 46dcc426265c9c6d3e5a95476b486aea 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 ed ---- 90 values hashing to 24562a4b1a2aff1a1a2f2cf5c4224a17 query I rowsort SELECT a+b*2 FROM t1 WHERE c>d OR a>b OR d>e ---- 28 values hashing to 2fcc0f3b5e0753a1f915168aa80928cb query IIII rowsort SELECT c-d, b-c, e, a+b*2+c*3+d*4+e*5 FROM t1 WHERE d>e ---- 44 values hashing to 2a856cf96ef2c2ee896fde7ac15baf59 query I rowsort SELECT e FROM t1 WHERE a>b OR coalesce(a,b,c,d,e)<>0 ---- 30 values hashing to b9f09a0d6206ee3b897ed8a2dc580e1d 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.bb 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=d+2) ---- 29 values hashing to 725eda52ed4dea9e7b98db61d7453ca7 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.be ---- 36 values hashing to 36e5ee818c5f66d85faa44d5c242e3a3 query IIII rowsort SELECT e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d=d+2) AND (e>a AND e(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 ---- 75 values hashing to b9e8c83a8bc74e55aa613fb8bbae83b5 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(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE (a>b-2 AND ac OR ea AND e(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.bt1.c AND x.d(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(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 ac OR ec ---- 125 values hashing to a4c2c5b599a12eb25e02a7a49e712b33 query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(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 ---- 203 values hashing to 1c10d302b1c0ebea0ed1b3f458977b97 query III rowsort SELECT a+b*2+c*3+d*4+e*5, c-d, (SELECT count(*) FROM t1 AS x WHERE x.b=d+2) ---- 1612 -2 0 1902 -3 3 query IIII rowsort SELECT (a+b+c+d+e)/5, (SELECT count(*) FROM t1 AS x WHERE x.b0 OR b IS NOT NULL ---- 120 values hashing to 1851d361af710203059df04bf29673a7 query IIII rowsort SELECT c, a+b*2+c*3+d*4+e*5, b, a+b*2 FROM t1 ---- 120 values hashing to 10ce41f677d9d05127e3b704d98bc101 query IIIIII rowsort SELECT b-c, b, a+b*2, (SELECT count(*) FROM t1 AS x WHERE x.b=d+2) ---- 60 values hashing to acdf487118a15ea371915fc5f0f267ff query IIIII rowsort SELECT a, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d0 ---- 10 values hashing to 40d0564520ae2c3653e39dbaed07d225 query IIIIII rowsort SELECT b, b-c, e, CASE WHEN a(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) ---- 72 values hashing to 2f4add22910ef08e36f4a9b91127d083 query II rowsort SELECT a-b, d-e FROM t1 ---- 60 values hashing to c60a057f1b0709ced3374a0ceb82507d query I rowsort SELECT a+b*2+c*3+d*4+e*5 FROM t1 WHERE (a>b-2 AND ae OR (c<=d-2 OR c>=d+2) ---- 32 values hashing to 9e90687d2b7ec623140ca90b9f8aa467 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(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE b IS NOT NULL ---- 189 values hashing to ca41f560b82abfc4ff509877b9d62b5d query I rowsort SELECT a+b*2+c*3+d*4 FROM t1 WHERE (e>c OR eb-2 AND at1.c AND x.db ---- 102 values hashing to 4a7a447f6d5243f37593760f719d4ded query I rowsort SELECT abs(a) FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b0 AND a IS NULL ---- NULL 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 ---- 91 values hashing to 8bc441725523cf82da0b2509fef56441 query IIII rowsort SELECT a+b*2, a-b, a+b*2+c*3+d*4, (SELECT count(*) FROM t1 AS x WHERE x.bb AND c BETWEEN b-2 AND d+2 ---- 40 values hashing to 514495abd297c1a057a65b95c2ad204c 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 ---- 120 values hashing to ab4368667b081082064b8857255d4dfb query III rowsort SELECT c-d, abs(b-c), CASE WHEN ab ---- 30 values hashing to 7df01c794d7280c4cda156ce4cc15349 query II rowsort SELECT b, a FROM t1 WHERE (a>b-2 AND at1.c AND x.dc OR (e>a AND e(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 ec ---- 91 values hashing to f466adf4b72001a7e56f1288f645df0b 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.bb AND (a>b-2 AND ad ---- 14 values hashing to 060c8961d4cff53963cd257a6eee9284 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 ---- 90 values hashing to bbd77b718f2719f7454986877792ef5e query IIII rowsort SELECT CASE WHEN a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, e, a FROM t1 ---- 120 values hashing to 3fa24bffa729a10cb7039b714b42e5d4 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 ---- 54 values hashing to 881857dc2c171a5b5629a1b02f5ace04 query IIIIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.b(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 ac OR c>d ---- 132 values hashing to 11730d9f03d7ecbc708a87dc3640c235 query IIIIII rowsort SELECT e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dc AND d>e ---- 12 values hashing to 9f73d785e22ab32232fd62d9ad1f340d 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 ab-2 AND at1.c AND x.d0 OR (a>b-2 AND at1.c AND x.dc ---- 26 values hashing to 153104bccece0f4b8983f53c4fce4711 query IIIIIII rowsort SELECT b, a+b*2+c*3, (a+b+c+d+e)/5, CASE WHEN ae ---- 77 values hashing to 6e95b47bb3fde264a5703ac9d978a586 query IIII rowsort SELECT CASE WHEN ab AND (e>a AND eb ---- 27 values hashing to c6c480f662d91f78cd743fd4c1283663 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.d0 AND b IS NOT NULL ---- 189 values hashing to 3b5e129e362e947f42addc2454cc9d00 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 ---- 138 values hashing to 99547f63b16be41e4b6d1ce1ecd6bbba 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 ---- 150 values hashing to 0a190d0a39d0986d864cdafb35899dec query IIIII rowsort SELECT d, (SELECT count(*) FROM t1 AS x WHERE x.bc ---- 13 values hashing to bf5f4ef7a0280c43b79f03405b636d31 query I rowsort SELECT d-e FROM t1 WHERE (e>a AND e=d+2) AND (a>b-2 AND at1.c AND x.db-2 AND a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, a-b, CASE WHEN ab ---- 72 values hashing to 82acf3b1c44d191e300317b99459564f query I rowsort SELECT a+b*2+c*3+d*4 FROM t1 ---- 30 values hashing to fd6d6825820cf653aceb2d72af4a5983 query IIIII rowsort SELECT c-d, a, b, d, b-c FROM t1 ---- 150 values hashing to 805631fbc56c324b76a9e5def0b20628 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.b0 AND (c<=d-2 OR c>=d+2) ---- 50 values hashing to 8b122e9905ab4554fac21a8adb7e15bb query IIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bb-2 AND at1.c AND x.d0 AND e+d BETWEEN a+b-10 AND c+130 ---- 10 values hashing to f554e1ec3679835b79c7b5798663cdfd query IIIII rowsort SELECT a+b*2+c*3+d*4+e*5, abs(a), c, CASE WHEN a0 OR (c<=d-2 OR c>=d+2) ---- 150 values hashing to 549a029db9acfbfd3deb7f78189f3707 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 ---- 75 values hashing to b90bf883e6dde333753b1eb5b7b41d7b 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(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(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.bt1.c AND x.d=d+2) ---- 50 values hashing to 1a25f2981afcfe3b90b78e5f46d408dd 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.db-2 AND ac ---- 10 values hashing to 97311a820c01f81122bd9a43101bb2b3 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.bc AND (c<=d-2 OR c>=d+2) ---- 16 values hashing to 955f14c539e3692f1b86ab3a24683a19 query IIIII rowsort SELECT d-e, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.dc ---- 65 values hashing to e3d9292d05db4167a92c6229e4caa760 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(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 ---- 72 values hashing to 370fe299a3734448a7be6672f01c3a94 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) ---- 50 values hashing to 07bc5bca23ad9ae8a819dfac639082fd query IIII rowsort SELECT CASE WHEN at1.c AND x.da AND ee ---- 60 values hashing to 82d16a26b3d57b3cc239c4f7a9593f7c query IIIIII rowsort SELECT CASE WHEN aa AND ec OR eb ---- 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(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 ---- 90 values hashing to c5fa723aa4e2c42050943e4693f1e923 query IIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.b(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE (e>c OR et1.c AND x.dd ---- 78 values hashing to eac728c6ddb91ccd31a0d1128417639c 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 ec ---- 52 values hashing to 7315fb2782e02a62e78599ef812d5d8e 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.bd OR b>c ---- 154 values hashing to 253db2ba2de764cddb828c61c33fa94b 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 ---- 12 values hashing to 61f4eb32e9f9cee66661e5545d3b1c99 query IIII rowsort SELECT a, a+b*2, a-b, (SELECT count(*) FROM t1 AS x WHERE x.be ---- 68 values hashing to 17710e7f1160312d5f85b00b3baef24b query IIIIII rowsort SELECT a+b*2+c*3, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.db ---- 119 values hashing to a928e4c940a05e1636f24ad9d8d056c5 query III rowsort SELECT a-b, abs(b-c), a+b*2+c*3 FROM t1 WHERE (a>b-2 AND aa AND ed ---- 54 values hashing to 750a489b4c6cdcd65e8153612541edb4 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 ---- 90 values hashing to a3cc5ce52e625e50e112a70b5afa9d9f query IIIII rowsort SELECT a+b*2, e, (SELECT count(*) FROM t1 AS x WHERE x.bt1.c AND x.d0 ---- 60 values hashing to 338667821f799dd406c1ce8fc2fcd75b 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.bt1.c AND x.db ---- 17 values hashing to 4a6c075c0bc5ddff6a754adcddbe79f2 query III rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.be ---- 33 values hashing to 03629e50bc54a9c68b8e0642de1d4b7f 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 ---- 39 values hashing to c01cb38d1477fb445451a60bccfb3148 query I rowsort SELECT a FROM t1 WHERE a IS NULL OR b IS NOT NULL ---- 27 values hashing to c6c480f662d91f78cd743fd4c1283663 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.de AND a>b ---- 36 values hashing to 64c7b21a3631601a574791d879f549c1 query II rowsort SELECT b, (a+b+c+d+e)/5 FROM t1 WHERE a>b ---- 34 values hashing to 69ba5ba7b54faa8998a04eb07686fe15 query I rowsort SELECT (a+b+c+d+e)/5 FROM t1 WHERE e+d BETWEEN a+b-10 AND c+130 ---- 107 127 query IIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.bb AND c BETWEEN b-2 AND d+2 AND (e>c OR e(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.be OR (a>b-2 AND ab ---- 51 values hashing to c1b4d722bbccd5388ce36d4da5a272fe query III rowsort SELECT b, d, b-c FROM t1 WHERE a IS NULL OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.bt1.c AND x.d=d+2) ---- 70 values hashing to 9a7478a4b8f1a1d7ee51ac83087d9623 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 ac OR e(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 ec OR (c<=d-2 OR c>=d+2) ---- 133 values hashing to eb09696995447bcf7629e722d6bce242 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 ---- 210 values hashing to 9b0beb9869ed0a96cfbcda0f59b83405 query I rowsort SELECT a FROM t1 ---- 30 values hashing to 9a6afb6b859fc856aafb6a7af11a38e4 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.bb-2 AND ac OR ee OR a>b ---- 75 values hashing to a4ce622cd218c8c4279544e5142a5f17 query IIIIIII rowsort SELECT CASE WHEN ac ---- 91 values hashing to 406047a5fba16f6298cc8865ceb16d6d query IIIII rowsort SELECT a+b*2, abs(b-c), CASE WHEN a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE (e>c OR eb-2 AND ab 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.be ---- 22 values hashing to 59fc2a0cb9d6eb15500b2a01873c9267 query IIIIIII rowsort SELECT b-c, (SELECT count(*) FROM t1 AS x WHERE x.bd ---- -2 18 208 NULL NULL NULL 1 query III rowsort SELECT b, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d(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 ec ---- 65 values hashing to 3e557fbf49bddf5af6346144a1ae8837 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 ed ---- 48 values hashing to 0e34bea3ef5254baecdfc598a768bad7 query IIIIIII rowsort SELECT abs(b-c), e, a+b*2, CASE WHEN a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, abs(b-c), (a+b+c+d+e)/5 FROM t1 ---- 180 values hashing to 6def4225a77ed61ec70dfdfab8f4294a query IIII rowsort SELECT b, CASE WHEN a=d+2) OR coalesce(a,b,c,d,e)<>0 ---- 120 values hashing to aa50fc18d4fe0a775060a5289c7df0f1 query IIII rowsort SELECT abs(a), c, (a+b+c+d+e)/5, CASE WHEN a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, (a+b+c+d+e)/5 FROM t1 WHERE d>e ---- 77 values hashing to c2770ceec6cb227337e0706504a617e0 query IIIII rowsort SELECT c, a-b, a+b*2+c*3+d*4+e*5, e, abs(a) FROM t1 ---- 150 values hashing to a14b7f2ccb8b1fae67646b4fb3b5113b 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 ---- 120 values hashing to 02413ad3886e868d10e60923c66d937b 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 ---- 88 values hashing to 812e25e42aa220948974f1eec8a1ddf1 query IIII rowsort SELECT a+b*2+c*3, a+b*2, CASE WHEN ac OR ee 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.d0 OR b>c ---- 150 values hashing to 1e4b4b28a8b6a2e471e50ea659610358 query IIIIIII rowsort SELECT b-c, a, (a+b+c+d+e)/5, c-d, a+b*2+c*3, CASE WHEN at1.c AND x.dc OR e(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 ---- 90 values hashing to ac4a1d203ab70c5087569113ced7147f query I rowsort SELECT c FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.bd OR a>b ---- 29 values hashing to 725eda52ed4dea9e7b98db61d7453ca7 query III rowsort SELECT a+b*2+c*3+d*4, b, abs(a) FROM t1 ---- 90 values hashing to dfaa311be6dc8e4d21f0120e3a099cf0 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(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE b>c ---- 52 values hashing to 8a4f59d60224b0bb54df3d8b9940b67f 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.db-2 AND ae OR b>c ---- 100 values hashing to 8037b1bcfe636f3ff495bfd825d53e0d 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 ---- 39 values hashing to 841a895d7644c667c2fad00c7f68e8e5 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 ec OR e+d BETWEEN a+b-10 AND c+130 ---- 25 values hashing to 152789c2cc255e73e1326c66cc7fb1e3 query III rowsort SELECT d-e, a, d FROM t1 WHERE (e>c OR ec OR e(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, e FROM t1 WHERE b IS NOT NULL ---- 81 values hashing to 0640407785b3503fdb251a182b6d57ab 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 ---- 150 values hashing to 632b4850194bf60509de90f1feabfb2a 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.dt1.c AND x.d(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(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 ---- 50 values hashing to ac4b616ec0c322bb2be9a742fbc3e1b4 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 ---- 20 values hashing to 02253cc820958e19bdcdc9135a965d7c 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.dd ---- 24 values hashing to 82a9f46f2908306f2348047b589eeac0 query II rowsort SELECT c-d, e FROM t1 WHERE coalesce(a,b,c,d,e)<>0 ---- 60 values hashing to 588535d9ebc6d149a7057b9468ce599d query IIIII rowsort SELECT a+b*2+c*3+d*4, d-e, abs(a), a+b*2, c FROM t1 ---- 150 values hashing to 6e1d4a7fb7f2779d84fb3030fdecb95a query I rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d0 OR (c<=d-2 OR c>=d+2) ---- 30 values hashing to ec9f02c46c399db521c47dd9cb6a40dd query IIIIII rowsort SELECT a-b, a+b*2+c*3+d*4+e*5, a+b*2, CASE WHEN a(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, (a+b+c+d+e)/5 FROM t1 WHERE (e>c OR ec OR ed ---- 78 values hashing to 601783bc6cee105e35b85bffdefdabf0 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 ec AND (e>a AND e0 ---- 180 values hashing to d18f2b7889b1931bf2ad6e5c5b5d4434 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 ---- 154 values hashing to f2c0443c634f22d927709c9df7248cb4 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.bb AND c>d AND b IS NOT NULL ---- 20 values hashing to bd0a4f265ee4fa29a213395d83a0776d query I rowsort SELECT c FROM t1 WHERE (e>a AND e(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.be AND c>d ---- 10 values hashing to 2832b4b5ac653f653d22d7f12a93cf9e 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 ---- -1 -1 -1 -3 1 query IIIII rowsort SELECT e, a-b, b-c, d-e, (SELECT count(*) FROM t1 AS x WHERE x.ba AND e=d+2) OR c BETWEEN b-2 AND d+2 ---- 95 values hashing to 451208c9117faf9f6575928cd5fcbcf3 query III rowsort SELECT d-e, a-b, b-c FROM t1 ---- 90 values hashing to 864c4406e97c2f59c84ce3ca396d1ab8 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.bd OR d>e ---- 114 values hashing to e60614d0810e9d20d1ba7d5ec76faae4 query III rowsort SELECT a+b*2+c*3, CASE WHEN at1.c AND x.db-2 AND ad ---- 51 values hashing to 6257dc95c2d19fe398936dcf19cc0fd7 query IIIIIII rowsort SELECT c, a+b*2+c*3, CASE WHEN at1.c AND x.d=d+2) OR d NOT BETWEEN 110 AND 150 ---- 133 values hashing to 17d275371a37f40f92cc7a00385ceef1 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+2) OR c BETWEEN b-2 AND d+2 OR a>b ---- 84 values hashing to dddaa7a5327df8e332800a2692c9fd3c query IIII rowsort SELECT a+b*2+c*3+d*4, (SELECT count(*) FROM t1 AS x WHERE x.bb-2 AND ac ---- 24 values hashing to 4322e1fd1ebd79c0adcf73292b568d18 query IIIIII rowsort SELECT a+b*2+c*3, a+b*2, e, c, abs(a), CASE WHEN ac OR ed ---- 48 values hashing to e123674e3f83b126ddc91ddfb4ec283e query IIIIII rowsort SELECT d, CASE WHEN at1.c AND x.dc OR ed ---- 52 values hashing to 953d2bddf44b39d6a8131c7e0d8527ab query I rowsort SELECT (a+b+c+d+e)/5 FROM t1 WHERE (e>c OR e(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE c>d ---- 91 values hashing to 45e6f78c344e1febadcfb399ccdb77d0 query IIIIII rowsort SELECT a+b*2+c*3, CASE WHEN ae AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, (SELECT count(*) FROM t1 AS x WHERE x.b(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 ---- 150 values hashing to 5db6c9ec6926b5c79fc5e8a4c523abc4 query I rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.de ---- 11 values hashing to be1fb32359cadf053dc7743dd3945178 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) ---- 12 values hashing to e170e72ed3c6c65f197d2de7a3c22834 query I rowsort SELECT a-b FROM t1 ---- 30 values hashing to a8508bcdf86e494dd5feccb5ca8d9768 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.bc OR c>d ---- 140 values hashing to d4f3b53d6c183b6326b0c2564db94ea0 query IIII rowsort SELECT c-d, (SELECT count(*) FROM t1 AS x WHERE x.bb-2 AND ac ---- 104 values hashing to cd111f29f5f7f36e2a77b27e33dbd004 query IIIIIII rowsort SELECT CASE WHEN a(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 aa AND e=d+2) OR b>c ---- 57 values hashing to 886592d9da106aa25f38a55801e8ac69 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 ac OR e+d BETWEEN a+b-10 AND c+130 OR (a>b-2 AND ac AND (a>b-2 AND at1.c AND x.da AND et1.c AND x.d(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 ---- 105 values hashing to ab84430c78ddb8d0d0d19474da34643f 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.dd 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 a0 ---- 14 values hashing to 618c86d29c136607a70868aa0904aa06 query II rowsort SELECT b-c, abs(a) FROM t1 WHERE coalesce(a,b,c,d,e)<>0 OR (e>a AND e=d+2) OR (e>a AND e0 ---- 30 values hashing to c5a2b847c6c21100b32db39349809b0e 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.b0 ---- NULL NULL query IIIII rowsort SELECT e, a+b*2, CASE WHEN at1.c AND x.d(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, d-e FROM t1 ---- 210 values hashing to b4a7869dee46edfc2130eb57eeddd3e2 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.dd ---- 40 values hashing to 37a6d88bfb16420fe6ffcfb0389bb483 query I rowsort SELECT abs(a) FROM t1 WHERE c>d ---- 13 values hashing to 7d6be458c1183d1520b654a8117570fe query IIII rowsort SELECT e, a+b*2, c, d-e FROM t1 ---- 120 values hashing to 8229fc62414ac478d35fc865e46beba5 query IIII rowsort SELECT d-e, d, a, a+b*2 FROM t1 ---- 120 values hashing to 75f1c2193cc02c75e60ae3b6c925a916 query I rowsort SELECT a FROM t1 WHERE c>d ---- 13 values hashing to 7d6be458c1183d1520b654a8117570fe 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 ---- 102 values hashing to 12665cbcc870eefa3f4cc0d11a9991d5 query III rowsort SELECT CASE WHEN a0 ---- 90 values hashing to 23c4156570b0b850e857e907cadd7306 query IIIII rowsort SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.db-2 AND ac OR eb ---- 25 values hashing to 2378cc3c476ffe4a8e946543b42a9d9d 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.db OR (a>b-2 AND a=d+2) AND a IS NULL AND c>d ---- query IIII rowsort SELECT b, d-e, a+b*2, b-c FROM t1 ---- 120 values hashing to 373df092a93b28b07e7af72a6365b90e 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 ec ---- 91 values hashing to 0ad92c52d72f7b62755150d1cc34a4ef 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 ---- 168 values hashing to 8781330a228647b4efdfd2abbccd3f93 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) ---- 210 values hashing to e7395b6a397534eb6c79b00a6cbf5faf 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 ---- 150 values hashing to 56327e383a710587cd5f4205603ee4bc 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.ba AND e0 ---- 120 values hashing to 978da2a4ac397e44e638d685b7e1de7d 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.bb AND (e>a AND eb-2 AND a0 AND b IS NOT NULL ---- 27 values hashing to 726c5ed379e4b774e40e82e6dbdde380 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 ---- -2 1 -3 4 query IIIIII rowsort SELECT (a+b+c+d+e)/5, e, c-d, a+b*2+c*3, CASE WHEN a0 OR a IS NULL ---- 180 values hashing to 4a09d612e6ee25eb68bd8c0060901f36 query II rowsort SELECT a-b, a FROM t1 WHERE c>d ---- 26 values hashing to 9de411d9f4f9b07040f9b8f63b6e432c 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 ---- 232 3473 3 698 555 231 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 ---- 16 values hashing to 393ec0319f60a4bcad062e8ed256490f