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

incorrect result using CTE and subquery #53857

Open
wjhuang2016 opened this issue Jun 6, 2024 · 2 comments · May be fixed by #54252
Open

incorrect result using CTE and subquery #53857

wjhuang2016 opened this issue Jun 6, 2024 · 2 comments · May be fixed by #54252
Assignees
@hawkingrei
Labels
affects-6.5 affects-7.1 affects-7.5 affects-8.1 affects-8.2 fuzz/randomtest impact/wrong-result 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 `t9172e9ec` (
  `col_1` int(11) NOT NULL,
  `col_2` json NOT NULL,
  `col_3` char(119) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '1Fj!VQi4iQ)^PgL_+l',
  `col_4` varchar(286) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'cU',
  `col_5` float DEFAULT NULL,
  PRIMARY KEY (`col_1`,`col_3`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
PARTITION BY HASH (`col_1`) PARTITIONS 3;
INSERT INTO `t9172e9ec` VALUES(-2124506745,'[7854852970062856851, 485712809120497816]','m9dYdi-QwRg#*o*A3Ip',')u$3a$dfL4rc',8833.722),(-1987900253,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','rA0yD=c3(zA#Tx4Me=%','5=-l6',8261.812),(-1801039543,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','q','5=-l6',2249.8162),(-1801039543,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','qNiB(j^v=9#m)5I','5=-l6',8015.3647),(-1555981914,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','wREM','5=-l6',7211.5654),(-1512956812,'[12237306431704586590, 15033675751746115877, 17890410345510922576]','YKec~g','pvNYq!TYOu',4839.073),(-1427641173,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','k^j_b','5=-l6',1043.4517),(-1241352378,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','xJnURwQG!s9If','5=-l6',1577.0089),(-1137801237,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','q!8&+','5=-l6',6956.594),(-1135860082,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','mFIwt_-nw^+=xzhFO7','5=-l6',9747.357),(-833071871,'[3671565389575202116]','s(W6=&fu4+@@O1Dh4P=','B',6504.2065),(-401167891,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','~3xV&h^)ZNPTlC','5=-l6',3470.9688),(-385141748,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','oc','5=-l6',4505.947),(-369638048,'[6692908082570525008, 11282158432044887632]','7CLPayG','!%u0*yeZTW#+OhWEc+',4696.878),(-316801815,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','oMhb_vrKJTv!BIm0lNS','5=-l6',677.98785),(-155320341,'[15037175073412781918, 6436057204829237547]','9DhQlP=','Ild(5Ft4C!^zrk@7O=F',2871.2407),(-129161234,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','n3qVghjnkx*#zy9AaV','5=-l6',8387.211),(154916136,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','mkJsR','5=-l6',5501.6943),(241213743,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','xyaR%xp5m5g-H','5=-l6',8753.599),(297737358,'[10881785351205027060, 10968098726351092777, 13447444998800967333, 10787113729586840005, 18164090871369150855]','ZZbM','G&L*a%V1',9692.497),(361364887,'[13571935304690400155, 15428459843371141639, 5166067369409479765, 13376215633079336076, 14918734709157485711]','nYpg','K3&a9W^sbyS=nH~',NULL),(461116246,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','m','5=-l6',4245.67),(690428690,'[13874302886417823206, 5106557973216105875, 4500765527154768391, 698879997138293585, 4238860526309864992]','fZxMsQ','rb6R5NF',NULL),(787126218,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','oh4fN@M_bk4#s&N','5=-l6',8638.904),(1955454898,'[4784139917445341210, 2409847733994134699, 10707724437804402980, 6577977165263525461]','llE0aPj@+N_#k@Q','5=-l6',798.27545);
CREATE TABLE `ta0c4280a` (
  `col_64` time NOT NULL,
  KEY `idx_25` (`col_64`),
  UNIQUE KEY `idx_26` (`col_64`),
  PRIMARY KEY (`col_64`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin;
INSERT INTO `ta0c4280a` VALUES('00:00:54'),('00:07:16'),('00:13:36'),('00:19:54'),('00:22:22'),('00:22:47'),('00:40:24'),('00:41:42'),('00:42:17'),('00:45:20'),('00:47:50'),('01:26:40'),('01:47:38'),('01:49:41'),('01:56:35'),('01:59:55'),('01:59:58'),('02:01:25'),('02:12:23'),('02:12:28'),('02:26:30'),('02:32:16'),('02:50:53'),('02:55:45'),('03:01:28'),('03:09:41'),('03:10:02'),('03:18:21'),('03:22:04'),('03:24:53'),('03:32:52'),('04:15:04'),('04:39:11'),('04:44:55'),('04:48:13'),('04:50:28'),('05:27:20'),('05:35:49'),('05:40:36'),('05:44:35'),('05:47:27'),('05:53:50'),('05:57:15'),('06:00:53'),('06:05:09'),('06:23:28'),('06:31:53'),('06:48:26'),('06:50:34'),('06:58:10'),('06:58:34'),('07:02:03'),('07:10:37'),('07:19:28'),('07:22:30'),('07:44:38'),('07:47:35'),('07:52:10'),('08:06:39'),('08:12:58'),('08:18:35'),('08:33:16'),('08:37:23'),('08:44:13'),('08:46:17'),('08:47:15'),('08:58:06'),('09:02:19'),('09:10:07'),('09:13:38'),('09:18:38'),('09:41:40'),('10:11:05'),('10:31:32'),('10:31:59'),('10:42:32'),('10:43:47'),('10:48:58'),('10:49:19'),('11:02:52'),('11:14:33'),('11:20:24'),('11:26:11'),('11:27:17'),('11:29:45'),('11:39:55'),('11:41:01'),('11:45:15'),('11:46:21'),('11:48:16'),('12:05:01'),('12:05:42'),('12:13:23'),('12:18:18'),('12:18:23'),('12:21:06'),('12:21:11'),('12:36:24'),('12:36:35'),('12:40:39'),('12:47:46'),('12:48:36'),('12:52:06'),('12:53:30'),('13:06:13'),('13:07:50'),('13:10:11'),('13:11:11'),('13:12:46'),('13:24:08'),('13:26:34'),('13:35:50'),('13:38:14'),('13:40:34'),('13:42:23'),('13:42:47'),('13:50:32'),('13:51:59'),('14:00:39'),('14:01:32'),('14:14:22'),('14:32:35'),('14:36:32'),('14:36:59'),('14:38:41'),('14:41:52'),('14:42:17'),('15:02:46'),('15:04:34'),('15:17:59'),('15:18:07'),('15:36:06'),('15:36:20'),('15:44:23'),('15:46:15'),('15:51:33'),('15:59:15'),('16:04:02'),('16:22:21'),('16:37:16'),('16:42:40'),('16:47:08'),('17:03:05'),('17:09:33'),('17:15:36'),('17:22:57'),('17:37:49'),('17:38:09'),('17:44:14'),('17:46:30'),('17:48:38'),('17:50:30'),('18:05:08'),('18:17:02'),('18:20:07'),('18:31:48'),('18:37:57'),('18:42:36'),('18:52:06'),('18:55:54'),('18:57:08'),('19:07:16'),('19:09:46'),('19:22:10'),('19:24:52'),('19:30:43'),('19:33:07'),('19:35:00'),('19:39:36'),('19:49:19'),('20:04:28'),('20:18:42'),('20:24:42'),('20:36:50'),('20:36:52'),('20:37:39'),('20:41:41'),('21:11:41'),('21:15:56'),('21:28:25'),('21:32:26'),('21:38:45'),('21:45:56'),('21:59:31'),('22:02:33'),('22:08:19'),('22:13:24'),('22:26:54'),('22:31:52'),('22:54:18'),('22:56:38'),('23:22:58'),('23:32:42'),('23:41:17');

CREATE TABLE `tld1ce2472` (
  `col_52` json NOT NULL,
  `col_53` date NOT NULL,
  `col_54` datetime NOT NULL,
  `col_55` json NOT NULL,
  `col_56` datetime NOT NULL DEFAULT '2030-11-15 00:00:00',
  `col_57` json NOT NULL,
  PRIMARY KEY (`col_54`,`col_56`) /*T![clustered_index] NONCLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_chinese_ci;
INSERT INTO `tld1ce2472` VALUES('[\"sQ3DTecnoKDB04UlsE9fZnuHcOmsKKmlgZcSZu47TkGSve1YYrGjX7d46eSVAcLT\", \"QD24Or3D1BsDv1Q9fraSfexPhEgwceKdYI6uUvcmN3VAD8hdu2MAmC7I1rwUuzBF\", \"rpgf3MpXDVtGicbZXiktVIZPqcclm3tiA3Ui64Vet17zp3xy2mm7rogqscTueQcO\"]','2008-05-07','2011-12-13 00:00:00','[\"c04PqN1B1h2dxEmcHOUYNhLHNNEQlFnkRhnuftF0Bd7DlkoL46XOnG1Vfd3gVmWe\", \"CAroaoW5ei2wyH8HKdK6uKBt829sYfcddZKRQsHxCRRNEeY8NSwT0ddr6JxXc5m0\", \"U0XhDvZWb93tiFONlwr47jtFrSVDJLPVYHPoKEtwGcqov0FwpbvUR9OfjisyYxmc\", \"BWLKZIE08UFH08DQ6klBLflJZwmVtkWz4aj35lt3myVIh6UXCzDLT8zA3uF4rhZg\", \"cAgPZvbC9xJT2i421NBzhl5UqWDSdOaT5niB3SpkTDOA37ovL7RuqKG9rpaJdUOl\"]','1976-01-24 00:00:00','[0.2044318454344091, 0.022017863976707134, 0.4001102885564622, 0.2508550080069659, 0.04603861529897418]'),('[\"8risuwRixSO7I9JF2FblCF5nrRAewwZgGd5KeaaKYhWm4H8S4URVXUlwEg0i7pXm\", \"HjTk7soYR318JIarutZkMK8fxz5CvMepeVer2SUNQqpucA0ia81gKNGSI5CpaAim\"]','1987-09-09','1981-09-05 00:00:00','[\"Gzdrj1TFDO0hA4fT7jL47ADL6WSDllOEiG84M5o8xMPMDXQ1J2ERszd7wtwccYln\"]','1972-02-19 00:00:00','[0.6541864885449548, 0.6847267454153251, 0.21656763359152537, 0.4157849328013752]'),('[\"NVnk2gAW0leRUvJ7K4kc8pFCTQptBQCpbJpzJM0a1UwSg5yZRBoIo6C8HAl7Anfl\", \"agpfAniYB9J4ry2yxM7lmHHkdxDlUOg7ysnDDS224Uy35hQohkx6ZlQ95Pdmi8ym\", \"iGmlCEBWX39tArtJQDDRhhXDkrO9t4325b1LVZ0d4jSrHhNyFbLxPk0DdXHGiPuD\"]','1996-07-15','2015-03-31 00:00:00','[\"r5Ebn8Bu9hWCgBAKyTJkwm1msCMPGqE0qPNqJePIr9lfY9DDUfj7uBngnaduJW3E\", \"6qhD8BwmvaiYSuuWBJjZzD47KwqPQrVrVhzYBB6d4OMUdkArN7ppz2kLnm5jqAHc\", \"I72IGndAp6dHcYJqB1rzkYelAZZKeW07p2mWRfrbu3beki0LL0yOrMos7eOspLd8\"]','1979-04-09 00:00:00','[0.41150895967330214, 0.5068919190831073, 0.5868392081295616, 0.3143672081876886, 0.08395895213379623]'),('[\"gdlG6ksXifxNRJzuBsBgW4LVUeFjmbEGqoYzqK0x0v74w6jRkhQk4PafSG3pjNcg\", \"kckeddQI88gj3bcQIhJ4wRiV9HXHcelHpFoUTopaiJN8dvg54ppRkaXlw2Kr8XVN\", \"XmnfNLQwFULh6ZORviXWeknaTBnPiYy4fB1d3kQ89stcch1GhvJb4a1N6PfVv0cf\", \"XuSelWDc1ngOXdevOsj3bqd8XLuCdie3NysT6t4vhi23ki3d4w7G6sbellInLodQ\", \"P45ms1m7nSH7P8xeGGVkYvn9sYKaEr2hroNH0Mk6gLCLBUrifgdDMMoK0xvqwxrF\"]','2016-02-03','2028-04-14 00:00:00','[\"aWr92VD66L2bG5CMhhlpEAizRI4oL5a97ec67NDDFpHZUt7u4CIeGqLrvM8vBhRC\", \"f2gJNBlnCP9XEW6lUtQzGLoKNL25UyRakj1IiH1tPOdCnM1ZObvthPpkGI6M7Pi2\", \"4mw5z3QEZTjmylIMthCp4FR12ko8zutmuTguRXP4yDNwQbbM4p5ER50sbDLdFn1Y\"]','2019-02-06 00:00:00','[0.18762694195376287, 0.3689823603721429, 0.610368713091008, 0.7178364851908664]'),('[\"IJldX6gjLYtfNPp45PkUpCirHTBkcmLrguAiUgmqlKlvucrMQV0HB9x4zSpCfABg\", \"0proaVQk1GsPN3f8c0U7zDXjxIvpvgaTUVCakM36wlSd9HHmsJA6FakToDdEOBW5\", \"9z4fFSGThKxOzLnJix4WbZnFPrRlcQPKgT1XO24m7mYrmohfNByh70ZFsL4qd8wo\"]','2000-01-05','2025-08-29 00:00:00','[\"2NO9y1CFjiSLkUKlCgNzYi6l3e4pccRny7ghwgyIExfpH3pahiEawIykAo0B5fpb\", \"FcPummX2RLSgyK7pwG3jtvPhbSoCPYkRPYJKGkn5LIUOaMiEBWp8uJF7qUiEsnxC\", \"b7ccR5P5cctNKFtFjOEkkxUAq8nvxt0ulSY4AWdwwjim6pF2tf6Z6cjVRhuwRjqS\", \"oEPUXQM0MWt9R2vzf0VxPQYbi4ahMwyt34ilJ94pnl3l20MJnInZQIj7bQOTX7zE\"]','2028-07-15 00:00:00','[0.9674478048581427, 0.2222114351688126]'),('[\"ym5oBkTFkkeDKu8XCU9VjLmwamYxa0kTF6p9zRjSFgBnFE0q1bpQKfuoSmKZP7iv\", \"2SnLWzJtZqlfH7cnxPC3tJb3e3RmN3cW5s3FnjbZdkTnTrwQfdNTYoikmNe1Fbxr\"]','1978-06-18','1978-03-09 00:00:00','[\"bpoyZPQkhVjEj9syukrU4XrLuT1SfKppEjrn8r8qTi6isAvHdWefe4xQOQUekUvh\", \"D0aIqSi6mM2ENKRrqyGw7V1RjiIYFKPZm3WoBpVoHyt2SMIjN2z6yzknO9LKmY2z\", \"P1sIX5FEffa02NvQMyxHyHhsXX4q9fqPGzfpZcJ49eaR87j07dYVqzV3JmbmbT5l\", \"3r7DrA8yp6udkInkwax6F8pzGvGQ1IzQGjiP9l0pAePspHLMgauMTy9sN5gyi9W4\"]','1982-08-17 00:00:00','[0.8104981513704869, 0.5554296267840119, 0.15148036211320645, 0.3089212940993241]'),('[\"IjExPD7nBEdiZo0JWiGdqj1QczqNYczMZzfsBTbFFMwblmAHF0eWWpfraBU73Mxv\", \"PW7Cct2TmwIOZnBm9FVnMcaBE4upxpunbMWMsAylLqZhKXv5iRExEjv1R1ZZBG35\", \"Yp7koedCnwUBySeZHwBUHbeZrIxU5BVsFzLoraVGCS2mBT0nvSeopNGoyvNBIFoB\"]','2036-04-26','1999-09-22 00:00:00','[\"qDhPEzORlSK3pp0rM4xMjkTL2Av3w4pboqSPFsZsypqo1aD8HMCdtydGtftt8niI\"]','2016-04-13 00:00:00','[0.22173159880605683, 0.766526350394025, 0.15976997253636382]'),('[\"BeCNPq05ps8jyXghHcCduvax1uTGN5lxVKerbAwVQOMyYVl6DK8Lal9hr7kb0ENn\", \"DDAtQ7dOKCphmyS9L7vP3R9ZJTCN2smbp1klQp0gVcgUG3myPk77zrDtOYdyXfkF\", \"PRVVeIJpTKH2RTWU9xybHRaTQlsNmnfwhVgpF0WvZSXm9XTzeHD0llVoNjBO51Cv\", \"uGeFbLcOGxaNCrkWZBVczff88mSlDtTq0OlCYb80Vunhd1KtJmyIw13N0HWxZMZr\", \"55DPB4li7uXBLpIS0dwnHI6IZ9XLSxLm74bfEGsqqdPJmo22J0UnmhkuzLuvCab6\"]','1988-02-06','1985-01-20 00:00:00','[\"FdZBvPDMfv1q0GRx79G2py6lAvL6pb2hAZJBY3xSDB4HktYWcyTaDLIqAwGEvQQo\", \"ypX6dOSrUn7ue6v3jt1TJEMe2N8wYop8Qhs2KxFAnaNzO0C8M0WL8vnugXECqjUF\", \"KUmHn4k5VHAlkywMuhjsUdSF0PAKhlJLTRcNpoipG8EytOGWQNj1yaCkFIRXoRes\"]','1975-09-07 00:00:00','[0.8705401834506464, 0.35452960405946554, 0.5874242096203672, 0.1550717839826001, 0.8393586183398839]'),('[\"vH8q1l9oIVwhmVpk8lFmxxzzGGLdKZ5ndMulSB8dzxw09VkwI8EWFv0vrXvHCbui\", \"S3bmEa6qMrBXZiOrfBaWG5EU6ma8RUyQ6TOxlpaA4WXQbunIfW5Dl7fPLGDzz9Ac\", \"dwxTL5ScIMJccTK8HE42NFkY5oGNXZD7yYQtaIYQIhr5h2XaZoGGxq8odXELEg8S\", \"zEbPnyABCd5r8TQlkaZnD3xuEc7ZdM6v4dEesbcTnVQKhwauQVEbFrTuobsj0eBR\"]','1980-08-07','2004-12-19 00:00:00','[\"ghFazkT2xiNmjHey6pMCPzkQUnBl6ZDZNaJdkNOzxJgSLk1R1dnY49gfTHDvYqZI\", \"9oVaH4EPaXQ59PFEVuSjkNZzUWtWHpcwLIg4wIeIlWi13P7WotFfcjB2AwzYK10k\"]','2008-09-21 00:00:00','[0.8933399442803783, 0.2749574908374919, 0.2957384535419304, 0.18474097724774424, 0.7974148420776407]'),('[\"JJ5t1z2gNFoWrL63QJSJpa9LOjNAoXv6orIp2EOaNUFxxu9Z3xedBSsBe1sgrSvr\", \"cbDjBokgQQNiopgnS42CxOBn8pVeCJDT3dkXWGxP09CRQ5xk49XmAVepvIndsoTb\", \"kkc46lojec7AfOWAco1C69xQtToYr2N6KJLUz7LIj3GmULEMSPfoEaGYvxoWzPWh\", \"Q7uMpWS4t4fhw23V7oqTPTudTbb6vpFQnxSICHlEQaRWoRdM8C2qad2bioPA1fY9\", \"xrMqLrUtZT5hdtah7GNVUxRqX6LATf2cgzUltL44Q5VLVh1eTvwjDEiETXj4COkn\"]','1987-02-13','2028-04-21 00:00:00','[\"QnAN7ZuTfFwQwpQ5C9bgPYJJrbiA7XJp6Xv4TvccWzLcBh5YYx8NE84C245qs6EN\", \"eCFKcYZPpUaZgiGE5JEaOMXMpZ6awMwKUIMzWIn9hcZwSzI02b9lXO8SfImbJRep\"]','1971-02-13 00:00:00','[0.33193776490747656, 0.5154397675349843]'),('[\"eQXJXdcZU4TPhyjcRH8wQOgJG9qVitb7aJBtddDqFaJdTIQXNaD28WSA1Eo0euBF\", \"SpyoBa2QOUPIwo7w3Z5P4KF1BasA0Fe1oujUf2exK3Q5DetApO7qUM7UOYmROwGK\"]','2022-05-24','2034-12-31 00:00:00','[\"cut624h0F2Uim28edGLcYTOt12BqSll7dSLBtEIVLkXPWuTU73iGNXbdzaWYLOEY\", \"YNFswJ2UY1O5ExGSi0rMmDab0gl7xtZGIvrIPyzEaiycqGlDhPl4QAv9uavPdWiO\", \"aoRdlHLFfXFz7pWyiQjgyPLUiPLJcGItO40t2LWFRyPaDfpTY1aV2WuEDH3qenu5\"]','1988-02-02 00:00:00','[0.8247831765243192]'),('[\"Wc2nqMv2Hzdzp2cLG6kClWvHpl4m66pnEICIu5rK3tYhwgVtoqHu1x7YyCzXoAjQ\", \"ewfoMyomtgpu4pWxMLUJz46FBznG6h2rSNaWVcmAtMKTC316XAmCeHN2Kxy8BkKE\", \"RkFlp2AeYOA3HSVritwR9kXefDiY5qANrnSA3FquXhhgsMHeINRV7KssF2PowiBs\", \"7JUCh0rsAZsD8FEad63d1RNZNXzyGmRgJp6ANEe6hFEuOqvi97CvAoT9cCqxtZue\"]','2016-12-03','1972-07-05 00:00:00','[\"GCancSWzgLwv9znfZomRIDNYumQ6rUh8M0kRrweynMXqBTKiRJ7AfTiExK6UEOvP\", \"L944q746VFqefnfGvB3Tf9IyOOSVkkxpd69NSiTDM26weRpmq15VPQrPtgFh9GrF\", \"jwm9ilA4DWuGAEfHcvf6ugnVF8mU4iyfrMhhhi81WqvATB3R4EAHIQ6sWNVKJgie\", \"ktY05QCrVn4C4FDThhWZK9hb7rnJWtpLSHhAltZKatZAvZkNsOyFmOHoQvMItf5V\"]','2034-12-23 00:00:00','[0.6008856389305994, 0.10304033595648161]'),('[\"lssjyTBCQkAJ1QbBQvzsQScQtrqb8GQZQ4HNCr9Fm5nqkFlGoQXH1h8kj3NqyW5p\", \"lsEKIBO7QWl2TB3un26wZdDLC37bbU3KDnvpZxJUWgToVbKyzrILLdS2mgYBy21P\"]','1994-06-12','1978-11-02 00:00:00','[\"buMrRmXBPm9SdutmAaBQnJo6kx5PxD5DgboEuKKcEE1XnHLLrwGfRM6WSKMWca2C\", \"8FEp1GPD2VV8XZatbjuNzZ9Z79GZMOw07StxKKltY7SLIQtkRVCsxEZiLhqAIeEA\", \"82dxl070t6CkB8fo8PP1mnenMrV63v9Vlcf8Nzzhj5oNHYwk2urQWrftya0qWDRJ\", \"kcw2TjlVeq44JN9ZC829FtJSjyaunnASik4SyMJMOByFpeKEwOKDYQ33rgt0hW2K\"]','2012-02-11 00:00:00','[0.6277570612427995, 0.5454411297738203]'),('[\"wG2W2JaRcVZAhYURL5Hrbqiap6bZY95fM9OY4pWfnS9Zl5yyp17ee1MTbOreNxGf\", \"rrp16lcpMmaDo8Dhl2snquHuYem4kJ3RW77IuwfN12fdlcnGtv2Ceis6xXr3Ety9\", \"6qf9hanUbsSngKVZtbM1I3BloTBXvOWwnxoTzBpzL8jLynjvQvFHTCkxpVZvcVWr\"]','1985-05-03','2036-09-16 00:00:00','[\"hjRkMRn8hWqryg5oDwpEFC2AEIvlMD9xuUa351Ohy06ImqrPynRGDPbKCjkmJrwl\", \"rKxD7xtliA3n2rT9UUYXWG0xhXa4ialg1vkVGxLUiXkNXA0WVHN5Jq2dHUJoPeI9\", \"43MKN5NVNMpdzaq3RlkDGZJEXEk4bQ8Iuh4qcN53Fn2kfRop3GDiR9GD884FuKd0\", \"20YV0DXetYe6v133Do3UgMHR1uXFuzXBjryIxqBi2MyKdlERmS3nZZ8quOCEL1ja\"]','1983-07-28 00:00:00','[0.28114710718714564, 0.021354294649253792, 0.45153938340584726, 0.35598969419044985, 0.8845288174858683]'),('[\"oqnvNXdXQGgE1uv9EclA8R9XjfG9iEgmeruCmrXg4n4JdH6pavWKY5xk469vEQa9\", \"uFASsTjQNmbVIWznAMSPdC4XwOGRtxNQbTc19WsZSb4VQfKmiMDUCbXv7V2MJCcF\"]','1976-01-24','2014-05-02 00:00:00','[\"18JkGp40SBQ8Vp79KAP1vVGAYhTfSbVdwhS8RqHu8RiWoHzIFANTbU2NGqxYfyaf\", \"vAZS0KWjRHvdZpci8Jw8sUopf0D6qTWQQgPs8rAZB6eQgiwec7mXz6oVBnHvWLrr\"]','1989-05-10 00:00:00','[0.4208078551460235]'),('[\"LgG7cm9DT6rwGIlrxe7ReHzRHDds6GHYHJepXTjFk2g0oaYBR7zKvryNSBjwmpF6\", \"cyM6dO3MY1d6HIWX64ABPzm6KAtScgOOU4YFQ9No5ydIaLemiOwa2iSsr0hTr8Xy\", \"ZQcILvVNTSNYMLTpkbQ5MgTGPCmodsgIYofU2gKsZAFFuG7MIV9fQJb11Dgo6LEd\"]','2007-03-20','2024-01-19 00:00:00','[\"gMmQ23WA2GgDfu6HSoXnf6ze6uxeXslHkEvwWlYoV21sJqHtwaQ6DgSytKg46mdQ\", \"Rcd7TgmEMWWIcYa5PQIqfqfJi6CAv2OKjx5zsENs2c9vCL3XkebqyljXOo14jE1J\", \"956AAzHAuYivb08aLX32dAsgsmsTerZfmnZZm8yGJziH4xR5T0bmg0U66TJJGFiD\", \"laC5C5HFmaszxNWTRCkmQDfrZP1JaxwWa72bkarFnZE0scosoJApByv3TUpHkVHp\", \"RKO7OHN10qlb6n8ybYzCQm1d9oTuWwKWHgNaD4Nxo1zg2Cf4nSmyp3h3VRYRVNUV\"]','2031-05-05 00:00:00','[0.8060840636775954, 0.642041104435424, 0.9540080687107967, 0.16041433481692366, 0.17091702212789037]'),('[\"QBgccD8tseIKMri76e5TNDC1KND9SXcHV0fC635SkOq750HioW8ms7ZJacdhT2nr\"]','1999-05-05','1997-05-06 00:00:00','[\"YxHvXhTcvNwVpXlrDb3D5zxl0dNTF3i22IC8J9rWwo9wScVSwzvAABQacT5MuTEA\", \"6OVblnkf9N6J76G9kKUK9VhcDTdpJKTSYNJiGkRRK5o4jKgxHJGqBNLrcoUYigOV\", \"03Fc8yTgxq56RzogtJispWmwh66T1yJHDFj3YMXHoYukONGGestUBATPJYKJwHcA\"]','2011-07-19 00:00:00','[0.15579453147694006, 0.33177963066270505, 0.6908690844097451]'),('[\"cJe7aECw1jZ8tIFf3Dp3PASUpkRNpicEI6BsON6EG2mE7YeyOlT9ceKNw8UEFsm3\"]','2014-03-29','1984-04-13 00:00:00','[\"VjcRYwofJra048jsmcjOgHdDwVRpgdLpRHptjkexfZ2J0wbZso7HhNg3FjExsqBb\", \"M3JMRpxrvDHLxjNPetwHdTBAGC2bT8Ip5Ggz2uB0J2Ut3OTwzlgmAnHHGEIMfMP2\"]','1970-04-08 00:00:00','[0.948916749838948, 0.4206918428771202, 0.060679772047249565, 0.6640076525615456, 0.9889790975833586]'),('[\"QPDXlJUd6pPvZA5QOvoReTmLOPsualhhFaVlzR6cIyJPi0KMX6vx1ADxQlJz2MH5\", \"yHZkFndm6PsXnkMCrNS6GZ1OiCneMH7kn7b8V430VBfuEZFGqS3EtVPtYFSkx55z\", \"bgLgA6OPMHfCXXQa34ySRvsVwPoZdew8WSAtsq0jS8rXJWo4mxlcikp08HxXDaKK\", \"2ybme9e9vi7rZE6FNTrB1iK8p530dFANOBSVaul6Gs0rQL0dWten1266X6SZAsR4\"]','2025-09-15','1974-06-13 00:00:00','[\"pTueF7kXbrxzIl3XSIN3UkdNtFi4fATx05WvoXpYa2kz5Cfit5ubPJcIxkjmM29U\", \"Q3aANhK23M2CHSKQ30jSoVqpjTVEPvYFYhhQtrifVIqDTObjnLxiQBfcx7mzDfV4\", \"yfKYZxbYHmlui6aYRv9s91jYgl3MYNV9LBqUejTWcpe4M318UNo6k8sjCBi6g57x\", \"0HfvYYaydDCszMy61iXEM3kd5qZOyDmwrFSHoWvD1PHe7OpaEOiR5g1Sh0qsY9A8\", \"j8ODaeU8s8bSPGULUoeY3dnOrr30fHtMDli6GQYQ9YwaIbe9dFIQaPf3NFIpCZfa\"]','1984-11-15 00:00:00','[0.528994129000875, 0.5605515770867295, 0.14821028305828848, 0.7982894590510905]'),('[\"IXa4DtqGB6dKD970f0NzaZvh9J9QoCxDWz7VguwOetmYDMw7wiFOLiLjTtg76Rtb\"]','2020-04-20','1979-03-28 00:00:00','[\"rx8LbV9DqLV64tGwMsUdurNlLzBfuKQeCDb22EFd7EDGxa7EDLPlHUfSKICJynzu\", \"DnxAsbjND7e0bbUSFCxw1xfMlMfN0jCtgdcepl4AM9Sy7YBUvlZ5h4g1Cf95fwGW\", \"x1vF8noZ2Yyc6GIVT8nzRxV4E1g9lKRrdzUz6A4R6Y4NEilkloGovrwgMRtzFWlw\", \"zeRgr2CzG7Sotb9b67PeK7ZsD40GuSMxtN1llKZnuCA9sNRV7Ivek35YSEFWdOLh\"]','2006-08-02 00:00:00','[0.20630171921895388]'),('[\"XQx3ozCSGuybB7EjxI4yFVKguvLO9Cazz2YSVdx1kLFaNE1jZRiAsAgyHupkEPHa\", \"PgsskxaCcbQjWrN3xMtQ1j9YmYxi0dtIrfU48qHBvKlewTJXD7h0bJPJJZmrRjK3\"]','1971-10-25','1975-08-15 00:00:00','[\"dWaMem5dnRjpA0uwV1VrZfk27lWS64UwuOrXA9qhYhNbRr6pyGbqZdMRRyIyXRWq\", \"N77MnMCUp04o0XW3BA43WQKNOeon6X6wTToC8YhyIIoIoPkHVBkWFNBEDmxptgKU\", \"DcdKzACPOrqEZbqMCUwIrOsbp3bvfd0LiOGDg2LnC0fwTz9i5cwZWAh7WzRtyc7z\", \"l8IudkXbnTtGuxCZTfayBPTx1hAVHzCMAcisbXqIGG427n0zZbQDS4yZHBLQv0W3\"]','2009-06-22 00:00:00','[0.1593263193234567, 0.34035088779449396]'),('[\"YsgzLdXz5IvB5q29G1stCXvey0r3qTWv9RDvH27vHYAQ3st3xanrZA80nKH6jD4L\", \"jq8O5pL5cgKcJzU6ujK0CfulhD6Aw78KcCFv5r3FIKGvsxMP03187UmwaAiDw4Cc\"]','2021-01-03','1981-02-20 00:00:00','[\"CnApJ3ILfwffcYx4AVz0Cs1AJxFOqicgJ0ollY5mxLJyHVoy15zURkx48Y688Ueg\", \"4RBrHJFss2wvSeytKHS9mXEL2TqGiiTVXdxqgttv3oQbNZqVhte97YIbp7y2qC5W\", \"3r8H6M1wBvUh6vUjIKVpHHDscC2oBRpRN0yb1UAIGL4jIwwV8FrPUjX8i85kPI6W\", \"FTzBK1fsUTT3rTDHju1YsNVcOXsT7wsoZ5RBzS6SQMTlLNpR6i3qRdEOeZPNc5xO\"]','2022-12-13 00:00:00','[0.8754196728271935, 0.7141393404122288, 0.8235300556896564, 0.21554555345927504]'),('[\"YPbysJv1X3lCkxukFNzZtLVycSmr3CvD6JSMWIdMgT7Z1ISGJ3M4xHm2orZ2QFVr\", \"e2hSaC3Ldwlc0EBQqY7qhwObdz3YyGOTO0Fe8Zn8pgTWBrO4PM4iwaNvxEAa7PrK\", \"fQVlbj4p6Q1YlhHuFrlEaHQcMAkmjZThLdwAxiZmABdeAIqoxh0hM8CD3wMxY75o\", \"eQHI3dvwoyPMxFodcRBDaHWnAcTnRP5i8h3GRuEEYjo1jUD1bjDZ3v4HyBwEOO8b\", \"qIzJgGbjbgfgUWMFhBT2VVV5fFnSUczrtNo4IWjjF81Ap5L1TxExAnLxpBkC95ah\"]','2017-04-08','1998-06-24 00:00:00','[\"4Jo3SnJY3uWZ690agQdv04Mw9VVOlEm5CyFF0jqdSsFd6ql2PnaVlT7b7049vwVB\", \"3vptqqQxLhKkV0XcYtarCW1MatDchxuOBdOelFGqI7yIJ7U7BbTN7sOEZWYr4Fut\"]','2021-03-27 00:00:00','[0.8180578937136436, 0.8131665260858524]'),('[\"HUfwMryglH8wPdd8OZw1bckCiDTOyXYQQwT8D2239tXmYhW6DOoTIf4qpgXWIi4O\"]','1990-11-18','1990-02-27 00:00:00','[\"Uqh84j0LJe6QQopi8E8zguLx6gvQh51rWUj2NvwxYZYgc0wLMfPnEoTIgl3rgEBd\", \"y9YUfwoorTSm4Z0a27GMo5tqXvQO8W1DgAT9aNUGfPvQNuIQLmFjOGPxFrul5Evf\", \"VE7LZG9sudeAKZA1msozHQ6JWlrl66oOy3Kf1dfpM6WSlly9JwBXA1P9YMT5SQhV\", \"Ogo9MbqIy0Qhn77JHmCudeSHnXbYRfgAzqWThmVCCp3pBL1lEOJHnOEJ4ztJ6Bmz\"]','1982-01-06 00:00:00','[0.026131386523690858, 0.6585488872343441, 0.7635409061946831, 0.7872914525072943, 0.7307815826642772]'),('[\"3MyUaU7dGrxc6J1hzHJjHDSxVkwhUwueAw85KpgOrJxSudErBuQiFulfX1kvkf1s\", \"H2MZF255TutMRr9u1D3fuqyaTED8KSlJwBTTxbEo4qnB4xibTH3pXUyFppbC0K8K\"]','2028-06-11','1979-07-11 00:00:00','[\"vyMQejcEh6sfk8EOvn2lhMISLaLHhUNOK00IIQxHpT0ZQCEojSDwaTiLoOoEVExp\", \"220ZT51lWbVasBS6khvK6MGrC0Q4eCQeUTnKF8CpEMtwjas16RyHdxZSnh7yZY6J\"]','2019-11-17 00:00:00','[0.34063902254564044, 0.5850040729325597, 0.33365817698661265]'),('[\"F0WE8GwxgchAX5GKtmDbplAdqjnFUhzO0QHpHRKOOPsaOI5EQKS3rAm04oWSyT0M\", \"WPe1speeGef34rHBW16rABnRdh0aozu5kwYvByNOVR6vXkvAvcs0vNpnrgBxk41A\"]','2020-11-23','1979-07-08 00:00:00','[\"mehvg2vnm2GYOP7EicBn5qY8U9fTlHO8mkf2SetLGjvffEMPA4pXOVXWssak1qJW\", \"Jw4LUVcpgL4NP6CzQyTrzwvqprbijQk4n7fjFB28SdSGv4jWzbfEAuWyrhlOFK1L\", \"wFgMdJnOrmwDA6fmrW1WfqFNG2tCJMNBD7Y1pbtQerbVnkuiG7ehgki5lqK7a7PI\"]','2007-06-06 00:00:00','[0.054501327314774584, 0.6916573434014444, 0.31421126805111077]'),('[\"9Ed67fshAce8zp834HvpeGJwoJXAsEqaebx9o3UWmGnSkJzlpO3CMD4oi1p4PMdl\", \"j9eKWlYdAzjbpm7MQQys2aaTvTpYfWKAMyyeVszqQuX5NWqByeeWbqNF5VvDhprg\", \"5kzqDeETLhUeMuIPapja8RNrMq0LvvW1u6Q7bKABJeVr74cJjmdJxKe8nOV4NhSO\", \"dqb41x1E4n52q3eR2Hh7itWE9fxOr7uaTtHEauGEy7TivloPRcwz4W6eW6K4LMVE\", \"Jbksc4mOrG7QnNXu37PxY36LNnvoRucQBv8bZtx2KsEqnSyZEsB1SusRYuF9ilix\"]','1971-08-15','2016-10-20 00:00:00','[\"J89C1L3nNMtgnzWwsFxsXVXNsJRXdjYgx2FuxGAcmMZPVE9QtCWIWYWpogsNmIIJ\", \"lwI5my3KSA01P6nKaLUrO8ecoIiCIGatMqxqf8RzSx78BjfsIMGdULPeRyBUiDIW\", \"UYXQpYmNOwYpA9jJA0fNctp7kXrv9D6zZCmsOMTTh8beqi8BQyVMqdlES8xi9kIh\", \"opcu1kwvta6M0vSSeK5udcfYRxzikmBlnoQjVjKuw9kiK7oSinvB96450hz9OgkZ\", \"opfEE4DsabUCk6Dbo5d8tK00WAM9XuwXZ4q5YI8OfHjAz1mAABFPYX5QC9TyDyrE\"]','1978-11-09 00:00:00','[0.2865868953743651]'),('[\"ZrYlI4JWMtO6Lpa9FY8u7f1juHGtz6MlYqZfDIgfQDG1XYI48NVnmqfOq2cuBTwc\", \"1qMtPySwSbmpCA3TCjdGQF3OhsqGgZHpN6WtCnfeIdUZxBP2yyzXyG3n44tvOOnn\"]','2024-08-06','2007-08-09 00:00:00','[\"P3SZzNHLfRNfoXDZC1VUjgd0ZUAaVq8Fu1a4ZWh9MAwA5QHfRBg1avigFIguzSYb\", \"ItWoS4y2dvNXM7K74Co1RUfxNvcV05nyJZ2Ii7ZAhMsZhYvKGDlGPORFNZ2Morn2\"]','1984-05-17 00:00:00','[0.33445322853416226, 0.42247847640391006, 0.6980432085867009, 0.8656718784348065, 0.04832676111430641]'),('[\"dFlvqd7bdQREHugEx6N8aaXBStdJwmFatSvUYV2Afx9ejMWQXgLoh9wD1lHudVHq\", \"GKj1KKUIAbOND7J4BwS3NAB7vpwemjT0BPRcrfDYT4wu3pwqfJW5AvCWZa389HUt\", \"bpt0MklF3C5I4wkEl7XQ1xZMjU7viUTqcaJNveT44tveOFrSPNeCJTqoV0Pid1eP\"]','2024-11-08','2013-10-25 00:00:00','[\"xz6z9q2DHDSCjRmevHdBDhhpObsMnBkpIk0m0GBg2luuQ05aWuzD4SsZQst2GPwp\", \"nBbgk1cAjS4Wads8hd8M7bOfiS0YoXgbD1ZkISKtDXVDW34zclrB71Q3VcfVqtxk\", \"gDB6ug5fcXg6oEBKKvipRbkR9ioMQDUa6r31q2bKqMGOotnHz8UOgmiUI0nkybxy\"]','2012-05-31 00:00:00','[0.007774545162851695, 0.018373712783083588, 0.34495933769366577, 0.4936089832440795]'),('[\"5nx4PAHlqyhHXpvrBqm62qG1G4RRsJdve2l6N3nascCtkblRj6jkOpNsEqyyvDKs\", \"zH9HHmj0tsxX3piJjEgoqNhkfA3gLZ7pi863FvkTrUaQDph1mcYTruAUPdkLxBo6\"]','2013-08-18','2025-04-25 00:00:00','[\"L8GYR71vGEsKU6cmQouPdGN8gt38qxTa4ytxMSg4HuLmu8h5OB8YvLBUM4HehCZy\", \"zTFpLPZdDta9aPeNNaIPTA6hbRShQbwxT0LmZnLFc5Bz23OCqPYswKoq4cOuGtAf\"]','2015-07-13 00:00:00','[0.4500643614903652]'),('[\"8p9UqRaITcccEPH5j8axW93dQkdODlsdxqQcxQH6yrIdiVJdP39fPEPbd5cbh9Pz\"]','1977-06-05','1991-08-03 00:00:00','[\"38mUGUvdMHrJUMy8zEoEtH0CjJ8AGkLwaZLjym5NwgocyF1CWkgJNKcFOWlRAZmn\", \"lsbnhWsqwEo9IK3pGjy3vIsaeCWlXRyGoTA9VWzKs9a14wLoYoBlAkja2h7ENa7S\", \"M6cRcnSna4zRchaJAJwSo5A9Q3NeSemdSoPJVWXwsArA5DIktGBsFS0LAWwfE2WB\", \"rnzG7E5a7jLdylrCqX3mgoE9lWpxYXbQ32sP8zoq9LidnKEjVFq13UB66eHFDCoM\", \"nKiVohyrtMJw0UaHl6EWUf022m9D5UsaL4Tt3wyJnwS2S9tJI5cC7PBinbrNYUSI\"]','1994-07-30 00:00:00','[0.014740044389187237]'),('[\"SPoTAdmXpQUuC8DKgEZPdnX5wz1jlObeuLL32wr7ejzk2f1pMPMYPXpUTT8MoRDT\", \"D1gKJmFHAUmwXQLRa2APw0xUghmzK2qqVm1kUjHKlAcsUbkZn6qsozyD8N2ww9Ad\"]','1982-03-18','2002-09-19 00:00:00','[\"H2jbiCofuyOqlDns2Oy8mDmX4FNR5nzbMqeFGjNLOwC5KOYM4G2R5Aeeep8gv4LE\", \"CGT73BNm09mEUolTpnnBWwzfC29E8uKhuwjRq0gQo93UyuboEkMrXwcSrWRbSPVl\", \"9MJLefyZvr4GiwIx6mrmtiLPmSREKksbXI2jENM8QKsvswGRhUPoon0at1RdxkwG\"]','1975-11-06 00:00:00','[0.7716774375944869]'),('[\"mLijrizdfV3tuIAUq1GtXpX1GwpeFGy7UIUhdjBGOknyjDUpovboGQ0JzpvBz4Jc\", \"HkpLqRIibx4sy9akMXIjXhkg5lRynMqmnlbCSL87OlSG9GDnB1Of34wjvWOO3MdZ\", \"zyAI0M5pF53pG7QG0mfV8Q1DIMPIRZXa92RQxV0pGhDWnT6DLM6jg40YAkU7Awwf\", \"OoRFK2PCQMAkH76MYGyRdozARIMV33yiSRanB7Hti3ysrRYGNAwXj1rx2XSlbEbH\", \"IaBWfERuSJmWTh3FO36IszI02nFVdqcsAOL4VjMX0WypVff4RlFBQxLVsgBMcZqD\"]','2029-08-30','2020-05-20 00:00:00','[\"HP8wc6rxGE3KUEdu0szMdOQnyCJzQ6RPfVtUl3Sl5R3W8YOVMCvZMX0XcszeuZvK\", \"vqPblY3uRrJXwgmy0JuAeOEsMc6B0aofX4Ysv0Z8lY9IaLIPcpVu007MBu7bHYbB\"]','2023-04-17 00:00:00','[0.2100180343726104, 0.5288731985948688, 0.29053431791941275]'),('[\"uvqMmRpzy4QFvYmSDfrGeY9qUsLYxSu9ZW9pN8SZCzZzrpaYcgB5lZbzTPd5p9Zz\", \"Ir4meUN0y6rG8S2TM99QYL3cbk9xE3kOlUAwfPfoJEm0nsESpSYSqfEqKsa65PX7\"]','2013-09-29','1996-05-25 00:00:00','[\"Igdi0XIAlQ7OkGbEkXjllBg9qKwAwwWyWXIJjlIgyobLhN6eLL0yrMTBXsO5fgcF\", \"rYYaFjdBEvZ5bkenyy6V5pumaYy6aclhQDkHyrgEd9x2u0BhC5PRC00pj9aSDTIE\", \"S3APWVpiIq7TcYunGnTwFvVpDlbDGMRkDCoNEZwvATX0HWyFQ9MHsWZ8SthCpncg\"]','1985-04-21 00:00:00','[0.5205479611252712, 0.4833118971041047, 0.8880511436007136, 0.7291263090168532]'),('[\"uqiIZanZRB2Hp44P3TIen2MdoPgsP8K3eSc9GwwCEROdHIf8xWEYQAn0cmdCikPf\", \"8yAhWDqGQvMnfZqciF0AXcI9CxcTmTsOeUKF1Eo2n6G3EPnZ1zOlOSMNp2ORXign\", \"KCh3NS5TCSmUGRhAizVhutCdskSVJveMVf19OMIiHkjUCwnbPwz8mqLdaKJX7b1n\", \"q9xAUMs9SxWu59Z9kmcokoW99YHmOZNYwADW8qwTq7cY0mpbwA8Y2myHCEPG1NUt\"]','2015-06-07','2032-12-11 00:00:00','[\"cgsX8drEa662W6Wv394ct1VCQhpzXeJEpoqkf3S2pEPXPn32NOUMjrIvOB6qqWL9\", \"A8kxBeaw3CtIMYtnLIbH4wbxyhkAFi03h43L4T4ceGVeMb2r5oJkEtcnRXnBGrlT\", \"z19caFCRGnz7NK5nhMOMARLKx111O88FTKB7axW2XypY9YgOeHO11uiKf7YAmjDr\"]','1995-06-11 00:00:00','[0.5648117356635188, 0.5385770398212066, 0.4740902785263248, 0.7296322307810768]'),('[\"CuyMtWnPOm5m8R7FBh6iypyFO15gEJyxOQ5hYNAm8biWNNW9gCDQb6Ez6TimIRCF\", \"lm0UnWOOqnvHsNv2IMPjF7PeYCCXmI3oyHo93cY2hOcLyrRjFag6vGFSGS70DtEz\"]','1989-02-11','2023-07-22 00:00:00','[\"5DMqdanoOjtJDRLNwkQqUouRnJznILFEtsgcsBavYvnCu6Jqy1lcTKJGYtuKVD2Y\", \"zyzw1U4bJ21LhHo7xhfXYKbOmMqPW1rhCuiMhPsQQ2jVo4dSb5SxgBhY0vRLamdz\", \"WcuWLYUB5M1SDDkSlOx5aVIAizkX82KjbVVocnY6koQKqOxJVMpi7H6EDEczWNwN\"]','2015-05-08 00:00:00','[0.6426271847645817, 0.9162404778297084, 0.8061965421391227, 0.3191241916987836, 0.8786555615760616]'),('[\"XTmNuxoni9aUgRfHA7f2mqFsh5oaSAdEoghgHYke7K8maZ2fQjvee9tVbTulaKaE\", \"ndVt2iJNyuGdJT6owDtYXVXsqU2tPm8NjxtttitSbsWusL4DvWk2s0itUD5S15xk\", \"NksN5L7bUDgIJvH4K76nS8NabdIcIrd9JVOu20R1yzCX0c3B0xtMAl2fzkqsvVoE\"]','1975-03-04','2019-05-29 00:00:00','[\"yDgqCzMMivMI85kANtgeU3RZTdmYxiHQbgXOu7ifCQbtjOF6vh9pTacV6ujO4hDA\", \"f6wGdaA610izP3HNw45VkTVAZekLE9TgRGNZ9JrhxCVkoNlFxdtwe0OGr3OhgqDy\", \"tnUrjtEa5zGvbHmLQjBwOMHhC0CkSFY0SdIJAxFxVGlYrFFWoPyNH2f28vsHn99m\", \"jOoEENMrOfst4RJ0rv5fN8xsGoMu268kfa5wGD9nSN79F0AUOMTHnJBtiicUMeSq\"]','1992-05-08 00:00:00','[0.01350922371878786, 0.5072105171964445, 0.9585680740487551, 0.7358299994294016]'),('[\"jYQ3z4yNucM6cOnCL7RPFoSfv3aLLzx8JWf7OAud9uFRg6WREGTGvMXhw1P0aZoq\", \"jmwjQvPc7shQy5UPKZ4CM8AaD4plydZgDNfari5mDER8Cxwl5XgeHfRoqn66ikBT\", \"R5S8GPCeLxP3yvZQXoXWlrwfRRR4aBpHhpXpaOerBnLkguONZKNpYu3XhnV5yVJv\", \"rqN1HvZ7MBn7INFKfKxWIoBKBXcF34O4S9MNieTXu2as3XtRNzVxv5dy4U1C6D7N\"]','2013-02-02','2008-04-10 00:00:00','[\"3CSFgVXyxJiFnnGEEKtkS9wvsvW6EcpShA386RsbmohQwv2mg9C31l3EdTQgJK2p\", \"KVmFiU3WFQwuRwUAPadLeJmr3jyD3QQ13eZABRf040Z7MlgyKGPn22GeGCzfJ5hN\", \"gQNvCAmOpVqF4hAglYVnHdWT3twYnLfssVnswpW6vX6WS1027IFprY4763IUEb4M\", \"TXWgoPzoSBb0iyNYynFM0nZPV6kT6ytNVl6k1WPTxogcKSPuD7PEllJWqbw1MSVx\", \"GnjNN4xhOFggCK2uTZqGmACnP78B9oOTmP47PvbYEbT7Dz15EbfCaoaEZfLZsPur\"]','2034-07-20 00:00:00','[0.5898806239693096]'),('[\"eE4b4IIWmibUmvH45vzvx6jN1wbwPn6LZzSjP0uVwq4yggwoqD99KXHztNYCQ1I4\", \"gwkvNw9PNvKOQZok2iH7rRZNdHZ3I9HaRxsb77nfXBsS3FvxazSunD0cIS9omEw7\", \"bv8vFaG0jdzCKVPyWpnN3dZdrBUyk75vc9aJas2nhKg4gpPKOYYgwCWjwiOOyWUF\", \"n5jXPO4GhjVrzJd57Zn1siTgu5HsMXuG5kZiuR6rKvtrtQVFA4q8k1M4ljuim2WK\", \"q1lOtwYt4YHIVvA066rikIL1q5k5W6xS7TtUkMQwAQcLpNQUlnRZYL7HMPu92VeE\"]','2007-02-03','1980-08-12 00:00:00','[\"b2Crpf9zsy4MZRUZQhLAGiFtMCt0IilZalTwvc7XllyhKgdSK0Uvf0kmmJ6LA84O\", \"6OJqcICSkQV1dx0T0ImzCyPydlm5zcRsv4O5Xqlv8aiHgSK1WFj2ZcnayMU7Uq0H\", \"eeb2AUlxIMFXoSCkmoyEPHbVLwJJwW2o8AtOp2zORb1F0etZT3Bgi8Opdj3kqcJr\"]','1975-11-20 00:00:00','[0.7095289813412694]'),('[\"qVTi754IOSmfaCpqJiASWDopeQZcrRv9Wps08HYikCe1GvkORj46AFXafXUjI5Hf\"]','2031-05-26','1998-01-06 00:00:00','[\"2mEHXOK5BS0KdygGC85nnQfKBej3ElHBnhmgSA9lKoh2PsTp7yDUJD6XnKgKGQAa\", \"i2E2aw1zINVGDaeb4SRfTfDjcsfe8vP2p57OXgIM91Llqfhot33dNtZFghM6ocm7\"]','2014-02-11 00:00:00','[0.30204438320967697]'),('[\"6FrALKao6NCXhgZRn4a2mFjAPKEWNKKuNiyI3SGQa8yxJOgzIUt20Sk6osChKRpr\", \"4S3M2ioWWLBjDUFNHg30O2hH4X4IG8m6JlvoOCef07pMhrzNnITBV32nSxNHZ6mY\", \"VVdgBtldDI7WSFei8sdGA4vmNxWeIit2neeea2fmtWZ5hqk9WNzib9m3RrdwH3mg\"]','2006-09-28','1974-06-14 00:00:00','[\"MilzGZV7UUyiWJSnIuyqRbZ9hka1T07A7yThFgwxTzsAISbdDgPn8wliOS9ph0We\", \"xh9Y14LVy4yoTpcXDbkx47fZbh6kQkLVgKMT8RsgIIZMYojmOcnx37aZJ5FjAxp5\"]','2021-02-04 00:00:00','[0.1817475434478905, 0.04947526469145963, 0.11897320857692152]'),('[\"r6f1CTcubN6E3w8OTe062efIGFPFyCUlGMZA9LzUDvEZqiugRSQXQsn2IZOA5Xzp\", \"6wiwf7FWTtNbmY46D9aubLI21ZxEK2mcLHU41Ik1DPadH6jnFhizsM51qiW6Szaf\", \"2OdIDWyIEDXMRrKRQ45RYtjCaAj80pTxbPR3FhGSrTTxFOW7avxjFR91rgJtOIBY\"]','2034-12-25','1984-06-16 00:00:00','[\"Xiz7ZZSQCN9dDO8wfpAxqnzgYXebwmklxY7rcU3JH59g8P6fjNOM7BliEVWyfyhb\", \"n9sMsY54SzZuQBwsy3g015ot28Tb8en2vBuMwzPGQ1x21RGiVUU6kXnQwAK232sb\", \"XotC7vn6ilZuR7BldjiRsaTNGbLDSevuFST3EzIxiRznoeTOvXukihoosKQX2A6a\", \"ExVoA4du4ao5FLVsUiZfjvSwvc8yx4QlrmpNDbuGPMlvXr2dVM1RK2rJBuprhr5F\"]','1974-12-17 00:00:00','[0.7622978727040536, 0.550288819397284, 0.6478534317044453, 0.574880285886972, 0.8104694325088238]'),('[\"Nfg9MB9c93xk3t3pl9ZHnZcD5BTls8tmptUugPtlH7kyc6fh2uQr8OnXbflbKVrJ\", \"PczPlfQsY1RvdTagXd6PM9zO8mN6u4l0PhmVLhLKjhkKUo8HJEW5hY5qZHxfSj2e\", \"auGk7o0NAuOfQsCFTmL91VHdAf70YbhRHewAryq58bYXsrJTlO33EZhCIDWKPTn8\", \"5ypcpkL08yeWfNW2X5SOilzXZ1NOc1kxUVWzySCtcgx2EVuXNIQ1rf3dM8dY12ij\"]','2008-02-23','1983-01-15 00:00:00','[\"IkGRNZuuZ3XVnVIxkHOib0kHM7JFeqGAKZYexnNNOj4XC2KJEGweM9kT2rPuvicP\"]','1981-07-04 00:00:00','[0.9102220819633761, 0.4714516249325858, 0.4190343694839622]'),('[\"yfsdIPmrpLPHGqA9pNP8ac6EUR0HJFxS34Yp5NZvdAYBKRmHZyQFAN6bZUnSb9qr\", \"9Flmqn8x4M8X1X3VnoDLFV8ghPMGcyVWeYfgXkkO1y3FsuDe6jBqblRo96XWBA7r\", \"HgnaXXR4xInO5uyL6c4EW8U4F1kbfhciWwyOBVJKFeJ6CXdzZQZ5bF3IdfZNfgo2\", \"1jXZzQuPn11TEEKyFpmsStpkYMG1sn57yJrL5OnC53fxXRXjDJCdnmsZat3DlBRL\"]','1992-09-14','2000-05-22 00:00:00','[\"hXxe1sPw6pRBIZagetKI6BoS89b4wfKn2VtAXB0Bw2cZTzTd0TANg26wbwePGWB6\", \"Ik746SMiWnoOyzp2oP9iFTkrsRftijVjLYpLHOVQfreS2lxbJFgX2p6V7rtFzGn3\", \"oxnXl58oVtBsDm0hLdFXajGA7ZUYsOGsULW5l2v4O0ScBuHMjH3BAFgMGiNDJ3Ho\"]','1986-05-10 00:00:00','[0.9579275304888738]'),('[\"WSWmwBhfYxMI8Rx8DSBdbA2bNtx1DGqFQOl2VdHrUGGIN3SnTTkmgzSUh86XEf8H\", \"fSyTyNFhNdLtDFVDDO4rVTQjtQIUiK5g6sM52Hlivyl3ioJ3BbzNguE4Eqbs1oFK\"]','2031-06-04','1995-08-27 00:00:00','[\"QUo7iRYo7W6WgaGAvomNdR9wFjlKWQYnvSJ2B9XlpLJn2BHngwSKCqGQ8Tz36S2w\"]','2011-11-06 00:00:00','[0.27425788776763105, 0.8558269035458208, 0.5002935869406752, 0.9848318085928289]'),('[\"4Jk373n5CII88haXS42bG3jLeyAVtBRqDrVABl94hXgzIEvtpEnT77fAqwpmjZRO\", \"Cq8o3R8KGHEIMTEz0Hdv3kglQ6F1J5vwwx8Mp0Zf1HEnBelFrAaHY4eIajF0iiSQ\", \"KTIC001ymGERG2m54QvapbewzNl3rc8N9vtKYhNwfTgCRPtbfe2b6N113Qi83rZd\"]','1983-10-29','2031-09-18 00:00:00','[\"r7pDTX3AThTGW0oC0l3mrrOYzTcM2idITy1yxjGPeLfjAVcdr6WSGMtQYo0Euy6c\", \"ZWF4SFZ2nfHG5ZZbLhGkNNOO0vnxtDcDRMZK0cQ8vrtje9nwR0FWhoSgQF6HfAy4\", \"Ywctz9IGkTjoEphmWkcFELUd4nwfnGVZ6u6scPSJA7943IW6A2Ym8vuOubg6XLsX\", \"QCf3uUPYT5cxaPNYKZOSVqLd3EGCTygiXtrTklfe0aUr5lKC2V9hUPbeFzJPyPW7\"]','1977-09-19 00:00:00','[0.6683491899661822, 0.2984031402684146, 0.28247967809615726, 0.028400568045308293, 0.630651915875849]'),('[\"NU3Mf3vmj0PGQEnBIFuqZip20NgPWK7RX9LN4v3Ocu3KO5KvjLPbvoplawgO1cAU\", \"GZQZObn4h3H6lUrh5E3uD9HIdl28CZTpHXMye1g5rzl8ignvuanNp257a3hfmKb7\", \"MlM1xPyNck5PzgVDIHIXHhfOqW8pAKcUkytUkk6NlDM3wlixnU3gH6ZzqdsYRKhY\"]','1991-04-16','2020-04-05 00:00:00','[\"XggXsuRXzidUfpJqUQC9GDx2mDWcrn2VMygrpFdy0Lf4mlpNKUnPLIuHz3qfx912\"]','2020-11-03 00:00:00','[0.26511703221350175, 0.04429804919254248, 0.08027287360090749, 0.9063692551468664, 0.37159171748060377]'),('[\"14JAyt1S3rl5aPifNk75tL9My0nuqOb6mn45MAkfTggVFceEjr7pwiWQNGKVhB05\", \"YwbrqH0nm2FjN3tXBlhgCDhqiGVHORKXeMGlij569txCC9D7k5Xhc5wDNLNXdTUd\", \"Cnwtmg26OnJQbn0wUY1UuKgvKcqi6h634LOaX7Nc4dBlzBfWZQLIHHwrG1QPwg5a\", \"sgvLSgcEAQahs9ENMI1ssVW4ccvNAlwRs6lQu0M6qbS3WtWYzfYTeOmwpKXFQzhN\", \"ebQzSTflkL4xXmr9pGteQr5w03zbry7LKmsgdFThFJIulHykDwvSNB3sATM7vrxF\"]','1992-01-18','1979-03-30 00:00:00','[\"W8pSjXlBXKESmAvCDe8nl7ugcFGZJ6XPB6O65lKD9vmt7WMCbSqpTSwktLipGslx\", \"hLR1CCrlK0ImFuDvgxY5UnElbkDkGfcF3eyPwjQhfLapuQjYE11GJvxdlgWOs4TU\"]','2011-11-23 00:00:00','[0.5736748735516263, 0.9721622442070186, 0.5201736855560637]'),('[\"bYpuouwFJrTWhq5Cn8Qke1NQ7Dti1Lrcledhbsos6j3Nj22CSHT1d87Tv3XtKOlJ\", \"KgmseOr4kzvUN0eUodaITvqwaULbvMA6tzTVRCNMhKNyIsajY5ECkzfmq4nIsBVQ\", \"JKl7yTHB1DX67bhbwOxah4QnBMYiHDZMdtT5QiTIboFpdmTvGspidZCdweyFNW3a\"]','1992-09-08','2018-06-02 00:00:00','[\"hG3rK2QeFBtwLuJ3ZteKFGq0BDNYmMcIKiXvV9kVNrNTqdEJHFMQNtL9G6IN12L8\", \"YdyaPkOMTRTF0tF1RIu4lkrUKKY86j4gC7pJodH5aodOHKLDvvAwwzWnMoNZTkwl\", \"aN0hO9WQbXPd22lGEN4qf4U558XAg4SnP3Z74awKfZz41ZUsot0cCyIHjBEv8ePB\", \"7whFDYB1o5FHdk9EWF6y0psI0hOEG5blBzsBRK0dnxrXwcFtABB2S6FSGdlQtFUY\"]','1972-07-12 00:00:00','[0.3503955800144707, 0.7946302522533017, 0.733857653670291]'),('[\"OqiJaOEW7ePejHT5LfFksIbOWFASBppwajLOrudlXed9pDvOOreqXuHh0JNkCO81\", \"rst9lKHCNWv3SD8JZ48R1GrFeqIPutKwaBoau8IsvuwHrWjwHnonyvfJXXSzsxTa\"]','2011-09-19','1992-01-22 00:00:00','[\"0LRURRNtwvrNRNunUdk73nszhvphIs2avQGcjhZXE0cNJkQDSxRrhtGch3mLgUMZ\", \"QgIcTnO8Nrcpg4tQvlWta1GNoRZAdRDRlrTStwhd1L5GlChWCDVRAlOO0gkHzu5b\", \"dCre8Tnr8oE3FdJk5xk8ihAhgHS6uIw9DG9WWLePbnZVRNMnRVaDZyipfvlDopII\", \"dhvPh1A34k1sLSaazw4Muf1SjjOKG4uLeI9eYgem6pSm8LZ8cIlMX8kOAxp7FTBj\"]','2016-04-17 00:00:00','[0.6717135134579746, 0.9704113290689538, 0.06066643892762763, 0.03669350790819926]'),('[\"vV9XRAbZohgSthNUWGcyYIinogKNtlH5g4pK1i8uVJ7a6KQZvh5Uxb801qCrNa45\", \"8K26RnNcHxt87Pj19ZeLZrAH4md6JLBY4GzzVjU5aTsfYQt4dSclv7O9X411WTGx\", \"wCnUEnmvhklXfnZh8GDKO5Jwz5yAMuYOnTBTMZJJfRRxjhbeSwtwqgZ2NVrc1GkY\"]','2002-04-28','2009-03-06 00:00:00','[\"MJPxFkACq3eYUGok6FgbfOPEIbUx3i8C8zIy3Srf5snj1i8Zl1u8LjWpw35Hv4tr\", \"aswyDTLhw7y0D0tYlx0JDkKvyhwwHkJkuh4NuzoKzPANKJEtPEzi2LuX12ukdYem\", \"DP7qyYDq4gGHVJWU0IjGbprueZHqPz4RfSJ7ko8F4augyyzsf68WNpUIXOhz0GZ7\", \"0s6tCopZXQIgNQqSZ52LdUEDwbxQhWSvbXncmXSfzMKcjkCROjoBXb0fVyLAqDVn\"]','2006-07-06 00:00:00','[0.8158090770480149, 0.9545080603120522, 0.7687410776212851, 0.6287726826718296, 0.0863719136006138]'),('[\"CT4e9RclIuqk5JxoMfc4qAKy685BKfcl2eWFSEQJwunrfTsQbL7u8mGt2Jc04yz5\", \"aiwzHnLbJuAAEhciOc31To2n4j9cEXYS6f88K4J6cKim7KgDDIYsTHrj1viYufhi\", \"AGZIh74KNFVODzMY68m06RYqUbkoqHkVC47pxIBoAmZjQGmBSG1WPEho9vWkll3i\", \"w17PEZ7I36PCv30HeujJv2jDFPqhUMew64feOOz0ANISehx013L38gzN2TDKHarT\"]','1976-07-19','1989-04-11 00:00:00','[\"2fCS64TgSTkpc4GzhwRmwraRGxgyocIlgFLh4ySL8N2WP57T2D4w4EpIl7eoTRQB\", \"Uh05REOtbU5j7PClHQfg5yTm9H5sHHijTvyrM6Q2PTAFals05KQsFUGVnmM8oTGR\"]','1998-07-23 00:00:00','[0.8692478970963795, 0.9862730054642267, 0.5459771173802278]'),('[\"6trQrYQqZgk2HgsUS5ZbSGlHG6k5jnrAIlySHXmILHD8nvlJkffcO4YsX8Re6E1P\", \"DX6iXKwnEdakiE7tO1tzLgffsfhWev5KJYMBme3B0JaEAjXCmp7Dvf4Yjw7GJusN\"]','2002-04-21','1984-09-05 00:00:00','[\"VVbsc8rRsSAD9GwTUyzvJSGF5N3zQYiXbUBbI6SgzUbkT3GR1U74XEy8ez0b1nXM\", \"3ORwrkcJuNLNcl0twEFF9bdasDhf0guvUzJ8rOTg9WUALNyS2onYkN0ZjKQLRXLc\", \"jyBCTGJrzzRipMLz65XuEqH8YcxlrxmCDnsWJwbzhLewwFCYCQy0uFFvDdsGpFeb\", \"gaK2lAOHqGbGjbOvqIZVdQaKqaCMPe7CLKqjxHsZLZ5IzAr4yE3dsgP2axwHSeSc\", \"GFd0F9kkHyQtZkVsrHfkz9oDYOsvVEzjiMeKbxPjgJMP8q1Uua0B0gTPK5fqHxqc\"]','2028-02-18 00:00:00','[0.5471565929987244, 0.34350304848042856]');

WITH `cte_1465` (`col_7280`, `col_7281`, `col_7282`, `col_7283`) AS (SELECT /*+ USE_INDEX_MERGE(`tld1ce2472` )*/ LENGTH(`tld1ce2472`.`col_57`) AS `r0`,EXPORT_SET(2, `tld1ce2472`.`col_54`, `tld1ce2472`.`col_57`, '-', 8) AS `r1`,TRIM(`tld1ce2472`.`col_53`) AS `r2`,`tld1ce2472`.`col_53` AS `r3` FROM `tld1ce2472` WHERE NOT (JSON_CONTAINS(`tld1ce2472`.`col_52`, '"zhVuWVabjeEZQpf2c9KO8jpAy4W2U7gXSYUnpoAs502NuQyyJAn7VMRXmZjsEuMN"')) GROUP BY `tld1ce2472`.`col_53`,`tld1ce2472`.`col_57`,`tld1ce2472`.`col_54` HAVING `tld1ce2472`.`col_53` BETWEEN '1991-05-27' AND '2034-05-05' OR `tld1ce2472`.`col_54`<='2033-08-05' ORDER BY `r0`,`r1`,`r2`,`r3`), `cte_1466` (`col_7284`, `col_7285`) AS (SELECT /*+ INL_JOIN(`t9172e9ec`)*/ RIGHT(`ta0c4280a`.`col_64`, 4) AS `r0`,`ta0c4280a`.`col_64` AS `r1` FROM (`ta0c4280a`) JOIN `t9172e9ec` WHERE `ta0c4280a`.`col_64` IN ('09:41:40.00')) (SELECT 1 FROM (`cte_1466`) JOIN `cte_1465` WHERE NOT (ISNULL(`cte_1466`.`col_7285`)) AND `cte_1466`.`col_7284` BETWEEN '3-@3mtQ-2-b_z7$dNM' AND '4f' LIMIT 80246884);

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

MySQL:

mysql> WITH `cte_1465` (`col_7280`, `col_7281`, `col_7282`, `col_7283`) AS (SELECT /*+ USE_INDEX_MERGE(`tld1ce2472` )*/ LENGTH(`tld1ce2472`.`col_57`) AS `r0`,EXPORT_SET(2, `tld1ce2472`.`col_54`, `tld1ce2472`.`col_57`, '-', 8) AS `r1`,TRIM(`tld1ce2472`.`col_53`) AS `r2`,`tld1ce2472`.`col_53` AS `r3` FROM `tld1ce2472` WHERE NOT (JSON_CONTAINS(`tld1ce2472`.`col_52`, '"zhVuWVabjeEZQpf2c9KO8jpAy4W2U7gXSYUnpoAs502NuQyyJAn7VMRXmZjsEuMN"')) GROUP BY `tld1ce2472`.`col_53`,`tld1ce2472`.`col_57`,`tld1ce2472`.`col_54` HAVING `tld1ce2472`.`col_53` BETWEEN '1991-05-27' AND '2034-05-05' OR `tld1ce2472`.`col_54`<='2033-08-05' ORDER BY `r0`,`r1`,`r2`,`r3`), `cte_1466` (`col_7284`, `col_7285`) AS (SELECT /*+ INL_JOIN(`t9172e9ec`)*/ RIGHT(`ta0c4280a`.`col_64`, 4) AS `r0`,`ta0c4280a`.`col_64` AS `r1` FROM (`ta0c4280a`) JOIN `t9172e9ec` WHERE `ta0c4280a`.`col_64` IN ('09:41:40.00')) (SELECT 1 FROM (`cte_1466`) JOIN `cte_1465` WHERE NOT (ISNULL(`cte_1466`.`col_7285`)) AND `cte_1466`.`col_7284` BETWEEN '3-@3mtQ-2-b_z7$dNM' AND '4f' LIMIT 80246884);
Empty set, 2 warnings (0.00 sec)

3. What did you see instead (Required)

1300 rows in set, 5 warnings (0.01 sec)

4. What is your TiDB version? (Required)

b69f81b
@wjhuang2016 wjhuang2016 added type/bug The issue is confirmed as a bug. fuzz/randomtest labels Jun 6, 2024
@hawkingrei hawkingrei self-assigned this Jun 23, 2024
@hawkingrei
Copy link
Member

hawkingrei commented Jun 26, 2024 •
edited
Loading

We generated a minimal reproducible sql.

WITH `cte_1465` (`col_7282`) AS
  (SELECT
                                               `tld1ce2472`.`col_53`
   FROM `tld1ce2472`),
     `cte_1466` (`col_7284`) AS
  (SELECT RIGHT(`ta0c4280a`.`col_64`, 4) 
   FROM (`ta0c4280a`)
   JOIN `t9172e9ec`
   WHERE `ta0c4280a`.`col_64` IN ('09:41:40.00'))
  (SELECT 1
   FROM (`cte_1466`)
   JOIN `cte_1465`
   WHERE `cte_1466`.`col_7284` BETWEEN '1f' AND '4f'
   );

then we check the planner. We cannot find any filters in the planner. it may be the root cause.

+-------------------------------+---------+-----------+--------------------------------------------------+------------------------+
| id                            | estRows | task      | access object                                    | operator info          |
+-------------------------------+---------+-----------+--------------------------------------------------+------------------------+
| Projection_22                 | 1325.00 | root      |                                                  | 1->Column#31           |
| └─HashJoin_24                 | 1325.00 | root      |                                                  | CARTESIAN inner join   |
|   ├─Projection_25(Build)      | 25.00   | root      |                                                  | 1->Column#35           |
|   │ └─HashJoin_27             | 25.00   | root      |                                                  | CARTESIAN inner join   |
|   │   ├─Point_Get_28(Build)   | 1.00    | root      | table:ta0c4280a, clustered index:PRIMARY(col_64) |                        |
|   │   └─TableReader_30(Probe) | 25.00   | root      | partition:all                                    | data:TableFullScan_29  |
|   │     └─TableFullScan_29    | 25.00   | cop[tikv] | table:t9172e9ec                                  | keep order:false       |
|   └─Projection_31(Probe)      | 53.00   | root      |                                                  | 1->Column#36           |
|     └─IndexReader_35          | 53.00   | root      |                                                  | index:IndexFullScan_34 |
|       └─IndexFullScan_34      | 53.00   | cop[tikv] | table:tld1ce2472, index:PRIMARY(col_54, col_56)  | keep order:false       |
+-------------------------------+---------+-----------+--------------------------------------------------+------------------------+

@jebter jebter added sig/planner SIG: Planner and removed sig/sql-infra SIG: SQL Infra labels Jun 26, 2024
@hawkingrei
Copy link
Member

hawkingrei commented Jun 26, 2024 •
edited
Loading

We transfer this planner into the join. it still triggers the bug.

SELECT 1
FROM (
    SELECT RIGHT(ta0c4280a.col_64, 4) AS col_7284
    FROM ta0c4280a
    JOIN t9172e9ec
    WHERE ta0c4280a.col_64 IN ('09:41:40.00')
) AS cte_1466
JOIN (
    SELECT tld1ce2472.col_53 AS col_7282
    FROM tld1ce2472
) AS cte_1465
WHERE cte_1466.col_7284 BETWEEN '1f' AND '4f';

+-------------------------------+---------+-----------+--------------------------------------------------+--------------------------------+
| id                            | estRows | task      | access object                                    | operator info                  |
+-------------------------------+---------+-----------+--------------------------------------------------+--------------------------------+
| Projection_13                 | 257.05  | root      |                                                  | 1->Column#15                   |
| └─HashJoin_15                 | 257.05  | root      |                                                  | CARTESIAN inner join           |
|   ├─Projection_16(Build)      | 4.85    | root      |                                                  | 1->Column#19                   |
|   │ └─HashJoin_18             | 4.85    | root      |                                                  | CARTESIAN inner join           |
|   │   ├─Point_Get_19(Build)   | 1.00    | root      | table:ta0c4280a, clustered index:PRIMARY(col_64) |                                |
|   │   └─TableReader_21(Probe) | 25.00   | root      | partition:all                                    | data:TableFullScan_20          |
|   │     └─TableFullScan_20    | 25.00   | cop[tikv] | table:t9172e9ec                                  | keep order:false, stats:pseudo |
|   └─Projection_22(Probe)      | 53.00   | root      |                                                  | 1->Column#20                   |
|     └─IndexReader_26          | 53.00   | root      |                                                  | index:IndexFullScan_25         |
|       └─IndexFullScan_25      | 53.00   | cop[tikv] | table:tld1ce2472, index:PRIMARY(col_54, col_56)  | keep order:false, stats:pseudo |
+-------------------------------+---------+-----------+--------------------------------------------------+--------------------------------+

This was referenced Jun 26, 2024
Open
Open
@hawkingrei hawkingrei mentioned this issue Aug 30, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hawkingrei hawkingrei

Labels
affects-6.5 affects-7.1 affects-7.5 affects-8.1 affects-8.2 fuzz/randomtest impact/wrong-result severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
5 participants
@fixdb @hawkingrei @jebter @wjhuang2016 @ti-chi-bot