This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 659900040f7717b99b557391edb1509f3ae0d815
Author: airborne12 <airborn...@gmail.com>
AuthorDate: Fri Apr 19 12:06:14 2024 +0800
[Fix](inverted index) fix wrong need read data opt when encounters columnA
> columnB predicate (#33855)
---
be/src/olap/rowset/segment_v2/segment_iterator.cpp | 11 +-
.../test_index_no_need_read_data.out | 74 ++
.../test_index_no_need_read_data.groovy | 871 ++++++++++++++++++++-
3 files changed, 954 insertions(+), 2 deletions(-)
diff --git a/be/src/olap/rowset/segment_v2/segment_iterator.cpp
b/be/src/olap/rowset/segment_v2/segment_iterator.cpp
index bee83282c48..ccdc0577a6b 100644
--- a/be/src/olap/rowset/segment_v2/segment_iterator.cpp
+++ b/be/src/olap/rowset/segment_v2/segment_iterator.cpp
@@ -2613,7 +2613,16 @@ void
SegmentIterator::_calculate_pred_in_remaining_conjunct_root(
auto node_type = expr->node_type();
if (node_type == TExprNodeType::SLOT_REF) {
- _column_predicate_info->column_name = expr->expr_name();
+ if (_column_predicate_info->column_name.empty()) {
+ _column_predicate_info->column_name = expr->expr_name();
+ } else {
+ // If column name already exists, create a new ColumnPredicateInfo
+ // if expr is columnA > columnB, then column name will exist, in
this situation, we need to add it to _column_pred_in_remaining_vconjunct
+ auto new_column_pred_info =
std::make_shared<ColumnPredicateInfo>();
+ new_column_pred_info->column_name = expr->expr_name();
+
_column_pred_in_remaining_vconjunct[new_column_pred_info->column_name].push_back(
+ *new_column_pred_info);
+ }
} else if (_is_literal_node(node_type)) {
auto v_literal_expr = static_cast<const
doris::vectorized::VLiteral*>(expr.get());
_column_predicate_info->query_value = v_literal_expr->value();
diff --git
a/regression-test/data/inverted_index_p0/test_index_no_need_read_data.out
b/regression-test/data/inverted_index_p0/test_index_no_need_read_data.out
index 9b64c110139..da7e5a81123 100644
--- a/regression-test/data/inverted_index_p0/test_index_no_need_read_data.out
+++ b/regression-test/data/inverted_index_p0/test_index_no_need_read_data.out
@@ -136,3 +136,77 @@ j 2 k
k 2 j
u 8 d
+-- !select_no_need_1 --
+1 -5960927335705409832 5 3
+1 -10 -10 9
+1 -10 -4 -4
+1 -10 1 2
+1 -10 3 6
+1 -10 4 -4
+1 -10 7 3
+1 -10 9 1
+2 -4 -10 -10
+1 -4 -10 3
+1 -4 3 3
+1 0 -4 5
+1 0 2 9
+1 0 5 1
+1 0 5 3
+1 1 -10 5
+1 1 0 -4
+1 1 4 3
+1 1 7 -10
+1 1 9 -4
+1 2 8 -4
+1 3 -10 8
+1 3 -4 9
+1 3 3 -4
+1 5 -10 -10
+1 5 -4 1
+1 5 1 8
+1 6 -10 -4
+1 7 -10 2
+1 7 1 6
+1 7 2 8
+1 7 3 -4
+1 7 8 -10
+1 8 -10 -10
+1 8 -10 3
+1 8 -10 8
+2 8 -10 9
+1 8 -4 5
+1 8 -4 8
+1 8 4 -4
+1 8 4 3
+1 8 5 -10
+1 8 5 2
+1 8 8 1
+1 9 -4 2
+1 9 6 1
+1 25 2 -10
+1 26 2 -10
+
+-- !select_no_need_2 --
+1.2
+
+-- !select_no_need_3 --
+2023-12-09 -5522213112273370561 2023-12-16
+2023-12-09 -4155137914128855235 2023-12-12
+2023-12-10 \N 2023-12-19
+2023-12-10 8625368487501035525 2023-12-17
+2023-12-11 4714785027515578912 2023-12-10
+2023-12-15 \N 2024-01-09
+2023-12-15 -559291350287121968 2023-12-16
+2023-12-16 -4473441684795462099 2023-12-15
+2023-12-18 \N 2025-06-18
+2023-12-18 419678391523752890 2026-01-18
+2023-12-20 6152093303748835632 2023-12-17
+2024-01-09 \N 2025-06-18
+2024-01-17 2371697304713448324 2024-01-09
+2025-02-17 -4599200440035458276 2024-01-19
+2025-06-18 -1196385874478092971 2023-12-17
+2025-06-18 -750688512374970345 2024-01-17
+2025-06-18 7670879000600913113 2023-12-09
+2026-01-18 9039465042666792521 2023-12-09
+2026-02-18 -3974342907695018910 2024-01-09
+
diff --git
a/regression-test/suites/inverted_index_p0/test_index_no_need_read_data.groovy
b/regression-test/suites/inverted_index_p0/test_index_no_need_read_data.groovy
index 31016df9814..fd871b0a000 100644
---
a/regression-test/suites/inverted_index_p0/test_index_no_need_read_data.groovy
+++
b/regression-test/suites/inverted_index_p0/test_index_no_need_read_data.groovy
@@ -359,4 +359,873 @@ suite("test_index_no_need_read_data",
"inverted_index_select"){
"""
qt_select_no_need_0 "SELECT table1 . col_varchar_10__undef_signed AS
field1, table1 . `col_int_undef_signed_not_null` - ( 0 + 1) AS field2, table1 .
col_varchar_10__undef_signed_not_null AS field3 FROM ${table2} AS table1 WHERE
( ( table1 . `col_int_undef_signed_not_null` is NULL ) OR table1 .
col_date_undef_signed_index_inverted = '2023-12-18' ) GROUP BY
field1,field2,field3 ORDER BY field1,field2,field3 LIMIT 1000 OFFSET 2;"
-}
\ No newline at end of file
+
+ def table3 = "test_index_no_need_read_data3"
+
+ sql "drop table if exists ${table3}"
+ sql """
+ create table ${table3} (
+ col_date_undef_signed_not_null_index_inverted date not null ,
+ col_bigint_undef_signed_not_null_index_inverted bigint not null ,
+ col_bigint_undef_signed_not_null bigint not null ,
+ col_int_undef_signed int null ,
+ col_int_undef_signed_index_inverted int null ,
+ col_int_undef_signed_not_null int not null ,
+ col_int_undef_signed_not_null_index_inverted int not null ,
+ col_bigint_undef_signed bigint null ,
+ col_bigint_undef_signed_index_inverted bigint null ,
+ col_date_undef_signed date null ,
+ col_date_undef_signed_index_inverted date null ,
+ col_date_undef_signed_not_null date not null ,
+ col_varchar_10__undef_signed varchar(10) null ,
+ col_varchar_10__undef_signed_index_inverted varchar(10) null ,
+ col_varchar_10__undef_signed_not_null varchar(10) not null ,
+ col_varchar_10__undef_signed_not_null_index_inverted varchar(10) not
null ,
+ col_varchar_1024__undef_signed varchar(1024) null ,
+ col_varchar_1024__undef_signed_index_inverted varchar(1024) null ,
+ col_varchar_1024__undef_signed_not_null varchar(1024) not null ,
+ col_varchar_1024__undef_signed_not_null_index_inverted varchar(1024)
not null ,
+ pk int,
+ INDEX col_int_undef_signed_index_inverted_idx
(`col_int_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_int_undef_signed_not_null_index_inverted_idx
(`col_int_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_bigint_undef_signed_index_inverted_idx
(`col_bigint_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_bigint_undef_signed_not_null_index_inverted_idx
(`col_bigint_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_date_undef_signed_index_inverted_idx
(`col_date_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_date_undef_signed_not_null_index_inverted_idx
(`col_date_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_varchar_10__undef_signed_index_inverted_idx
(`col_varchar_10__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_varchar_10__undef_signed_not_null_index_inverted_idx
(`col_varchar_10__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_varchar_1024__undef_signed_index_inverted_idx
(`col_varchar_1024__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_varchar_1024__undef_signed_not_null_index_inverted_idx
(`col_varchar_1024__undef_signed_not_null_index_inverted`) USING INVERTED
+ ) engine=olap
+ UNIQUE KEY(col_date_undef_signed_not_null_index_inverted,
col_bigint_undef_signed_not_null_index_inverted,
col_bigint_undef_signed_not_null)
+ PARTITION BY
RANGE(col_date_undef_signed_not_null_index_inverted) (
+ FROM ('2023-12-08') TO ('2024-01-01') INTERVAL 1 DAY,
+ FROM ('2024-01-01') TO ('2024-12-01') INTERVAL 1 MONTH,
+ FROM ('2025-01-01') TO ('2027-01-01') INTERVAL 1 YEAR,
+ FROM ('2027-01-01') TO ('2032-01-01') INTERVAL 2 YEAR
+ )
+
+ distributed by hash(col_bigint_undef_signed_not_null)
+ properties("enable_unique_key_merge_on_write" = "true",
"replication_num" = "1");
+ """
+ sql """INSERT INTO ${table3} (
+ pk,
+ col_int_undef_signed,
+ col_int_undef_signed_index_inverted,col_int_undef_signed_not_null,
+ col_int_undef_signed_not_null_index_inverted,col_bigint_undef_signed,
+
col_bigint_undef_signed_index_inverted,col_bigint_undef_signed_not_null,
+ col_bigint_undef_signed_not_null_index_inverted,col_date_undef_signed,
+ col_date_undef_signed_index_inverted,col_date_undef_signed_not_null,
+
col_date_undef_signed_not_null_index_inverted,col_varchar_10__undef_signed,
+
col_varchar_10__undef_signed_index_inverted,col_varchar_10__undef_signed_not_null,
+
col_varchar_10__undef_signed_not_null_index_inverted,col_varchar_1024__undef_signed,
+
col_varchar_1024__undef_signed_index_inverted,col_varchar_1024__undef_signed_not_null,
+ col_varchar_1024__undef_signed_not_null_index_inverted)
+ VALUES
+
(0,5,-10,3,1,null,1146299004109928502,3054813699474005908,-8079828267200209325,null,'2023-12-11','2024-02-18','2023-12-09',null,'m','f','e','a',null,'t','k'),
+
(1,7,6,-10,5,-3931151281173717292,-5145129302476624156,902304869577035320,5744562438440616389,'2024-02-18','2023-12-10','2025-06-18','2025-02-17','d',null,'c','l','x','e','y','x'),
+
(2,4,3,-4,3,-7408004146830346908,null,-8028056329708851758,1163188885741485002,'2025-02-17','2024-02-18','2023-12-14','2023-12-09',null,'v','p','i','l','c','b','j'),
+
(3,1,6,1,0,-1906034789238721279,null,1957761206188834725,3171057930488341880,'2026-02-18','2026-02-18','2025-02-18','2024-01-17','o',null,'e','i',null,'d','a','t'),
+
(4,2,-10,9,-4,5850070976734819027,null,-5842840828907453020,-273940474239998130,'2023-12-11','2023-12-09','2027-01-09','2025-02-17','w','r','t','d','h','c','q','a'),
+
(5,5,null,4,0,-5480193238064846266,-6620736245996944815,7365496721129870481,1691015090920050763,'2023-12-14','2024-01-19','2027-01-16','2025-02-18',null,'k','a','x','u','w','w','z'),
+
(6,1,6,6,0,-9130053015303478082,-7409550162748983851,-6460519591113198675,4268431147039676041,'2023-12-17','2023-12-14','2023-12-13','2023-12-09','f','b','j','t','s','w','k','w'),
+
(7,1,1,7,-10,-5034221818576108388,3377388750712858412,4148586308329186918,-6946810068891785279,'2025-06-18','2024-02-18','2025-02-18','2023-12-16','a',null,'v','v','y','d','l','j'),
+
(8,4,5,-10,8,-4438909091225320199,5264569089790771494,673882907280772426,-6648743693508345926,'2023-12-14','2023-12-20','2025-02-17','2025-06-18','t','d','g','m','c','p','w','f'),
+
(9,-10,-4,8,5,-7072757031384422827,1891130646555645562,7434252548576276534,-5743044648348161373,'2025-06-18','2023-12-19','2023-12-20','2027-01-16','y','a','n','p','c','n','c','m'),
+
(10,7,-4,4,5,5857498966192122667,6193204789244308341,-3086121824768187201,1515144221306401089,null,'2024-01-17','2023-12-15','2023-12-18','h','x','n','j','t','i','m','e'),
+
(11,-10,2,2,-10,6625489715972743845,103798082185739918,8612497332139231257,754097475492000522,null,'2024-01-31','2023-12-16','2023-12-12','y','d','u','q','j','e','k','s'),
+
(12,null,-10,-10,4,1031002928045228743,null,-2121004553096116042,-5786600442641449888,'2025-06-18','2023-12-20','2025-06-18','2023-12-13','e','q','i','s','t','x','a','k'),
+
(13,7,6,8,-10,-3650237907046013970,-8923143162937692921,-2901539272447586610,-3848668134431446551,'2025-06-18','2026-01-18','2026-02-18','2023-12-19','q',null,'e','z',null,'k','z','i'),
+
(14,-4,8,-4,7,-5551320780754796619,-8198293630186692221,807743948639582197,771500250889699631,'2026-02-18','2023-12-12','2024-01-19','2024-01-09','h','h','f','t','s','b','n','h'),
+
(15,-10,null,3,2,-1361577796381150861,-9150402829641459244,-2134857148859701067,-8732326141705640079,'2024-01-17','2023-12-18','2023-12-14','2024-01-17','j','h','r','c',null,'l','u','z'),
+
(16,null,null,8,-10,-6046584177751179555,null,-7103875849041184443,-4530723850373671640,'2023-12-16',null,'2025-02-17','2024-02-18','b',null,'m','o','y','l','d','h'),
+
(17,-4,4,-4,-4,571594462292185627,-6068611791805235858,-2368221053835161848,5542334773553433761,'2023-12-14','2023-12-17','2024-01-09','2023-12-18','e','m','k','h','e','m','j','l'),
+
(18,4,-4,8,-4,-2381305601222026411,null,2689411551411464180,2249737024075651261,'2024-02-18','2023-12-15','2024-01-08','2023-12-12',null,'v','t','x','l',null,'b','x'),
+
(19,4,null,5,4,1489284125193916764,8324916610585760001,-188367432889663886,7565473533629309477,'2025-06-18','2023-12-14','2023-12-10','2027-01-16','e','q','s','m',null,null,'h','u'),
+
(20,5,5,-10,3,5311791441008953224,-5373656924853056247,5033152844478566987,-1965600420787096371,'2024-01-19',null,'2023-12-13','2023-12-11','h',null,'d','u','y','b','s','t'),
+
(21,2,null,-4,-4,null,-5210845946882797263,-1906934135585903680,-6715836128700437175,'2024-01-31',null,'2023-12-15','2025-02-17',null,'h','u','x','d','f','u','o'),
+
(22,-4,6,8,3,-7915827973227671028,-7763151239401397618,-6924184946839377244,-5077528576615928221,null,'2026-01-18','2027-01-09','2025-02-18',null,'t','z','w',null,'p','y','a'),
+
(23,3,9,3,2,-1377420279866931713,2353940657356813290,-3956199807549024801,-7352610478131219676,'2023-12-15','2025-06-18','2027-01-09','2023-12-16',null,'s','i','u','m','j','y','w'),
+
(24,-10,2,3,5,4351938980531654605,null,-7367984332108156958,1547376881468045026,'2023-12-15','2024-02-18','2024-02-18','2027-01-16','i',null,'i','a','v','y','f','u'),
+
(25,null,-4,5,-10,813215637967049379,null,-8639371031629360757,-2677090274650435671,'2024-02-18','2023-12-19','2024-01-31','2023-12-14','e','w','h','b','m',null,'e','w'),
+
(26,null,-4,7,0,-2705719529474059399,761101566426163462,-4094584249080765052,4728256755894584175,'2027-01-16','2025-06-18','2023-12-15','2023-12-16','l','h','g','l','f','c','b','f'),
+
(27,null,-4,0,-4,null,-1915788396240476514,6636972836518065792,973665687888690313,'2023-12-12','2023-12-17','2024-02-18','2024-02-18','f','h','y','t','g','d','e','j'),
+
(28,1,3,-4,3,1826767802295773650,-8601082167935472379,786583851108559956,7095204956568924586,'2025-02-17','2026-01-18','2026-02-18','2026-01-18','y','p','h','d',null,'c','j','w'),
+
(29,6,1,8,0,2007299877841850028,null,-1033108658215433638,2144620676116321201,'2023-12-09','2024-02-18','2024-02-18','2026-01-18',null,'b','a','m',null,null,'h','v'),
+
(30,7,-10,0,8,-1507049011359000670,null,-8045359991171155883,-597686187736225023,'2023-12-16','2024-01-17','2024-01-19','2023-12-17','x',null,'n','s','w','o','k','e'),
+
(31,7,2,7,-10,null,-8458279600625224237,-3914822523612983096,-4446342715209868884,'2024-02-18','2027-01-09','2023-12-17','2027-01-09','g',null,'p','l','j','p','r','a'),
+
(32,-4,3,4,-4,-5000241005490842497,null,3250886256326101741,-2609778586966241852,'2025-02-18','2024-01-31','2023-12-10','2023-12-16','k','g','r','n','i','i','h','m'),
+
(33,8,8,1,-4,545801367274301686,2040874140179283652,6139875498888853887,3305951047824978187,'2023-12-13','2025-02-18','2023-12-19','2027-01-16','z','s','m','e','v','q','e','q'),
+
(34,8,-10,6,-4,-9128124361950426021,764648136753512126,-3119079956728551491,2254455287193372425,'2023-12-18','2023-12-12','2024-01-31','2025-02-17','r','e','g','e','t','g','d','a'),
+
(35,-4,-10,9,6,-3424830969405380454,null,6332391162045472707,-8275510987434726169,'2023-12-20','2024-02-18','2024-01-09','2023-12-10',null,'v','j','j','n',null,'k','f'),
+
(36,3,null,7,5,-386625993355302526,5268031105455808934,-1318788345808047836,4415301058346503575,null,'2023-12-17','2023-12-19','2023-12-11','y','r','z','i','d',null,'m','t'),
+
(37,5,2,4,-10,-7921349127087247948,482578803322134946,-7884490253805336058,-5745731346487409054,'2027-01-09','2024-01-17','2026-02-18','2024-01-08','a','p','z','p','r','y','p','b'),
+
(38,-4,1,2,0,590841228155877868,null,2145072569052395952,2323398089574171513,'2023-12-19','2026-02-18','2024-02-18','2023-12-16','l','c','a','e','n','j','x','k'),
+
(39,9,8,8,7,-480620735123240246,-5176490473294300655,-4313738933151315624,3680054219070596837,'2024-02-18','2023-12-18','2023-12-18','2023-12-13','i','l','p','z','z',null,'x','p'),
+
(40,0,2,4,-10,5369707610006331017,null,-9012080361800815742,-4799198380897739036,'2025-02-17','2023-12-10','2024-01-31','2026-02-18','i',null,'z','i','h','f','o','p'),
+
(41,1,9,-10,4,8908830966360674313,null,-6993282584234490218,6761134586638358207,'2023-12-11',null,'2026-02-18','2024-01-08',null,'y','z','y','i','b','o','e'),
+
(42,7,-4,-4,9,null,4549659473548533477,-2674534228571273744,5306067049540282217,'2026-02-18','2026-01-18','2025-02-18','2023-12-18','r',null,'p','s',null,null,'v','p'),
+
(43,5,null,-4,3,-2476241334378583391,null,-6318178316501710444,-8516151862183337116,'2024-01-09',null,'2026-01-18','2023-12-13','r','t','o','e','b','t','u','z'),
+
(44,1,6,4,-10,null,3579596494186056294,4966472750863861613,2841646796185804447,'2023-12-17',null,'2023-12-19','2023-12-09','x','g','c','e','l','i','f','q'),
+
(45,null,8,-4,-4,-4965111477823617192,-5286434348768626629,2715454396527386574,3309748998908759298,'2024-01-17','2024-01-08','2026-01-18','2023-12-09','t','u','w','e','o','e','b','i'),
+
(46,-10,null,3,2,null,-7616474331004486594,-246680075038083294,7820924017202546946,'2027-01-16','2025-02-18','2024-01-17','2024-02-18','h','y','c','e','j','u','s','e'),
+
(47,3,6,-4,6,280714650710842291,-631315162984856571,4202780481531603208,927942176177129602,null,'2027-01-16','2023-12-12','2026-02-18','r','z','e','f','e','c','t','x'),
+
(48,null,6,-4,9,-8887846129139266086,445589898932113981,4706686273532265628,-1619520637972685150,'2023-12-09','2023-12-13','2027-01-16','2024-02-18',null,'q','c','h','k','g','z','l'),
+
(49,6,-10,6,8,5983110054374805308,1601019964266644567,7723563362109930198,399519444913401672,'2026-02-18','2023-12-12','2023-12-14','2023-12-11',null,'x','s','g','p','u','z','a');
+ """
+
+ def table4 = "test_index_no_need_read_data4"
+
+ sql "drop table if exists ${table4}"
+ sql """create table ${table4} (
+ col_int_undef_signed_not_null_index_inverted int not null ,
+ col_bigint_undef_signed_not_null_index_inverted bigint not null ,
+ col_bigint_undef_signed_not_null bigint not null ,
+ col_int_undef_signed int null ,
+ col_int_undef_signed_index_inverted int null ,
+ col_int_undef_signed_not_null int not null ,
+ col_bigint_undef_signed bigint null ,
+ col_bigint_undef_signed_index_inverted bigint null ,
+ col_date_undef_signed date null ,
+ col_date_undef_signed_index_inverted date null ,
+ col_date_undef_signed_not_null date not null ,
+ col_date_undef_signed_not_null_index_inverted date not null ,
+ col_varchar_10__undef_signed varchar(10) null ,
+ col_varchar_10__undef_signed_index_inverted varchar(10) null ,
+ col_varchar_10__undef_signed_not_null varchar(10) not null ,
+ col_varchar_10__undef_signed_not_null_index_inverted varchar(10) not null
,
+ col_varchar_1024__undef_signed varchar(1024) null ,
+ col_varchar_1024__undef_signed_index_inverted varchar(1024) null ,
+ col_varchar_1024__undef_signed_not_null varchar(1024) not null ,
+ col_varchar_1024__undef_signed_not_null_index_inverted varchar(1024) not
null ,
+ pk int,
+ INDEX col_int_undef_signed_index_inverted_idx
(`col_int_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_int_undef_signed_not_null_index_inverted_idx
(`col_int_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_bigint_undef_signed_index_inverted_idx
(`col_bigint_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_bigint_undef_signed_not_null_index_inverted_idx
(`col_bigint_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_date_undef_signed_index_inverted_idx
(`col_date_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_date_undef_signed_not_null_index_inverted_idx
(`col_date_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_varchar_10__undef_signed_index_inverted_idx
(`col_varchar_10__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_varchar_10__undef_signed_not_null_index_inverted_idx
(`col_varchar_10__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_varchar_1024__undef_signed_index_inverted_idx
(`col_varchar_1024__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_varchar_1024__undef_signed_not_null_index_inverted_idx
(`col_varchar_1024__undef_signed_not_null_index_inverted`) USING INVERTED
+ ) engine=olap
+ UNIQUE KEY(col_int_undef_signed_not_null_index_inverted,
col_bigint_undef_signed_not_null_index_inverted,
col_bigint_undef_signed_not_null)
+ PARTITION BY
RANGE(col_int_undef_signed_not_null_index_inverted) (
+ PARTITION p0 VALUES LESS THAN ('4'),
+ PARTITION p1 VALUES LESS THAN ('6'),
+ PARTITION p2 VALUES LESS THAN ('7'),
+ PARTITION p3 VALUES LESS THAN ('8'),
+ PARTITION p4 VALUES LESS THAN ('10'),
+ PARTITION p5 VALUES LESS THAN ('1147483647'),
+ PARTITION p100 VALUES LESS THAN ('2147483647')
+ )
+
+ distributed by hash(col_bigint_undef_signed_not_null)
+ properties("enable_unique_key_merge_on_write" = "true", "replication_num"
= "1");
+ """
+
+ sql """
+ INSERT INTO ${table4}(
+ pk,
+ col_int_undef_signed,
+ col_int_undef_signed_index_inverted,
+ col_int_undef_signed_not_null,
+ col_int_undef_signed_not_null_index_inverted,
+ col_bigint_undef_signed,
+ col_bigint_undef_signed_index_inverted,
+ col_bigint_undef_signed_not_null,
+ col_bigint_undef_signed_not_null_index_inverted,
+ col_date_undef_signed,
+ col_date_undef_signed_index_inverted,
+ col_date_undef_signed_not_null,
+ col_date_undef_signed_not_null_index_inverted,
+ col_varchar_10__undef_signed,
+ col_varchar_10__undef_signed_index_inverted,
+ col_varchar_10__undef_signed_not_null,
+ col_varchar_10__undef_signed_not_null_index_inverted,
+ col_varchar_1024__undef_signed,
+ col_varchar_1024__undef_signed_index_inverted,
+ col_varchar_1024__undef_signed_not_null,
+ col_varchar_1024__undef_signed_not_null_index_inverted)
+ VALUES
+
(0,-4,-10,4,0,-4374279311784469210,6230856899329561501,-1362977170076928174,5463495393891541626,'2024-01-31','2026-01-18','2024-02-18','2023-12-14','p',null,'a','c','g','m','m','j'),
+
(1,-4,3,0,5,6906900996486541211,-2711144224856392486,1690655402925311792,332907949355269309,'2026-02-18','2027-01-16','2024-01-31','2023-12-10','u',null,'t','b','x','k','r','p'),
+
(2,-4,5,6,1,-5341451822306664502,-7115804010536970742,-4843960976976500243,7691986120828494058,'2023-12-11','2025-06-18','2023-12-18','2023-12-10','z','g','n','r','o','i','t','h'),
+
(3,null,-4,7,-10,327892986881735505,-8837888276019013196,-4046944610541972362,4462086985245026136,'2027-01-09','2024-02-18','2024-02-18','2023-12-12','x','g','j','b','p',null,'o','x'),
+
(4,8,-10,-4,-10,-8103714258740889321,null,-6100454805711535802,-7007269108987098048,'2024-01-08',null,'2025-06-18','2023-12-19','i',null,'l','m','f','g','k','p'),
+
(5,8,8,-10,-4,null,1714919072532351532,-2734317776976078785,-7065081553707628941,'2024-01-09',null,'2023-12-14','2024-02-18','k','l','x','k','p',null,'w','q'),
+
(6,9,5,8,5,8933733382910842732,2593449295475070603,-6967069732255393771,4181239333600269,'2023-12-13',null,'2024-02-18','2025-06-18','y','d','q','s','i','s','f','g'),
+
(7,null,-4,-10,8,null,-6087104111939342959,-5761839186792307998,-5276788681754397583,'2023-12-16','2024-01-31','2024-02-18','2024-01-09','u','i','g','v','r','x','d','o'),
+
(8,-4,9,0,2,2435390590143504753,-6317557083356582458,-7951133009629443607,4001268324476360080,'2024-01-09','2023-12-18','2023-12-10','2023-12-15','t','z','s','p','z','j','u','z'),
+
(9,3,-4,5,4,6342563333639934319,-744829708550488670,-3699151955606516335,4592632498223399047,null,'2024-02-18','2023-12-13','2023-12-20','o','p','f','t','y',null,'q','f'),
+
(10,3,-4,2,4,-3306843512894296461,-2707388015819334459,392367306362836837,-4713477625347948733,'2023-12-17',null,'2027-01-16','2023-12-12','k',null,'z','o','s','m','u','c'),
+
(11,1,-10,7,-4,-2432875797191938254,1709676469795306975,2985452025410848007,7598045945075263293,'2025-02-17','2025-02-17','2023-12-13','2023-12-17',null,'h','l','c',null,'x','e','u'),
+
(12,9,-10,-10,4,5840415679800360308,null,-8187426912793923006,-1371366092755353351,'2023-12-18',null,'2023-12-16','2023-12-11','f','y','i','t','j',null,'m','q'),
+
(13,4,2,7,-10,-4317958699881727007,4629780752784506794,-768293186225303832,2913296699191586253,'2023-12-13',null,'2024-01-19','2023-12-14','a','u','p','o','s','d','t','v'),
+
(14,-4,5,5,4,-6116177655339387947,-5072350629017321874,6032568594823889084,-3637087033433580073,'2025-02-18','2023-12-15','2026-02-18','2023-12-09','c','r','k','g','o','r','m','e'),
+
(15,null,-10,5,-4,1451439167875099448,null,-3083064549924141039,8477304707241625848,'2027-01-09','2027-01-09','2023-12-20','2027-01-16','z','w','c','n','y',null,'q','c'),
+
(16,3,5,-10,9,-1807434810700055230,-4859213966577544827,-723410772400036445,2758378783736727839,'2023-12-19','2023-12-14','2025-06-18','2024-01-09','h',null,'l','c','n',null,'q','i'),
+
(17,7,null,-10,4,-4603591052649553464,4010384366789041704,4768892995676961224,-5776603065792060312,'2023-12-10','2024-01-08','2024-01-19','2025-02-18','d','c','t','i','j','t','a','e'),
+
(18,8,3,-4,-10,-2526706244749516773,9150775215396227369,-697278752989518462,-6993391287390315322,null,'2026-02-18','2023-12-12','2027-01-09','u','i','y','r','m',null,'w','s'),
+
(19,null,4,-10,-10,null,-4048266292265681313,2198895883037279869,-4727497382390112607,'2023-12-18','2023-12-13','2026-01-18','2023-12-19','c','e','h','w','w','o','r','x'),
+
(20,1,-4,4,-10,915044794065797675,5767467541212153071,805079178006980426,-5832392521480652104,'2023-12-09',null,'2023-12-10','2025-06-18','q',null,'m','f','x','g','s','a'),
+
(21,null,8,7,2,-7779943329829392946,-580168709010583216,-3875246283753493237,2106715699688700081,'2023-12-19','2024-02-18','2023-12-12','2024-02-18',null,null,'u','c','a','a','l','u'),
+
(22,null,3,1,4,-1433244310611814881,463798216469349291,-3993493521540596692,-1655409780328479239,'2024-02-18','2023-12-11','2024-01-17','2024-01-31',null,'a','j','m','n','g','r','z'),
+
(23,-4,3,-10,-10,null,796361822606831545,6459034733477890212,-7041503003082661774,'2026-02-18','2024-02-18','2024-01-17','2024-01-09','i','a','u','o','a','a','m','g'),
+
(24,5,-10,-10,2,null,2220905695260878249,-786034809849623809,2220087153625747339,null,null,'2023-12-09','2024-02-18',null,'t','m','b','g','k','u','x'),
+
(25,-10,-10,8,8,null,null,-3479485257013893199,4115385544188410040,'2024-01-19','2024-01-08','2026-01-18','2023-12-20','m','y','u','i','h','v','m','d'),
+
(26,-4,7,-4,-10,-6274266781511631015,-6227105689808199660,-964043111865585753,5538388785209296423,'2027-01-16',null,'2024-02-18','2024-02-18','t','g','b','n','x','u','b','w'),
+
(27,5,null,-4,-10,-7644699987660198305,6752007724729926825,1402337567971338188,-8985676234650436106,'2024-01-31','2027-01-09','2023-12-13','2023-12-17','o','d','k','v','w',null,'i','m'),
+
(28,null,1,5,9,-32726974781645892,null,3163425560289830058,7947682038003034876,'2024-02-18','2023-12-15','2026-02-18','2023-12-14','j',null,'f','u',null,'l','o','f'),
+
(29,4,-10,5,-10,-7494882589520174902,-708794773472534037,8864040579112277958,9016298081936948013,'2024-02-18','2025-02-17','2027-01-09','2027-01-09','s','m','a','d',null,null,'y','z'),
+
(30,8,null,8,6,-7969789176743648651,3995090805756755628,-3431502351498670021,-8014312388299533826,'2023-12-11','2025-02-18','2023-12-20','2026-02-18','y','u','e','x','r',null,'f','b'),
+
(31,null,-4,-10,2,7550347272789509553,3872875348404154813,7804341187060405957,448443571425496346,'2023-12-09','2024-01-31','2023-12-14','2027-01-09','i','s','m','c','e',null,'c','j'),
+
(32,3,3,3,-4,-8959255589673252978,8167700668095735919,-3599832410803104025,890118425432299772,'2023-12-17','2023-12-10','2024-01-19','2025-06-18','o','s','z','n',null,'q','h','k'),
+
(33,7,3,-10,5,-1015175028437962837,-8466721438536728594,3251948054786435766,-7771957592532254405,'2024-02-18',null,'2025-06-18','2024-01-08','v','k','f','g','u',null,'y','f'),
+
(34,0,8,-10,-4,null,-7079831472885584649,-3385439260999791057,5600810453965655524,'2023-12-19','2023-12-10','2024-02-18','2023-12-19',null,'r','j','y','i','j','r','x'),
+
(35,null,9,-10,-10,1580906363255232903,-4080634175451712213,-3552859155879629811,-2166303063843400144,'2024-01-31','2023-12-10','2024-01-08','2023-12-11','h','d','f','b','y','l','o','w'),
+
(36,9,1,3,9,-6806495139778535894,2702207607257979668,-3402421250001308357,-8320351824293312344,'2023-12-15',null,'2025-02-18','2024-01-17',null,'v','f','g',null,'z','n','p'),
+
(37,7,3,-4,-10,-4800984213430644307,7461383103576184807,-3274035332690061411,-28599221166062621,'2023-12-12',null,'2023-12-14','2023-12-16','q','u','g','i','a','x','w','y'),
+
(38,0,-4,3,3,7238664880615018700,-4797606762194243590,9179648063004905118,-1573978436199896,'2023-12-12','2024-02-18','2023-12-19','2023-12-12','c','m','n','s',null,'v','w','y'),
+
(39,-10,9,3,3,null,null,8177777199198803415,-347026646202248969,'2024-02-18','2025-06-18','2024-02-18','2024-01-08','m','x','g','b','l','c','s','p'),
+
(40,7,-4,2,9,3914381071364338122,null,3924941427391147928,-3657946472047063224,'2027-01-16','2025-06-18','2024-02-18','2025-02-17','k',null,'y','z',null,null,'m','v'),
+
(41,2,-10,-10,7,-5808964950144096455,-2100279162114847574,2928466204466928811,5045687639015665238,'2024-02-18','2023-12-12','2024-01-09','2027-01-16','c','h','q','d','u','a','r','b'),
+
(42,-4,9,9,6,null,-6160899548039050387,-2191266489297679333,8329335412260929602,'2023-12-15','2025-02-18','2023-12-09','2023-12-15','s','i','o','t','b',null,'i','j'),
+
(43,1,4,5,-4,null,-6530600321165393735,804842027815969388,3518829673794923315,'2025-02-18','2023-12-20','2026-01-18','2024-02-18','q','x','o','j','b','y','u','r'),
+
(44,9,7,-4,-10,-5847501154351098445,7703034812492442373,1357807031393353032,1366575769668513143,'2025-06-18','2025-02-18','2023-12-09','2024-02-18','q','x','g','i','u','y','t','h'),
+
(45,8,9,-10,4,5576279648143068992,4858336579969416801,3613889528376791938,-9050893386117105191,'2023-12-09','2027-01-09','2025-02-18','2024-01-17','b','l','n','a','d','j','x','k'),
+
(46,0,-4,2,8,5655393055825953457,-8822505644073884472,-3553290867279881090,5990053982050704820,'2027-01-16','2023-12-20','2023-12-09','2023-12-18','q','z','h','n','r','a','b','t'),
+
(47,9,6,0,-4,-4567408599648021877,4726758482151618961,-532407405170053250,-9149611662648095535,'2023-12-13','2027-01-16','2023-12-17','2023-12-11','p','i','y','e','i',null,'h','t'),
+
(48,-4,6,7,1,6993537939189193043,null,5219595323544812758,-6266192751197355511,'2023-12-13','2024-01-08','2023-12-19','2025-06-18','x','f','i','x','r','h','x','z'),
+
(49,-4,null,1,1,-793429874699684492,2731612800302170068,-8258968138792801394,-604973685259326939,null,'2024-01-31','2023-12-17','2023-12-20','i','t','d','c','u','z','k','h'),
+
(50,1,3,2,4,null,-1181340731105722635,1957771400080841726,1514890477185503853,'2023-12-12','2025-06-18','2024-02-18','2023-12-19',null,'o','i','c','x','q','s','t'),
+
(51,2,7,-4,-4,null,null,-2154521592160516899,-8254235104879753323,'2024-01-09','2025-02-17','2024-01-09','2025-06-18','h','k','q','f','h','p','n','v'),
+
(52,7,-4,3,4,null,-2394426695842498133,7644107209448288384,1463209406830791588,'2023-12-16','2024-01-31','2023-12-12','2023-12-13','v','u','j','k',null,'c','i','h'),
+
(53,null,0,2,0,3290186359579227073,5370729292588386525,715755893754043315,-5338635265674023033,'2023-12-11','2023-12-18','2024-02-18','2026-01-18','v',null,'l','w','a',null,'v','q'),
+
(54,7,1,5,-4,-2583544562212544609,-6530610552635634122,-1003006555342432486,3466338377827248850,'2026-01-18',null,'2025-02-17','2023-12-12','e',null,'u','s',null,'h','v','q'),
+
(55,9,2,9,-4,4569056132889195950,null,-8334941492513475935,1645248882101858167,'2026-01-18','2024-01-17','2026-01-18','2023-12-16','y','l','g','h',null,'l','k','r'),
+
(56,0,4,1,-10,null,3889002712426834242,5929860470216094115,5442709659182983947,'2027-01-09',null,'2023-12-11','2024-02-18','u','v','n','n','x',null,'i','f'),
+
(57,null,-4,7,3,3301916305625845253,-4917814758883130078,-6315595450234631719,2909744643512919440,'2023-12-10','2025-02-18','2024-01-17','2023-12-10',null,null,'a','h','x','j','p','s'),
+
(58,-10,-10,5,0,-5101677846562573474,-3036405238250610875,-8967724773412352716,-7890486781548601303,'2023-12-19','2023-12-15','2025-06-18','2025-06-18','s','w','l','c','c',null,'v','i'),
+
(59,8,2,8,0,-3771340549227355567,-5332704703769436099,7969105374518441325,-3290527289471229051,'2025-06-18','2025-06-18','2024-01-09','2026-02-18','k',null,'o','i','h',null,'b','r'),
+
(60,-10,null,6,3,6088635990829297416,-427285520357620531,3210661624777882314,6775862866213090148,'2023-12-15',null,'2025-02-18','2025-02-17','o','n','r','f','g',null,'l','l'),
+
(61,-10,5,-10,-10,-2582207522113475375,-7751145616567856608,8194407191287366720,3427527395554022329,null,'2025-06-18','2023-12-12','2023-12-17','h',null,'o','r',null,'u','y','m'),
+
(62,2,-10,-10,0,9127775229165644097,8965751423304265297,6546740737182994399,8741950356311830606,null,'2025-06-18','2025-02-18','2023-12-14',null,'d','f','m',null,'x','z','r'),
+
(63,6,9,-4,5,-8522716279584170123,-5207644728454537578,-8843194407744496348,6433663505469138454,'2024-02-18','2023-12-16','2024-01-08','2024-01-17',null,'l','m','l','j','t','z','g'),
+
(64,2,9,9,3,-3165626656511292684,-9032338160285674442,2519602398937561457,-6259991795199694525,'2023-12-20','2024-02-18','2023-12-18','2024-02-18','s','g','t','w','t','h','q','g'),
+
(65,-4,5,1,6,7583171009332408221,8603254114462077881,5390788075181477511,-8301919228544148269,null,'2023-12-16','2024-01-17','2023-12-15','w','f','n','w','o',null,'r','u'),
+
(66,-10,-4,1,0,9084887619520943355,null,4266488954048054291,7834350410719089719,'2023-12-20','2023-12-15','2024-01-08','2023-12-16','p',null,'n','b','b','m','t','t'),
+
(67,9,0,3,3,1287201644628600885,9015092599522141574,2859050237040165999,845696629587897952,'2023-12-14','2027-01-16','2025-06-18','2023-12-20','z','v','v','w',null,null,'c','v'),
+
(68,2,8,7,-10,null,8986004892348197686,-3076401008354772909,-3869023017589822322,'2025-06-18','2024-01-09','2025-06-18','2025-06-18','d','k','d','p','f','j','r','x'),
+
(69,6,7,4,2,4247710583746697039,null,-2881224756676054192,-6504487671782598775,'2026-01-18','2025-02-18','2024-01-31','2023-12-10','e','x','e','i','r','g','s','k'),
+
(70,3,null,5,-4,null,-6379628078115148755,-8637357844994209885,-1175147288893128810,'2023-12-12','2023-12-16','2025-02-18','2023-12-15','w',null,'x','l','s',null,'i','x'),
+
(71,-10,-4,8,4,-161114011499147333,null,7527570514662628811,-3143294038995043817,'2023-12-18','2024-02-18','2026-02-18','2027-01-16','z','y','e','t','f','v','i','t'),
+
(72,1,8,4,-10,null,-2566686755560124707,-1984722270271696408,6554878357826736076,'2023-12-20','2023-12-14','2023-12-11','2023-12-17','y','h','j','z','l','m','z','b'),
+
(73,-10,9,0,-10,null,-5911079654787097794,-1231723484332417712,-1510404922414526519,'2024-01-08','2024-01-08','2024-01-09','2023-12-20','x','t','a','i','w','d','x','i'),
+
(74,-4,-4,-10,-4,1021982051302183303,null,-5524412173519497971,4762631702038202273,'2024-02-18','2023-12-15','2023-12-12','2024-01-08',null,'g','l','m','m','r','q','s'),
+
(75,-4,5,1,-10,-8187291799007472601,-1589344171272697978,-2221672332904187079,-5498875241982219042,'2023-12-13','2024-01-31','2023-12-12','2024-01-19','d','g','g','i','f','e','e','q'),
+
(76,2,null,1,5,-1049556416011894874,5659823604821247801,4576617879751897252,7679004151039096951,'2023-12-10',null,'2024-01-19','2023-12-11','g','y','i','l',null,null,'z','m'),
+
(77,2,8,3,-10,-8298457594137779019,-3008519884517039277,6165454958542109984,-2857572786594217366,'2024-01-08','2025-06-18','2023-12-18','2023-12-17','f','y','d','b',null,'g','k','g'),
+
(78,7,null,2,1,7922947873248670954,null,-8033901538112331881,-7734882996737897338,'2024-01-31','2024-01-08','2024-02-18','2023-12-10','w','m','x','n','g','m','g','q'),
+
(79,2,0,-10,-4,null,null,6866577989530226549,-5648133931388839462,'2025-02-17','2023-12-11','2023-12-10','2023-12-14','x',null,'c','k','n','k','o','j'),
+
(80,null,2,5,5,-4002764782855679718,-3334085319763484862,7078340365437125170,153422961666453264,'2023-12-10','2023-12-11','2024-02-18','2023-12-16',null,'x','z','y','l',null,'g','k'),
+
(81,-4,8,1,3,-502598168988806100,-2215017116349710864,6667779713577352926,-5057578441666532067,'2023-12-12','2023-12-19','2024-01-31','2024-01-09','l','k','b','l','o',null,'w','z'),
+
(82,-10,1,-10,9,-3923170050209511192,null,2722142715895290021,8574020792796821057,'2024-02-18','2023-12-12','2024-01-09','2023-12-17','e','b','a','p','r','u','l','b'),
+
(83,3,6,-4,1,1998510655215300619,null,6354289167038372886,-1329048652064706437,'2023-12-18','2023-12-18','2024-01-19','2024-01-09','w',null,'g','a',null,null,'k','p'),
+
(84,6,1,9,6,4641731249315512781,-1703620321495592488,-6092625881819943380,-8101002340899447705,'2024-01-09','2023-12-12','2025-02-18','2025-02-17','v','c','o','u','d','c','d','s'),
+
(85,6,8,5,4,1844668414721960612,-8146210778991800273,-3936859523385652823,1968571585919863013,'2023-12-13',null,'2025-06-18','2026-02-18',null,'h','n','b','s',null,'p','h'),
+
(86,6,4,-4,5,2307184585446501717,8457935425369849751,-4640790242830318334,-5720189668042239199,'2024-01-17','2024-01-31','2024-01-09','2023-12-12','l','d','y','x','b','z','o','d'),
+
(87,null,-4,1,-4,-4079880541179092990,-8777085310848376529,-8855355639795760272,-6213712627501603776,'2023-12-17','2026-01-18','2025-06-18','2023-12-19','q','x','i','k','y','z','i','r'),
+
(88,2,-4,1,9,2449530539661493163,null,-1034942690256776893,-5239530726206775030,null,null,'2025-06-18','2025-02-17','p','p','e','v','i','s','u','y'),
+
(89,-4,4,9,9,null,580744008591223310,582804241137928552,2826188225544777887,'2026-02-18','2023-12-09','2024-01-17','2024-01-09',null,'w','s','p','e','j','n','q'),
+
(90,null,-10,1,-10,null,8077986560665786085,-3076874287907959745,-6280654642858117473,'2024-02-18','2025-06-18','2024-02-18','2023-12-14','z','q','u','g',null,null,'k','d'),
+
(91,8,null,3,7,-7897081096047758209,-9050557163818221881,-2541271846187182209,8303513704230583288,'2024-01-31','2026-01-18','2024-01-09','2023-12-20','s',null,'r','s','f',null,'q','a'),
+
(92,-10,3,0,-4,null,2453017922179789859,7337126341758369206,-5602454622732291242,'2024-01-31','2023-12-16','2023-12-20','2027-01-16','k','q','w','f',null,'e','z','a'),
+
(93,0,-10,-10,6,8992480174027148091,-1670336162804176485,1411753004553957735,-198618186182788640,'2024-01-19','2023-12-17','2024-01-08','2024-02-18','r','o','p','y',null,'x','y','u'),
+
(94,-4,6,-10,-10,-8957466425083050119,-2402909453843046228,3531706226758585417,-3669324823467897400,'2025-06-18','2025-02-18','2023-12-12','2026-01-18','g',null,'h','x','e',null,'c','g'),
+
(95,null,8,-4,-10,null,null,6839449815129485589,279614831548786313,null,'2023-12-11','2023-12-16','2023-12-20','c','m','e','b','g','o','k','a'),
+
(96,2,6,-10,-10,738742098729572283,-5347826738826717328,5940077377412709204,1070229902504882739,'2026-01-18','2023-12-18','2023-12-13','2023-12-18','p',null,'q','c',null,'w','b','q'),
+
(97,2,5,-10,5,2852709492739526594,3864442720152847647,-5206985522063394337,7684852802358358168,'2023-12-18',null,'2027-01-09','2025-06-18','b','k','c','e',null,'p','l','l'),
+
(98,0,6,-10,-10,8129634363133588286,null,6601689984342767762,-2581265504187476060,'2023-12-11',null,'2024-01-09','2024-01-08',null,'m','j','n','s',null,'s','l'),
+
(99,7,5,-4,-4,null,-8927275264663200004,2454888163421628958,1159285906723119737,'2024-01-19','2024-02-18','2023-12-13','2024-02-18','e','u','f','t','x','v','l','v'),
+
(100,1,null,-10,2,null,-7481942172263910485,-6831752050563716337,-223828997630176126,'2026-02-18','2024-01-17','2023-12-18','2025-06-18','s','y','v','q','e','j','j','o'),
+
(101,0,1,8,8,null,null,-4659777097019506942,-6911205925937430248,null,'2025-06-18','2025-02-17','2023-12-19','q','i','q','a',null,'h','j','w'),
+
(102,null,4,6,6,-5383300846905119484,-3852892649923125183,8741303194326577454,-1422162377162384531,'2023-12-15','2023-12-16','2024-02-18','2025-02-17',null,'g','s','f','q','d','u','c'),
+
(103,9,-10,1,0,null,-5366175811963673605,-6025984314237815618,3195746254337656948,'2023-12-13','2023-12-19','2023-12-11','2024-01-19',null,'p','b','s',null,null,'x','m'),
+
(104,2,0,9,3,543598546805911905,7963087580304173292,41125194827462574,-5996112137043481658,null,'2023-12-12','2025-02-17','2023-12-16','v','o','m','u','e','s','z','c'),
+
(105,-4,3,-10,5,null,-6700664837979733535,-5960927335705409832,99083855513148415,'2023-12-16',null,'2024-02-18','2025-06-18','p','g','z','p','w','t','a','v'),
+
(106,2,0,2,5,6185015649563523480,-4256528497487740013,-7682960043948784363,-4730508576545418376,'2024-01-08','2024-01-09','2025-02-18','2026-02-18','r','m','b','v',null,null,'n','d'),
+
(107,3,-10,1,7,4518382840624285261,-4708648979257994067,-1184766874694299954,1822263113487199481,'2023-12-09','2023-12-13','2025-06-18','2023-12-17','z','d','s','h','c','l','i','t'),
+
(108,-10,7,4,8,6298603150862889107,null,-8033238113214998802,8655415796198685900,'2024-01-17','2023-12-19','2023-12-20','2024-01-31',null,null,'a','l','y','d','r','f'),
+
(109,-4,4,-10,1,8211484109800317652,-2044676252909838031,-3174454308715372561,205997297789665844,'2023-12-11','2025-06-18','2025-06-18','2026-02-18','e','p','h','q','r','p','x','t'),
+
(110,7,null,-4,6,-5355279419137407168,null,-4771711721664649895,-1832061257770180659,'2023-12-16','2024-02-18','2023-12-10','2024-01-09',null,null,'d','o','j',null,'m','w'),
+
(111,-10,8,9,7,null,null,3495781070681066731,-7751769959271685461,null,'2024-01-09','2023-12-17','2023-12-16',null,'q','y','q',null,null,'n','p'),
+
(112,3,2,7,5,null,-8426913959368365890,-3322518183186526632,-9012922211700264139,'2025-06-18','2023-12-09','2025-06-18','2023-12-17','q',null,'f','m','h','d','g','i'),
+
(113,6,1,-4,9,3307572978351887404,null,7216752837703912613,-1099717463162147826,'2023-12-20',null,'2026-01-18','2027-01-16','c',null,'l','x',null,'c','g','s'),
+
(114,6,0,2,5,4273745106575096240,-4309878515979504572,-8743375667691118143,1150882016866373141,'2023-12-13','2024-02-18','2023-12-13','2024-01-08','n',null,'v','p','b',null,'p','o'),
+
(115,null,8,1,2,-5325473613954832428,-6305506083342863376,3282163540651038181,-2348922300393953043,'2023-12-18',null,'2023-12-15','2024-02-18','w','n','t','s',null,null,'a','b'),
+
(116,-10,5,-10,5,null,-2280008494954635011,7599532400772891574,-6972157389604191866,'2023-12-12','2023-12-19','2023-12-10','2024-02-18','p',null,'l','g','z','r','d','e'),
+
(117,1,null,3,-4,6509515715296433309,null,-7316943633816884717,-7588155182092565097,'2024-02-18','2024-01-08','2024-01-31','2025-06-18','h','o','u','v',null,'k','l','r'),
+
(118,7,null,-4,-10,-5348942484818265920,-115842037267334644,8921697522425758050,-7589445783794413545,'2023-12-17','2024-02-18','2023-12-12','2026-02-18','v','z','j','k','s','h','s','d'),
+
(119,null,-4,6,-10,-963346494928329499,-5943554955977630098,-3904762043076439214,-3589895882724627048,'2023-12-12','2024-01-09','2023-12-11','2027-01-16','o','p','p','s','o','t','a','e'),
+
(120,2,null,0,4,-22680686098672503,null,-5542083999655223056,7463003916581539418,'2025-06-18','2024-01-31','2023-12-09','2023-12-11','c','d','m','i','f','l','n','m'),
+
(121,null,null,6,5,392367742148684396,6215444246243059703,7058433144043520407,-5126721088826007011,'2027-01-16','2024-01-08','2026-01-18','2024-02-18','k',null,'u','y','c','i','q','a'),
+
(122,-10,1,-4,5,-3938055250590368252,null,-7571075358146213188,6550266852494957073,'2023-12-14','2023-12-12','2023-12-20','2024-02-18','n',null,'r','k',null,'b','r','n'),
+
(123,-4,-10,8,5,null,2138737019170354262,351373869269067115,7058505121160252015,'2025-06-18','2023-12-09','2027-01-16','2024-01-19','i','m','q','n','a','g','o','h'),
+
(124,3,-4,8,-10,-4210455955286522087,null,2231635375866126752,5613078292080299722,'2023-12-13','2023-12-20','2024-02-18','2023-12-16',null,'a','c','p','p','v','v','f'),
+
(125,-4,-10,9,7,null,-245792394362721219,-3380330149007444668,7370021404759691579,'2023-12-15',null,'2023-12-19','2025-02-18','b','o','v','j','p','l','k','t'),
+
(126,-10,3,-10,7,3388478275171816529,729277112928857610,7032754029847169854,-4106297766531731833,'2024-01-19','2023-12-19','2024-02-18','2023-12-11','g','y','n','n','m','s','g','t'),
+
(127,null,-4,2,-4,-686394147000737042,null,-3106943452438700394,-7634277061725223758,'2024-01-17','2024-02-18','2027-01-09','2024-01-09','k','j','g','p','h','z','d','u'),
+
(128,null,1,0,5,6950104621570455987,2471141496485968350,778426102249376628,6570889237740344011,'2026-02-18','2026-01-18','2023-12-15','2024-02-18','m','x','t','h','p','v','h','w'),
+
(129,null,0,-10,4,-6879977270320432909,null,-4541442347808369450,-8186430568429593475,'2027-01-16','2024-02-18','2023-12-20','2024-02-18','f','x','z','z','q','o','g','d'),
+
(130,-10,0,-4,-4,3564989563073709122,2900579710103386402,6368392132419761484,8375904869864765554,'2023-12-19','2026-02-18','2024-01-19','2023-12-19',null,'p','d','l','b','r','t','e'),
+
(131,-10,6,5,9,1394750496655932510,4577557961658420405,-370836983757236658,6306036168787890000,'2023-12-15','2027-01-16','2023-12-10','2024-02-18','p','k','x','z','z',null,'n','j'),
+
(132,null,8,5,1,5700672970687850887,9170134070500207214,1057023106304799660,9018548651389304582,'2023-12-20','2027-01-09','2023-12-20','2024-02-18','h','h','k','i','r','d','b','f'),
+
(133,-4,2,0,3,null,-742292491060610773,4631105689365007235,4126317630870085333,'2026-02-18','2026-01-18','2023-12-12','2023-12-18','w','j','m','s','v',null,'a','o'),
+
(134,-10,2,-10,1,-5225256832161593284,-4130895541709655456,6330602409572608338,8464814604243196898,'2023-12-15','2024-02-18','2023-12-15','2026-01-18','u','p','c','h','u','l','m','m'),
+
(135,-10,0,2,9,null,8143831258642605184,-2725133517955844922,8895278493520317424,'2024-01-09','2023-12-13','2023-12-09','2023-12-11',null,'m','h','g','i','b','t','e'),
+
(136,9,6,8,-10,3089055599373292605,2754698593244717196,-1062489555710081596,-5348210221819126242,'2024-01-31','2027-01-16','2023-12-10','2027-01-09','y',null,'d','c','i','u','y','w'),
+
(137,9,-4,-4,8,null,null,-3229149233350248404,4959767326079369496,null,'2024-01-19','2026-01-18','2026-02-18','d','t','l','d','h',null,'w','l'),
+
(138,-4,-10,2,-10,null,5870998506145918366,7295672039040337093,5140113514492461307,'2024-02-18','2025-02-18','2023-12-19','2023-12-19','t','u','i','r','x','k','r','w'),
+
(139,0,4,7,6,1753303443248375231,-9172088115534524215,8827609633045132813,-5001366908295118601,'2024-02-18',null,'2023-12-09','2023-12-10','c','s','y','k',null,'a','y','j'),
+
(140,8,-10,7,8,5673776871824353756,null,6158602833656611687,-5982984041243386520,'2023-12-13','2023-12-15','2026-02-18','2024-02-18',null,'c','s','q','g','j','q','m'),
+
(141,3,8,-10,-10,5390990103301446933,-2355660463889030891,-2769621455151539522,-5201597879712237394,'2024-01-08','2025-06-18','2024-02-18','2024-02-18','l',null,'g','q','p',null,'g','f'),
+
(142,null,1,-4,6,-6687890083051077019,8639164517873186908,426636294373918583,3832029756764217724,null,'2025-06-18','2023-12-10','2024-01-19',null,'u','h','w',null,'s','v','m'),
+
(143,-10,-4,-4,-10,null,8949000333639224425,6067902032507147112,-8446123205471028580,'2025-02-18','2027-01-16','2024-01-31','2023-12-11','g',null,'t','b','m',null,'q','v'),
+
(144,null,9,5,-4,339204242343824700,2278285957545941692,-1943782900027721772,-8348310440995114935,'2023-12-17','2023-12-11','2023-12-13','2026-02-18','n','n','i','f','f',null,'n','k'),
+
(145,0,null,8,-4,null,null,3695608990914575340,4568884434825134946,'2027-01-09','2025-06-18','2023-12-12','2023-12-10','g','p','v','j',null,'d','j','d'),
+
(146,null,0,1,1,5498577630379820303,-3503412173309954418,-3770797427518516131,4198094291883669841,'2027-01-16','2027-01-09','2023-12-20','2024-01-09',null,'j','a','v','j',null,'d','a'),
+
(147,-4,-10,7,-4,-6510420309842072678,null,4759433064330161922,8849696642448442688,'2023-12-16','2024-02-18','2024-01-19','2023-12-16','u','h','m','f',null,'n','i','b'),
+
(148,7,7,-4,4,-1528546365398989087,878406751783699950,-5873519552663755005,3831259362162200901,'2023-12-13','2023-12-15','2024-01-17','2024-01-08','s',null,'u','c',null,'p','z','c'),
+
(149,4,-10,0,-10,null,8357361433200011727,-9173692827007418900,-7200603283707275459,'2023-12-11','2023-12-09','2024-02-18','2026-01-18','c','i','i','w','b','l','v','q'),
+
(150,2,0,-10,0,-5825377272342249605,null,-5212665030454190226,-969357951484574036,'2027-01-09','2023-12-17','2024-02-18','2027-01-16',null,'j','i','l','s','g','h','h'),
+
(151,-10,0,4,7,-6947893377272167242,null,-6411444504208654865,-1979976902011568550,'2023-12-15',null,'2023-12-09','2024-01-31','i','e','w','m','v','g','f','s'),
+
(152,-10,-10,-4,7,6370484431281596431,-8518580439911769132,-7050763773315008926,-6390924258173564173,'2027-01-16','2024-02-18','2025-02-18','2023-12-09','g',null,'f','p','l','n','q','f'),
+
(153,-10,9,1,-10,null,null,-7673493355059181431,8477857846738446950,'2026-02-18','2024-01-09','2023-12-15','2023-12-13',null,'i','s','n','p','o','h','w'),
+
(154,-4,1,-10,9,-7834679095386913011,null,-3735896019062322969,-4942386992134761207,'2026-01-18','2027-01-09','2027-01-09','2024-02-18','i',null,'v','l',null,'s','p','x'),
+
(155,6,3,1,-10,-8297787415300020751,5520768481578535257,-1114470387745182661,-764765837348618453,'2024-02-18',null,'2027-01-16','2026-02-18','g','f','b','e','p','l','d','a'),
+
(156,null,9,3,-4,-7432405070463824918,-6693375447762756089,-1986811764636941378,7077340990429825479,'2027-01-16','2025-02-17','2027-01-09','2023-12-20','b','f','f','j',null,'m','w','s'),
+
(157,2,3,-4,-10,-8043045030806164917,-7870179836885921967,8761871061746148914,1842089240437598176,'2023-12-16','2024-02-18','2023-12-16','2023-12-10','z','y','v','r',null,'p','x','k'),
+
(158,1,0,1,0,null,null,1734010327074713406,1979012233763050208,'2024-01-17','2027-01-09','2025-06-18','2024-01-31','a','g','b','m','w','h','i','z'),
+
(159,4,6,-10,3,7192508453543324048,-6493858886834315917,5768439037668650007,221519802612139801,'2023-12-12','2024-02-18','2025-06-18','2025-02-18','w','x','l','h','e','w','j','y'),
+
(160,8,6,4,3,-1529328817972905373,null,9029791646209013309,-4505746455681779129,'2023-12-18','2024-01-08','2026-02-18','2023-12-20','u','r','m','r','a',null,'m','x'),
+
(161,5,null,2,3,null,7544424000557143615,-6778192840580332023,1593932536200889022,'2023-12-16','2023-12-15','2023-12-13','2025-06-18',null,null,'z','d','c','y','d','c'),
+
(162,null,1,6,7,1191103517914911622,-1425723294077995795,-8923934703783583290,-2392525107762314937,'2024-01-19','2024-01-08','2023-12-19','2026-02-18','g','o','t','r','m','o','i','l'),
+
(163,3,-4,6,0,null,4958150149198231841,6593245031185906035,-1747221098105687052,'2023-12-14','2025-06-18','2025-06-18','2023-12-17','r','d','b','z','q','s','g','m'),
+
(164,-10,3,3,-4,8102016218211253674,7284917939501292395,7564867875027596179,927945446368696584,'2024-02-18','2023-12-12','2023-12-14','2027-01-16','a','f','l','f','k',null,'z','g'),
+
(165,null,7,6,-10,null,4355506312577609302,-2705174508623903125,4098801940084898398,'2023-12-09',null,'2023-12-18','2023-12-13','m',null,'j','e','u',null,'i','t'),
+
(166,8,2,0,-10,-4990309479252218962,null,3790696393467372822,2391765835488247935,'2024-01-19','2024-01-17','2024-02-18','2023-12-16',null,'e','t','h','b','o','u','e'),
+
(167,2,-4,6,-10,-6137076672853547468,null,-2900378247730534940,-2338205081190906530,'2025-02-18','2027-01-16','2023-12-17','2023-12-10','d','c','q','t','d','l','f','m'),
+
(168,0,5,-10,7,null,1519973463029064780,-6509976041346963722,886038751462832370,'2023-12-20','2023-12-20','2023-12-12','2023-12-10','a',null,'s','k','k','j','c','n'),
+
(169,8,9,5,-10,-511207748233993056,7046983661427344232,-5318962225951558018,-1318222236071998412,'2023-12-19','2023-12-19','2023-12-16','2027-01-09','p',null,'g','y','h',null,'o','l'),
+
(170,6,0,7,-4,null,5924995693151446165,2857092396499732737,4719009073079633717,'2023-12-16','2027-01-09','2025-02-18','2024-02-18',null,'a','l','r','c','g','z','r'),
+
(171,4,0,1,-10,-5807726131379650488,6259985254657646686,1028606200226150260,2120169321684016642,'2024-01-19','2024-01-08','2023-12-20','2023-12-11','k','c','t','h','t','w','z','n'),
+
(172,-4,6,2,-10,-6851025984395220766,-328701344968344845,6218450411210712060,225568743996045356,'2026-02-18','2026-01-18','2023-12-18','2024-01-31','k','m','j','p','g',null,'h','c'),
+
(173,null,8,0,2,1642699978568713558,-2568532380212377065,-2082836525352075283,5209217917654654520,'2024-01-17','2026-02-18','2024-01-19','2023-12-17','a','a','y','g','v','u','u','s'),
+
(174,-4,4,-4,-10,-2348526840264403896,null,-2977286597882087585,-8430105457775039900,'2027-01-16','2026-02-18','2024-01-09','2023-12-18','b','b','q','g','m','m','x','c'),
+
(175,0,-4,5,9,-4097757866510737899,6783793723723705316,261959403170202823,-6825567933941997716,'2024-01-17','2023-12-16','2023-12-16','2026-01-18','q',null,'f','y','g',null,'v','u'),
+
(176,-10,2,-10,0,null,null,-140347096143572621,86829518304300526,'2023-12-15','2024-02-18','2023-12-18','2026-02-18','i','o','w','c','w','m','h','g'),
+
(177,null,-10,-4,-10,-7615873053221805473,6325575376391465954,5458267994860900945,1669894698302833125,'2023-12-11','2023-12-15','2024-01-31','2024-01-09','e','h','x','y','u','h','f','y'),
+
(178,-4,null,0,-10,-3374084688925056163,-8974590571037228863,6173067536220354560,5177723430144022077,'2023-12-17','2025-06-18','2024-01-09','2026-02-18','e','x','y','l','b','l','r','e'),
+
(179,-10,3,-4,3,4888772792430910481,-2422846341304380745,-3409113689143764843,-277946275457162521,'2024-02-18',null,'2023-12-15','2023-12-14','k','h','j','c',null,'p','z','z'),
+
(180,0,-10,-4,4,4559628989934340783,1169759166701362797,8038493369777588256,-3475228011229159393,'2024-01-09','2026-01-18','2024-02-18','2026-01-18',null,'z','m','m','f','f','v','m'),
+
(181,null,-4,-10,4,-7639548024677292410,null,7741850675438233282,4199787323519713824,null,'2026-01-18','2023-12-10','2023-12-13','c','z','u','o','e','d','g','j'),
+
(182,4,9,7,-10,-7047837547077595442,-1349401890221094682,-8853431113232879688,-7249128399854997696,'2023-12-19',null,'2023-12-17','2024-01-17','a','p','h','k','y','k','g','k'),
+
(183,-10,9,9,3,3193253807762625012,-5090770560149993651,1493502922801515898,1308247327449744618,'2023-12-12','2023-12-17','2023-12-14','2027-01-16','o','r','r','m',null,'f','z','y'),
+
(184,3,-10,5,-10,7601150030431055036,-812354007846758385,8625532598119016236,-4767366624796468315,'2025-02-17','2025-06-18','2024-01-19','2023-12-13','x',null,'h','t','b','a','l','l'),
+
(185,4,7,9,-10,-6021921667796296429,1218029009091194815,-937139680579393800,-5699041435989644582,'2023-12-20','2023-12-12','2024-02-18','2024-02-18',null,'a','d','p',null,null,'n','a'),
+
(186,null,5,0,-4,-4739781826478334628,3448714532477042523,6622887693003280697,-4672628169180526397,'2023-12-10','2023-12-14','2024-01-08','2024-01-08','f',null,'q','u','b','f','y','t'),
+
(187,6,-10,4,0,-6552746736645849518,7759107423043535417,-7360918406119053279,-4697591193108461511,'2023-12-10','2023-12-13','2026-02-18','2025-02-17','i','q','l','t','r','f','p','v'),
+
(188,1,-10,6,3,2551624430450557094,-9221429894279860380,-4029424833018792759,-2163512570069363981,'2023-12-13','2023-12-11','2023-12-14','2026-01-18','v','j','o','l','e','q','g','k'),
+
(189,-10,-4,1,-10,-4266387829623969689,8664598246988494509,-5427197804641841558,2504276125332448414,'2023-12-20','2023-12-14','2023-12-18','2024-02-18','a','r','c','v','g',null,'p','u'),
+
(190,-10,-10,1,2,null,-5948265905124383321,-7991503254852671835,-7043212206068634989,'2027-01-16','2023-12-18','2025-06-18','2024-01-17','t','l','z','a','t','a','j','e'),
+
(191,0,null,7,1,1548108972526451159,4462555000975404165,4615986075498860358,-1621744719252279787,'2024-02-18','2023-12-14','2024-01-31','2025-06-18','z','r','i','j','n','p','e','m'),
+
(192,1,-10,-10,8,-6983097378483968395,-1670182270275689551,1321755971686558697,-4296180545508691666,'2023-12-11','2023-12-15','2024-01-09','2027-01-09','t','l','b','h','d',null,'e','f'),
+
(193,-10,9,6,8,4045177501727154496,null,5650317515348191145,-7005853801693584638,'2024-01-31','2023-12-09','2023-12-10','2024-01-31','i','g','n','m',null,null,'u','j'),
+
(194,8,-10,-4,2,-6781646106891734793,-4667314839816313423,-6624319356593031557,8007192365744554099,'2023-12-19','2024-02-18','2023-12-14','2027-01-16','c',null,'j','m','v',null,'d','w'),
+
(195,null,null,3,5,-9046822387689193037,-5639261652851770842,-2209317473234106988,-5451079706538694578,'2024-02-18','2023-12-12','2024-01-19','2024-01-09','q','j','v','e','h','s','c','s'),
+
(196,3,-4,4,4,3194602054453660972,null,-2451730047630426313,3495039411706418770,null,'2023-12-13','2024-01-09','2024-01-09','e','k','m','j',null,null,'k','q'),
+
(197,null,null,-4,0,5528277152284673127,null,-6870269485237355163,-4701734578161453960,null,'2024-02-18','2023-12-11','2023-12-18','g','s','a','j','e','j','p','m'),
+
(198,2,-4,1,-4,8482784137563371099,664963432144069941,-8513218057058084600,-733752538492864451,'2023-12-17','2023-12-15','2023-12-16','2024-02-18','g','u','r','y','k','r','q','i'),
+
(199,-10,-4,3,4,-5342490364422145651,4360392406090046370,6261509186250799159,-7692382056950526338,'2027-01-16','2023-12-09','2025-02-18','2023-12-15',null,null,'q','p','d','p','w','d');
+ """
+
+ qt_select_no_need_1 """
+ SELECT
+ COUNT(DISTINCT table1.col_date_undef_signed_not_null_index_inverted)
AS field1,
+ (
+ (CASE
+ WHEN (table1.col_int_undef_signed_not_null - (4 + 1) <>
table1.col_bigint_undef_signed)
+ THEN table1.col_int_undef_signed_not_null
+ WHEN (table1.col_int_undef_signed_not_null IN (NULL))
+ THEN table1.col_int_undef_signed_not_null_index_inverted *
(8 + 1)
+ WHEN (table1.col_int_undef_signed_not_null_index_inverted IN
(2))
+ THEN
DAY(DATE_ADD(table1.col_date_undef_signed_not_null_index_inverted, INTERVAL 8
DAY))
+ WHEN (table1.col_int_undef_signed_not_null <=
YEAR(table1.col_date_undef_signed_index_inverted))
+ THEN 8
+ WHEN (table1.col_int_undef_signed_not_null_index_inverted * (1
+ 1) IN (9))
+ THEN table1.col_int_undef_signed_not_null_index_inverted
+ WHEN (table1.col_int_undef_signed + (7 + 1) !=
table1.col_int_undef_signed_not_null)
+ THEN table1.col_bigint_undef_signed_not_null
+ ELSE
(MONTH(table1.col_date_undef_signed_not_null_index_inverted))
+ END)
+ ) AS field2,
+ table1.col_int_undef_signed_not_null_index_inverted AS field3,
+ table1.col_int_undef_signed_index_inverted AS field4
+ FROM
+ ${table4} AS table1
+ LEFT OUTER JOIN
+ ${table3} AS table2
+ ON
+ (table2.col_int_undef_signed_index_inverted =
table1.col_int_undef_signed_index_inverted)
+ WHERE
+ NOT (
+ (table1.col_varchar_1024__undef_signed_not_null_index_inverted
= 'n')
+ OR (table1.col_int_undef_signed_not_null_index_inverted BETWEEN
NULL AND (8 + 8)
+ AND table2.col_date_undef_signed_not_null_index_inverted BETWEEN
'2000-03-11'
+ AND DATE_ADD(table1.col_date_undef_signed_not_null_index_inverted,
INTERVAL 9 DAY))
+ OR (table1.col_varchar_1024__undef_signed_not_null_index_inverted
<
+ table1.col_varchar_1024__undef_signed_index_inverted)
+ )
+ GROUP BY
+ field2, field3, field4
+ ORDER BY
+ field2, field3, field4
+ LIMIT 1000;
+ """
+
+ def table5 = "test_index_no_need_read_data5"
+ sql "drop table if exists ${table5}"
+ sql """
+ create table ${table5} (
+ col_int_undef_signed_not_null_index_inverted int not null ,
+ col_date_undef_signed_not_null_index_inverted date not null ,
+ col_bigint_undef_signed_not_null_index_inverted bigint not null ,
+ col_bigint_undef_signed_not_null bigint not null ,
+ col_int_undef_signed int null ,
+ col_int_undef_signed_index_inverted int null ,
+ col_int_undef_signed_not_null int not null ,
+ col_bigint_undef_signed bigint null ,
+ col_bigint_undef_signed_index_inverted bigint null ,
+ col_date_undef_signed date null ,
+ col_date_undef_signed_index_inverted date null ,
+ col_date_undef_signed_not_null date not null ,
+ col_varchar_10__undef_signed varchar(10) null ,
+ col_varchar_10__undef_signed_index_inverted varchar(10) null ,
+ col_varchar_10__undef_signed_not_null varchar(10) not null ,
+ col_varchar_10__undef_signed_not_null_index_inverted varchar(10) not null
,
+ col_varchar_1024__undef_signed varchar(1024) null ,
+ col_varchar_1024__undef_signed_index_inverted varchar(1024) null ,
+ col_varchar_1024__undef_signed_not_null varchar(1024) not null ,
+ col_varchar_1024__undef_signed_not_null_index_inverted varchar(1024) not
null ,
+ pk int,
+ INDEX col_int_undef_signed_index_inverted_idx
(`col_int_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_int_undef_signed_not_null_index_inverted_idx
(`col_int_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_bigint_undef_signed_index_inverted_idx
(`col_bigint_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_bigint_undef_signed_not_null_index_inverted_idx
(`col_bigint_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_date_undef_signed_index_inverted_idx
(`col_date_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_date_undef_signed_not_null_index_inverted_idx
(`col_date_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_varchar_10__undef_signed_index_inverted_idx
(`col_varchar_10__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_varchar_10__undef_signed_not_null_index_inverted_idx
(`col_varchar_10__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_varchar_1024__undef_signed_index_inverted_idx
(`col_varchar_1024__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_varchar_1024__undef_signed_not_null_index_inverted_idx
(`col_varchar_1024__undef_signed_not_null_index_inverted`) USING INVERTED
+ ) engine=olap
+ UNIQUE KEY(col_int_undef_signed_not_null_index_inverted,
col_date_undef_signed_not_null_index_inverted,
col_bigint_undef_signed_not_null_index_inverted,
col_bigint_undef_signed_not_null)
+ PARTITION BY
RANGE(col_int_undef_signed_not_null_index_inverted,
col_date_undef_signed_not_null_index_inverted) (
+ PARTITION p VALUES LESS THAN ('-1', '1997-12-11'),
+ PARTITION p0 VALUES LESS THAN ('4', '2023-12-11'),
+ PARTITION p1 VALUES LESS THAN ('6', '2023-12-15'),
+ PARTITION p2 VALUES LESS THAN ('7', '2023-12-16'),
+ PARTITION p3 VALUES LESS THAN ('8', '2023-12-25'),
+ PARTITION p4 VALUES LESS THAN ('8', '2024-01-18'),
+ PARTITION p5 VALUES LESS THAN ('10', '2024-02-18'),
+ PARTITION p6 VALUES LESS THAN ('1147483647', '2056-12-31'),
+ PARTITION p100 VALUES LESS THAN ('2147483647',
'9999-12-31')
+ )
+
+ distributed by hash(col_bigint_undef_signed_not_null_index_inverted)
+ properties("enable_unique_key_merge_on_write" = "true", "replication_num"
= "1");
+ """
+ sql """
+ INSERT INTO ${table5}(
+ pk,
+ col_int_undef_signed,
+ col_int_undef_signed_index_inverted,
+ col_int_undef_signed_not_null,
+ col_int_undef_signed_not_null_index_inverted,
+ col_bigint_undef_signed,
+ col_bigint_undef_signed_index_inverted,
+ col_bigint_undef_signed_not_null,
+ col_bigint_undef_signed_not_null_index_inverted,
+ col_date_undef_signed,
+ col_date_undef_signed_index_inverted,
+ col_date_undef_signed_not_null,
+ col_date_undef_signed_not_null_index_inverted,
+ col_varchar_10__undef_signed,
+ col_varchar_10__undef_signed_index_inverted,
+ col_varchar_10__undef_signed_not_null,
+ col_varchar_10__undef_signed_not_null_index_inverted,
+ col_varchar_1024__undef_signed,
+ col_varchar_1024__undef_signed_index_inverted,
+ col_varchar_1024__undef_signed_not_null,
+ col_varchar_1024__undef_signed_not_null_index_inverted)
+ VALUES
+
(0,-4,2,5,9,1597656363509768688,null,3477062685138998670,4767688554724266649,'2024-02-18','2026-02-18','2026-01-18','2023-12-14','p','k','e','r','u','v','r','r'),
+
(1,null,-4,6,6,null,7053826899060545018,-1737102912815425073,-5764949869476544269,'2025-06-18',null,'2023-12-11','2023-12-11','h','k','t','i','w','o','y','g'),
+
(2,null,1,-4,4,-8335129479222173285,-7566068947847872996,-39411413887182943,-7512882586003478045,'2025-06-18','2023-12-15','2026-02-18','2023-12-17','p','f','p','q','x',null,'e','a'),
+
(3,null,-10,2,-4,8010755982890395310,1559081802508005052,-8715541722086947818,678744477444498899,'2023-12-20','2023-12-17','2023-12-18','2023-12-19','z','e','p','i','u',null,'j','j'),
+
(4,5,null,1,-4,-7228047648562902143,null,7050675995302884140,-8968510540616847830,'2027-01-16','2023-12-12','2023-12-20','2023-12-14','l','a','b','j','k','y','c','a'),
+
(5,-10,0,4,-4,5074228085074203422,null,8120013656225175775,-320006342449097163,'2023-12-15',null,'2024-02-18','2024-01-17','c',null,'u','r',null,'s','k','k'),
+
(6,5,-10,8,0,1115357658589189764,8343874302818886013,8698472252924308100,-7002542535281181212,'2024-01-31','2023-12-17','2023-12-20','2023-12-15','j','h','y','b','m','a','t','a'),
+
(7,-10,-10,1,9,1488620132479970379,-469205316727634966,-1498719844048617134,-231574019079462849,'2025-06-18','2024-02-18','2025-06-18','2023-12-20',null,'z','c','b',null,'i','g','r'),
+
(8,2,-10,4,-10,-3850478684533807957,null,7047793190400950615,7523455668733189832,'2024-02-18','2023-12-18','2023-12-11','2023-12-09',null,'s','j','y','y','r','h','c'),
+
(9,-10,-10,-10,-10,null,null,3435485933063741398,1788726098902371670,'2024-02-18','2024-02-18','2023-12-15','2023-12-20','y',null,'c','c','a',null,'q','i'),
+
(10,3,null,6,-10,8777553935583969387,-3482077951326156517,3901651770999202399,2865780292497180496,'2024-01-17','2023-12-17','2023-12-20','2024-01-17','s',null,'e','d',null,'m','x','d'),
+
(11,2,0,3,3,-6644405142947020693,null,3067064004989127913,7607548084217601403,'2024-02-18','2025-02-18','2023-12-17','2023-12-12','l','t','u','d','y','d','s','x'),
+
(12,null,0,-4,-4,-4872417135400422116,1205495085375795978,-7702512424546554268,-7600835650766273516,'2023-12-19','2025-02-18','2023-12-12','2025-06-18','p','l','b','l',null,'f','h','j'),
+
(13,null,null,-10,2,null,-699882169918477984,-2180291753730440488,3271789779065464999,'2023-12-18','2025-02-18','2024-02-18','2023-12-18','b',null,'t','w',null,'t','k','e'),
+
(14,9,-4,-4,-10,null,null,-5156308894935799537,-6032268031644144468,null,'2024-01-09','2023-12-20','2023-12-10','a','a','i','x',null,'j','c','d'),
+
(15,6,-10,1,2,-3338081029023625464,null,1072509329519376549,-6633612545261775452,'2023-12-19','2026-01-18','2024-02-18','2024-01-31','g','e','n','j','i','d','v','e'),
+
(16,-10,3,0,-10,-1742529706030341317,1056826562732178058,-5364229721598921904,6893536832961113233,'2024-02-18','2024-01-17','2024-01-31','2027-01-09','m',null,'z','p',null,null,'l','l'),
+
(17,2,-4,7,-4,2592405093302233664,1608435584399428122,-6426429174505417004,-7544346517252924507,'2023-12-19',null,'2023-12-16','2025-02-17','p','h','l','n','k','z','f','b'),
+
(18,null,1,0,8,-3573421517528334090,7811565869245468089,-5446226584934144420,-8413430202286478431,'2024-01-09','2023-12-18','2023-12-16','2026-01-18','x','d','h','d','l','b','w','v'),
+
(19,-4,9,8,3,-7125926251423688718,6341224698131984819,-3371654985950559359,1199793145261479561,'2023-12-13','2024-01-17','2023-12-17','2027-01-09','u',null,'q','c','w',null,'e','a'),
+
(20,4,-4,-4,6,807962263040457164,9055398770010878103,3797035456323434216,-8416209988958337787,'2024-02-18','2025-02-17','2023-12-11','2025-06-18','m','h','l','w','z','d','l','o'),
+
(21,null,5,6,0,-2629528750940912658,8962173047011554525,-5906507312435721614,-1786047889497973187,'2023-12-10','2023-12-11','2024-01-19','2023-12-20',null,null,'l','w',null,'w','m','e'),
+
(22,4,6,6,2,-7631688882022577635,7055215301860175948,-3514252823980272726,-7523286580831237711,'2024-01-08','2024-02-18','2023-12-16','2023-12-13','s',null,'w','m','l',null,'p','o'),
+
(23,null,7,6,0,7615656268832605572,-1564610451171981620,-1768817764471954975,-3374849624752145210,'2023-12-16',null,'2024-01-09','2024-01-17','m','t','g','u','j',null,'i','b'),
+
(24,5,-4,-10,2,null,8383349808088957594,2526137371271116192,-6744509714081498854,'2024-02-18','2024-01-08','2025-02-17','2025-02-18','p','a','a','n',null,null,'o','n'),
+
(25,4,-4,8,-10,-1835042141820830937,4299716784649675069,-3825578274899731320,-1153050820367606492,'2023-12-18','2023-12-20','2023-12-18','2023-12-16','h','c','q','m','d','s','x','b'),
+
(26,-10,6,8,6,null,-6641277582431037683,-829195265364748673,4291956542269552120,'2026-01-18',null,'2027-01-09','2026-01-18',null,null,'p','z','v',null,'t','v'),
+
(27,1,-4,0,-10,7147924798526829963,-3008886870901963502,-5500938975328560818,-2937658153167169603,'2023-12-09','2023-12-19','2023-12-18','2023-12-16','r','j','x','b','j','d','f','x'),
+
(28,3,null,-4,2,null,-542393139344341007,7266425618829254654,5986215015408735830,'2024-01-17','2026-01-18','2023-12-17','2024-01-09','l','c','u','h','s','j','x','i'),
+
(29,7,2,-10,0,-2449149726449808461,-3263550110416390547,-743239754115289378,-6439435143295813193,'2023-12-16','2027-01-16','2024-01-17','2023-12-19',null,'c','k','l','z',null,'b','s'),
+
(30,-4,9,-4,-4,null,null,3327862269223543080,-4876768748977414760,'2023-12-12','2023-12-20','2024-01-17','2023-12-10','k','y','f','k','p','r','p','q'),
+
(31,-10,null,2,-10,7580116570554820877,5031256557141064246,-6329653075431116966,-5300877392863357434,null,'2024-01-17','2023-12-12','2024-02-18','m',null,'q','v','x','j','h','d'),
+
(32,null,1,-10,8,null,-8910494162141897995,-1594355786045379063,-7577140151237538169,'2023-12-10','2024-02-18','2026-02-18','2024-02-18','k','b','b','i',null,'l','b','k'),
+
(33,3,9,9,-4,8558413542094480695,null,5454006440161012701,5465596246096425615,'2023-12-12','2027-01-16','2026-01-18','2023-12-18','z','i','s','t','w','s','p','m'),
+
(34,null,3,-4,9,-3010619115778084208,null,3478014528649114415,-7736271480300818538,'2024-02-18','2023-12-10','2026-02-18','2023-12-20','n','z','j','z','q','u','b','p'),
+
(35,-4,6,-10,9,954804292729401716,-9177735606051525480,-2924826934324258500,1168033231532738708,'2026-01-18','2024-01-19','2027-01-16','2023-12-09','q','v','w','k','f','v','q','p'),
+
(36,2,4,9,0,2013170980145920580,999602803052914907,3619616622626928675,-4931185426999669275,'2027-01-09','2023-12-18','2023-12-11','2023-12-19','i','w','d','s','y','s','a','c'),
+
(37,null,0,-10,4,null,746975401946864323,7974370266159571784,6417345951614161873,null,'2024-02-18','2026-02-18','2023-12-12','j',null,'t','d',null,'p','t','g'),
+
(38,-10,2,1,8,-7233548971026614838,-6998803048128269781,-6224763644067194679,6465385609683877470,'2023-12-10','2024-01-17','2027-01-16','2024-01-17','l',null,'g','g','z','q','q','v'),
+
(39,-4,-10,-10,-10,-5932136785653398141,-3208434148480417252,-1734025653531583913,8896034426611488543,null,'2025-06-18','2023-12-15','2027-01-09','y','s','e','u','q','s','k','u'),
+
(40,-10,null,4,7,-1256893551175421503,-3000730495395157134,-1519983435545895221,7798176241963370987,'2024-02-18','2024-02-18','2023-12-16','2027-01-09','y','f','q','j','f','i','k','z'),
+
(41,2,8,4,5,-6545233055337701627,4907365368129133967,2290149502268826972,-7991158197751177069,'2026-01-18','2023-12-09','2024-02-18','2023-12-13','d','w','g','e','i',null,'z','k'),
+
(42,3,3,8,2,-6578508965441022011,-7880264496047938709,-8543331693692098430,3531910304092149753,null,'2023-12-12','2026-01-18','2023-12-14','p','c','v','a','p','e','d','v'),
+
(43,null,4,-10,0,2725457917653505854,8557846150925997359,2807099962181418709,-3588427962483885672,'2025-02-18','2023-12-15','2025-02-18','2023-12-11',null,'n','b','h','a','y','t','x'),
+
(44,null,9,-4,1,7283131058306208552,3978372352631598410,247592582266331249,-6817649122949614629,null,null,'2023-12-11','2024-02-18','i','w','c','e','z','e','o','b'),
+
(45,5,null,5,-10,null,3373140005405369242,-631199712244554305,-7578881427032213857,'2023-12-09','2023-12-14','2023-12-11','2024-01-31','q','m','a','c','t','i','n','i'),
+
(46,4,-4,-4,-10,-5299659623795961390,null,-5444894524037635939,50523792215487445,'2025-02-17','2026-01-18','2024-02-18','2024-02-18',null,'q','s','m','s','u','a','s'),
+
(47,-10,null,2,-10,-4508372775109055189,-3176231319264991284,1502833318832087148,6068460913232380144,'2023-12-19','2024-01-19','2026-01-18','2023-12-09','f','v','c','b','n','i','i','w'),
+
(48,5,6,0,-10,-5233536567112695291,-6445712292797537361,4999849878272342015,8552570538725511161,'2023-12-10','2023-12-15','2023-12-16','2026-01-18','i','t','w','m','z',null,'i','e'),
+
(49,3,null,2,6,null,null,-8176466338515914718,7620389308374960017,'2024-01-08','2025-06-18','2023-12-20','2023-12-18','k','h','r','u','c','q','w','x'),
+
(50,-10,-10,6,9,6181345825903272689,7703063180672679128,5106241172121684908,-8644759987673741100,'2024-01-09','2023-12-15','2023-12-09','2024-01-09','f','q','j','i','t','w','o','i'),
+
(51,5,-4,-4,0,4256799320317438592,null,1978308330977146209,2982804202006508033,null,'2023-12-09','2025-06-18','2024-01-09',null,'m','p','q','p','j','l','a'),
+
(52,3,-4,-10,9,-2047182625461489786,3121447715492634274,5686266365055546679,-9098056376826909848,'2023-12-15','2023-12-17','2026-02-18','2025-02-18',null,'o','m','o','w','w','t','i'),
+
(53,9,4,-4,7,1556963964948837322,6602307728457743664,8655113278003697971,-2731426198260190940,'2023-12-10','2023-12-20','2024-01-08','2023-12-10','c','v','r','o','o','c','h','c'),
+
(54,2,8,5,9,null,null,5406301970195893182,2283742809491369318,'2023-12-13',null,'2027-01-16','2024-01-09','u','q','j','t',null,null,'r','w'),
+
(55,-10,-4,-10,1,-6471529263738757839,7138548307278202012,-5655806087672683329,6695631602579507718,null,null,'2025-06-18','2023-12-11','t','b','g','c','v','a','u','d'),
+
(56,-4,-4,-10,-10,6317667989348451736,null,2623552082300546510,-8945506938562134909,'2026-01-18','2023-12-17','2024-01-09','2023-12-16','c',null,'b','v','y','n','o','o'),
+
(57,9,9,3,6,7349199604579581785,7288848375256119970,3606236740994390683,5551478440501298432,'2023-12-16','2023-12-20','2026-02-18','2027-01-16','b',null,'z','g','l','c','o','q'),
+
(58,-10,null,8,0,null,null,-761254702887054559,4930367676733214645,'2023-12-20','2023-12-15','2023-12-10','2023-12-12','h','k','e','y','t','o','p','x'),
+
(59,0,9,5,4,-3476143564679256164,-2866224544284803007,6055459760545202690,1419923708614798489,'2023-12-12','2025-06-18','2024-01-17','2023-12-13','i','z','r','s','i','i','k','m'),
+
(60,1,6,6,-10,null,null,-6090932991204929047,-7330518274177368125,'2023-12-14','2023-12-17','2026-01-18','2024-02-18','u','k','o','i','r',null,'c','m'),
+
(61,3,4,6,0,null,null,6121442649727188254,944733113920004887,'2024-01-17','2025-02-18','2026-02-18','2023-12-10',null,'c','z','a',null,'t','x','a'),
+
(62,null,-4,5,5,4761777570282150780,6443284183605307399,8016007167227007191,2288156563893925798,null,null,'2023-12-12','2024-02-18','z','d','n','p',null,'u','q','y'),
+
(63,-4,7,0,-4,-4692283756697162205,-4515985465229046211,-3481582668995753148,1673346934739622588,'2026-02-18','2023-12-15','2027-01-09','2023-12-11','m','l','h','l',null,'r','q','e'),
+
(64,-4,0,1,6,4133590807288956396,5708085989361370856,2896879018431987932,5697875663488013740,'2024-01-19','2023-12-15','2025-02-18','2026-02-18','i','x','s','j','v','a','o','j'),
+
(65,0,7,-4,5,-5853817091760814964,-2376936740476715030,6572485125767797939,1852795436897151008,null,'2024-01-17','2023-12-17','2023-12-17','j','z','m','y','w',null,'r','v'),
+
(66,3,-10,9,-4,null,-8468868073609358107,-2916275337502665940,-7235895390022353046,'2024-02-18','2023-12-09','2024-01-09','2023-12-09','x','a','l','e','p',null,'n','c'),
+
(67,-10,-4,6,5,742158889813554037,null,-8428771853332272228,-4554858204337103174,'2024-01-31','2025-06-18','2023-12-12','2023-12-11','f',null,'z','s',null,'j','k','a'),
+
(68,9,-4,7,4,-4856859345791266223,-3610029513132479662,6887693797370118503,7904195769271751685,'2023-12-17','2023-12-12','2025-06-18','2024-01-17','i',null,'x','a','z',null,'z','v'),
+
(69,9,1,6,3,5572751762070059418,-4509942009300363968,3408045521058488016,-3352800658704292744,'2023-12-12','2025-06-18','2024-02-18','2026-02-18','k','q','l','s','l','i','g','k'),
+
(70,4,3,0,-4,4441537213492795994,-6837872668252503022,8754263795362719670,-3618348956417291488,'2026-01-18','2023-12-12','2023-12-12','2023-12-17','e','n','x','d',null,'p','d','l'),
+
(71,4,8,-4,-10,null,-2936401583776579064,-960140797891425104,-4833342212206306015,null,'2023-12-10','2023-12-10','2023-12-12','e','q','i','t','f',null,'v','h'),
+
(72,7,3,-10,7,8771853032688093527,7000827174982085596,1106894299028158001,-1466852027370745758,'2024-02-18','2024-01-08','2024-02-18','2026-02-18','v','h','c','z','b','z','r','o'),
+
(73,0,7,3,7,null,7665290937673679628,5020755453397402790,-9052067807739605901,null,'2024-02-18','2024-01-19','2025-02-18','r','g','a','v',null,'f','g','g'),
+
(74,9,-10,-4,6,-8310303623034423210,null,3339638706507555663,8929196675973262374,null,null,'2026-02-18','2027-01-16','w',null,'m','d','p',null,'l','o'),
+
(75,null,-10,4,-10,-2365312291705438354,721650033830007864,-8010384940553332493,-7315481204829773559,'2023-12-19','2025-02-17','2024-02-18','2027-01-16',null,'q','b','j','i','w','f','a'),
+
(76,-4,4,3,7,1424090740450050572,6064167505669826418,3785000820927952491,-5157609009382905119,'2023-12-17',null,'2024-02-18','2023-12-19','w','a','f','z','x','l','m','g'),
+
(77,-4,0,0,4,null,-7839431906416932985,-8241441269452161831,-1074219681504881915,null,'2024-01-17','2023-12-19','2023-12-14','h','g','k','f','c',null,'p','b'),
+
(78,-10,9,6,-10,null,null,991384140128589590,5423891201283362272,'2023-12-20','2023-12-18','2024-01-08','2023-12-13',null,'w','x','n',null,null,'a','q'),
+
(79,3,null,-4,-10,-7593115752679173787,-2401174188585496004,-4671607850619222855,2072871780706154773,'2023-12-18','2025-06-18','2024-01-09','2023-12-16','e',null,'h','i',null,'z','y','j'),
+
(80,9,-10,-4,5,-6717936580784600387,-8864400986459794599,5607803677297367161,-4512637978159501369,'2024-01-17','2023-12-09','2024-01-19','2025-02-18','v','c','z','f','e','d','c','f'),
+
(81,-10,2,3,-4,4445108204526380252,-1944978576532723771,6960203199500619727,-6857756663640247847,'2023-12-16','2024-02-18','2025-06-18','2023-12-20','j','g','s','n','f','p','u','u'),
+
(82,-10,8,-4,-10,306086597829979006,-7764436285885729668,7199307167487778664,-4346111357847361278,'2023-12-11','2024-01-19','2024-02-18','2023-12-16','l','a','c','b','t',null,'m','m'),
+
(83,6,-10,-10,7,null,null,4681732537204023355,-2356289738487739660,'2027-01-16','2025-02-17','2023-12-14','2024-02-18',null,'a','x','c','m','f','n','m'),
+
(84,3,3,-4,6,null,-2267396918546902495,-3794107337343519595,5489824928006690762,'2023-12-13','2025-06-18','2027-01-09','2024-01-08',null,'b','e','i','y','z','k','a'),
+
(85,9,5,-4,8,2754606819843992474,null,4602870889071333012,37418768839981613,'2023-12-09','2023-12-10','2025-02-17','2023-12-15',null,null,'a','w','y','u','q','o'),
+
(86,null,1,-10,0,-1435450961364862552,null,-7095245157900477894,-1707639265992074971,'2024-01-08','2027-01-16','2024-02-18','2024-02-18','j','c','w','l','q','x','g','b'),
+
(87,null,3,7,5,null,-6074479408089430595,-4012702043255751698,5078569345217983823,'2023-12-10','2024-01-17','2024-02-18','2027-01-09','f','y','f','j',null,'l','n','q'),
+
(88,9,3,-10,3,null,-8658291299982526624,7233410715991104575,4930722601630283273,'2023-12-15','2027-01-16','2023-12-14','2023-12-16','e',null,'i','y','i','a','c','l'),
+
(89,0,-10,4,-4,null,null,-6155233165769459400,-6625601304745147905,'2025-06-18','2023-12-12','2023-12-09','2023-12-12','x','t','b','w','g',null,'y','n'),
+
(90,-4,6,-4,1,null,-8617440068868400881,-4485853795881177636,264072083999789066,'2025-02-18','2023-12-18','2023-12-18','2025-02-17','o','j','z','x',null,'l','u','s'),
+
(91,7,-10,1,7,-9019770589671961763,1920836416049425798,-7522973294659152929,7537609464607333461,null,'2023-12-17','2024-01-17','2025-02-17',null,'l','c','r',null,'c','b','j'),
+
(92,-4,-4,7,6,null,5973348904354699196,4670920932196484283,-1668561480447954116,'2023-12-14','2027-01-16','2025-06-18','2025-02-17','r','j','b','u','i','x','w','o'),
+
(93,null,4,-4,7,null,-4002470210049864765,-3320259876617826113,8019053216705563620,'2024-01-31','2025-06-18','2025-06-18','2023-12-15','b','a','e','l',null,'r','s','l'),
+
(94,8,9,3,3,-4208341743050238193,null,1949965884731430715,-7273032402169870685,'2025-06-18','2025-06-18','2024-01-08','2024-02-18','t','a','j','s','l','j','w','i'),
+
(95,-10,3,0,9,-3332754049963506751,null,-2974393052443111635,4364335977203883677,'2024-01-19','2023-12-12','2025-02-18','2024-01-17','o','r','r','y','c','x','a','q'),
+
(96,null,8,9,3,null,null,663336051869955165,6976629635589261895,'2023-12-16',null,'2024-01-19','2027-01-16','e','k','m','c',null,'g','m','r'),
+
(97,null,-10,-10,0,-8289828820107282666,5926161235243845848,8470343316244700603,1302036978922211535,'2023-12-09','2024-01-09','2023-12-20','2024-01-19',null,'w','s','x','w',null,'f','q'),
+
(98,4,2,0,3,-3715538877788459979,-9190418477109888977,4382057664321747152,-1064550769607271072,'2024-02-18','2026-01-18','2025-06-18','2025-06-18','c','u','e','y','b','k','a','v'),
+
(99,3,null,0,-10,null,-2717638308070185546,1939642534293404539,4264581035985789940,'2023-12-19','2024-01-17','2023-12-20','2024-01-17','b','t','d','n','v','u','l','z'),
+
(100,null,2,1,5,3610690374202771529,-65630678031649762,-8111611953254798410,4886532844447605188,'2023-12-11','2023-12-17','2024-01-08','2023-12-15','s','k','p','f',null,'m','f','c'),
+
(101,1,2,-4,0,6298014739515619507,null,2249013880376945054,-8785251321380163910,'2024-02-18','2023-12-12','2023-12-13','2023-12-20','m','o','c','b','r','l','e','r'),
+
(102,0,6,-4,5,null,null,-5914589146684811638,-6506602557176795091,'2023-12-17','2023-12-12','2026-01-18','2027-01-09','b','q','f','e','n','x','g','k'),
+
(103,2,null,9,-10,3692325208140934961,6021723988093225073,3325184039956336836,-7256277607023347532,null,'2023-12-13','2024-02-18','2023-12-16','e',null,'p','a',null,'a','b','r'),
+
(104,3,9,1,9,-1092237939237856663,null,5835090792412231732,-1403278698098707106,'2026-02-18','2024-02-18','2027-01-09','2023-12-15','k','i','i','j','w','w','z','y'),
+
(105,-4,3,0,4,2629031497687628595,1106039974161625029,-2893347664144425108,-682537518243160504,'2023-12-16','2027-01-16','2023-12-09','2023-12-18',null,'x','h','x','o','a','n','f'),
+
(106,0,null,9,-10,7712777176591749667,1579003848843259169,-1687980317468168178,191713866060282576,'2023-12-17','2023-12-09','2024-01-08','2023-12-17','u',null,'i','q','k',null,'j','g'),
+
(107,-10,2,6,2,-7478612125444333456,-8310903471187624796,1089753572611045696,3970516260861757491,'2024-01-19','2023-12-17','2025-06-18','2024-01-09','e','h','c','s','e','m','x','n'),
+
(108,6,2,2,9,null,null,-2299227022974551707,3205317392825455148,'2024-02-18','2024-02-18','2024-02-18','2025-06-18',null,null,'m','a','i','n','c','w'),
+
(109,null,-10,3,8,-4296670671937804740,null,5547572807280690648,8094928857339230973,'2024-01-08','2024-02-18','2025-06-18','2024-02-18','u','x','x','e','s','r','z','b'),
+
(110,2,8,6,1,-8626378428774269851,4506129639818138593,7819550333726849119,-2459745184222176583,'2025-06-18','2023-12-18','2024-01-17','2026-02-18','i','k','x','e','n','w','g','l'),
+
(111,-10,5,-4,-10,-366126235548744225,6896351375005321993,-2399619867834539388,818054328438546892,'2023-12-17','2023-12-10','2025-02-17','2024-01-08','b',null,'h','n','s','g','u','c'),
+
(112,2,0,6,6,null,4857550115555702390,-2825930969154779767,-2783207812388226187,'2024-01-17','2023-12-11','2024-01-08','2023-12-09','v',null,'n','f','p','p','e','b'),
+
(113,-10,-4,-10,-10,2594465045540922784,4166877316229219774,-983343959804404413,-2674692597364779311,'2023-12-15','2025-02-18','2023-12-18','2027-01-16','n',null,'r','q','a','t','f','y'),
+
(114,null,null,8,-4,-4840657534200157093,null,9080131697764981436,6360062755005734256,'2023-12-14','2027-01-09','2025-06-18','2026-02-18','m','q','x','k',null,'d','m','v'),
+
(115,0,-10,-4,4,null,null,2832706043832702323,3660467846170871044,null,'2026-01-18','2025-06-18','2023-12-20','h','y','u','s','w','m','z','m'),
+
(116,-4,0,0,-4,-5062412393787995484,null,5134623649933706655,-8106300663225367493,'2023-12-19','2027-01-09','2023-12-09','2024-01-08','g','e','f','c',null,'p','r','q'),
+
(117,1,0,0,3,5592014993495047282,-3931766274868155600,-8355636459572913690,-8406779578663919972,'2023-12-13','2023-12-10','2024-01-19','2024-01-17',null,'l','x','t','e','l','m','e'),
+
(118,6,4,2,6,2125017845398329243,null,-2138972478789514959,-6124342358027041063,null,'2024-01-09','2023-12-12','2025-06-18',null,'b','y','o','e','o','b','h'),
+
(119,6,1,4,-10,null,4929311554657213007,-4681829106988135668,5362829677913412786,null,'2026-01-18','2024-01-08','2025-06-18',null,'f','h','t',null,'l','t','t'),
+
(120,0,null,5,7,3506695328876632459,3911410784417939002,2658048973434057434,8406237978609022397,'2025-02-18','2024-02-18','2027-01-16','2024-01-09',null,null,'j','v','q','h','j','e'),
+
(121,3,-10,1,7,null,7190205388012904033,-5817537367405959127,-1020684850820413392,'2025-06-18','2024-01-19','2024-02-18','2026-01-18','v','o','p','k','b','h','k','j'),
+
(122,5,-4,7,8,-1700077098175223936,8773274409492191687,-1580281629115092293,4246514602112547054,'2025-06-18','2025-02-17','2024-01-31','2024-02-18',null,'g','z','c','e','e','u','z'),
+
(123,0,6,-10,-4,2162807918426833539,null,-2273338296102402820,6752333019540761174,'2025-02-18','2027-01-16','2023-12-09','2025-06-18',null,null,'q','r','m','r','m','n'),
+
(124,3,null,4,8,null,null,-3521132648044090919,1529428401787745839,'2024-01-17','2023-12-20','2023-12-18','2023-12-09',null,'d','a','d',null,'p','m','e'),
+
(125,-4,-4,1,-10,5725123748364212788,-8797826498139803462,1878684469497435680,-7298908483924091680,'2023-12-15',null,'2027-01-09','2026-01-18','e',null,'g','s','j','y','w','l'),
+
(126,0,5,5,6,null,9054709399415664499,-3486870500120725193,6126048631547082737,'2023-12-17','2023-12-11','2024-01-31','2024-01-09','v','g','m','s','w','p','d','j'),
+
(127,9,0,2,0,null,8942822845613726384,4995196744774327167,8433991630030909356,'2024-02-18','2024-01-09','2023-12-12','2027-01-16',null,'g','x','w','l',null,'b','j'),
+
(128,7,7,7,4,-7972355990151827559,4711909865339148552,-8911813427278762848,-3759092287096189259,null,'2023-12-15','2023-12-16','2024-01-31','q','d','z','y','u','r','a','j'),
+
(129,9,0,4,0,6367621032781589130,-6499766435777709673,-1484957242194242355,5402739757204439244,'2024-02-18','2024-01-31','2025-02-18','2023-12-15','x','r','d','o','r','d','b','e'),
+
(130,-10,7,3,-4,-3746234806372376483,6732140003803355082,-3318866882156566009,-3838622433860004974,'2024-01-19','2025-06-18','2023-12-13','2024-01-08','u','z','k','p','m','f','x','g'),
+
(131,-10,null,2,2,-6550332796474691666,8750776030616320942,5110965470133359614,3119851742555585121,'2024-02-18','2023-12-14','2027-01-09','2024-01-09',null,'s','j','f','x','j','a','r'),
+
(132,-4,1,5,-4,null,679077130089901711,-984454136175668176,6397247872629308672,'2024-02-18','2023-12-12','2025-06-18','2024-02-18','o','g','v','n','d','b','k','j'),
+
(133,-4,1,-10,4,-3696259358570368695,1206706047036150684,7667786965778890757,-7652409133256645575,null,'2023-12-14','2024-02-18','2024-02-18','n',null,'c','p','f','w','j','q'),
+
(134,4,-10,7,1,908535686674553583,null,-6290652194169323958,-2997949504357225773,'2024-02-18',null,'2026-02-18','2023-12-14','a',null,'k','f',null,null,'g','d'),
+
(135,-4,0,5,-4,null,6194656864067365909,4813123536445184753,-2629564069304520051,'2027-01-09','2023-12-20','2024-02-18','2025-02-17','w',null,'y','r','d','w','e','n'),
+
(136,7,-4,1,-10,2982861183121414308,-4106511130653738303,2539422496382131229,8111092151184229840,null,'2023-12-11','2027-01-16','2027-01-09','f','j','t','j','j','t','s','b'),
+
(137,6,5,-4,2,-4282878903975621428,1519914029575735331,4670547705395860123,346204075283741910,'2025-02-17','2024-01-19','2024-01-19','2023-12-16','n','x','o','d','y',null,'v','r'),
+
(138,-10,6,-4,3,-2627987086202135413,-2510575846444534365,6360971244692027207,7139867382333367844,'2026-01-18','2025-02-18','2024-01-08','2024-02-18',null,'f','e','b','o','a','j','h'),
+
(139,-4,-10,7,5,null,975380043598036224,-6880208129883758510,2486741216523538476,'2023-12-14',null,'2025-02-17','2023-12-15','c','i','x','f','d','w','b','b'),
+
(140,5,1,-4,0,null,-4952653379251796433,-3286944253975051178,-8549343418883589239,'2024-01-09','2025-06-18','2024-02-18','2027-01-16',null,null,'c','f','b',null,'d','x'),
+
(141,7,1,-10,0,5086478114600681828,-5201319921574415614,-2204487312248588450,-3207029867417760247,'2023-12-20','2024-01-17','2023-12-15','2025-02-18','n','e','y','d','v','z','t','w'),
+
(142,null,5,0,3,8252570654818719163,null,7983773335064801710,-750986034245303651,'2026-02-18','2027-01-16','2025-06-18','2023-12-17',null,'q','x','p','n','c','r','g'),
+
(143,8,4,5,-10,-365465944660365439,-183557135648908705,-8890900780744889749,4207266976034775271,'2023-12-20','2024-01-08','2023-12-13','2024-01-08','a','l','x','e','r','x','a','m'),
+
(144,1,3,0,-4,null,null,-3003583898618633821,-2134443998905890217,'2023-12-18',null,'2026-01-18','2024-01-19','y','i','b','l','d','q','a','z'),
+
(145,-10,-4,9,6,null,1063197137839502471,6789287364811254763,2999056594023717173,'2023-12-15','2023-12-16','2027-01-09','2026-01-18','l','s','e','u','k','t','i','c'),
+
(146,-4,null,9,6,1174175580763355522,6451487696701039815,8749915704166793287,-6889714363690204814,'2025-06-18','2026-01-18','2025-02-18','2023-12-11','d','l','a','e','t','o','o','h'),
+
(147,0,0,2,7,null,2754818255120865492,798097121363636191,5600317566757932613,'2023-12-09','2027-01-09','2027-01-09','2024-01-19','o','w','y','e','l','t','h','b'),
+
(148,null,-4,1,4,5636862055771309412,-3497705340154107819,3667401486513577297,6011150604009607627,'2023-12-20','2023-12-14','2025-06-18','2023-12-19','y','u','m','d','m','b','p','k'),
+
(149,5,-10,2,-10,null,-2950882735050599937,7847714559028630649,4201975068094453643,'2023-12-20',null,'2023-12-16','2026-01-18','v','j','t','i','u','h','e','q'),
+
(150,1,-4,3,-4,-6287076248939275564,-947862405873888712,-1243932433054210590,1044080321945027921,'2026-02-18','2023-12-14','2024-02-18','2025-06-18','j',null,'x','w','n','p','v','p'),
+
(151,-10,0,5,7,-3044173387256889969,-5803258380558763516,1703274450984585284,1588386069242029591,'2026-02-18','2026-02-18','2024-01-17','2023-12-11',null,'v','e','q','o',null,'p','s'),
+
(152,-10,0,-4,6,7553774732262232437,1404490877015387722,3444629383444136689,87986376813159460,'2024-01-19','2027-01-09','2025-02-18','2023-12-10','d','b','l','r','u',null,'y','e'),
+
(153,-4,1,6,4,-7717895501491809691,-6366519603386418519,-1652144517267348508,6613800408292501893,'2027-01-16',null,'2023-12-12','2023-12-11','b','m','b','k','m',null,'z','d'),
+
(154,3,-4,1,9,null,null,-1789847673469739047,7884953486102558099,'2023-12-17','2023-12-10','2023-12-09','2023-12-19',null,'j','n','m','z','f','l','y'),
+
(155,-4,6,9,9,-8976962603287659887,6674492652157048443,-2257152036746091193,-346483294692792388,'2025-06-18','2025-02-18','2024-01-17','2023-12-19','n','e','u','s',null,'x','a','r'),
+
(156,null,-10,5,2,-2050721669014616848,null,2019753248619260783,-8569139418417363525,'2024-01-08','2026-01-18','2024-01-17','2024-01-09','y','d','x','d','j','n','o','h'),
+
(157,0,-10,2,-10,7567739376725572066,5616377650809946837,8573624867352119272,2262392814438727082,'2024-01-08','2024-01-31','2024-01-17','2023-12-19','f','n','f','r','n','q','m','n'),
+
(158,-4,9,-10,7,2319159625194776334,407250325989847802,-3588497774199811578,-547418380398391270,'2024-01-17','2024-01-31','2026-01-18','2023-12-19','s','x','u','j','i',null,'p','b'),
+
(159,-10,4,8,8,null,null,7705602450550432993,742041524790384390,'2024-01-31','2023-12-09','2023-12-09','2024-01-19','g','y','l','d','g','e','k','h'),
+
(160,0,2,2,8,null,8522131301326659073,-8865304049362191686,-7171064086258098677,'2023-12-18',null,'2024-01-19','2024-01-19','n','v','d','j',null,'w','f','l'),
+
(161,4,7,3,9,null,3541346781635634258,-8551746578812887781,-7337560889113694888,'2024-01-19','2027-01-09','2024-02-18','2023-12-14',null,'y','j','h','c','w','a','i'),
+
(162,7,6,9,8,7030148837172289305,8056410353843730036,-4855338156902986890,5319227784182380731,null,'2023-12-09','2027-01-09','2023-12-16','n','n','a','b','v',null,'t','b'),
+
(163,5,3,0,7,427334391358246771,8050112207649519443,-8783981195124085537,-2925264850368739780,'2024-01-31','2024-01-17','2023-12-14','2025-02-18',null,'w','f','g','b','j','g','o'),
+
(164,8,null,1,0,null,-5125932554164553193,-361428343629790836,1490877093813367596,'2024-02-18','2023-12-13','2024-02-18','2025-06-18','g','c','u','z','j','t','n','s'),
+
(165,6,-10,-10,4,401211505594870957,-2486045565429716565,3679366561172793116,-6544327233785336337,'2023-12-15','2023-12-10','2023-12-12','2024-02-18','n','u','u','l','b',null,'r','o'),
+
(166,2,2,7,6,null,null,-1232875368367813909,-2654235050917742705,null,'2026-01-18','2027-01-09','2023-12-18',null,'k','k','x','o','l','a','m'),
+
(167,-10,1,8,9,-8578602726444116604,4395344205255541535,-3700493525899938965,5581859827495744469,'2024-01-09','2024-01-19','2024-01-17','2025-06-18','s','f','k','y','n',null,'q','y'),
+
(168,8,7,-10,-10,-9099654191483240772,8746495951376111750,7413311732292904586,-3633262094199864671,'2025-02-18','2024-02-18','2024-02-18','2023-12-19','q','l','o','o','s','p','q','i'),
+
(169,4,-4,9,-4,-4018679014449613083,6067940199083356941,227509747112856702,-8878903158743492700,'2023-12-09','2024-01-17','2023-12-17','2024-02-18','a','e','q','c','d','l','u','i'),
+
(170,-10,1,-10,-10,-4347338175015239096,303152522920523964,-3366861472324546751,-1792053362852353550,'2023-12-14','2023-12-15','2023-12-18','2023-12-12',null,null,'d','j','v','t','t','x'),
+
(171,4,8,9,4,6125596596282667356,null,-3769307504282746471,4492543183509474594,'2023-12-19','2024-01-17','2023-12-13','2025-06-18','e','d','z','e','e',null,'v','e'),
+
(172,null,8,-10,-10,-5878699407241380005,3707545942848547534,8460371982479682208,-8268219849788841026,'2023-12-20',null,'2023-12-16','2023-12-20','m','k','h','d','f','z','x','p'),
+
(173,null,-10,-4,-10,null,null,-4337290235619243347,-4209340769710092424,'2023-12-20','2024-02-18','2024-01-19','2027-01-09','f',null,'o','l','i','s','y','u'),
+
(174,1,9,5,0,-2847215348701688440,-5478594453193527180,5027479249607597225,170359040141253660,'2023-12-15','2026-01-18','2024-01-09','2023-12-10','y',null,'u','j','r','n','b','l'),
+
(175,9,-10,-10,-4,-4965439207449911104,-8458924371575507301,2633043105526646613,5667795406959092719,'2027-01-16','2023-12-18','2023-12-14','2024-01-09','g','l','v','v','p','r','c','n'),
+
(176,3,3,2,-10,null,-8375557814965113270,6578183021595461371,-2562712282389245947,'2023-12-14','2025-02-18','2027-01-16','2023-12-20','m','t','s','r',null,'v','c','a'),
+
(177,-4,7,2,1,4395058196255561498,-7229470944605757362,937960490371387357,596062613781144577,'2024-01-09','2023-12-12','2024-01-17','2023-12-09','x',null,'k','s','g','t','v','b'),
+
(178,-10,6,-10,-4,-5343127241116805555,3214329783351046811,-2942702620220385757,4629202499911938133,'2024-01-09','2025-06-18','2027-01-09','2025-02-17','k',null,'x','k','s',null,'y','d'),
+
(179,8,2,-10,7,1306794644034360185,8104508283348401656,-7781611788119325374,-1559047723439747245,'2026-02-18','2023-12-15','2023-12-16','2023-12-14','c','h','r','h','k','r','m','r'),
+
(180,8,null,-10,9,-6845889033670399965,-4012385316602501804,-4338537233243482341,1876438682638258549,'2026-01-18','2024-01-09','2024-02-18','2026-01-18','x','t','x','j','p','f','g','t'),
+
(181,-4,1,-10,8,null,null,1262464141766850708,-3799131303622379390,'2024-01-17','2023-12-16','2025-06-18','2025-02-18','d',null,'j','o','s','x','k','x'),
+
(182,-4,7,8,6,7946259648386972860,-7710561382439523341,-5136919082500090741,3470998110053417757,'2024-02-18','2023-12-20','2023-12-17','2023-12-14','x','n','g','h','e','r','t','l'),
+
(183,-4,-10,-10,0,1509548002977119549,null,-432062717774302450,-3151043498777017301,'2024-01-19','2024-01-09','2023-12-17','2023-12-18',null,'l','b','f','i','l','h','c'),
+
(184,null,-10,6,5,2119924088069447144,-1255768152811558172,1012819011919698613,-3496912237284611876,'2023-12-20',null,'2024-01-19','2023-12-15',null,'u','w','q','n',null,'p','a'),
+
(185,8,8,8,-10,4676274730336956938,5136751053010961301,8300622693683205319,-1361583777210343375,'2026-01-18','2023-12-16','2024-02-18','2023-12-12','o','c','s','h','d','h','l','c'),
+
(186,3,7,-4,6,null,5041489075802116054,-6588426236193545740,8423676058141919964,'2023-12-13','2023-12-19','2023-12-18','2024-01-09',null,'c','r','z','z','i','y','a'),
+
(187,-4,null,4,6,null,964974380252695233,-4015675944313432053,-4973580781314544714,'2024-02-18',null,'2023-12-13','2023-12-19','j','a','i','d','w','r','h','s'),
+
(188,7,-10,8,-10,-7650070701520749042,-1556549730628237978,-7841366573812989369,2058539311970243887,'2025-02-17','2025-06-18','2023-12-19','2023-12-14','k','l','e','p',null,'a','p','g'),
+
(189,6,null,4,8,null,3679128814704027170,-8277380801474691009,-3170290534566200063,'2024-01-08','2024-01-31','2023-12-10','2027-01-09',null,'f','k','b','g',null,'h','e'),
+
(190,-10,-4,-10,1,-4219948539138905579,-5244245245890492072,-6785158847867478694,-7248193910059028370,'2023-12-18','2026-01-18','2025-06-18','2023-12-17','l','a','j','a','i','h','h','f'),
+
(191,6,-10,-4,8,3175896213233378185,8743318336990811501,-5546142116733032449,-9097610172970560923,'2024-02-18','2026-02-18','2023-12-09','2023-12-10','v','i','h','j','r',null,'v','g'),
+
(192,-10,9,8,-4,4335715539682699734,5465033577746370018,4473180193110960481,8659491888045138847,'2023-12-09','2023-12-16','2027-01-16','2027-01-09',null,'h','e','l','n',null,'w','x'),
+
(193,-10,-4,6,6,-7375321279050850063,null,8845182676995525750,-4850465566991597349,'2024-02-18','2024-01-31','2023-12-14','2023-12-18','s',null,'o','j','s','g','l','v'),
+
(194,-4,-10,8,-10,-4761575559261734188,-7042329325798196061,1260959184865930991,-4767044596743930518,'2024-01-17','2026-01-18','2025-06-18','2023-12-14','i','t','l','m','n',null,'z','n'),
+
(195,null,4,9,-10,null,null,2891549689244551808,-5230886631619520164,'2025-06-18','2027-01-16','2023-12-12','2023-12-19',null,'r','j','q','t','r','s','g'),
+
(196,9,8,-10,-10,2187809305762373805,null,-2850062827064335926,2430195282731050215,'2024-01-08','2025-06-18','2023-12-18','2026-02-18','y','g','j','v','u','e','b','u'),
+
(197,null,3,0,-4,-8286099209958254886,7748929527795363370,-6521295200647841804,789640259676833298,'2027-01-16','2025-02-18','2027-01-09','2023-12-18',null,'f','t','m','a','d','i','p'),
+
(198,0,6,9,1,2906540190944252981,1491936597198579837,-424302572113584860,740930406390435907,'2025-06-18','2025-06-18','2024-01-08','2024-02-18','a','x','z','g','y','l','m','v'),
+
(199,1,-10,7,-10,6437035907235877917,-2720500768116271006,-1635391493087085931,5523231887763834144,'2023-12-12','2024-01-31','2023-12-13','2023-12-17','z','p','k','i','o','r','k','m');
+ """
+ qt_select_no_need_2 """
+ SELECT
+ AVG(DISTINCT
table1.`col_int_undef_signed_not_null_index_inverted`) AS field1
+ FROM
+ ${table5} AS table1
+ WHERE
+ NOT (
+ (
+ (
+
(table1.col_int_undef_signed_not_null_index_inverted >= 9)
+ OR
table1.col_varchar_10__undef_signed_not_null_index_inverted <>
table1.col_varchar_1024__undef_signed_not_null_index_inverted
+ )
+ OR table1.col_varchar_10__undef_signed_index_inverted
> 'good'
+ )
+ OR table1.`col_int_undef_signed_not_null_index_inverted`
BETWEEN NULL AND (7 + 9)
+ AND table1.`col_date_undef_signed_not_null_index_inverted`
BETWEEN '2023-12-16' AND DATE_ADD(table1.`col_date_undef_signed_not_null`,
INTERVAL 7 DAY)
+ )
+ LIMIT 10000;
+ """
+
+ def table6 = "test_index_no_need_read_data6"
+ sql "drop table if exists ${table6}"
+ sql """
+ create table ${table6} (
+ col_date_undef_signed_not_null_index_inverted date not null ,
+ col_bigint_undef_signed_not_null_index_inverted bigint not null ,
+ col_bigint_undef_signed_not_null bigint not null ,
+ col_int_undef_signed int null ,
+ col_int_undef_signed_index_inverted int null ,
+ col_int_undef_signed_not_null int not null ,
+ col_int_undef_signed_not_null_index_inverted int not null ,
+ col_bigint_undef_signed bigint null ,
+ col_bigint_undef_signed_index_inverted bigint null ,
+ col_date_undef_signed date null ,
+ col_date_undef_signed_index_inverted date null ,
+ col_date_undef_signed_not_null date not null ,
+ col_varchar_10__undef_signed varchar(10) null ,
+ col_varchar_10__undef_signed_index_inverted varchar(10) null ,
+ col_varchar_10__undef_signed_not_null varchar(10) not null ,
+ col_varchar_10__undef_signed_not_null_index_inverted varchar(10) not null
,
+ col_varchar_1024__undef_signed varchar(1024) null ,
+ col_varchar_1024__undef_signed_index_inverted varchar(1024) null ,
+ col_varchar_1024__undef_signed_not_null varchar(1024) not null ,
+ col_varchar_1024__undef_signed_not_null_index_inverted varchar(1024) not
null ,
+ pk int,
+ INDEX col_int_undef_signed_index_inverted_idx
(`col_int_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_int_undef_signed_not_null_index_inverted_idx
(`col_int_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_bigint_undef_signed_index_inverted_idx
(`col_bigint_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_bigint_undef_signed_not_null_index_inverted_idx
(`col_bigint_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_date_undef_signed_index_inverted_idx
(`col_date_undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_date_undef_signed_not_null_index_inverted_idx
(`col_date_undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_varchar_10__undef_signed_index_inverted_idx
(`col_varchar_10__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_varchar_10__undef_signed_not_null_index_inverted_idx
(`col_varchar_10__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_varchar_1024__undef_signed_index_inverted_idx
(`col_varchar_1024__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_varchar_1024__undef_signed_not_null_index_inverted_idx
(`col_varchar_1024__undef_signed_not_null_index_inverted`) USING INVERTED
+ ) engine=olap
+ UNIQUE KEY(col_date_undef_signed_not_null_index_inverted,
col_bigint_undef_signed_not_null_index_inverted,
col_bigint_undef_signed_not_null)
+ distributed by hash(col_bigint_undef_signed_not_null) buckets 1
+ properties("enable_unique_key_merge_on_write" = "true", "replication_num"
= "1");
+ """
+ sql """
+ INSERT INTO ${table6}(
+ pk,
+ col_int_undef_signed,
+ col_int_undef_signed_index_inverted,
+ col_int_undef_signed_not_null,
+ col_int_undef_signed_not_null_index_inverted,
+ col_bigint_undef_signed,
+ col_bigint_undef_signed_index_inverted,
+ col_bigint_undef_signed_not_null,
+ col_bigint_undef_signed_not_null_index_inverted,
+ col_date_undef_signed,
+ col_date_undef_signed_index_inverted,
+ col_date_undef_signed_not_null,
+ col_date_undef_signed_not_null_index_inverted,
+ col_varchar_10__undef_signed,
+ col_varchar_10__undef_signed_index_inverted,
+ col_varchar_10__undef_signed_not_null,
+ col_varchar_10__undef_signed_not_null_index_inverted,
+ col_varchar_1024__undef_signed,
+ col_varchar_1024__undef_signed_index_inverted,
+ col_varchar_1024__undef_signed_not_null,
+ col_varchar_1024__undef_signed_not_null_index_inverted)
+ VALUES
+
(0,2,null,2,5,null,6047071702080355644,1743773009061720927,3968365840610113182,null,'2023-12-10','2023-12-18','2023-12-10','m','e','l','w','s','f','c','x'),
+
(1,5,null,8,-4,6093818696587887333,9084553190249453965,-4779202639200620381,-5215587017466273548,'2026-02-18','2024-01-08','2027-01-09','2024-02-18','i',null,'f','b','w','o','w','t'),
+
(2,-4,5,8,3,null,-5680478258766518915,6193120162169252722,859865224420839805,'2024-01-09','2025-02-17','2025-06-18','2027-01-16',null,'m','r','f','d','l','p','o'),
+
(3,0,null,-4,1,null,994798108522699043,-7031415486628048126,5990000782425933563,'2027-01-09','2025-02-18','2023-12-17','2027-01-16','k','k','h','p','f',null,'y','p'),
+
(4,8,9,-4,4,5319335073963350191,-4375219010963025933,-3008307869272473435,7920842530090123102,'2023-12-15','2024-02-18','2026-02-18','2023-12-18','o','c','e','u','o','f','f','o'),
+
(5,-10,4,-10,3,6905383895504497995,4714785027515578912,7253753864062943115,7704919728637448242,'2023-12-10','2023-12-17','2023-12-11','2023-12-14','q','v','x','a','w','v','h','d'),
+
(6,8,3,9,6,3537191251092326115,-7561146461075150845,9134495110669406461,-5763667657169835232,'2024-02-18','2025-02-18','2024-01-08','2023-12-09','d','o','w','p','z','j','w','s'),
+
(7,6,0,6,0,3153592367577200883,2371697304713448324,-6286827003601310266,1341411796447444067,'2024-01-09','2024-01-09','2024-01-17','2023-12-13','m','t','b','r','n',null,'k','r'),
+
(8,0,2,0,7,-2468425315177796710,null,4842126111665415103,951334858022112250,'2023-12-10',null,'2027-01-09','2024-02-18','n','g','w','n','e','s','e','v'),
+
(9,0,8,1,6,4939444585074163694,-9153663403976431389,-353942154540925304,-7032306882339768290,'2023-12-14','2023-12-12','2024-02-18','2023-12-18','x','p','s','d','w','k','x','v'),
+
(10,3,4,-10,6,null,null,-4215952697964699827,-1719431863470678908,'2023-12-19',null,'2023-12-12','2023-12-20','z','b','f','q','j',null,'j','c'),
+
(11,5,-4,-4,0,null,6548821515603388818,-6175147937517306851,-4094004617028236529,'2024-02-18','2025-02-18','2024-01-19','2027-01-09','u','z','p','f','m','j','i','z'),
+
(12,-4,6,-10,3,2203471486366176024,-5277090899702382016,3417149535731923169,6441001575802340806,null,null,'2024-01-17','2023-12-20','u','h','d','v','p',null,'a','r'),
+
(13,5,9,4,2,-1992377771700148483,-559291350287121968,-3005977928697009690,-7531456678359909168,'2023-12-16','2024-02-18','2023-12-15','2023-12-15','y','u','z','p','c','k','i','p'),
+
(14,-4,7,0,8,590261254598495131,-1908674911887416554,584395141912150539,5072698314763590994,'2023-12-19','2023-12-12','2023-12-11','2027-01-09',null,'o','y','u','q','t','i','x'),
+
(15,3,8,4,-10,-7579431748710361647,-8155162620998389425,2874208940129807662,-5742742834942932894,'2023-12-18','2024-01-09','2024-01-17','2025-02-17','r','b','t','z','t','h','h','p'),
+
(16,4,-10,1,1,7461938820230421863,null,-9200561829194173663,-3146640760841215298,'2025-06-18','2024-01-31','2024-01-09','2024-02-18','g','n','c','y',null,'q','p','e'),
+
(17,6,-10,6,5,null,8625368487501035525,-7286860434583964446,5646630444354261975,'2023-12-17','2023-12-17','2023-12-10','2023-12-18','d','v','j','f',null,'c','g','b'),
+
(18,null,null,0,6,3357164691434157854,-5053592862467599824,-299605368484252016,-7301242560619705429,'2025-02-18','2023-12-17','2024-01-08','2023-12-09','x',null,'x','h','l',null,'k','l'),
+
(19,7,5,7,7,281475235579931926,6513642546811305927,5267044139266533684,3650267105063752728,null,'2023-12-13','2024-02-18','2027-01-16',null,'k','d','t','y','t','l','l'),
+
(20,3,-4,-4,-4,-5540560095623011609,null,53948240632423741,-8352232891511580467,'2023-12-09',null,'2024-01-08','2023-12-09','u','r','a','q','u','k','h','u'),
+
(21,6,2,-4,5,null,null,4321355771692382265,4567758090701714014,'2023-12-19','2023-12-18','2023-12-10','2024-01-08',null,'r','d','g','a',null,'a','l'),
+
(22,1,-10,3,9,-2036645409027616747,-903109984248808064,-6201579286490831689,3565899407818468374,'2026-02-18',null,'2023-12-12','2023-12-10',null,'b','a','v','c','z','b','f'),
+
(23,null,-4,-10,1,3310206209156138586,-4155137914128855235,-3514691054541487722,2915994975133352939,'2023-12-12','2024-01-19','2023-12-09','2026-02-18','o','l','j','v','t','f','y','i'),
+
(24,9,null,4,4,6551121666871685812,null,-8016546789408062643,6119825356242292412,'2024-01-09','2025-06-18','2023-12-13','2025-02-18','f',null,'q','z','z',null,'m','w'),
+
(25,4,2,0,0,-520048936955506758,7670879000600913113,-2040077939644368040,1197843741238154598,'2023-12-09','2023-12-15','2025-06-18','2026-01-18','r','v','c','g','h','u','f','m'),
+
(26,null,-10,4,-4,null,419678391523752890,-7435874721585714233,8898634654295427266,'2026-01-18',null,'2023-12-18','2023-12-18','s','t','e','p','q',null,'p','g'),
+
(27,9,-4,3,-10,null,-3974342907695018910,443191779926461130,8233084506172994654,'2024-01-09','2023-12-17','2026-02-18','2024-02-18','t','t','g','a','h','m','v','c'),
+
(28,null,7,8,9,null,6152093303748835632,-4562412588627987392,-934172863387418493,'2023-12-17','2024-01-31','2023-12-20','2024-01-17',null,'w','w','k',null,null,'z','p'),
+
(29,4,8,8,0,null,null,-2824034215088311828,-180188196226406973,'2023-12-11','2024-01-09','2024-01-31','2023-12-17',null,'u','g','l','g','e','z','z'),
+
(30,null,null,-4,-4,7235852278026844130,-9047156586257680967,5923497116520700436,-938448741948749056,'2023-12-19','2025-06-18','2026-01-18','2024-01-09','r',null,'m','i','r','i','v','q'),
+
(31,7,5,-4,9,-5135616285903777613,null,-5136431726765172914,-134704751314553959,null,'2024-01-19','2024-01-08','2023-12-09','e',null,'w','d','n',null,'t','d'),
+
(32,3,-4,2,4,-117991869282553866,null,-7684403676477748961,4934216177675456310,'2024-01-08',null,'2027-01-09','2023-12-10','n','p','k','f','q',null,'c','s'),
+
(33,8,9,4,-4,4678985764823073465,-4473441684795462099,2483205526020008396,4231901676928655206,'2023-12-15',null,'2023-12-16','2026-02-18','z','w','d','a','d','j','q','q'),
+
(34,9,8,2,8,-4584748361800749967,4202823116769139963,145368720959794659,2251003368255192412,null,'2025-06-18','2023-12-09','2027-01-09','d','o','t','g','y','e','a','x'),
+
(35,5,-4,-10,-4,-906548241884551302,8645460519643931914,6481522417337591957,6261673488873372831,'2024-01-08','2023-12-13','2023-12-14','2023-12-15','p','f','i','p',null,null,'s','n'),
+
(36,5,null,8,-4,null,null,4314003773436158626,7579142261463225081,'2024-01-09','2023-12-13','2023-12-15','2023-12-14','c','t','t','e','u','x','r','f'),
+
(37,-10,6,9,2,-6620185973552334642,null,-3046015722118082480,-3095068909681245822,'2026-02-18','2027-01-09','2023-12-10','2027-01-16','j','j','j','m','j','i','m','z'),
+
(38,-10,8,6,-10,-2515256036168029290,null,8269780684849815478,-8650591097852000982,'2025-06-18',null,'2023-12-18','2024-02-18','m','y','l','j','p','y','s','h'),
+
(39,0,-10,-10,0,null,-5522213112273370561,-1316816252214516585,-1567577471748513560,'2023-12-16','2023-12-11','2023-12-09','2024-02-18','a','t','c','d','n','d','a','q'),
+
(40,7,-10,-10,3,-5084805805235703626,-1233811050241785632,8217977506968477373,-6963502005382243135,'2023-12-10','2025-06-18','2026-02-18','2024-02-18','v','d','n','u','x','s','x','n'),
+
(41,null,null,-10,7,null,null,5799307291119757557,2215391798483197604,'2025-02-18','2026-02-18','2024-01-08','2023-12-18',null,'e','g','l',null,'g','v','w'),
+
(42,3,null,3,4,null,-4599200440035458276,-5232722834984859778,-3875787409217377000,'2024-01-19','2023-12-10','2025-02-17','2024-01-17','c','z','r','p','l','p','r','j'),
+
(43,3,0,8,1,null,9039465042666792521,8653474097534804813,-3815270519775100915,'2023-12-09','2023-12-10','2026-01-18','2023-12-14','n','y','o','w','x','c','n','u'),
+
(44,5,-10,-10,2,null,-1196385874478092971,3634991072249040858,9109232382765106898,'2023-12-17','2026-02-18','2025-06-18','2023-12-12','h','e','b','l','c','x','s','a'),
+
(45,1,2,1,-10,3496175437205301884,-750688512374970345,-5989758804641551640,-2702732245503451716,'2024-01-17',null,'2025-06-18','2023-12-13','g','l','g','o','j','c','r','b'),
+
(46,4,1,3,-10,-4730011562372937560,-4016339630147734399,5168369054194323923,8388817823560738292,'2023-12-18',null,'2027-01-16','2023-12-11','v','o','b','s','a','r','h','r'),
+
(47,null,null,3,-4,null,-8740603053341502757,-5732373097375670728,-4814649296407464281,'2023-12-09','2025-02-17','2024-01-19','2025-02-18',null,'b','m','r','t','d','k','r'),
+
(48,-10,1,4,5,244387110332320233,4552672675815310682,2693886189414111015,5304928960690310043,'2025-06-18','2023-12-10','2023-12-12','2024-01-17','r','j','z','f',null,'v','h','j'),
+
(49,1,9,-4,6,1253182385525141650,2164820345365000550,758006141978389707,2057826544478381809,'2024-02-18','2025-06-18','2023-12-16','2026-02-18','l','o','q','d','u','q','c','z');
+ """
+ qt_select_no_need_3 """
+ SELECT
+ table1.col_date_undef_signed_not_null AS field1,
+ table1.col_bigint_undef_signed_index_inverted AS field2,
+ table1.col_date_undef_signed AS field3
+ FROM
+ ${table6} AS table1
+ WHERE
+ NOT (
+ NOT (
+
(table1.col_varchar_10__undef_signed_index_inverted >
table1.col_varchar_1024__undef_signed_not_null_index_inverted)
+ AND table1.col_varchar_10__undef_signed_index_inverted
!= 'k'
+ )
+ AND table1.`col_int_undef_signed_not_null` != (3 + 0.3)
+ )
+ GROUP BY
+ field1, field2, field3
+ ORDER BY
+ field1, field2, field3
+ LIMIT 10000;
+"""
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
