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 estRows and result using CTE #55818

Closed
wjhuang2016 opened this issue Sep 3, 2024 · 2 comments · Fixed by #55842
Closed

incorrect estRows and result using CTE #55818

wjhuang2016 opened this issue Sep 3, 2024 · 2 comments · Fixed by #55842
Assignees
@hawkingrei
Labels
affects-7.1 affects-7.5 affects-8.1 fuzz/randomtest impact/inconsistency incorrect/inconsistency/inconsistent 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 `t61a85298` (
  `col_71` binary(179) DEFAULT NULL,
  `col_72` datetime NOT NULL DEFAULT '1991-12-31 00:00:00',
  `col_73` json NOT NULL,
  `col_74` json DEFAULT NULL,
  `col_75` decimal(35,16) NOT NULL DEFAULT '35255.3',
  `col_76` text COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_77` json NOT NULL,
  `col_78` blob DEFAULT NULL,
  `col_79` json DEFAULT NULL,
  `col_80` int(11) NOT NULL DEFAULT '-946722020',
  PRIMARY KEY (`col_80`) /*T![clustered_index] NONCLUSTERED */,
  UNIQUE KEY `idx_26` (`col_80`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `t61a85298` VALUES(x'244268334d52253d675050497446000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1980-12-29 00:00:00','[2]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',0.7257000000000000,'bfGazt0IFc','[\"okLP9ehoOfIfUy3D5nUc5w5kzwHtWayzCJXItDWwV65HgjnKa3YmMpJeLT3TD7K3\", \"uLV7R8UGDgchSK69Xl6gEXSTdGTwOi4WDewLMwAHMPFU5oGn97TjjQiDvwqAsYDZ\", \"vBi5sEgC6YpHxEHvkJR5SQgf6Eo9GRCE6bGUrszYw1snT0LXtLIsmwLK5DnUTaVe\"]',x'7e674d6363585e2332722b41','[\"yWmYbztzBUuVIBBZLTGJivgA2KjQieESK5aFAbqe7s2CyacJDvZApvjNg4d1pfFT\", \"c1M8WvuTpfvrPeyHTyFC0gQNQRkECbkvVF3Ys8ekPzrFO2M5nzShf683DGwr0Wg4\", \"jbbGwGapyVXOzJICCGZu18eWiOq9yZH0PHNRTQEuD1WgLrVy2GhmABQpDuiERptb\"]',-768730220),(x'4c2a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1980-12-29 00:00:00','[2786033664113468783, 216209834908268656, 5620962634434035303, -9223372036854775808, 6973166865549414064]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',99.0000000000000000,'bzInH!N=fmZ&V$','[\"nN0f53J5HaboVRqkFinjcnK6l3m8GwrSctkBLIm3ZzbgQmjek9MgzP82ftAYNONG\", \"4SplrUhLBD3XtOVVNTXM0eTTOmlYgkvf9eHgHxGx2M38ypbcx2L0GTd8wm40zgDH\"]',x'2a2a4f31525933','[\"WhYsmFi74BRWnV7w0J1HCKc0cBGCQiipHhrPEBV5PeZ6ODZqcj0G91z4kUPGHyyp\", \"8j7fYhpV9cAF9AtZu3NggjxBDbnML7xtGjb0jLTrLp4x3u7Q8frzTNNOYJPglrYX\"]',542985182),(x'67494e2358214769782843637572566568640000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1980-12-29 00:00:00','[1121926719409012308]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',0.9242000000000000,'PS%Hna%-Lzv','[\"h2U5n17gqr3GJTbek9hu6jGNy3bpY3G1Ef9E6VyVEIEN7ZTLARF7S1B8jD6UxqHR\", \"UBdqIZjtNhRgMuTYBJoJV32YUhsACFvc5FEJvs1jOu4gRQugJM2IPLS9FGRqlL3p\", \"lWSQuQOwrsxHOudB1dmX6uBSAe5kS9kTr0oxc9EbCXghzml2KpdzncYkbcXYJplv\"]',x'5530494e40','[\"6KEzKoKIVQdb10a7KhxeorxwC2br4YeoGJeCTL0BnTvYZvBTcGMn4wMBjapPs6He\", \"2GXpNQwAex3BkcV76FSlkoS96sdJvMLfrAAwkpxtEp2MTLTHVEXzbCCdOncEGEQY\"]',619635276),(x'464c2a794c286b4b570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1980-12-29 00:00:00','[1063414791300340132, 5955792018178627386]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',951257.0060000000000000,'#0ZACF~','[\"GZOocYIReu0jaxed7GNcSIWWH6Xb0czWEWiVC8dzA89aHbeRIS0zqgwlo9Xd0XL4\"]',x'582d4e3076','[\"OlqlAvEzYUmlZTfmU5q3MQ1lg3R1LR4iSOTqtPLCGfF8Pb9gJCikIxvwUDdSfhCx\", \"V2VJz6Oth0yyAKdtOXtCGUxSqoYn1N4oTIWASBE3niBJwVxW9D1km2s7GtacL8Bi\", \"1tFYP4ZOg8ttqxOwWt8ss6fVIxtNkqe7tfW98oMdayOpNkSoju0gXitm1ovAuykb\"]',-1631722875),(x'557844616947342a7868613833334b4335000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1980-12-29 00:00:00','[6836963398343278107, 3604187905560811635, 2471480107541244554, 1, 3744784212157929486]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',7.1000000000000000,'O','[\"F5r0C5FuOgbbf4YmpjAX4NQPUFtSUEZXJlHxdWASqFi3q9pdTmwMajQyqMn8su1u\"]',x'245025456d3069373d664e6d745640','[\"SKXCGgduIOPgG96Y9oUFdXHYnghE9c11hrbQTxYQFvB2hLKocQ0de9ahSjsYpC7o\", \"nBp7x6cT3x35juaj4Pn4Uk1wzGxLSoxONVMLVS1de0hhywYs0EI9KF876tfPnWDX\", \"0dlbmVRnWOaUWdq5qLgFwjKqiMAW5yQUGfxQXYxzKh08rfHcsqlkTRQkCrIoiVNU\"]',-1041741526),(x'4b7e373849540000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1980-12-29 00:00:00','[277087977837928747, -1, 2975734424204088647, 5603975063470051454, 7725353919237545845]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',241.3940000000000000,'oR)dA4S','[\"8ys08TrHNP8NHCXy4NohDohqPM6OVLQzLRtjDxl5kAdkZwZDblXleiC5yGU20w6d\"]',x'','[\"VxzOE6oJvSyWhMPYfVUjhcmYXBlyZnqlbKVno4TWnoDrKiGyMgP3sRrWMKtsYuT1\", \"p3WhkJB4UdDjcnp1sGlQhs6x1xZ2cYSAOqb4EXAl2tTJu7mkft1QszOTHL7CiZPW\"]',414594236),(x'4663574e4a4e7372793d4f383300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1980-12-29 00:00:00','[5876085250774630879, 7155738159800002707]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',995879.0000000000000000,'pmjxmmFDBe','[\"IOY6PFXFlVZzJd5q3joV83He5NwNOnR2N5WNI2ZHIfS5jr8CVPMbCcbMDnsFmLWy\", \"9arbvOh3G4niUMZa1mS67CdkKZwsjjf34zJuNuCtbX2wHoi4NARzqIVGC1SdaGJj\", \"U54ZEbaKj2bUvWOCZQFQNZX5u2YDjCcXNoidfXZGU7bz1B0fR3RcS9M0BjHSSSa4\", \"qhyKE3wswMNN2luLyfjR9DFsgt3TbSXVpsnZZnEaUnDpHh1DovafwgopDbIn3sp8\", \"2XrGOqMkLM3xgVVOM4EJgMlKiojAAcsSkd14rd67UP0dRPPlN6RtYUVqkhQph4MN\"]',x'65636f52566450756278444d47','[\"LVIN5PguLMHwZzcjZ1VTh8A4DyL08KbudXbGv5uEi9lmMmfYAuy2TdMPBNR4QpU7\", \"5QBZy2IB419wv3TVr4pWYoZ9VWRN3hjdQUgM75erLdt56kkASGjOaKliARhryvkI\", \"7HVKiThkKAq049t4xiMU6aLJHfyzmFP8sfYSITNqYoWCtGlie3pSAYKUHgWrLtwZ\", \"5qXe0OWPU0nzraAMrxjO9DFJ0WWGVCDr4N55VJdwgnJcKl9rRimYzJ5QxhqnB6n8\"]',-1415629819),(x'745633633128404c3230292b58613276263d6500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2010-03-28 00:00:00','[8867528722093652303, 8145448421282649106, 4853372671033029790, 4544428290673923189, 728087081641458177]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',703630.5000000000000000,'6q!Ch%dl%+W@','[\"NgBacJ6ynKqdRhe4ozAUxFqBNT8pH2xu56Ujl7Nc7xQWPrWtcHvCN0caZy9Hjvy6\", \"9Bmf1SN0nPk29VUXi8Idjja2LjMg84mlsZseNxVMrwulyMFVZvZvmID85lmtwX09\", \"6Q5LN0qh1yl7nIpI50LrkzyypA7nGHpxVQ8gB1mgYVFA2I3rJHrZzC8TFvVHHtET\", \"BuCtBqJSOrx2dPHVBXRVTVC450Cb3AJlHcp1HmY1QpMsZobpa30iegCd4GztJKao\", \"EdYoQbe5GuhbhC94jnUt6GbMaQhSw16PFr1XPMUko3JcqfP1q8aRS8qstWqkq0yi\"]',x'59774937256635565357','[\"253Gp997SNVYggOKXf5ivGKnTBs67AlY5oJnZWAH5Hx2PXc8cGCvpUCZrtLUZ7FQ\", \"Hxq9KnPHZ9AFbJCnY6zvMfyJxaFQGqGRpKmmIS63UAx7tfnF8ZRzKMSOrdCECLvy\"]',-1515486431),(x'6d51303821343000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1981-03-28 00:00:00','[5310803527364097621, 7794034064358082126, 6243322966753739013]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',27.0600000000000000,'FhwIRkKChZifquoq','[\"2QpTFMYCayrmqYBTSrTiSI2OXFNImaHCVtSiSoRRr1AE7vMrAYClhlSzay0NbvZb\", \"W7p4usLe4UGkupGtrRjZLZhaCCo9i4FRBxaVnDEBTBNCH4GYKxG0o7CvwvnVM0P2\", \"rrEvGB6jgW8XCkpqdWZV1GXUbU0KUkhzNgVEnJBRdSFCyxMlKUlUBHSxWrZDIea3\", \"wg2RMgCe0ZFzOWnE5kbaIYLoYF0Rh2KlBfeaPLZjot5e7BgrzWGKRKi1y8TXcYvF\", \"Zjwh6sd7MybtF8FRLX4EMcKFZph8xXdOysRsBkwxZPv3ukATDeawZXhqpNjkjWTz\"]',x'717e495951','[\"kiaSCwakYXIIAK5R4047DK9AyWWCfFkaFgrTBJdXbS8fdFe3Dcm3Ahn9QJpkX09v\", \"heNTDg4DeQJZ50CYsTWBMOxuL5mxq8y51Mu90lhBkbPvyZAmmrXEvRbqhqrJtbaC\", \"FKsmgBivrfjwV2PUwtyzWSVtQkLwsOyujd6P0IlY53D3doNUkAevGjlDDg3YcyLz\", \"lyQ3ULRSqQs7lCJfTTjC5pnidMNaOCq3m4jCZ3hNZVmKs9DOrzW7zuhTb74ogr6E\", \"UUMiyqKjYjhf2UtB6lkYrI8pi4rEzJYXN8SKgVA4IsjQ5u3Hnb0xYJsRkEoLnEa0\"]',732103284),(x'57747033307e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2017-02-12 00:00:00','[8160667650558325041, 6496327535588131712, 5801122917501123355, 4328889746810148441, 2288047220796779681]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',53841.7900000000000000,'2PvYLPmtYhr8zM','[\"9z3scvOa9RrW6HG60oNsFA0jD6DoQp53FHp794SL6DKEOLC8UswXea2MJBVCmj2r\", \"1XDIUZVgCOAEmQpWLoDNCftPIOMlBWv4ALBw6f5R0ZPDU04jHZOyA8BCDW6Q9vCe\", \"FgXslvr6DJfyumSGFHRZE315bD0kR8AHgpyQAbZqoTFQUKMjX4LNKhEfh5TZbCV6\", \"dUleMNByyGyCUQ375ku0o1YqFOJkKsA9J1o3HdiBxF8uIv8vlrwHY5fXrfFu1Yge\"]',x'735334467765795361516135','[\"QFGOz4Z6qq4ShZrflSxyPUFlA9nFRS8hTb8n7LG5brT7fj5NEGatP6aZ9HRxuMBk\", \"UvJfYXeTCF4CZxislIJuXQq34IeFnpU4eJvIEKpdOgGBsEp2fQBbGsKq24zpDoXt\"]',2147483647),(x'6f672a6143545e57386234542850440000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2014-09-27 00:00:00','[3498978531772615847, 7150249656551953586, 4689017469181627123]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',21245.1034000000000000,'DqpPzKgPuu_&YR','[\"HrjJYM9eYgFwFXbAZ0tqEAZBF84mFbXYMXQHWN57OqcKZWiYR3RihPwykDwNItzU\"]',x'5f7e3143474959297a2a363468','[\"LGinWduFT7KJOZcBtPUwwYWhnXtrU8BHHAXFtbHqgQtNNEZ0MneMkR2qYjIjUYnp\", \"aCzZe6XCr2uDd2ZiIZB8qQba1ot6TNuJiNzvH6SPK5c1IGEgrPeyKbdXFYKhW7Fj\", \"jjfgWxvQUv9AHsbfWEj118LJAqzyna6xn36f5SZWab9RqDifM7CdyKzyrH8phgaw\", \"dLFZGkKfweWOK0N1hM8L7KYaTn6aBCjndaXR7z5vqroRu4TFfHfjWKsUkiUQzQUh\", \"d6Etyt9noIf1vnT78hNBmJbqYKdOxox5r0ldPC4Vyy6PLp6heFxhahvW4PWGCybv\"]',394269794),(x'2900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1984-06-07 00:00:00','[8750897102153075276, 1630082170383391299, 9223372036854775807, 3528934326793806040]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',0.1735000000000000,'','[\"8CfX7PsYHictCs6LSla7aZtyGAQIeEr5npPo9MUSlcMCx3YjmfGBzspqwTFSu9GB\", \"0T91b5eHFgEyDOOW1Ts6467t9ymwX5cAKZRSYVjrGcrRH3KIUacHvw4reucm4bCa\"]',x'213051486b6f682a5971','[\"0HS6nO64nMKd3EXAcUttb5sjFdXmMeLtWbXBN5oTbjDJ0H5apMZ8fXLoFX843Seg\"]',-1441991359),(x'45394b474d48332855525e623461570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2031-10-03 00:00:00','[5259275879873419759, 8814546150634470426, -9223372036854775807]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',0.0000000000000000,'RGmVJZ8HH+iWn','[\"envx6kV9SbFWjUK5YY6JBlpOPtkPg94vgz8p6Bb9AA6icRq1lNlU6hRME1P0gyxB\", \"2QZKUg2qNHhKStnlE1cnXuURhnBHo87k3DLDBmh1P3yvgLhQvNnslIDf7NEnxfmi\", \"dmlm6gDgziBXkKusgoeCXLrqSfUYXTGEFjUXQ9XATY6FmRDoHu9ZZAWmU2cRx6SF\"]',x'747a6e3875416654','[\"nDw4gMC5kfQiaidVgGfgrRr9oA8CrIIPTSh169QOmVQgwwI1ox4cOsTJmClsrbOi\", \"CjA2j8Qw0BeJK0MmHxI78P0MTZh4tY3g0KRo5ExhbY9DDRkpzKTuhDkUN8jubJqX\", \"sVjyRkbz9fv3DYiNaaXtIxi9Qu6sYLgbbDAfoW0vioWUhRXQD0fMKtsJQAS8kdYW\", \"vBmIL52hFWfdyVWneligyemLFyQTQwsjykiWvSsXNSGNr0gKlJi4L2s86qGZpnrJ\", \"0RLAgOVy5V5qkriuzboLrXgIXvdoGnmICAxQPWl0KqhCRXT48izDEb9hLbi9kxkx\"]',415143520),(x'5000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2013-02-10 00:00:00','[9223372036854775807, 2691192579700345343, 9223372036854775807, 3675383209648692659]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',823.5040000000000000,'v4$hYfxMzXw8(*','[\"vJwgNz7U7TOyxTq1ZFia370VnBtBqNBNkuC5UBgHGl7YmgPFOzOzt0sfzFzMYaUQ\", \"z7YMd5vaiIzd3xWCKVqy2IP26u8dFivw1E4zAy2rLpAkxsSKDTUg7e92eriPPLYd\", \"wjRgnOBTwZUTg5YAhve3Q3hZ8bqv2wDs7ik16ErIBTsBvZ9RndSSrn7di7xQvLyA\", \"M4jUCZPN5O1LG73e0Uts0HLt7DGjsIY17XpndBhRCCSzvs95P35Q6iaBx0dj4RGR\", \"5qyWESTsEyHQWFRJiTCszVfFuOLatqDv8Wvvda4CXbxzeCv2TFOMzOF16olgBkdF\"]',NULL,'[\"QXBOBxzKJGI3OI2m59jjKGJp4BdfZZ9xG0lIRK9rVqjkjR4RpUOWFqo8xdQohZCJ\"]',-866244926),(x'7577527a72485769393928385537535600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2031-09-04 00:00:00','[7638223771013364388, 2301568669539339323, 2752673170613222519, 877610638841991858]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',0.5000000000000000,'IC^0bV4akV','[\"AIQJQeowg37gwHCh7CWdJhYKWSbB13WMgUawiM8JafDFihrEbWouZUNBljxyJGSQ\", \"coo5VC32qWweDjajjoq9xuTNCXHkODOQkELsgJL0GgPNFOopbEsUfcHu4TqT8Q2X\", \"kgUG6vy35Nrd6S4fpU1sdKAGhKvyEKxEglzSBgPIuJMSNTffD1Fu8vC1bytEPV6K\", \"XprRiD562FJbgNRU0itXZrJBbRetF3GBMhQXkLyd07jYdz60VQe1lDgulIPy9FdR\"]',x'573d4a2b506d322a61724234513d6b643256','[\"3Yt7E9WH3VYAe3RXF4VaHYe7EcALKkULRWtZUnQcNcBNQx3007GEgYxFEMF0CMJ0\", \"PKkiInM00lzOt2ZTFQdtZyLjnR4jtSrfRmC5R3KWpY2XmlqGWP1eZn4ffATy3d9o\", \"YsHGCKOJ1dZVm37AfoVXj7O0ZOc7A31JwVSj37ehFrFHd2b7QqE9axv1e9NGIj2Z\", \"KXFeBIjMIwT56UKx6YzvU4EySSrL2T5rpP0972ZiLO3VhmQwUPOjc9mSR9Xmeh8i\"]',965848777),(x'69434e3d6971297336284d71524b250000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1971-05-07 00:00:00','[6646223494336125939, 4568139103849028779]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',92729.4482000000000000,'ea@3XY$tR%-ilGB@','[\"pWKphlfl6CJmeKdLU9PGRY6uRBt9KNRTPJLiqKmHHnMYw1LwBGDq5Nr0IYcqzfXM\", \"iAGfPklnwlPquoUoFoYCblRK7iIyWIJMqg35rihFlwgMr3hvzQvUJN02htsWEN9d\", \"qKjVUlvv2iudftNHNnqwkoxyY639Hn8mymX2HHKUpSarDsSWAQaUAoOZpmOve6A7\", \"dwjV3fxzZC6JxVvt0RcofN6OyiZ3ecTsZEQ9o5YlyMYqYidV1eIWVvrIpaCsW5l5\"]',x'2359655a413d672523392939','[\"nikTvEWPTMMftrFzh4hRWaC9ialX6Wrb4PzM6YuAZpjqubx9SNbutWSbfS0jjrv3\", \"AxyBgH6DwV0O7l5hlMqpx0UP79XuOBctY82aX11qCBIko91aD9RRYmXSPvSMaaRy\", \"Pmmyl4FmKoAQ4poJZkxrzONvWrRTP8zR7JW9HtySK18zed1M09VRg5oR55eI1Z5a\"]',745496927),(x'25562344256528776b7e4c300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2003-09-17 00:00:00','[-9223372036854775807, 2725451283702767989, 1714571966393976287]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',3295.0000000000000000,'_','[\"V6cGqIFFthBPggNmSq7Wenqr5P5x1D7m0gEhhbHF0f6CiXjuHbnK6mTKrWsnVXul\", \"V0gICZrT0Oqc32orPF8DficpsUISVw1VVE3Ihbs6D2hMxRHcQv9AUw5BJugzIe0I\"]',x'716d594456252b317765574068','[\"U7EV1LONvke6rqG0nNdWwlrOHLljb5kneDqoyc2V9dhsJ0ii9PjSNqZFHqfIDyoe\", \"fpc3fcgc8Khw0OhDkvXqXPuI7vB2qLUbXHzGTfcqYNiMdz6HXTikhFWkrPhJ9YxB\", \"CF5Z3tLUsvL1tcgB4o6IGzFvihIkHkqEtpBbR9LLWWxDeiyXoGE78GkkEY5K5C0T\"]',542104413),(x'215f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1974-01-24 00:00:00','[8770846335108183899, 4698163365243489978, 6067253269213459491, 1873016314900529740]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',4862.6503000000000000,'tx','[\"rUbPkzRgmGxvom1onaSa2QBC8w8AJTLn1GQC5YVZDSUXq7NzWFlutDY8AgQU7P0R\", \"htcqcVmBIH7z0S0aqaccmCfAwRl3DHxdPANF1Wvt8ePRCCPLEzpS9LvI7ezmEsss\", \"Zy7OoPzP5ux9Cq3fXM31HATQVb3033RHY6WEkmfQdU6x2W1piNieis0Nk1dq8p1Q\"]',x'','[\"trCKb4LqScPqkdR0GcbiJMVFyIg0DV4fZ1TTpTsL9hiKF1Ogtv8fJlBlK00OY2PL\", \"LW9v7DF2VK3S4TfEzJhVinZ6hbZfwzSSAfnN3CEzvEv3vZ9UKazJVPY9KQR5e8Gr\", \"Msp1uvZdNXkQHdgNm8jeHsNXpppaAAc76D2UpKIy77I9fBeHyPDtKg1Py76jVXKQ\", \"QNIQbUBpJsc6v2wxsbgmEeBGGJAODvbP8whPeULEKMz5BFqQUtda1Uq5CTkymFDB\", \"LRCxPiRMrO09tTvzbqZmJRGpSuFYVFXjF0IWapwasLAD2ChyXX8QKt9h76axAsim\"]',863954939),(x'70756642772a714c674741454965000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1971-03-23 00:00:00','[5243428620352020917, 5568391592292303044, 7909748808678584821, 430379849967994272, 707105727635344166]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',143.0000000000000000,'0N1oNfHqNQUiPQUQk','[\"MxNoJ1SVoLJ5Vdg7BwDajRgV26mRHRjflT4nJMYYBTfDkv1dQtVP5femAfCfYJ6j\", \"kpYAlFn4PCeGIqilvUCh7RMqPhrsN3OMD0auT4aQJ3mngZKHaVs50A7YRORJNKsY\", \"4T9dHuL2qsxLfMfgAtcUWKAmljuIzg68X8gdQYZigCfMcPSyOTRkbAEvjL1wl4Yt\"]',x'69584956343325','[\"1dog7HyQdYFcJPXJ8PjQIEhH7rWR66Cp0Vh6qmTEy0YITPBsLgGIA4yHuT5nKnzH\"]',649625869),(x'2a474d5f63682b28453452000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1993-05-09 00:00:00','[1719491966238713970, 1393108457729113241, 1287922375661849076]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',49.8014000000000000,'W4I9OToFfv!kny','[\"vFmBKVqpSyAw27DxiPlRnBh3RQ9uXhXa0AA0R4n8Ozju8MuUwxihrci4iEVJ5BgD\", \"RWFrsUR6WXNXo3cgBUaICUpHgrOA3JyYFtb2xOj5PPjKsEYmKWIX3jUYNgdmKNx0\"]',x'76526c7a4468','[\"K3OCyJOVr5mybh1qzeFsPFCoItl7cxTGhu5usVOOhYhh4HQsxZFr3sigX1C1bEoI\", \"F9vUqpYmvMcb3zXgTCgyyy3XWholRbgKCVY2BdvcNQWYJpWoT9fUF4fDFLa4uKvh\", \"UG0KV08wbGVpTDDYgTL6kROL6krZwEhCX5nnZUMD1VlCqvZPdiNwVgyu5Rj2agsd\"]',1703027236),(x'2650736b5e6721386e3d4e307444725423690000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1996-11-11 00:00:00','[8717302980257269786, 7352052435240377438]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',0.0000000000000000,'5C@ieC@K7','[\"0cL7Pt915lAXJEpCOPcGNaf8j9pVCnhcarCXMMuSpI2zca4jOokkqjtdLS3jwOm2\", \"inzxZzSeryaNOQTVM3MRTsqnW5utNfO99pqgbka0NgWRYSj93tsBUGI5pwKzXm1Q\", \"55RDD6oyKbmQBeHTaYHRasIXxjaiOCg3laM6cJBMnlhHesqHbOME08ZkWiRhLEYt\", \"JlnOWk0tG2zQnCkbCvXNiLUV33Es350HU4vdLL7gmqYz68NABs8z13s38Dah3PVX\"]',x'282d25296a755751393432636238','[\"dFzil9txBUFHxPHUr9wTzFgqQozdWgSXGf6bISiOdaIS8I1UNDpku23EP3YHgvAY\", \"OYvfwn6bupadLR8CV8WN7ZCCfHLCJ3BohTEHSrl0q33LbqNRnEAqRXpawDDIx72I\", \"QBm4BsCEksqbV8KwwTjTGm2cYMi85TECiJzXk7CoaxtMYdHCwUGRXpQhu5LYWMxK\"]',26165514),(x'2b66393d3d367130314300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2014-07-13 00:00:00','[8365648798966068151, 5326450683673479456, 3540428616184073157, 5487293052067343940, 1329944379116433918]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',98635.4217000000000000,'E1g%7&m8ma!K_J8#tb','[\"xX1JOOPkkMV6zl5XAG0XSsEHTqYqZfAxrpuvd4sSYwVDo25gWfUPkq7iPB8CJpz7\", \"VXN6Yuzdx0Gjbw2qjNMCb5XvEeqCAm8YQ6hm0zNdeAlszGfjCgKfbBzJMrfooU7C\", \"iMiFDcmkFv1yYQN8NKYZSdBQHYVN6oZJrFCCUKKJuddW6ByzbYZ7GtBAhnfozHbd\", \"st2h25rRfEYoLvL8fq4ZIttbQliTIbjZZKQ2gl8PmEZNLs5Y7ryuZNhZz2ecWGq8\"]',x'722b594d5f7e','[\"4pm8n3uZOlhsc3PeMVtoem43mqMizmQjDPmePp3DkoNLmBGzWubaSPlAR60oy66g\", \"gZa2O4tB41bPEn14hFW6DWwtDOHAoFk6cY7LP2CMqdkUa3DGOwfBxBGl720Pvdoh\"]',-1034796556),(x'4800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1982-07-08 00:00:00','[1424359607579336053, 6824469241721227587]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',8491.0000000000000000,'ddh$~ZS(cL^4','[\"QxIoX0MNyqnJUyoGbya9GZdprXx5GHTOuDzVWtASZeXrD5lxx12eYbmRRscEAyZa\", \"vQisR85a0TF8pAelwmtpKsN0DEyOzNH0IEVcOMeG4PDdF2cNsHeTcVUqJuUdh2Cv\"]',x'5558622646344b527369254468','[\"4RSr58UOO928d8zAbBhXY7ot3Kmeqm2Dxi9IYNLaFDIGJVZxpkFmhbUiNBlwKVzK\", \"j7sOgGDRp9ItSKFPeK5yL1GV1vvFo0Yg7cq7DhI5ytAXvQtQKGZ3WGbAFZQ7Alq7\"]',-2147483647),(x'426241583d4d384d546352773769776d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1990-10-03 00:00:00','[1, 4617020669588082736, 5739020229500513618, 1326254519938675703]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',0.4503000000000000,'js7-jqSy','[\"Ik1flAN6fCg3V8bIZBsqH4qpCpIPlQdzPt1M9HIRlRfIsdHDywwdWfljIqaVnnFi\", \"6Ce5YAVYZgePV7Rc7EgNSe9iScs8orwsKWWOBHaAxNZORpK2mDUdRCrAO23XEL2h\", \"5cYktCE6ezZ2F6HHyE83XKllPAHCCSypELMuYuK2I1jmA8NRBE7qUGt1D83g80Nh\"]',x'356a6f','[\"G5SkjvTYseOnVuAXWTZaPndRKKvyDd7BaClqjVfmIwNT74At40HlB3LQk69wSk7N\", \"KSiZApt9xM3Vo4ppYiWr31HAz71mfWv9BoxlbpK1UHPW0Drck4zDhP2qCnsVMIOr\", \"qReYYcnNxzJ4C370cDpjlYRmIqOiWotMLJWNSjuwYlnb7c7S4JlhYMEyd2wtoDUP\", \"1lXA7qLZ7rmwpVbeGMWlVahQqJMwfnwX8RfaSB623PQ3mB9CBz4A2Rer4p6KGpQo\", \"RlUswT6ksAaV94NdZBdHqxpuamnOn7IArAggtOAfeBFxPtsfZYHv1s3KOGriz2JG\"]',-1664751152),(x'362a6136465a463272285524537725766e4b4d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1970-12-19 00:00:00','[4379566925672446433, 8022948120577789820]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',86.6320000000000000,'O+','[\"ufn4SdRGWM8wZabfpGf3N0rSmOXeqAqjmNBe2q5jsTsnowTVxKcu6OzmEd6Rwt9i\", \"0mNTfagM0wMxheiSsGd6SdqAJM8f25cjTcOMh9JoWg01uny175RKR74vXp7ezHra\", \"l8QwnIQdaD2brEuuynEoaT6Rm2lUDkUfC4qfrr2ulWeju7i9yHAe7gVHsmB57paY\", \"GodShDSV5zUljz6YRAYHjqg4eGjJ4pAtS0rD7IU91VSDu2KKQnhSX1jBmMSUtNUP\"]',x'425967735f342b6f59','[\"RHz51qF2WNo0oj4bQtM32Tzc2aKjIEa2T7TQZgqWEyiui15FL8iXS6jHqD5Dj5sA\"]',1272957893),(x'706c556f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1984-10-20 00:00:00','[8110479956303206926, 3908848609333001503]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',22.0400000000000000,'=hjp_bZTQ%mhE','[\"qrrx8zSOjFKo11T24Y0nnim57hnLOXu11F0AwWADj8BPDfbYzLJvbUUFFOJ364zk\", \"LxrQ282kjYbCAFVX6MQdBOpoi31FmVIT0RSMq41NQfIJ1ZYAyfM1jSpz5cBqX50O\"]',x'4d714e4076437938566b404e6a566e5f36','[\"GoJBy5GndzKAQsTUPUFFMGE1IvNZE6joHbEm4uCtOoSYSf7AIMjZoYRy0oCKU5Vw\"]',-1),(x'4b7e290000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2031-12-10 00:00:00','[4670206350187888447, 7014547489375638275]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',630.8100000000000000,'A_mOd','[\"tfV7WbgFYIU1KKtB7PRuM3BgzTkeSUdvZMmM3HHwHMM7H1qOtZfUilDtY5Achwp3\", \"rsj7ojMfjvUa7VXfGjM3EyKeFD6Ct8Wok37MpDRhzmiBX4n5qWAXQnR5IgVCMw1f\", \"DDbkobqzZ8SpyOM4LRjfvj5e0clPfmsfqASLXIKVpciGrRfnvTbj9AjDBq8bYDet\", \"ey9cgPCOT79I2vcbNUpeHq21ATsY2VhOokWmduaRX5w2UfsiyFLSPhwPx7VhPqRh\"]',x'4074696b5136495e','[\"V2is9UZVqoOhtPfqQk1VSinhprNAt7jCWQsRWtFJDiSQVbk9ciZnwJAl2s50dzsk\"]',1709561739),(x'7570366e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1991-09-29 00:00:00','[9197285688962310988, 8298563179847366897]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',70994.4300000000000000,NULL,'[\"YXkJrwHvKhLyGaeYhXrpln2FrMZEeUPpcW2Fh1Zl7adntiMOnQdkXsgDLrKkH3XF\", \"H9gJe8FoAmuPwJwaxrPbY43DNnbe5KL56HtLRmRXl2IiQYqCEZlCCsXEFRfidHES\", \"gSYybuSScuiXt8xU6WW4zQp6wx8JcQupNsBofXp4yDFNoi3XVpxg3Vy4cYJeA3qN\", \"cfjs38LikaLrF03owlsD0NsYwBQ9XWp1yVkBwEkmAMxaKlpeK54U4Ocv2OnIQq7z\", \"P7PHq2m3DXkAflZm1olguzBYXgqTgeKjY5BYRuZZdxtvedHzMc55ek4aZDdJUsji\"]',x'6749734752285545744d5f3079','[\"6S4x42ibsV4oTrigBxi8hbcl26roATCdmXJIQnHHGYGFojq2a0XVSSjorqZJ5zMf\", \"pp8X6Kb1vZF9yyUawzKVDRalEey1NuodVfN4PL7KHLuNGv8SypOvjoSwXM1heI1E\"]',2022893258),(x'435e6135793438774a7000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1981-04-26 00:00:00','[5907925664077936595, 3369722584097072819, 5835711727561410762]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',0.2000000000000000,'PrxwQWu#nB','[\"H2GthDw1yf0pctuElEwOWyqiTBjpHGmVrJnRTPaEphHno3JvCMHAqvq20rleqtLG\", \"9jbwB6ijFoc4S8QTdHXvC1JpXgE69PyRVwknsqe76QWiPRWbEQbx1HztFB5CbWxw\"]',x'4867677551496e','[\"ZvpAurRXiYVqnzDdVQspmmA5yvpxmWpcfFbudr0FH5vhoQFBrLCygzOeGlX20sKQ\"]',-35097579),(x'766133773d4b6e444c685f2b5364523267000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1981-11-29 00:00:00','[8628637859757992714, 6163891607028946735]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',3.1700000000000000,'c_b_suGpw&08DsDiF','[\"P7UmCGeBOObee3VqyqAUf35sdz307JXirs6R26rlssiYnEPMWEeXvX5mAoJFLMrn\", \"cyTBTGBRKGKqoYKrNyeWuxfdJ2DBp30Bj0ar8AL639IYFTBo1WffSNVZf7JJbZw6\"]',x'78','[\"Rw8wcG2LK1SWn84pNefsar1wSxHyVKgF2eoFrBy0aJAjTJU2pQxIFVQNkuGveek6\"]',-771923182),(x'354866325e61756b656b2b410000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1980-01-17 00:00:00','[7239820075911232975, 5165180562879473865, 5487894130172929934, 6240331434772177392, 6301139125131715642]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',73.6000000000000000,'u5zaa7x','[\"lT3eFD51H5GaxtPqzqP0klVdUDmXmkjru8Ut5MJuGdNRDMqf3o6IQT9lRZTBlJvl\", \"tkm0GFMxddwzh2w2dTm1mfQlODpY8B6SV4VHr223V8AjcCm1Yg4WgGF0MGedb2bX\", \"jDS3TqO4fUgwg1ozubhQS7gotZNlZgpRSaLQM4GNPW71G8CwkJltdzXMvkTY3TRz\", \"PUJXNgCGbEOpujP54pjefW7fdpdS02OQ9FoeZMMlf3gayNVPOZUIuf0oXmPib2sg\", \"sSxAtuobbeLNMv3H8srbd9XfslU9bXTucv34VR7SpVnjEPmnvprdpLfuL7mGC1dr\"]',x'61423633674323352445564e75','[\"Ux113ZXAYVqalqlhfgmkA6DmKoLIgoctu5lVg4irRxBVG5W780ngVNLheb5LOhKT\", \"DtbqzXToFXvM5v9X6kClYSNtR7xl8zdXcxEmwjqGXVbRu7ks5XL5IOFjPk9cHEZz\"]',-1785310612),(x'524f4e4761373645734b4b6c5963470000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1981-10-23 00:00:00','[808252063897818455, 7601727311223349023, 191796941149332104, 4887963947110370636]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',2530.5180000000000000,'rSLbjs5jNPR','[\"R4kokwOxbxM7JKlXon9vYlmGnONiOjYysLobQiTVHcH9YhgIAANRG36SFN5sY3gk\", \"gb8IxVThF6W0EF8vTbKOLbtCtlUHfa2tlxdoigTf5KcEQHzj3ZdvTAC5BXCBDOHT\", \"y8xMoJYJey7FXRgkaQpKjUXGZUA4MgDtDfs6FJ88Vstz20YsW27aob9DUsuW6K3u\", \"wVv5TMOHtWZE9jmXoKGxOfIyr3aD7Tdm3Rt98LYLWFYuukfJ5Vg4yWZvQkidjIyP\", \"fX11cRSZ4TcaXoejrPNclIJv1vFc3rdngjwvWOTjxLAWyzbuembUooD7kjImofmT\"]',x'66316452212d3866','[\"bgG1GNVJCCNFMr56aQnczaSHDBSpcNtzqzjvcg4yzRJFbgbPHbjkh8EF8BHFgNHP\", \"CCR8M77WmeuHRGyUuRyDppLMHqjn5E3Z0y8XZf6nzV2TlscXbbeCL7GmqmixxxvC\", \"7sOM8i4Hu1M2N104K89azP6b2Ygt85i1RC0nytmD8CBscKJQbVGWADJTSgZNcJdX\", \"SQvEtZ7tfW6ItyCfY0olHzdfpRleD98343Wf3mrAyxO4Bkm4xXED8IR70s8kV9hQ\"]',474619225),(x'593835722540332952474d522d24000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1989-03-21 00:00:00','[6412778172147726466, 3043427495520640442, 2093094187259737575, 7930156186476952010]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',863553.0000000000000000,'1Wfrs!qYl=q9ixIX_9','[\"JW4iRZaNnEhert88CMstUeG1nYzhj6I0BmFT838fvhHTcrla26LQ4FksxA2vuxhG\", \"NjxtjqoLMcmPzJAUsvH5JgtyFXvzvRavd7lNy0yY5QBlrz8o1JUnibYvdtwY52pP\", \"TDSLr351c8jahLTAkoppPbdm5zkKgqqoGePYp8uMTaKtcYw1dn5G0qpW0aokIqrA\", \"xEAXRduE3OXEOKD2ai0RceKBAc0HtAjnJrDPOLa6ZHiIviUOUFzIZy04VBsGjGBH\", \"Ap8xlujCo4X8qgYrwXFgGN9pJszixJ3oaIzAFApWMBjzrF5ENQI0qUcZXykjATmW\"]',NULL,'[\"O0Wbh0ed9526pXGsmbmjEdf3jvXlx4b9eodgzGiR0XFM2c5Qs2KfvszEWu6AVs0t\", \"5pFQEOtIzrSptueDhjlj18XJVx2495c9IRdeMNzs0H6DzRkUnPiwG82Y9zSkeNo0\"]',-741338274),(x'0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2009-05-14 00:00:00','[4408306895929544150, 8050999426819584729, -9223372036854775807, 7128663424344369386, 1097052050724643427]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',156424.0000000000000000,'Noz','[\"6ArZynWwf10bFefks4giiwC3KTpGx3IPNv9pMTNg6n1g0niqjuqkTrAZqPZ3eiTd\", \"sYy54co2YILdCizLlOwJy1Qjx9Slben6XfdSs7xWChUmxhQVfS2oDPMt7HaRWRew\", \"tGiGqJqA730fz4XZmsFlvyujN9WWNpw4SeUYxlF0ZsHlE9xOpIPc3a8DI5FKgVAU\", \"Al8l5ftkwL3SF9z21JQ7KCTYbCW2GNMVgwxxmVhY2aKdIe8IejNylKmOCKeAqOPI\", \"RVnvtVk28VrWiK5h5H656wwq05T6uzy37kp0S1Z8w5kKvns2vVPQxZPCU6hvxfCd\"]',x'54252524334075597a57626928744967596b','[\"mPBd6YEriQDpxrUkvJdyhObM04FanNGa8urvSwi29I4uYMQBb6gufOakLLkVsR5u\", \"5CDSrnLerM1fZpKwj4XUj0l9njrTniSc9qAvh75ppVcZLZ7SBDVFGTGULZr5n2S3\"]',1),(x'4b5e42456c3251733576436b7300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2017-06-27 00:00:00','[4081783654370653710, 4112822716303842150, 6473094800329335711, 6219902220115905314]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',43.9400000000000000,'s+','[\"IWOVUV5gW97Ir7Op80M4A0P3qGIVhfnyU7lEfPGUuuwy8IWtyUq7Ga4DXbLEqz3W\", \"OCwTtPPTrDZYbBX0NdmwrmhdvrN8G6AogyWBg99gMdd1QqG10YpBckH4bAxvr8MR\", \"Key3tixARBUo5mJgPK29py7oUUE5jqzPt9EstrDTu7kaeDhhGPm33xjpoyPhYRk3\", \"QQVO3GF0EzynNcEe9LGU2TcwlF9hct0Bwm7LlMbQJ3CB2jwBnPNNYIbF17OrDjW3\", \"jndKfXu5jtKLxA4qb6YPLADU6l8JfEIZOL1tJXR9omB8AHmlwg13icOTpJQ9AnEn\"]',x'5232543d463373214a30436461',NULL,704033110),(x'7e6547327a4f39404552764557632a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2033-03-26 00:00:00','[8752698153008498802]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',0.0000000000000000,'kxTL_eQa=fPw=%','[\"A36eSw19uh2hnYyJOGTTzzGx4lp66hJGWZHtFghL3oUGHMo69qIuGaOthZruG9aH\", \"An30jY4u8rOrfaC6jgCrhTIlQGenpDaODtQmpILF9yXcZYfszChs89C3oYw28nXo\", \"uEb9xiOulbF02p8d435sQGk7YYXKJBV0s50f9IYdHJAPEI1v5gWxMS3CFs3EldOB\", \"eqIuKxteMYyrLiH6HEGYoAeoBQVt6Mz0ZZ8ba4qysgZRXgW5GXb2gnnRnqN5xFfV\", \"nE2QTiGnt38I5xH4ZnHGNP5628G963Zf8kwN6D4uxda7MEcqrG29KVE0ud4Ae1wg\"]',x'4069456c316c296d6641383463514e2466','[\"sHvYHMQ8Mwp8hMzq91x5mxgjlpXmfF2geXCYWPayv5USIpPwcZj8U8RcQI8fGSA5\", \"I4IMXoOYYEMEemhBIkHN2liEkqTtMqObInYyRbdWp8OpCdYlv7qZwZihsc3GS59W\"]',-1969564789),(x'6732535770000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','1985-01-25 00:00:00','[20466059053750828, 809257279982052908]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',928.9600000000000000,'nQ','[\"25CPvmZ3Xdn71rJm5xowP6p1QjeDK11A2DZtUzLK7ja2d5T6vJjJTvSwo9Y8M9ST\", \"jm3m76VKq4bDFSbSA3hnEExHNzhd2nZulAQxujbO9qXkufW9dEzaC7R6cDcsMHVb\", \"9PU0409eee7WlWYS47XUTugEoiQptzb26jh5q01iT0XBu1g3YtbhpwGtC9jzbA0F\", \"mrde3RG1gY5wPnZa4yHxOl5rkBmoskhFAG3ilYSKYsUDJ2DLDJz0XV9n2sHsdW2N\"]',x'6e335a322a534076436264','[\"YnYbURpB1OdBgruO9gTbCCNpCy9MtQHKBmRUs814TmO5iNWU6nFUzf5LHADaHT4q\", \"ncwswzXgnTqfl1UBh7yYOZLnnWovtrlgwSOjdpNCEBcsTLI1ETt6GXDmdlTvvqi6\", \"HyVLvryYvuxED2pYiLf9QJBpWmo1QyBbhSmPgCes6KC9MzXQMU10w1qy5cGPCd9z\", \"Vl8oDK0vLdw2kb9E7zp6Eplb7MbdjMFOSajyvAiLLyrJslYNhNT9TtjqOPOSCQM1\"]',0),(x'51506c676b47432554634679796c744100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','2036-01-15 00:00:00','[8624981470875515058, 2417933999360149782]','[\"G0XZTTTqz76DK7sJXL7vpI69KobLAL4w3HJpoJMd2RRbYqf4G5Wg30mWXf2vtwzy\", \"DbI37w1Vp4SCcMifWXedcBd8s1eUXkuhYwFmZOQwnCPZ4QUBuUQ9SM78xiIy1M1U\", \"lqadGREbQINyTSrLP7S0PQ67VVRxCU1r01V6i3BXTH66DuG11SpGrfSXhKVaKj11\"]',17.0000000000000000,'&P+Xy','[\"WFJuRuUyVdMUqGuAhB5LAeiR7tdwkc5zkQG61iT2NMkk78WNThiCBCkVH6jHkEYv\", \"6d9N5UH9sU3qtZtnUaVBcpl7dxAhU1l3vQGiuOipbJFeQJiCPfiHnQltzA6hARUk\", \"OGyPybNJ8vsWyl5FeBjcENU6EaAgEI6Py1f8AGqgi7B19bcVbBqKldRO1xYancJr\", \"PbhvJJ8ZK1BHbnz0Mxi2R2gpasuUj8xKgsTRHtQGmCaDLyiXIat1eruUFUYBLk2v\", \"vWwCx4uBcgk92G8VdlQdXHPa86KPPfz78y8YBVpcHyYtzZOGZrMACjxOOtQj7JIb\"]',x'64324c','[\"t6s87vRoBAD3j9vnZWVOkexWwpf3iMH9w6ImV1BWyQ1kW9Ls3POg5KTxuFI4Hpo1\"]',-600235817);

set @@tidb_enable_global_index=1;
CREATE TABLE `tceb7972c` (
  `col_17` json DEFAULT NULL,
  `col_18` smallint(5) unsigned NOT NULL DEFAULT '13551',
  `col_19` float NOT NULL,
  PRIMARY KEY (`col_18`) /*T![clustered_index] NONCLUSTERED */,
  UNIQUE KEY `idx_9` (`col_19`,(cast(`col_17` as signed array))) /*T![global_index] GLOBAL */,
  UNIQUE KEY `idx_10` ((cast(`col_17` as signed array)),`col_19`) /*T![global_index] GLOBAL */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
PARTITION BY RANGE (`col_18`)
(PARTITION `p0` VALUES LESS THAN (2),
 PARTITION `p1` VALUES LESS THAN (14104),
 PARTITION `p2` VALUES LESS THAN (56927));
INSERT INTO `tceb7972c` VALUES(NULL,32768,3820.5208),('[2978991857918245466, 2358633058135455779]',14958,9050.871),('[3209216649516490663, 8796285761077563704, 8679842102776923655, 7938639730493564777]',50028,5950.6714),('[1835017567976206479, 2]',25510,6779.271),('[7771897049175925887, 1, 5907722896328501457, 2218303279528464844, 4106409123325473016]',56899,9767.853),('[7839602274985524695, 4773627824242235154, 5873227109465605544, 4833046260666832936]',33174,3820.5208);

analyze table tceb7972c;
WITH `cte_11235` (`col_60767`) AS (SELECT /*+ USE_INDEX_MERGE(`tceb7972c` `t61a85298`)*/ `tceb7972c`.`col_17` AS `r0` FROM `t61a85298` JOIN `tceb7972c` ON `tceb7972c`.`col_19`=`t61a85298`.`col_71` WHERE NOT (`t61a85298`.`col_75`<=43.851) AND `t61a85298`.`col_78`<'@tikQ6I^' ORDER BY `r0`) (SELECT 1 FROM `cte_11235` WHERE 16739493649928310215 MEMBER OF (`cte_11235`.`col_60767`) OR NOT (JSON_CONTAINS(`cte_11235`.`col_60767`, '6019730272580550835')));

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

Empty row.

3. What did you see instead (Required)

mysql> WITH `cte_11235` (`col_60767`) AS (SELECT /*+ USE_INDEX_MERGE(`tceb7972c` `t61a85298`)*/ `tceb7972c`.`col_17` AS `r0` FROM `t61a85298` JOIN `tceb7972c` ON `tceb7972c`.`col_19`=`t61a85298`.`col_71` WHERE NOT (`t61a85298`.`col_75`<=43.851) AND `t61a85298`.`col_78`<'@tikQ6I^' ORDER BY `r0`) (SELECT * FROM `cte_11235` WHERE 16739493649928310215 MEMBER OF (`cte_11235`.`col_60767`) OR NOT (JSON_CONTAINS(`cte_11235`.`col_60767`, '6019730272580550835')));
+-----------------------------------------------------------------------------------------+
| col_60767                                                                               |
+-----------------------------------------------------------------------------------------+
| [2978991857918245466, 2358633058135455779]                                              |
| [2978991857918245466, 2358633058135455779]                                              |
| [2978991857918245466, 2358633058135455779]                                              |
| [2978991857918245466, 2358633058135455779]                                              |
| [3209216649516490663, 8796285761077563704, 8679842102776923655, 7938639730493564777]    |
| [3209216649516490663, 8796285761077563704, 8679842102776923655, 7938639730493564777]    |
| [3209216649516490663, 8796285761077563704, 8679842102776923655, 7938639730493564777]    |
| [3209216649516490663, 8796285761077563704, 8679842102776923655, 7938639730493564777]    |
| [1835017567976206479, 2]                                                                |
| [1835017567976206479, 2]                                                                |
| [1835017567976206479, 2]                                                                |
| [1835017567976206479, 2]                                                                |
| [7771897049175925887, 1, 5907722896328501457, 2218303279528464844, 4106409123325473016] |
| [7771897049175925887, 1, 5907722896328501457, 2218303279528464844, 4106409123325473016] |
| [7771897049175925887, 1, 5907722896328501457, 2218303279528464844, 4106409123325473016] |
| [7771897049175925887, 1, 5907722896328501457, 2218303279528464844, 4106409123325473016] |
| [7839602274985524695, 4773627824242235154, 5873227109465605544, 4833046260666832936]    |
| [7839602274985524695, 4773627824242235154, 5873227109465605544, 4833046260666832936]    |
| [7839602274985524695, 4773627824242235154, 5873227109465605544, 4833046260666832936]    |
| [7839602274985524695, 4773627824242235154, 5873227109465605544, 4833046260666832936]    |
+-----------------------------------------------------------------------------------------+
20 rows in set, 2 warnings (0.00 sec)

4. What is your TiDB version? (Required)

3d42e34
@wjhuang2016 wjhuang2016 added type/bug The issue is confirmed as a bug. fuzz/randomtest labels Sep 3, 2024
@wjhuang2016
Copy link
Member Author

EstRows is incorrect.

mysql> desc WITH `cte_11235` (`col_60767`) AS (SELECT /*+ USE_INDEX_MERGE(`tceb7972c` `t61a85298`)*/ `tceb7972c`.`col_17` AS `r0` FROM `t61a85298` JOIN `tceb7972c` ON `tceb7972c`.`col_19`=`t61a85298`.`col_71` WHERE NOT (`t61a85298`.`col_75`<=43.851) AND `t61a85298`.`col_78`<'@tikQ6I^' ORDER BY `r0`) (SELECT * FROM `cte_11235` WHERE 16739493649928310215 MEMBER OF (`cte_11235`.`col_60767`) OR NOT (JSON_CONTAINS(`cte_11235`.`col_60767`, '6019730272580550835')));
+------------------------------+---------+-----------+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id                           | estRows | task      | access object   | operator info                                                                                                                                                                            |
+------------------------------+---------+-----------+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| HashJoin_24                  | NaN     | root      |                 | CARTESIAN inner join                                                                                                                                                                     |
| ├─TableReader_31(Build)      | 7.98    | root      |                 | data:Selection_30                                                                                                                                                                        |
| │ └─Selection_30             | 7.98    | cop[tikv] |                 | gt(test.t61a85298.col_75, 43.851), lt(test.t61a85298.col_78, "@tikQ6I^")                                                                                                                 |
| │   └─TableFullScan_29       | 38.00   | cop[tikv] | table:t61a85298 | keep order:false, stats:partial[col_78:unInitialized]                                                                                                                                    |
| └─TableReader_28(Probe)      | NaN     | root      | partition:all   | data:Selection_27                                                                                                                                                                        |
|   └─Selection_27             | NaN     | cop[tikv] |                 | or(json_memberof(cast(16739493649928310215, json BINARY), test.tceb7972c.col_17), not(istrue_with_null(json_contains(test.tceb7972c.col_17, cast("6019730272580550835", json BINARY))))) |
|     └─TableFullScan_26       | 6.00    | cop[tikv] | table:tceb7972c | keep order:false, stats:partial[col_17:unInitialized]                                                                                                                                    |
+------------------------------+---------+-----------+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7 rows in set, 2 warnings (0.00 sec)

@hawkingrei hawkingrei self-assigned this Sep 3, 2024
@hawkingrei
Copy link
Member

hawkingrei commented Sep 3, 2024 •
edited
Loading

We can simple the SQL like this.

SELECT 1
FROM (
    SELECT /*+ USE_INDEX_MERGE(tceb7972c t61a85298)*/ tceb7972c.col_17 AS col_60767
    FROM t61a85298
    JOIN tceb7972c ON tceb7972c.col_19 = t61a85298.col_71
) AS derived_table
WHERE 16739493649928310215 MEMBER OF (derived_table.col_60767) 
   OR NOT (JSON_CONTAINS(derived_table.col_60767, '6019730272580550835'));

@jebter jebter added sig/planner SIG: Planner severity/major impact/inconsistency incorrect/inconsistency/inconsistent labels Sep 4, 2024
@hawkingrei hawkingrei mentioned this issue Sep 4, 2024
Merged
13 tasks
@ti-chi-bot ti-chi-bot bot closed this as completed in dd18083 Sep 6, 2024
This was referenced Sep 6, 2024
Closed
Merged
ti-chi-bot bot pushed a commit that referenced this issue Sep 9, 2024
@ti-chi-bot
planner: fix incorrect estRows with global index and json column (#55842
a6789fd 
) (#55924)

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

@hawkingrei hawkingrei

Labels
affects-7.1 affects-7.5 affects-8.1 fuzz/randomtest impact/inconsistency incorrect/inconsistency/inconsistent 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 incorrect estRows with global index and json column hawkingrei/tidb
3 participants
@hawkingrei @jebter @wjhuang2016