You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by zs...@apache.org on 2022/09/20 05:50:51 UTC
[ignite-3] branch main updated: IGNITE-17667 Divide long test into suitable parts - Fixes #1071.
This is an automated email from the ASF dual-hosted git repository.
zstan pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/ignite-3.git
The following commit(s) were added to refs/heads/main by this push:
new 2fef41a481 IGNITE-17667 Divide long test into suitable parts - Fixes #1071.
2fef41a481 is described below
commit 2fef41a481741c55293c3fd9700322fbe402dfa9
Author: zstan <st...@gmail.com>
AuthorDate: Tue Sep 20 08:50:01 2022 +0300
IGNITE-17667 Divide long test into suitable parts - Fixes #1071.
Signed-off-by: zstan <st...@gmail.com>
---
.../sql/sqlite/select1/select1.test_slow | 2684 --------------------
.../sql/sqlite/select1/select1_p1.test | 275 ++
.../sql/sqlite/select1/select1_p2.test | 191 ++
.../sql/sqlite/select1/select1_p3.test_ignored | 859 +++++++
.../sql/sqlite/select1/select1_p4.test_ignored | 441 ++++
.../sql/sqlite/select1/select1_p5.test_ignored | 551 ++++
.../sql/sqlite/select1/select1_p6.test_ignored | 212 ++
.../sql/sqlite/select1/select1_p7.test_ignored | 333 +++
.../sql/sqlite/select1/select1_p8.test_ignored | 485 ++++
9 files changed, 3347 insertions(+), 2684 deletions(-)
diff --git a/modules/runner/src/integrationTest/sql/sqlite/select1/select1.test_slow b/modules/runner/src/integrationTest/sql/sqlite/select1/select1.test_slow
deleted file mode 100644
index e7e135c29a..0000000000
--- a/modules/runner/src/integrationTest/sql/sqlite/select1/select1.test_slow
+++ /dev/null
@@ -1,2684 +0,0 @@
-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(103,102,100,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,111,113)
-
-statement ok
-INSERT INTO t1(d,c,e,a,b) VALUES(116,119,117,115,118)
-
-statement ok
-INSERT INTO t1(c,d,b,e,a) VALUES(123,122,124,120,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,148,147)
-
-statement ok
-INSERT INTO t1(b,c,a,d,e) VALUES(151,150,153,154,152)
-
-statement ok
-INSERT INTO t1(c,e,a,d,b) VALUES(155,157,159,156,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,169,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,178,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(200,202,203,201,204)
-
-statement ok
-INSERT INTO t1(c,e,a,b,d) VALUES(208,209,205,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,235,238)
-
-statement ok
-INSERT INTO t1(e,c,b,a,d) VALUES(242,244,240,243,241)
-
-statement ok
-INSERT INTO t1(e,d,c,b,a) VALUES(246,248,247,249,245)
-
-query IIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c,
- (a+b+c+d+e)/5,
- a+b*2,
- c-d
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- AND e+d BETWEEN a+b-10 AND c+130
- AND d NOT BETWEEN 110 AND 150
- ORDER BY 5,3,2,4,1
-----
-
-query IIIIIII nosort
-SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- a+b*2+c*3+d*4+e*5,
- a,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d
- FROM t1
- WHERE a>b
- AND (e>a AND e<b)
- ORDER BY 7,2,4,6,1,3,5
-----
-
-query II nosort
-SELECT b-c,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- AND (e>c OR e<d)
- AND c>d
- ORDER BY 2,1
-----
--3
-0
--1
-0
--1
-0
-
-query I nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (e>c OR e<d)
- AND e+d BETWEEN a+b-10 AND c+130
- AND d>e
- ORDER BY 1
-----
-0
-0
-0
-
-query IIII nosort
-SELECT c-d,
- abs(b-c),
- e,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE a>b
- AND e+d BETWEEN a+b-10 AND c+130
- AND (e>a AND e<b)
- ORDER BY 3,4,1,2
-----
-
-query II nosort
-SELECT c-d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- AND a>b
- AND (e>a AND e<b)
- ORDER BY 2,1
-----
-
-query II nosort
-SELECT c,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE b>c
- AND (e>a AND e<b)
- AND d>e
- ORDER BY 1,2
-----
-247
-0
-
-query III nosort
-SELECT a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- AND (a>b-2 AND a<b+2)
- AND c>d
- ORDER BY 1,2,3
-----
-
-query IIIIII nosort
-SELECT a,
- a+b*2+c*3,
- abs(a),
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- a-b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (e>a AND e<b)
- AND e+d BETWEEN a+b-10 AND c+130
- AND (e>c OR e<d)
- ORDER BY 4,2,5,1,3,6
-----
-
-query IIIII nosort
-SELECT a,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- b-c,
- a-b,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR a>b
- OR b>c
- ORDER BY 1,4,3,2,5
-----
-145 values hashing to 65042db64d506f67a37c85f825cdd11f
-
-query IIII nosort
-SELECT a+b*2+c*3+d*4,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- ORDER BY 4,2,1,3
-----
-60 values hashing to a2af299d7b2197866b7c8f6854b77ab5
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(b-c),
- a+b*2+c*3+d*4,
- (a+b+c+d+e)/5,
- d-e,
- a+b*2+c*3+d*4+e*5
- FROM t1
- WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- ORDER BY 1,6,2,4,5,3
-----
-174 values hashing to 05379a2f92dfafe9d9f27b43b2da99a1
-
-query IIIIIII nosort
-SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- d-e,
- b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a-b,
- a,
- e
- FROM t1
- ORDER BY 4,5,1,3,7,6,2
-----
-210 values hashing to 8d6b363f389996a9821b4e3809779f76
-
-query III nosort
-SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- a+b*2,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (e>c OR e<d)
- ORDER BY 2,1,3
-----
-81 values hashing to f73fa4ec254d735c86e5741004f72034
-
-query II nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4+e*5
- FROM t1
- WHERE (e>a AND e<b)
- OR (c<=d-2 OR c>=d+2)
- OR e+d BETWEEN a+b-10 AND c+130
- ORDER BY 2,1
-----
-38 values hashing to 6b17e3a64ebbafbdf4ec543abf34d414
-
-query IIIII nosort
-SELECT a,
- d,
- a+b*2+c*3+d*4+e*5,
- a-b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR (a>b-2 AND a<b+2)
- OR b>c
- ORDER BY 1,3,5,4,2
-----
-140 values hashing to 3dfb60ce29bfaa3deb2c90771787ae28
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3,
- d-e,
- b,
- a,
- c,
- a+b*2
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- OR (e>a AND e<b)
- OR d>e
- ORDER BY 5,6,3,7,2,1,4
-----
-154 values hashing to 7be42f68cbfeb20d2a574569eabc62b8
-
-query IIIIIII nosort
-SELECT b-c,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- a+b*2,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(a),
- c-d,
- d
- FROM t1
- WHERE b>c
- OR d NOT BETWEEN 110 AND 150
- OR (e>c OR e<d)
- ORDER BY 4,6,5,1,3,7,2
-----
-203 values hashing to 449a18d19874d7ee976c4c9fc953e3f4
-
-query III nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- (a+b+c+d+e)/5,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR (c<=d-2 OR c>=d+2)
- OR c>d
- ORDER BY 1,3,2
-----
-81 values hashing to 3bd0cf1b195cb05eea3e0621c5a4f38e
-
-query IIIII nosort
-SELECT a+b*2,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c-d,
- a+b*2+c*3
- FROM t1
- WHERE d>e
- ORDER BY 4,2,1,5,3
-----
-80 values hashing to 06c104cf923af770f3cf98700c2428d0
-
-query IIIIII nosort
-SELECT a+b*2,
- (a+b+c+d+e)/5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- abs(b-c),
- a-b
- FROM t1
- WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- AND c>d
- ORDER BY 6,5,4,1,3,2
-----
-78 values hashing to f8b104ce0c1d6a8d02976b512c224c33
-
-query III nosort
-SELECT (a+b+c+d+e)/5,
- a+b*2,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (e>c OR e<d)
- OR b>c
- ORDER BY 2,1,3
-----
-84 values hashing to aa77bd3dacaadb8d94850b7457313394
-
-query IIIIIII nosort
-SELECT c-d,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- a+b*2,
- a,
- abs(b-c),
- a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR b>c
- ORDER BY 3,5,4,2,6,7,1
-----
-196 values hashing to ce60e2883fe7a0c41c29c17e9b62bf51
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- abs(a),
- a+b*2+c*3+d*4+e*5,
- d-e,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- OR d>e
- OR b>c
- ORDER BY 2,3,1,5,4,6
-----
-150 values hashing to c31247552305ea7108b6c15517e4e50e
-
-query IIIIIII nosort
-SELECT a+b*2,
- a+b*2+c*3+d*4+e*5,
- b,
- c-d,
- abs(b-c),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- ORDER BY 5,1,4,7,3,2,6
-----
-210 values hashing to 24fae43b38fe9736d9fc79f183773c0f
-
-query IIIII nosort
-SELECT b-c,
- c,
- d-e,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- (a+b+c+d+e)/5
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- OR d NOT BETWEEN 110 AND 150
- OR b>c
- ORDER BY 3,5,4,2,1
-----
-140 values hashing to db6ada3c6b4c6105c96c56f98bd679d1
-
-query III nosort
-SELECT b,
- d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE b>c
- ORDER BY 1,2,3
-----
-42 values hashing to fdf2c9075b2487f82c8ad837755619d7
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c-d,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- d-e,
- a+b*2+c*3+d*4,
- c,
- a+b*2
- FROM t1
- ORDER BY 7,3,2,6,4,5,1
-----
-210 values hashing to 295b9d736969e666ddf559dd8479c415
-
-query II nosort
-SELECT d-e,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- ORDER BY 1,2
-----
-22 values hashing to 1e52dd7b5731c2e28fbbaa8fccc86f65
-
-query II nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d
- FROM t1
- ORDER BY 1,2
-----
-60 values hashing to aae77ef6a7bbfce44e353697e1736636
-
-query IIIIII nosort
-SELECT a,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4+e*5,
- d,
- a+b*2+c*3
- FROM t1
- WHERE b>c
- AND (c<=d-2 OR c>=d+2)
- AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- ORDER BY 2,3,1,6,4,5
-----
-42 values hashing to 8ce8889165dbfc2a153b8e41d6eac176
-
-query IIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4+e*5,
- c-d,
- d
- FROM t1
- WHERE d NOT BETWEEN 110 AND 150
- ORDER BY 1,3,4,2
-----
-88 values hashing to 271cfc0737d448d8e0ae9b778205fcad
-
-query IIII nosort
-SELECT a+b*2+c*3,
- c-d,
- a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE d>e
- OR (c<=d-2 OR c>=d+2)
- OR c BETWEEN b-2 AND d+2
- ORDER BY 1,2,4,3
-----
-108 values hashing to 709932df0abe61ded2f95a3b2b8e9c34
-
-query IIIIIII nosort
-SELECT (a+b+c+d+e)/5,
- 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,
- a,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4+e*5
- FROM t1
- ORDER BY 3,5,1,2,7,4,6
-----
-210 values hashing to d312440b05a05bd531e9e6b7ad183255
-
-query IIIIIII nosort
-SELECT c,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- a+b*2,
- e,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- b-c,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- AND d>e
- AND d NOT BETWEEN 110 AND 150
- ORDER BY 7,2,1,5,6,4,3
-----
-14 values hashing to d8e81dbe9389b8a7fb955726d1018688
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- e,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (a+b+c+d+e)/5,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- d,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
- FROM t1
- WHERE a>b
- ORDER BY 7,6,5,2,1,3,4
-----
-133 values hashing to e0e2d07862532072e37e60225da99516
-
-query IIIIII nosort
-SELECT e,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- a-b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE a>b
- AND (c<=d-2 OR c>=d+2)
- AND c>d
- ORDER BY 6,5,4,2,3,1
-----
-18 values hashing to 7b37fd650c93c3580d86ed2112de3518
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- e,
- a+b*2+c*3+d*4,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- a+b*2+c*3,
- abs(a),
- c-d
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR (e>c OR e<d)
- ORDER BY 1,4,2,5,7,3,6
-----
-189 values hashing to 225b9220120f5debc0a77757e6a544a7
-
-query IIIII nosort
-SELECT a+b*2,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- b,
- c,
- abs(a)
- FROM t1
- WHERE d>e
- ORDER BY 1,3,2,4,5
-----
-80 values hashing to 4cf6188a63134ebf831c245aed6fd46d
-
-query IIIII nosort
-SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- e,
- a+b*2+c*3,
- c
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- OR d>e
- ORDER BY 3,4,2,5,1
-----
-110 values hashing to 7c7ca7dc3909bad67db7afb2ce90ee58
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(a),
- a-b,
- a+b*2+c*3,
- d-e,
- b,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END
- FROM t1
- WHERE d NOT BETWEEN 110 AND 150
- AND (c<=d-2 OR c>=d+2)
- ORDER BY 1,5,6,2,4,7,3
-----
-91 values hashing to e0fe8de872329c82af624de95132584e
-
-query IIII nosort
-SELECT a+b*2+c*3+d*4,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- a,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE c>d
- ORDER BY 4,1,3,2
-----
-56 values hashing to 68bfd05b60394ed25ff6ddecdef16e10
-
-query IIIIIII nosort
-SELECT b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c-d,
- b-c,
- a+b*2+c*3+d*4,
- c,
- abs(a)
- FROM t1
- WHERE d>e
- ORDER BY 2,1,4,5,6,3,7
-----
-112 values hashing to 7d1953113f7f07c9266eb09edadd82f9
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- abs(a),
- d,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- a,
- a+b*2
- FROM t1
- WHERE d NOT BETWEEN 110 AND 150
- AND (a>b-2 AND a<b+2)
- ORDER BY 5,6,3,1,2,4,7
-----
-49 values hashing to d9af3c86c55045321eccea3c3f39b048
-
-query IIII nosort
-SELECT abs(a),
- a+b*2+c*3+d*4,
- a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE b>c
- OR (e>a AND e<b)
- ORDER BY 2,4,1,3
-----
-64 values hashing to ad2644ea3960ffbe041c9a505773a231
-
-query IIIIIII nosort
-SELECT c-d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(a),
- d-e,
- b,
- abs(b-c),
- a+b*2+c*3
- FROM t1
- ORDER BY 6,1,4,2,5,3,7
-----
-210 values hashing to 029d94ade68a27ab16900e1e1f6f3c54
-
-query IIIIIII nosort
-SELECT c,
- c-d,
- a+b*2+c*3+d*4,
- a+b*2+c*3+d*4+e*5,
- abs(b-c),
- (a+b+c+d+e)/5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE d NOT BETWEEN 110 AND 150
- AND a>b
- AND c>d
- ORDER BY 7,1,5,3,2,4,6
-----
-42 values hashing to 719b82439155e612b0a13ee9e8496dea
-
-query IIIII nosort
-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,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- ORDER BY 2,4,5,1,3
-----
-30 values hashing to 7f66566999f88b34321d64aafb17b34d
-
-query IIII nosort
-SELECT a,
- abs(a),
- (a+b+c+d+e)/5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 3,1,2,4
-----
-120 values hashing to 322fbb90672f08ec55b91dd2b85b8bc5
-
-query IIIII nosort
-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,
- abs(a),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a
- FROM t1
- ORDER BY 2,4,5,1,3
-----
-150 values hashing to 3d333b73ba68315675c5463fb4536269
-
-query IIIIII nosort
-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,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(b-c),
- b-c,
- a+b*2+c*3
- FROM t1
- WHERE (e>c OR e<d)
- AND (c<=d-2 OR c>=d+2)
- AND c BETWEEN b-2 AND d+2
- ORDER BY 2,5,4,6,3,1
-----
-60 values hashing to 755f345cafbb73c0340e12a2580bb1e8
-
-query IIIIII nosort
-SELECT a,
- a+b*2+c*3,
- a+b*2+c*3+d*4+e*5,
- c-d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- OR d NOT BETWEEN 110 AND 150
- ORDER BY 2,4,5,6,1,3
-----
-156 values hashing to 7133d2c62ac44540d9e489748fb517d0
-
-query IIIIIII nosort
-SELECT a+b*2+c*3,
- c,
- b-c,
- a+b*2+c*3+d*4,
- a,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- (a+b+c+d+e)/5
- FROM t1
- WHERE (e>c OR e<d)
- AND c BETWEEN b-2 AND d+2
- AND (e>a AND e<b)
- ORDER BY 7,5,3,2,6,4,1
-----
-14 values hashing to 6ae7f7555d748317d1f77e0f76a877fc
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- e,
- abs(a),
- c-d,
- a,
- b-c
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- OR (c<=d-2 OR c>=d+2)
- OR d NOT BETWEEN 110 AND 150
- ORDER BY 7,1,5,3,4,6,2
-----
-196 values hashing to 3f2cca604f78daaa5c238d7f0fa01745
-
-query IIIIII nosort
-SELECT a+b*2+c*3+d*4,
- d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- c,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
- FROM t1
- WHERE a>b
- OR (e>a AND e<b)
- ORDER BY 4,6,2,5,1,3
-----
-138 values hashing to 226c6ba76feacd2b0d92d3dee611399d
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- b,
- a,
- a+b*2+c*3+d*4+e*5,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- a+b*2+c*3
- FROM t1
- WHERE a>b
- AND (e>c OR e<d)
- ORDER BY 3,7,2,5,6,4,1
-----
-126 values hashing to a3c1afa7c92832ab10d89a3cdd218e17
-
-query IIIII nosort
-SELECT a+b*2+c*3+d*4,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
- FROM t1
- ORDER BY 4,5,3,2,1
-----
-150 values hashing to 41a342f4212e2a14116ba83427e049be
-
-query II nosort
-SELECT b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (e>a AND e<b)
- OR c>d
- ORDER BY 1,2
-----
-30 values hashing to 907d0240f42a1141b7870e0424b0dd04
-
-query III nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(a),
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- AND c>d
- ORDER BY 1,3,2
-----
-9 values hashing to 0598e89fd314145ba8f06f228456f4ba
-
-query IIIIIII nosort
-SELECT a-b,
- d,
- a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- (a+b+c+d+e)/5,
- b,
- d-e
- FROM t1
- ORDER BY 1,5,3,7,4,6,2
-----
-210 values hashing to e2f7b27ca407bf9df4acb3be08c64524
-
-query IIIIII nosort
-SELECT abs(b-c),
- (a+b+c+d+e)/5,
- d,
- b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c
- FROM t1
- ORDER BY 4,6,2,1,5,3
-----
-180 values hashing to e636f30eea1a3449e5944de44985d2c5
-
-query IIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c,
- a,
- (a+b+c+d+e)/5
- FROM t1
- ORDER BY 2,3,1,4
-----
-120 values hashing to 62c5856425278965c1b1a7b2686bb1a4
-
-query IIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- d,
- (a+b+c+d+e)/5
- FROM t1
- WHERE (e>a AND e<b)
- AND (c<=d-2 OR c>=d+2)
- ORDER BY 3,2,1,4
-----
-12 values hashing to fae09a9a32247b430470a8b81fbc6cc9
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c-d,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- c,
- d,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- OR c>d
- ORDER BY 1,2,4,5,6,3
-----
-102 values hashing to 1a7c46130532fbc982bba080af7ee291
-
-query IIIIIII nosort
-SELECT a+b*2+c*3,
- abs(a),
- 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,
- d-e,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE d NOT BETWEEN 110 AND 150
- AND (e>a AND e<b)
- ORDER BY 1,5,3,4,6,2,7
-----
-21 values hashing to d87da634fb840b1c06fbe4a9044e809d
-
-query II nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- b
- FROM t1
- ORDER BY 1,2
-----
-60 values hashing to 15596791cdb51704f8ab6f597e39790d
-
-query I nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 1
-----
-30 values hashing to ec9f02c46c399db521c47dd9cb6a40dd
-
-query IIIII nosort
-SELECT a-b,
- c-d,
- a+b*2+c*3+d*4+e*5,
- c,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 1,4,3,2,5
-----
-150 values hashing to 034d9cdf4634c24ca574f76ba23ed550
-
-query IIIIII nosort
-SELECT b-c,
- a-b,
- abs(a),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- 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
- WHERE b>c
- OR (a>b-2 AND a<b+2)
- ORDER BY 4,3,1,5,6,2
-----
-114 values hashing to d289034237130317cf469cf3bc27c879
-
-query IIIII nosort
-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.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4,
- b
- FROM t1
- WHERE c>d
- OR d>e
- ORDER BY 2,5,1,3,4
-----
-120 values hashing to 6b7c62f6dba560a1b1cfb4a0de687636
-
-query IIIIIII nosort
-SELECT 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,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4+e*5,
- e,
- (a+b+c+d+e)/5
- FROM t1
- ORDER BY 6,5,1,7,2,3,4
-----
-210 values hashing to 0b9d7c7d7a7c7cc0a5d90f1990a043e9
-
-query IIII nosort
-SELECT c,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- a+b*2+c*3+d*4
- FROM t1
- WHERE b>c
- OR (e>c OR e<d)
- OR d NOT BETWEEN 110 AND 150
- ORDER BY 3,2,1,4
-----
-116 values hashing to 033ab3b385a760384a80f7c2f8116b27
-
-query IIIIIII nosort
-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,
- a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a,
- d-e,
- e
- FROM t1
- ORDER BY 4,3,2,1,5,7,6
-----
-210 values hashing to 72748aa05256149f5b609735556600ee
-
-query IIIIIII nosort
-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,
- a+b*2,
- a+b*2+c*3,
- a+b*2+c*3+d*4,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(b-c)
- FROM t1
- WHERE d NOT BETWEEN 110 AND 150
- ORDER BY 4,3,2,5,7,1,6
-----
-154 values hashing to 48148b8db7389fcfe7ce1305fd4c4baa
-
-query III nosort
-SELECT 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.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- ORDER BY 1,3,2
-----
-33 values hashing to 83af9d93602ea54fa991d265574a4c3a
-
-query IIIIIII nosort
-SELECT d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- (a+b+c+d+e)/5,
- a-b,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- c-d,
- d-e
- FROM t1
- WHERE b>c
- OR d NOT BETWEEN 110 AND 150
- ORDER BY 2,3,6,7,4,1,5
-----
-182 values hashing to 9bb679937b36be78dd530a683782d10a
-
-query II nosort
-SELECT (a+b+c+d+e)/5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- OR c BETWEEN b-2 AND d+2
- OR (a>b-2 AND a<b+2)
- ORDER BY 2,1
-----
-60 values hashing to 4ff348b6082ffad99447100b2c77aca6
-
-query I nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR c>d
- ORDER BY 1
-----
-25 values hashing to 3a8c1f92b5515a90e97181b7aaf6970b
-
-query IIIIII nosort
-SELECT (a+b+c+d+e)/5,
- a,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- b-c,
- a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- ORDER BY 6,4,5,1,2,3
-----
-66 values hashing to 80d5784436f12d6111be1755171b13d4
-
-query II nosort
-SELECT a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- ORDER BY 2,1
-----
-58 values hashing to 9646b8b8b446280ab97d4f5e30a51bae
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- abs(b-c),
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a-b,
- abs(a)
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- OR d>e
- OR c BETWEEN b-2 AND d+2
- ORDER BY 4,1,5,6,3,2
-----
-144 values hashing to 87705ab033397683288724d8d8a8303e
-
-query III nosort
-SELECT a,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(b-c)
- FROM t1
- ORDER BY 3,2,1
-----
-90 values hashing to ea5d42bf4b76916f27ca2207d5f3a1cb
-
-query III nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3,
- a-b
- FROM t1
- WHERE a>b
- AND (c<=d-2 OR c>=d+2)
- ORDER BY 3,1,2
-----
-30 values hashing to 6ad8accda9cddcf28817fbf053942483
-
-query IIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- d,
- a,
- a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- ORDER BY 2,5,3,1,4
-----
-110 values hashing to 76487e705db851d7db9ddf5ba8be0c56
-
-query III nosort
-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 c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE c>d
- ORDER BY 2,3,1
-----
-42 values hashing to 0b30094aec5125c1843b3e6e1e41a6e8
-
-query IIIIII nosort
-SELECT abs(b-c),
- c,
- b,
- (a+b+c+d+e)/5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d
- FROM t1
- WHERE d>e
- ORDER BY 6,5,3,1,2,4
-----
-96 values hashing to d43f79239513169ba12520f7a149dee7
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- 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,
- b-c,
- a+b*2+c*3+d*4,
- (a+b+c+d+e)/5
- FROM t1
- WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- AND (c<=d-2 OR c>=d+2)
- ORDER BY 5,1,2,4,3,6,7
-----
-105 values hashing to 6f1348d248b462331e2adebdb5140a95
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- a+b*2+c*3,
- a,
- (a+b+c+d+e)/5,
- b
- FROM t1
- WHERE b>c
- ORDER BY 4,2,6,5,3,7,1
-----
-98 values hashing to 9672e04e6af85e083efc6d3a01ad003c
-
-query IIII nosort
-SELECT a+b*2,
- a-b,
- a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 1,3,4,2
-----
-120 values hashing to aba88e7aab9b448d205e6978445e0e60
-
-query IIIII nosort
-SELECT a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- c,
- d
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- ORDER BY 4,5,2,1,3
-----
-55 values hashing to a7ad6c80c65b6fa1575e15a286ab717b
-
-query IIIIII nosort
-SELECT c,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- b-c,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- ORDER BY 6,3,1,2,4,5
-----
-132 values hashing to fd0adbb2bc4037a6ef6fcec0141f7aa1
-
-query IIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d-e,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- c
- FROM t1
- WHERE d>e
- OR a>b
- ORDER BY 4,3,2,1,5
-----
-125 values hashing to 9fcf17184ac87f3ca33f5aa74b552242
-
-query IIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- a+b*2
- FROM t1
- ORDER BY 1,3,4,2
-----
-120 values hashing to 9d8ae71d1d4851666a75fec8bc675773
-
-query IIIIII nosort
-SELECT c-d,
- a+b*2+c*3+d*4+e*5,
- b,
- (a+b+c+d+e)/5,
- a,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE d>e
- ORDER BY 4,5,6,1,3,2
-----
-96 values hashing to a762a09cf2fc3bb7b96a1bacd3516820
-
-query IIIII nosort
-SELECT a+b*2+c*3+d*4+e*5,
- d-e,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(b-c),
- c-d
- FROM t1
- ORDER BY 2,1,3,4,5
-----
-150 values hashing to 9fa5902ee5ef32c5318e0331bdd35651
-
-query III nosort
-SELECT a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- e
- FROM t1
- ORDER BY 3,1,2
-----
-90 values hashing to 81c7f303422ff0623fdd74a5b0bdbcd9
-
-query IIIIII nosort
-SELECT b,
- c,
- abs(a),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- b-c,
- e
- FROM t1
- ORDER BY 4,5,1,6,2,3
-----
-180 values hashing to 8c1ed130d0125560ee81e819bc8451af
-
-query IIIIIII nosort
-SELECT a+b*2+c*3+d*4,
- c-d,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- a+b*2,
- b,
- b-c,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 5,2,4,1,6,3,7
-----
-210 values hashing to ad750cadd33a9416af71d69c5fac509d
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- b-c,
- a,
- abs(a)
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- OR (c<=d-2 OR c>=d+2)
- OR d>e
- ORDER BY 3,5,6,2,1,7,4
-----
-196 values hashing to ab60be6b2b2d576e28c474ce597e7441
-
-query IIIIII nosort
-SELECT (a+b+c+d+e)/5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3,
- a,
- a-b,
- d
- FROM t1
- WHERE (e>a AND e<b)
- AND c BETWEEN b-2 AND d+2
- ORDER BY 6,1,2,3,5,4
-----
-12 values hashing to 01ab6b4f408df903621edf08828ba7a5
-
-query IIII nosort
-SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- a
- FROM t1
- ORDER BY 4,2,3,1
-----
-120 values hashing to cdadd86b806e762ee9d7d03f0058ff4a
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- d,
- c,
- a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (e>a AND e<b)
- ORDER BY 4,2,3,1,5,6
-----
-24 values hashing to 9e80b3c7e910457fc023a082297c66a6
-
-query IIIIII nosort
-SELECT e,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4+e*5,
- b,
- d-e,
- c
- FROM t1
- WHERE c>d
- AND d>e
- AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- ORDER BY 2,4,1,5,3,6
-----
-36 values hashing to 13898e32c711a65529fa502c0c91de6e
-
-query IIIIIII nosort
-SELECT e,
- abs(a),
- c-d,
- a,
- c,
- a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- ORDER BY 2,7,6,5,3,1,4
-----
-154 values hashing to 37f9bacc7a12ddc6b1beae763457ddda
-
-query IIII nosort
-SELECT abs(b-c),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d-e,
- a-b
- FROM t1
- ORDER BY 1,3,4,2
-----
-120 values hashing to dbf19b42301e4f161c0a991b57d13101
-
-query IIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- a-b,
- d-e
- FROM t1
- ORDER BY 1,4,3,2
-----
-120 values hashing to 5d82db974f8caa9127d640fcf6cc1a40
-
-query IIIII nosort
-SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a-b,
- (a+b+c+d+e)/5,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- ORDER BY 4,1,3,5,2
-----
-55 values hashing to 9b60d91226b0f2f8659270ea5306163d
-
-query IIIIII nosort
-SELECT a+b*2+c*3+d*4+e*5,
- a,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- e,
- d
- FROM t1
- WHERE b>c
- ORDER BY 6,2,5,4,3,1
-----
-84 values hashing to e05d2e123bb3c8af78b16346f8a4b290
-
-query IIII nosort
-SELECT a+b*2+c*3,
- d-e,
- c,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE d NOT BETWEEN 110 AND 150
- ORDER BY 1,2,4,3
-----
-88 values hashing to db4da1f3c45a5823d3ebc705f0762179
-
-query II nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
- FROM t1
- ORDER BY 2,1
-----
-60 values hashing to 85404c9e49e9c58a47120a703e4457da
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c-d,
- c,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- b,
- a+b*2+c*3
- FROM t1
- ORDER BY 4,2,1,3,5,6
-----
-180 values hashing to e80b8346172b01fad12a7248e5bbc7a4
-
-query IIIII nosort
-SELECT c-d,
- abs(a),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4,
- d
- FROM t1
- WHERE c>d
- AND (e>c OR e<d)
- ORDER BY 3,1,4,5,2
-----
-55 values hashing to 50319241cf069b222e20cb31cfb4f023
-
-query III nosort
-SELECT (a+b+c+d+e)/5,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 1,3,2
-----
-90 values hashing to 0c2274d4a8a3ec90ea6a28620767869e
-
-query IIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- abs(a),
- abs(b-c),
- b-c
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- OR d>e
- OR (a>b-2 AND a<b+2)
- ORDER BY 3,4,2,1,5
-----
-140 values hashing to 70533a0a1bba09436341d84b243a4d16
-
-query IIIII nosort
-SELECT abs(b-c),
- c-d,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- AND d>e
- AND c BETWEEN b-2 AND d+2
- ORDER BY 1,2,5,3,4
-----
-10 values hashing to d1f0237fc8125db019f7ae5fc6432c34
-
-query IIIIII nosort
-SELECT a+b*2+c*3+d*4,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- a+b*2+c*3+d*4+e*5,
- a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE c>d
- AND c BETWEEN b-2 AND d+2
- AND (e>c OR e<d)
- ORDER BY 6,2,5,4,1,3
-----
-66 values hashing to a8f6dd606793116aa2ce7b0e208adc9b
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- abs(b-c),
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- ORDER BY 3,1,6,4,2,5
-----
-132 values hashing to ec8164a205d1e3a7ff6159a6c54f9b38
-
-query III nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.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
- FROM t1
- ORDER BY 1,2,3
-----
-90 values hashing to 16f9d5fdf4a5fcefd72fd63af183a51a
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- a-b,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- 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+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 3,4,7,5,2,6,1
-----
-210 values hashing to 278b40264305ba138427722b9dcc7b78
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d-e,
- a+b*2+c*3,
- a-b,
- a+b*2+c*3+d*4+e*5,
- b-c
- FROM t1
- WHERE b>c
- AND a>b
- AND (c<=d-2 OR c>=d+2)
- ORDER BY 5,1,3,6,2,4
-----
-24 values hashing to 651f715b7e5976e9d63b17b91ea8d333
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(a),
- b-c,
- a-b,
- a,
- c-d
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- ORDER BY 3,6,1,2,4,5
-----
-36 values hashing to 101e7b5dd4d24f8db95eca3c47633127
-
-query IIII nosort
-SELECT d-e,
- b,
- b-c,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE d>e
- OR d NOT BETWEEN 110 AND 150
- OR c BETWEEN b-2 AND d+2
- ORDER BY 3,4,2,1
-----
-116 values hashing to 8a927705b4fec3a4b0d85784481196d6
-
-query IIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- d,
- c-d,
- a
- FROM t1
- ORDER BY 3,4,2,5,1
-----
-150 values hashing to 1effee3fa900abed1f10e47b0c1d1e65
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- e,
- a+b*2,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- a+b*2+c*3+d*4+e*5,
- a+b*2+c*3,
- c-d
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- ORDER BY 4,2,6,1,7,3,5
-----
-77 values hashing to a07d85e50adee8e8d352265890fa3df5
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(a),
- a+b*2+c*3+d*4,
- (a+b+c+d+e)/5,
- e,
- b,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- OR (a>b-2 AND a<b+2)
- OR b>c
- ORDER BY 2,1,3,7,5,4,6
-----
-154 values hashing to b9a9dc5ffa8928273db7bcd669c53cd7
-
-query IIIII nosort
-SELECT abs(a),
- e,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE a>b
- ORDER BY 4,1,5,2,3
-----
-95 values hashing to 19afe88a8ec0b6ac1a596dcfbe7a73ef
-
-query IIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d-e,
- b,
- a+b*2+c*3+d*4
- FROM t1
- ORDER BY 1,3,2,4
-----
-120 values hashing to 238444a65f715eb041390b17898802ba
-
-query III nosort
-SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 3,1,2
-----
-90 values hashing to d3e4cefb53c165b66f678c56a86c8314
-
-query IIIII nosort
-SELECT a+b*2+c*3+d*4+e*5,
- a,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d,
- abs(b-c)
- FROM t1
- WHERE d NOT BETWEEN 110 AND 150
- AND (e>a AND e<b)
- ORDER BY 1,3,5,4,2
-----
-15 values hashing to abd13e32a5a8a00bfe03cdf0f269bfc8
-
-query IIIII nosort
-SELECT a+b*2+c*3,
- d,
- a,
- a+b*2+c*3+d*4,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- ORDER BY 2,3,5,1,4
-----
-30 values hashing to a33bb527d06a2910c9a6c62eca6505b7
-
-query IIIII nosort
-SELECT b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- b-c,
- c,
- abs(b-c)
- FROM t1
- WHERE c>d
- AND (e>c OR e<d)
- AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- ORDER BY 1,3,2,5,4
-----
-50 values hashing to 3ee816fcef04a3eec0ebe12b5f6d1358
-
-query IIIIIII nosort
-SELECT abs(b-c),
- a+b*2,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c-d
- FROM t1
- ORDER BY 6,2,1,3,4,7,5
-----
-210 values hashing to 2086c3df1975d9993bfa394053028c8f
-
-query IIIIIII nosort
-SELECT (a+b+c+d+e)/5,
- a+b*2+c*3+d*4,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c-d,
- a+b*2+c*3+d*4+e*5,
- d
- FROM t1
- WHERE a>b
- AND c BETWEEN b-2 AND d+2
- ORDER BY 5,6,3,7,2,4,1
-----
-105 values hashing to 32404e31bbeb9f3a9e286caaf42683bf
-
-query IIIIIII nosort
-SELECT a+b*2+c*3,
- b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- abs(a),
- a+b*2,
- a
- FROM t1
- WHERE d>e
- OR c>d
- OR e+d BETWEEN a+b-10 AND c+130
- ORDER BY 6,2,1,7,5,4,3
-----
-175 values hashing to 1086608e130bcb51302b4bfea65791e1
-
-query II nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- c
- FROM t1
- WHERE (e>c OR e<d)
- ORDER BY 1,2
-----
-54 values hashing to e0a9aff1c8ce9380036deac54055bb55
-
-query III nosort
-SELECT a,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2
- FROM t1
- ORDER BY 1,2,3
-----
-90 values hashing to 23fade28502d6270c32ef8abb80c2587
-
-query IIII nosort
-SELECT abs(a),
- a-b,
- a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 4,2,1,3
-----
-120 values hashing to c0fb0d9f06fa5550406b035929522753
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- a+b*2,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- d,
- b
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR (e>a AND e<b)
- ORDER BY 6,3,1,5,4,2
-----
-144 values hashing to 8fcce962010f9d02b8f88fe335f942d6
-
-query III nosort
-SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
- FROM t1
- WHERE c>d
- OR c BETWEEN b-2 AND d+2
- OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- ORDER BY 2,3,1
-----
-90 values hashing to 622e9a88d60bdd5066c19a3843a170f7
-
-query I nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
- FROM t1
- WHERE a>b
- OR (e>a AND e<b)
- ORDER BY 1
-----
-23 values hashing to 170b11bfad55c44388691ff914c121af
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4+e*5,
- d,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- b-c,
- (a+b+c+d+e)/5
- FROM t1
- ORDER BY 1,3,6,2,5,4
-----
-180 values hashing to 76cb0f185711243083f4b8769f948815
-
-query IIIII nosort
-SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- c-d,
- abs(b-c),
- a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- AND a>b
- ORDER BY 4,1,5,3,2
-----
-35 values hashing to 3af25b67f93d88c1a5f7c4641a52f3f5
-
-query IIIIII nosort
-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,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- e,
- d,
- a-b
- FROM t1
- ORDER BY 2,3,4,5,6,1
-----
-180 values hashing to dd0992af784793780e0941bfc46d5c17
-
-query IIIIII nosort
-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,
- d-e,
- c-d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(b-c)
- FROM t1
- WHERE b>c
- ORDER BY 6,5,3,2,4,1
-----
-84 values hashing to 4eacead92f2a04db9b0334482576382b
-
-query IIIIII nosort
-SELECT a-b,
- d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3,
- a+b*2+c*3+d*4+e*5,
- (a+b+c+d+e)/5
- FROM t1
- WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- OR b>c
- ORDER BY 1,4,2,5,6,3
-----
-174 values hashing to 742703bb047dc6b6254470d20be52ae0
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- c,
- a+b*2+c*3+d*4+e*5,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d
- FROM t1
- WHERE b>c
- AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- AND (e>c OR e<d)
- ORDER BY 6,2,1,3,5,4
-----
-78 values hashing to 2bc2b9f40afbeff305b8b1bbb990f54d
-
-query IIIII nosort
-SELECT a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- e,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- abs(b-c)
- FROM t1
- WHERE c>d
- AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- AND e+d BETWEEN a+b-10 AND c+130
- ORDER BY 4,3,5,2,1
-----
-10 values hashing to 2d123a0355480421449ef9e36dafe214
-
-query III nosort
-SELECT a+b*2+c*3+d*4,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a
- FROM t1
- ORDER BY 1,2,3
-----
-90 values hashing to d8520212db20c57541d0c28d4fddae94
-
-query IIIIII nosort
-SELECT abs(a),
- e,
- c-d,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- AND b>c
- ORDER BY 5,3,6,1,4,2
-----
-48 values hashing to 603d52ce942c28eb4f224d7e9ea74524
-
-query II nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END
- FROM t1
- WHERE a>b
- OR c BETWEEN b-2 AND d+2
- OR (a>b-2 AND a<b+2)
- ORDER BY 2,1
-----
-52 values hashing to fb874a11725bff133c5555192c29d1d4
-
-query II nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(a)
- FROM t1
- ORDER BY 1,2
-----
-60 values hashing to 60ed925e6266c564dc3551acfa13417d
-
-query IIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- b,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- c-d
- FROM t1
- WHERE a>b
- OR e+d BETWEEN a+b-10 AND c+130
- ORDER BY 5,3,1,4,2
-----
-115 values hashing to 87b7852145d2cd4b4aef60d7fde294ca
-
-query IIIIII nosort
-SELECT b-c,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d,
- a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- b
- FROM t1
- ORDER BY 2,6,3,1,4,5
-----
-180 values hashing to 0237184a8878edf72b431a6c9bcfcbf2
-
-query III nosort
-SELECT e,
- a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE a>b
- ORDER BY 1,2,3
-----
-57 values hashing to c8d389e6c270e554bc93a318ef21e848
-
-query IIII nosort
-SELECT b-c,
- d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- ORDER BY 2,3,1,4
-----
-44 values hashing to 4ee79810a1704816bba77ef7c8033bfb
-
-query IIIIII nosort
-SELECT abs(a),
- a,
- c,
- d-e,
- a+b*2,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
- FROM t1
- ORDER BY 1,6,3,5,4,2
-----
-180 values hashing to dfff98b6d7e9b049c8feace97a7eb622
-
-query IIIII nosort
-SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- a+b*2,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- a+b*2+c*3+d*4+e*5,
- a+b*2+c*3+d*4
- FROM t1
- ORDER BY 2,3,1,5,4
-----
-150 values hashing to 1db48656258028dd2a0274c1f20a4e6c
-
-query IIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d-e,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- b,
- a+b*2+c*3
- FROM t1
- WHERE (e>c OR e<d)
- ORDER BY 3,5,4,6,2,1
-----
-162 values hashing to ec8ccfd9d87f0f620283a1dae7d24434
-
-query IIIIIII nosort
-SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- a+b*2+c*3,
- (a+b+c+d+e)/5,
- b,
- c,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- a-b
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- ORDER BY 3,5,7,2,4,6,1
-----
-42 values hashing to 86eba634c2a25d3e9a0aca99b8b9b7a3
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- a-b,
- a+b*2+c*3+d*4,
- a,
- a+b*2+c*3+d*4+e*5,
- c-d
- FROM t1
- WHERE d>e
- OR (c<=d-2 OR c>=d+2)
- ORDER BY 7,3,2,4,6,1,5
-----
-154 values hashing to ead80733a2080af9498e2ac38198e68e
-
-query III nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (a+b+c+d+e)/5,
- b
- FROM t1
- ORDER BY 3,1,2
-----
-90 values hashing to 05b2f3f52d4f5af4cf24810c343f5954
-
-query IIIIII nosort
-SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c,
- b-c
- FROM t1
- WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- OR a>b
- OR d NOT BETWEEN 110 AND 150
- ORDER BY 5,3,6,1,2,4
-----
-180 values hashing to 631b9506abcdd5dcea64c7ed2a3799ed
-
-query IIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d,
- a+b*2+c*3+d*4,
- a-b,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR c>d
- ORDER BY 3,5,4,1,2
-----
-125 values hashing to 58b4ab36ed442f3837188b38cd02486a
-
-query IIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- c-d,
- a-b
- FROM t1
- WHERE (e>c OR e<d)
- ORDER BY 3,5,4,1,2
-----
-135 values hashing to 635b37bb69d24a1353243f6975112cea
-
-query IIIIIII nosort
-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,
- (a+b+c+d+e)/5,
- abs(b-c),
- abs(a),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- ORDER BY 7,2,5,1,3,6,4
-----
-154 values hashing to b82f838cd6b2f0034ba34f8069a36b09
-
-query III nosort
-SELECT (a+b+c+d+e)/5,
- e,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (e>c OR e<d)
- OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- ORDER BY 3,1,2
-----
-90 values hashing to 66be8c935b54646fa54e09d50724c3fc
-
-query IIII nosort
-SELECT a-b,
- a+b*2,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d-e
- FROM t1
- WHERE d>e
- OR (e>a AND e<b)
- ORDER BY 4,1,3,2
-----
-72 values hashing to 25a13d479847a5eb07e7e6088d47b373
-
-query IIIIII nosort
-SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d-e,
- b,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- a+b*2
- FROM t1
- WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- OR (a>b-2 AND a<b+2)
- ORDER BY 2,6,3,5,4,1
-----
-174 values hashing to bf3a367003c73007e24f49edd2245ff8
-
-query IIIII nosort
-SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- c-d,
- abs(a),
- abs(b-c),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- ORDER BY 1,5,3,2,4
-----
-145 values hashing to 8024d1eebf4b583f802c8e24ef08700f
-
-query II nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a-b
- FROM t1
- WHERE b>c
- ORDER BY 1,2
-----
-28 values hashing to 2d23fde26e5c80f6eabca42e592bde71
-
-query III nosort
-SELECT a-b,
- a+b*2+c*3+d*4,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (e>c OR e<d)
- ORDER BY 1,2,3
-----
-81 values hashing to 21c30dc6df3b8c769f84c72451f968b5
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d,
- b-c,
- (a+b+c+d+e)/5,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- a-b
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR (e>c OR e<d)
- OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- ORDER BY 7,2,4,1,5,6,3
-----
-210 values hashing to 4abfb880f67a314446d0402a24ae5282
-
-query III nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
- FROM t1
- ORDER BY 1,3,2
-----
-90 values hashing to 87301227ae0731f419456d467d0e095f
-
-query IIII nosort
-SELECT (a+b+c+d+e)/5,
- a+b*2+c*3+d*4,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- abs(a)
- FROM t1
- WHERE (e>a AND e<b)
- AND d NOT BETWEEN 110 AND 150
- ORDER BY 4,3,1,2
-----
-12 values hashing to c334c687262c72da162e191703935928
-
-query IIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d,
- CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- e
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- ORDER BY 4,3,2,1
-----
-24 values hashing to 746dff67b6166bb25993d89eaa93e7a3
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- (a+b+c+d+e)/5,
- c-d,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- d,
- a+b*2+c*3+d*4,
- abs(a)
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- ORDER BY 2,5,1,3,7,6,4
-----
-105 values hashing to b3e0305b909d1f2abf1dc3c1745ac029
-
-query III nosort
-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,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 1,2,3
-----
-90 values hashing to 28225a47a6332aa64342b0faecc4ffde
-
-query III nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c,
- a+b*2+c*3
- FROM t1
- WHERE d NOT BETWEEN 110 AND 150
- AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- ORDER BY 2,1,3
-----
-63 values hashing to 77cf402238c411fd045a6a991c7dec12
-
-query IIIII nosort
-SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- d-e,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3,
- a+b*2+c*3+d*4+e*5
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- AND a>b
- AND (e>c OR e<d)
- ORDER BY 2,5,3,4,1
-----
-45 values hashing to 75ef6cb7d694759a04fb38d0d80ea6fb
-
-query I nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR (e>c OR e<d)
- OR a>b
- ORDER BY 1
-----
-28 values hashing to a76dc8384405fa57100e5dffbbd99b99
-
-query IIIII nosort
-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,
- c,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4+e*5
- FROM t1
- WHERE (a>b-2 AND a<b+2)
- ORDER BY 2,3,1,5,4
-----
-55 values hashing to 625bcace071d982d6c04cc1ddfe8378c
-
-query IIIIIII nosort
-SELECT d-e,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- c-d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4,
- a+b*2
- FROM t1
- ORDER BY 6,2,5,1,4,7,3
-----
-210 values hashing to b7fc5840ce267465864efec4638ec6ad
-
-query IIIIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d-e,
- a+b*2+c*3+d*4+e*5,
- a+b*2+c*3,
- a+b*2,
- abs(b-c),
- d
- FROM t1
- WHERE d>e
- ORDER BY 3,4,2,6,5,7,1
-----
-112 values hashing to 3a34b6923ab936224547f54261b88bd9
-
-query IIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2,
- c,
- a+b*2+c*3+d*4+e*5,
- d-e
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- OR c>d
- OR b>c
- ORDER BY 4,2,3,5,1
-----
-135 values hashing to 4305481e9a7ca71ef955b400497b8a93
-
-query IIII nosort
-SELECT a,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- c-d,
- b
- FROM t1
- ORDER BY 4,3,2,1
-----
-120 values hashing to 343df600fb44be4495c01502f42dbc1c
-
-query IIII nosort
-SELECT b,
- e,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 2,3,1,4
-----
-120 values hashing to 1e0e23f922af975b4024bd2bfd71ca2e
-
-query IIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4+e*5,
- 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 d NOT BETWEEN 110 AND 150
- AND a>b
- ORDER BY 3,4,2,1
-----
-68 values hashing to efb249f37bdc0e2144ea0f8a265caab5
-
-query IIII nosort
-SELECT a+b*2+c*3,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE (c<=d-2 OR c>=d+2)
- ORDER BY 3,4,1,2
-----
-60 values hashing to d5adb2536f4ed1202bbffe836134c8b8
-
-query IIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- c-d,
- a+b*2+c*3+d*4
- FROM t1
- WHERE a>b
- ORDER BY 2,4,1,3
-----
-76 values hashing to c842520d07c8a4805c0e9c46781e4e44
-
-query IIIIII nosort
-SELECT (a+b+c+d+e)/5,
- c-d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.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,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
- FROM t1
- WHERE d>e
- ORDER BY 1,6,2,5,4,3
-----
-96 values hashing to 521dca6d96de8a96e1ee4b3bfd22ca84
-
-query IIII nosort
-SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- a+b*2+c*3+d*4,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
- OR (c<=d-2 OR c>=d+2)
- ORDER BY 2,4,3,1
-----
-116 values hashing to 7475b1713d2bb04b2f15460ec5487648
-
-query II nosort
-SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE c>d
- ORDER BY 2,1
-----
-28 values hashing to 7bb527bc1d2528e5b09d04fcd8e6a1fb
-
-query IIIIIII nosort
-SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- a+b*2,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- a-b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- b
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- ORDER BY 6,1,2,3,7,4,5
-----
-154 values hashing to c4f2247a413e6c36412edaf2b966c320
-
-query IIIIII nosort
-SELECT a+b*2+c*3+d*4+e*5,
- CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
- WHEN a<b+3 THEN 333 ELSE 444 END,
- 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,
- c-d,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- ORDER BY 3,5,1,4,2,6
-----
-180 values hashing to fda423ac986fe8647b30d631dafb83fa
-
-query IIIIIII nosort
-SELECT b,
- a-b,
- e,
- d,
- abs(a),
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- AND d>e
- ORDER BY 2,1,5,3,6,4,7
-----
-105 values hashing to ad1f447f56a3bc9d467abea530124a7c
-
-query IIIII nosort
-SELECT b,
- a-b,
- a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- d
- FROM t1
- WHERE d NOT BETWEEN 110 AND 150
- AND c>d
- ORDER BY 1,2,3,5,4
-----
-45 values hashing to 170723580d1cb9c1114c2269200ebca6
-
-query IIIIIII nosort
-SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- b,
- a+b*2+c*3,
- a-b,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a+b*2+c*3+d*4
- FROM t1
- ORDER BY 4,3,5,2,7,1,6
-----
-210 values hashing to 7a0a8f77c3a0e99e5adda38c1771c18e
-
-query IIIIII nosort
-SELECT 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,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- d-e,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a
- FROM t1
- ORDER BY 6,4,5,3,2,1
-----
-180 values hashing to 360a865da8121bc0977f7658d1dfd557
-
-query IIIII nosort
-SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- a-b,
- b,
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
- e
- FROM t1
- ORDER BY 1,5,4,3,2
-----
-150 values hashing to 37ae594d2c57e581ced3eaa5665cc2db
-
-query IIII nosort
-SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
- WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- (a+b+c+d+e)/5
- FROM t1
- WHERE c BETWEEN b-2 AND d+2
- OR d>e
- OR a>b
- ORDER BY 2,3,1,4
-----
-108 values hashing to 51ad3b8a1b881292bb3b372941aa523b
-
-query IIIIII nosort
-SELECT (a+b+c+d+e)/5,
- c-d,
- (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
- abs(b-c),
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- b-c
- FROM t1
- WHERE e+d BETWEEN a+b-10 AND c+130
- OR (c<=d-2 OR c>=d+2)
- OR d>e
- ORDER BY 2,1,3,5,6,4
-----
-138 values hashing to 99d143bc2979104655dbd53c1ebb9daf
-
-query IIII nosort
-SELECT e,
- a+b*2+c*3+d*4+e*5,
- (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
- CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
- FROM t1
- ORDER BY 2,3,4,1
-----
-120 values hashing to 3ce25b7100fcbfe7c7142b3160cb9ebf
-
diff --git a/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p1.test b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p1.test
new file mode 100644
index 0000000000..18d4ee3e95
--- /dev/null
+++ b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p1.test
@@ -0,0 +1,275 @@
+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(103,102,100,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,111,113)
+
+statement ok
+INSERT INTO t1(d,c,e,a,b) VALUES(116,119,117,115,118)
+
+statement ok
+INSERT INTO t1(c,d,b,e,a) VALUES(123,122,124,120,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,148,147)
+
+statement ok
+INSERT INTO t1(b,c,a,d,e) VALUES(151,150,153,154,152)
+
+statement ok
+INSERT INTO t1(c,e,a,d,b) VALUES(155,157,159,156,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,169,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,178,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(200,202,203,201,204)
+
+statement ok
+INSERT INTO t1(c,e,a,b,d) VALUES(208,209,205,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,235,238)
+
+statement ok
+INSERT INTO t1(e,c,b,a,d) VALUES(242,244,240,243,241)
+
+statement ok
+INSERT INTO t1(e,d,c,b,a) VALUES(246,248,247,249,245)
+
+query IIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c,
+ (a+b+c+d+e)/5,
+ a+b*2,
+ c-d
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ AND e+d BETWEEN a+b-10 AND c+130
+ AND d NOT BETWEEN 110 AND 150
+ ORDER BY 5,3,2,4,1
+----
+
+query IIIIIII nosort
+SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ a+b*2+c*3+d*4+e*5,
+ a,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d
+ FROM t1
+ WHERE a>b
+ AND (e>a AND e<b)
+ ORDER BY 7,2,4,6,1,3,5
+----
+
+query II nosort
+SELECT b-c,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ AND (e>c OR e<d)
+ AND c>d
+ ORDER BY 2,1
+----
+-3
+0
+-1
+0
+-1
+0
+
+query I nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (e>c OR e<d)
+ AND e+d BETWEEN a+b-10 AND c+130
+ AND d>e
+ ORDER BY 1
+----
+0
+0
+0
+
+query IIII nosort
+SELECT c-d,
+ abs(b-c),
+ e,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE a>b
+ AND e+d BETWEEN a+b-10 AND c+130
+ AND (e>a AND e<b)
+ ORDER BY 3,4,1,2
+----
+
+query II nosort
+SELECT c-d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ AND a>b
+ AND (e>a AND e<b)
+ ORDER BY 2,1
+----
+
+query II nosort
+SELECT c,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE b>c
+ AND (e>a AND e<b)
+ AND d>e
+ ORDER BY 1,2
+----
+247
+0
+
+query III nosort
+SELECT a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ AND (a>b-2 AND a<b+2)
+ AND c>d
+ ORDER BY 1,2,3
+----
+
+query IIIIII nosort
+SELECT a,
+ a+b*2+c*3,
+ abs(a),
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ a-b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (e>a AND e<b)
+ AND e+d BETWEEN a+b-10 AND c+130
+ AND (e>c OR e<d)
+ ORDER BY 4,2,5,1,3,6
+----
+
+query IIIII nosort
+SELECT a,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ b-c,
+ a-b,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR a>b
+ OR b>c
+ ORDER BY 1,4,3,2,5
+----
+145 values hashing to 65042db64d506f67a37c85f825cdd11f
+
+query IIII nosort
+SELECT a+b*2+c*3+d*4,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ ORDER BY 4,2,1,3
+----
+60 values hashing to a2af299d7b2197866b7c8f6854b77ab5
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(b-c),
+ a+b*2+c*3+d*4,
+ (a+b+c+d+e)/5,
+ d-e,
+ a+b*2+c*3+d*4+e*5
+ FROM t1
+ WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ ORDER BY 1,6,2,4,5,3
+----
+174 values hashing to 05379a2f92dfafe9d9f27b43b2da99a1
+
+query IIIIIII nosort
+SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ d-e,
+ b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a-b,
+ a,
+ e
+ FROM t1
+ ORDER BY 4,5,1,3,7,6,2
+----
+210 values hashing to 8d6b363f389996a9821b4e3809779f76
+
+query III nosort
+SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ a+b*2,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (e>c OR e<d)
+ ORDER BY 2,1,3
+----
+81 values hashing to f73fa4ec254d735c86e5741004f72034
+
diff --git a/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p2.test b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p2.test
new file mode 100644
index 0000000000..5fe3c24220
--- /dev/null
+++ b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p2.test
@@ -0,0 +1,191 @@
+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(103,102,100,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,111,113)
+
+statement ok
+INSERT INTO t1(d,c,e,a,b) VALUES(116,119,117,115,118)
+
+statement ok
+INSERT INTO t1(c,d,b,e,a) VALUES(123,122,124,120,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,148,147)
+
+statement ok
+INSERT INTO t1(b,c,a,d,e) VALUES(151,150,153,154,152)
+
+statement ok
+INSERT INTO t1(c,e,a,d,b) VALUES(155,157,159,156,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,169,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,178,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(200,202,203,201,204)
+
+statement ok
+INSERT INTO t1(c,e,a,b,d) VALUES(208,209,205,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,235,238)
+
+statement ok
+INSERT INTO t1(e,c,b,a,d) VALUES(242,244,240,243,241)
+
+statement ok
+INSERT INTO t1(e,d,c,b,a) VALUES(246,248,247,249,245)
+
+query II nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4+e*5
+ FROM t1
+ WHERE (e>a AND e<b)
+ OR (c<=d-2 OR c>=d+2)
+ OR e+d BETWEEN a+b-10 AND c+130
+ ORDER BY 2,1
+----
+38 values hashing to 6b17e3a64ebbafbdf4ec543abf34d414
+
+query IIIII nosort
+SELECT a,
+ d,
+ a+b*2+c*3+d*4+e*5,
+ a-b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR (a>b-2 AND a<b+2)
+ OR b>c
+ ORDER BY 1,3,5,4,2
+----
+140 values hashing to 3dfb60ce29bfaa3deb2c90771787ae28
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3,
+ d-e,
+ b,
+ a,
+ c,
+ a+b*2
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ OR (e>a AND e<b)
+ OR d>e
+ ORDER BY 5,6,3,7,2,1,4
+----
+154 values hashing to 7be42f68cbfeb20d2a574569eabc62b8
+
+query IIIIIII nosort
+SELECT b-c,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ a+b*2,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(a),
+ c-d,
+ d
+ FROM t1
+ WHERE b>c
+ OR d NOT BETWEEN 110 AND 150
+ OR (e>c OR e<d)
+ ORDER BY 4,6,5,1,3,7,2
+----
+203 values hashing to 449a18d19874d7ee976c4c9fc953e3f4
+
+query III nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ (a+b+c+d+e)/5,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR (c<=d-2 OR c>=d+2)
+ OR c>d
+ ORDER BY 1,3,2
+----
+81 values hashing to 3bd0cf1b195cb05eea3e0621c5a4f38e
+
+query IIIII nosort
+SELECT a+b*2,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c-d,
+ a+b*2+c*3
+ FROM t1
+ WHERE d>e
+ ORDER BY 4,2,1,5,3
+----
+80 values hashing to 06c104cf923af770f3cf98700c2428d0
+
+query IIIIII nosort
+SELECT a+b*2,
+ (a+b+c+d+e)/5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ abs(b-c),
+ a-b
+ FROM t1
+ WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ AND c>d
+ ORDER BY 6,5,4,1,3,2
+----
+78 values hashing to f8b104ce0c1d6a8d02976b512c224c33
+
diff --git a/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p3.test_ignored b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p3.test_ignored
new file mode 100644
index 0000000000..82ce70dcc8
--- /dev/null
+++ b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p3.test_ignored
@@ -0,0 +1,859 @@
+# Ignore https://issues.apache.org/jira/browse/IGNITE-17612
+
+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(103,102,100,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,111,113)
+
+statement ok
+INSERT INTO t1(d,c,e,a,b) VALUES(116,119,117,115,118)
+
+statement ok
+INSERT INTO t1(c,d,b,e,a) VALUES(123,122,124,120,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,148,147)
+
+statement ok
+INSERT INTO t1(b,c,a,d,e) VALUES(151,150,153,154,152)
+
+statement ok
+INSERT INTO t1(c,e,a,d,b) VALUES(155,157,159,156,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,169,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,178,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(200,202,203,201,204)
+
+statement ok
+INSERT INTO t1(c,e,a,b,d) VALUES(208,209,205,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,235,238)
+
+statement ok
+INSERT INTO t1(e,c,b,a,d) VALUES(242,244,240,243,241)
+
+statement ok
+INSERT INTO t1(e,d,c,b,a) VALUES(246,248,247,249,245)
+
+query III nosort
+SELECT (a+b+c+d+e)/5,
+ a+b*2,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (e>c OR e<d)
+ OR b>c
+ ORDER BY 2,1,3
+----
+84 values hashing to aa77bd3dacaadb8d94850b7457313394
+
+query IIIIIII nosort
+SELECT c-d,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ a+b*2,
+ a,
+ abs(b-c),
+ a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR b>c
+ ORDER BY 3,5,4,2,6,7,1
+----
+196 values hashing to ce60e2883fe7a0c41c29c17e9b62bf51
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ abs(a),
+ a+b*2+c*3+d*4+e*5,
+ d-e,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ OR d>e
+ OR b>c
+ ORDER BY 2,3,1,5,4,6
+----
+150 values hashing to c31247552305ea7108b6c15517e4e50e
+
+query IIIIIII nosort
+SELECT a+b*2,
+ a+b*2+c*3+d*4+e*5,
+ b,
+ c-d,
+ abs(b-c),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ ORDER BY 5,1,4,7,3,2,6
+----
+210 values hashing to 24fae43b38fe9736d9fc79f183773c0f
+
+query IIIII nosort
+SELECT b-c,
+ c,
+ d-e,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ (a+b+c+d+e)/5
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ OR d NOT BETWEEN 110 AND 150
+ OR b>c
+ ORDER BY 3,5,4,2,1
+----
+140 values hashing to db6ada3c6b4c6105c96c56f98bd679d1
+
+query III nosort
+SELECT b,
+ d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE b>c
+ ORDER BY 1,2,3
+----
+42 values hashing to fdf2c9075b2487f82c8ad837755619d7
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c-d,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ d-e,
+ a+b*2+c*3+d*4,
+ c,
+ a+b*2
+ FROM t1
+ ORDER BY 7,3,2,6,4,5,1
+----
+210 values hashing to 295b9d736969e666ddf559dd8479c415
+
+query II nosort
+SELECT d-e,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ ORDER BY 1,2
+----
+22 values hashing to 1e52dd7b5731c2e28fbbaa8fccc86f65
+
+query II nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d
+ FROM t1
+ ORDER BY 1,2
+----
+60 values hashing to aae77ef6a7bbfce44e353697e1736636
+
+query IIIIII nosort
+SELECT a,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4+e*5,
+ d,
+ a+b*2+c*3
+ FROM t1
+ WHERE b>c
+ AND (c<=d-2 OR c>=d+2)
+ AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ ORDER BY 2,3,1,6,4,5
+----
+42 values hashing to 8ce8889165dbfc2a153b8e41d6eac176
+
+query IIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4+e*5,
+ c-d,
+ d
+ FROM t1
+ WHERE d NOT BETWEEN 110 AND 150
+ ORDER BY 1,3,4,2
+----
+88 values hashing to 271cfc0737d448d8e0ae9b778205fcad
+
+query IIII nosort
+SELECT a+b*2+c*3,
+ c-d,
+ a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE d>e
+ OR (c<=d-2 OR c>=d+2)
+ OR c BETWEEN b-2 AND d+2
+ ORDER BY 1,2,4,3
+----
+108 values hashing to 709932df0abe61ded2f95a3b2b8e9c34
+
+query IIIIIII nosort
+SELECT (a+b+c+d+e)/5,
+ 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,
+ a,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4+e*5
+ FROM t1
+ ORDER BY 3,5,1,2,7,4,6
+----
+210 values hashing to d312440b05a05bd531e9e6b7ad183255
+
+query IIIIIII nosort
+SELECT c,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ a+b*2,
+ e,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ b-c,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ AND d>e
+ AND d NOT BETWEEN 110 AND 150
+ ORDER BY 7,2,1,5,6,4,3
+----
+14 values hashing to d8e81dbe9389b8a7fb955726d1018688
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ e,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (a+b+c+d+e)/5,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ d,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
+ FROM t1
+ WHERE a>b
+ ORDER BY 7,6,5,2,1,3,4
+----
+133 values hashing to e0e2d07862532072e37e60225da99516
+
+query IIIIII nosort
+SELECT e,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ a-b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE a>b
+ AND (c<=d-2 OR c>=d+2)
+ AND c>d
+ ORDER BY 6,5,4,2,3,1
+----
+18 values hashing to 7b37fd650c93c3580d86ed2112de3518
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ e,
+ a+b*2+c*3+d*4,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ a+b*2+c*3,
+ abs(a),
+ c-d
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR (e>c OR e<d)
+ ORDER BY 1,4,2,5,7,3,6
+----
+189 values hashing to 225b9220120f5debc0a77757e6a544a7
+
+query IIIII nosort
+SELECT a+b*2,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ b,
+ c,
+ abs(a)
+ FROM t1
+ WHERE d>e
+ ORDER BY 1,3,2,4,5
+----
+80 values hashing to 4cf6188a63134ebf831c245aed6fd46d
+
+query IIIII nosort
+SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ e,
+ a+b*2+c*3,
+ c
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ OR d>e
+ ORDER BY 3,4,2,5,1
+----
+110 values hashing to 7c7ca7dc3909bad67db7afb2ce90ee58
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(a),
+ a-b,
+ a+b*2+c*3,
+ d-e,
+ b,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END
+ FROM t1
+ WHERE d NOT BETWEEN 110 AND 150
+ AND (c<=d-2 OR c>=d+2)
+ ORDER BY 1,5,6,2,4,7,3
+----
+91 values hashing to e0fe8de872329c82af624de95132584e
+
+query IIII nosort
+SELECT a+b*2+c*3+d*4,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ a,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE c>d
+ ORDER BY 4,1,3,2
+----
+56 values hashing to 68bfd05b60394ed25ff6ddecdef16e10
+
+query IIIIIII nosort
+SELECT b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c-d,
+ b-c,
+ a+b*2+c*3+d*4,
+ c,
+ abs(a)
+ FROM t1
+ WHERE d>e
+ ORDER BY 2,1,4,5,6,3,7
+----
+112 values hashing to 7d1953113f7f07c9266eb09edadd82f9
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ abs(a),
+ d,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ a,
+ a+b*2
+ FROM t1
+ WHERE d NOT BETWEEN 110 AND 150
+ AND (a>b-2 AND a<b+2)
+ ORDER BY 5,6,3,1,2,4,7
+----
+49 values hashing to d9af3c86c55045321eccea3c3f39b048
+
+query IIII nosort
+SELECT abs(a),
+ a+b*2+c*3+d*4,
+ a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE b>c
+ OR (e>a AND e<b)
+ ORDER BY 2,4,1,3
+----
+64 values hashing to ad2644ea3960ffbe041c9a505773a231
+
+query IIIIIII nosort
+SELECT c-d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(a),
+ d-e,
+ b,
+ abs(b-c),
+ a+b*2+c*3
+ FROM t1
+ ORDER BY 6,1,4,2,5,3,7
+----
+210 values hashing to 029d94ade68a27ab16900e1e1f6f3c54
+
+query IIIIIII nosort
+SELECT c,
+ c-d,
+ a+b*2+c*3+d*4,
+ a+b*2+c*3+d*4+e*5,
+ abs(b-c),
+ (a+b+c+d+e)/5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE d NOT BETWEEN 110 AND 150
+ AND a>b
+ AND c>d
+ ORDER BY 7,1,5,3,2,4,6
+----
+42 values hashing to 719b82439155e612b0a13ee9e8496dea
+
+query IIIII nosort
+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,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ ORDER BY 2,4,5,1,3
+----
+30 values hashing to 7f66566999f88b34321d64aafb17b34d
+
+query IIII nosort
+SELECT a,
+ abs(a),
+ (a+b+c+d+e)/5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 3,1,2,4
+----
+120 values hashing to 322fbb90672f08ec55b91dd2b85b8bc5
+
+query IIIII nosort
+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,
+ abs(a),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a
+ FROM t1
+ ORDER BY 2,4,5,1,3
+----
+150 values hashing to 3d333b73ba68315675c5463fb4536269
+
+query IIIIII nosort
+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,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(b-c),
+ b-c,
+ a+b*2+c*3
+ FROM t1
+ WHERE (e>c OR e<d)
+ AND (c<=d-2 OR c>=d+2)
+ AND c BETWEEN b-2 AND d+2
+ ORDER BY 2,5,4,6,3,1
+----
+60 values hashing to 755f345cafbb73c0340e12a2580bb1e8
+
+query IIIIII nosort
+SELECT a,
+ a+b*2+c*3,
+ a+b*2+c*3+d*4+e*5,
+ c-d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ OR d NOT BETWEEN 110 AND 150
+ ORDER BY 2,4,5,6,1,3
+----
+156 values hashing to 7133d2c62ac44540d9e489748fb517d0
+
+query IIIIIII nosort
+SELECT a+b*2+c*3,
+ c,
+ b-c,
+ a+b*2+c*3+d*4,
+ a,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ (a+b+c+d+e)/5
+ FROM t1
+ WHERE (e>c OR e<d)
+ AND c BETWEEN b-2 AND d+2
+ AND (e>a AND e<b)
+ ORDER BY 7,5,3,2,6,4,1
+----
+14 values hashing to 6ae7f7555d748317d1f77e0f76a877fc
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ e,
+ abs(a),
+ c-d,
+ a,
+ b-c
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ OR (c<=d-2 OR c>=d+2)
+ OR d NOT BETWEEN 110 AND 150
+ ORDER BY 7,1,5,3,4,6,2
+----
+196 values hashing to 3f2cca604f78daaa5c238d7f0fa01745
+
+query IIIIII nosort
+SELECT a+b*2+c*3+d*4,
+ d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ c,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
+ FROM t1
+ WHERE a>b
+ OR (e>a AND e<b)
+ ORDER BY 4,6,2,5,1,3
+----
+138 values hashing to 226c6ba76feacd2b0d92d3dee611399d
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ b,
+ a,
+ a+b*2+c*3+d*4+e*5,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ a+b*2+c*3
+ FROM t1
+ WHERE a>b
+ AND (e>c OR e<d)
+ ORDER BY 3,7,2,5,6,4,1
+----
+126 values hashing to a3c1afa7c92832ab10d89a3cdd218e17
+
+query IIIII nosort
+SELECT a+b*2+c*3+d*4,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
+ FROM t1
+ ORDER BY 4,5,3,2,1
+----
+150 values hashing to 41a342f4212e2a14116ba83427e049be
+
+query II nosort
+SELECT b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (e>a AND e<b)
+ OR c>d
+ ORDER BY 1,2
+----
+30 values hashing to 907d0240f42a1141b7870e0424b0dd04
+
+query III nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(a),
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ AND c>d
+ ORDER BY 1,3,2
+----
+9 values hashing to 0598e89fd314145ba8f06f228456f4ba
+
+query IIIIIII nosort
+SELECT a-b,
+ d,
+ a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ (a+b+c+d+e)/5,
+ b,
+ d-e
+ FROM t1
+ ORDER BY 1,5,3,7,4,6,2
+----
+210 values hashing to e2f7b27ca407bf9df4acb3be08c64524
+
+query IIIIII nosort
+SELECT abs(b-c),
+ (a+b+c+d+e)/5,
+ d,
+ b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c
+ FROM t1
+ ORDER BY 4,6,2,1,5,3
+----
+180 values hashing to e636f30eea1a3449e5944de44985d2c5
+
+query IIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c,
+ a,
+ (a+b+c+d+e)/5
+ FROM t1
+ ORDER BY 2,3,1,4
+----
+120 values hashing to 62c5856425278965c1b1a7b2686bb1a4
+
+query IIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ d,
+ (a+b+c+d+e)/5
+ FROM t1
+ WHERE (e>a AND e<b)
+ AND (c<=d-2 OR c>=d+2)
+ ORDER BY 3,2,1,4
+----
+12 values hashing to fae09a9a32247b430470a8b81fbc6cc9
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c-d,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ c,
+ d,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ OR c>d
+ ORDER BY 1,2,4,5,6,3
+----
+102 values hashing to 1a7c46130532fbc982bba080af7ee291
+
+query IIIIIII nosort
+SELECT a+b*2+c*3,
+ abs(a),
+ 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,
+ d-e,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE d NOT BETWEEN 110 AND 150
+ AND (e>a AND e<b)
+ ORDER BY 1,5,3,4,6,2,7
+----
+21 values hashing to d87da634fb840b1c06fbe4a9044e809d
+
+query II nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ b
+ FROM t1
+ ORDER BY 1,2
+----
+60 values hashing to 15596791cdb51704f8ab6f597e39790d
+
+query I nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 1
+----
+30 values hashing to ec9f02c46c399db521c47dd9cb6a40dd
+
+query IIIII nosort
+SELECT a-b,
+ c-d,
+ a+b*2+c*3+d*4+e*5,
+ c,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 1,4,3,2,5
+----
+150 values hashing to 034d9cdf4634c24ca574f76ba23ed550
+
+query IIIIII nosort
+SELECT b-c,
+ a-b,
+ abs(a),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ 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
+ WHERE b>c
+ OR (a>b-2 AND a<b+2)
+ ORDER BY 4,3,1,5,6,2
+----
+114 values hashing to d289034237130317cf469cf3bc27c879
+
+query IIIII nosort
+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.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4,
+ b
+ FROM t1
+ WHERE c>d
+ OR d>e
+ ORDER BY 2,5,1,3,4
+----
+120 values hashing to 6b7c62f6dba560a1b1cfb4a0de687636
+
+query IIIIIII nosort
+SELECT 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,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4+e*5,
+ e,
+ (a+b+c+d+e)/5
+ FROM t1
+ ORDER BY 6,5,1,7,2,3,4
+----
+210 values hashing to 0b9d7c7d7a7c7cc0a5d90f1990a043e9
+
+query IIII nosort
+SELECT c,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ a+b*2+c*3+d*4
+ FROM t1
+ WHERE b>c
+ OR (e>c OR e<d)
+ OR d NOT BETWEEN 110 AND 150
+ ORDER BY 3,2,1,4
+----
+116 values hashing to 033ab3b385a760384a80f7c2f8116b27
+
+query IIIIIII nosort
+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,
+ a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a,
+ d-e,
+ e
+ FROM t1
+ ORDER BY 4,3,2,1,5,7,6
+----
+210 values hashing to 72748aa05256149f5b609735556600ee
+
+query IIIIIII nosort
+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,
+ a+b*2,
+ a+b*2+c*3,
+ a+b*2+c*3+d*4,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(b-c)
+ FROM t1
+ WHERE d NOT BETWEEN 110 AND 150
+ ORDER BY 4,3,2,5,7,1,6
+----
+154 values hashing to 48148b8db7389fcfe7ce1305fd4c4baa
+
+query III nosort
+SELECT 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.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ ORDER BY 1,3,2
+----
+33 values hashing to 83af9d93602ea54fa991d265574a4c3a
+
+query IIIIIII nosort
+SELECT d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ (a+b+c+d+e)/5,
+ a-b,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ c-d,
+ d-e
+ FROM t1
+ WHERE b>c
+ OR d NOT BETWEEN 110 AND 150
+ ORDER BY 2,3,6,7,4,1,5
+----
+182 values hashing to 9bb679937b36be78dd530a683782d10a
+
+query II nosort
+SELECT (a+b+c+d+e)/5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ OR c BETWEEN b-2 AND d+2
+ OR (a>b-2 AND a<b+2)
+ ORDER BY 2,1
+----
+60 values hashing to 4ff348b6082ffad99447100b2c77aca6
+
+query I nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR c>d
+ ORDER BY 1
+----
+25 values hashing to 3a8c1f92b5515a90e97181b7aaf6970b
+
+query IIIIII nosort
+SELECT (a+b+c+d+e)/5,
+ a,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ b-c,
+ a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ ORDER BY 6,4,5,1,2,3
+----
+66 values hashing to 80d5784436f12d6111be1755171b13d4
+
diff --git a/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p4.test_ignored b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p4.test_ignored
new file mode 100644
index 0000000000..b74aa62f11
--- /dev/null
+++ b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p4.test_ignored
@@ -0,0 +1,441 @@
+# Ignore https://issues.apache.org/jira/browse/IGNITE-17612
+
+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(103,102,100,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,111,113)
+
+statement ok
+INSERT INTO t1(d,c,e,a,b) VALUES(116,119,117,115,118)
+
+statement ok
+INSERT INTO t1(c,d,b,e,a) VALUES(123,122,124,120,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,148,147)
+
+statement ok
+INSERT INTO t1(b,c,a,d,e) VALUES(151,150,153,154,152)
+
+statement ok
+INSERT INTO t1(c,e,a,d,b) VALUES(155,157,159,156,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,169,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,178,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(200,202,203,201,204)
+
+statement ok
+INSERT INTO t1(c,e,a,b,d) VALUES(208,209,205,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,235,238)
+
+statement ok
+INSERT INTO t1(e,c,b,a,d) VALUES(242,244,240,243,241)
+
+statement ok
+INSERT INTO t1(e,d,c,b,a) VALUES(246,248,247,249,245)
+
+query II nosort
+SELECT a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ ORDER BY 2,1
+----
+58 values hashing to 9646b8b8b446280ab97d4f5e30a51bae
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ abs(b-c),
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a-b,
+ abs(a)
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ OR d>e
+ OR c BETWEEN b-2 AND d+2
+ ORDER BY 4,1,5,6,3,2
+----
+144 values hashing to 87705ab033397683288724d8d8a8303e
+
+query III nosort
+SELECT a,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(b-c)
+ FROM t1
+ ORDER BY 3,2,1
+----
+90 values hashing to ea5d42bf4b76916f27ca2207d5f3a1cb
+
+query III nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3,
+ a-b
+ FROM t1
+ WHERE a>b
+ AND (c<=d-2 OR c>=d+2)
+ ORDER BY 3,1,2
+----
+30 values hashing to 6ad8accda9cddcf28817fbf053942483
+
+query IIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ d,
+ a,
+ a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ ORDER BY 2,5,3,1,4
+----
+110 values hashing to 76487e705db851d7db9ddf5ba8be0c56
+
+query III nosort
+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 c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE c>d
+ ORDER BY 2,3,1
+----
+42 values hashing to 0b30094aec5125c1843b3e6e1e41a6e8
+
+query IIIIII nosort
+SELECT abs(b-c),
+ c,
+ b,
+ (a+b+c+d+e)/5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d
+ FROM t1
+ WHERE d>e
+ ORDER BY 6,5,3,1,2,4
+----
+96 values hashing to d43f79239513169ba12520f7a149dee7
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ 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,
+ b-c,
+ a+b*2+c*3+d*4,
+ (a+b+c+d+e)/5
+ FROM t1
+ WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ AND (c<=d-2 OR c>=d+2)
+ ORDER BY 5,1,2,4,3,6,7
+----
+105 values hashing to 6f1348d248b462331e2adebdb5140a95
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ a+b*2+c*3,
+ a,
+ (a+b+c+d+e)/5,
+ b
+ FROM t1
+ WHERE b>c
+ ORDER BY 4,2,6,5,3,7,1
+----
+98 values hashing to 9672e04e6af85e083efc6d3a01ad003c
+
+query IIII nosort
+SELECT a+b*2,
+ a-b,
+ a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 1,3,4,2
+----
+120 values hashing to aba88e7aab9b448d205e6978445e0e60
+
+query IIIII nosort
+SELECT a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ c,
+ d
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ ORDER BY 4,5,2,1,3
+----
+55 values hashing to a7ad6c80c65b6fa1575e15a286ab717b
+
+query IIIIII nosort
+SELECT c,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ b-c,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ ORDER BY 6,3,1,2,4,5
+----
+132 values hashing to fd0adbb2bc4037a6ef6fcec0141f7aa1
+
+query IIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d-e,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ c
+ FROM t1
+ WHERE d>e
+ OR a>b
+ ORDER BY 4,3,2,1,5
+----
+125 values hashing to 9fcf17184ac87f3ca33f5aa74b552242
+
+query IIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ a+b*2
+ FROM t1
+ ORDER BY 1,3,4,2
+----
+120 values hashing to 9d8ae71d1d4851666a75fec8bc675773
+
+query IIIIII nosort
+SELECT c-d,
+ a+b*2+c*3+d*4+e*5,
+ b,
+ (a+b+c+d+e)/5,
+ a,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE d>e
+ ORDER BY 4,5,6,1,3,2
+----
+96 values hashing to a762a09cf2fc3bb7b96a1bacd3516820
+
+query IIIII nosort
+SELECT a+b*2+c*3+d*4+e*5,
+ d-e,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(b-c),
+ c-d
+ FROM t1
+ ORDER BY 2,1,3,4,5
+----
+150 values hashing to 9fa5902ee5ef32c5318e0331bdd35651
+
+query III nosort
+SELECT a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ e
+ FROM t1
+ ORDER BY 3,1,2
+----
+90 values hashing to 81c7f303422ff0623fdd74a5b0bdbcd9
+
+query IIIIII nosort
+SELECT b,
+ c,
+ abs(a),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ b-c,
+ e
+ FROM t1
+ ORDER BY 4,5,1,6,2,3
+----
+180 values hashing to 8c1ed130d0125560ee81e819bc8451af
+
+query IIIIIII nosort
+SELECT a+b*2+c*3+d*4,
+ c-d,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ a+b*2,
+ b,
+ b-c,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 5,2,4,1,6,3,7
+----
+210 values hashing to ad750cadd33a9416af71d69c5fac509d
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ b-c,
+ a,
+ abs(a)
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ OR (c<=d-2 OR c>=d+2)
+ OR d>e
+ ORDER BY 3,5,6,2,1,7,4
+----
+196 values hashing to ab60be6b2b2d576e28c474ce597e7441
+
+query IIIIII nosort
+SELECT (a+b+c+d+e)/5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3,
+ a,
+ a-b,
+ d
+ FROM t1
+ WHERE (e>a AND e<b)
+ AND c BETWEEN b-2 AND d+2
+ ORDER BY 6,1,2,3,5,4
+----
+12 values hashing to 01ab6b4f408df903621edf08828ba7a5
+
+query IIII nosort
+SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ a
+ FROM t1
+ ORDER BY 4,2,3,1
+----
+120 values hashing to cdadd86b806e762ee9d7d03f0058ff4a
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ d,
+ c,
+ a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (e>a AND e<b)
+ ORDER BY 4,2,3,1,5,6
+----
+24 values hashing to 9e80b3c7e910457fc023a082297c66a6
+
+query IIIIII nosort
+SELECT e,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4+e*5,
+ b,
+ d-e,
+ c
+ FROM t1
+ WHERE c>d
+ AND d>e
+ AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ ORDER BY 2,4,1,5,3,6
+----
+36 values hashing to 13898e32c711a65529fa502c0c91de6e
+
+query IIIIIII nosort
+SELECT e,
+ abs(a),
+ c-d,
+ a,
+ c,
+ a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ ORDER BY 2,7,6,5,3,1,4
+----
+154 values hashing to 37f9bacc7a12ddc6b1beae763457ddda
+
+query IIII nosort
+SELECT abs(b-c),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d-e,
+ a-b
+ FROM t1
+ ORDER BY 1,3,4,2
+----
+120 values hashing to dbf19b42301e4f161c0a991b57d13101
+
+query IIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ a-b,
+ d-e
+ FROM t1
+ ORDER BY 1,4,3,2
+----
+120 values hashing to 5d82db974f8caa9127d640fcf6cc1a40
+
+query IIIII nosort
+SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a-b,
+ (a+b+c+d+e)/5,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ ORDER BY 4,1,3,5,2
+----
+55 values hashing to 9b60d91226b0f2f8659270ea5306163d
+
diff --git a/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p5.test_ignored b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p5.test_ignored
new file mode 100644
index 0000000000..5216149439
--- /dev/null
+++ b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p5.test_ignored
@@ -0,0 +1,551 @@
+# Ignore https://issues.apache.org/jira/browse/IGNITE-17612
+
+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(103,102,100,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,111,113)
+
+statement ok
+INSERT INTO t1(d,c,e,a,b) VALUES(116,119,117,115,118)
+
+statement ok
+INSERT INTO t1(c,d,b,e,a) VALUES(123,122,124,120,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,148,147)
+
+statement ok
+INSERT INTO t1(b,c,a,d,e) VALUES(151,150,153,154,152)
+
+statement ok
+INSERT INTO t1(c,e,a,d,b) VALUES(155,157,159,156,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,169,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,178,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(200,202,203,201,204)
+
+statement ok
+INSERT INTO t1(c,e,a,b,d) VALUES(208,209,205,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,235,238)
+
+statement ok
+INSERT INTO t1(e,c,b,a,d) VALUES(242,244,240,243,241)
+
+statement ok
+INSERT INTO t1(e,d,c,b,a) VALUES(246,248,247,249,245)
+
+query IIIIII nosort
+SELECT a+b*2+c*3+d*4+e*5,
+ a,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ e,
+ d
+ FROM t1
+ WHERE b>c
+ ORDER BY 6,2,5,4,3,1
+----
+84 values hashing to e05d2e123bb3c8af78b16346f8a4b290
+
+query IIII nosort
+SELECT a+b*2+c*3,
+ d-e,
+ c,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE d NOT BETWEEN 110 AND 150
+ ORDER BY 1,2,4,3
+----
+88 values hashing to db4da1f3c45a5823d3ebc705f0762179
+
+query II nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
+ FROM t1
+ ORDER BY 2,1
+----
+60 values hashing to 85404c9e49e9c58a47120a703e4457da
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c-d,
+ c,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ b,
+ a+b*2+c*3
+ FROM t1
+ ORDER BY 4,2,1,3,5,6
+----
+180 values hashing to e80b8346172b01fad12a7248e5bbc7a4
+
+query IIIII nosort
+SELECT c-d,
+ abs(a),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4,
+ d
+ FROM t1
+ WHERE c>d
+ AND (e>c OR e<d)
+ ORDER BY 3,1,4,5,2
+----
+55 values hashing to 50319241cf069b222e20cb31cfb4f023
+
+query III nosort
+SELECT (a+b+c+d+e)/5,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 1,3,2
+----
+90 values hashing to 0c2274d4a8a3ec90ea6a28620767869e
+
+query IIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ abs(a),
+ abs(b-c),
+ b-c
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ OR d>e
+ OR (a>b-2 AND a<b+2)
+ ORDER BY 3,4,2,1,5
+----
+140 values hashing to 70533a0a1bba09436341d84b243a4d16
+
+query IIIII nosort
+SELECT abs(b-c),
+ c-d,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ AND d>e
+ AND c BETWEEN b-2 AND d+2
+ ORDER BY 1,2,5,3,4
+----
+10 values hashing to d1f0237fc8125db019f7ae5fc6432c34
+
+query IIIIII nosort
+SELECT a+b*2+c*3+d*4,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ a+b*2+c*3+d*4+e*5,
+ a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE c>d
+ AND c BETWEEN b-2 AND d+2
+ AND (e>c OR e<d)
+ ORDER BY 6,2,5,4,1,3
+----
+66 values hashing to a8f6dd606793116aa2ce7b0e208adc9b
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ abs(b-c),
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ ORDER BY 3,1,6,4,2,5
+----
+132 values hashing to ec8164a205d1e3a7ff6159a6c54f9b38
+
+query III nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.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
+ FROM t1
+ ORDER BY 1,2,3
+----
+90 values hashing to 16f9d5fdf4a5fcefd72fd63af183a51a
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ a-b,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ 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+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 3,4,7,5,2,6,1
+----
+210 values hashing to 278b40264305ba138427722b9dcc7b78
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d-e,
+ a+b*2+c*3,
+ a-b,
+ a+b*2+c*3+d*4+e*5,
+ b-c
+ FROM t1
+ WHERE b>c
+ AND a>b
+ AND (c<=d-2 OR c>=d+2)
+ ORDER BY 5,1,3,6,2,4
+----
+24 values hashing to 651f715b7e5976e9d63b17b91ea8d333
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(a),
+ b-c,
+ a-b,
+ a,
+ c-d
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ ORDER BY 3,6,1,2,4,5
+----
+36 values hashing to 101e7b5dd4d24f8db95eca3c47633127
+
+query IIII nosort
+SELECT d-e,
+ b,
+ b-c,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE d>e
+ OR d NOT BETWEEN 110 AND 150
+ OR c BETWEEN b-2 AND d+2
+ ORDER BY 3,4,2,1
+----
+116 values hashing to 8a927705b4fec3a4b0d85784481196d6
+
+query IIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ d,
+ c-d,
+ a
+ FROM t1
+ ORDER BY 3,4,2,5,1
+----
+150 values hashing to 1effee3fa900abed1f10e47b0c1d1e65
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ e,
+ a+b*2,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ a+b*2+c*3+d*4+e*5,
+ a+b*2+c*3,
+ c-d
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ ORDER BY 4,2,6,1,7,3,5
+----
+77 values hashing to a07d85e50adee8e8d352265890fa3df5
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(a),
+ a+b*2+c*3+d*4,
+ (a+b+c+d+e)/5,
+ e,
+ b,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ OR (a>b-2 AND a<b+2)
+ OR b>c
+ ORDER BY 2,1,3,7,5,4,6
+----
+154 values hashing to b9a9dc5ffa8928273db7bcd669c53cd7
+
+query IIIII nosort
+SELECT abs(a),
+ e,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE a>b
+ ORDER BY 4,1,5,2,3
+----
+95 values hashing to 19afe88a8ec0b6ac1a596dcfbe7a73ef
+
+query IIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d-e,
+ b,
+ a+b*2+c*3+d*4
+ FROM t1
+ ORDER BY 1,3,2,4
+----
+120 values hashing to 238444a65f715eb041390b17898802ba
+
+query III nosort
+SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 3,1,2
+----
+90 values hashing to d3e4cefb53c165b66f678c56a86c8314
+
+query IIIII nosort
+SELECT a+b*2+c*3+d*4+e*5,
+ a,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d,
+ abs(b-c)
+ FROM t1
+ WHERE d NOT BETWEEN 110 AND 150
+ AND (e>a AND e<b)
+ ORDER BY 1,3,5,4,2
+----
+15 values hashing to abd13e32a5a8a00bfe03cdf0f269bfc8
+
+query IIIII nosort
+SELECT a+b*2+c*3,
+ d,
+ a,
+ a+b*2+c*3+d*4,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ ORDER BY 2,3,5,1,4
+----
+30 values hashing to a33bb527d06a2910c9a6c62eca6505b7
+
+query IIIII nosort
+SELECT b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ b-c,
+ c,
+ abs(b-c)
+ FROM t1
+ WHERE c>d
+ AND (e>c OR e<d)
+ AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ ORDER BY 1,3,2,5,4
+----
+50 values hashing to 3ee816fcef04a3eec0ebe12b5f6d1358
+
+query IIIIIII nosort
+SELECT abs(b-c),
+ a+b*2,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c-d
+ FROM t1
+ ORDER BY 6,2,1,3,4,7,5
+----
+210 values hashing to 2086c3df1975d9993bfa394053028c8f
+
+query IIIIIII nosort
+SELECT (a+b+c+d+e)/5,
+ a+b*2+c*3+d*4,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c-d,
+ a+b*2+c*3+d*4+e*5,
+ d
+ FROM t1
+ WHERE a>b
+ AND c BETWEEN b-2 AND d+2
+ ORDER BY 5,6,3,7,2,4,1
+----
+105 values hashing to 32404e31bbeb9f3a9e286caaf42683bf
+
+query IIIIIII nosort
+SELECT a+b*2+c*3,
+ b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ abs(a),
+ a+b*2,
+ a
+ FROM t1
+ WHERE d>e
+ OR c>d
+ OR e+d BETWEEN a+b-10 AND c+130
+ ORDER BY 6,2,1,7,5,4,3
+----
+175 values hashing to 1086608e130bcb51302b4bfea65791e1
+
+query II nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ c
+ FROM t1
+ WHERE (e>c OR e<d)
+ ORDER BY 1,2
+----
+54 values hashing to e0a9aff1c8ce9380036deac54055bb55
+
+query III nosort
+SELECT a,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2
+ FROM t1
+ ORDER BY 1,2,3
+----
+90 values hashing to 23fade28502d6270c32ef8abb80c2587
+
+query IIII nosort
+SELECT abs(a),
+ a-b,
+ a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 4,2,1,3
+----
+120 values hashing to c0fb0d9f06fa5550406b035929522753
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ a+b*2,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ d,
+ b
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR (e>a AND e<b)
+ ORDER BY 6,3,1,5,4,2
+----
+144 values hashing to 8fcce962010f9d02b8f88fe335f942d6
+
+query III nosort
+SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
+ FROM t1
+ WHERE c>d
+ OR c BETWEEN b-2 AND d+2
+ OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ ORDER BY 2,3,1
+----
+90 values hashing to 622e9a88d60bdd5066c19a3843a170f7
+
+query I nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
+ FROM t1
+ WHERE a>b
+ OR (e>a AND e<b)
+ ORDER BY 1
+----
+23 values hashing to 170b11bfad55c44388691ff914c121af
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4+e*5,
+ d,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ b-c,
+ (a+b+c+d+e)/5
+ FROM t1
+ ORDER BY 1,3,6,2,5,4
+----
+180 values hashing to 76cb0f185711243083f4b8769f948815
+
+query IIIII nosort
+SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ c-d,
+ abs(b-c),
+ a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ AND a>b
+ ORDER BY 4,1,5,3,2
+----
+35 values hashing to 3af25b67f93d88c1a5f7c4641a52f3f5
+
+query IIIIII nosort
+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,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ e,
+ d,
+ a-b
+ FROM t1
+ ORDER BY 2,3,4,5,6,1
+----
+180 values hashing to dd0992af784793780e0941bfc46d5c17
+
diff --git a/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p6.test_ignored b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p6.test_ignored
new file mode 100644
index 0000000000..a99cc8d0cd
--- /dev/null
+++ b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p6.test_ignored
@@ -0,0 +1,212 @@
+# Ignore https://issues.apache.org/jira/browse/IGNITE-17612
+
+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(103,102,100,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,111,113)
+
+statement ok
+INSERT INTO t1(d,c,e,a,b) VALUES(116,119,117,115,118)
+
+statement ok
+INSERT INTO t1(c,d,b,e,a) VALUES(123,122,124,120,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,148,147)
+
+statement ok
+INSERT INTO t1(b,c,a,d,e) VALUES(151,150,153,154,152)
+
+statement ok
+INSERT INTO t1(c,e,a,d,b) VALUES(155,157,159,156,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,169,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,178,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(200,202,203,201,204)
+
+statement ok
+INSERT INTO t1(c,e,a,b,d) VALUES(208,209,205,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,235,238)
+
+statement ok
+INSERT INTO t1(e,c,b,a,d) VALUES(242,244,240,243,241)
+
+statement ok
+INSERT INTO t1(e,d,c,b,a) VALUES(246,248,247,249,245)
+
+query IIIIII nosort
+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,
+ d-e,
+ c-d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(b-c)
+ FROM t1
+ WHERE b>c
+ ORDER BY 6,5,3,2,4,1
+----
+84 values hashing to 4eacead92f2a04db9b0334482576382b
+
+query IIIIII nosort
+SELECT a-b,
+ d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3,
+ a+b*2+c*3+d*4+e*5,
+ (a+b+c+d+e)/5
+ FROM t1
+ WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ OR b>c
+ ORDER BY 1,4,2,5,6,3
+----
+174 values hashing to 742703bb047dc6b6254470d20be52ae0
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ c,
+ a+b*2+c*3+d*4+e*5,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d
+ FROM t1
+ WHERE b>c
+ AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ AND (e>c OR e<d)
+ ORDER BY 6,2,1,3,5,4
+----
+78 values hashing to 2bc2b9f40afbeff305b8b1bbb990f54d
+
+query IIIII nosort
+SELECT a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ e,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ abs(b-c)
+ FROM t1
+ WHERE c>d
+ AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ AND e+d BETWEEN a+b-10 AND c+130
+ ORDER BY 4,3,5,2,1
+----
+10 values hashing to 2d123a0355480421449ef9e36dafe214
+
+query III nosort
+SELECT a+b*2+c*3+d*4,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a
+ FROM t1
+ ORDER BY 1,2,3
+----
+90 values hashing to d8520212db20c57541d0c28d4fddae94
+
+query IIIIII nosort
+SELECT abs(a),
+ e,
+ c-d,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ AND b>c
+ ORDER BY 5,3,6,1,4,2
+----
+48 values hashing to 603d52ce942c28eb4f224d7e9ea74524
+
+query II nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END
+ FROM t1
+ WHERE a>b
+ OR c BETWEEN b-2 AND d+2
+ OR (a>b-2 AND a<b+2)
+ ORDER BY 2,1
+----
+52 values hashing to fb874a11725bff133c5555192c29d1d4
+
+query II nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(a)
+ FROM t1
+ ORDER BY 1,2
+----
+60 values hashing to 60ed925e6266c564dc3551acfa13417d
+
+query IIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ b,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ c-d
+ FROM t1
+ WHERE a>b
+ OR e+d BETWEEN a+b-10 AND c+130
+ ORDER BY 5,3,1,4,2
+----
+115 values hashing to 87b7852145d2cd4b4aef60d7fde294ca
+
diff --git a/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p7.test_ignored b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p7.test_ignored
new file mode 100644
index 0000000000..0a6f02bb8d
--- /dev/null
+++ b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p7.test_ignored
@@ -0,0 +1,333 @@
+# Ignore https://issues.apache.org/jira/browse/IGNITE-17612
+
+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(103,102,100,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,111,113)
+
+statement ok
+INSERT INTO t1(d,c,e,a,b) VALUES(116,119,117,115,118)
+
+statement ok
+INSERT INTO t1(c,d,b,e,a) VALUES(123,122,124,120,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,148,147)
+
+statement ok
+INSERT INTO t1(b,c,a,d,e) VALUES(151,150,153,154,152)
+
+statement ok
+INSERT INTO t1(c,e,a,d,b) VALUES(155,157,159,156,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,169,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,178,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(200,202,203,201,204)
+
+statement ok
+INSERT INTO t1(c,e,a,b,d) VALUES(208,209,205,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,235,238)
+
+statement ok
+INSERT INTO t1(e,c,b,a,d) VALUES(242,244,240,243,241)
+
+statement ok
+INSERT INTO t1(e,d,c,b,a) VALUES(246,248,247,249,245)
+
+query IIIIII nosort
+SELECT b-c,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d,
+ a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ b
+ FROM t1
+ ORDER BY 2,6,3,1,4,5
+----
+180 values hashing to 0237184a8878edf72b431a6c9bcfcbf2
+
+query III nosort
+SELECT e,
+ a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE a>b
+ ORDER BY 1,2,3
+----
+57 values hashing to c8d389e6c270e554bc93a318ef21e848
+
+query IIII nosort
+SELECT b-c,
+ d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ ORDER BY 2,3,1,4
+----
+44 values hashing to 4ee79810a1704816bba77ef7c8033bfb
+
+query IIIIII nosort
+SELECT abs(a),
+ a,
+ c,
+ d-e,
+ a+b*2,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
+ FROM t1
+ ORDER BY 1,6,3,5,4,2
+----
+180 values hashing to dfff98b6d7e9b049c8feace97a7eb622
+
+query IIIII nosort
+SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ a+b*2,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ a+b*2+c*3+d*4+e*5,
+ a+b*2+c*3+d*4
+ FROM t1
+ ORDER BY 2,3,1,5,4
+----
+150 values hashing to 1db48656258028dd2a0274c1f20a4e6c
+
+query IIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d-e,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ b,
+ a+b*2+c*3
+ FROM t1
+ WHERE (e>c OR e<d)
+ ORDER BY 3,5,4,6,2,1
+----
+162 values hashing to ec8ccfd9d87f0f620283a1dae7d24434
+
+query IIIIIII nosort
+SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ a+b*2+c*3,
+ (a+b+c+d+e)/5,
+ b,
+ c,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ a-b
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ ORDER BY 3,5,7,2,4,6,1
+----
+42 values hashing to 86eba634c2a25d3e9a0aca99b8b9b7a3
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ a-b,
+ a+b*2+c*3+d*4,
+ a,
+ a+b*2+c*3+d*4+e*5,
+ c-d
+ FROM t1
+ WHERE d>e
+ OR (c<=d-2 OR c>=d+2)
+ ORDER BY 7,3,2,4,6,1,5
+----
+154 values hashing to ead80733a2080af9498e2ac38198e68e
+
+query III nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (a+b+c+d+e)/5,
+ b
+ FROM t1
+ ORDER BY 3,1,2
+----
+90 values hashing to 05b2f3f52d4f5af4cf24810c343f5954
+
+query IIIIII nosort
+SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c,
+ b-c
+ FROM t1
+ WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ OR a>b
+ OR d NOT BETWEEN 110 AND 150
+ ORDER BY 5,3,6,1,2,4
+----
+180 values hashing to 631b9506abcdd5dcea64c7ed2a3799ed
+
+query IIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d,
+ a+b*2+c*3+d*4,
+ a-b,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR c>d
+ ORDER BY 3,5,4,1,2
+----
+125 values hashing to 58b4ab36ed442f3837188b38cd02486a
+
+query IIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ c-d,
+ a-b
+ FROM t1
+ WHERE (e>c OR e<d)
+ ORDER BY 3,5,4,1,2
+----
+135 values hashing to 635b37bb69d24a1353243f6975112cea
+
+query IIIIIII nosort
+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,
+ (a+b+c+d+e)/5,
+ abs(b-c),
+ abs(a),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ ORDER BY 7,2,5,1,3,6,4
+----
+154 values hashing to b82f838cd6b2f0034ba34f8069a36b09
+
+query III nosort
+SELECT (a+b+c+d+e)/5,
+ e,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (e>c OR e<d)
+ OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ ORDER BY 3,1,2
+----
+90 values hashing to 66be8c935b54646fa54e09d50724c3fc
+
+query IIII nosort
+SELECT a-b,
+ a+b*2,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d-e
+ FROM t1
+ WHERE d>e
+ OR (e>a AND e<b)
+ ORDER BY 4,1,3,2
+----
+72 values hashing to 25a13d479847a5eb07e7e6088d47b373
+
+query IIIIII nosort
+SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d-e,
+ b,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ a+b*2
+ FROM t1
+ WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ OR (a>b-2 AND a<b+2)
+ ORDER BY 2,6,3,5,4,1
+----
+174 values hashing to bf3a367003c73007e24f49edd2245ff8
+
+query IIIII nosort
+SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ c-d,
+ abs(a),
+ abs(b-c),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ ORDER BY 1,5,3,2,4
+----
+145 values hashing to 8024d1eebf4b583f802c8e24ef08700f
+
+query II nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a-b
+ FROM t1
+ WHERE b>c
+ ORDER BY 1,2
+----
+28 values hashing to 2d23fde26e5c80f6eabca42e592bde71
+
+query III nosort
+SELECT a-b,
+ a+b*2+c*3+d*4,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (e>c OR e<d)
+ ORDER BY 1,2,3
+----
+81 values hashing to 21c30dc6df3b8c769f84c72451f968b5
+
diff --git a/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p8.test_ignored b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p8.test_ignored
new file mode 100644
index 0000000000..bde032a164
--- /dev/null
+++ b/modules/runner/src/integrationTest/sql/sqlite/select1/select1_p8.test_ignored
@@ -0,0 +1,485 @@
+# Ignore https://issues.apache.org/jira/browse/IGNITE-17612
+
+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(103,102,100,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,111,113)
+
+statement ok
+INSERT INTO t1(d,c,e,a,b) VALUES(116,119,117,115,118)
+
+statement ok
+INSERT INTO t1(c,d,b,e,a) VALUES(123,122,124,120,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,148,147)
+
+statement ok
+INSERT INTO t1(b,c,a,d,e) VALUES(151,150,153,154,152)
+
+statement ok
+INSERT INTO t1(c,e,a,d,b) VALUES(155,157,159,156,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,169,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,178,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(200,202,203,201,204)
+
+statement ok
+INSERT INTO t1(c,e,a,b,d) VALUES(208,209,205,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,235,238)
+
+statement ok
+INSERT INTO t1(e,c,b,a,d) VALUES(242,244,240,243,241)
+
+statement ok
+INSERT INTO t1(e,d,c,b,a) VALUES(246,248,247,249,245)
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d,
+ b-c,
+ (a+b+c+d+e)/5,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ a-b
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR (e>c OR e<d)
+ OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ ORDER BY 7,2,4,1,5,6,3
+----
+210 values hashing to 4abfb880f67a314446d0402a24ae5282
+
+query III nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
+ FROM t1
+ ORDER BY 1,3,2
+----
+90 values hashing to 87301227ae0731f419456d467d0e095f
+
+query IIII nosort
+SELECT (a+b+c+d+e)/5,
+ a+b*2+c*3+d*4,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ abs(a)
+ FROM t1
+ WHERE (e>a AND e<b)
+ AND d NOT BETWEEN 110 AND 150
+ ORDER BY 4,3,1,2
+----
+12 values hashing to c334c687262c72da162e191703935928
+
+query IIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d,
+ CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ e
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ ORDER BY 4,3,2,1
+----
+24 values hashing to 746dff67b6166bb25993d89eaa93e7a3
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ (a+b+c+d+e)/5,
+ c-d,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ d,
+ a+b*2+c*3+d*4,
+ abs(a)
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ ORDER BY 2,5,1,3,7,6,4
+----
+105 values hashing to b3e0305b909d1f2abf1dc3c1745ac029
+
+query III nosort
+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,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 1,2,3
+----
+90 values hashing to 28225a47a6332aa64342b0faecc4ffde
+
+query III nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c,
+ a+b*2+c*3
+ FROM t1
+ WHERE d NOT BETWEEN 110 AND 150
+ AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ ORDER BY 2,1,3
+----
+63 values hashing to 77cf402238c411fd045a6a991c7dec12
+
+query IIIII nosort
+SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ d-e,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3,
+ a+b*2+c*3+d*4+e*5
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ AND a>b
+ AND (e>c OR e<d)
+ ORDER BY 2,5,3,4,1
+----
+45 values hashing to 75ef6cb7d694759a04fb38d0d80ea6fb
+
+query I nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR (e>c OR e<d)
+ OR a>b
+ ORDER BY 1
+----
+28 values hashing to a76dc8384405fa57100e5dffbbd99b99
+
+query IIIII nosort
+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,
+ c,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4+e*5
+ FROM t1
+ WHERE (a>b-2 AND a<b+2)
+ ORDER BY 2,3,1,5,4
+----
+55 values hashing to 625bcace071d982d6c04cc1ddfe8378c
+
+query IIIIIII nosort
+SELECT d-e,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ c-d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4,
+ a+b*2
+ FROM t1
+ ORDER BY 6,2,5,1,4,7,3
+----
+210 values hashing to b7fc5840ce267465864efec4638ec6ad
+
+query IIIIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d-e,
+ a+b*2+c*3+d*4+e*5,
+ a+b*2+c*3,
+ a+b*2,
+ abs(b-c),
+ d
+ FROM t1
+ WHERE d>e
+ ORDER BY 3,4,2,6,5,7,1
+----
+112 values hashing to 3a34b6923ab936224547f54261b88bd9
+
+query IIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2,
+ c,
+ a+b*2+c*3+d*4+e*5,
+ d-e
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ OR c>d
+ OR b>c
+ ORDER BY 4,2,3,5,1
+----
+135 values hashing to 4305481e9a7ca71ef955b400497b8a93
+
+query IIII nosort
+SELECT a,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ c-d,
+ b
+ FROM t1
+ ORDER BY 4,3,2,1
+----
+120 values hashing to 343df600fb44be4495c01502f42dbc1c
+
+query IIII nosort
+SELECT b,
+ e,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 2,3,1,4
+----
+120 values hashing to 1e0e23f922af975b4024bd2bfd71ca2e
+
+query IIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4+e*5,
+ 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 d NOT BETWEEN 110 AND 150
+ AND a>b
+ ORDER BY 3,4,2,1
+----
+68 values hashing to efb249f37bdc0e2144ea0f8a265caab5
+
+query IIII nosort
+SELECT a+b*2+c*3,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE (c<=d-2 OR c>=d+2)
+ ORDER BY 3,4,1,2
+----
+60 values hashing to d5adb2536f4ed1202bbffe836134c8b8
+
+query IIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ c-d,
+ a+b*2+c*3+d*4
+ FROM t1
+ WHERE a>b
+ ORDER BY 2,4,1,3
+----
+76 values hashing to c842520d07c8a4805c0e9c46781e4e44
+
+query IIIIII nosort
+SELECT (a+b+c+d+e)/5,
+ c-d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.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,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b)
+ FROM t1
+ WHERE d>e
+ ORDER BY 1,6,2,5,4,3
+----
+96 values hashing to 521dca6d96de8a96e1ee4b3bfd22ca84
+
+query IIII nosort
+SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ a+b*2+c*3+d*4,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
+ OR (c<=d-2 OR c>=d+2)
+ ORDER BY 2,4,3,1
+----
+116 values hashing to 7475b1713d2bb04b2f15460ec5487648
+
+query II nosort
+SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE c>d
+ ORDER BY 2,1
+----
+28 values hashing to 7bb527bc1d2528e5b09d04fcd8e6a1fb
+
+query IIIIIII nosort
+SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ a+b*2,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ a-b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ b
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ ORDER BY 6,1,2,3,7,4,5
+----
+154 values hashing to c4f2247a413e6c36412edaf2b966c320
+
+query IIIIII nosort
+SELECT a+b*2+c*3+d*4+e*5,
+ CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
+ WHEN a<b+3 THEN 333 ELSE 444 END,
+ 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,
+ c-d,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ ORDER BY 3,5,1,4,2,6
+----
+180 values hashing to fda423ac986fe8647b30d631dafb83fa
+
+query IIIIIII nosort
+SELECT b,
+ a-b,
+ e,
+ d,
+ abs(a),
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ AND d>e
+ ORDER BY 2,1,5,3,6,4,7
+----
+105 values hashing to ad1f447f56a3bc9d467abea530124a7c
+
+query IIIII nosort
+SELECT b,
+ a-b,
+ a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ d
+ FROM t1
+ WHERE d NOT BETWEEN 110 AND 150
+ AND c>d
+ ORDER BY 1,2,3,5,4
+----
+45 values hashing to 170723580d1cb9c1114c2269200ebca6
+
+query IIIIIII nosort
+SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ b,
+ a+b*2+c*3,
+ a-b,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a+b*2+c*3+d*4
+ FROM t1
+ ORDER BY 4,3,5,2,7,1,6
+----
+210 values hashing to 7a0a8f77c3a0e99e5adda38c1771c18e
+
+query IIIIII nosort
+SELECT 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,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ d-e,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a
+ FROM t1
+ ORDER BY 6,4,5,3,2,1
+----
+180 values hashing to 360a865da8121bc0977f7658d1dfd557
+
+query IIIII nosort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ a-b,
+ b,
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
+ e
+ FROM t1
+ ORDER BY 1,5,4,3,2
+----
+150 values hashing to 37ae594d2c57e581ced3eaa5665cc2db
+
+query IIII nosort
+SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222
+ WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ (a+b+c+d+e)/5
+ FROM t1
+ WHERE c BETWEEN b-2 AND d+2
+ OR d>e
+ OR a>b
+ ORDER BY 2,3,1,4
+----
+108 values hashing to 51ad3b8a1b881292bb3b372941aa523b
+
+query IIIIII nosort
+SELECT (a+b+c+d+e)/5,
+ c-d,
+ (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b),
+ abs(b-c),
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ b-c
+ FROM t1
+ WHERE e+d BETWEEN a+b-10 AND c+130
+ OR (c<=d-2 OR c>=d+2)
+ OR d>e
+ ORDER BY 2,1,3,5,6,4
+----
+138 values hashing to 99d143bc2979104655dbd53c1ebb9daf
+
+query IIII nosort
+SELECT e,
+ a+b*2+c*3+d*4+e*5,
+ (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
+ CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
+ FROM t1
+ ORDER BY 2,3,4,1
+----
+120 values hashing to 3ce25b7100fcbfe7c7142b3160cb9ebf
+