This is an automated email from the ASF dual-hosted git repository.
lihaopeng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new d53f006c6f9 [Chore](topn) add case for topn opt (#38154)
d53f006c6f9 is described below
commit d53f006c6f9ce08a737c4190b24d7fd4f14cb2f8
Author: Pxl <[email protected]>
AuthorDate: Wed Jul 24 00:18:15 2024 +0800
[Chore](topn) add case for topn opt (#38154)
---
.../data/nereids_arith_p0/topn_alltype.out | 1207 ++++++++++++++++++++
.../suites/nereids_arith_p0/load.groovy | 43 +
.../suites/nereids_arith_p0/topn_alltype.groovy | 433 +++++++
3 files changed, 1683 insertions(+)
diff --git a/regression-test/data/nereids_arith_p0/topn_alltype.out
b/regression-test/data/nereids_arith_p0/topn_alltype.out
new file mode 100644
index 00000000000..22f0f3a24a6
--- /dev/null
+++ b/regression-test/data/nereids_arith_p0/topn_alltype.out
@@ -0,0 +1,1207 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !boolean --
+\N
+1
+2
+
+-- !boolean --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !tinyint --
+\N
+1
+13
+
+-- !tinyint --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !smallint --
+\N
+1
+13
+
+-- !smallint --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !int --
+\N
+1
+13
+
+-- !int --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !bigint --
+\N
+1
+13
+
+-- !bigint --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !largeint --
+\N
+1
+13
+
+-- !largeint --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !varchar --
+18
+19
+24
+
+-- !varchar --
+\N
+1
+4
+13
+14
+15
+16
+17
+18
+19
+20
+21
+22
+23
+24
+
+-- !char --
+13
+19
+20
+
+-- !char --
+1
+4
+7
+13
+14
+15
+16
+17
+18
+19
+20
+21
+22
+23
+24
+
+-- !str --
+13
+14
+20
+
+-- !str --
+\N
+1
+4
+13
+14
+15
+16
+17
+18
+19
+20
+21
+22
+23
+24
+
+-- !date --
+\N
+1
+13
+
+-- !date --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !datev2 --
+\N
+1
+13
+
+-- !datev2 --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !datetime --
+\N
+1
+13
+
+-- !datetime --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !datetimev2 --
+\N
+1
+13
+
+-- !datetimev2 --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !decimal32 --
+\N
+1
+2
+
+-- !decimal32 --
+\N
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+
+-- !decimal64 --
+\N
+1
+2
+
+-- !decimal64 --
+\N
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+
+-- !decimal128 --
+\N
+1
+2
+
+-- !decimal128 --
+\N
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+
+-- !decimalv2 --
+\N
+1
+13
+
+-- !decimalv2 --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !decimal256 --
+1
+2
+3
+
+-- !decimal256 --
+1
+2
+3
+4
+5
+
+-- !ipv4 --
+1
+2
+3
+
+-- !ipv4 --
+1
+1
+2
+2
+3
+
+-- !ipv6 --
+1
+2
+3
+
+-- !ipv6 --
+1
+1
+2
+2
+3
+
+-- !boolean --
+1
+2
+3
+
+-- !boolean --
+1
+2
+3
+4
+5
+6
+7
+8
+13
+14
+15
+16
+17
+18
+19
+
+-- !tinyint --
+1
+2
+13
+
+-- !tinyint --
+1
+2
+3
+4
+5
+6
+7
+8
+13
+14
+15
+16
+17
+18
+19
+
+-- !smallint --
+1
+2
+13
+
+-- !smallint --
+1
+2
+3
+4
+5
+6
+7
+8
+13
+14
+15
+16
+17
+18
+19
+
+-- !int --
+1
+2
+13
+
+-- !int --
+1
+2
+3
+4
+5
+6
+7
+8
+13
+14
+15
+16
+17
+18
+19
+
+-- !bigint --
+1
+2
+13
+
+-- !bigint --
+1
+2
+3
+4
+5
+6
+7
+8
+13
+14
+15
+16
+17
+18
+19
+
+-- !largeint --
+1
+2
+13
+
+-- !largeint --
+1
+2
+3
+4
+5
+6
+7
+8
+13
+14
+15
+16
+17
+18
+19
+
+-- !varchar --
+18
+19
+24
+
+-- !varchar --
+1
+4
+7
+13
+14
+15
+16
+17
+18
+19
+20
+21
+22
+23
+24
+
+-- !char --
+13
+19
+20
+
+-- !char --
+1
+4
+7
+13
+14
+15
+16
+17
+18
+19
+20
+21
+22
+23
+24
+
+-- !str --
+13
+14
+20
+
+-- !str --
+1
+4
+7
+13
+14
+15
+16
+17
+18
+19
+20
+21
+22
+23
+24
+
+-- !date --
+1
+2
+13
+
+-- !date --
+1
+2
+3
+4
+5
+6
+7
+8
+13
+14
+15
+16
+17
+18
+19
+
+-- !datev2 --
+1
+2
+13
+
+-- !datev2 --
+1
+2
+3
+4
+5
+6
+7
+8
+13
+14
+15
+16
+17
+18
+19
+
+-- !datetime --
+1
+2
+13
+
+-- !datetime --
+1
+2
+3
+4
+5
+6
+7
+8
+13
+14
+15
+16
+17
+18
+19
+
+-- !datetimev2 --
+1
+2
+13
+
+-- !datetimev2 --
+1
+2
+3
+4
+5
+6
+7
+8
+13
+14
+15
+16
+17
+18
+19
+
+-- !decimal32 --
+1
+2
+3
+
+-- !decimal32 --
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+15
+
+-- !decimal64 --
+1
+2
+3
+
+-- !decimal64 --
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+15
+
+-- !decimal128 --
+1
+2
+3
+
+-- !decimal128 --
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+15
+
+-- !decimalv2 --
+1
+2
+13
+
+-- !decimalv2 --
+1
+2
+3
+4
+5
+6
+7
+8
+13
+14
+15
+16
+17
+18
+19
+
+-- !decimal256 --
+1
+4
+5
+
+-- !decimal256 --
+1
+2
+3
+4
+5
+
+-- !ipv4 --
+1
+1
+2
+
+-- !ipv4 --
+1
+1
+2
+2
+3
+
+-- !ipv6 --
+2
+3
+3
+
+-- !ipv6 --
+1
+2
+2
+3
+3
+
+-- !boolean --
+\N
+1
+2
+
+-- !boolean --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !tinyint --
+\N
+1
+13
+
+-- !tinyint --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !smallint --
+\N
+1
+13
+
+-- !smallint --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !int --
+\N
+1
+13
+
+-- !int --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !bigint --
+\N
+1
+13
+
+-- !bigint --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !largeint --
+\N
+1
+13
+
+-- !largeint --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !varchar --
+18
+19
+24
+
+-- !varchar --
+\N
+1
+4
+13
+14
+15
+16
+17
+18
+19
+20
+21
+22
+23
+24
+
+-- !char --
+13
+19
+20
+
+-- !char --
+1
+4
+7
+13
+14
+15
+16
+17
+18
+19
+20
+21
+22
+23
+24
+
+-- !str --
+13
+14
+20
+
+-- !str --
+\N
+1
+4
+13
+14
+15
+16
+17
+18
+19
+20
+21
+22
+23
+24
+
+-- !date --
+\N
+1
+13
+
+-- !date --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !datev2 --
+\N
+1
+13
+
+-- !datev2 --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !datetime --
+\N
+1
+13
+
+-- !datetime --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !datetimev2 --
+\N
+1
+13
+
+-- !datetimev2 --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !decimal32 --
+\N
+1
+2
+
+-- !decimal32 --
+\N
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+
+-- !decimal64 --
+\N
+1
+2
+
+-- !decimal64 --
+\N
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+
+-- !decimal128 --
+\N
+1
+2
+
+-- !decimal128 --
+\N
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+
+-- !decimalv2 --
+\N
+1
+13
+
+-- !decimalv2 --
+\N
+1
+2
+3
+4
+5
+6
+7
+13
+14
+15
+16
+17
+18
+19
+
+-- !decimal256 --
+1
+2
+3
+
+-- !decimal256 --
+1
+2
+3
+4
+5
+
diff --git a/regression-test/suites/nereids_arith_p0/load.groovy
b/regression-test/suites/nereids_arith_p0/load.groovy
index ff8eedfa3c0..791dd32559b 100644
--- a/regression-test/suites/nereids_arith_p0/load.groovy
+++ b/regression-test/suites/nereids_arith_p0/load.groovy
@@ -92,4 +92,47 @@ suite("load") {
sql """
insert into expr_test_not_nullable select * from expr_test where id is
not null
"""
+
+ sql "set enable_decimal256=true;"
+ sql """
+ CREATE TABLE IF NOT EXISTS `expr_test2` (
+ `id` int null,
+ `kipv4` ipv4 null,
+ `kipv6` ipv6 null,
+ `kdcml256v3` decimalv3(76, 66) null
+ ) engine=olap
+ DISTRIBUTED BY HASH(`id`) BUCKETS 4
+ properties("replication_num" = "1")
+ """
+
+ sql """
+ CREATE TABLE IF NOT EXISTS `expr_test_not_nullable2` (
+ `id` int null,
+ `kipv4` ipv4 not null,
+ `kipv6` ipv6 not null,
+ `kdcml256v3` decimalv3(76, 66) not null
+ ) engine=olap
+ DISTRIBUTED BY HASH(`id`) BUCKETS 4
+ properties("replication_num" = "1")
+ """
+
+ sql"""
+ insert into expr_test2
values(1,"192.168.1.1","ffff:0000:0000:0000:0000:0000:0000:0001",1.1),(2,"192.168.1.2","ffff:0000:0000:0000:0000:0000:0000:0002",2.2),(3,"192.168.1.3","ffff:0000:0000:0000:0000:0000:0000:0003",3.3),(4,"192.168.1.4","ffff:0000:0000:0000:0000:0000:0000:0004",4.4),(5,"192.168.1.5","ffff:0000:0000:0000:0000:0000:0000:0005",5.5)
+ """
+
+ sql"""
+ insert into expr_test2
values(1,"192.168.11.1","ffff:0000:0000:0000:0000:0000:0100:0001",11.1),(2,"192.168.11.2","ffff:0000:0000:0000:0000:0000:0010:0002",22.2),(3,"192.168.11.3","ffff:0000:0000:0000:0000:0000:0001:0003",33.3),(4,"192.168.11.4","ffff:0000:0000:0000:0000:0100:0000:0004",44.4),(5,"192.168.11.5","ffff:0000:0000:0000:0000:0000:0100:0005",55.5)
+ """
+
+ sql"""
+ insert into expr_test2
values(1,null,null,null),(2,null,null,null),(3,null,null,null),(4,"192.168.1.4","ffff:0000:0000:0000:0000:0000:0000:0004",null),(5,"192.168.1.5","ffff:0000:0000:0000:0000:0000:0000:0005",null)
+ """
+
+ sql"""
+ insert into expr_test_not_nullable2
values(1,"192.168.11.1","ffff:0000:0000:0000:0000:0000:0100:0001",11.1),(2,"192.168.11.2","ffff:0000:0000:0000:0000:0000:0010:0002",22.2),(3,"192.168.11.3","ffff:0000:0000:0000:0000:0000:0001:0003",33.3),(4,"192.168.11.4","ffff:0000:0000:0000:0000:0100:0000:0004",44.4),(5,"192.168.11.5","ffff:0000:0000:0000:0000:0000:0100:0005",55.5)
+ """
+
+ sql"""
+ insert into expr_test_not_nullable2
values(1,"192.168.11.1","ffff:0000:0000:0000:0000:0000:0100:0001",32.1),(2,"192.168.11.2","ffff:0000:0000:0000:0000:0000:0010:0002",21.3),(3,"192.168.11.3","ffff:0000:0000:0000:0000:0000:0001:0003",12.4),(4,"192.168.11.4","ffff:0000:0000:0000:0000:0100:0000:0004",5.5),(5,"192.168.11.5","ffff:0000:0000:0000:0000:0000:0100:0005",6.7)
+ """
}
\ No newline at end of file
diff --git a/regression-test/suites/nereids_arith_p0/topn_alltype.groovy
b/regression-test/suites/nereids_arith_p0/topn_alltype.groovy
new file mode 100644
index 00000000000..3f43623ed27
--- /dev/null
+++ b/regression-test/suites/nereids_arith_p0/topn_alltype.groovy
@@ -0,0 +1,433 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+import org.codehaus.groovy.runtime.IOGroovyMethods
+
+suite ("topn_alltype") {
+ qt_boolean"""
+ select * from (select id from expr_test order by kbool,id limit 3)t order
by id;
+ """
+ qt_boolean"""
+ select * from (select id from expr_test order by kbool,id limit 15)t order
by id;
+ """
+
+ qt_tinyint"""
+ select * from (select id from expr_test order by ktint,id limit 3)t order
by id;
+ """
+ qt_tinyint"""
+ select * from (select id from expr_test order by ktint,id limit 15)t order
by id;
+ """
+
+ qt_smallint"""
+ select * from (select id from expr_test order by ksint,id limit 3)t order
by id;
+ """
+ qt_smallint"""
+ select * from (select id from expr_test order by ksint,id limit 15)t order
by id;
+ """
+
+ qt_int"""
+ select * from (select id from expr_test order by kint,id limit 3)t order by
id;
+ """
+ qt_int"""
+ select * from (select id from expr_test order by kint,id limit 15)t order
by id;
+ """
+
+ qt_bigint"""
+ select * from (select id from expr_test order by kbint,id limit 3)t order
by id;
+ """
+ qt_bigint"""
+ select * from (select id from expr_test order by kbint,id limit 15)t order
by id;
+ """
+
+ qt_largeint"""
+ select * from (select id from expr_test order by klint,id limit 3)t order
by id;
+ """
+ qt_largeint"""
+ select * from (select id from expr_test order by klint,id limit 15)t order
by id;
+ """
+
+ qt_varchar"""
+ select * from (select id from expr_test order by kvchr,id limit 3)t order
by id;
+ """
+ qt_varchar"""
+ select * from (select id from expr_test order by kvchr,id limit 15)t order
by id;
+ """
+
+ qt_char"""
+ select * from (select id from expr_test order by kchr,id limit 3)t order by
id;
+ """
+ qt_char"""
+ select * from (select id from expr_test order by kchr,id limit 15)t order
by id;
+ """
+
+ qt_str"""
+ select * from (select id from expr_test order by kstr,id limit 3)t order by
id;
+ """
+ qt_str"""
+ select * from (select id from expr_test order by kstr,id limit 15)t order
by id;
+ """
+
+ qt_date"""
+ select * from (select id from expr_test order by kdt,id limit 3)t order by
id;
+ """
+ qt_date"""
+ select * from (select id from expr_test order by kdt,id limit 15)t order by
id;
+ """
+
+ qt_datev2"""
+ select * from (select id from expr_test order by kdtv2,id limit 3)t order
by id;
+ """
+ qt_datev2"""
+ select * from (select id from expr_test order by kdtv2,id limit 15)t order
by id;
+ """
+
+ qt_datetime"""
+ select * from (select id from expr_test order by kdtm,id limit 3)t order by
id;
+ """
+ qt_datetime"""
+ select * from (select id from expr_test order by kdtm,id limit 15)t order
by id;
+ """
+
+ qt_datetimev2"""
+ select * from (select id from expr_test order by kdtmv2,id limit 3)t order
by id;
+ """
+ qt_datetimev2"""
+ select * from (select id from expr_test order by kdtmv2,id limit 15)t order
by id;
+ """
+
+ qt_decimal32"""
+ select * from (select id from expr_test order by kdcml32v3,id limit 3)t
order by id;
+ """
+ qt_decimal32"""
+ select * from (select id from expr_test order by kdcml32v3,id limit 15)t
order by id;
+ """
+
+ qt_decimal64"""
+ select * from (select id from expr_test order by kdcml64v3,id limit 3)t
order by id;
+ """
+ qt_decimal64"""
+ select * from (select id from expr_test order by kdcml64v3,id limit 15)t
order by id;
+ """
+
+ qt_decimal128"""
+ select * from (select id from expr_test order by kdcml128v3,id limit 3)t
order by id;
+ """
+ qt_decimal128"""
+ select * from (select id from expr_test order by kdcml128v3,id limit 15)t
order by id;
+ """
+
+ qt_decimalv2"""
+ select * from (select id from expr_test order by kdtmv2,id limit 3)t order
by id;
+ """
+ qt_decimalv2"""
+ select * from (select id from expr_test order by kdtmv2,id limit 15)t order
by id;
+ """
+
+ sql "set enable_decimal256=true;"
+ qt_decimal256"""
+ select * from (select id from expr_test2 order by kdcml256v3,id limit 3)t
order by id;
+ """
+ qt_decimal256"""
+ select * from (select id from expr_test2 order by kdcml256v3,id limit 5)t
order by id;
+ """
+
+ qt_ipv4"""
+ select * from (select id from expr_test2 order by kipv4,id limit 3)t order
by id;
+ """
+ qt_ipv4"""
+ select * from (select id from expr_test2 order by kipv4,id limit 5)t order
by id;
+ """
+ qt_ipv6"""
+ select * from (select id from expr_test2 order by kipv6,id limit 3)t order
by id;
+ """
+ qt_ipv6"""
+ select * from (select id from expr_test2 order by kipv6,id limit 5)t order
by id;
+ """
+
+
+
+ // not nullable
+ qt_boolean"""
+ select * from (select id from expr_test_not_nullable order by kbool,id
limit 3)t order by id;
+ """
+ qt_boolean"""
+ select * from (select id from expr_test_not_nullable order by kbool,id
limit 15)t order by id;
+ """
+
+ qt_tinyint"""
+ select * from (select id from expr_test_not_nullable order by ktint,id
limit 3)t order by id;
+ """
+ qt_tinyint"""
+ select * from (select id from expr_test_not_nullable order by ktint,id
limit 15)t order by id;
+ """
+
+ qt_smallint"""
+ select * from (select id from expr_test_not_nullable order by ksint,id
limit 3)t order by id;
+ """
+ qt_smallint"""
+ select * from (select id from expr_test_not_nullable order by ksint,id
limit 15)t order by id;
+ """
+
+ qt_int"""
+ select * from (select id from expr_test_not_nullable order by kint,id limit
3)t order by id;
+ """
+ qt_int"""
+ select * from (select id from expr_test_not_nullable order by kint,id limit
15)t order by id;
+ """
+
+ qt_bigint"""
+ select * from (select id from expr_test_not_nullable order by kbint,id
limit 3)t order by id;
+ """
+ qt_bigint"""
+ select * from (select id from expr_test_not_nullable order by kbint,id
limit 15)t order by id;
+ """
+
+ qt_largeint"""
+ select * from (select id from expr_test_not_nullable order by klint,id
limit 3)t order by id;
+ """
+ qt_largeint"""
+ select * from (select id from expr_test_not_nullable order by klint,id
limit 15)t order by id;
+ """
+
+ qt_varchar"""
+ select * from (select id from expr_test_not_nullable order by kvchr,id
limit 3)t order by id;
+ """
+ qt_varchar"""
+ select * from (select id from expr_test_not_nullable order by kvchr,id
limit 15)t order by id;
+ """
+
+ qt_char"""
+ select * from (select id from expr_test_not_nullable order by kchr,id limit
3)t order by id;
+ """
+ qt_char"""
+ select * from (select id from expr_test_not_nullable order by kchr,id limit
15)t order by id;
+ """
+
+ qt_str"""
+ select * from (select id from expr_test_not_nullable order by kstr,id limit
3)t order by id;
+ """
+ qt_str"""
+ select * from (select id from expr_test_not_nullable order by kstr,id limit
15)t order by id;
+ """
+
+ qt_date"""
+ select * from (select id from expr_test_not_nullable order by kdt,id limit
3)t order by id;
+ """
+ qt_date"""
+ select * from (select id from expr_test_not_nullable order by kdt,id limit
15)t order by id;
+ """
+
+ qt_datev2"""
+ select * from (select id from expr_test_not_nullable order by kdtv2,id
limit 3)t order by id;
+ """
+ qt_datev2"""
+ select * from (select id from expr_test_not_nullable order by kdtv2,id
limit 15)t order by id;
+ """
+
+ qt_datetime"""
+ select * from (select id from expr_test_not_nullable order by kdtm,id limit
3)t order by id;
+ """
+ qt_datetime"""
+ select * from (select id from expr_test_not_nullable order by kdtm,id limit
15)t order by id;
+ """
+
+ qt_datetimev2"""
+ select * from (select id from expr_test_not_nullable order by kdtmv2,id
limit 3)t order by id;
+ """
+ qt_datetimev2"""
+ select * from (select id from expr_test_not_nullable order by kdtmv2,id
limit 15)t order by id;
+ """
+
+ qt_decimal32"""
+ select * from (select id from expr_test_not_nullable order by kdcml32v3,id
limit 3)t order by id;
+ """
+ qt_decimal32"""
+ select * from (select id from expr_test_not_nullable order by kdcml32v3,id
limit 15)t order by id;
+ """
+
+ qt_decimal64"""
+ select * from (select id from expr_test_not_nullable order by kdcml64v3,id
limit 3)t order by id;
+ """
+ qt_decimal64"""
+ select * from (select id from expr_test_not_nullable order by kdcml64v3,id
limit 15)t order by id;
+ """
+
+ qt_decimal128"""
+ select * from (select id from expr_test_not_nullable order by kdcml128v3,id
limit 3)t order by id;
+ """
+ qt_decimal128"""
+ select * from (select id from expr_test_not_nullable order by kdcml128v3,id
limit 15)t order by id;
+ """
+
+ qt_decimalv2"""
+ select * from (select id from expr_test_not_nullable order by kdtmv2,id
limit 3)t order by id;
+ """
+ qt_decimalv2"""
+ select * from (select id from expr_test_not_nullable order by kdtmv2,id
limit 15)t order by id;
+ """
+
+ sql "set enable_decimal256=true;"
+ qt_decimal256"""
+ select * from (select id from expr_test_not_nullable2 order by
kdcml256v3,id limit 3)t order by id;
+ """
+ qt_decimal256"""
+ select * from (select id from expr_test_not_nullable2 order by
kdcml256v3,id limit 5)t order by id;
+ """
+
+ qt_ipv4"""
+ select * from (select id from expr_test_not_nullable2 order by kipv4,id
limit 3)t order by id;
+ """
+ qt_ipv4"""
+ select * from (select id from expr_test_not_nullable2 order by kipv4,id
limit 5)t order by id;
+ """
+ qt_ipv6"""
+ select * from (select id from expr_test_not_nullable2 order by kipv6,id
limit 3)t order by id;
+ """
+ qt_ipv6"""
+ select * from (select id from expr_test_not_nullable2 order by kipv6,id
limit 5)t order by id;
+ """
+
+ // expr
+ qt_boolean"""
+ select * from (select id from expr_test order by abs(kbool),id limit 3)t
order by id;
+ """
+ qt_boolean"""
+ select * from (select id from expr_test order by abs(kbool),id limit 15)t
order by id;
+ """
+
+ qt_tinyint"""
+ select * from (select id from expr_test order by abs(ktint),id limit 3)t
order by id;
+ """
+ qt_tinyint"""
+ select * from (select id from expr_test order by abs(ktint),id limit 15)t
order by id;
+ """
+
+ qt_smallint"""
+ select * from (select id from expr_test order by abs(ksint),id limit 3)t
order by id;
+ """
+ qt_smallint"""
+ select * from (select id from expr_test order by abs(ksint),id limit 15)t
order by id;
+ """
+
+ qt_int"""
+ select * from (select id from expr_test order by abs(kint),id limit 3)t
order by id;
+ """
+ qt_int"""
+ select * from (select id from expr_test order by abs(kint),id limit 15)t
order by id;
+ """
+
+ qt_bigint"""
+ select * from (select id from expr_test order by abs(kbint),id limit 3)t
order by id;
+ """
+ qt_bigint"""
+ select * from (select id from expr_test order by abs(kbint),id limit 15)t
order by id;
+ """
+
+ qt_largeint"""
+ select * from (select id from expr_test order by abs(klint),id limit 3)t
order by id;
+ """
+ qt_largeint"""
+ select * from (select id from expr_test order by abs(klint),id limit 15)t
order by id;
+ """
+
+ qt_varchar"""
+ select * from (select id from expr_test order by repeat(kvchr,2),id limit
3)t order by id;
+ """
+ qt_varchar"""
+ select * from (select id from expr_test order by repeat(kvchr,2),id limit
15)t order by id;
+ """
+
+ qt_char"""
+ select * from (select id from expr_test order by repeat(kchr,2),id limit
3)t order by id;
+ """
+ qt_char"""
+ select * from (select id from expr_test order by repeat(kchr,2),id limit
15)t order by id;
+ """
+
+ qt_str"""
+ select * from (select id from expr_test order by repeat(kstr,2),id limit
3)t order by id;
+ """
+ qt_str"""
+ select * from (select id from expr_test order by repeat(kstr,2),id limit
15)t order by id;
+ """
+
+ qt_date"""
+ select * from (select id from expr_test order by hour_floor(kdt),id limit
3)t order by id;
+ """
+ qt_date"""
+ select * from (select id from expr_test order by hour_floor(kdt),id limit
15)t order by id;
+ """
+
+ qt_datev2"""
+ select * from (select id from expr_test order by hour_floor(kdtv2),id limit
3)t order by id;
+ """
+ qt_datev2"""
+ select * from (select id from expr_test order by hour_floor(kdtv2),id limit
15)t order by id;
+ """
+
+ qt_datetime"""
+ select * from (select id from expr_test order by hour_floor(kdtm),id limit
3)t order by id;
+ """
+ qt_datetime"""
+ select * from (select id from expr_test order by hour_floor(kdtm),id limit
15)t order by id;
+ """
+
+ qt_datetimev2"""
+ select * from (select id from expr_test order by hour_floor(kdtmv2),id
limit 3)t order by id;
+ """
+ qt_datetimev2"""
+ select * from (select id from expr_test order by hour_floor(kdtmv2),id
limit 15)t order by id;
+ """
+
+
+ qt_decimal32"""
+ select * from (select id from expr_test order by abs(kdcml32v3),id limit
3)t order by id;
+ """
+ qt_decimal32"""
+ select * from (select id from expr_test order by abs(kdcml32v3),id limit
15)t order by id;
+ """
+
+ qt_decimal64"""
+ select * from (select id from expr_test order by abs(kdcml64v3),id limit
3)t order by id;
+ """
+ qt_decimal64"""
+ select * from (select id from expr_test order by abs(kdcml64v3),id limit
15)t order by id;
+ """
+
+ qt_decimal128"""
+ select * from (select id from expr_test order by abs(kdcml128v3),id limit
3)t order by id;
+ """
+ qt_decimal128"""
+ select * from (select id from expr_test order by abs(kdcml128v3),id limit
15)t order by id;
+ """
+
+ qt_decimalv2"""
+ select * from (select id from expr_test order by abs(kdtmv2),id limit 3)t
order by id;
+ """
+ qt_decimalv2"""
+ select * from (select id from expr_test order by abs(kdtmv2),id limit 15)t
order by id;
+ """
+
+ sql "set enable_decimal256=true;"
+ qt_decimal256"""
+ select * from (select id from expr_test2 order by abs(kdcml256v3),id limit
3)t order by id;
+ """
+ qt_decimal256"""
+ select * from (select id from expr_test2 order by abs(kdcml256v3),id limit
5)t order by id;
+ """
+
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
