This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch branch-4.0-preview
in repository https://gitbox.apache.org/repos/asf/doris.git
commit df138e74e7112a2a8e0a10ff9205df2ffe6dbec9
Author: airborne12 <airborn...@gmail.com>
AuthorDate: Thu Apr 11 15:45:01 2024 +0800
[Fix](inverted index) fix fast execute problem when need read data opt
enabled (#33526)
---
be/src/vec/exprs/vectorized_fn_call.cpp | 7 +-
.../test_index_no_need_read_data.out | 9 +
.../test_index_no_need_read_data.groovy | 274 +++++++++++++++++++++
3 files changed, 286 insertions(+), 4 deletions(-)
diff --git a/be/src/vec/exprs/vectorized_fn_call.cpp
b/be/src/vec/exprs/vectorized_fn_call.cpp
index d039a4e3a32..1c08b721cf9 100644
--- a/be/src/vec/exprs/vectorized_fn_call.cpp
+++ b/be/src/vec/exprs/vectorized_fn_call.cpp
@@ -158,10 +158,9 @@ Status
VectorizedFnCall::_do_execute(doris::vectorized::VExprContext* context,
// prepare a column to save result
block->insert({nullptr, _data_type, _expr_name});
if (_can_fast_execute) {
- // if not find fast execute result column, means do not need check
fast execute again
- _can_fast_execute =
fast_execute(context->fn_context(_fn_context_index), *block, args,
- num_columns_without_result,
block->rows());
- if (_can_fast_execute) {
+ auto can_fast_execute =
fast_execute(context->fn_context(_fn_context_index), *block, args,
+ num_columns_without_result,
block->rows());
+ if (can_fast_execute) {
*result_column_id = num_columns_without_result;
return Status::OK();
}
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 01a08f324d7..9b64c110139 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
@@ -127,3 +127,12 @@ qie \N TENGXUN2
\N
500
+-- !select_no_need_0 --
+d -5 r
+d 1 w
+d 8 f
+g 6 q
+j 2 k
+k 2 j
+u 8 d
+
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 e5bc37e2fd2..31016df9814 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
@@ -85,4 +85,278 @@ suite("test_index_no_need_read_data",
"inverted_index_select"){
qt_select_10 "SELECT addr, name FROM ( SELECT * from ${table1} WHERE city
!= 'beijing' ORDER BY id) t"
qt_select_11 "SELECT addr, name, upper(city) FROM ( SELECT * from
${table1} WHERE city != 'beijing' ORDER BY id) t"
qt_select_12 "SELECT sum(n) FROM ${table1} WHERE city = 'beijing' group by
id ORDER BY id"
+
+ def table2 = "test_index_no_need_read_data2"
+
+ sql "drop table if exists ${table2}"
+
+ sql """
+ create table ${table2} (
+ col_date_undef_signed_not_null date not null ,
+ col_bigint_undef_signed_not_null_index_inverted 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_bigint_undef_signed_not_null bigint not null ,
+ col_date_undef_signed date null ,
+ col_date_undef_signed_index_inverted date 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_date_undef_signed_not_null,
col_bigint_undef_signed_not_null_index_inverted)
+ PARTITION BY RANGE(col_date_undef_signed_not_null) (
+ FROM ('2023-01-01') TO ('2035-01-01') INTERVAL 1 YEAR
+ )
+
+ distributed by hash(col_bigint_undef_signed_not_null_index_inverted)
buckets 100
+ properties("enable_unique_key_merge_on_write" = "true",
"replication_num" = "1");
+ """
+
+ sql """INSERT INTO ${table2}(
+ 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,-10,3,4,7,5580109438872025323,3872694526474684631,385420850865925584,-3940821135776863465,'2027-01-16','2025-06-18','2024-01-19','2024-01-17','v','a','r','p','j','i','k','v'),
+
(1,1,6,-4,0,-1493194171885821015,7387138194313888736,3765212635902277035,7113302526071831680,'2023-12-18','2023-12-14','2023-12-12','2024-01-31','f','p','k','i','w',null,'x','n'),
+
(2,6,3,4,7,3563852437963852520,8385106866914432959,4566306316897671779,6364576578692437612,'2023-12-13','2024-02-18','2023-12-13','2023-12-14','o','y','u','f','j','y','r','g'),
+
(3,1,0,-4,2,-2254950510857437520,2491560902833588034,8217842243064941717,-921017394636829524,'2023-12-17','2023-12-10','2027-01-09','2023-12-14','m','q','x','t','y',null,'j','m'),
+
(4,3,-10,4,-10,null,7628199607952032608,3197258099718089201,5763243269817274185,'2023-12-19','2024-02-18','2023-12-15','2024-01-17','d','a','a','d','n','i','r','k'),
+
(5,8,0,-10,8,null,3581621927069206106,-9067180315701355776,-8841115213335077773,'2023-12-18','2023-12-19','2024-02-18','2023-12-11','u','l','n','i',null,'u','k','o'),
+
(6,9,-10,-10,4,1923093018429459351,-5433098053895211168,-8967523672716182495,-4056723171560692598,'2023-12-18',null,'2023-12-17','2026-02-18','x','e','q','w','p',null,'f','m'),
+
(7,7,4,6,0,-7445550386419643592,null,1648172906321291693,2621186248433016087,'2024-01-17','2024-01-19','2023-12-16','2025-02-18','k','r','a','m','d','n','t','a'),
+
(8,-4,1,-4,7,1796634544229381107,-593463340620785966,5787209728812745054,-5485486542440665708,'2025-02-17','2027-01-16','2025-06-18','2024-02-18','l','q','h','o','t','u','a','m'),
+
(9,9,1,3,9,null,4937075267478298592,-2273828918034758405,-8206180445681276242,'2025-02-18','2026-02-18','2024-01-17','2024-01-08','m',null,'q','a','q','d','c','w'),
+
(10,6,8,8,-4,1207767175600440022,8847766271086933954,2323398854618204264,-493059712089143372,'2024-01-19','2023-12-18','2025-06-18','2024-01-08',null,null,'e','q','o','w','l','q'),
+
(11,5,-4,7,7,-3469957288755596137,-2641830827441697431,-8760427991816018685,679645147777243519,'2023-12-14','2024-02-18','2024-01-19','2023-12-09','p','u','t','n','r',null,'j','q'),
+
(12,0,1,-4,-4,-7894918345848500465,8680458589049247459,-8377225567607577955,6792164504588279227,'2023-12-09','2024-01-19','2026-02-18','2023-12-09','i','g','g','t','l','l','v','x'),
+
(13,1,4,-10,2,4114705031219212601,null,-6177506599019385457,5138406382915390307,'2024-02-18','2025-06-18','2023-12-10','2024-01-09','t',null,'d','w','j','b','v','u'),
+
(14,-4,-10,4,3,5975268122701547514,150994224860372313,-1146720549575812907,-7009122126858912431,'2023-12-18','2024-02-18','2023-12-11','2023-12-13','l','w','v','f',null,'q','p','s'),
+
(15,1,1,-10,8,-3626135723208192188,519621184823112729,-7573705488022410893,494753102026856399,'2023-12-12','2024-01-09','2026-02-18','2023-12-14','d','l','o','h','u','j','j','s'),
+
(16,-10,-10,1,2,null,null,-8398718839920683470,6038460101621662244,'2023-12-14','2027-01-09','2023-12-14','2027-01-16','p','d','v','i','o','z','z','o'),
+
(17,9,1,4,-4,3413009869227781893,null,865249880237668165,2770415779455383989,'2023-12-15','2023-12-16','2023-12-16','2024-02-18','v','q','y','q','j','c','a','r'),
+
(18,3,6,9,-10,8749385070419959986,-6987739797721157518,-134542821823440506,-746949899172342144,'2023-12-18','2026-01-18','2024-01-31','2024-01-17',null,'f','l','n','p','d','w','r'),
+
(19,0,2,1,-10,-7413963880191969679,-7232501961520107253,-925106718320609612,3238785916731870616,'2024-02-18','2023-12-09','2024-02-18','2024-01-17','n',null,'r','r',null,'g','l','a'),
+
(20,7,6,8,4,8651297646150639662,6018819133916644480,-136832000802503168,6608563689940337220,'2024-01-19','2024-01-09','2025-02-18','2024-02-18',null,'j','e','z','l','j','j','c'),
+
(21,null,7,7,8,null,7850807104570290010,-2940201119327577321,-7782825355908730753,'2027-01-16','2023-12-12','2023-12-11','2023-12-09','r','v','h','l','t','c','s','y'),
+
(22,0,3,8,-10,6483641277594834061,5272032945780194227,6721070633124742038,4480541256023769627,'2025-02-18','2025-02-17','2023-12-15','2025-06-18',null,'n','a','c','m','r','n','w'),
+
(23,5,-4,9,3,1189711079190301419,-508728666249457767,-4796650213367800041,-2614767289707832609,null,'2023-12-17','2024-02-18','2024-02-18','j','p','n','u',null,'p','j','d'),
+
(24,5,7,-4,9,708950585774598434,null,802903261902903991,5034268205269069810,'2023-12-10',null,'2025-06-18','2023-12-16','w',null,'i','g','q',null,'u','a'),
+
(25,1,0,2,4,null,-8816502366270413322,-6246915445331697640,-22303848810465001,'2023-12-16','2023-12-11','2023-12-10','2024-02-18','b','t','p','t','w','a','t','j'),
+
(26,null,0,8,5,5041704642941241381,-1040920583948735873,-3050904107661227848,3818438036241519364,'2023-12-15','2024-02-18','2023-12-18','2023-12-11','j',null,'b','w','g',null,'n','l'),
+
(27,-4,5,5,0,-7110334501024778905,6139458997057859246,1952439230666743535,-1780860814160845957,'2023-12-18','2023-12-19','2024-02-18','2024-02-18','i','q','q','i','k','e','b','r'),
+
(28,-10,1,1,-4,-1177929373235978167,1523584050471804610,1741710960961868858,2138613709760771252,'2023-12-15','2024-01-17','2023-12-19','2024-01-09','j','r','y','k','h','s','r','v'),
+
(29,2,5,9,5,2151683970592511232,null,-9079195712293984833,-832946634936224763,'2024-01-31','2023-12-14','2024-01-31','2025-06-18','v','o','b','c','v','o','a','h'),
+
(30,6,-4,3,-4,-5674973890990533864,-7930103893991073675,-8695393871765917570,8423605879288969451,'2026-01-18','2023-12-18','2026-01-18','2023-12-16','j',null,'k','f','n','c','h','m'),
+
(31,-10,null,7,-4,-8613191708658642580,4643025050848756677,-2938926314298340928,-3268125550911659026,'2027-01-09','2023-12-13','2024-01-31','2027-01-16','o','u','v','y','s','e','k','d'),
+
(32,4,1,6,-10,-3780476841982360554,-1465800917874352047,-8040569538841136543,-2850720971377524729,'2023-12-17','2025-02-17','2023-12-17','2025-06-18','g','s','l','k','q','o','v','y'),
+
(33,null,null,4,6,-7859842309046606373,6339293308146092664,1353722378411931780,-4351109131638306369,'2023-12-13','2027-01-16','2023-12-17','2023-12-10','i','v','r','p','p','p','s','m'),
+
(34,null,6,5,-10,775460194850212355,-857318101479980273,5707726219311668064,-8156298623103687698,'2025-06-18','2024-01-17','2024-02-18','2023-12-19','v','k','b','y','u','j','m','d'),
+
(35,4,2,3,8,null,7869433062326420427,8577575012653028053,-2427932731456201896,null,'2025-02-17','2023-12-15','2023-12-13','n','w','g','x','n',null,'t','v'),
+
(36,1,5,3,-4,-4052850329707382806,null,3543852552281280328,144459604708779398,null,'2023-12-17','2023-12-18','2023-12-15','u','u','v','w',null,'c','r','h'),
+
(37,2,-4,-10,-4,3308439093289595569,-4576595019875335985,-5027502052563641731,-1153136184101431003,'2025-06-18','2023-12-14','2023-12-14','2024-01-17','l','r','y','g','q','u','p','s'),
+
(38,5,5,5,7,7739062077873814633,-4392780353883175471,7718546622414071889,4784376271820034871,'2023-12-11',null,'2023-12-17','2024-01-08','c','m','v','r',null,'y','o','c'),
+
(39,2,null,4,-10,null,null,-7091181624443389952,-1523182598015545283,'2023-12-19','2024-01-09','2023-12-17','2023-12-10',null,null,'g','y','l','r','b','s'),
+
(40,null,null,8,8,-3850458026233780339,null,-2224370480099152990,986150044629816420,null,'2023-12-09','2024-01-08','2024-02-18',null,'f','l','h',null,'h','u','t'),
+
(41,4,0,-10,2,-8548018030627515877,-526825220301930369,-6837214598909243203,-71495819606874989,'2024-01-17','2023-12-10','2023-12-20','2024-02-18','p','b','g','l','e','p','e','d'),
+
(42,6,null,9,7,5247818117274871825,7662842062297160632,4736712239946555003,-8777028431175216502,'2024-01-17','2023-12-17','2026-01-18','2023-12-16','b','f','l','v','b','x','t','j'),
+
(43,0,4,1,-4,-7323463697237377652,8359987866596815795,-7696667293877334704,7282058073097594290,'2025-06-18',null,'2023-12-12','2024-01-31',null,'u','f','g','z','e','y','u'),
+
(44,-10,0,-10,0,-8774736825980139716,-9087949559314091146,8169500708930581350,-6260433878840298875,'2024-01-08','2026-01-18','2023-12-19','2023-12-15','k','f','c','m','e','g','t','z'),
+
(45,null,-10,3,0,null,null,-5113884651055394008,8725402168887851060,'2023-12-13','2023-12-16','2023-12-14','2025-02-17','j',null,'l','t','t','o','b','g'),
+
(46,4,1,8,-10,null,-6531952254536753998,-2924421668465251732,-2194652303765193023,'2025-06-18','2025-02-17','2025-02-18','2026-01-18','q','b','i','z',null,'l','t','k'),
+
(47,8,-4,0,7,null,3432780964748477613,-7132177230817155428,1182857722110673405,'2023-12-10','2023-12-17','2023-12-19','2026-02-18',null,'f','n','r','u','j','r','m'),
+
(48,2,8,6,-10,3402707501095389317,1751756224480974842,6398935893076763254,-6870988324470664552,'2027-01-16','2026-02-18','2023-12-19','2024-01-19','i','w','n','m','q','g','a','q'),
+
(49,-4,6,8,0,5486551107215099612,null,-7473782296902431420,-5989367996030108585,'2026-01-18','2024-01-09','2023-12-18','2024-02-18','a',null,'u','w','u',null,'n','u'),
+
(50,1,-10,8,1,null,9044941427856703516,5718792231868237169,1904082734065935159,'2023-12-16','2025-06-18','2026-02-18','2023-12-11','z','m','h','p',null,'j','b','h'),
+
(51,-4,2,2,0,null,-1652297780041170740,9092511863605571992,3093074109783760178,'2023-12-14','2023-12-18','2024-01-08','2024-02-18','c',null,'p','a','m','o','h','f'),
+
(52,-10,1,-4,2,null,-52118520912539584,-2467154476596439436,-1591502250087705128,'2027-01-16','2027-01-16','2027-01-09','2027-01-16','s','m','q','c','b','d','r','c'),
+
(53,7,7,-10,8,-6050148469337645927,-6422535335041660441,5264504826379740805,-1085407954320820018,'2023-12-17',null,'2023-12-10','2024-02-18',null,'x','i','u','b','u','r','h'),
+
(54,5,8,-4,-10,7459039506829897451,6705880834090083493,-3670400590756658462,-4273060761760940983,'2027-01-16','2024-02-18','2024-01-17','2023-12-14','j','b','n','c','i','z','s','t'),
+
(55,-4,-4,2,-4,4855319502460373472,-3126360002573475203,-68729602730082495,3151378913823921708,'2023-12-14','2027-01-09','2024-02-18','2025-02-17','g','e','a','c','w','v','a','p'),
+
(56,0,null,3,9,5469091841836564344,-8913501729070845008,6788025520372211892,-1616745350959302522,'2023-12-09','2025-06-18','2024-02-18','2023-12-14','n','t','x','f','d','p','p','n'),
+
(57,4,null,-10,1,-1563000628155557629,-862763319942031476,-7432897080628302644,3414999754266286323,'2024-02-18',null,'2023-12-13','2024-01-08','n','z','l','y',null,'i','p','r'),
+
(58,1,-10,1,-10,705526106102345691,8224284170341160115,-8671548728855377707,8978322568246121698,'2023-12-13','2024-02-18','2025-02-17','2023-12-18','q',null,'f','e','e',null,'h','i'),
+
(59,1,5,8,4,-2904484111886589501,4401239845001785918,-6282784812051737836,-6239511645700996554,'2023-12-09','2023-12-09','2023-12-13','2024-02-18','o','v','d','x','e','c','r','q'),
+
(60,1,-10,-10,9,1248425082513772119,null,8859106197807815796,-4988233320410560113,'2025-02-17','2024-01-08','2025-02-17','2025-02-18','s','a','q','m','e','s','v','n'),
+
(61,1,7,3,6,-7483005358344115127,-1139236728514143791,1429496785723455224,-4306427359310612465,null,null,'2023-12-15','2025-02-17','x',null,'d','j','y','x','h','o'),
+
(62,5,8,7,1,-3104735154314378273,-8395798987915934069,-7982736207736198304,7011986936356258894,'2023-12-12','2024-02-18','2023-12-17','2025-06-18',null,'q','h','e','u','k','v','g'),
+
(63,null,-10,2,6,-4271504123822900473,566092902144643066,4749120337344719401,8163272629722250560,'2024-01-17','2023-12-18','2024-01-31','2023-12-17','d',null,'w','m',null,'v','y','b'),
+
(64,null,-10,5,-10,-4592552003439471292,-1451345462844358401,-2010580602144950162,-1134972326059249542,'2023-12-20','2024-01-08','2023-12-13','2023-12-09','b',null,'u','v','o','v','t','v'),
+
(65,6,9,-10,8,null,-6621292092609311401,4238756076966657595,-2473189958578814158,null,'2023-12-17','2023-12-14','2024-02-18','h','x','q','r','w',null,'z','m'),
+
(66,8,null,-4,3,-1129208833673349302,2107615842277768095,6264382583683275445,7431295579919957544,null,'2023-12-09','2026-01-18','2025-06-18','y','k','r','d',null,'p','i','o'),
+
(67,3,5,1,-4,-6674906368771292737,-4714909078995860171,-694606630357981501,2056794120664778888,'2023-12-09','2025-02-17','2024-02-18','2023-12-11','l',null,'g','d','q','g','y','c'),
+
(68,6,0,-10,1,6421608748716099689,-6420232743727631483,-5027341321206369030,-8047447049344425122,'2024-01-19','2023-12-13','2025-06-18','2023-12-18',null,'d','l','q','y','r','z','w'),
+
(69,-4,-4,-10,2,null,-5596432443330502176,72306968755123630,-5958628508439113044,'2023-12-12','2025-06-18','2023-12-09','2023-12-10','x','g','t','m',null,null,'c','v'),
+
(70,7,1,-10,-4,6992919153400584793,null,1353783002907846353,-5152302836273005942,'2024-01-19','2023-12-12','2024-01-19','2024-01-19',null,'c','p','e','t','c','p','g'),
+
(71,7,0,2,7,null,-8684271386152979594,3233214622962490768,8179162928591451395,'2025-02-18',null,'2025-06-18','2023-12-19','i','u','q','g','g','t','u','l'),
+
(72,8,5,-4,-4,8023833669625596957,-2175811755314296797,8273820027333341012,-7561803641363713877,'2023-12-17','2023-12-11','2025-02-18','2023-12-16','k',null,'n','i','v','f','x','r'),
+
(73,null,null,4,7,8097971023770222543,null,6847610491507492007,-248447702232261375,'2026-02-18','2024-01-08','2023-12-19','2026-02-18','g','m','k','r','s','m','o','j'),
+
(74,-4,null,4,-10,3831989339160695519,-8524697687236665725,-4718672348796081091,2770443942158142445,'2024-02-18','2023-12-17','2026-01-18','2024-01-08','f','f','y','b',null,'m','r','m'),
+
(75,-4,2,0,7,null,4959953926979696845,3486608622464080794,-3229317567443887999,'2023-12-14','2027-01-09','2023-12-17','2027-01-09','v','f','w','r',null,null,'q','b'),
+
(76,2,-4,-4,2,-601652204721465653,-3212752196133020786,5990606691349434570,-5949271236111832329,'2023-12-09','2024-02-18','2023-12-17','2024-01-19','m','q','x','o',null,'l','g','f'),
+
(77,-4,-10,-4,9,3655074239162198459,5189205617498229776,-6518420188701451360,5337606984188054445,'2023-12-10',null,'2023-12-19','2025-02-17','p',null,'j','e','t','a','n','a'),
+
(78,-10,9,-10,3,9122168885603966206,6448663440965666822,3372934569284931400,7574495481147792550,null,null,'2023-12-16','2026-01-18','v','x','w','u',null,'c','h','m'),
+
(79,-10,4,2,4,1031010101330880152,null,-663567195363937482,-3723694315710801677,'2025-02-18','2023-12-09','2023-12-09','2024-02-18','x',null,'d','s',null,null,'i','e'),
+
(80,-4,-4,-4,-10,-860805994236637848,1353988761359803557,8933620360636954498,975751778872136323,'2024-01-09',null,'2024-01-09','2024-02-18','w','e','k','u','g','h','f','k'),
+
(81,-10,-4,3,3,6343717446741286985,3019062611073886538,-2947234371040941148,-3140400579276155811,'2027-01-09','2024-01-17','2024-02-18','2027-01-16','v','l','x','m',null,null,'r','w'),
+
(82,6,null,-4,1,null,-4998553068568552704,5258188475370747831,785490117157375299,'2024-01-09','2023-12-16','2024-01-19','2024-01-09','x','x','a','b',null,'a','x','m'),
+
(83,2,0,-4,-10,-1247191244278730004,-8661164724725903678,7750833324080233471,3775784822365635910,'2024-02-18','2024-01-17','2023-12-13','2023-12-10','x','y','b','x','u','s','k','d'),
+
(84,2,9,-10,4,-817858363160312975,-6307225941795055746,2777452333765506049,7606287144502601088,'2025-02-17','2025-06-18','2023-12-20','2023-12-19',null,null,'l','w',null,'b','q','o'),
+
(85,3,6,3,1,-3335909153779002796,-2216409861500764748,3000962396131195310,-4606005732372915357,'2024-01-17',null,'2025-02-18','2025-02-17','d','h','n','o','u','o','o','y'),
+
(86,7,7,7,3,null,null,177000028736781102,-4500482738673885249,null,'2023-12-13','2024-01-08','2023-12-09','c','a','v','p',null,'l','e','o'),
+
(87,1,6,1,3,-8849844482902436466,null,-1399043876332577010,-6205355923329386507,'2023-12-15','2023-12-15','2023-12-11','2023-12-19','a','f','v','o','m',null,'n','x'),
+
(88,-10,9,2,7,-4142094149740485178,-6097600667195297942,-7736360815770084520,1137542737768894954,null,'2026-02-18','2023-12-16','2023-12-11','x',null,'m','c','k','k','v','y'),
+
(89,null,-10,3,4,5230502337072618230,-5604843245718539955,-4145483474992550386,-7766088395904457482,'2026-01-18','2025-06-18','2025-06-18','2023-12-15','v','i','x','s',null,null,'j','e'),
+
(90,-4,null,-4,4,-3303845190780727617,4977491131663868126,-4238194913226948570,7085770928368876512,'2023-12-16','2023-12-20','2024-01-17','2023-12-18',null,'a','g','i','o','j','j','w'),
+
(91,2,-4,6,-10,8142670228898751158,-8269778573449278132,5247255187446357862,-7150795204924087206,'2026-01-18','2023-12-19','2024-01-08','2023-12-19','e','q','h','l','z','g','h','y'),
+
(92,8,2,-10,-10,8246365030697052702,null,1832518927452710569,213124874328504406,'2023-12-18','2026-02-18','2023-12-11','2023-12-10','q','d','z','w','l',null,'a','e'),
+
(93,-4,-4,8,-10,7561272305027437460,-7647150958656616571,-2676635155700154238,-4522007691342264526,'2025-06-18','2025-06-18','2024-01-17','2025-02-17',null,'n','f','d','d','d','y','n'),
+
(94,-10,0,3,-10,-5605747574229168194,5182475087931900109,-8309333835210543607,9186292896916463476,'2023-12-09','2026-02-18','2023-12-09','2026-02-18','u','e','x','w','o','k','n','z'),
+
(95,6,1,-4,-10,-5252194964165933147,-1746773078673780213,6170198878190586183,-7294735841376118696,'2024-01-09','2025-06-18','2025-06-18','2023-12-19','r','f','t','d',null,'v','k','q'),
+
(96,-10,8,9,-10,-6066911064423874486,null,3634168368389506356,3822346680227396148,'2023-12-10','2027-01-09','2023-12-18','2026-02-18','p','t','v','u','y','c','x','e'),
+
(97,8,3,-4,3,6175671587580785704,5906494686057356739,-1967425206976655863,-3925705760640524442,'2023-12-16','2023-12-17','2024-02-18','2024-02-18','i','q','k','a','s','z','j','m'),
+
(98,8,9,6,8,7411169187348677028,7449414531536242146,-8699252498301697283,-8174321010282471216,'2023-12-18','2023-12-14','2027-01-09','2026-01-18','m','b','z','i','c','e','h','d'),
+
(99,-4,0,0,5,null,-1176464926279906122,-4999489278190558824,2571407554977584849,'2023-12-18','2024-01-09','2023-12-17','2024-02-18','z','b','h','r',null,null,'x','t'),
+
(100,8,8,8,-4,-3468322257390679547,null,-7914808819562923788,5408223112330809542,'2027-01-09',null,'2023-12-12','2024-01-08','c','x','a','g','o','i','i','u'),
+
(101,5,0,8,3,null,-8813549542765202970,-9177655225414804101,2059236470159210950,'2023-12-10','2023-12-20','2023-12-13','2023-12-15','w','p','f','k','r','q','s','z'),
+
(102,0,2,-10,9,4085346460992124148,2034777159334372255,-8862747378171119929,-703955865726407353,'2027-01-09',null,'2025-02-18','2023-12-12','j','l','w','y','b','g','e','u'),
+
(103,null,2,-4,2,-8759596790358056076,-2332782672358919128,-1015833249060432998,2831574326561352249,'2025-06-18','2023-12-20','2023-12-09','2023-12-13','p','l','d','x','s','h','s','v'),
+
(104,0,7,4,7,null,null,-5815230959973118916,-1420422137631498908,'2025-06-18','2023-12-11','2024-01-31','2024-01-08','w','l','y','t','d','k','n','g'),
+
(105,0,null,-10,1,2010086610127544661,-4323005608867325730,-990710261784582107,3731689068705537185,null,'2025-06-18','2023-12-19','2023-12-16','w','b','y','c','y',null,'y','b'),
+
(106,-10,-4,-10,1,-2094359095540169494,-2152661011165469751,-407651042626345601,7498060011104870144,'2023-12-09','2023-12-16','2023-12-10','2025-02-18',null,'d','j','a','n','o','w','c'),
+
(107,-10,-4,7,-4,-3196471327621740923,null,-5572610269276461502,3315068851942396190,'2023-12-11','2023-12-18','2023-12-10','2024-01-08','g','k','q','p','s','n','w','g'),
+
(108,4,-10,6,3,-3057042597962031632,null,-2159449737025884731,-1551590702287364467,'2024-02-18','2023-12-13','2025-06-18','2023-12-20',null,'a','q','e',null,null,'r','m'),
+
(109,8,4,3,2,null,-4987003599701071002,-1717431060201734552,-1048790362343573455,'2024-01-09','2025-02-17','2024-01-19','2023-12-10',null,null,'v','u','p','a','y','e'),
+
(110,8,null,-10,-10,-1842829307815004845,null,1415732896595163275,-6310236724918690102,'2026-02-18','2024-01-19','2023-12-13','2023-12-16',null,'g','u','i','p','p','l','x'),
+
(111,6,1,6,0,null,6312305928520220483,3365460910283453490,-3878367957383772837,'2026-02-18','2023-12-11','2023-12-17','2027-01-16','s','q','x','v','j','k','m','p'),
+
(112,-4,-10,-10,7,2380400422889424409,1963876330439667216,-5836681077839021771,2440060790583499390,'2025-06-18',null,'2025-02-17','2025-02-17','l','m','v','f',null,'e','g','s'),
+
(113,7,null,1,7,-2195405805986914490,4625229358937058763,6033163783549986017,4925074000933733104,null,'2025-06-18','2023-12-17','2023-12-16','k','o','d','d',null,'r','v','k'),
+
(114,-10,-10,0,7,6062034195118399521,null,-5411852481933751178,-1987885979907256937,'2024-01-31','2026-01-18','2023-12-13','2023-12-19','t','r','s','o',null,'g','v','e'),
+
(115,3,8,7,-4,-9127380289294619156,null,8385668391800796597,7590579961023582879,'2027-01-09','2023-12-17','2024-01-09','2023-12-15','o','p','b','v','e',null,'m','i'),
+
(116,7,null,2,-4,-2466262211293807333,null,7128035713146149079,7959758184035771043,'2024-01-09','2023-12-14','2027-01-09','2023-12-18','z','y','c','c','f',null,'j','q'),
+
(117,6,-4,-4,9,null,null,-426646984630556550,-1543674850997323049,'2025-06-18',null,'2023-12-11','2023-12-12','o','t','l','t','o','i','s','i'),
+
(118,9,3,-4,-4,5551171659862319657,-3857396517970182822,-3381220542530874582,211502040570616805,'2024-01-08','2025-06-18','2023-12-18','2024-01-08','k','s','k','w',null,'i','p','f'),
+
(119,-4,null,-4,2,-4036771036354371373,-5268121176736020103,-9202777940063920441,-643910676728604631,'2024-02-18','2024-01-09','2025-02-18','2024-01-17',null,'r','e','v','i','e','u','r'),
+
(120,3,8,9,7,-2566318575293129968,1686940761033910913,-2724417428267777664,4374420777915789928,'2023-12-14','2023-12-11','2023-12-15','2024-01-17','h','u','w','m','m','x','d','h'),
+
(121,-10,null,6,-4,1582635592543553185,-5137311020664757410,-8579259002422505432,-4363425453047660885,null,'2027-01-16','2023-12-13','2023-12-14',null,'u','x','r','k','x','v','c'),
+
(122,-10,-10,8,5,-6275920676345321947,null,6524024749956657019,-1351204623156774281,'2023-12-10','2025-02-18','2023-12-15','2024-01-17',null,'g','v','i',null,'h','p','g'),
+
(123,-4,9,-4,-10,-1866034129886413284,null,7284798450703536860,-7983828394429691706,'2023-12-12','2027-01-09','2027-01-16','2023-12-20',null,'e','r','x','b','v','x','y'),
+
(124,2,9,-4,5,-7818897807961738922,6256387471948154897,2585605500478691817,-7881817626914286092,'2025-06-18','2025-06-18','2025-06-18','2023-12-20','s','t','e','p',null,'e','y','a'),
+
(125,7,4,0,8,-2442289570598034323,3017714704247177402,-8372809352945300223,1070629302200695167,'2023-12-15','2023-12-13','2023-12-16','2024-02-18','j','w','m','h','u',null,'t','a'),
+
(126,1,9,2,2,8214142431338730982,3660411019939881762,-1748525699378068112,4234719550387624842,null,'2024-01-09','2023-12-20','2024-01-19','z','j','e','m','c','c','u','d'),
+
(127,8,null,-10,-4,-6183774203945608554,1403931482337460752,5497335773114954423,-7041936107758949139,'2026-02-18','2027-01-09','2023-12-17','2023-12-09','e',null,'v','z','m','y','n','p'),
+
(128,-4,null,-10,-10,-3527043394788989841,null,-1893599763259313250,6319421229044889007,'2024-02-18','2026-01-18','2024-02-18','2023-12-16','c','y','d','i','i',null,'t','y'),
+
(129,4,-4,-10,-4,5232732513450445011,-717919705972489917,-5411752723532127668,-5349655480732064818,'2023-12-14','2024-02-18','2024-01-31','2025-02-18',null,null,'x','c','x','v','y','j'),
+
(130,null,1,5,4,-6523085183793426429,-9012193721486509069,-2202067684543775504,-3985855344706264884,'2024-02-18','2025-06-18','2023-12-11','2023-12-10','x','h','w','o','h','a','a','t'),
+
(131,-4,3,-4,1,null,null,6198358310085909087,-928590921314043929,'2023-12-16','2024-01-09','2024-01-17','2024-02-18',null,'k','e','w','u','d','g','z'),
+
(132,-4,0,8,1,6689827572124436012,4916969215813697399,1578149663472949380,6637733286044673649,null,'2025-06-18','2023-12-19','2023-12-20','y','z','r','a','e','v','x','c'),
+
(133,1,-10,6,4,-1297985777428861579,-990447532556969907,6114555769592170501,-1251536506876371467,null,null,'2025-06-18','2025-02-18',null,'x','z','z','q',null,'f','d'),
+
(134,9,7,3,0,null,-2574806983372047749,7782943546456622685,1784068357887003432,'2025-02-18','2024-01-08','2024-01-17','2024-02-18','v','s','c','f','a','i','q','w'),
+
(135,null,3,3,4,null,-6402238570222527588,456985212413588060,-6324642629429883775,'2023-12-16','2023-12-12','2023-12-10','2026-02-18','e',null,'u','q','x','z','p','i'),
+
(136,0,1,4,-4,9165440537890266026,-3368696524456875625,1834670262686358570,7159488295151947092,'2024-01-08',null,'2024-01-19','2025-06-18','f',null,'r','u','p','n','g','q'),
+
(137,9,0,-10,2,5825564402002529715,5916583003766254161,308486195639949801,-3084124640868354155,'2023-12-18','2023-12-11','2025-02-17','2023-12-13','u','q','u','q','n',null,'s','m'),
+
(138,2,-10,3,-10,null,null,-7906028525213830822,7768974004381159295,'2023-12-12','2024-01-17','2024-01-19','2024-02-18','s','u','a','d','x','i','v','m'),
+
(139,4,null,6,3,-1087205098158704253,null,6117774810699553195,5528899066049683102,'2023-12-11','2023-12-12','2023-12-14','2026-01-18',null,'k','l','u','t',null,'h','s'),
+
(140,9,-10,7,7,6895235116122591997,6655789171345214492,7435979442397054614,3271248940660667682,'2023-12-18','2024-01-17','2023-12-14','2023-12-14','a','t','f','k','y','x','k','n'),
+
(141,-4,-10,-4,0,null,1550572088109129759,2922425330446401892,-3292062204666000685,'2024-01-09','2027-01-09','2023-12-15','2026-01-18',null,'s','v','m',null,'u','a','w'),
+
(142,4,-4,-4,2,3750738797310752802,482495131642894924,-1803133122874943468,-5560828149916351177,'2024-02-18','2023-12-20','2024-02-18','2023-12-19','g','u','u','v','t','z','i','l'),
+
(143,-10,-10,5,-4,3752175362923346376,null,9070358245968329102,979478163667151368,'2023-12-17','2023-12-15','2023-12-12','2026-01-18','j','b','f','j','e','l','v','q'),
+
(144,5,null,-10,5,-7578858516067052196,5296737221140370249,-4036183011311068274,6564252036481980570,'2024-02-18','2024-01-08','2026-02-18','2023-12-19','f',null,'b','b','d','k','z','s'),
+
(145,7,null,-10,-10,-2801905559410385260,-5825383618332418622,-8578446262558777713,7659245641813351104,'2023-12-16','2025-06-18','2024-02-18','2026-02-18','c','k','y','j',null,'j','p','g'),
+
(146,null,null,5,0,3107760972522643704,null,7134018890318340647,-6320590865572550487,null,'2024-02-18','2024-01-09','2025-02-18','f','w','r','f','n','l','x','s'),
+
(147,4,null,-10,8,1846616948654222483,-6412906185260906202,-6731263606855662025,6990855464391374757,'2023-12-15','2023-12-19','2023-12-20','2024-01-19','y','q','r','h','m','f','x','f'),
+
(148,null,-4,-4,8,-7453357553846742813,1378835603755975964,-5266233497248044403,-9186504589591711117,'2027-01-16','2025-06-18','2023-12-12','2023-12-17',null,'m','y','r','q','j','v','u'),
+
(149,-4,null,8,8,null,null,-2034921767147130207,5520873100977820520,'2024-01-19','2023-12-15','2024-02-18','2024-02-18','q','l','k','z','d','n','u','v'),
+
(150,-4,6,4,8,-8093623869105529860,-8931801690014246778,-4084430254900686932,2180092529716307520,'2024-01-08','2023-12-16','2024-02-18','2027-01-09','n','p','w','v','t',null,'b','g'),
+
(151,1,5,9,6,-3511936494211303764,2576411238581044414,-2081336023618431624,-6760879733264571615,'2024-01-19','2027-01-09','2023-12-18','2023-12-16',null,'u','z','o','c','i','r','b'),
+
(152,null,-4,5,2,-5017752096013630944,null,4195060556751701629,-6421314757947568106,'2026-01-18','2023-12-09','2023-12-13','2024-01-17',null,'o','h','o','e','w','p','m'),
+
(153,2,-10,6,-4,3067828230092317486,-6599453705016579907,-9169029376106860745,6781630600285070443,'2023-12-20','2024-01-09','2024-02-18','2023-12-13','z',null,'p','z','u','g','a','v'),
+
(154,-10,-4,6,6,4180562161029377651,null,6271979755251634149,-6624217891779638671,null,'2023-12-16','2025-02-18','2023-12-20','o','l','w','h',null,'h','e','n'),
+
(155,1,-4,-10,0,-7767798817892634820,5782113845303121502,4207969927461612633,2877262173140503308,'2023-12-09','2024-01-17','2024-02-18','2024-01-31','z','z','o','w','q','v','j','q'),
+
(156,-10,6,0,-4,null,-5789953689294652033,102245250334180744,3755119803480784046,'2023-12-14','2023-12-10','2025-06-18','2023-12-17','e','d','y','w','a','c','z','u'),
+
(157,8,6,0,-10,-5238309315680282118,-5707254004425303637,3323831776166491524,7139867243097082268,null,'2023-12-14','2023-12-15','2024-01-09',null,'b','e','c','r','h','y','b'),
+
(158,null,9,9,1,-5349953513329428835,4403185441047693129,932185000913135760,-1992306805009575326,'2024-01-09','2023-12-18','2025-06-18','2024-02-18','u','i','d','d','t','t','y','r'),
+
(159,6,5,-4,-10,3313378859261499127,-7584248478502122376,5760207207702292339,-8987355841581094337,'2026-02-18','2026-01-18','2023-12-19','2024-01-17',null,null,'l','e','c','d','n','u'),
+
(160,2,null,7,2,-5498266611850349156,6917745080484487592,-2805323606048046980,1216391667383278497,'2024-01-19','2024-02-18','2023-12-16','2026-01-18','e',null,'e','z','m','a','b','x'),
+
(161,6,-4,3,4,-1876263858946146628,-6615460033503337367,-5100038927409331460,8250232565082127255,'2027-01-16','2024-02-18','2024-02-18','2023-12-10','c','b','k','a','r','l','e','b'),
+
(162,4,null,-10,9,null,2546849170385649215,8324132647242971653,-7895309615378665473,'2023-12-13','2023-12-16','2025-06-18','2024-02-18','t',null,'p','i','s','d','s','r'),
+
(163,5,null,-4,6,-685494335523908835,null,-834712794866661570,-1950489445402007616,'2025-06-18','2024-01-31','2027-01-16','2023-12-11','c','o','u','k','l','k','j','p'),
+
(164,-4,4,8,-4,4002375995713095002,-4571185357674435246,-208187264117144629,-2321648468360330025,'2023-12-09','2025-06-18','2024-01-09','2025-06-18',null,'q','d','b','t','o','y','v'),
+
(165,-4,7,-4,0,-6278901807472071584,-3313854966455205400,-8085051633312104550,-3109207519938755775,'2026-02-18','2024-02-18','2023-12-09','2023-12-14','r','c','b','j',null,'a','h','y'),
+
(166,null,-4,-10,6,-8361792768864825077,-1084162764304274919,-479780499589336666,-1129407620705531893,'2026-02-18','2023-12-13','2024-01-17','2023-12-19',null,null,'g','g','r',null,'j','c'),
+
(167,-10,4,9,5,null,null,3951522919893940804,-8332023418620028762,'2024-02-18','2023-12-09','2027-01-09','2023-12-14',null,'d','g','v',null,'w','h','f'),
+
(168,-4,9,3,8,1529777499214360074,-6997887526651843542,-8458231178492141089,3840372226716160967,null,'2023-12-16','2024-02-18','2025-06-18',null,'n','z','c','c','h','c','l'),
+
(169,-10,4,-4,-4,6946993991730979265,8176100137769720968,-8041462426565086065,-4109741515972549488,null,null,'2024-02-18','2024-02-18','a','z','p','i',null,null,'v','x'),
+
(170,3,0,-4,4,null,-7624607757800218752,3618830994450644153,-6129891312770625052,'2025-02-17','2023-12-18','2025-06-18','2025-06-18','d','j','r','d','p','z','g','g'),
+
(171,-10,5,6,2,-8830138177615843980,5994980713134629070,6480319847223557063,5812457841941972048,'2027-01-16','2024-01-19','2024-01-08','2023-12-13',null,'i','b','y',null,'h','c','e'),
+
(172,null,2,8,-10,null,null,-2668174711835062355,-7937911099765547092,'2024-02-18','2023-12-15','2023-12-11','2023-12-20',null,'p','x','q','k','w','y','j'),
+
(173,null,null,-10,-4,-7787325944354092620,1320716527879719392,-9166221674764576094,235735767961663391,'2025-06-18','2023-12-14','2023-12-12','2023-12-10','d','c','j','s','p','b','c','u'),
+
(174,null,-4,-4,-10,364622063991352420,4970321947467996353,-9130870957699502595,8196827494559495982,'2025-02-18','2024-02-18','2026-02-18','2023-12-18','z','j','x','x',null,'s','t','a'),
+
(175,5,8,-10,7,null,-2825070457296610618,-4914813500598169343,960642228396826217,'2027-01-16','2024-02-18','2023-12-18','2023-12-17',null,'i','n','b','d','x','r','k'),
+
(176,-4,7,8,-10,3764948595785602107,2369598693018501594,-7989778992633982458,-382915346647278838,'2026-02-18','2024-01-08','2027-01-16','2025-02-17','o',null,'x','b','g','s','a','u'),
+
(177,2,-4,0,9,3737716014645813822,-8560588108410815277,-4182495432745381426,4295861215986743261,null,'2025-06-18','2023-12-15','2026-01-18','d','v','v','v','c','i','t','h'),
+
(178,-10,-10,3,-10,9116324680519029777,5244767067437673763,387385371772011475,5929758206547735429,'2025-02-18','2025-02-18','2023-12-14','2023-12-13','x','d','z','n','f','u','x','z'),
+
(179,null,-10,4,8,33967237888604502,-5317545323880858579,-5205082973483149617,1930065832149488722,'2024-01-31','2024-02-18','2023-12-17','2023-12-10','k',null,'s','h','r','k','q','j'),
+
(180,null,3,0,2,-5628966950066318339,null,5178806324406541024,-3755555444616250127,null,'2023-12-13','2027-01-16','2027-01-16','k','q','z','o','f','b','s','g'),
+
(181,2,7,4,-10,6385617375816027246,6495041779069789335,3773525655373506,8863923940907927212,'2027-01-16',null,'2025-02-17','2024-01-31',null,null,'c','j',null,'m','q','k'),
+
(182,0,3,9,1,8218839267568478559,-9078367742579969816,42287215527153557,-8332275497056352768,null,'2024-01-17','2023-12-19','2027-01-16','u','o','n','n',null,'d','j','d'),
+
(183,0,4,-4,-10,-4412910011538773187,null,6009092362215628337,1397631704475053458,'2025-06-18','2024-01-09','2023-12-16','2023-12-18',null,'j','g','a','l','g','o','d'),
+
(184,0,3,2,2,6021283243596252750,-4155088143560449683,6170973520736075185,-4205974343310933147,'2023-12-15','2027-01-09','2024-02-18','2024-02-18',null,'b','h','j','k',null,'t','j'),
+
(185,-10,9,8,6,null,-6847080278916852813,447950904400246482,-6933255189029870646,'2024-01-09',null,'2023-12-14','2026-02-18','h','p','g','q','p','u','x','p'),
+
(186,3,-4,-4,2,-6009193301033031800,null,-4672034582397754264,879776088217230979,'2023-12-09','2023-12-17','2023-12-12','2023-12-20','m','p','s','c','f','f','t','l'),
+
(187,null,0,3,5,8333051860130787223,-6516443762135442729,879209435522521115,8013043252265825497,'2025-02-17','2023-12-18','2025-02-18','2025-06-18','k','b','j','x','g','g','s','l'),
+
(188,0,-10,7,-4,-2463031932695328774,null,-2011111060524811832,-6510640267309401751,null,'2023-12-20','2024-01-09','2025-06-18','m','j','s','y','y',null,'n','t'),
+
(189,7,-4,-4,9,572148246336646876,null,5241035521810846489,-1634746466882461066,'2027-01-16','2026-02-18','2025-02-18','2023-12-20','b',null,'b','b','l','l','f','k'),
+
(190,-4,-10,-4,8,6098594457072613484,null,4073451604755026083,1867497698996352795,'2023-12-13','2024-02-18','2025-02-18','2024-01-08','i','k','f','s','b','o','c','q'),
+
(191,0,-4,1,7,null,8584171056884324573,2382411307476548648,-2812791859451287640,'2024-01-17','2024-01-17','2023-12-19','2024-01-31','s','l','o','q','k','r','p','y'),
+
(192,null,7,9,-10,-6627830543468052229,-1031929253636573934,-6915694304224904507,-2450876687398543429,'2024-01-09','2023-12-18','2024-02-18','2023-12-17','d','w','f','q','n',null,'k','e'),
+
(193,5,8,-10,7,-5900364580208786110,-7872693241314584841,-3099731394333634291,8800894838331835589,'2023-12-14','2023-12-11','2023-12-12','2024-01-08',null,'a','o','s','l','q','l','o'),
+
(194,-10,-10,-10,0,6190666485437686533,9106505512949814658,-5259893975720632633,-2082645093827676340,'2023-12-15','2023-12-16','2023-12-14','2026-01-18','f','k','d','l','g','l','h','k'),
+
(195,-10,-10,8,-10,9022523916974374832,-1637460904533459978,-2660463402243837366,-1386206454202037958,'2023-12-16','2023-12-12','2024-02-18','2024-01-17',null,'k','h','b','t','y','g','h'),
+
(196,null,0,7,0,4521246042360985258,-3539427316714994362,4376191890126961035,-5108612672018064701,null,'2024-01-31','2023-12-20','2024-01-09','c',null,'w','t','h',null,'t','c'),
+
(197,7,null,2,1,-3638524270505713749,-960841410750600000,5789480090124650148,8824201152864956993,'2023-12-10','2024-02-18','2024-01-17','2024-02-18','p','u','w','z','a',null,'l','w'),
+
(198,null,0,2,-4,-1564019790200386279,-7666918062049658327,-4388748787665181900,-145844673711442497,'2026-01-18','2023-12-14','2027-01-16','2024-01-31','h',null,'a','r','a','t','d','h'),
+
(199,null,null,-10,-4,-6417806465018977070,6707853128566441994,-1305020385906477162,6811355155723134908,null,'2023-12-13','2024-01-09','2025-06-18','n','b','y','d','f',null,'p','y');
+ """
+
+ 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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
