Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

query get extra rows using MV index #50382

Closed
wjhuang2016 opened this issue Jan 12, 2024 · 4 comments · Fixed by #50439
Closed

query get extra rows using MV index #50382

wjhuang2016 opened this issue Jan 12, 2024 · 4 comments · Fixed by #50439
Assignees
@AilinKid
Labels
affects-7.5 affects-7.6 fuzz/randomtest severity/critical sig/planner SIG: Planner type/bug This issue is a bug.

Comments

@wjhuang2016
Copy link
Member

wjhuang2016 commented Jan 12, 2024 •
edited

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE `tdbe45f5c` (
  `col_96` varchar(488) COLLATE utf8_general_ci DEFAULT NULL,
  `col_97` binary(206) DEFAULT '&\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `col_98` json DEFAULT NULL,
  UNIQUE KEY `idx_29` (`col_96`,(cast(`col_98` as signed array)),`col_97`),
  UNIQUE KEY `idx_30` ((cast(`col_98` as signed array)),`col_96`(5))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
CREATE TABLE `teef726a5` (
  `col_92` float NOT NULL DEFAULT '5217.6055',
  `col_93` json NOT NULL,
  `col_94` json NOT NULL,
  `col_95` varchar(181) COLLATE gbk_bin NOT NULL DEFAULT 'FbVkA~^',
  KEY `idx_26` (`col_92`),
  PRIMARY KEY (`col_92`,`col_95`) /*T![clustered_index] NONCLUSTERED */,
  UNIQUE KEY `idx_28` (`col_92`,(cast(`col_93` as binary(64) array)),`col_95`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin;

INSERT INTO `tdbe45f5c` VALUES ('xAjzs_u6X+0gJqJuET-',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',NULL), ('nlAjx',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[2824373988573110971, 5894521625901721212]'), ('wgP0QqCcL5-8m&(E$(',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[1007488563383092277, 3063509239455308111, 2754461956121461839, 5645965065554745872, 1005212220604930446]'), ('_1!h#UuCz',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[7882407618943261094, 8854243031713614290, 5227143073914885406, 8564944233704467069]'), ('e(NUcjl+zAELv$*z$',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[-9223372036854775807, 6768456826251219389, 2248881510994147256, 2, 8745962758401483278]'), ('E=S*7NDaKNCxr=x@',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[6948162628461842154, 388072781061651177]'), ('T~6BXQtuLXs3Nynn',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[4916097982268977111, 4831071175460962296, 4924144738157843623, 2889755021111370727, 7736261994385613239]'), ('zk6o$4pcTHA*GQ',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[7837077849986219679]'), ('RFJ5z@%5g^N0',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[4399145150159068551, 7991081209330848136, 8256336280143154808, 5399122950997952001, 8717000361483843589]'), ('sa7pyqxv#M9R8o',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[2, 4049793359209704085, 5457696026985542523]'), ('eGOjrJ1P9kxEYpcugQ',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[7884484671527550094, 8634464548201717067, 8507102471069520402]'), ('GZw!5e7&)!9u*T',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[8791675374770640862, 2, 8602312435882769125]'), ('_SYgMRJUxlD',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[4117899633844964344, 4671277985023451974, 1378278192784622509, 857385574001509129]'), ('Tk~ZO2Bb7G',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[7349735891030170302, 4006473353908131903, 8348756573667225821]'), ('lKxj',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[4198901845746850296, 8555782483966661868, 4780445824640244967]'), ('j*%IIY',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[9113627478285286054, 3365776573532138608]'), ('S',x'6b536a2100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[2340978648684737790, 4491705820356034617]'), ('QWcmV0oEtkZ',x'285976384a72737548647a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[4053237834475434032, 2203415323059271958]'), ('FdXx&4nW$XV1BUZ',x'6f2857505140725f592b456f7e4a304365780000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[9166375012323249218, 7634802971897214524]'), ('zx=o(2C',x'567e26345f47774f72284e365323454450317600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[3872027442434845309]'), (NULL,x'57215a6937487a462b4900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[684201383684052068, 8916862203535944869]'), ('R&iVDa',x'5355252b63424175524625490000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[-9223372036854775807, 5371469509464083948]'), ('PzZ$7WR^pv',x'7169336f4d294d37445f415033506b7979000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[7555878223365323954, 4756285055555932036]'), ('j+ZWYw@(rL4wX',x'3255412851000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[8995604371944461763, 4718018081306628255]'), (NULL,x'6f37000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[8099339227856698919, 6363092662441211585, 3446444781791333199, 4793136298173921432]'), ('Syx-sCOnVfdYmjCR_o',x'564d79316477236f530000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[8234105681383801024, 8865885156825379032, 3267682608805102652]'), ('Mx6aE=&ON@3gv',x'702a61627a574529347200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[14408703268575065, 4523422767275373168, 5451813102239929534, 2268289247375721883, 2539129929953898452]'), ('xuNDTl3~OS#Fta#=x7j',x'584670552d3462617121637033746e7600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[1118162715614928353, 164127156245810373, 6485526244075454977, 7937826337322972302]'), ('u',x'49594d69456b3735446b72282644000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[3758211633046291609]'), ('p6&Com20hVUTkmMuu',x'7840000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[7571252360585941590, 1734882074174969530]'), ('QrZ#L7YONs',x'6757523100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[5423019684257616025, 3094046958020427448, 2637156371525210234, 1]'), ('',x'6a5a7171292825232965314f4371304d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[7393958735679057686, 5418784868165549355, 4911356181212311562]'), ('*v1Zv4O-LVJTkEdC$_1',x'745e730000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[-9223372036854775808, 3213102951297930226]'), ('-s&O-=4u',x'2d4a50564f472621000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[4089507174448063655, 7545980512068610869]'), (')$l!^nocE8=~a~gPl',x'5266454a6c4f5230000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[4805529298331638562, 7491916460274281549, 3096299632319250416, 3597992594017127006, 8412164794458757968]'), ('P',x'5123257a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[5921560901022446660, 2284610011192569496, 5225108870668056146]'), ('^@j@Zo$ccb5Z3PBoXZJ',x'452a5a336c37704b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[7911703076490821618, 8635596802529081563, 3203784289139702409, 4564005977449518860, 4204222143335676418]'), ('b(ulJYm*RcitdLSM',x'41707356787075542b4f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[3706887387998428198]'), ('3fMYt8*HY9*',x'566f516d2462242477622a6b2448527a49656800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[1656629165279810296, 4984318803604144665, 1444362014867251136]'), ('-2^@PfkndCo',x'4d484f3655704f66422a454a7468246400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[3683225382961208983, 6119248964370467932, 8664035647024380958, 5216299029424302031]'), ('6HbPkv',x'0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[6111435266195737565, 3252509972167657103, 1, 2437442535068202287]'), ('vIEvKzXh_(2n',x'6574313d50405e332a58614b626e25674c527100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[4068317683206856999, 3885799890728826639, -1, 7587824990967374532, 2479850901274608056]'), ('=ETq#*~$Z!sTZ',x'4d4f2b746b6d3373716c5640336d7a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[2, 8850519154014199541]'), ('m',x'6f662a25573725656b4e45000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[7346820363611954553, 7091575110105363031, 7432579807142462553, 675755596992759560]'), ('$lyVY$50*BO',x'5200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[1051678399392721847, 9223372036854775807, 4762509192439574711]');

INSERT INTO `teef726a5` VALUES (7818.12,'[\"D4TPSt7NTkgn7ntmrOSJSnyhRmN2UHhVK04vecPJ4IkmVTBIGVwT64f95dCJG2HZ\", \"nxDagX5al5jW5GOB40LDc4svRzhB1hwzDczrqi9ej2iZBI8K1GWWaBU8iHrsyRfE\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','*iw=WC5BNiJ1Y6j_7)'), (7818.12,'[\"D4TPSt7NTkgn7ntmrOSJSnyhRmN2UHhVK04vecPJ4IkmVTBIGVwT64f95dCJG2HZ\", \"nxDagX5al5jW5GOB40LDc4svRzhB1hwzDczrqi9ej2iZBI8K1GWWaBU8iHrsyRfE\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','-hYgRwL)5#QDo&v'), (7818.12,'[\"2uE21PG636uMpCGRc6mlBWabfrL8dHeCwOnQNc69Dtf9K9OSHW95Ul2j9YEZrHZ3\", \"5n1ernJau4itsEj1kpfWAqzhv74lpfFJFwFvWLqEyhlyEq47GGY8j3EMeTepdUlv\", \"gGZR0n9VhS6d18DxlmEWSjtrf85opeG1Rd2cFwJl6hiRQoW2HbTgw1tmNO3dkirJ\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]',''), (7818.12,'[\"VhRbd4QE5vVJzEn8TmaCeNhUyLHkZGgyJukl1l2388mey4u3JZKhYHUNyVE08XYg\", \"HqqQN58cN79iAQOU6mk3JgIDhvbCWpeIjoEo0HnBPTpos4yPbkgjtxRWedVRvVNs\", \"uPiRicFuBfbMFUUlr7a7RL397b4x9bxF3tVEEoeAbDNy2Lt8tDplLHRPfCpu9mN7\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','!LU1~iU3sMb$=o('), (7818.12,'[\"XdyWqdXLMPZhJYI9Nldr537EkCylKwZNskPkR0SGBW4dyNesjMqXufdIet3RmRrS\", \"Haav1rw7BNq6HsQMBcjK23otT4MwIoSgmYe8fc78q2da67byEFoDfKaOqlgBjMjW\", \"zsRLI41pK7w8bf7eQGjXx70EbC4wuVYUZ3CLq1wQdF9RNmoEzP1wlGs09INw8H6n\", \"Mj8r5U0n0HGwOwrrqTCiwXohxCEWsLR2H1WdcfEeGMaFvCm7IPyuUbDlsI01d7RQ\", \"mRW6WGFSfZNH8pBnLyOGWRAXz0LCeNrju34o3I72m5TnzjL0l48o4RpYVJOTYNCE\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','(YDoG#q-'), (7818.12,'[\"AfT6ld4iHfyTyu3DPw9xP5Uq9XQ0OGe4bss1mzizjWAsYvbCVbpxxxf16BqkfuWj\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','IUaM$#)OnTs2'), (1341.5392,'[\"2iVoTyJ9hIbKRhKkMOdFVvIIysgfnOb159ArOJBu7pNMWOjRaeigUWpo01vOLEUg\", \"GinfXtCSbBhr2MAKHbiScTA2iHsO5FaEzmDg0Saf2W75l701hrYQ2sgiSAaVzoKA\", \"q87U212KqvXWVrSlqsEha1fJPsX9FolQ8hWwdTLAw57Z2vhtoaGJDdVDYMtPB8bp\", \"RHLr4zTSUPyySmuHCNdBqad5RHmEl1W5RtG8l0sp0Uf6yPfOz6cLxomeM15PXmEh\", \"RXJBuWBwzLhy9WAmI8YXec7mAs3RNe1GLJOHEdjJpScAcCmVDolzgk9yAgtDOjUk\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','sV1X#QVQ'), (3981.2578,'[\"2OJvdhSdpZmHlTl85w9eldJ4EB8PXzbHae5P0f51qoM3q3EnjF6CuygTd9xlsxo0\", \"O9o63G3ep6bH2F4ortJiGAYImyIHEA3Bw2W1Fl4JZsDTgpVm3XZ5G2nTZLi0IvdN\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','2R'), (1385.8489,'[\"9FngF5xhg7sFFNRsmPysIxhIwZgaVPt6d4SRkdtefJskvzIV1bwtiOEzzdiv5kSb\", \"VHBsM245QEt6LgvnynvsKFEfkOKxHGHF8DqKseGKPSI4vaV24iWLCt7xKrng7Q4Q\", \"zMgC7U53xPwnytYJfB1FdujuSiPmt0Z8VkYAmpVfxXocIs8FxwaxWqncSKAgbjE9\", \"EyWXa5EFKeHQAs9NCcGUgYgYpEJ1JiwOZLGA9W0EqGABDujuCUwaZC8Nn0KWAvMB\", \"dE1DMK4zsViAAYQyAjTcZc0S2jYUdiCMcJqjCGQsI7wV6TDRCxSsOeJxoMe96hE6\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','F$vTOK^DH~'), (4690.9023,'[\"P8LoCL0X3tg11Lbb5HiIMEZ4TRztUe4pzC4iMkfUwFKz3uu2kkcpGHas6KdTxbVz\", \"R1thmJKG6xLh8PtDcsAIawbk5iRCZmfTgSJ982hujptXa9jjgtcbzmL0AF3qADXP\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','SKn6L+J(Fnw'), (3582.79,'[\"4vOWNUCIJgsytBsFVfroJOI33X19WpC0bLIHt9JnO7jDLKmQiC69mLtrseCC87RI\", \"hGIRIiuJYDIEjadHrVA6NfhdMAdsPk8u2IKofijXGz3ppi1MrJj0tC9ZvXOqO2wi\", \"2M2p6FCNUJJCA7YNvxjiZjHpYhwVWVPeCr2kZm9skf8qFITuoxg5ge7215Sgjnvt\", \"3Z5WUQkAZkAmpDlcDkFQD09FIn9XRpAFcf1NqMdQQwd5o6Rko5oniLRniLCjZVsD\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','9ox'), (3011.0894,'[\"Z9IUHtRUG1PO889tUcPQGmWoEVeSYcV1lO0vgvmHGWJCOfArBtYiLzD34BCghLsX\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','Hrs$@JrezMcU_J+'), (4509.584,'[\"yVIJasgHAZgPS2gDlwHOnnWk5kjaTxNprIE5p7qecQafvNik5U6eTo34JrjZrxx4\", \"xjueNPFGM3j0S9JlVHhJPO1cdXRMSDbONgzXeHyCxXH55c9Rr5FVwoZyxT9iUVPm\", \"CqPYQZba6OhV9nZH04uRElKmraZia8VYshkXpIPJKkxarKKz3J07F9XPUuLUa9Vg\", \"apF3DDfMDPMo8W7Wesua1XCWmNJjIvEFFkbZpmcPHxyMHAtzkTvBTHzsVqznEYAm\", \"n3DMxhoA2IUWlnnsS9HrSVP5b5jjPU7PAehyHAN6y1YaRwleUmPGIvnHu9touc6j\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','Td@fSOTkg-j'), (4512.079,'[\"J3T6UmTjER2A4b3BmZj2pLwXFtDQuhNSPA1wyres22dzap43m1Vjpaq7DQ4zmf6q\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','0q-#%rvh79J='), (8343.3545,'[\"S71mQdLAR9xFrkEKNxNreuTSSOvQX8JzCNGZoGJgc9PRkEu029DJWBpjZcwGjZjG\", \"04dUV3YUDsIcxQyqaoQLhsEEFU7LjDtVNSLjWjuGTEt6LqDsc2djp1eRCgEQMbUc\", \"4gnYGSTRrXmrOQozgJiSflerQNRz0XjknjP0fV8UqG2lnbOSQnoM0T4qB586mLxQ\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','fG'), (6131.9585,'[\"LJfOoBQyMb31S4IhMSMyXvTLrHEKzA7lqNrJO6m9KM44vbqNraqHMnYVEAsFuKi8\", \"4TSgrl9nAqB9bQHuzdZ9n1Zb88I0TZ8r8AhXvjzM19IJsaDNGlN1gy7qf2XHht43\", \"ZxitEuF1oeLP5KYbdjI3EGuZ2PlaxLtQidWP943YSU9cDRzg7sFtPDoOn9mBHoaI\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','u-0G'), (6812.7246,'[\"ODTT9SD7SVBAQqxiXqWF8qhM6MkctLVlCTmbrj5BkkWTsYpeTAk4hWQYA9AqbnMK\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','B163%wAXY'), (5492.353,'[\"rvpnAbAMyUTAI4yMHma1KZFAJfT6ScqEHotvZX7hUxdIMFfwMQDsCAlHDiwrTM9h\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','fRBQagU18'), (1512.0317,'[\"8TKFguOnHMinOURwwc8S06JXEfLIy5sChav8CL0vnYEtgPtkrB0L8gKLe6ioNkjG\", \"dwKVJpcwO4MFjd5bxh9xLoqPcMbMGbePNUH0gcejKi1setbwY0InlLzvfbVERoiE\", \"mtC1UGSxZaOeqOs1zzQAzXU8dvE5yVItaaE90qsr2XGslzismcJ5Ti1fzlH3OUe4\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','QLi3sfhf&8Vp)4'), (4065.6995,'[\"ODWkbLmNIVnc6hRH2OVOc2Hqm2nON0HOFsRmION89hrmYZcsyw1gYwssjck9i559\", \"IOAyX1UssSQWc845COH1M06uuquoxooSCf9jD1YOjPvUpb40Z3xYtDN4N1i44Iqd\", \"x1EKoDAydeDsCIVzn5uKVnw3HWKY4u6pUfMtf0ujxETx10DXT6zpKxztVKG1kZow\", \"qnczZOASDPfCvnOOcvk1X24lgcs4qoMMrefgw29PPc6pk87HDraXznAbUSAdR6hO\", \"N0uZ8J14jSNzhrnUdFiYQeD3PFL6x5WUX9PP1tS38A8i1W4rCYcT2jPyadGuR3kq\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','mf-k*+-Q@ItxkTyUHlY'), (4739.278,'[\"KnDssKz5oE2mkxyVPRn77JBh0NIwFhVgXl3l066L786B0CrVUESyupof1imYPvr2\", \"hVf2X4c1oUDBu0KF8o2HLV7uVDkNNAByqpDmRE0VZBnbXSFw8JDWOufEwjpQ26e1\", \"ae3Uhwf6TJKM0FbXflvKDRRmGdrONo7tHbNH0tab5gJuECTzMfHPtgjla22Xk7C9\", \"6zqbmHn2q1QIHhNmSAwP54CqiCnOAQwDkTscheIozr7RnzZPKP5eWAVSY5EFrdfJ\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','j~0@bLfS1U04E3I'), (8780.668,'[\"2y80bH9hIsGSBhuHhDcFDoI4wQtaiSI0d90jlEjBe21TqeOiXodTa0DWqJZA0es3\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','569'), (30.489977,'[\"maEjfaLtCvtJU9Ve8VXHazF2WRFjazcIJO6cfTc0PIQwsJKGKIHr25w9xRfmzSZa\", \"VvyRLdS0aSlgDiuGFt1IZl5o0F8btF2SofZJVBgyCSQvWuwk8tX74TsXfGsoYK0o\", \"EWXRIvN7J6hLBwnhS7M6xTu8y4YlUKO9hTxwZPRd2toiXEQSIFqJXKwj5ceJXeWq\", \"UQV2nOPpiZNYVxpB6LGg6Hpv1gwOw2sIrjAKETGeliAQjkkSuKaumcHQVQ3Md1Gv\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','Mf~a=H~Qu(f+8Jpl&X'), (9307.473,'[\"DpxftSwCiNd5ILGECZkU5VxQa9yD94ASBKcQF9fOKBMAzbg8Ojx8VnMIDIXU8CMK\", \"vIAKIbNr1LDJfCGIsl9JY3w4rV1Iy4Nw6IbfiKO2aWBO3egLxGO333omVhXTI7q6\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','uW7-jdiQbn#'), (6410.3096,'[\"L3EreDFNfgneM25yz59N4iCYeL8Z9py1umCA4PPl9AwbQ5RFlgYvG97b3QJezKJ1\", \"2NeDZOluO7ohp2XKXtxDb4InnExHheZxzcpfu1V8UZIbJlqNBobeZ36OqjJk1RED\", \"9AvUWo5aiFI6ApK0bcq26YnGyYxNc2sgHYHs3kAqy75PTPcStAyfDvMTb65fL7IJ\"]','[\"snvI6zcokWYv4JcUVN6Lo76xytHrsswaoeIttSCOIOO0wHMcHMeyGa12qyLW3Pbq\", \"RetKYHeRnCHkG5o2UuY9ZaPAKFlUfsa2GQznZKhUScQO4qK8ECAI06RCuXh16hVg\", \"5GuoXbvqWhQYfBlFiqWLcvx59UqlOxgJrfrjn6oraPAQnSd1xzyq3zlvaFYbBzMM\", \"RxdxLBnLeLJhMzIilwBCnuGahMynYprdEpqh36LG2cplfLmqG32wEL6xsgthio9x\", \"25LzYFSa548IsoVz0V7uQ1LOcYklBCyFjro26dtQsrGNbYMWqhN4mNPwgmsEKcUH\"]','SYt3tKvf+c'), (281.3734,'[\"l8YaSwJ28Iw5NQuICF3dfJQ3HRSGi1ODk1Ds43jBgwZxCrjhSSsoLQh5iGVWZ2aJ\", \"0uEVU0GTCyD2w5LQiLFz0SYvicA0TlzdYNfQx61qZFR0k69KjwBmWNDRl2T1IfMY\", \"o49AQ45FsasqLev7KUIdHLwkQQbtrUXYoBZC4JkhPfl0DfN6NF8AN8smLxb6Pr7B\", \"L0hTSCxQv2NIMAOViaXVSr9iSdwzpPVZJlFJz8vA2AIstktrOj6KQu1iLftGmyF9\", \"L55ycDjsQFfEaK4e8YKu1Ro4bl16lpSwRxTClBojstiyVuWZd563CX8i3KgGDvql\"]','[\"JL0LurUeMBRj4E2sLAWk5DU7n2EZVGlYIxOcSoBbWcvlGUp85BvMfi9ZzhLrRLI0\", \"CQE99m1lxWs7eE3psGOAHhK76qFY3TRRJSHqf7DU4oJ5POUNVEEXDbiQcbAHc94k\"]','=3'), (5481.3066,'[\"WpG1FJ9s0mQxUroSQwQqbTjCiBX3qqZQJYAoYM9iHcD8mtQnMmrEgzIBym3aLbGl\", \"3465MXpWFsz5melXie6DA9Qc4dzhfOC2sDRqCPIjwG1bMsZLYlqtQqiTTBR4nJA7\", \"B1aeSotFvhGHRxxVqrVJiURmi8ZKwFa0K0Bokg581WnLVeyZqbJJKyIIk9v84P0H\"]','[\"nLypndaSuzKMFoQt4mwrOXqhJtlvRiRlRF3aKV8LaFV0N55znYbscWWitOfecHmg\"]','pU'), (2447.234,'[\"5xW3ErwvAnnNT7BTrmP7U0MCfEa3o66g6Z9dFSPqEeklLmxKTWrHljAeLwrcbGui\"]','[\"6Z06VZyRyVFNGiYc4tLwQLHa4UtZF2LqLpmMfAbtzMFc4NWS9mZCtvQHAfRs5nVi\", \"LhDyik13IixDbCSPq0Mze4PSutwG6HlPLpMvjyPM36kAliPZ9AvVfsHbiwJHMfVI\", \"ooFi4W7qcG80A3RrXNifHIFJYhOGo4dlpQDV2BbtZet9tWNIaTQSIlE15XAdg0pc\", \"tluB0ZEnjqImtSEkTg9JYlUB3dM0JPoKAyJw5iA0hKhOzwibWGQQI1JkI6vliJIp\", \"N1Qg4cvMOvrLQMJQFKuIzDZctNfOgbCAtGmM2teWyqqPuNBkcZr1XRUbwwzo5a2d\"]','&lnZvpYs'), (1892.9227,'[\"VTzYAWqsjRdbeg6OXtydYvZxsm0p48FQfYHgX7K815KnzSYn4v69gHgVauqbtQvR\", \"qDW8DxxLIxQenEhLQaF7LGinaKZaEXkBIlVpDspHPnR44suzhhP2QFw0H0Vh31Wu\", \"PgQ3VNG4cO8tDohjanVedDWsmmoyfzXn1N3oRuHHime2fk4SmYDjrZ8O9lgtdhUu\", \"4eWhttT9xTCIZgSulxvJb1pAIrwZmHcvn3bahJ7y6l41PxPKBKdFEhS8IY0OqIJ8\", \"jGiKKb2clwRXynMqjhnVBtJRQy4MFxkljDR7Fzq7WnOQdgclwOsso8z6rq9mfzRo\"]','[\"aqowE0pWJShaBNuguo1kJCXIaiOYP7YU7DjDkrfXEP6MS5vToQsUlyZGuWkpyyqA\", \"MTh1O6xUpTg7IpomRstSNCKPsqMOfuRVnu4L1Y0MZaTWWpTOh84ex9F95s9AJ2GJ\", \"kbRSLWudGMdtsHercAYenA3rQ3dh3SJDjP01Pf7ezHuBFaOcrTZ03MlIhJ3N5U8i\", \"OGiNNQJSlROTPDzf5wVzdlL3PIjgCuesFqRVgwHkayXiEhAoI2tPjsar5eWLNUv0\", \"1v9AQbtiHpiIdhHu9kKgfA5DbEj7DNCOCuyW9MYP6brklS0eAsrzdaYyCnA8k1YS\"]','rB*'), (1943.5444,'[\"7JVrWjJgowVPEK6fqSwHvwLfdkxn3bUGjnAjVspLD6rV9oT9yQfSIDSyZVAvptNu\"]','[\"IlspTtwm1famNJi4RlU3VA5uZ1VrWXVgUlmt3luMhdcjELJRcUTiXUEO0GswnZsE\", \"6aLUnEzL4OQ0pGvYW7LwfruK3Uq4P4LC50P0c7kEUjkfPtVY2lJymPHJWun6Y2MR\", \"qv9IyDtUdaELZ2ET0n66zuLuBSTEGk51SY1tHcj6mbHiTZGvCfIN8omDoHRhfBwr\", \"EisTEac0KisHRj3umRdmO3zwZL3IzcDoumJ0aToCn0qyUQIk7mk3AGmU7rz0fhB3\", \"elQQ3FvIPNFvfR7IEmFfhDsyfYuWCybfdA29aoEvkfy6E47zGdCckBroSzCtsBAx\"]','s'), (9426.224,'[\"HNnEDvzqjh6lF2NmXCWdlUBfIaVZjINDD1mp27RjnM8AYsbV7wMkQ59CMbSvs9HO\", \"OBDbz771XKMipkRbC2DjzxZ9pa1mFTkkritqfTSxO5UOeNiuiy5OLNDZSBdIz5On\"]','[\"twBEqCAjm1R99GGQT1JskoYikwRyJ3IZCDL2rgMJamCZDDsivGVYvu57wSNLmcLs\", \"J0QOpGxv4U7Odw4uFvd5LJVxQc3CcQXw8Q3kxmxDpLKfFnz6sgW5bK7IoXaCpYzQ\", \"nzEJiGNDzvbV1wU2PuNjEDLfeQZRYbNnWTDPb3s9kPkNhVfEPPTtK4jN6y0Mq0zP\", \"GCRntNIqtyrXg17TNdc8TiW12AsXrZDMaQHRt6U4Wh8ZpWvQ2fcTn8TXdNhfiMU7\", \"HZYeDGqMZrH1qup8wccUEXfKUfsbz645A2p6qxeOmACKjcXOB62TBLuCYNf5OpyJ\"]','vroIOao~MXNf'), (2880.339,'[\"86iU9bG9wcUM3PwmpYKi4ybRpE8Bk710jqvG9Yv0uiCmf8kHhJqZC03ajhfqAwhz\", \"YYe1xiYd0d6oGYHC4fGmY2Z7d9z8Mj3m2lWemwIcVaHXMa3FrjdX0mxEzo1Vm1Is\"]','[\"1kQ3MjBjbwqUjoZnaPW9mKzqrqsbZphIfs4XL11qXyokhVT70QSPgGogwn679Q4d\"]','_jrqC'), (5960.231,'[\"GGnno3UmyZOzhkKyWg1Pa1bSgtV3UipFaVhdvx8976XZ4wAPyQoe4xM16QEQZPjn\", \"UUzZp9rEHdDKVuG25Yt9QY6nAAeaS2LxVqWLdjCZDHzyr4uZIZPhbjrIP8yHy76O\", \"5MDrSRQSu9XUyg0HL4EgeqL0jnPh4cpbE32c1YT0PSOxjQawQVwzk8mu8BY9cV6k\"]','[\"UqitLrvjKkB4A8noOzMdLtBvMUbuusPQoo4EIwEBPLvpC5HEbTv14WoYqNUSA5U3\", \"TG1S1OsE8ESNXEFqtsGgPm6BQeiXNX9gBKPVEl5H2rkvZ3IZV8ejW4Lr3Y3AdPzq\"]','JUIDgA_1&_LLP0zs'), (4166.2383,'[\"acq5zfbaLOibqYlobipu3EuPEGb4v5V8yIkph0FTGwP81S4x92h27zedI5veBRn1\", \"OFjAIZjcEV9wNQqgqvAYgIEnjaxe4cBkSm2XNqrfQeBvn1N65URPCIFlYD4VjuwT\", \"CLQXCVVzwbpWhtYqRsv9Ngu0UTU04AtPR5AUwDHwCqytuMuRF1YJdwSt3K7TgAMN\", \"sC5x5hDCUL8jQrfAMa3wJWpIAgwYCC04bxgy5RfMl1TBcJ19booW9R7vb5TCOils\", \"HS24fs4ERcrQvLzNBdOMbPgEFc6gLr7WHe7zOgc2KSLF1vYPzS6cjvdvp5x8b20E\"]','[\"NuFdG4wko1jGZlczFCBD6WAsU3vmS2f04hQu9rgd4nLsNu8CMDU7huph6HqT8JWn\"]','E0ZN6B'), (3123.6172,'[\"jIgd5qSgFl8eaObFgsPD7j2wpxBduDx968b5porgEgRXfmHY2GNEGMgX5ZQsw2mC\", \"RIgJgm8nx4MvDKZzAUUcpyAUXwtlFH12uvDfD35PPdFbvaEmzlEUchjzXEqyukp4\", \"Q7b4N4VLuY22ZJlIDVbY86GTZNIsdHyGPTn5AXMWWZCPhaR89Kvw9zByaWQgZLoZ\"]','[\"9oHkL4Aj521qeuaKCSVXOMJ5w8YQzQ1b7tDZCD1wKI7L5BYKeMJvPZ4cWh2gJv7I\", \"Du4OQmjLO6I2Kr5yAA5aaLmj3RANiBQ2xBuzKSaNoysnMKFPiI6EVvZolNiTB4yg\", \"FU92uRj9OBIQc3EyuCsVzJHGRooWd3bp1RetfbxOl6oBDPeLQTYxUm25T34cmNrV\"]','&&l%jh0'), (4265.4927,'[\"sYe62jkjJFPSMBcysFfE3iq37jPbDLqOwzlIbeEMGau2Zlj2YGqUhIzJpMnxHe8E\", \"kF86omHgBCv2maNyaqgGr7FCXKrOoq56WMDUzag0AdOUX3re2hWUiPifPi7bUGP2\", \"K2O30BACYBrtAnk1ezxvNUybhQIHJP1rGGDFslnDHhHmuXkeH0EIgsasgRGOGMcs\"]','[\"3KjdstROFYCBt0S1DB2nJb4hnXpZSUn01aEoqN5y7TMijzv9Mmke1cmX1m50ouF7\", \"eFm3iGm8DTIy6n2DyYczLDPvPmZoXU3LXzfEc4DUjiUF4qXvtM2MnEnUFN8lskfH\", \"UdeBRvZ68qvaSW8nF1posW7Va6niPHXEl1RbcpsXaIqJqvHqqu8jzROYeHvwWrXv\"]','nZS%0&WpYB2L'), (3529.3848,'[\"AaTp63zeMxcDOpmAZCytphKSJQ0jrhfjJZQqpFGUxa714zPWQxgHAopexcvIL7yT\"]','[\"LRpCTPtvuI5DmEssDVjVOKd57QMwElX1CT3vFQNb0QrU53qfH4itBTvvZHunVexB\"]','rTx*&H'), (9290.619,'[\"xv1pukQI48hn055RB7E3OzZ2f17sklnSob2XIotlSv3x2f0YUh6xLo4wEuTqBp7b\", \"APYhXlf2cAMrOJMD7wLUAcJqpWQHW9YERWFEKQ90Ralhw8WiP4G1rDmlQpJUbQ7e\"]','[\"2YBFdXYZE4PNr5kVyH2Oov0gACTFAMhHbReL2LXxdOqsDZ0fNwgu9GUdoxpYhtIT\", \"7Maw5jOvf1CXVujwbLnTrfYNefAThB0C2RjAOhbFmgz7DQhOMwctc98AV7oEKFgf\", \"sup2E0JXFLpEgyBmeLRaacxqv889pkhsML34sXX89pOCGTY2QHRs7Ay3muiGsgTL\"]','OZsI0X57~5)GcXjY'), (1017.6303,'[\"MXfh8sOrrQDvtCpxW7VERbut3tf9lwnL2uY4nXRwigHhn84dTOWOJmu3I8pOlN9p\"]','[\"WSBZ3uhTiEKPrTeNq6a1ItQcr0aJK6vh0SbHcAcAW265mkczJyR6UgTsmmwM9SsC\", \"nJ5pgSso0nR9MCVWvUklfMiMwEzH2l98D4fPcOa6k2kKeFPqMYuAMr70tiDW586Q\"]','7S+Ojw*8*YuSicG'), (1629.144,'[\"73f3bVPxweKkN6qXK4PZ2liNYEmX0i8M5NyrNgsyv5bq8Fihz5Cag3UkiAMNMjyx\"]','[\"gxz2fWehNbMXO3aR6kI6biyUkuQlLls1W2kcHu64ziehPQIdhRy1MPIWG4wW6hvu\", \"VS7ZWzClFEulgGUsWkEdEeCQNEQoxAHrshFuT7mBZPu7JTLVYWoTc0443qaZ2yO2\", \"04gsa20aa9WHpqtM2C2gVkNSFqz8EEAeVqTajwwMRoeH3YpMo3PDf5Gg0uCZPHHn\", \"CIfwSvLLDD3nQCPyXKdKMoOaj7smpsdIynMdQSVHtSiIe5TdAyirSbUTZOSoO7Ur\", \"QNyzlpk7iQjGAEOPOBgqxJ5GRn7klkesVEknpTe2Gmytq3fr7YsSKd0MNRupp1Jr\"]','aA*EeK'), (3648.8384,'[\"kgpe47e7bDBPxGuUyfV0LhtODf5vNxsxbGOLNKdycatzuMYVCd1U5gt8QKVyeYag\", \"9SDMxVlXK75iz6ENbvVVDds0ToRHThO9zNER7d1K9x62wz8extfei9ka8QCjENCg\", \"TOM1l3IvHVUUH429h6GEE4phQJI2VrkUnzlMhveobRh9DjIq5V3GaqKiXBkhcOdr\"]','[\"by4GwYJrCLbhXD9ObbNjH9B6d28QRSKiYavVGufQm7F1c4naGCpREmOjt32r5yDx\"]','RORLHK-VOrB#+T&o_ef'), (4355.857,'[\"jrFfwdkB5SAea1MJ3DggDx5liGFXH1GysaCyRgItUIxgnQvna1N3HvBUori9kaAB\", \"PFaGvSOBuuqBmM4gW5gkcaJAqMH8PoWpB7NFYGEyN5TJunUB93BpDzMyswxoDtSz\", \"Jg35hMCJKoLaUhelyF8sy8oR9E1UUUNYU0CA8U0oMyFNIzlUl5IJzfXoT5SCZV9C\"]','[\"4ko3h13zVZiEPD5Ador1ePmqd37vAF3qMv2wUbsGXRBHuDbl3UrkW5RIIjUZp8Vj\", \"c7zazbWupBA775SA0PdFNpxjGACCjUWgIbsyNgp7vTCUuDo3UH27sxa68uom8eFf\", \"RD8iZShNuzy0PIUEJcvAvrbE8PsCTbzWf57qIa9DEbq17tImDhG3UEY5bpEbAZcd\", \"MHdT9UDDtW815EARjSQk74HzQBnufQET52ZvYhTnB4p6AHgpCKWGdu4CzG0K4xfY\", \"9WmTuFP4YgNSWhaTCRBZqobcHkwTUBSjNujTaAW0DTLvMzrhSkDECzSqlgaDHfhK\"]','C6fFX&1joH'), (4877.8203,'[\"ISVUzmPcKAzFSM0tmqSgQFQnVQQUVMRPAmT5gxpf51PeOfznthoCwLO8LGnrQN29\", \"hdOmO4RpML1t24Y7DUzMnbZbgsSw60nfyrjunWumIzGuCyhAJFRAkocKqHjwXnZL\", \"doqR4kzh6PqpgFyRpnRWGKqUmTQavGbUpmswn3xF4fq0HieCUC5QJG55ytDi14d9\"]','[\"8v1WZn3JTOAVfYNd3e0n0E16wvRh5bjd449mIZZjBGKulbuKo0RH5AasuW8IU18I\", \"oG7drC2lQqkDNX0NOWZI23G5AfV6krgvxudzJl4dvWWG6utc0xI8iDlaHtBYPZU0\", \"Eg1fbe2QBuTymEUAehC7A67b7xsshTmqjrP7w4JZISzMQczQJ4TzFBQgGRT96TmN\", \"46an8759myFy7HyRcRU2yzDrgemW6QPUWnob3siefGzL14Spfy3RzlxZljCnxdsg\"]','I0n_WE*BT~ofe^ZufZ'), (915.226,'[\"Inj73BtChLfAwdjBllGqkXoJ2YtsxNSzayXNvDH3e67ZPKkw8pllk6QPgY0aW9or\", \"xo4M5EAB2hxanDQk2aFiA3hBMpAu5MtAtYSDyalJ5P5mYLy3dNwCZ8kF0S7VZ6Z7\"]','[\"cNSnPRQS907iJdyGjoj8APaKRYkt9LDboqcN8j4BSUPfroy16m6t0UoMViCaF0oO\", \"XzE03SUmgcFVzZy50dtIiYETnIfD4xiLTgOxWrXSz9jpN3S4ZqgabjHCqktfcatV\", \"yN3r7tpNAJRSiabOGISp2iLGO1wk5rc3Cw6TVHKtzbygCabnaIY4e4Rzzq966fqh\", \"Z0y21Mrzv7rtsBDg3PoRbW9mBLx22AyS4VMMfZ1Aw9JorJFJ0ycFqVyGNJRx4gkI\"]','~KxJMwc@pQLC$aYt1'), (1806.7991,'[\"dXvjjWbrvF3YpAcJYxU1WV5pOLKHgnyXri8NahE0i5IfeDIfH4JIiIYA2F8sOUDM\", \"66AeToqojcP95ztJkwJb7sOTnK6AUXQjoMwaiAz7sDqNNw87yW7Va4q3Ze5P84Cg\", \"gleCYfdpv9ITioi1a4doWgppgTPL1lpf5jzUTSoqJ1RVmFJEmir05lEEw6xbuEpB\"]','[\"hx41EBK8u4uMukmSFVQcbwIeHC6cCLwLvoXn403llhgNirlPa7A1XLsNBz6ljEON\"]','X%G!PLUQ7'), (8696.62,'[\"ZRGYVXHWLgNzGscEjokb7zdEIdnhUjQRqimYDIqPYz8s92cPZpi1SiAYw6sHINqn\", \"QMUlUYePrDyP2mGuleSFEZousIyDqlwi41C7L1L01LzF86I0sCGFaLkOBKywtMey\", \"R0APc4bv5V2M3fJUOYTQwiPmiqABu5HvIJXGNlMwfkIFUPgF5YPhnzKTvEcjCbfE\"]','[\"9A1T1RQtGnpAQ2B4NodZPKKR519gQkigxdPE2AcT58xZ2ab0eKjiGjvLxldHOUCU\"]','e~J$K'), (5056.735,'[\"2ZaHCY8lDeSBmB1vIyqsbe2V0zXs4cwvt71BRVo0IOQOXSMqUuA4M7ooas72M3eg\", \"vaqq2DAwnhKKGMvUQVbOb6zwo8VqJd3MplwHm3cDYrcDFk3YzU4U3SIfZ6RfEIS8\", \"q0EZIEBYUxNUODmWZWAe1S9mFJoaBzZtALkuoTILBFhirLgiCjYnFZlFP3J7jGpt\", \"Raot4K7hM3dhVwGDALoiixFlcPCmfEMkA7rWtrGXUz6g61qb7puer4hBEnkGH63Y\", \"YTLZCfLVzDW5CGEVxhdESfLTe4vLEj7T6J3mRrPRP6KhtyVGxXoEsnyyO8xvuz6U\"]','[\"pzQ0eZHO7PQVTdBVWvE9EQ2YQ9BAVBko5FhmyX0aJAsOyZVphDzEadqULpILEZHy\", \"5wsa74cwPOt5fLPHyN9gaHtmIYBa9QPJx1zXjbOTha65RfqX9RJhSV9kATmHwDoF\", \"X2mNT7z2RG0dZ6kYl5Z5NXDNDwP6R23XMperj3P12dnV2XdLkNHW2si7fP9eSqwl\", \"W7Kr7IP7YQbwWZQg3lXm1m5zKgPk2vsBHDA61R7qDao9gSbg0A7VimETSwSNeEws\", \"8aoKNYT9i4FqH0eEVnb5wJ2E1T5yXLP6LOs4RlpjnDgxs8TBJIH6coihThZeM279\"]','RhG0M%');

SELECT `teef726a5`.`col_94` AS `r0` FROM `tdbe45f5c` JOIN `teef726a5` ON `tdbe45f5c`.`col_96`=`teef726a5`.`col_95` WHERE `teef726a5`.`col_95`='' AND NOT (6252179388429456273 MEMBER OF (`tdbe45f5c`.`col_98`));

2. What did you expect to see? (Required)

mysql> SELECT `teef726a5`.`col_94` AS `r0`, col_98 FROM `tdbe45f5c` use index() JOIN `teef726a5` ON `tdbe45f5c`.`col_96`=`teef726a5`.`col_95` WHERE `teef726a5`.`col_95`='' AND NOT (6252179388429456273 MEMBER OF (`tdbe45f5c`.`col_98`));
+----------------------------------------------------------------------+-----------------------------------------------------------------+
| r0                                                                   | col_98                                                          |
+----------------------------------------------------------------------+-----------------------------------------------------------------+
| ["xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI"] | [7393958735679057686, 5418784868165549355, 4911356181212311562] |
+----------------------------------------------------------------------+-----------------------------------------------------------------+
1 row in set (0.01 sec)

3. What did you see instead (Required)

mysql> SELECT `teef726a5`.`col_94` AS `r0` FROM `tdbe45f5c` JOIN `teef726a5` ON `tdbe45f5c`.`col_96`=`teef726a5`.`col_95` WHERE `teef726a5`.`col_95`='' AND NOT (6252179388429456273 MEMBER OF (`tdbe45f5c`.`col_98`));
+----------------------------------------------------------------------+
| r0                                                                   |
+----------------------------------------------------------------------+
| ["xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI"] |
| ["xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI"] |
| ["xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI"] |
+----------------------------------------------------------------------+
3 rows in set (0.00 sec)

4. What is your TiDB version? (Required)

56c619f
@wjhuang2016 wjhuang2016 added type/bug This issue is a bug. fuzz/randomtest labels Jan 12, 2024
@seiya-annie seiya-annie added sig/planner SIG: Planner and removed sig/sql-infra SIG: SQL Infra labels Jan 13, 2024
@AilinKid AilinKid self-assigned this Jan 14, 2024
@AilinKid
Copy link
Contributor

AilinKid commented Jan 15, 2024 •
edited

in master version

image

insert data missed? I couldn't reproduce what your paste above

mysql: 
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.31    |
+-----------+
1 row in set (0.01 sec)

mysql> INSERT INTO `teef726a5` VALUES (7818.12,'[\"D4TPSt7NTkgn7ntmrOSJSnyhRmN2UHhVK04vecPJ4IkmVTBIGVwT64f95dCJG2HZ\", \"nxDagX5al5jW5GOB40LDc4svRzhB1hwzDczrqi9ej2iZBI8K1GWWaBU8iHrsyRfE\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','*iw=WC5BNiJ1Y6j_7)'), (7818.12,'[\"D4TPSt7NTkgn7ntmrOSJSnyhRmN2UHhVK04vecPJ4IkmVTBIGVwT64f95dCJG2HZ\", \"nxDagX5al5jW5GOB40LDc4svRzhB1hwzDczrqi9ej2iZBI8K1GWWaBU8iHrsyRfE\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','-hYgRwL)5#QDo&v'), (7818.12,'[\"2uE21PG636uMpCGRc6mlBWabfrL8dHeCwOnQNc69Dtf9K9OSHW95Ul2j9YEZrHZ3\", \"5n1ernJau4itsEj1kpfWAqzhv74lpfFJFwFvWLqEyhlyEq47GGY8j3EMeTepdUlv\", \"gGZR0n9VhS6d18DxlmEWSjtrf85opeG1Rd2cFwJl6hiRQoW2HbTgw1tmNO3dkirJ\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]',''), (7818.12,'[\"VhRbd4QE5vVJzEn8TmaCeNhUyLHkZGgyJukl1l2388mey4u3JZKhYHUNyVE08XYg\", \"HqqQN58cN79iAQOU6mk3JgIDhvbCWpeIjoEo0HnBPTpos4yPbkgjtxRWedVRvVNs\", \"uPiRicFuBfbMFUUlr7a7RL397b4x9bxF3tVEEoeAbDNy2Lt8tDplLHRPfCpu9mN7\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','!LU1~iU3sMb$=o('), (7818.12,'[\"XdyWqdXLMPZhJYI9Nldr537EkCylKwZNskPkR0SGBW4dyNesjMqXufdIet3RmRrS\", \"Haav1rw7BNq6HsQMBcjK23otT4MwIoSgmYe8fc78q2da67byEFoDfKaOqlgBjMjW\", \"zsRLI41pK7w8bf7eQGjXx70EbC4wuVYUZ3CLq1wQdF9RNmoEzP1wlGs09INw8H6n\", \"Mj8r5U0n0HGwOwrrqTCiwXohxCEWsLR2H1WdcfEeGMaFvCm7IPyuUbDlsI01d7RQ\", \"mRW6WGFSfZNH8pBnLyOGWRAXz0LCeNrju34o3I72m5TnzjL0l48o4RpYVJOTYNCE\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','(YDoG#q-'), (7818.12,'[\"AfT6ld4iHfyTyu3DPw9xP5Uq9XQ0OGe4bss1mzizjWAsYvbCVbpxxxf16BqkfuWj\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','IUaM$#)OnTs2'), (1341.5392,'[\"2iVoTyJ9hIbKRhKkMOdFVvIIysgfnOb159ArOJBu7pNMWOjRaeigUWpo01vOLEUg\", \"GinfXtCSbBhr2MAKHbiScTA2iHsO5FaEzmDg0Saf2W75l701hrYQ2sgiSAaVzoKA\", \"q87U212KqvXWVrSlqsEha1fJPsX9FolQ8hWwdTLAw57Z2vhtoaGJDdVDYMtPB8bp\", \"RHLr4zTSUPyySmuHCNdBqad5RHmEl1W5RtG8l0sp0Uf6yPfOz6cLxomeM15PXmEh\", \"RXJBuWBwzLhy9WAmI8YXec7mAs3RNe1GLJOHEdjJpScAcCmVDolzgk9yAgtDOjUk\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','sV1X#QVQ'), (3981.2578,'[\"2OJvdhSdpZmHlTl85w9eldJ4EB8PXzbHae5P0f51qoM3q3EnjF6CuygTd9xlsxo0\", \"O9o63G3ep6bH2F4ortJiGAYImyIHEA3Bw2W1Fl4JZsDTgpVm3XZ5G2nTZLi0IvdN\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','2R'), (1385.8489,'[\"9FngF5xhg7sFFNRsmPysIxhIwZgaVPt6d4SRkdtefJskvzIV1bwtiOEzzdiv5kSb\", \"VHBsM245QEt6LgvnynvsKFEfkOKxHGHF8DqKseGKPSI4vaV24iWLCt7xKrng7Q4Q\", \"zMgC7U53xPwnytYJfB1FdujuSiPmt0Z8VkYAmpVfxXocIs8FxwaxWqncSKAgbjE9\", \"EyWXa5EFKeHQAs9NCcGUgYgYpEJ1JiwOZLGA9W0EqGABDujuCUwaZC8Nn0KWAvMB\", \"dE1DMK4zsViAAYQyAjTcZc0S2jYUdiCMcJqjCGQsI7wV6TDRCxSsOeJxoMe96hE6\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','F$vTOK^DH~'), (4690.9023,'[\"P8LoCL0X3tg11Lbb5HiIMEZ4TRztUe4pzC4iMkfUwFKz3uu2kkcpGHas6KdTxbVz\", \"R1thmJKG6xLh8PtDcsAIawbk5iRCZmfTgSJ982hujptXa9jjgtcbzmL0AF3qADXP\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','SKn6L+J(Fnw'), (3582.79,'[\"4vOWNUCIJgsytBsFVfroJOI33X19WpC0bLIHt9JnO7jDLKmQiC69mLtrseCC87RI\", \"hGIRIiuJYDIEjadHrVA6NfhdMAdsPk8u2IKofijXGz3ppi1MrJj0tC9ZvXOqO2wi\", \"2M2p6FCNUJJCA7YNvxjiZjHpYhwVWVPeCr2kZm9skf8qFITuoxg5ge7215Sgjnvt\", \"3Z5WUQkAZkAmpDlcDkFQD09FIn9XRpAFcf1NqMdQQwd5o6Rko5oniLRniLCjZVsD\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','9ox'), (3011.0894,'[\"Z9IUHtRUG1PO889tUcPQGmWoEVeSYcV1lO0vgvmHGWJCOfArBtYiLzD34BCghLsX\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','Hrs$@JrezMcU_J+'), (4509.584,'[\"yVIJasgHAZgPS2gDlwHOnnWk5kjaTxNprIE5p7qecQafvNik5U6eTo34JrjZrxx4\", \"xjueNPFGM3j0S9JlVHhJPO1cdXRMSDbONgzXeHyCxXH55c9Rr5FVwoZyxT9iUVPm\", \"CqPYQZba6OhV9nZH04uRElKmraZia8VYshkXpIPJKkxarKKz3J07F9XPUuLUa9Vg\", \"apF3DDfMDPMo8W7Wesua1XCWmNJjIvEFFkbZpmcPHxyMHAtzkTvBTHzsVqznEYAm\", \"n3DMxhoA2IUWlnnsS9HrSVP5b5jjPU7PAehyHAN6y1YaRwleUmPGIvnHu9touc6j\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','Td@fSOTkg-j'), (4512.079,'[\"J3T6UmTjER2A4b3BmZj2pLwXFtDQuhNSPA1wyres22dzap43m1Vjpaq7DQ4zmf6q\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','0q-#%rvh79J='), (8343.3545,'[\"S71mQdLAR9xFrkEKNxNreuTSSOvQX8JzCNGZoGJgc9PRkEu029DJWBpjZcwGjZjG\", \"04dUV3YUDsIcxQyqaoQLhsEEFU7LjDtVNSLjWjuGTEt6LqDsc2djp1eRCgEQMbUc\", \"4gnYGSTRrXmrOQozgJiSflerQNRz0XjknjP0fV8UqG2lnbOSQnoM0T4qB586mLxQ\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','fG'), (6131.9585,'[\"LJfOoBQyMb31S4IhMSMyXvTLrHEKzA7lqNrJO6m9KM44vbqNraqHMnYVEAsFuKi8\", \"4TSgrl9nAqB9bQHuzdZ9n1Zb88I0TZ8r8AhXvjzM19IJsaDNGlN1gy7qf2XHht43\", \"ZxitEuF1oeLP5KYbdjI3EGuZ2PlaxLtQidWP943YSU9cDRzg7sFtPDoOn9mBHoaI\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','u-0G'), (6812.7246,'[\"ODTT9SD7SVBAQqxiXqWF8qhM6MkctLVlCTmbrj5BkkWTsYpeTAk4hWQYA9AqbnMK\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','B163%wAXY'), (5492.353,'[\"rvpnAbAMyUTAI4yMHma1KZFAJfT6ScqEHotvZX7hUxdIMFfwMQDsCAlHDiwrTM9h\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','fRBQagU18'), (1512.0317,'[\"8TKFguOnHMinOURwwc8S06JXEfLIy5sChav8CL0vnYEtgPtkrB0L8gKLe6ioNkjG\", \"dwKVJpcwO4MFjd5bxh9xLoqPcMbMGbePNUH0gcejKi1setbwY0InlLzvfbVERoiE\", \"mtC1UGSxZaOeqOs1zzQAzXU8dvE5yVItaaE90qsr2XGslzismcJ5Ti1fzlH3OUe4\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','QLi3sfhf&8Vp)4'), (4065.6995,'[\"ODWkbLmNIVnc6hRH2OVOc2Hqm2nON0HOFsRmION89hrmYZcsyw1gYwssjck9i559\", \"IOAyX1UssSQWc845COH1M06uuquoxooSCf9jD1YOjPvUpb40Z3xYtDN4N1i44Iqd\", \"x1EKoDAydeDsCIVzn5uKVnw3HWKY4u6pUfMtf0ujxETx10DXT6zpKxztVKG1kZow\", \"qnczZOASDPfCvnOOcvk1X24lgcs4qoMMrefgw29PPc6pk87HDraXznAbUSAdR6hO\", \"N0uZ8J14jSNzhrnUdFiYQeD3PFL6x5WUX9PP1tS38A8i1W4rCYcT2jPyadGuR3kq\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','mf-k*+-Q@ItxkTyUHlY'), (4739.278,'[\"KnDssKz5oE2mkxyVPRn77JBh0NIwFhVgXl3l066L786B0CrVUESyupof1imYPvr2\", \"hVf2X4c1oUDBu0KF8o2HLV7uVDkNNAByqpDmRE0VZBnbXSFw8JDWOufEwjpQ26e1\", \"ae3Uhwf6TJKM0FbXflvKDRRmGdrONo7tHbNH0tab5gJuECTzMfHPtgjla22Xk7C9\", \"6zqbmHn2q1QIHhNmSAwP54CqiCnOAQwDkTscheIozr7RnzZPKP5eWAVSY5EFrdfJ\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','j~0@bLfS1U04E3I'), (8780.668,'[\"2y80bH9hIsGSBhuHhDcFDoI4wQtaiSI0d90jlEjBe21TqeOiXodTa0DWqJZA0es3\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','569'), (30.489977,'[\"maEjfaLtCvtJU9Ve8VXHazF2WRFjazcIJO6cfTc0PIQwsJKGKIHr25w9xRfmzSZa\", \"VvyRLdS0aSlgDiuGFt1IZl5o0F8btF2SofZJVBgyCSQvWuwk8tX74TsXfGsoYK0o\", \"EWXRIvN7J6hLBwnhS7M6xTu8y4YlUKO9hTxwZPRd2toiXEQSIFqJXKwj5ceJXeWq\", \"UQV2nOPpiZNYVxpB6LGg6Hpv1gwOw2sIrjAKETGeliAQjkkSuKaumcHQVQ3Md1Gv\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','Mf~a=H~Qu(f+8Jpl&X'), (9307.473,'[\"DpxftSwCiNd5ILGECZkU5VxQa9yD94ASBKcQF9fOKBMAzbg8Ojx8VnMIDIXU8CMK\", \"vIAKIbNr1LDJfCGIsl9JY3w4rV1Iy4Nw6IbfiKO2aWBO3egLxGO333omVhXTI7q6\"]','[\"xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI\"]','uW7-jdiQbn#'), (6410.3096,'[\"L3EreDFNfgneM25yz59N4iCYeL8Z9py1umCA4PPl9AwbQ5RFlgYvG97b3QJezKJ1\", \"2NeDZOluO7ohp2XKXtxDb4InnExHheZxzcpfu1V8UZIbJlqNBobeZ36OqjJk1RED\", \"9AvUWo5aiFI6ApK0bcq26YnGyYxNc2sgHYHs3kAqy75PTPcStAyfDvMTb65fL7IJ\"]','[\"snvI6zcokWYv4JcUVN6Lo76xytHrsswaoeIttSCOIOO0wHMcHMeyGa12qyLW3Pbq\", \"RetKYHeRnCHkG5o2UuY9ZaPAKFlUfsa2GQznZKhUScQO4qK8ECAI06RCuXh16hVg\", \"5GuoXbvqWhQYfBlFiqWLcvx59UqlOxgJrfrjn6oraPAQnSd1xzyq3zlvaFYbBzMM\", \"RxdxLBnLeLJhMzIilwBCnuGahMynYprdEpqh36LG2cplfLmqG32wEL6xsgthio9x\", \"25LzYFSa548IsoVz0V7uQ1LOcYklBCyFjro26dtQsrGNbYMWqhN4mNPwgmsEKcUH\"]','SYt3tKvf+c'), (281.3734,'[\"l8YaSwJ28Iw5NQuICF3dfJQ3HRSGi1ODk1Ds43jBgwZxCrjhSSsoLQh5iGVWZ2aJ\", \"0uEVU0GTCyD2w5LQiLFz0SYvicA0TlzdYNfQx61qZFR0k69KjwBmWNDRl2T1IfMY\", \"o49AQ45FsasqLev7KUIdHLwkQQbtrUXYoBZC4JkhPfl0DfN6NF8AN8smLxb6Pr7B\", \"L0hTSCxQv2NIMAOViaXVSr9iSdwzpPVZJlFJz8vA2AIstktrOj6KQu1iLftGmyF9\", \"L55ycDjsQFfEaK4e8YKu1Ro4bl16lpSwRxTClBojstiyVuWZd563CX8i3KgGDvql\"]','[\"JL0LurUeMBRj4E2sLAWk5DU7n2EZVGlYIxOcSoBbWcvlGUp85BvMfi9ZzhLrRLI0\", \"CQE99m1lxWs7eE3psGOAHhK76qFY3TRRJSHqf7DU4oJ5POUNVEEXDbiQcbAHc94k\"]','=3'), (5481.3066,'[\"WpG1FJ9s0mQxUroSQwQqbTjCiBX3qqZQJYAoYM9iHcD8mtQnMmrEgzIBym3aLbGl\", \"3465MXpWFsz5melXie6DA9Qc4dzhfOC2sDRqCPIjwG1bMsZLYlqtQqiTTBR4nJA7\", \"B1aeSotFvhGHRxxVqrVJiURmi8ZKwFa0K0Bokg581WnLVeyZqbJJKyIIk9v84P0H\"]','[\"nLypndaSuzKMFoQt4mwrOXqhJtlvRiRlRF3aKV8LaFV0N55znYbscWWitOfecHmg\"]','pU'), (2447.234,'[\"5xW3ErwvAnnNT7BTrmP7U0MCfEa3o66g6Z9dFSPqEeklLmxKTWrHljAeLwrcbGui\"]','[\"6Z06VZyRyVFNGiYc4tLwQLHa4UtZF2LqLpmMfAbtzMFc4NWS9mZCtvQHAfRs5nVi\", \"LhDyik13IixDbCSPq0Mze4PSutwG6HlPLpMvjyPM36kAliPZ9AvVfsHbiwJHMfVI\", \"ooFi4W7qcG80A3RrXNifHIFJYhOGo4dlpQDV2BbtZet9tWNIaTQSIlE15XAdg0pc\", \"tluB0ZEnjqImtSEkTg9JYlUB3dM0JPoKAyJw5iA0hKhOzwibWGQQI1JkI6vliJIp\", \"N1Qg4cvMOvrLQMJQFKuIzDZctNfOgbCAtGmM2teWyqqPuNBkcZr1XRUbwwzo5a2d\"]','&lnZvpYs'), (1892.9227,'[\"VTzYAWqsjRdbeg6OXtydYvZxsm0p48FQfYHgX7K815KnzSYn4v69gHgVauqbtQvR\", \"qDW8DxxLIxQenEhLQaF7LGinaKZaEXkBIlVpDspHPnR44suzhhP2QFw0H0Vh31Wu\", \"PgQ3VNG4cO8tDohjanVedDWsmmoyfzXn1N3oRuHHime2fk4SmYDjrZ8O9lgtdhUu\", \"4eWhttT9xTCIZgSulxvJb1pAIrwZmHcvn3bahJ7y6l41PxPKBKdFEhS8IY0OqIJ8\", \"jGiKKb2clwRXynMqjhnVBtJRQy4MFxkljDR7Fzq7WnOQdgclwOsso8z6rq9mfzRo\"]','[\"aqowE0pWJShaBNuguo1kJCXIaiOYP7YU7DjDkrfXEP6MS5vToQsUlyZGuWkpyyqA\", \"MTh1O6xUpTg7IpomRstSNCKPsqMOfuRVnu4L1Y0MZaTWWpTOh84ex9F95s9AJ2GJ\", \"kbRSLWudGMdtsHercAYenA3rQ3dh3SJDjP01Pf7ezHuBFaOcrTZ03MlIhJ3N5U8i\", \"OGiNNQJSlROTPDzf5wVzdlL3PIjgCuesFqRVgwHkayXiEhAoI2tPjsar5eWLNUv0\", \"1v9AQbtiHpiIdhHu9kKgfA5DbEj7DNCOCuyW9MYP6brklS0eAsrzdaYyCnA8k1YS\"]','rB*'), (1943.5444,'[\"7JVrWjJgowVPEK6fqSwHvwLfdkxn3bUGjnAjVspLD6rV9oT9yQfSIDSyZVAvptNu\"]','[\"IlspTtwm1famNJi4RlU3VA5uZ1VrWXVgUlmt3luMhdcjELJRcUTiXUEO0GswnZsE\", \"6aLUnEzL4OQ0pGvYW7LwfruK3Uq4P4LC50P0c7kEUjkfPtVY2lJymPHJWun6Y2MR\", \"qv9IyDtUdaELZ2ET0n66zuLuBSTEGk51SY1tHcj6mbHiTZGvCfIN8omDoHRhfBwr\", \"EisTEac0KisHRj3umRdmO3zwZL3IzcDoumJ0aToCn0qyUQIk7mk3AGmU7rz0fhB3\", \"elQQ3FvIPNFvfR7IEmFfhDsyfYuWCybfdA29aoEvkfy6E47zGdCckBroSzCtsBAx\"]','s'), (9426.224,'[\"HNnEDvzqjh6lF2NmXCWdlUBfIaVZjINDD1mp27RjnM8AYsbV7wMkQ59CMbSvs9HO\", \"OBDbz771XKMipkRbC2DjzxZ9pa1mFTkkritqfTSxO5UOeNiuiy5OLNDZSBdIz5On\"]','[\"twBEqCAjm1R99GGQT1JskoYikwRyJ3IZCDL2rgMJamCZDDsivGVYvu57wSNLmcLs\", \"J0QOpGxv4U7Odw4uFvd5LJVxQc3CcQXw8Q3kxmxDpLKfFnz6sgW5bK7IoXaCpYzQ\", \"nzEJiGNDzvbV1wU2PuNjEDLfeQZRYbNnWTDPb3s9kPkNhVfEPPTtK4jN6y0Mq0zP\", \"GCRntNIqtyrXg17TNdc8TiW12AsXrZDMaQHRt6U4Wh8ZpWvQ2fcTn8TXdNhfiMU7\", \"HZYeDGqMZrH1qup8wccUEXfKUfsbz645A2p6qxeOmACKjcXOB62TBLuCYNf5OpyJ\"]','vroIOao~MXNf'), (2880.339,'[\"86iU9bG9wcUM3PwmpYKi4ybRpE8Bk710jqvG9Yv0uiCmf8kHhJqZC03ajhfqAwhz\", \"YYe1xiYd0d6oGYHC4fGmY2Z7d9z8Mj3m2lWemwIcVaHXMa3FrjdX0mxEzo1Vm1Is\"]','[\"1kQ3MjBjbwqUjoZnaPW9mKzqrqsbZphIfs4XL11qXyokhVT70QSPgGogwn679Q4d\"]','_jrqC'), (5960.231,'[\"GGnno3UmyZOzhkKyWg1Pa1bSgtV3UipFaVhdvx8976XZ4wAPyQoe4xM16QEQZPjn\", \"UUzZp9rEHdDKVuG25Yt9QY6nAAeaS2LxVqWLdjCZDHzyr4uZIZPhbjrIP8yHy76O\", \"5MDrSRQSu9XUyg0HL4EgeqL0jnPh4cpbE32c1YT0PSOxjQawQVwzk8mu8BY9cV6k\"]','[\"UqitLrvjKkB4A8noOzMdLtBvMUbuusPQoo4EIwEBPLvpC5HEbTv14WoYqNUSA5U3\", \"TG1S1OsE8ESNXEFqtsGgPm6BQeiXNX9gBKPVEl5H2rkvZ3IZV8ejW4Lr3Y3AdPzq\"]','JUIDgA_1&_LLP0zs'), (4166.2383,'[\"acq5zfbaLOibqYlobipu3EuPEGb4v5V8yIkph0FTGwP81S4x92h27zedI5veBRn1\", \"OFjAIZjcEV9wNQqgqvAYgIEnjaxe4cBkSm2XNqrfQeBvn1N65URPCIFlYD4VjuwT\", \"CLQXCVVzwbpWhtYqRsv9Ngu0UTU04AtPR5AUwDHwCqytuMuRF1YJdwSt3K7TgAMN\", \"sC5x5hDCUL8jQrfAMa3wJWpIAgwYCC04bxgy5RfMl1TBcJ19booW9R7vb5TCOils\", \"HS24fs4ERcrQvLzNBdOMbPgEFc6gLr7WHe7zOgc2KSLF1vYPzS6cjvdvp5x8b20E\"]','[\"NuFdG4wko1jGZlczFCBD6WAsU3vmS2f04hQu9rgd4nLsNu8CMDU7huph6HqT8JWn\"]','E0ZN6B'), (3123.6172,'[\"jIgd5qSgFl8eaObFgsPD7j2wpxBduDx968b5porgEgRXfmHY2GNEGMgX5ZQsw2mC\", \"RIgJgm8nx4MvDKZzAUUcpyAUXwtlFH12uvDfD35PPdFbvaEmzlEUchjzXEqyukp4\", \"Q7b4N4VLuY22ZJlIDVbY86GTZNIsdHyGPTn5AXMWWZCPhaR89Kvw9zByaWQgZLoZ\"]','[\"9oHkL4Aj521qeuaKCSVXOMJ5w8YQzQ1b7tDZCD1wKI7L5BYKeMJvPZ4cWh2gJv7I\", \"Du4OQmjLO6I2Kr5yAA5aaLmj3RANiBQ2xBuzKSaNoysnMKFPiI6EVvZolNiTB4yg\", \"FU92uRj9OBIQc3EyuCsVzJHGRooWd3bp1RetfbxOl6oBDPeLQTYxUm25T34cmNrV\"]','&&l%jh0'), (4265.4927,'[\"sYe62jkjJFPSMBcysFfE3iq37jPbDLqOwzlIbeEMGau2Zlj2YGqUhIzJpMnxHe8E\", \"kF86omHgBCv2maNyaqgGr7FCXKrOoq56WMDUzag0AdOUX3re2hWUiPifPi7bUGP2\", \"K2O30BACYBrtAnk1ezxvNUybhQIHJP1rGGDFslnDHhHmuXkeH0EIgsasgRGOGMcs\"]','[\"3KjdstROFYCBt0S1DB2nJb4hnXpZSUn01aEoqN5y7TMijzv9Mmke1cmX1m50ouF7\", \"eFm3iGm8DTIy6n2DyYczLDPvPmZoXU3LXzfEc4DUjiUF4qXvtM2MnEnUFN8lskfH\", \"UdeBRvZ68qvaSW8nF1posW7Va6niPHXEl1RbcpsXaIqJqvHqqu8jzROYeHvwWrXv\"]','nZS%0&WpYB2L'), (3529.3848,'[\"AaTp63zeMxcDOpmAZCytphKSJQ0jrhfjJZQqpFGUxa714zPWQxgHAopexcvIL7yT\"]','[\"LRpCTPtvuI5DmEssDVjVOKd57QMwElX1CT3vFQNb0QrU53qfH4itBTvvZHunVexB\"]','rTx*&H'), (9290.619,'[\"xv1pukQI48hn055RB7E3OzZ2f17sklnSob2XIotlSv3x2f0YUh6xLo4wEuTqBp7b\", \"APYhXlf2cAMrOJMD7wLUAcJqpWQHW9YERWFEKQ90Ralhw8WiP4G1rDmlQpJUbQ7e\"]','[\"2YBFdXYZE4PNr5kVyH2Oov0gACTFAMhHbReL2LXxdOqsDZ0fNwgu9GUdoxpYhtIT\", \"7Maw5jOvf1CXVujwbLnTrfYNefAThB0C2RjAOhbFmgz7DQhOMwctc98AV7oEKFgf\", \"sup2E0JXFLpEgyBmeLRaacxqv889pkhsML34sXX89pOCGTY2QHRs7Ay3muiGsgTL\"]','OZsI0X57~5)GcXjY'), (1017.6303,'[\"MXfh8sOrrQDvtCpxW7VERbut3tf9lwnL2uY4nXRwigHhn84dTOWOJmu3I8pOlN9p\"]','[\"WSBZ3uhTiEKPrTeNq6a1ItQcr0aJK6vh0SbHcAcAW265mkczJyR6UgTsmmwM9SsC\", \"nJ5pgSso0nR9MCVWvUklfMiMwEzH2l98D4fPcOa6k2kKeFPqMYuAMr70tiDW586Q\"]','7S+Ojw*8*YuSicG'), (1629.144,'[\"73f3bVPxweKkN6qXK4PZ2liNYEmX0i8M5NyrNgsyv5bq8Fihz5Cag3UkiAMNMjyx\"]','[\"gxz2fWehNbMXO3aR6kI6biyUkuQlLls1W2kcHu64ziehPQIdhRy1MPIWG4wW6hvu\", \"VS7ZWzClFEulgGUsWkEdEeCQNEQoxAHrshFuT7mBZPu7JTLVYWoTc0443qaZ2yO2\", \"04gsa20aa9WHpqtM2C2gVkNSFqz8EEAeVqTajwwMRoeH3YpMo3PDf5Gg0uCZPHHn\", \"CIfwSvLLDD3nQCPyXKdKMoOaj7smpsdIynMdQSVHtSiIe5TdAyirSbUTZOSoO7Ur\", \"QNyzlpk7iQjGAEOPOBgqxJ5GRn7klkesVEknpTe2Gmytq3fr7YsSKd0MNRupp1Jr\"]','aA*EeK'), (3648.8384,'[\"kgpe47e7bDBPxGuUyfV0LhtODf5vNxsxbGOLNKdycatzuMYVCd1U5gt8QKVyeYag\", \"9SDMxVlXK75iz6ENbvVVDds0ToRHThO9zNER7d1K9x62wz8extfei9ka8QCjENCg\", \"TOM1l3IvHVUUH429h6GEE4phQJI2VrkUnzlMhveobRh9DjIq5V3GaqKiXBkhcOdr\"]','[\"by4GwYJrCLbhXD9ObbNjH9B6d28QRSKiYavVGufQm7F1c4naGCpREmOjt32r5yDx\"]','RORLHK-VOrB#+T&o_ef'), (4355.857,'[\"jrFfwdkB5SAea1MJ3DggDx5liGFXH1GysaCyRgItUIxgnQvna1N3HvBUori9kaAB\", \"PFaGvSOBuuqBmM4gW5gkcaJAqMH8PoWpB7NFYGEyN5TJunUB93BpDzMyswxoDtSz\", \"Jg35hMCJKoLaUhelyF8sy8oR9E1UUUNYU0CA8U0oMyFNIzlUl5IJzfXoT5SCZV9C\"]','[\"4ko3h13zVZiEPD5Ador1ePmqd37vAF3qMv2wUbsGXRBHuDbl3UrkW5RIIjUZp8Vj\", \"c7zazbWupBA775SA0PdFNpxjGACCjUWgIbsyNgp7vTCUuDo3UH27sxa68uom8eFf\", \"RD8iZShNuzy0PIUEJcvAvrbE8PsCTbzWf57qIa9DEbq17tImDhG3UEY5bpEbAZcd\", \"MHdT9UDDtW815EARjSQk74HzQBnufQET52ZvYhTnB4p6AHgpCKWGdu4CzG0K4xfY\", \"9WmTuFP4YgNSWhaTCRBZqobcHkwTUBSjNujTaAW0DTLvMzrhSkDECzSqlgaDHfhK\"]','C6fFX&1joH'), (4877.8203,'[\"ISVUzmPcKAzFSM0tmqSgQFQnVQQUVMRPAmT5gxpf51PeOfznthoCwLO8LGnrQN29\", \"hdOmO4RpML1t24Y7DUzMnbZbgsSw60nfyrjunWumIzGuCyhAJFRAkocKqHjwXnZL\", \"doqR4kzh6PqpgFyRpnRWGKqUmTQavGbUpmswn3xF4fq0HieCUC5QJG55ytDi14d9\"]','[\"8v1WZn3JTOAVfYNd3e0n0E16wvRh5bjd449mIZZjBGKulbuKo0RH5AasuW8IU18I\", \"oG7drC2lQqkDNX0NOWZI23G5AfV6krgvxudzJl4dvWWG6utc0xI8iDlaHtBYPZU0\", \"Eg1fbe2QBuTymEUAehC7A67b7xsshTmqjrP7w4JZISzMQczQJ4TzFBQgGRT96TmN\", \"46an8759myFy7HyRcRU2yzDrgemW6QPUWnob3siefGzL14Spfy3RzlxZljCnxdsg\"]','I0n_WE*BT~ofe^ZufZ'), (915.226,'[\"Inj73BtChLfAwdjBllGqkXoJ2YtsxNSzayXNvDH3e67ZPKkw8pllk6QPgY0aW9or\", \"xo4M5EAB2hxanDQk2aFiA3hBMpAu5MtAtYSDyalJ5P5mYLy3dNwCZ8kF0S7VZ6Z7\"]','[\"cNSnPRQS907iJdyGjoj8APaKRYkt9LDboqcN8j4BSUPfroy16m6t0UoMViCaF0oO\", \"XzE03SUmgcFVzZy50dtIiYETnIfD4xiLTgOxWrXSz9jpN3S4ZqgabjHCqktfcatV\", \"yN3r7tpNAJRSiabOGISp2iLGO1wk5rc3Cw6TVHKtzbygCabnaIY4e4Rzzq966fqh\", \"Z0y21Mrzv7rtsBDg3PoRbW9mBLx22AyS4VMMfZ1Aw9JorJFJ0ycFqVyGNJRx4gkI\"]','~KxJMwc@pQLC$aYt1'), (1806.7991,'[\"dXvjjWbrvF3YpAcJYxU1WV5pOLKHgnyXri8NahE0i5IfeDIfH4JIiIYA2F8sOUDM\", \"66AeToqojcP95ztJkwJb7sOTnK6AUXQjoMwaiAz7sDqNNw87yW7Va4q3Ze5P84Cg\", \"gleCYfdpv9ITioi1a4doWgppgTPL1lpf5jzUTSoqJ1RVmFJEmir05lEEw6xbuEpB\"]','[\"hx41EBK8u4uMukmSFVQcbwIeHC6cCLwLvoXn403llhgNirlPa7A1XLsNBz6ljEON\"]','X%G!PLUQ7'), (8696.62,'[\"ZRGYVXHWLgNzGscEjokb7zdEIdnhUjQRqimYDIqPYz8s92cPZpi1SiAYw6sHINqn\", \"QMUlUYePrDyP2mGuleSFEZousIyDqlwi41C7L1L01LzF86I0sCGFaLkOBKywtMey\", \"R0APc4bv5V2M3fJUOYTQwiPmiqABu5HvIJXGNlMwfkIFUPgF5YPhnzKTvEcjCbfE\"]','[\"9A1T1RQtGnpAQ2B4NodZPKKR519gQkigxdPE2AcT58xZ2ab0eKjiGjvLxldHOUCU\"]','e~J$K'), (5056.735,'[\"2ZaHCY8lDeSBmB1vIyqsbe2V0zXs4cwvt71BRVo0IOQOXSMqUuA4M7ooas72M3eg\", \"vaqq2DAwnhKKGMvUQVbOb6zwo8VqJd3MplwHm3cDYrcDFk3YzU4U3SIfZ6RfEIS8\", \"q0EZIEBYUxNUODmWZWAe1S9mFJoaBzZtALkuoTILBFhirLgiCjYnFZlFP3J7jGpt\", \"Raot4K7hM3dhVwGDALoiixFlcPCmfEMkA7rWtrGXUz6g61qb7puer4hBEnkGH63Y\", \"YTLZCfLVzDW5CGEVxhdESfLTe4vLEj7T6J3mRrPRP6KhtyVGxXoEsnyyO8xvuz6U\"]','[\"pzQ0eZHO7PQVTdBVWvE9EQ2YQ9BAVBko5FhmyX0aJAsOyZVphDzEadqULpILEZHy\", \"5wsa74cwPOt5fLPHyN9gaHtmIYBa9QPJx1zXjbOTha65RfqX9RJhSV9kATmHwDoF\", \"X2mNT7z2RG0dZ6kYl5Z5NXDNDwP6R23XMperj3P12dnV2XdLkNHW2si7fP9eSqwl\", \"W7Kr7IP7YQbwWZQg3lXm1m5zKgPk2vsBHDA61R7qDao9gSbg0A7VimETSwSNeEws\", \"8aoKNYT9i4FqH0eEVnb5wJ2E1T5yXLP6LOs4RlpjnDgxs8TBJIH6coihThZeM279\"]','RhG0M%');
Query OK, 47 rows affected (0.05 sec)
Records: 47  Duplicates: 0  Warnings: 0

mysql> INSERT INTO `tdbe45f5c` VALUES ('xAjzs_u6X+0gJqJuET-',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',NULL), ('nlAjx',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[2824373988573110971, 5894521625901721212]'), ('wgP0QqCcL5-8m&(E$(',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[1007488563383092277, 3063509239455308111, 2754461956121461839, 5645965065554745872, 1005212220604930446]'), ('_1!h#UuCz',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[7882407618943261094, 8854243031713614290, 5227143073914885406, 8564944233704467069]'), ('e(NUcjl+zAELv$*z$',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[-9223372036854775807, 6768456826251219389, 2248881510994147256, 2, 8745962758401483278]'), ('E=S*7NDaKNCxr=x@',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[6948162628461842154, 388072781061651177]'), ('T~6BXQtuLXs3Nynn',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[4916097982268977111, 4831071175460962296, 4924144738157843623, 2889755021111370727, 7736261994385613239]'), ('zk6o$4pcTHA*GQ',x'594d7e6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[7837077849986219679]');
Query OK, 8 rows affected (0.04 sec)
Records: 8  Duplicates: 0  Warnings: 0

mysql> SELECT `teef726a5`.`col_94` AS `r0`, col_98 FROM `tdbe45f5c` use index() JOIN `teef726a5` ON `tdbe45f5c`.`col_96`=`teef726a5`.`col_95` WHERE `teef726a5`.`col_95`='' AND NOT (6252179388429456273 MEMBER OF (`tdbe45f5c`.`col_98`));
Empty set (0.02 sec)

tidb is the same empty

@AilinKid
Copy link
Contributor

@wjhuang2016 /cc

@wjhuang2016
Copy link
Member Author

@wjhuang2016 /cc

Update!

@AilinKid
Copy link
Contributor

AilinKid commented Jan 15, 2024 •
edited 

tidb> explain SELECT `teef726a5`.`col_94` AS `r0` FROM `tdbe45f5c` JOIN `teef726a5` ON `tdbe45f5c`.`col_96`=`teef726a5`.`col_95` WHERE `teef726a5`.`col_95`='' AND NOT (6252179388429456273 MEMBER OF (`tdbe45f5c`.`col_98`));
+-------------------------------+----------+-----------+-------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id                            | estRows  | task      | access object                                                                 | operator info                                                                                                                                                   |
+-------------------------------+----------+-----------+-------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| IndexHashJoin_18              | 12.50    | root      |                                                                               | inner join, inner:IndexLookUp_15, outer key:test.teef726a5.col_95, inner key:test.tdbe45f5c.col_96, equal cond:eq(test.teef726a5.col_95, test.tdbe45f5c.col_96) |
| ├─TableReader_31(Build)       | 10.00    | root      |                                                                               | data:Selection_30                                                                                                                                               |
| │ └─Selection_30              | 10.00    | cop[tikv] |                                                                               | eq(test.teef726a5.col_95, "")                                                                                                                                   |
| │   └─TableFullScan_29        | 10000.00 | cop[tikv] | table:teef726a5                                                               | keep order:false, stats:pseudo                                                                                                                                  |
| └─IndexLookUp_15(Probe)       | 12.50    | root      |                                                                               |                                                                                                                                                                 |
|   ├─Selection_13(Build)       | 15.62    | cop[tikv] |                                                                               | not(isnull(test.tdbe45f5c.col_96))                                                                                                                              |
|   │ └─IndexRangeScan_11       | 15.64    | cop[tikv] | table:tdbe45f5c, index:idx_29(col_96, cast(`col_98` as signed array), col_97) | range: decided by [eq(test.tdbe45f5c.col_96, test.teef726a5.col_95)], keep order:false, stats:pseudo                                                            |
|   └─Selection_14(Probe)       | 12.50    | cop[tikv] |                                                                               | not(istrue_with_null(json_memberof(cast(6252179388429456273, json BINARY), test.tdbe45f5c.col_98)))                                                             |
|     └─TableRowIDScan_12       | 15.62    | cop[tikv] | table:tdbe45f5c                                                               | keep order:false, stats:pseudo                                                                                                                                  |
+-------------------------------+----------+-----------+-------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
9 rows in set (0.01 sec)

tidb> SELECT `teef726a5`.`col_94` AS `r0` FROM `tdbe45f5c` JOIN `teef726a5` ON `tdbe45f5c`.`col_96`=`teef726a5`.`col_95` WHERE `teef726a5`.`col_95`='' AND NOT (6252179388429456273 MEMBER OF (`tdbe45f5c`.`col_98`));
+----------------------------------------------------------------------+
| r0                                                                   |
+----------------------------------------------------------------------+
| ["xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI"] |
| ["xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI"] |
| ["xPnHuZq0riZJuBtlG3UYDaDRHknMTLsRkKmc9X8kV1K9pOdMzWmlJDgBK5f43VPI"] |
+----------------------------------------------------------------------+
3 rows in set (0.01 sec)

tidb> explain analyze SELECT `teef726a5`.`col_94` AS `r0` FROM `tdbe45f5c` JOIN `teef726a5` ON `tdbe45f5c`.`col_96`=`teef726a5`.`col_95` WHERE `teef726a5`.`col_95`='' AND NOT (6252179388429456273 MEMBER OF (`tdbe45f5c`.`col_98`));
+-------------------------------+---------+---------+-----------+-------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+------+
| id                            | estRows | actRows | task      | access object                                                                 | execution info                                                                                                                                                                                                                                                              | operator info                                                                                                                                                   | memory    | disk |
+-------------------------------+---------+---------+-----------+-------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+------+
| IndexHashJoin_18              | 0.06    | 3       | root      |                                                                               | time:1.27ms, loops:2, RU:1.432080, inner:{total:725.8µs, concurrency:5, task:1, construct:29.9µs, fetch:681.1µs, build:11.2µs, join:4.29µs}                                                                                                                                 | inner join, inner:IndexLookUp_15, outer key:test.teef726a5.col_95, inner key:test.tdbe45f5c.col_96, equal cond:eq(test.teef726a5.col_95, test.tdbe45f5c.col_96) | 65.3 KB   | N/A  |
| ├─TableReader_31(Build)       | 0.05    | 1       | root      |                                                                               | time:460.3µs, loops:3, cop_task: {num: 1, max: 433.7µs, proc_keys: 0, rpc_num: 1, rpc_time: 398.3µs, copr_cache_hit_ratio: 0.00, build_task_duration: 11.3µs, max_distsql_concurrency: 1}                                                                                   | data:Selection_30                                                                                                                                               | 309 Bytes | N/A  |
| │ └─Selection_30              | 0.05    | 1       | cop[tikv] |                                                                               | tikv_task:{time:355.4µs, loops:0}                                                                                                                                                                                                                                           | eq(test.teef726a5.col_95, "")                                                                                                                                   | N/A       | N/A  |
| │   └─TableFullScan_29        | 47.00   | 47      | cop[tikv] | table:teef726a5                                                               | tikv_task:{time:355.4µs, loops:0}                                                                                                                                                                                                                                           | keep order:false, stats:pseudo                                                                                                                                  | N/A       | N/A  |
| └─IndexLookUp_15(Probe)       | 0.06    | 3       | root      |                                                                               | time:629.9µs, loops:2, index_task: {total_time: 255.8µs, fetch_handle: 254.7µs, build: 416ns, wait: 625ns}, table_task: {total_time: 300.5µs, num: 1, concurrency: 5}, next: {wait_index: 308.3µs, wait_table_lookup_build: 66.6µs, wait_table_lookup_resp: 237.9µs}        |                                                                                                                                                                 | 9.29 KB   | N/A  |
|   ├─Selection_13(Build)       | 0.07    | 3       | cop[tikv] |                                                                               | time:251µs, loops:3, cop_task: {num: 1, max: 223.8µs, proc_keys: 0, rpc_num: 1, rpc_time: 215.7µs, copr_cache_hit_ratio: 0.00, build_task_duration: 20.3µs, max_distsql_concurrency: 1}, tikv_task:{time:206.5µs, loops:0}                                                  | not(isnull(test.tdbe45f5c.col_96))                                                                                                                              | N/A       | N/A  |
|   │ └─IndexRangeScan_11       | 0.07    | 3       | cop[tikv] | table:tdbe45f5c, index:idx_29(col_96, cast(`col_98` as signed array), col_97) | tikv_task:{time:206.5µs, loops:0}                                                                                                                                                                                                                                           | range: decided by [eq(test.tdbe45f5c.col_96, test.teef726a5.col_95)], keep order:false, stats:pseudo                                                            | N/A       | N/A  |
|   └─Selection_14(Probe)       | 0.06    | 3       | cop[tikv] |                                                                               | time:228.3µs, loops:2, cop_task: {num: 1, max: 199.3µs, proc_keys: 0, rpc_num: 1, rpc_time: 190.4µs, copr_cache_hit_ratio: 0.00, build_task_duration: 31.1µs, max_distsql_concurrency: 1, max_extra_concurrency: 1}, tikv_task:{time:174.7µs, loops:0}                      | not(istrue_with_null(json_memberof(cast(6252179388429456273, json BINARY), test.tdbe45f5c.col_98)))                                                             | N/A       | N/A  |
|     └─TableRowIDScan_12       | 0.07    | 3       | cop[tikv] | table:tdbe45f5c                                                               | tikv_task:{time:174.7µs, loops:0}                                                                                                                                                                                                                                           | keep order:false, stats:pseudo                                                                                                                                  | N/A       | N/A  |
+-------------------------------+---------+---------+-----------+-------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+------+
9 rows in set (0.01 sec)

split it as two part:

  • part1: select * from teef726a5 WHERE teef726a5.col_95=''
    (returning 1 row) (corrected as MySQL)
  • part2: select * from tdbe45f5c t1 where not (6252179388429456273 MEMBER OF (t1.col_98));
    (returning 44 rows) (corrected as MySQL)

so the problem must come from the index hash join's internal assumption error.


teef726a5     INDEX JOIN    tdbe45f5c ( ON`teef726a5`.`col_95`= `tdbe45f5c`.`col_96`)
    one row                      / (using mv index idx_29(col_96, array_col_98, col_97) , here)
        +-----drive index scan --

kind of prefix range scan for mv index idx_29, while mv index rows returned here are not 
handle-count equivalent. while, index hash join will take it for granted that, for probe side
returned 1 row here, that must mean that we found 1 qualified handle from the be-drived
derived table as we expected as usual.

looks like MySQL has done some handle duplication?

mysql> explain analyze  select * from tdbe45f5c t1 join (select * from `teef726a5` WHERE `teef726a5`.`col_95`='') t2 ON `t1`.`col_96`=`t2`.`col_95` where not (6252179388429456273 MEMBER OF (t1.col_98));
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPLAIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| -> Nested loop inner join  (cost=7.10 rows=5) (actual time=1.518..1.565 rows=1 loops=1)
    -> Filter: (teef726a5.col_95 = '')  (cost=5.45 rows=5) (actual time=0.854..0.873 rows=1 loops=1)
        -> Table scan on teef726a5  (cost=5.45 rows=47) (actual time=0.781..0.859 rows=47 loops=1)
    -> Filter: ((not(<cache>(6252179388429456273) member of (t1.col_98))) and (t1.col_96 = teef726a5.col_95))  (cost=0.27 rows=1) (actual time=0.658..0.684 rows=1 loops=1)
        -> Index lookup on t1 using idx_29 (col_96=teef726a5.col_95)  (cost=0.27 rows=1) (actual time=0.644..0.670 rows=1 loops=1)
 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

@AilinKid AilinKid mentioned this issue Jan 15, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 15, 2024
@AilinKid
planner: fix mv index path will be leveraged as index join's probe si…
186f08c 
…de (#50439)

close #50382
This was referenced Jan 15, 2024
Merged
Merged
ti-chi-bot bot pushed a commit that referenced this issue Jan 17, 2024
@ti-chi-bot
planner: fix mv index path will be leveraged as index join's probe si…
ae79892 
…de (#50439) (#50492)

close #50382
ti-chi-bot bot pushed a commit that referenced this issue Jan 18, 2024
@ti-chi-bot
planner: fix mv index path will be leveraged as index join's probe si…
8aa2293 
…de (#50439) (#50440)

close #50382
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@AilinKid AilinKid

Labels
affects-7.5 affects-7.6 fuzz/randomtest severity/critical sig/planner SIG: Planner type/bug This issue is a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

planner: fix mv index path will be leveraged as index join's probe side AilinKid/tidb
4 participants
@AilinKid @wjhuang2016 @seiya-annie @ti-chi-bot