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

invalid memory address or nil pointer dereference when using MV index #50420

Closed
wjhuang2016 opened this issue Jan 15, 2024 · 3 comments · Fixed by #50474
Closed

invalid memory address or nil pointer dereference when using MV index #50420

wjhuang2016 opened this issue Jan 15, 2024 · 3 comments · Fixed by #50474
Assignees
@time-and-fate
Labels
affects-7.6 fuzz/randomtest severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@wjhuang2016
Copy link
Member

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE `td34e50a2` (
  `col_37` binary(66) NOT NULL DEFAULT 'izk3(+*PuOfj\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_38` date NOT NULL DEFAULT '2011-01-24',
  `col_39` bit(35) NOT NULL DEFAULT b'0',
  `col_40` varchar(248) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `col_41` json NOT NULL,
  `col_42` datetime NOT NULL,
  KEY `idx_20` ((cast(`col_41` as signed array))),
  PRIMARY KEY (`col_39`,`col_37`) /*T![clustered_index] NONCLUSTERED */,
  KEY `idx_22` (`col_38`),
  UNIQUE KEY `idx_23` (`col_42`,`col_37`,`col_38`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `td34e50a2` VALUES (x'406100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'07501cda49','','[6485018451143719372, 371334648418677081]','1992-06-17 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'066de9d5d5','','[6485018451143719372, 371334648418677081]','2032-10-09 00:00:00'), (x'4e4e2a7051456b4c5a574a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','2025-02-22 00:00:00'), (x'54634e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','1999-10-27 00:00:00'), (x'4e315a36505059322a770000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','2004-12-07 00:00:00'), (x'366200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'006a35eee0','','[6485018451143719372, 371334648418677081]','1970-09-14 00:00:00'), (x'464276000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','1977-09-09 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0487f9a50f','','[6485018451143719372, 371334648418677081]','1999-05-23 00:00:00'), (x'4f3100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','1971-01-16 00:00:00'), (x'5875312d723557432d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','2035-08-08 00:00:00'), (x'7a7a375f614e3148615f6c39282a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0249b7c7b5','','[6485018451143719372, 371334648418677081]','2027-01-31 00:00:00'), (x'44436838237071364468366f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0503d938e6','','[6485018451143719372, 371334648418677081]','1994-06-02 00:00:00'), (x'2b5a6825637e7829214b4657646f78000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02a1c71dd8','','[6485018451143719372, 371334648418677081]','2005-01-10 00:00:00'), (x'51665032562948332165685e515564635e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','1996-03-14 00:00:00'), (x'312b7e3364645f28374b5a4d757337382d4f240000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0007f1064b','','[6485018451143719372, 371334648418677081]','2034-06-29 00:00:00'), (x'447a55362d2a6d30634e2434357100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0720f5058c','','[6485018451143719372, 371334648418677081]','1991-02-14 00:00:00'), (x'6c3024537242255158410000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'03c1cc0b80','','[6485018451143719372, 371334648418677081]','1980-07-12 00:00:00'), (x'636d395077564c3929580000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','2027-06-17 00:00:00'), (x'73415f6f564f704600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0272b8d92c','','[6485018451143719372, 371334648418677081]','2033-12-20 00:00:00'), (x'24786731467661445a4b56692b3900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04666af531','','[6485018451143719372, 371334648418677081]','1987-03-04 00:00:00'), (x'4a702a782578673900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','2025-06-07 00:00:00'), (x'327856316738584946264f6564237e756f21000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01dd5560a8','','[6485018451143719372, 371334648418677081]','2010-12-05 00:00:00'), (x'4344256d6430320000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'03b1de7e6f','','[6485018451143719372, 371334648418677081]','2012-02-14 00:00:00'), (x'35386d256e61646866000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04d0000463','','[6485018451143719372, 371334648418677081]','2011-09-22 00:00:00'), (x'246b356548683d4c4a3359556c2b56280000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06bb18d31c','','[6485018451143719372, 371334648418677081]','2029-01-15 00:00:00'), (x'3d633d280000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04e1e24f7c','','[6485018451143719372, 371334648418677081]','1983-11-30 00:00:00'), (x'7839616d77242d41236942355674546f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'044c9ddf84','','[6485018451143719372, 371334648418677081]','2036-11-26 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'00862bf9de','','[6485018451143719372, 371334648418677081]','2018-06-19 00:00:00'), (x'6b786d742b42282325484d57585300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0319e0fb25','','[6485018451143719372, 371334648418677081]','2001-01-26 00:00:00'), (x'330000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'052aac7e22','','[6485018451143719372, 371334648418677081]','2025-09-28 00:00:00'), (x'28466c495900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05af773623','','[6485018451143719372, 371334648418677081]','1993-03-31 00:00:00'), (x'622a476977487347337453697175734b7252000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','2030-10-08 00:00:00'), (x'4439776a524d4654375e4a4b2d4d73462d53490000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06fbadc414','','[6485018451143719372, 371334648418677081]','2019-01-03 00:00:00'), (x'257e496e446b595830456e356c255e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0097d87077','','[6485018451143719372, 371334648418677081]','1988-06-26 00:00:00'), (x'4a24535541592b243244547e735e21233800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','2022-10-10 00:00:00'), (x'212134554924752b6742574a776723672b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01bf22cadb','','[6485018451143719372, 371334648418677081]','2030-08-01 00:00:00'), (x'684700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'009ad54a17','','[6485018451143719372, 371334648418677081]','2008-10-10 00:00:00'), (x'234f394a696b44442a2b614e2d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0358b78864','','[6485018451143719372, 371334648418677081]','1977-01-05 00:00:00'), (x'640000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'038d1bf38c','','[6485018451143719372, 371334648418677081]','1984-04-09 00:00:00'), (x'7e507e3341634a406d487a44775e3d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0575a827d0','','[6485018451143719372, 371334648418677081]','2026-10-19 00:00:00'), (x'217400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06f2445ce1','','[6485018451143719372, 371334648418677081]','2015-11-07 00:00:00'), (x'762b79384e797a29564d414658387e550000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'062caa03f5','','[6485018451143719372, 371334648418677081]','2022-11-06 00:00:00'), (x'2823725e374f727000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'055810e307','','[6485018451143719372, 371334648418677081]','1990-07-07 00:00:00'), (x'693d217a425f383854443700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05da64bf8f','','[6485018451143719372, 371334648418677081]','2031-03-17 00:00:00'), (x'3023342928516538385476306e5f7257464b3d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'07d5429c17','','[6485018451143719372, 371334648418677081]','2000-10-31 00:00:00'), (x'617771444d2d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'070067b069','','[6485018451143719372, 371334648418677081]','1974-09-02 00:00:00'), (x'70382550552a6a694a425000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02e33176f9','','[6485018451143719372, 371334648418677081]','2008-08-29 00:00:00'), (x'393600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04d0c60d35','','[6485018451143719372, 371334648418677081]','2012-04-06 00:00:00'), (x'546e3d2b3763692d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0039f0aa8e','','[6485018451143719372, 371334648418677081]','2008-03-27 00:00:00'), (x'312941753226554a504f5949254b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0528f37e7c','','[6485018451143719372, 371334648418677081]','2020-11-25 00:00:00'), (x'522a6c3462637e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'034636b218','','[6485018451143719372, 371334648418677081]','1988-12-13 00:00:00'), (x'396900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0048bc9eac','','[6485018451143719372, 371334648418677081]','2028-02-01 00:00:00'), (x'580000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'032e58fee4','','[6485018451143719372, 371334648418677081]','2029-10-06 00:00:00'), (x'6c53342b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02f461496c','','[6485018451143719372, 371334648418677081]','2029-03-15 00:00:00'), (x'342d6144755430754c6858732d3878453278570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02dbd73a20','','[6485018451143719372, 371334648418677081]','2036-07-17 00:00:00'), (x'387600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02d1aac11f','','[6485018451143719372, 371334648418677081]','1982-10-15 00:00:00'), (x'3030737261295e4736580000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0245a57490','','[6485018451143719372, 371334648418677081]','1974-08-10 00:00:00'), (x'6a31665769364f522a6d6e66382d782d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'00c64768bc','','[6485018451143719372, 371334648418677081]','2019-12-05 00:00:00'), (x'39597834672826676274214126234b695000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0726dc3a2f','','[6485018451143719372, 371334648418677081]','1996-02-19 00:00:00'), (x'4273403828624069364b5a566e4a426e3100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'00f6c2842c','','[6485018451143719372, 371334648418677081]','2033-08-20 00:00:00'), (x'467378410000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01ecd6ce25','','[6485018451143719372, 371334648418677081]','2022-12-19 00:00:00'), (x'29245f4534746e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04629682c8','','[6485018451143719372, 371334648418677081]','1974-09-12 00:00:00'), (x'4a5746000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0747f0aee7','','[6485018451143719372, 371334648418677081]','2034-08-10 00:00:00'), (x'5438484c7a4b3d5e643649772666676f4800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'00245eadb7','','[6485018451143719372, 371334648418677081]','2013-08-08 00:00:00'), (x'504c414b4f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'037f9aa5fc','','[6485018451143719372, 371334648418677081]','2028-12-12 00:00:00'), (x'484300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01dcf7aee9','','[6485018451143719372, 371334648418677081]','1988-05-29 00:00:00'), (x'407057745a4777782b412500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'07cc1c1359','','[6485018451143719372, 371334648418677081]','2005-09-27 00:00:00'), (x'426a42694800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0085fa7eea','','[6485018451143719372, 371334648418677081]','2027-10-05 00:00:00'), (x'505f6e7543664e50626e266a473324570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0620b96024','','[6485018451143719372, 371334648418677081]','1988-10-26 00:00:00'), (x'58357a5735694474576d71426a256a250000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05485d3c2c','','[6485018451143719372, 371334648418677081]','2031-08-23 00:00:00'), (x'56335964426e2b5621280000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06e30fc5bf','','[6485018451143719372, 371334648418677081]','2006-10-22 00:00:00'), (x'3d285876474a7544634d396b49496f526642650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'045bbbc698','','[6485018451143719372, 371334648418677081]','2022-08-21 00:00:00'), (x'232678000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'042611f363','','[6485018451143719372, 371334648418677081]','1998-03-21 00:00:00'), (x'48286a492400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'017eac894c','','[6485018451143719372, 371334648418677081]','2031-05-15 00:00:00'), (x'3449336d5a6c536d4e730000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'077c1318ad','','[6485018451143719372, 371334648418677081]','2007-05-08 00:00:00'), (x'762d28727036777e29470000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04acc2654d','','[6485018451143719372, 371334648418677081]','1977-08-16 00:00:00'), (x'6833406d684747692d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0742a18b5e','','[6485018451143719372, 371334648418677081]','1987-10-01 00:00:00'), (x'632b4946432842626f2a3647000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06920dc5cb','','[6485018451143719372, 371334648418677081]','1974-06-02 00:00:00'), (x'4678717e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'045d449f69','','[6485018451143719372, 371334648418677081]','1975-04-18 00:00:00'), (x'62594c394d6637292a427643690000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01cb97a8a1','','[6485018451143719372, 371334648418677081]','1994-06-18 00:00:00'), (x'45592b4b584766314e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06a9301c48','','[6485018451143719372, 371334648418677081]','1999-02-16 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06496b0a33','','[6485018451143719372, 371334648418677081]','1981-12-28 00:00:00'), (x'384f4e79522a4c7762000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02f31ed81c','','[6485018451143719372, 371334648418677081]','1981-11-20 00:00:00'), (x'61456a5f2b6b38764b247100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'07180a77f5','','[6485018451143719372, 371334648418677081]','2032-03-16 00:00:00'), (x'6c414e25344e4451396a3964000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05d6c58024','','[6485018451143719372, 371334648418677081]','1996-09-21 00:00:00'), (x'7a262d565200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'060b151684','','[6485018451143719372, 371334648418677081]','2022-05-13 00:00:00'), (x'623d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'07a5bdf556','','[6485018451143719372, 371334648418677081]','2008-09-26 00:00:00'), (x'326b48352a38772974000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'027b34376d','','[6485018451143719372, 371334648418677081]','1970-02-21 00:00:00'), (x'66746643582b2d6554540000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0777eeb8d8','','[6485018451143719372, 371334648418677081]','2011-05-01 00:00:00'), (x'66526a66577e5a786834786b5e436a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0195b95c5a','','[6485018451143719372, 371334648418677081]','1996-03-23 00:00:00'), (x'364449300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'023b959ef5','','[6485018451143719372, 371334648418677081]','2020-11-18 00:00:00'), (x'654c6a705778626238686c55386d78285530000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0653487910','','[6485018451143719372, 371334648418677081]','2019-01-10 00:00:00'), (x'654500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01ad026ec9','','[6485018451143719372, 371334648418677081]','1970-03-23 00:00:00'), (x'59494e2d3931785e4c4c5f5e420000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0312b0553c','','[6485018451143719372, 371334648418677081]','2013-10-01 00:00:00'), (x'310000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05cde2d8df','','[6485018451143719372, 371334648418677081]','2036-05-23 00:00:00'), (x'77296b2a4942634168000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0458acee11','','[6485018451143719372, 371334648418677081]','2030-03-06 00:00:00'), (x'65504a4e5e45566600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05fb046432','','[6485018451143719372, 371334648418677081]','2013-04-09 00:00:00'), (x'4f734f566e666c445f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0501b0df47','','[6485018451143719372, 371334648418677081]','1975-07-30 00:00:00'), (x'424a2848654426497863296b485739262a6a350000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04a6e51533','','[6485018451143719372, 371334648418677081]','1997-11-25 00:00:00'), (x'364b2d4d664f484431000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'042ef37ed1','','[6485018451143719372, 371334648418677081]','2025-04-01 00:00:00'), (x'7e2568266c4f684900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06938a97c0','','[6485018451143719372, 371334648418677081]','2033-07-17 00:00:00'), (x'46493d256254505848000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'015cccb6af','','[6485018451143719372, 371334648418677081]','2017-07-16 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'011a59a84a','','[6485018451143719372, 371334648418677081]','1981-01-20 00:00:00'), (x'6f646c775e6a324e6b4a4e6379782a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'005d26c529','','[6485018451143719372, 371334648418677081]','2004-08-10 00:00:00'), (x'6c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'056ece849c','','[6485018451143719372, 371334648418677081]','2030-07-03 00:00:00'), (x'4d417e25527148504e4643702b4240000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'07d0c3a677','','[6485018451143719372, 371334648418677081]','1995-07-11 00:00:00'), (x'6f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'03828f5698','','[6485018451143719372, 371334648418677081]','2034-01-28 00:00:00'), (x'58376f375f47485839296300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0107416199','','[6485018451143719372, 371334648418677081]','2011-06-30 00:00:00'), (x'47286f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05724cd360','','[6485018451143719372, 371334648418677081]','1996-08-16 00:00:00'), (x'457953217568000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'027900fcfc','','[6485018451143719372, 371334648418677081]','1984-02-05 00:00:00'), (x'4b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0610462100','','[6485018451143719372, 371334648418677081]','1987-01-16 00:00:00'), (x'78347e2b75536b5557337244000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'07d3882849','','[6485018451143719372, 371334648418677081]','1989-10-21 00:00:00'), (x'4f6c4b786930242938000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02b6218477','','[6485018451143719372, 371334648418677081]','2035-11-30 00:00:00'), (x'4e266f24327e620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05f684c43c','','[6485018451143719372, 371334648418677081]','1974-07-23 00:00:00'), (x'30582d2a73304d7463267963474f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'03ad6bdd3c','','[6485018451143719372, 371334648418677081]','1984-01-26 00:00:00'), (x'2d296930706f580000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'03f847d134','','[6485018451143719372, 371334648418677081]','1987-06-24 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'07004e60c8','','[6485018451143719372, 371334648418677081]','2032-07-02 00:00:00'), (x'7e4277784a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04858e9725','','[6485018451143719372, 371334648418677081]','1977-01-28 00:00:00'), (x'6a66592b4566000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'061632440c','','[6485018451143719372, 371334648418677081]','1970-01-14 00:00:00'), (x'7a787074244d784a6c535f71723736450000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05e1309c1b','','[6485018451143719372, 371334648418677081]','2026-11-22 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'067835fe2c','','[6485018451143719372, 371334648418677081]','2022-03-20 00:00:00'), (x'5f427857382a244f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0476d8e235','','[6485018451143719372, 371334648418677081]','2016-05-31 00:00:00'), (x'78432a5f423d447250742641396357696a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0359e0e518','','[6485018451143719372, 371334648418677081]','2035-10-05 00:00:00'), (x'2b723577384a49363d5e29676140794c4e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'07385f3c3c','','[6485018451143719372, 371334648418677081]','2015-05-24 00:00:00'), (x'720000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'050fda4ea7','','[6485018451143719372, 371334648418677081]','2004-04-24 00:00:00'), (x'6d407e4e6b30774a46770000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02f10fd3aa','','[6485018451143719372, 371334648418677081]','1996-07-21 00:00:00'), (x'6f296d306a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'07e6b60432','','[6485018451143719372, 371334648418677081]','2029-11-20 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01c654fcd2','','[6485018451143719372, 371334648418677081]','1987-05-26 00:00:00'), (x'7641327e246231756c55562b5626217757795f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06c57336c2','','[6485018451143719372, 371334648418677081]','2024-03-12 00:00:00'), (x'6b3577535238210000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02dc02bfc0','','[6485018451143719372, 371334648418677081]','1995-09-21 00:00:00'), (x'5a49522a283d2d364d255f30707600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'035c5bfd7b','','[6485018451143719372, 371334648418677081]','1975-11-06 00:00:00'), (x'392569436761470000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'018b9eaaf9','','[6485018451143719372, 371334648418677081]','2033-09-25 00:00:00'), (x'30302b2a627a444665434277522400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'076e9ea6bf','','[6485018451143719372, 371334648418677081]','1978-10-31 00:00:00'), (x'7a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'00f9354bde','','[6485018451143719372, 371334648418677081]','1980-06-16 00:00:00'), (x'624478386d32215a59672b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'031389e2d5','','[6485018451143719372, 371334648418677081]','2027-04-12 00:00:00'), (x'6a5a3332564b394c51694c42000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0372539b3b','','[6485018451143719372, 371334648418677081]','2005-01-30 00:00:00'), (x'2d6a706578346243494248707a4434000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'041f1a2c7a','','[6485018451143719372, 371334648418677081]','2033-09-22 00:00:00'), (x'7237394863264d756d317064306c32377151000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'059fe2aa48','','[6485018451143719372, 371334648418677081]','2020-12-26 00:00:00'), (x'4035527e4f4d367257617772000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0583973254','','[6485018451143719372, 371334648418677081]','1983-06-24 00:00:00'), (x'4e6a24254d292d77744673534673755f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'013150519a','','[6485018451143719372, 371334648418677081]','1985-01-07 00:00:00'), (x'774d3246496f53213341406c58406e510000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04a88a0d29','','[6485018451143719372, 371334648418677081]','1987-05-20 00:00:00'), (x'61744d38375844454353494e4b4351000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'054fc668b8','','[6485018451143719372, 371334648418677081]','2008-02-09 00:00:00'), (x'544857664a6c467a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0253d52aea','','[6485018451143719372, 371334648418677081]','2011-04-20 00:00:00'), (x'6b2a23636475686247622b45752b37580000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06bd396944','','[6485018451143719372, 371334648418677081]','2000-11-30 00:00:00'), (x'497a6f49246a6a65537625365a4065350000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04342b8b8b','','[6485018451143719372, 371334648418677081]','2035-11-17 00:00:00'), (x'40426661412a416433753d2d3d75572d236c250000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05a961e07b','','[6485018451143719372, 371334648418677081]','2004-08-28 00:00:00'), (x'784345516f3958536636314b6f367e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04b2f7b91d','','[6485018451143719372, 371334648418677081]','2029-06-10 00:00:00'), (x'356c2d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'065cf3959f','','[6485018451143719372, 371334648418677081]','1995-11-04 00:00:00'), (x'6248393466677323657a5952560000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0431c8d761','','[6485018451143719372, 371334648418677081]','2035-05-13 00:00:00'), (x'6767565a4b46533453666f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'022e35c8ce','','[6485018451143719372, 371334648418677081]','2001-03-24 00:00:00'), (x'776741577941463572000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0643059769','','[6485018451143719372, 371334648418677081]','1978-05-21 00:00:00'), (x'69323d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'07172096ef','','[6485018451143719372, 371334648418677081]','2032-11-19 00:00:00'), (x'21404b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05993daf9c','','[6485018451143719372, 371334648418677081]','1999-10-30 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'00d718378a','','[6485018451143719372, 371334648418677081]','2015-12-28 00:00:00'), (x'764232742b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06184429ae','','[6485018451143719372, 371334648418677081]','1996-10-25 00:00:00'), (x'5074514d4c40715053767500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'00f9eedc1a','','[6485018451143719372, 371334648418677081]','1979-09-19 00:00:00'), (x'6f6b51234a7138496b552800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02e4213bad','','[6485018451143719372, 371334648418677081]','2026-09-25 00:00:00'), (x'566f4a456859000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'026c8753df','','[6485018451143719372, 371334648418677081]','1983-11-16 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'00ead4039f','','[6485018451143719372, 371334648418677081]','2010-01-08 00:00:00'), (x'3648442a414a7a4035000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'031feaa17f','','[6485018451143719372, 371334648418677081]','2004-03-15 00:00:00'), (x'7e59704f7259355473630000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'050ab3d9a8','','[6485018451143719372, 371334648418677081]','2017-05-14 00:00:00'), (x'6c26676d386a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0420013ec7','','[6485018451143719372, 371334648418677081]','2031-07-24 00:00:00'), (x'6b63613d4c25585e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05254c8e1b','','[6485018451143719372, 371334648418677081]','1983-05-15 00:00:00'), (x'4f56524f4374520000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'011a880a72','','[6485018451143719372, 371334648418677081]','1994-06-18 00:00:00'), (x'674f79680000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0318fdacce','','[6485018451143719372, 371334648418677081]','2025-07-31 00:00:00'), (x'555943376c2a28406521692d4f213d5a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04ba2a4e1d','','[6485018451143719372, 371334648418677081]','2031-04-21 00:00:00'), (x'336569587251662862654500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'05fe9fc395','','[6485018451143719372, 371334648418677081]','1989-02-08 00:00:00'), (x'356b63677200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'00da4d0c21','','[6485018451143719372, 371334648418677081]','2030-02-25 00:00:00'), (x'770000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0353142756','','[6485018451143719372, 371334648418677081]','2003-04-27 00:00:00'), (x'492400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01147777f3','','[6485018451143719372, 371334648418677081]','1983-04-08 00:00:00'), (x'61484d240000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'03fe94d466','','[6485018451143719372, 371334648418677081]','2013-10-24 00:00:00'), (x'5e6d53525f50465452650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'06567516fb','','[6485018451143719372, 371334648418677081]','2002-11-21 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'046b7e41ac','','[6485018451143719372, 371334648418677081]','1996-12-09 00:00:00'), (x'6a4b2166634a63557749545e7473586c3539000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'061c78a740','','[6485018451143719372, 371334648418677081]','2035-10-15 00:00:00'), (x'287367000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'03d7a45c76','','[6485018451143719372, 371334648418677081]','1984-03-02 00:00:00'), (x'78402b233249000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0422c89f66','','[6485018451143719372, 371334648418677081]','2024-03-26 00:00:00'), (x'2123645e394c6c4928593042342b4f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02b6f0d4e2','','[6485018451143719372, 371334648418677081]','1988-05-24 00:00:00'), (x'21446c5f442a677066662d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0221cc690c','','[6485018451143719372, 371334648418677081]','2016-11-03 00:00:00'), (x'5229406d795e424c6e715567426b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01974e4da6','','[6485018451143719372, 371334648418677081]','1996-08-02 00:00:00'), (x'406d3d666636764c38783570694b71237232530000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04de7ecfb1','','[6485018451143719372, 371334648418677081]','2018-01-04 00:00:00'), (x'43255242796a300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01722ac408','','[6485018451143719372, 371334648418677081]','2015-11-14 00:00:00'), (x'68285e3121407035216747334b6161353100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'025720b90e','','[6485018451143719372, 371334648418677081]','1996-07-16 00:00:00'), (x'4e6b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01ab1a47c2','','[6485018451143719372, 371334648418677081]','2010-10-24 00:00:00'), (x'33547a2d307a513063667a236a614f262d317a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'043c8604ab','','[6485018451143719372, 371334648418677081]','2026-04-13 00:00:00'), (x'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0320e56e38','','[6485018451143719372, 371334648418677081]','1993-11-20 00:00:00'), (x'57416243785a552d53322b50506e66265624000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01034ca450','','[6485018451143719372, 371334648418677081]','1970-08-31 00:00:00'), (x'795500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0145bf374a','','[6485018451143719372, 371334648418677081]','2002-08-10 00:00:00'), (x'4863622b634372564e532378776e47526e354e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'03f6ab270f','','[6485018451143719372, 371334648418677081]','1993-07-22 00:00:00'), (x'354374785e4263287e265a5f647e6b4b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01b4279eb4','','[6485018451143719372, 371334648418677081]','1997-08-11 00:00:00'), (x'776b546173476336672968732a6d63542555380000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'072dac154e','','[6485018451143719372, 371334648418677081]','2036-10-10 00:00:00'), (x'350000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'010c00d452','','[6485018451143719372, 371334648418677081]','1978-04-02 00:00:00'), (x'324470765f4d5631492446294c4c77454e2b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'060c461b61','','[6485018451143719372, 371334648418677081]','2005-07-23 00:00:00'), (x'6b5952430000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'04230762e7','','[6485018451143719372, 371334648418677081]','1992-06-03 00:00:00'), (x'345e236c714c7e41244b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'058afbd79e','','[6485018451143719372, 371334648418677081]','2027-04-17 00:00:00'), (x'3561422a4100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'0687efa0b4','','[6485018451143719372, 371334648418677081]','2033-09-06 00:00:00'), (x'460000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02d0c79a51','','[6485018451143719372, 371334648418677081]','2018-04-29 00:00:00'), (x'544c66234d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02163e8059','','[6485018451143719372, 371334648418677081]','1981-07-22 00:00:00'), (x'782a507344295e5278692a5f735e56575f24000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'005f541770','','[6485018451143719372, 371334648418677081]','1988-08-02 00:00:00'), (x'7032666e6b3d705f33754e51264078254d4e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'00bc91955b','','[6485018451143719372, 371334648418677081]','1989-07-02 00:00:00'), (x'77497e464968297251676c6f4d36564c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'02a16e5b3b','','[6485018451143719372, 371334648418677081]','2035-02-14 00:00:00'), (x'434e502a24785a6a2a6631296d247a472338690000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01748aff03','','[6485018451143719372, 371334648418677081]','1998-09-06 00:00:00'), (x'793742654e59257049367478296c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'03cc879bfd','','[6485018451143719372, 371334648418677081]','2005-07-02 00:00:00'), (x'5340614f5477347100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'073d5881d3','','[6485018451143719372, 371334648418677081]','1995-11-01 00:00:00'), (x'714c6a242a55544450000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'03e5f10e08','','[6485018451143719372, 371334648418677081]','1974-04-17 00:00:00'), (x'615e48000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01211cd5c6','','[6485018451143719372, 371334648418677081]','1977-07-24 00:00:00'), (x'646a415f775043385f4929286d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01280b099b','','[6485018451143719372, 371334648418677081]','2005-12-24 00:00:00'), (x'4c34625a5400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'006a79e1a9','','[6485018451143719372, 371334648418677081]','2002-09-30 00:00:00'), (x'6e3031507126730000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01072efdb8','','[6485018451143719372, 371334648418677081]','2017-04-02 00:00:00'), (x'696239294a4a6e7a6d626770347946000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2024-05-21',x'01df2e282b','','[6485018451143719372, 371334648418677081]','1972-03-30 00:00:00'), (x'337832293771473944000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1971-04-23',x'07163a06c1','*h-w^-I=p$!','[6485018451143719372, 371334648418677081]','1984-04-30 00:00:00'), (x'596e6a624b385572342a5a32360000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2034-09-13',x'07398a610a','Nxcxf3','[6485018451143719372, 371334648418677081]','2027-12-27 00:00:00'), (x'406b524b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2021-07-12',x'0796e1a117','Gse','[6485018451143719372, 371334648418677081]','2023-09-17 00:00:00'), (x'3632493d662a4b402a6c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2031-05-05',x'04bd7e3823','48Q&UeLZ_','[6485018451143719372, 371334648418677081]','2010-07-04 00:00:00'), (x'4d2553642964684500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2028-01-08',x'05dd9affcb','q','[6485018451143719372, 371334648418677081]','1987-07-26 00:00:00'), (x'435372282400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1983-01-16',x'0515175652','fXeGhV','[6485018451143719372, 371334648418677081]','2004-08-17 00:00:00'), (x'72522851346d303600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1982-07-24',x'01d521f8a4','82NRPONMiReNx*Cry2J','[6485018451143719372, 371334648418677081]','2027-05-17 00:00:00'), (x'6c5800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1987-10-11',x'076fdadf3f','&+fo&OV4jz-DH','[6485018451143719372, 371334648418677081]','2007-01-11 00:00:00'), (x'426825724e50000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2014-07-11',x'0000000000','_m4i%9s4Q)$x(','[6485018451143719372, 371334648418677081]','1996-12-26 00:00:00'), (x'576200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2000-06-08',x'07d2dc29f5','w!h@Q(o)!=B0qx','[-9223372036854775807, 5457324164642166454]','2033-11-13 00:00:00'), (x'2a2338766700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2025-04-30',x'014f4d26b1','tap','[6485018451143719372, 371334648418677081]','1977-06-12 00:00:00'), (x'76577350493055544e662400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2003-05-23',x'02927bac4a','6TTBM','[6485018451143719372, 371334648418677081]','2005-04-06 00:00:00'), (x'505a7a5f61445a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2012-03-09',x'068fe78b46','NeHM@9!bYnD@Z','[6485018451143719372, 371334648418677081]','1972-12-28 00:00:00'), (x'343d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2010-09-11',x'00540d4619','Ns8E','[6485018451143719372, 371334648418677081]','1986-09-11 00:00:00'), (x'3763715f4a4341453738455471566f742336000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1999-08-01',x'06e8e2ce5b','EeCuUyYWWacJvIo4zd','[6485018451143719372, 371334648418677081]','1983-12-04 00:00:00'), (x'7e4f366272353d40655851492b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2030-03-23',x'03c65f2a83','I)kx)_S+!YL','[6485018451143719372, 371334648418677081]','1973-03-12 00:00:00'), (x'5e4745402332000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1970-01-15',x'051979000d','TBCtu~Vsu','[6485018451143719372, 371334648418677081]','1992-03-04 00:00:00'), (x'6a2448000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2020-03-10',x'0000000000','P_N','[6485018451143719372, 371334648418677081]','1986-11-19 00:00:00'), (x'432362384600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2014-07-06',x'078c4a5863','r6_eKnW~zEvT7','[6485018451143719372, 371334648418677081]','2022-01-07 00:00:00'), (x'7a3533414c5f780000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2011-12-31',x'022f5e3191',NULL,'[6485018451143719372, 371334648418677081]','2019-12-20 00:00:00'), (x'356b763d5865346750000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1974-01-10',x'0000000000','1i&dU#f#dm','[6485018451143719372, 371334648418677081]','2025-04-05 00:00:00'), (x'344d4624574f65576739766e786f5539704b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1979-08-27',x'0000000000','6hnMW92F','[6485018451143719372, 371334648418677081]','2017-06-08 00:00:00'), (x'282562543d67594f4a597100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2010-03-10',x'078dbf71ac','OPC#+lOAxBC','[6485018451143719372, 371334648418677081]','1987-10-19 00:00:00'), (x'4c726430725a786d7935516a6e2836255850000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1987-06-21',x'06ce876bb4','SlY_D!btH$dpd&GZu+l','[6485018451143719372, 371334648418677081]','1990-10-25 00:00:00'), (x'476178406142737953265f264e696c55506a520000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2015-01-05',x'02aaea453b','u6d_H','[-9223372036854775807, 5457324164642166454]','2029-09-06 00:00:00'), (x'486c732d726d6b394729265f250000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1970-11-19',x'05cf62cab4','Je)qX','[0, 3533578094078479881]','2007-07-12 00:00:00'), (x'2139397a6b2b49696a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1990-06-12',x'06a636d36a','oW6al1OUePgRj79~o','[7519639497926997294, 6092107050049718100, 0, -9223372036854775808]','1998-03-24 00:00:00'), (x'324a4341336c70717e662b6e397734677443000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2008-10-03',x'050d5a3330','#S&W#dH7xRkk2kL0~xy','[3371680718299819643, 5169949266835963221, 6200309784819602585]','2033-06-17 00:00:00'), (x'3821676b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2004-08-09',x'038f1a04ab','YkKmH&mcD3Vao^&Pw','[-9223372036854775807, 5457324164642166454]','1971-04-29 00:00:00'), (x'34682471464c73637a4850504f766c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2000-01-17',x'04c6986b36','%fJ-Ot!~Nhd','[309368576018387265, 2, 3134633804978848306]','2016-07-29 00:00:00'), (x'2a42695e57284f47375f4923486f735a7700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1987-03-04',x'06af42aa9f','L!iaj(b)ak','[6821013623584923490, 2900086677127863753, 4630316951437721542, 2506608286991615733, 59410496893530042]','2015-12-28 00:00:00'), (x'65545572772d486c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1981-03-10',x'0000000000','Cucd0','[3038134410817873548]','1992-07-20 00:00:00'), (x'744f4f706d6a375657286f70000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2005-05-04',x'014a576ba6','S~UhJ!uFgq&Fx$=p','[9223372036854775807, 8696149413345922047]','2002-07-10 00:00:00'), (x'285032397a5777642a7a473175423d242d254a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2028-01-10',x'035fbfba66','dxvnAguKH7','[4802552524599151855, 6185666431052147750, 4799917333408016856]','2003-09-28 00:00:00'), (x'344a436c5f36475523586300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1991-01-05',x'0124cea6f9','','[173137406816962245, 6021085691887440520]','2021-10-23 00:00:00'), (x'2a5a4e52247743336c2a585f6864482650517e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1989-10-30',x'066280cbaa','ZeYUd4#','[-9223372036854775807, 5457324164642166454]','1988-07-03 00:00:00'), (x'6b252a380000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1972-05-12',x'00e4887203','','[2118703348220176256, 0]','2014-03-26 00:00:00'), (x'7a303233785e4d6b5f395432570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2012-07-07',x'016ceb3e01','c%3gZW*)','[5889384802150409344, 6742377607645616572, 8102883146998169799, 3749885631945681046]','2005-05-08 00:00:00'), (x'662a69675e24720000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1970-04-07',x'012f1aaac6','1csymPAq=aob%A+','[5889488298687313121]','1988-07-18 00:00:00'), (x'26424a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2031-04-12',x'058f3cbec8','v89gI_IUmNXssQ^3jU','[-9223372036854775807, 5457324164642166454]','2027-12-17 00:00:00'), (x'7e2b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2033-07-20',x'0207be3cfc','LR6vZ-AV2%V','[2788083451414248719]','2002-07-25 00:00:00'), (x'6f547e617752620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2001-02-07',x'0000000000','geZQ6OQA!EUs','[3441637333095851538, 5687773322580154292, 6045352228398183085]','1979-05-20 00:00:00'), (x'70356c4b2d552d2d4b2d3162387733610000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2010-06-12',x'03542c9c95','E^ojGU!qIB=Gr','[-1, 4901193436760197196, 0, 3386895109180248749, 3191420939510894097]','1992-07-24 00:00:00'), (x'414b6a4e286b4a6755456359250000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1990-11-20',x'03e832663a','IU#5HQ81Y~THG0GN','[6502564198651176286]','2022-11-02 00:00:00'), (x'6c5000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1988-04-29',x'006fe59463',NULL,'[7430245626865227295, 8112779924310368364]','2021-01-10 00:00:00');

update td34e50a2 set td34e50a2.col_41 = '[6028379176574077045,1827860736484397991]' where JSON_OVERLAPS( td34e50a2.col_41 , '[1,4189335613865098857,2462034006668988556,4621728434119175431]' ) or IsNull( td34e50a2.col_37 );

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

No error

3. What did you see instead (Required)

mysql> update td34e50a2 set td34e50a2.col_41 = '[6028379176574077045,1827860736484397991]' where JSON_OVERLAPS( td34e50a2.col_41 , '[1,4189335613865098857,2462034006668988556,4621728434119175431]' ) or IsNull( td34e50a2.col_37 );
ERROR 1105 (HY000): runtime error: invalid memory address or nil pointer dereference

4. What is your TiDB version? (Required)

1b6453f
@wjhuang2016 wjhuang2016 added type/bug The issue is confirmed as a bug. fuzz/randomtest labels Jan 15, 2024
@seiya-annie seiya-annie added sig/sql-infra SIG: SQL Infra and removed sig/transaction SIG:Transaction labels Jan 15, 2024
@YangKeao YangKeao self-assigned this Jan 15, 2024
@YangKeao
Copy link
Member

YangKeao commented Jan 15, 2024 •
edited
Loading

I failed to reproduce it on both the nightly cluster and the commit (1b6453f) provided in the issue:

mysql> explain analyze update td34e50a2 set td34e50a2.col_41 = '[6028379176574077045,1827860736484397991]' where JSON_OVERLAPS( td34e50a2.col_41 , '[1,4189335613865098857,2462034006668988556,4621728434119175431]' ) or IsNull( td34e50a2.col_37 );
+------------------------------------+---------+---------+-----------+---------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------+-----------+------+
| id                                 | estRows | actRows | task      | access object                                                 | execution info                                                                                                                                                                                                                                                                                                                                    | operator info                                                                                                                     | memory    | disk |
+------------------------------------+---------+---------+-----------+---------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------+-----------+------+
| Update_4                           | N/A     | 0       | root      |                                                               | time:738.5µs, loops:1, RU:1.966637                                                                                                                                                                                                                                                                                                                | N/A                                                                                                                               | 0 Bytes   | N/A  |
| └─Selection_6                      | 31.95   | 0       | root      |                                                               | time:729.3µs, loops:1                                                                                                                                                                                                                                                                                                                             | or(json_overlaps(test.td34e50a2.col_41, cast("[1,4189335613865098857,2462034006668988556,4621728434119175431]", json BINARY)), 0) | 3.85 KB   | N/A  |
|   └─IndexMerge_15                  | 39.94   | 0       | root      |                                                               | time:727.2µs, loops:1                                                                                                                                                                                                                                                                                                                             | type: union                                                                                                                       | 226 Bytes | N/A  |
|     ├─TableFullScan_9(Build)       | 0.00    | 0       | cop[tikv] | table:td34e50a2                                               | time:19.4µs, loops:1                                                                                                                                                                                                                                                                                                                              | keep order:false, stats:pseudo                                                                                                    | 0 Bytes   | N/A  |
|     ├─IndexRangeScan_10(Build)     | 10.00   | 0       | cop[tikv] | table:td34e50a2, index:idx_20(cast(`col_41` as signed array)) | time:595.8µs, loops:1, cop_task: {num: 1, max: 517.5µs, proc_keys: 0, tot_proc: 41.8µs, tot_wait: 66.5µs, rpc_num: 1, rpc_time: 502.9µs, copr_cache_hit_ratio: 0.00, build_task_duration: 20.7µs, max_distsql_concurrency: 1}, tikv_task:{time:0s, loops:1}, scan_detail: {total_keys: 1, get_snapshot_time: 25.5µs, rocksdb: {block: {}}}        | range:[1,1], keep order:false, stats:pseudo                                                                                       | N/A       | N/A  |
|     ├─IndexRangeScan_11(Build)     | 10.00   | 0       | cop[tikv] | table:td34e50a2, index:idx_20(cast(`col_41` as signed array)) | time:585.2µs, loops:1, cop_task: {num: 1, max: 528µs, proc_keys: 0, tot_proc: 41.9µs, tot_wait: 33.8µs, rpc_num: 1, rpc_time: 503.6µs, copr_cache_hit_ratio: 0.00, build_task_duration: 21.2µs, max_distsql_concurrency: 1}, tikv_task:{time:0s, loops:1}, scan_detail: {total_keys: 1, get_snapshot_time: 12µs, rocksdb: {block: {}}}            | range:[4189335613865098857,4189335613865098857], keep order:false, stats:pseudo                                                   | N/A       | N/A  |
|     ├─IndexRangeScan_12(Build)     | 10.00   | 0       | cop[tikv] | table:td34e50a2, index:idx_20(cast(`col_41` as signed array)) | time:581.5µs, loops:1, cop_task: {num: 1, max: 510.2µs, proc_keys: 0, tot_proc: 41.9µs, tot_wait: 38.3µs, rpc_num: 1, rpc_time: 484.4µs, copr_cache_hit_ratio: 0.00, build_task_duration: 16.9µs, max_distsql_concurrency: 1}, tikv_task:{time:0s, loops:1}, scan_detail: {total_keys: 1, get_snapshot_time: 9.6µs, rocksdb: {block: {}}}         | range:[2462034006668988556,2462034006668988556], keep order:false, stats:pseudo                                                   | N/A       | N/A  |
|     ├─IndexRangeScan_13(Build)     | 10.00   | 0       | cop[tikv] | table:td34e50a2, index:idx_20(cast(`col_41` as signed array)) | time:575.3µs, loops:1, cop_task: {num: 1, max: 524.3µs, proc_keys: 0, tot_proc: 74.4µs, tot_wait: 68.3µs, rpc_num: 1, rpc_time: 494.7µs, copr_cache_hit_ratio: 0.00, build_task_duration: 21µs, max_distsql_concurrency: 1}, tikv_task:{time:0s, loops:1}, scan_detail: {total_keys: 1, get_snapshot_time: 26µs, rocksdb: {block: {}}}            | range:[4621728434119175431,4621728434119175431], keep order:false, stats:pseudo                                                   | N/A       | N/A  |
|     └─TableRowIDScan_14(Probe)     | 39.94   | 0       | cop[tikv] | table:td34e50a2                                               |                                                                                                                                                                                                                                                                                                                                                   | keep order:false, stats:pseudo                                                                                                    | N/A       | N/A  |
+------------------------------------+---------+---------+-----------+---------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------+-----------+------+
9 rows in set, 1 warning (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 1

Does it have any special configuration? Or did you keep the log so that we can get the backtrace of this nil pointer dereference?

@wjhuang2016
Copy link
Member Author

Update case：

CREATE TABLE `t99f70d2d` (
  `col_29` bigint(20) NOT NULL DEFAULT '3829034190158003176',
  `col_30` timestamp NOT NULL DEFAULT '2011-05-01 00:00:00',
  `col_31` json NOT NULL,
  `col_32` varchar(51) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`col_29`) /*T![clustered_index] NONCLUSTERED */,
  KEY `idx_14` ((cast(`col_31` as char(64) array)),`col_29`),
  KEY `idx_15` (`col_30`,`col_29`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `t99f70d2d` VALUES (8097137304214681475,'2026-04-02 00:00:00','[\"XsYE4RggnHuzWDyzrHcqFTxXJnKUOI44lBPIUKVcNSDWIb8mEgrGyMfn3UD9InPS\"]','AHXBPG~yKtaMWN'), ; INSERT INTO `t99f70d2d` VALUES (8097137304214681475,'2026-04-02 00:00:00','[\"XsYE4RggnHuzWDyzrHcqFTxXJnKUOI44lBPIUKVcNSDWIb8mEgrGyMfn3UD9InPS\"]','AHXBPG~yKtaMWN'), (4520476612459661625,'1996-05-30 00:00:00','[\"XsYE4RggnHuzWDyzrHcqFTxXJnKUOI44lBPIUKVcNSDWIb8mEgrGyMfn3UD9InPS\"]','GESrTDXLxi14H*cSR'), (7469142675698740591,'1990-09-07 00:00:00','[\"XsYE4RggnHuzWDyzrHcqFTxXJnKUOI44lBPIUKVcNSDWIb8mEgrGyMfn3UD9InPS\"]','=jaIN0ki-5gU'), (248770552198223389,'2002-03-19 00:00:00','[\"XsYE4RggnHuzWDyzrHcqFTxXJnKUOI44lBPIUKVcNSDWIb8mEgrGyMfn3UD9InPS\"]','DWrqrP'), (8491535244927769930,'2004-11-14 00:00:00','[\"XsYE4RggnHuzWDyzrHcqFTxXJnKUOI44lBPIUKVcNSDWIb8mEgrGyMfn3UD9InPS\"]','G8l&x=3C5muYoeN$0h'), (3944886205705358328,'1984-02-06 00:00:00','[\"XsYE4RggnHuzWDyzrHcqFTxXJnKUOI44lBPIUKVcNSDWIb8mEgrGyMfn3UD9InPS\"]','@rh&VtxpRI)mhl'), (4727389195119507936,'2034-02-27 00:00:00','[\"XsYE4RggnHuzWDyzrHcqFTxXJnKUOI44lBPIUKVcNSDWIb8mEgrGyMfn3UD9InPS\"]','Si*oOp'), (3143321576046121673,'1976-05-17 00:00:00','[\"XsYE4RggnHuzWDyzrHcqFTxXJnKUOI44lBPIUKVcNSDWIb8mEgrGyMfn3UD9InPS\"]','Jh)AvF&wLxSiWItFE$j'), (6414429323479095657,'1973-12-11 00:00:00','[\"XsYE4RggnHuzWDyzrHcqFTxXJnKUOI44lBPIUKVcNSDWIb8mEgrGyMfn3UD9InPS\"]','(GOw%@jVAq)'), (2983675364568397065,'2023-09-15 00:00:00','[\"XsYE4RggnHuzWDyzrHcqFTxXJnKUOI44lBPIUKVcNSDWIb8mEgrGyMfn3UD9InPS\"]','1!n$'), (7005403057338812085,'2010-10-29 00:00:00','[\"50XllZMftERyXp5UiUsgT50hTAoLQ1yTKfNsqaqjpHEODtxGH8J1ouGz7mZUIItN\", \"efq7ywtOMiM0RR0ngL6hHPoEOGYsPB2KfzxYuDRyidknX9DGMLGhNYbn0kfLb74D\", \"bxDrKmQJi1coEGvPz6aWhVMHeunvDmMZOl1ngMp5EyXw8sNp2wXVJA3p9k1Z2lBI\", \"aGxoNA2xpGqkU7Yr4mAq10jjTseqAhSBSHK62pXf7gNRfNmKDAxGHgXNsqs8vUOy\", \"EacKHDL6ec1sZpvbBCNBuZqKGdnknzXsHjjDKOZLRxHloavTW2egLZGDByuQ0OoW\"]','(Ns=tWN'), (-1,'1993-07-29 00:00:00','[\"5ikM6V80sZkTznAGPtj54GbbTTRaAWk4wK12rif5FMUu8v11Bp768O2SldByvGWW\", \"g5Ahe8PSq7fKa1wlIKe58CwT2GJVjvp6n4QucemthVgBQMULMmqUSYc7cWv5WKcZ\", \"Ob5HViDPHLDqd5r4A4WNVhUL0jaOerTTh8kAhMsNm3nKVtKKDxak8z5TOaC4wllp\"]','pd$B'), (8040416941288894633,'2029-08-26 00:00:00','[\"JZ3LVuZwxsdF42R0OG4IZpPdsveKWxcTa8ChH1CTreHLrGhaqBPlm3lqCXtH7i9z\", \"xLYScRSTyCui7QLrWs8XOJxNrTmHV7DAY2OBBAXnGSt2flBcDiFndRENhykOuDLq\"]','k1A'), (7085903490108990378,'2021-10-20 00:00:00','[\"YEiZIUv03icQ7nIhq1PL8lBgLDVQbbQCmTkV2jbvL803hgxWczylNF8IA1VdNltU\", \"kQdgc28CxcsSdb06cdz9acfl267au3Pp2Lse6xy1PbufCXvGRNqZHvELFb6SVXEG\"]','1RrNIf'), (5489138993780284931,'1976-11-05 00:00:00','[\"Pge7wxFiOKU8AOFw9WgvxPdKMxrySfat8eU3YsKJlMbB7YLm4NKw1Bwu6RPhP2G9\", \"i3roxBcLpKJqeakkVudMZ6u133pTefVTkBluHW17mqNCXPOHo5ZeneqJ6t3FXsAw\", \"uLnLFgAW1e1UpW5nRdoHXVKcDUdSXtEvcg8CvH6Y0AQ5TnmEqVogRows3UZtkZOL\", \"RZCdMmtv0BI0VeoHZARDSrxgUqB9RP2EGvTbTqbBPo0Uw2bLyututax0qliBPFRp\"]','NXs(Qsn'), (5490310801880742830,'2017-11-07 00:00:00','[\"R6UmUX45zTi130W5YoNNtIxj673141dKqRJzaar14ZQY22jMktp9oW3E4mckOFbT\", \"h12kaLlavEP0AW6T5H3dh89CWGNDMsGx1BnFkd67gNGFO78KSny7sBJBFGkzuU4C\"]','H'), (-9223372036854775807,'1983-08-09 00:00:00','[\"7wKBF9vxLxzTdvmUCkqKvf6J2kdVUHIHMnNQ5tik6b8PUaDR3x2Z53j79FIikh7R\", \"l1SSHjOY4SxQe7hUcWMqxJ1HYDgeya9hC7zdDJ5tb2Adfkwk8hfk4Mjoj76v8uec\", \"wZd2Sd2YlxnDaLODGN8xW1bScBdSp3ND3A1DyENfVbXVo3S6NjvJ4zqBcEXgz7F1\", \"VOkdKhsgnThNiB0jLA0tNdTo5xZ3AMGkquA5HtX0rVVVPXoH9KcwsIXYWdA13Nzj\", \"M9RzPtxDEfIZSH2fT6D8uWFcVue9FtvYfZeU1FJ9WNvxEhrwRqtiOm3i7NXXZcHN\"]','WnC$k4ds479wv'), (4198325506401250924,'2004-01-25 00:00:00','[\"J6Ql5ZCfVCXwPZc6QlteRtl5jy6cylbWnKU4oQUZV5sPbtuWyeCEi2bAaPCFvKQG\", \"ScCi29WdJt1wODT2S0ZCgEJAQ6hIm0GXvTqDsNRqVZPaFnIPr2AXOZnQ5RMQtgS5\"]',''), (2978909401053571675,'1994-07-15 00:00:00','[\"vWTF02czN3bwybiKRlMqGBOptA9AohIVLEkDWNbEFWaPvmysTh6v9JBzqDyfO4k4\", \"6KIZePx7RsoSBn6ytUkZOabfG3Xgc9MhwWhUatgP8nS9TfXqyOE4uFNHBiEhtcC3\"]','h$jNM_b'), (8834320200269343341,'2022-06-19 00:00:00','[\"meLaumbMqkff4GCuQJLe4idaMnCjmgxGSbVGZHXgsZ1ywjBydyMpSya3j5UlmCQN\", \"BfJOjSZcB5dy0ouIiVrUOBUA4lnICvAIFIL0Lep64eXqnYmdtVnpuZx1jVIbFWsd\", \"pdcPYjHfrI7xHLbTdNsa5YUDOVuQYkoLQ0mM000sWPqilwaSg2GIKJ9WeLJbjGq1\"]','2e7e_3Zuvgs3@E&HIUD'), (1891878702768845293,'1984-12-09 00:00:00','[\"Q0BKwa0UiMWJuluCFQtmQJiVGGp17UMTcPO0v2k0afFVixt7xu1Z8ifghjnEvZMJ\", \"6kjjc6OclkrQ0egeobrNnmEECAV8nqwIPFYF3xi3bq9wXFfFNu5CS65WELf4qBiu\"]','c^&EdFBI'), (346561493214905497,'2006-08-27 00:00:00','[\"FYDnmFR04KeirRpaujtKc7lTaBw64zTmm28JttKCbSfx1CzrNv3adRZtZ0nmapLA\", \"nGPJoLxauPxUQXjfioTPuTO4THFlvpbtr1P98TFwBLhWikZAZ4l1mzx9rwJuOmfK\", \"cFxHKVHb7pEppR9pqQJHjZUFUv3Unb5nPHWKNRgJnR6r7qbz7Alf8xjy3UDnKVQk\", \"0XQVRVu58WLscXmM75cFZHTOSUjGW6JmeWI850MRhNQijUyI1fTR1DS5WTbS7h2r\"]','Y)+)5o*aUj_6=$');
update t99f70d2d set t99f70d2d.col_32 = 'cKtK4kbrEs(' where IsNull( t99f70d2d.col_29 ) or JSON_CONTAINS( t99f70d2d.col_31 , '\"wTgsEweWuGcHUjmcss4QncT1tGMOdGlS4GJVgidXBhrYvEQxLMUZyMyXePvLzNsR\"' );

@YangKeao
Copy link
Member

Backtrace:

        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/cardinality/selectivity.go:484
github.com/pingcap/tidb/pkg/planner/core.(*DataSource).buildPartialPathUp4MVIndex
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/core/indexmerge_path.go:1173
github.com/pingcap/tidb/pkg/planner/core.(*DataSource).generateIndexMerge4ComposedIndex
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/core/indexmerge_path.go:1044
github.com/pingcap/tidb/pkg/planner/core.(*DataSource).generateIndexMergePath
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/core/indexmerge_path.go:92
github.com/pingcap/tidb/pkg/planner/core.(*DataSource).DeriveStats
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/core/stats.go:493
github.com/pingcap/tidb/pkg/planner/core.(*baseLogicalPlan).recursiveDeriveStats
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/core/stats.go:139
github.com/pingcap/tidb/pkg/planner/core.(*baseLogicalPlan).recursiveDeriveStats
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/core/stats.go:132
github.com/pingcap/tidb/pkg/planner/core.physicalOptimize
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/core/optimizer.go:1203
github.com/pingcap/tidb/pkg/planner/core.doOptimize
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/core/optimizer.go:340
github.com/pingcap/tidb/pkg/planner/core.DoOptimize
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/core/optimizer.go:370
github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildUpdate
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/core/logical_plan_builder.go:5956
github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).Build
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/core/planbuilder.go:541
github.com/pingcap/tidb/pkg/planner.buildLogicalPlan
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/optimize.go:549
github.com/pingcap/tidb/pkg/planner.optimize
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/optimize.go:467
github.com/pingcap/tidb/pkg/planner.Optimize
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/planner/optimize.go:335
github.com/pingcap/tidb/pkg/executor.(*Compiler).Compile
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/executor/compiler.go:104
github.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/session/session.go:2185
github.com/pingcap/tidb/pkg/server.(*TiDBContext).ExecuteStmt
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/server/driver_tidb.go:294
github.com/pingcap/tidb/pkg/server.(*clientConn).handleStmt
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/server/conn.go:2024
github.com/pingcap/tidb/pkg/server.(*clientConn).handleQuery
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/server/conn.go:1775
github.com/pingcap/tidb/pkg/server.(*clientConn).dispatch
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/server/conn.go:1349
github.com/pingcap/tidb/pkg/server.(*clientConn).Run
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/server/conn.go:1122
github.com/pingcap/tidb/pkg/server.(*Server).onConn
        /home/yangkeao/Project/github.com/YangKeao/tidb/master/pkg/server/server.go:713

I have a smaller reproduce:

create table t (j json, i bigint(20) not null primary key, key mvi((cast(j as unsigned array))));
insert into t values ('[1,2,3]', 1);
explain select * from t force index(mvi) where isnull(i) or json_contains(j, '1');

It seems that the function CalcTotalSelectivityForMVIdxPath cannot handle a TablePath well. In this case, isnull(i) is a table path on primary key.

@YangKeao YangKeao added sig/planner SIG: Planner and removed sig/sql-infra SIG: SQL Infra labels Jan 15, 2024
@YangKeao YangKeao assigned AilinKid and unassigned YangKeao Jan 15, 2024
@time-and-fate time-and-fate mentioned this issue Jan 16, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 16, 2024
@time-and-fate
planner: fix panic when table path and mv index path are both used in…
7801b91 
… access path (#50474)

close #50420
@ti-chi-bot ti-chi-bot mentioned this issue Jan 16, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 17, 2024
@ti-chi-bot
planner: fix panic when table path and mv index path are both used in…
f573a65 
… access path (#50474) (#50480)

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

@time-and-fate time-and-fate

Labels
affects-7.6 fuzz/randomtest severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

planner: fix panic when table path and mv index path are both used in access path time-and-fate/tidb
6 participants
@YangKeao @AilinKid @wjhuang2016 @time-and-fate @seiya-annie @ti-chi-bot