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 query result when comparing data #58419

Open
wjhuang2016 opened this issue Dec 19, 2024 · 2 comments · May be fixed by #58570
Open

incorrect query result when comparing data #58419

wjhuang2016 opened this issue Dec 19, 2024 · 2 comments · May be fixed by #58570
Assignees
@hawkingrei
Labels
fuzz/randomtest impact/wrong-result 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 `t174f86ac` (
  `col_82` decimal(21,13) NOT NULL,
  `col_83` json NOT NULL,
  `col_84` time NOT NULL,
  `col_85` date NOT NULL DEFAULT '1996-11-01',
  `col_86` tinyint(1) NOT NULL DEFAULT '1',
  `col_87` decimal(19,3) NOT NULL DEFAULT '7149.18',
  `col_88` json NOT NULL,
  `col_89` json NOT NULL,
  KEY `idx_41` (`col_82`,(cast(`col_83` as signed array)))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `t174f86ac` VALUES(81.0000000000000,'[6269293839981757880, 4576501920986522525, 5887703832686958393]','13:48:08','1984-05-16',0,91244.000,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[2497148957455060589, 5259987956991643211, 9223372036854775807, 6765502403733553781]'),(0.7337000000000,'[780726932816060396, 5180962721980660560, 7609406532755770935, 1479986894584757215]','13:48:08','2030-02-01',0,8350.000,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[54007039893944993, 6867697594377857054]'),(0.5520000000000,'[7354182179960677256, 1894390602162752107, 3229315316669162671]','12:51:45','1974-09-21',0,511848.560,'[\"wkvgkSgGd8EB0WsdVpRaY3UyYcSB5QKb7VKP1JW951sat0Ou1LyTf2njx4tAkWa0\", \"o9F60JAl3UZrDaPN0MRyBwLvBevT0qva2gbxhYF4SQ3tGaTLOfe0FADUV3ZE4yur\", \"q0Vxr6DwYPQnWnl7500bylY8d4Lth59ur819cEHLElKoZowBwTh5jEUnzxlTaYqv\", \"vHVKkLPpxMotztDt5eCkgcyS1P1VZCEeLy2046zQsM798ogTREzdqvhwa7TlRqnW\", \"X88tEC2HsgWdxrdQcFGYDMmlMrNDIe98kUgtbgUxSFg7YjQ8qiwSFXwrC9V5pIjz\"]','[4950829245000599407, 8269186374975089159]'),(42.4265000000000,'[1722124103614794579, 5998399858638774394, 2506699720084431886]','18:13:57','2030-02-01',0,93.840,'[\"vKGm3HbjFuK6SwbeKb8hILMYRDJPS83YTHT4TUoIzcRlCmxKa9T2NOwTvhctubu2\"]','[6666348691763335869, 4641196101904441508, 3081364813359910721]'),(472220.2060000000000,'[5629513894450889943]','13:48:08','1970-11-20',1,48822.000,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[8040388176739592618]'),(172082.0000000000000,'[3850401841281041952, 4002603730522900101, 7733685458700950347, 4946516295143348401, 6292872864116185428]','04:37:08','1995-01-20',0,777729.000,'[\"HXfHKKq7Ah3fuE1T7dl3QjrBQfi1TYhpxS9o9sGLAv6YWTtrDUEOrHgVWOX5H04m\"]','[6969871868056796877, 557390586409721981, 7019164828210479262]'),(603.0200000000000,'[2246238456000107568, 2409497394143878052]','13:48:08','2030-02-01',0,37452.960,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[6390990477404234048, 2630427550309689391, 7156996229235817539, 4436934485117358722, 5772026613097175701]'),(67434.3000000000000,'[121855950508224416]','13:48:08','2030-02-01',0,74919.690,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[4762349886052339408]'),(6.0000000000000,'[4542831569534915038, 6897599925098423721]','19:35:53','1977-02-22',0,4.000,'[\"vWxGsEWiJ0Cl0JFVo528sajgwJGLpefFGpRfjWbgtKWtOS4j5MxUtxeHZwA4fMhz\"]','[2239119044327520770, 5694040749615349484, 7859979145699348816]'),(11.0000000000000,'[4731815709908528514]','16:54:35','1988-10-02',0,0.700,'[\"wWdjiw9QBG5M13tUYyXkxrzYJJFtPPr14uWpwnXOk2ZX1fJTWUHgMYEnHgCnfq4J\", \"1ABv0ED1FI8GaX6ZjPFHQfLz7NyITxbVuwE8nzS9fOP1jXuBIuiOfMZylTcLRYFV\", \"OZ1RytjFjKg4iGSlbhgKWJV7ClagXeVFJdIG9F176DTQC2bHmm22xogv9Mx6SArz\", \"L26jscOaycxywfpnGTQW7j4Ib50ZcQyhMtL9eHVAxgPlkTIbA2Z1TAT92u3QKO9x\", \"y2C26fiEcn08lH9Z26GUa6qpmmVCHoPeVqOrSzRqTUJ8pHpHZhqpGj0RQCJQVzn9\"]','[3440723675308311967, 8035112566340106533, 5102012793656528882, 1, 5077961478930340845]'),(7.3000000000000,'[2669944202192528221, 5523743323781727879, 7326740650677976308, 1]','13:48:08','2030-02-01',1,25035.730,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[7650392546690803919, 8080466472187543816, 2819377926894247152, 296226886282188326]'),(95825.0600000000000,'[3477937985538647172, 8630760890825867085, 7858602172930909235, 1237400543889890491, 0]','04:25:14','1988-08-28',0,7.900,'[\"SDdzkNhPXrpvkdpEfBari4JQ2rRg7DsA3xIqEz6koCfj3IIkcnyWjvq3GQ6oEs3b\"]','[8361611565690779551, 4074449338821421136]'),(4678.4300000000000,'[4617081845736338426, 7642472512581544247, 8160569364302927268, 5844956539283782953]','06:11:18','1992-07-23',0,7.000,'[\"qRSD9aj1mt6QkWNpfvdKZABZwUKfctf6VUuImKaUQLNdrnciByS3kxccOmSbcVsO\", \"QPzUNstTjzobT8m8J5ryKahDvGdDziEkQPY7Ug8ZkFKYuhE0CR5O2ZSFlD4QOrPc\", \"MVN3c5EWaIkl0odqwQqRK0ANgz6dAJB9OA1EHgZ75r1WJVrp62vAJIzTvu8AO7bz\"]','[2700274718899229199, 0]'),(9.9000000000000,'[2124498096000740873, 3180224057149883413, 6852938712485809595, 9223372036854775807]','06:48:43','1992-04-28',0,0.807,'[\"4Ae0cqA1nY6j9aFfHkMDKrGhb8HjfvfCrDopaoXsCqGD0QQ7aXcbcqCeOFHbsewY\"]','[4142057307731782856, 379321191668025281]'),(85103.0000000000000,'[3182719708032069817]','16:47:53','1988-12-18',0,96.000,'[\"jbjRCdsPlByWqHilegp5DHU8iiQVaaxZvoOZBsGQdKxtaun1JqnnktWQin2TLhxA\", \"kabLEQYlqTKnBHai5kJJwaMm9dWkU5kEKHNhIe5eGoNk4nBPFXV7h3Zcbv4Zx6pT\", \"OKU9GjAjW4aqeNk5hZxwyrI9id7S7HBJ13kIdfw8hFLxIHd7mdflQClt10iYEMJ6\", \"6ezPDVqa9z43K06xAppQOkGTeWary7OAgt6OelezJkQK1BQvzlKRCaoKgCXKVVs2\", \"GMvAihubHffONubTcYpbuXp2L4phbELX3H7rFWuje5AsGt0OURJorokZ0OQIOqb7\"]','[8428280223804004425, 5830538493483555830, 650530646643318075, 564398004017841013, 4632496879834828241]'),(0.7580000000000,'[527749384037000826, 6837871027060987866]','19:50:50','1986-06-20',1,3.050,'[\"YRsWl0xZ7U1bTmDAFlZtJVbt04QyqOH5h4w3D37fbOLiqowhKWPnEXLqtCS9ijmB\", \"xaaH2ctLjgsratjk1S7G1eGuYrDWx9F5RkCz7X5DOb6TSWDZV9Gbvi54rMK0X5Du\", \"tDgNQBshhcUX9mcx1AaGJun54coIRYadVxE8SWPOQplcvYvRgJ9QgrSUAimuRXo5\", \"RNL6dht1ICNXdYlAm2x9OG46e4AoZcVJp0c1tY45Xhm3GSiD7WzFoI9fNbNrW89u\", \"UWqTn0SGqKHmk7hV7tjOczNLUtdrTRO2MhHleV09to1F8Mg2jgFGlb8wgSxuH0O1\"]','[715645308452011696, 4189430603946353008, 3028397323028800314]'),(557520.0000000000000,'[5241434528037356548]','13:48:08','2030-02-01',0,6434.000,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[428919197508137673, 2848815123642335849]'),(6046.4190000000000,'[4961515368673053324]','18:13:57','2030-02-01',1,508.000,'[\"QWKVOwGQscJn0JATXvluZlX0F8nJ6kxiz2kaWQoi36rbRfoE0Oo8piVbanC5UfX8\", \"0kakO36fVgvUOCfz4D6MzDqDGPgr7QjCoMmNJ7bNLkBxkbKXC75l5I0B7oBEBMWi\", \"jSTaJ8qDK3t5EAgGlYCvCwSq8uMZrlJFIYTFitm4LFRfM6hdLgmUW8owLQ0UVIcN\", \"8h10zOmGmGcAoLt8BqiVZH3pwuTrMFqutkbZgjau1cpz0VMpva87qPdKrRZyxsxN\"]','[3933340848262555208, 3335282215053778965, 5340126873688028008]'),(2.6000000000000,'[4165083431892135886, 1685386617284762101, 8214865633846470061, 6137367720127371580, 1097031977157560085]','18:13:57','2030-02-01',0,4.000,'[\"u2dNYMGKGm3drpU9fjIjmazXiiMLM05fGdYfzjoLxftBKTejdcbRu95tXsTiPCkx\", \"P7VOokZm4RxUEK06vKXsK9C9LcNbYVxvpsml4E8CpuSN9irrBnUCn8k2zvlrFp4D\", \"Y2i1PFXzYd5i7rI651POFD9FXI7HaOqZzSigwFayt9WexUlf4fkI99BLECVJD84b\"]','[9086022259398112918]'),(270.0000000000000,'[2, 1889754962738674001, 1]','08:33:46','2002-06-05',0,0.000,'[\"BUJF1Pt1Skjx3AR1DvOHuyBwrYNb67tWxlYgX61qJBYPvDnUzw78jq5zDFZ5ThLs\", \"DrQgGT0eJMpnnBschRO2XzAM7BioX56IEA5V9ax3cYpbzHvJXLqK4HNEPwnUIU6b\"]','[4142057307731782856, 379321191668025281]'),(58660.8000000000000,'[-9223372036854775807]','03:28:22','1988-12-27',1,0.816,'[\"ca1g9gOpTlkcZAaOAEnhLn2XNfkT90Q6vhJjemptwOFo4RFQKpccVga3DzGlSLec\", \"iTpF7itwOS2dXqsgeCX8GjAgVuVa8G2WtmICudqIHoxd77XYtUX8UXyB7ZvG9kjB\", \"se1WuKWHGkkChkyImAr9tmVoaNBUUdzlZH82w7cR28IwMNuTGrdgI2EYPwO1VrCw\", \"fTLVtezmxsWLVVdUMTSTSnhHTPd8N2aluo9P334JNRLIjcxTPQWoE1w3eEZZNwxd\"]','[4142057307731782856, 379321191668025281]'),(21028.7000000000000,'[120816092329351089, 4443408675054376358, 1172585379521218467, 2421958875157963702, 2]','19:08:02','1999-12-08',1,1132.800,'[\"tJ0ZwT5T3ONLYTFTMe6M5ciZocz9Md3QuG9bcMiyfNVoaWX5eJqdBzE0gr1eO9Eb\", \"FwsrPpywNzNdIH2VHNVOBJgJb9zke9Grw4xguqbHkAs2gxWCmVbfIdcTj5ZzJKYI\"]','[1226761372172385163, 8529662356151577760]'),(935018.3430000000000,'[7301400589704942938]','04:58:50','2036-12-03',1,0.510,'[\"MDCtORK111O3U3poOaogoGIOUBDGbFeEGQrxgyA3G8IHU79QehDY5ZB8lyg2ptc4\", \"mBCJd3aAiqI0m3HLBrJzLYFcfKav3XQ0IdOt5sFKhrv1EB3cx6SPfuOVcxVqJKss\"]','[4142057307731782856, 379321191668025281]'),(5073.0000000000000,'[236450625688035467, 4236720067806969056, 7169620834800735173, 5840325897843947018, 2574110532842211196]','13:48:08','2030-02-01',0,7728.537,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[5144297730724154631]'),(1.0000000000000,'[6591538209939016699]','18:13:57','2030-02-01',0,1827.000,'[\"m1XQVUIrhXapxo7e8wRAqkT9pWNEbCSiM5N5HQAN1FubeD0W9WnFA4VDxvLUA09L\", \"uKVCMKlKLF1H1hKmCurpXlPmgC7WgXGbNzESvPqi0MZKVm5KRXCxdO3utYbxjAQb\", \"EZG1UOTl4nIMBrX5dNtcnMBjqw0Rtf9NoiUeY0PkvQJAMPZll9uyAYxIBzyocoXc\", \"K932kWfxLnLUpN6SsextNX1H3M8PGifS9sIky30Dq6ure8ngKHKADUMsntW5uHFl\", \"JiO5vZOqg6wLiKA4Jh2Zgd36GUpLN7Rg85EW7AQgTAXfp8RkLrpRpTAXKcZyocRf\"]','[382868922214427961, 6559383653175083712, 3566109308361973156]'),(35.0000000000000,'[2480812548952096433, 2989614031325736596, 5276952586805729853]','07:50:49','1996-03-01',0,21.997,'[\"dvNf7oZMED6AvXsXzHyogpxr7KKGT0A5yWQO6zdENaMw9oEN8tJNwBey8PzLkVF7\"]','[921261640848114673, 6951961152332596588, 517104861032337758, 8512805164496238329]'),(50641.9000000000000,'[579294312204262157, 3310077676783168850]','22:22:33','2003-02-13',0,782486.883,'[\"Q2WF9ZuEbTiW2OG0oom0P0U0m3wN2cBDFtonyALsIWOBwdfJrf6KWnfjLR51v1iY\", \"66uzWjfLJanBgAwDbKRbxbWHTFTxW51R450Id4QCqhakVRkexRA3l5TOcvtbNMGO\"]','[-9223372036854775807, 5304148349994143497, 1048974959015219762, 2997146245581285543, 3947504978733393830]'),(42191.0000000000000,'[4117943275919170308]','18:13:57','2030-02-01',1,598939.400,'[\"IqHQq2znLqTk5EOG20OiCWM8NbVfIdJ3yplSjEiW2jSSeB1K2mwFp9DGiQYsRJzb\"]','[5764740971430989804, 4052961142757227364, 2723654724916068598]'),(0.5200000000000,'[4310366935007955758, 6154824281760014507, 8973280263879770711, 7467610479517413380, -9223372036854775808]','18:13:57','2030-02-01',0,63.630,'[\"PCjL64kumspcmyc9KpBMsss3UWxpTLFsMlJCivbbBxDl2qeiNskOz3CHuaMuNtMA\"]','[1100543493808634612, 5821625663213815595, 8863351552654867700, 8464691990116894624, 261253263932119038]'),(8.9405000000000,'[3346810621951850368, 955166415483049217, 5024849939288419839, 8585117656299357243, 8211508820931434982]','13:48:08','2030-02-01',1,162223.484,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[3203667721500397883, 5210095443649793177, 150512443600741763]'),(234.6416000000000,'[1, 8878768020463372305, 580272941324813432]','18:06:11','2000-06-02',0,0.170,'[\"ehkQBQ88J8LovkjrYkXVVFEFvyMvnBewfWxWf9mSFiXNBPDn0ZpLt5a8Ttgwa5tL\", \"zmCIflrF8zGQYQdRwNL0uFc6aUBKMnwm8Pvy75LCYoRivFMzeSN3Ach3fqVUgcTK\", \"m7RnGBj0yNZLpmhfWUcj8uMmDJO7rFIYPWMuZ9qe4ap4StoRRn2yv72YeLr0JPqT\", \"FHm4m7QQJMOQ02ANM89jsUMMfp7IVfIBj6c4W7QF6umq4XiOxqy58xVFPxGNQN9O\", \"AV64LQsv82iIj9Ue4JiUK3NF6UBf8WLm79GWNO6V855ijWErhB9xRMeqwfgiAS7e\"]','[8607336452117333958, 5257737209936974532, 5368875940029323060, 2906873295606985051, 41440537131664478]'),(78716.8400000000000,'[7740835304323950589, 6648138005957366591, 1762143566107029212]','18:13:57','2030-02-01',1,242.000,'[\"a7I9jJuvlDpF0vHitS9i4xKJEjFu4O0bJIucZVlpJ9vWN0OGxV6jOPznVwJ726vX\"]','[7361293699966764543, 5657956784259090886, 9223372036854775807]'),(0.5000000000000,'[9223372036854775807, 1, 8278752784803993161]','13:48:08','1998-11-04',1,27515.040,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[3638369318809510107]'),(5.2600000000000,'[5039287941037386168, 7683529123452045550, 5795675836481925652, 7312652976066211371]','23:06:07','2005-02-14',1,74.168,'[\"GyigDEp3ibGnysrUoZi0k61xbqydGRNtBVTexFTlB3e78ZEvlbaWpBjh4w1Oq0QZ\", \"Vjnkc41awt5RyqDrvx3sn24hjwtiULVwLysTZvPKo014A6onwKUeC0IccNJgdoNe\", \"ACl9d1v0ymje1ll2KtbJEuQLkEmmRWHhEeHtKc4SNYLvJud1KvzHJSQSe8IXLvQf\", \"qKW7NMSqytarBc0bmaJ0DduZEgSlWxnFYuOTQGxJPL3ZBvcbvpe2KrjpMEUpY7L5\", \"wklzMA2T1AHkCUx4rD2xwhHFNgGLMvZ5LmTgER3JH6WhTkfVk27TXIePh5XKIdBY\"]','[1880858975011169188, 4990628633955535246, 6852228988775070458, 7954541877257867686]'),(58452.0000000000000,'[4488777899573549220, 8407270744591268101, 9223372036854775807]','13:48:08','2030-02-01',0,264838.100,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[0, 2077119247964945608, 6750749857491441541, 8839766266218012541]'),(0.0000000000000,'[1778259443926671612, 6714161366580769679]','23:18:37','1983-11-10',1,18.000,'[\"uvWUDIUPPAiNIcuBoA3CwA5x72y4OoUicYcmP63H4NKkttfEb0ZPqaJ7WzpeZvLR\", \"g8qVDLGdmBJyL0QAEeIKP1kAZcgUdYqhWsNjxirTmeoenFZftSL5xqbXxrEgnTaF\"]','[4213347007217391320, 6582984760189526346]'),(6.0000000000000,'[9042560921335886855, 7067758282372029333, 5267714063337503674, 5000568431980278677, 5990562249034829612]','18:13:57','2030-02-01',0,0.000,'[\"BVP3z65XBcoUSN9vTsD1W857EiQVxdkHaZjSyrSr2qs5HRyyy26O9LoMfawlAK0t\", \"5scPwXscHdLqRCAL6Csob4U1eq5aznzDtDjXFhUK0xOjxdQhjrdvJgJhJ0nSnp7j\", \"lsZp4at6UqoobQYp1mW2wtb8OxAPE8yO83W4tYfmb9VG3GfdVDTybiWwsMoHIwHq\", \"ya2qWUkmPVYEdZCkqUIvEdvqw4FHNNlTz8OyDS1ivNs1Z1d2Qo0W0Hh9PoDmF0Gx\"]','[4449291239117272527]'),(40860.4000000000000,'[3575172582081571611, 2243598310942867541, 9223372036854775807]','18:13:57','2030-02-01',0,540012.493,'[\"VifNGh7KkwvqofVxZsmr2Mfvm7kGoUtk9KJvny6pSOJiXoIwM9Rqy8LDWJ4v5bdb\"]','[255800650682239711, 267226953414459690, 1038163789395534972, 8424367439008700802, 4824795491479351956]'),(4448.0000000000000,'[360225639528577823]','18:13:57','2030-02-01',1,928.550,'[\"chmCNeHfdpKmqyijL7JKh6zwZCKdNkgYKAdCxihjUuEWIJr8GPkPzulEL6eqEdmg\", \"Xs4CozrltsVgwshzV3QqvnI3RxN9fxwj9EKAJtwSZwG0c99HRIFskdhEuPPETBNX\"]','[3246868143265953590, 8940646288317088061, 2804569842214059578, 8946131464887136210, 4424419930738730320]'),(63227.5270000000000,'[-9223372036854775808, 297226137690215194, 8027371596188224658]','13:48:08','1973-01-12',1,80897.400,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[6103791423456642128]'),(0.2390000000000,'[2232371289300257222, 4715281431524499148, 8941494094154894801, 1020735214054925165, -9223372036854775808]','09:23:46','1977-05-27',0,1.030,'[\"PA6HGcFdQ4ckRrLR2EJgKbhNTdZwzKosNodq0zKhYY9BFcqZb5dLPDI0SJ8Ui8yI\", \"idXiOQE7z24twntx5PqwFp3XJJOOkXINVyeV40CrwZ8OG13LTfTh3pWEeH4XPKCS\", \"kNYWw13ljleSjnOrKMzRS6SFEdl1eVn0kVwA9OnpvT7k59sGb4s9ojR4cLfbSxjP\"]','[4142057307731782856, 379321191668025281]'),(860263.1610000000000,'[3499800461837968902]','13:48:08','1977-10-01',1,28640.200,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[3807849160390476195]'),(0.1900000000000,'[6098307311888517395, 6308071492744632171]','13:48:08','1987-09-07',0,8628.020,'[\"j9rvu2xYPWrQ0RVjxCEZ2j2EkzNYD7jBsBYAVIxjouuQTiMIE1VcQgdsZXbsEj4N\"]','[1402922977867125508]'),(3.6536000000000,'[3866961036747422760, 3392860281471692000]','20:04:43','2017-09-02',0,7.000,'[\"rFCApLhKeYU4rHF1u7KOxhuRC5YRT2uSt2UuIKcVC5CocTJd5mBLXwWj4nKJ0JG3\", \"ylZAcuLVkDz293OkPSwTboWOEWjftB0Q2VpRlVaYYcWg1vi8oAGJ9iNRW1exorrc\", \"KbmOFg8bm27Bfjn30YcRH8PnLQjFHIf5MnxYByaXFpETP2JZRCwy6fOBQrFI6dFP\"]','[-9223372036854775808, 8123388722318413123, 4996313586549338778, 4312267325901735181]'),(44120.0000000000000,'[7807808559253996094, 4467632743235940465, 471919824449501751]','03:00:12','1970-02-17',0,42.000,'[\"pB72pFywg39LOXU8zpOXvytxaTWw12qU2OZc61xOrqbVPNjBTNsTzk5td691ZaDM\", \"T0DL1osifYO2AuV0zhMXgi9pvl9XjhcCyszQVFmAZLO2VF5iAURsdZV6D0B1GGxr\", \"sXI3wNxyixEFK0y5cMJabZlugi4XdsjfqTp5vXrSms8nDwXB85ydqcndpFh7YJ1A\", \"RyXpzYSRX68q8WRw7iHlg5YXw8cvb7lTlzoKgN7TIfhzx8KjiXMAAMIevisMwV0o\", \"h0rLZTH1wjW0WUEnSdUoKA7kN6xdZqo9QXRz4Zaet7nlwwHeJtLTa8kvXp87nFIS\"]','[8353974797901246814, 4239842354258140612, 1801634315189845508, 6696440632350708297]'),(0.2500000000000,'[8267286183717093359]','13:47:00','2023-07-02',0,366.200,'[\"2dnOlys2dSOivbx3hQ5MSvXgcWaHbQNxXC0Wg4XE5RuI6Z6FGLHHy5M5fo0DU8hE\"]','[5718417494298249167, 598961780231813336, 6940952713700836624, 40460921441319421, 8989021454099986153]'),(0.7400000000000,'[3641916316490656522, 1884066278728730648, 8632211837224447468]','11:15:45','1976-02-04',1,61366.270,'[\"PUlOIpuZdfgd1nK0OjjHDrUFRn9vTGLcU4g8mo86M5o07Mq0kjp9WtSBiLNtLoyq\", \"2gKlx5dzrkMZ8YMo7se5jsyxpz68YzlI1vYBI32kCXw5w3dvIFGIC48S5lXdnOfW\", \"McvTFg3WfvpS36qBv8jvBwslqrbNX5nEa37kBQUsqbvW9sDv3veEcxJbo0UIQiWp\", \"CSiH2905VYLGjVM4dzwTkMrRgBZIhKSJ7RTZLEkd2xpWKVi0MrZcMWvLf6lk89vF\"]','[1640294471674489123, 9002316707271111646, 5649112000403986031, 2957846296618872331, 0]'),(8196.6000000000000,'[6539171248764589067, 9112740300614944973]','10:40:39','1995-08-21',1,8.450,'[\"XRKpxKkEHH6T82cqyyoAPy5ykv4YTOBPtyWGXlsS4HbYfniNqeIPiHikHKr8C6Yz\"]','[6503012333259571610, 7308197298900829486, 7625970081872485951, 4706097017692543286, 8501843463572035466]'),(79279.2800000000000,'[4740273507356559261, 2468928178374561654, 1099294451568203569, 1250927812985361434]','02:08:08','2019-09-24',0,26.200,'[\"Vl6iGbU3SkmcV0kM2spYr99xCuPBo98utvDPmnE5Ervun1buhBESiccmkB1VbuhX\"]','[6053717700000793066]'),(65294.5778000000000,'[6170015373207725199, 9026456044878796802, 620340511738177027]','07:08:44','1975-03-14',0,971870.400,'[\"MCpFheCm8fdC2rQ4kcjHtQWKobawkEejbliZUu2z9fK82x8K55YNcBTEzl3FAM0b\", \"o7JZK7DwThmsGIdVp5MYT95VGbvik13teAJFKT6P6UGP7MB9sLu01bNmtVhiyURH\", \"XPOlPGdUbDndNREVhUIEFC5XCdpRywkQkxHwr6bYZXzGPJ7Asvbb0Ww5OnAAkZS7\", \"JC8iCnfgz4HB5FBWOSgrXTzA6tTeSo1qhMGc3IL1O24qPbYNyMyDMWxiAjTeXEFd\", \"eqZFHAyDEgebgRQwpTABO3YbMPLOxUKhImUnIbrHc9zmUXC9T6nqI5NIJN0wrT77\"]','[5175956991322285335, 7049584907927865359, 7346953232794422870]'),(0.9400000000000,'[1914118026222964442, 2644731456833026716, 1895058763469291176, 6283132013004131796]','06:23:45','2016-01-23',1,633952.700,'[\"gmy6jyC7QlTEkxEEjHCJlFU4j1GHDH82nPZ3rpuoyGeo0Jo9occzqqmgme0KwsTD\", \"RvNq4Mmv9mqYrMozBnamSs43VLgBJkeF169dKRQ4U97CqgSY24JC3dzumBanKFvL\", \"YdTWi8fs1ATsPJ81vI8khTbifDaPI61cj5uMDf6SKHXtkDd2byJMTdzBraNUeJVh\", \"unk6dmbZc46O5DCST6XKj9AC7Uy7sMSdInFUpCVYMh1WQcD4alroNIWqBO5PzR1z\"]','[662080469004353543]'),(2.0000000000000,'[4246687006500016817]','13:45:45','2033-07-12',0,5691.907,'[\"hSwssec123If6DT6f5ZbbnknrsbWPkYTWDwIusDKxnGOJlvTEfDNLWtVX7ryaOs6\", \"sh7599QVukknKN1q4vScc2Txu1dSBXN3wfPesvDVW0S7bbBjbiUTa1mx07EhxyC7\"]','[5865627853056391800, 3135763713657909393, 6334505476404359868, 2766591491138152514]'),(9284.7000000000000,'[1393047406134193973]','09:51:55','2005-04-01',0,54888.300,'[\"4rCRuBavFu39w2hZPV7nRN7gFJvOxMCX0jbsW3buwGklMjpZm6bYIDLc4aQ4gLGb\", \"bVvXPfEMElWIrTXZMQFypYAqreq2krcXPsZHkl2RhH6hjOMVafV2pTePaW0zRYtJ\", \"lzh1WBHOgPk2Ao9oYiZzDRNq3cTecnT4PoniJkHMMOGyNKGWTPJYIODLmeHEjsjP\"]','[3924527039464844542, 1132806941804597684, 6405310388628156502, 6299300935978044727, 1238606442674355802]'),(884.2700000000000,'[7571294999424982629, -9223372036854775807, 73084568046414059, 622655526273403826, 1027760607563810340]','00:13:16','2023-07-20',0,0.938,'[\"1nDXnyqDKf8h0BEA7RMlzxLzm0DytQWg1VXacOMA9aceEGpcxu3j3Qv3034C2csk\"]','[1609385356265034109]'),(6.5315000000000,'[3851621770382781123, 1667301908465857465, 7471534233167752955, 4915908703542273767, -9223372036854775807]','19:24:54','1999-05-10',0,15.910,'[\"UbfMMoD2kCU2mhGaTmrcq6EjRPCCpbEfzseAlhAXOZjNDsbWSCwnnQgnWvyrwZ7N\", \"MqgpZX0trLvduZ1EUJ4bjywjt7bYIz6QVFYud9YKev0ctw3WehkPRIcQrwvMgZAE\", \"P5JEw2OECspCNjFuTvhRBs1QxyymhfiJ7f941unHebvBKKLH0QQbA7rRAx0adRUP\", \"RBD7Kb04MPZqN9rGxubBEYVjqZ7K0RvnDkeSPH4s9vFTboyLpNu4wYijpNvQig76\"]','[5760235074006664260, 7154265310426243126]'),(457.5900000000000,'[3197234229576630953]','11:17:23','2029-01-10',0,4636.947,'[\"iHGRfL3yfKHxtHMQFTLY3sdSLt9ACmjOivDzhJSaZGtBt19Fd9oc7qrXiNM77AQb\", \"qdoJj32ewMMmeXU9ebmDqgbs8Zi3Pe4Hd6Yaq4XbplTcMjIkH5T9KB3zdbkSv04u\", \"v3EUayGyX9crCleqwkncz7D0Jfl4ETqTaN5cP1cagtPEVappqWErVjecJkVLBQYY\", \"R5Ipi9C4e3Fwj3V4M9opr8uG8xWkapGczLOrGVjx4JJmy9hUj4b328l74iZmD3ex\", \"InBJnFGJUEKQi3wh0VhATx8Gebn8eapnYcnykbIWtkfLW3xvN15rfT3mdxDpDHcN\"]','[4778801482601035946]'),(862.2238000000000,'[9223372036854775807, 534936442176084226, 3019246193779300645, 6719590781738566442, 1744937545523516790]','21:19:18','1990-01-21',0,0.060,'[\"uqyPsSB0hmRmflSQAhBWjXdmMCCss1WPSiMhMAuonsmmjJUO71buItNRa0TTVa2v\", \"sTwcE88ZfYdV1zc8KNjN2mNiE0x4TBqCLIcuEJX7jNTGcmuhFiopiWNToOJhn4Mr\", \"cf7yJFhZy4Aak4Yq7bKMvIwj5NYPouuIFMOLks2BGezINKwaCUznWIOrLHbb6tXY\"]','[2]'),(981427.7800000000000,'[8516864287410214885, 5652590678409652111, 4377008793084847723, 4156237223907471493]','02:48:00','2027-10-09',0,3941.510,'[\"l0Jqm1qQTTrx2S6ZJa783lgDtSuuJrUhhXVier079pU3opeGG13TSOVcYT7QtIOk\", \"oOunYwGyjTmOQqokqIYRtuWAEDYa4K4SGrUHZNlzja8QISG9kqvdY96w3WFTW5e7\", \"fDs0f8noXYf6gbmgPYewmCJnY2BX5RnqkuhTZvNTWfwB1l4ZNVWU8zDHUedpoTRJ\", \"BFzujkAZgsuU5sXjcFhKlHvnMd0vlU6LWLRZ50mzlXbpYwAzvMrh5FMQupjRjdbJ\"]','[1638703986726190788, 4671924023622992449, 1662962368619575866, 8741317942104028449, 8078436931887758347]'),(66464.8654000000000,'[5385546551534189586, 2, 0, 1263006565332003721, 7735329228100208109]','20:51:18','2016-05-05',1,942.100,'[\"3UQgBXWzs90lvrtLpNzXBJQ2iAUdiN3VMarFetYwJQ0VMozl9PKDuN5iyZkz8tm6\"]','[7404712428397359429, 2602290740402102607]'),(199.7400000000000,'[6683327729218528327, 7864833804864317290, 1186701712599025851]','23:32:40','1990-11-18',0,9.500,'[\"nSsFZYRpoo6PPnuQZKP90E3XWh8lkNwmILpBurdpryrb3I6FfGbOQ0Z2taGFZBLt\", \"ymPK0vVs8YuwpwxN0Gw2bUQAGqAO9CtrfOgT6bjELw4r7olHZo6BfnwjrIBNWd6z\", \"zZquLy0xygrhjYSUeeVHCsViGqYCZVoZ5KtyJUcL7SipKjvgjq5SOek52CMvXowj\", \"QVXfvhsAf5PDvCmdM2ZHeY0z2oNm1L8fssLjrmPlJZBE6J0JnPEa17bf53J2FKPm\", \"86VbieY2h9F8I3WWMZLN8SRCx8d1Ic0086WpoTqgxSAdmi38udacIpSvB8ZYTD6Q\"]','[955791515527283158, 8994246756108659899, 5655639441258694402, 7492034407863601795, 8051057349006726525]'),(759.7400000000000,'[7771783682160417668, 5974240743067501871, 9144689491047998214, 8997200110317691818]','20:57:05','2020-10-05',1,0.840,'[\"BsHF5rcvNHRsvDUXMrurgNPlnhy8HfmoAFMkPsKZ8mBycSa4ilW23HXaWILKGKxe\", \"tWTMkJVaETPpErmVZhlQnnD2tVQmY0emLUyNuGg5lyekPfvy3OMJq0gFw6MOShh8\", \"znPCv9e9j5cn2SUbaCRng5Qt2vKLOI2reWFhYd6qgAKjItXUmBrjEx35AciUtyQl\", \"WS2S1Qui91hyZ2XrBClo1NS2xuKaauY06FvhgCyKI3bYnagGLg9XsipymW7j4KFw\"]','[6292866842516092799, 412201771388426499, 1599900670507689269, 6191212234166823290, 4711032054057822084]'),(25.9400000000000,'[5487875721113327142]','20:33:49','2015-08-24',0,14509.000,'[\"ODVF8iL9wlK8AZmCiaMLdOvi05C46KMrUMV445wqlgYZ2PYWm4eUp3Uk6YRYlM16\", \"qEDYZL9e3ohalD66nX43Nf9uU0ZcAsMdIqBNJV2Y4RNbPJdcMErvtdq9GYU7hyUv\"]','[3248337508780059442, 4331259410245625989]'),(0.8649000000000,'[1086236206005946924, 3357826431314859785, -1, 2146080854449235770, 5566485294790617261]','06:07:43','1976-02-26',0,0.500,'[\"1CiavgcFhnfitppsBjDQQVUSXVwfoTfPwYoGgFNR0ONboVqp86L8DO9htXODPfIy\", \"uYbjVW4p3wmsL6ECHsXIKgS6Q2zyyN4lZ4FJIQY8zO2kei5XwD8ntlaKlftLqAFB\"]','[4142057307731782856, 379321191668025281]'),(2152.5877000000000,'[-9223372036854775808, -9223372036854775808]','13:02:15','1985-07-05',0,54959.000,'[\"8sg6fMVBoCSBwia1EraFhcdr43pUXyV7k8doCuWqplGGY0cc36goWjzGqNArHtGa\", \"0vN7KoRmLQGpDyWnAoat5ymuA6zXXNSjjCo0stI1IOqsQg9GeeKhrU8bj5hKcwQx\", \"udySiMHTftSbiDXZpgqgQyNWvSsdjSDW9LEgjAU0bpnnr8Fp8Rf8xVQUwPFn8l3C\", \"ayIUJiqr0mMqI0BE26IYZi0AjAmaKrGp00ZzF4BbgIMwrByYO7AdDiPtYZMLR1gy\", \"iteAvgM3b8ei4A0QCcLkZoZgZeOXVo28aFe820ofnWTT949jEOkbiH03kz71cB4G\"]','[9080437293696086166, 8668808798881787171]'),(8274.6000000000000,'[2, 3356017273588040010, 848375132751784417, 6579154908151148093]','11:53:56','1976-07-26',1,90391.000,'[\"HrVMaBX6klcD3dvQ5yQ75XjfOwRvnEV4fiWfimmFKU40RWfbYwQZgEVEVmGxah4j\", \"6AZ6aN3L6Myou1Nd92WSjmUrju2Jv15870JzixzWdSljNkEqA51CFrq1ndE4k4mO\", \"wbViVhEtgqlBEZMLHHzTEZEYHUaXJ2FGlHxL0wqOZ0dQCAoPiLO8Fht59PLYij0j\", \"nk04yoN3iGRMracLpSGAZio5ri3NQabho0LmW7D2NvpY0nV7JEUDITaugwh2jWaV\", \"N2y6emGY176WM8PMWnvEn6eoZX02Z5VfLeNR7PEbmHCD4rGSsMMYerUgQb5OPXGp\"]','[4600589768651916476, 3035512562412750506, 3275736119810871116, 2316045151947571429]'),(14.0000000000000,'[4022042649394493953, 8246112435927769683]','19:15:05','2019-01-02',1,48.000,'[\"2fBSwqqXwrzcYXYboiTjThHT00UnRMHAgrVKaA4Ql2ibt0f9sqfVq7uELKrCEm9H\", \"RbHOqrrEW4PjXnPrX5UpuOp8BbQSGTI0oToKZVQOfnUMvO1fJHpHpozFpGtSj982\"]','[7898280158024002618, -1, 5335221098268688347]'),(9.4000000000000,'[7447613146959276748, 6019928838241380842, 1869030255912663214]','06:11:47','2014-10-04',0,8.540,'[\"uXz08WEIqbztwYa0fvgerloImGeNiLYKXuck9muHUX9jhbDawB8l1fAGum117cYJ\", \"X5bAjSDWS1UFjiVvjr7fkF3JMFSHzqJATuUVoSBCfjpe09rPCpAQka637Xjt8b3q\", \"mYMbI4ZMpSTaV8ttsQja23i1PP5sGozYEjKKC6Kb39YxPq0nZ8Ffmghky7P2c7Pe\", \"v3ezGMWiUjGqJnMjrGs3I042L3T9s1pDMa9Ua7JvYuKMV87b2s3DZ6vpWUZ96fQG\", \"TMeX1dkEGaCZfVArGByVCEcunaeSrtWs7k3JnY9DE0Swkwfp9GdfQsjusg1gqUca\"]','[8044606835817725360, 6323248018929793039, 8422061466126661939, 954033673906615855, 8873134544169613964]'),(6.6000000000000,'[7105983264075683515, 3199071655186547551]','19:08:41','1998-04-05',0,5675.600,'[\"s8mL3Y1UovuXlzI4IsKIDq5FXwfbByFQC9AcJUBBldI1ynhAqnP4vdZMQS9LpE9Y\", \"fktxyWSNBVJJKX2TMEtH8FM0ai3camCMUFWjex4B3Ga0JXLfBF3YGVUbucQjtg1a\", \"VNy4bq8802CADJUMFpchX9Oz5YOrh0ZyqYoy8gI5q05xCg0LEf6iXBFtXYTAqVXG\", \"fbrX06g5KuUEiBDlB23WN0K6yquUddL0VN4wPLVlfUiELplSyyxfuSnqBIAZEvwC\", \"kyB884sY7EFN50MWx5maL1JoQdsjyjMarpsQvrirqdePlQNyelpBb80HmzkpmSv8\"]','[5773842891704220304, 8693978840743769079, 895538724313273255, 6055896583545156155, 9005506576498110126]'),(1444.5310000000000,'[8922918499273533122]','07:42:33','1982-11-11',0,442337.000,'[\"8uq1EObCdtiN0lCAzSUCO8RLFDgszNYzdauMk0vlfqu8OygxsJBPgR77984AQKOU\"]','[8657760556256736802, 4629919199232882203, 9004973069091187221, 4059554035674931967]'),(0.9000000000000,'[1235616779719380520, 3872056663317251764, 6829938743017222710, 2064919597494634813]','22:15:37','2009-01-22',0,84.020,'[\"5k55BgtWqjLioevV9Zsbf0VaXR9EJdhZsMXNaAsJFyI2AUrkYA7eu08S4hz3Axzq\", \"i4T3hAmOeogewXsdmAqIJNgfC1a0twFepWQ60j7gyuhavT9qTY4idLIUAL1rAI8Y\", \"CTLYqR6b5nFAN0Pa7ddgPw4QSjY7q6n2LGRdSBJEIFjf9wcYuVn8cLxXQrcDbSvX\", \"TwuRJnpMcPhXqm3A3ZywouxFa3Pdik3448oZsjw7hAxdkrVAE1w3CMeMrPKmvLMm\", \"jpbS2i9lgJAeoHqDTorVfZOwATFXtZeGPsdQjfseAvO2vRuoE9SxMVfKtLVTLf1u\"]','[6798802038626214603, -9223372036854775807, 5434755361058439281]'),(827830.4830000000000,'[3887001583676083439, 2532418643952079850, 4537678535979033963, 667610046902556034, 9223372036854775807]','23:19:23','2014-02-14',1,234233.000,'[\"fRi6CI38pJvPJZrThN37azXc5NlEkVVbEKrPo4AOyE0KEdzh6RXEhjDoisGqzCv4\", \"tq1lcZ86wgyRZa6cWtUwWsjKLrXIzLZWdoINTQrpABmEtekjNFMH0XT0uzzT7tRz\", \"a8OefGr77o90H5F7XecUzhQ2OhUngkiPx0L7l8pI9lNV1FUzqHwETqlmsgn5H8LO\", \"VzKBg1nXxZJ1aJkTUp3SlFAPiuZNMoaLeY5MuecOh5ekt4RdQAPyZZ91QihE4xxt\"]','[4096005815654596049, 7000857203340455635, 5217830562612360451, 2685463246940983123]'),(5661.8170000000000,'[7188439733202862577, 6172448650976169600]','15:06:57','2000-03-26',0,47216.120,'[\"aZKCcMRhY8VfqbeHZEvFRyVcWBhRrjpzi3lmiY3Fo0BF6eRVYb4zmHYXg1DDPZtI\", \"vFES4LmwjG2nTF6UxbPKVT3gvet6IJg9PQWPpRni0Kk4cMCe2uGxP7KFt0oSAaYF\", \"ajJ6TWR6FpCEMJ4grnIWYALKPaDKRMEkTS3HD1V1R3bBOrcE1iU9XGZj4e0SxLx4\"]','[7770927389752219821, 0, 2454870271565000899, 1196489839192779957]'),(856.5222000000000,'[2712525309599838537, -9223372036854775807, 1406144343411091499, -1]','08:16:52','2010-10-05',0,2.606,'[\"n1loyyZdBOhGEARPH3BBvOscnVbcn4tekLs3EpOE4vmkhw8OLxAUZP7A09QsHZgV\"]','[4142057307731782856, 379321191668025281]'),(18.2000000000000,'[1809321054545392124, 3907149877258731809, 2866077663877640506, 7511403932474376115]','00:43:22','2001-01-06',0,762.950,'[\"E01gilzFFrgdo2oZ2QWnQmVjKhiDBo3V0RnCNAEbhUKjHnJToDu9AOWANAiJuwkz\", \"5syIrh9GcRQF4W33DHzE86HnXQZZ96R4uwodtV5J80zCWsVAN25FTOamdNFq7Gfv\", \"kTmiLhKrOVPauxC9hvPGPfKpgD29efVsKUXy1ejUKScaYr9fcQrSm888xKydkYfw\"]','[4704200483288933360, 9129568250597536320, 5730662758696711111, 5147882646981701773, 8228071061593501833]'),(0.4000000000000,'[1520923208622419412, -9223372036854775807]','14:42:02','2015-12-19',1,6443.740,'[\"fm34Efy5GXpUQu2YQhJALAVhTFjV3BTZ215BhMzhRXH4IAmOhsk1gcwUTfRgg2hu\"]','[5607641771212504552, 528148818898217527]'),(989.1990000000000,'[-9223372036854775808, 5842411907964782228, 1, 2374011330437773338]','02:43:43','2036-12-24',1,9701.000,'[\"9sQp5bvpdSd0JrvOAcLtujBOXM09lEaiFZTeL0mNETqPalKMOcIU315kU8ODh0wl\", \"Vrpe5BfmWGimasxfO5n9zAe9vE8a4MIkvU8AWRJPVlfWYwziwQvl5U5dZtapivTa\"]','[7258301629340453856, 3773440282628392611]'),(16.3925000000000,'[5934041558024643651]','06:34:00','1973-01-20',0,469.630,'[\"Rtk5fcBq4EC38zeOYBdybg3i0DPTbi0BpJ8ZSWQijqwJfRlV3jaPPRCWPyat2M83\"]','[7242126134609325764, 2597804002456636176, 6131537327816037781, 7020558883690279948]'),(0.5000000000000,'[3253386853773097819]','01:48:52','2012-04-17',1,26463.100,'[\"2S5ZbaySgfbvA3mVbvRFfajHvED4ByjSuZ7QwT7TTyo6JrRQpCtqYJOKg0ACjD7v\", \"yY24jcNpccnsxNgvJFWPHx7GaNCXz8hxNoBol5OFUWn1xPL0bVTVK7h8zHhOzMh8\"]','[1, 770299750458050355, 7506813174824160036, 2, 3740878892764096849]'),(7.0000000000000,'[3493461331391724048]','06:27:26','2034-03-30',0,0.000,'[\"USeIpMvU2xvf7qDNZpmW8Z93xlEzx6SiCpooGzsqGDYItIrtTcI8mSeInVUZ8Fak\"]','[4142057307731782856, 379321191668025281]'),(1124.0578000000000,'[405486178496431282, 6020177715551883112, 5014292272532541618, 2831325301516118978, 1228888384681843929]','22:48:05','1988-07-19',0,5.700,'[\"VCxlyBAPCd7qTsXGI3c4blqYa1nm6HsF9TDirKVKbTgtPkJkf6IuEkrxy9kxuWbg\", \"aP2pVNHeNCaIRHkuMdn9dlyJUElfzPqsQp7Yfuuno5or9C8n4YgHnAJQASwNsxqP\", \"ucvUGYQNaCKwENPDuzN9OM2Nh6DKVeRVTt0ISJzUkJhHPYVbGbFcdLIWstSQZRqz\"]','[8029006389469836077, 2, 6740219070602584839, 6545827352500279924, 6591725767935404325]'),(757872.4000000000000,'[8625025136744744790, 382547921024722473]','11:34:17','2030-06-28',1,849.428,'[\"AoyUoXS14I0cgu6l0G426csoEPp78PS5DeoPzpE1zCNKMEreDJZ1wrjxA7M3DCLm\", \"zxiNDWagmmK8wXDdMluHzkuaLbjpHggw9ff3HhzAgJBupW5RtHYVQn94XcvOeo0t\", \"6glnNzNd1jHVHWb4NQIBmLLKV0Re3zT2VkOvyhoATr1iJhsJlI01T1KrHo00BlXK\", \"c4LsoxJ6H7Ggq5wxM5MwACK78Oo9PiKfYe5NhRCtGh0PLFWiXwM7D8UhuUwFmGXp\"]','[1532461252579073897, 2605261645651309768]'),(27.5059000000000,'[2318905729740370241, 2706476212173431451, 2202637400950290142, 4390099431806566942, -9223372036854775807]','16:27:16','1987-12-14',0,52953.100,'[\"tjN0ovGkIhJSovFdXdMSFSjKBYcvSImsoDZoERhELu8SwIJLFM4Bv5yM2BsOySOO\", \"M1tidyn6dfNvIRlxv20XmHiRj8WqR7XGaeWToYAoKe4eSOsbDuRs538fBZH6yBPr\", \"vfGGdNWE2O0qCgtM6tg5JcPmINGVLjS3ZK9a97tLfJsfGeO49ht5h4WvGkTAlHae\", \"uSHe6PprZhuhdPTdzz5j8PSF3xTXkP3NvFDVC66U7ExMsuPEy9iZfanmVKnalRm4\"]','[4666632230458598437, 7702284972647618479, 3764686153906176627]'),(4.2277000000000,'[7338077211064268274, 7523540867038583015, 5690145192502306003]','06:58:05','1985-08-21',1,112.108,'[\"ktezRMHgISIuHTbJR1LrlXR10ve9ANAaHlUrCLHKnhcK5nE30umzJp24jT9HlrDe\", \"ZWSV2Apqr4fYfcxNxki7mtyCksHVNayQ9hrSvU09DFe7oyVaK1yrKCCA94JLPXtK\", \"KQs90xAXbaztJB2zyUF7XLmJ47KVhUrPOC6oMbbR2I1cd4oZtvKKHhWBLcPLjlKF\", \"n49zK0fUa179aPSCUUohjU1A0RGXjTCNx3JzfyHqNbrn0lKaXXERwoff1WQHvzlh\", \"h5IYyqFTTywWx5ryrdXDNiLxMXnxZBNOz8KpBFmmvXDI4RyktgSeGFyMzZ9hoKsV\"]','[4377903304423306416]'),(2483.0000000000000,'[7411103950876593898, 680014287118664611, 7397059858763140349, 2500447527743693289, 1495623243609706500]','06:35:48','1977-07-05',1,3573.000,'[\"kwe9gCAPEMPfCWt4pSLCxWkqgLWxrWTVStQU65RFWrrxBUKKaiCYsJuHwHQl58H9\", \"FCW8OeMEAIxgq9NwklnJbyvSG8iiiK6dWxCYBAl50paCwMdFe1r24Duh3spDgN9w\"]','[1109095188637846540]'),(0.9000000000000,'[1594055089335714672, 7435005193696618401]','02:13:25','1976-09-05',0,46.558,'[\"9US5X6v2tIPhnoMoU4GVoJVX8pE2atwyJYEfrU4ijMxm9dxFELxXXu1VQ21dOufa\", \"ibLRvGgmdR4ZBOUSJ4AnCuBhxosOUJe8wGwL6gAIBZFUw0KW7swEp01tge7p6g4z\", \"o5vc0jQFlaRZx2wRqqWKagPOsubj43Dz2a9BZlEuTSKm99yaCSJcRdbsgQLfFiFW\", \"V0pwDLZeAUbkbzYyubDQF42RadWATpcsNjwP3bGWEbuNCsO14UAlGyFxMimmmoaE\", \"TWDBKs9b7Rgf9XNN8VKx6K2G7rfbVlrfpqVPkvxzv57qt8BVrqF0YLFSQkHsFo3C\"]','[8332207935041814461, 3861913515550831545, 9223372036854775807]'),(3284.6961000000000,'[3343182938515905654, 4781119089333846644, 2271241972735070430, 5284981789946942044, 5356116057672858084]','01:07:06','1985-07-10',0,50455.300,'[\"oWU0rq8OHGga1uI58EEFGIYStiXZUNDOOKJq2sUwGwduqK2XQuXMR4zhgRQ01Ed8\", \"QY7CfbbzAKsh5ZmAhDoKzNlGcUJvmNy3i9gCX8LNFxZdTT5etvoQRDhNJVxLD1gM\", \"FPs0fnkMwAilSXwpb7oT0BaGHymHTde9C00v2f1HFKScFSx4QuwvK5JlNO41WG9a\", \"pRkUaNBGv7dcrajOXj0zzfNlH43XhIcXlCgFuwxfjldVa2NvzBG8MZi5WyKg2Luj\", \"JZjfw2pNpknEwbhEt829ZquzWofQJZBkY3I0GbSTP2qlheohINfPoS1jdunZV5La\"]','[643384983338610060]'),(39587.4000000000000,'[5201371332379159593]','23:21:34','2007-10-30',0,1888.570,'[\"LdgaTBHVaEt7qTby2JqUXSFyFKJ0SjR4oXFP95fbHBIB5oip5PAhcjnFKakzxcMm\", \"43kksfxmDzObteHFwYbZaZdLPk7GBuWKPFeR0vOY0quB0yYCW0PdHW70tNiLhzOY\", \"7gGXW0sRhXfgojPUMEg0tIGG9pBHzcCJUgUKas1mS2onXSRrFgLtbzSgaJyYZbqz\", \"OmpVrB1kVPhJefgoWoPZiwjDCz8n7Tf8zQjMfE50T9DQCKTqSErIVUONFRe1NJkl\"]','[1443300981611704919]');

SELECT * FROM `t174f86ac` JOIN (SELECT /*+ USE_INDEX_MERGE(`t174f86ac` )*/ `t174f86ac`.`col_87` AS `r0`,FIELD(`t174f86ac`.`col_84`, `t174f86ac`.`col_84`, `t174f86ac`.`col_88`) AS `r1`,SUBSTRING(`t174f86ac`.`col_89`, 4) AS `r2`,LOWER(`t174f86ac`.`col_84`) AS `r3` FROM `t174f86ac`) AS `st_440` ON `t174f86ac`.`col_84`=`st_440`.`r3` WHERE `t174f86ac`.`col_84` IN ('02:13:25');

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

MySQL:

mysql> SELECT * FROM `t174f86ac` JOIN (SELECT /*+ USE_INDEX_MERGE(`t174f86ac` )*/ `t174f86ac`.`col_87` AS `r0`,FIELD(`t174f86ac`.`col_84`, `t174f86ac`.`col_84`, `t174f86ac`.`col_88`) AS `r1`,SUBSTRING(`t174f86ac`.`col_89`, 4) AS `r2`,LOWER(`t174f86ac`.`col_84`) AS `r3` FROM `t174f86ac`) AS `st_440` ON `t174f86ac`.`col_84`=`st_440`.`r3` WHERE `t174f86ac`.`col_84` IN ('02:13:25');
+-----------------+--------------------------------------------+----------+------------+--------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------+--------+----+--------------------------------------------------------------+----------+
| col_82          | col_83                                     | col_84   | col_85     | col_86 | col_87 | col_88                                                                                                                                                                                                                                                                                                                                               | col_89                                                          | r0     | r1 | r2                                                           | r3       |
+-----------------+--------------------------------------------+----------+------------+--------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------+--------+----+--------------------------------------------------------------+----------+
| 0.9000000000000 | [1594055089335714672, 7435005193696618401] | 02:13:25 | 1976-09-05 |      0 | 46.558 | ["9US5X6v2tIPhnoMoU4GVoJVX8pE2atwyJYEfrU4ijMxm9dxFELxXXu1VQ21dOufa", "ibLRvGgmdR4ZBOUSJ4AnCuBhxosOUJe8wGwL6gAIBZFUw0KW7swEp01tge7p6g4z", "o5vc0jQFlaRZx2wRqqWKagPOsubj43Dz2a9BZlEuTSKm99yaCSJcRdbsgQLfFiFW", "V0pwDLZeAUbkbzYyubDQF42RadWATpcsNjwP3bGWEbuNCsO14UAlGyFxMimmmoaE", "TWDBKs9b7Rgf9XNN8VKx6K2G7rfbVlrfpqVPkvxzv57qt8BVrqF0YLFSQkHsFo3C"] | [8332207935041814461, 3861913515550831545, 9223372036854775807] | 46.558 |  1 | 32207935041814461, 3861913515550831545, 9223372036854775807] | 02:13:25 |
+-----------------+--------------------------------------------+----------+------------+--------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------+--------+----+--------------------------------------------------------------+----------+
1 row in set, 1 warning (0.00 sec)

3. What did you see instead (Required)

TiDB:

mysql> SELECT * FROM `t174f86ac` JOIN (SELECT /*+ USE_INDEX_MERGE(`t174f86ac` )*/ `t174f86ac`.`col_87` AS `r0`,FIELD(`t174f86ac`.`col_84`, `t174f86ac`.`col_84`, `t174f86ac`.`col_88`) AS `r1`,SUBSTRING(`t174f86ac`.`col_89`, 4) AS `r2`,LOWER(`t174f86ac`.`col_84`) AS `r3` FROM `t174f86ac`) AS `st_440` ON `t174f86ac`.`col_84`=`st_440`.`r3` WHERE `t174f86ac`.`col_84` IN ('02:13:25');
Empty set, 2 warnings (0.01 sec)

4. What is your TiDB version? (Required)

aa19d3f
@wjhuang2016 wjhuang2016 added fuzz/randomtest type/bug The issue is confirmed as a bug. labels Dec 19, 2024
@hawkingrei
Copy link
Member 

SELECT *
FROM `t174f86ac`
JOIN
  (SELECT /*+ USE_INDEX_MERGE(`t174f86ac` )*/ LOWER(`t174f86ac`.`col_84`) AS `r3`
   FROM `t174f86ac`) AS `st_440` ON `t174f86ac`.`col_84`=`st_440`.`r3`
WHERE `t174f86ac`.`col_84` IN ('02:13:25');

it is the simplest sql to reproduce the problem.

@hawkingrei hawkingrei linked a pull request Dec 27, 2024 that will close this issue
Open
13 tasks
@hawkingrei
Copy link
Member

In fact, this sql is equal to SELECT * FROM t174f86ac WHERE col_84 = LOWER(col_84) AND col_84 = '02:13:25';

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

@hawkingrei hawkingrei

Labels
fuzz/randomtest impact/wrong-result 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 use wrong join type hawkingrei/tidb
3 participants
@hawkingrei @jebter @wjhuang2016