search

pingcap / tidb

TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://www.pingcap.com/tidb-serverless/
https://pingcap.com
Apache License 2.0
37.12k stars 5.83k forks source link

update gets an unexpected error 'Unsupported expression type MysqlBit' #51110

Open wjhuang2016 opened 8 months ago

wjhuang2016 commented 8 months ago

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE `tl03d45331` (
  `col_78` binary(99) DEFAULT 'q!ZRSxS%8ZJ%\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `col_79` json DEFAULT NULL,
  `col_80` json NOT NULL,
  `col_81` time NOT NULL DEFAULT '05:03:54',
  `col_82` decimal(13,7) DEFAULT '5800.7',
  `col_83` decimal(39,26) NOT NULL DEFAULT '429.1395',
  KEY `idx_25` (`col_78`(4),(cast(`col_79` as binary(64) array)),`col_83`),
  PRIMARY KEY (`col_81`,`col_83`) /*T![clustered_index] CLUSTERED */,
  UNIQUE KEY `idx_27` (`col_82`,(cast(`col_79` as binary(64) array)),`col_78`(3)),
  UNIQUE KEY `idx_28` (`col_78`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `tl03d45331` VALUES (x'402b4b4d426c592100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"ULBkVF6h1NkQ9hPNsJXnZDP1EOHFcHpFl65OrS3RXSSbYjAdLSumc0k7T9b1nYlz\", \"rY3Bi7RKGFRUsRFxZmVWRmBQFWDJKEQPENczW6O9JQIq4HMDVYL9uFycJXCgwlyC\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','01:08:20',43509.0000000,46323.00000000000000000000000000), (x'5a6500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"8PQHqBryI6cpYySVKdzErMx3lkVQC3vahpt0fH1Qycmcg1ZvAnllvSIbiwe4jlPE\"]','[-1]','01:33:32',0.0607000,57.00000000000000000000000000), (x'696364686523554878723930486f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"0Y5bTGOyo4scONj1EclfkubVZaOXEhoo84VUuHRJhziY7gmxmWfu5XEJ0zDYyrl4\", \"Fi90QmeN8kskoQK9Tm3ir1FPRL9AtxloGRIGSqGKys9XoY5uwxOubjI2Kdmdyr4d\", \"plpYV8wiaFZdaoLvPiQP3wunyRxDXoLWT0zn6QPDksBzkDcKOdTlesi1CafzcM3A\", \"bZIocJsuEaIYQuZpAE1VVtjBCbJ0HEzL5NQkwVbb8PzU59PljuocDbX5DOLDJ60J\", \"IRS0ZIEulRDCQRD03LW3GQZbaXG6BuSyyRHulLmIq7kFGtTJJk4V5x6imjYsbYMa\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','02:11:31',9441.9000000,480006.00000000000000000000000000), (x'663344000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"YJKlDAQdbugfohmvIbFeUYVAd0dooAoWlGSK7uP5GVREW7HEHPNVuYOmrM2fafrS\", \"IlZtYHDANBPCvfzDzBlo3u0MvrQ4JMgTZYBQ2HtuUGk4umDkUUaqUSPeJNNKNFK3\", \"E9PWCDrRvfo9ZD8Bcrjq876WkzU0zBNnCWCBLGu1yvy4hzGYR0W5gIK5HG4seg64\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','02:47:41',57.1400000,1.21440000000000000000000000), (x'2441287544596e36584d384d6e6d466c6f40000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"LZTkMCWniFeQvS7sHAFbx5aysTjZNeA8KYK1sS60286XCYdXVqsHLuD88sxlLWln\", \"DjnhswTj0vELoigJ244znsX4XthQU3yo8ERJXIWO6usAKYWUeBz4D0LZj3D3RfpX\", \"hZxAjrkOfk4aOjyROPZv6ZnhfP71HZTF3y2w1Oo3abfP1MVgvRYmLKwv7OfPcbeM\", \"wc27WzHWUqS3eWAQ7e6uDz6aHfHaY9rENeVUljW00xu2PB68bvfkG8J0djjwqIGn\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','03:08:32',8.7500000,4.00000000000000000000000000), (x'5273257159464969654d3936724d4b6e6a65000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"Lf1k11p0wZMxDinLQ2RkRhWLBEbEIanrYo0rlW9KdEIZNTGvxvXeYtQ5XDiR0XCf\", \"5ygbiE9ubWdn2oKm29pB37dOW07SVSbgYzXBFCwYsQanMzMB8MmVKZb3Di6qUyif\", \"Qe6fG1jh0gKRrDhQ82m367QYlFF3Nugg8Km3f21f4am4Z7eRXbiI6BDq0fxn2TGc\", \"WJ4jrSd9rgEJulst6LqmKdSz5WO5re6iooGVh658ameLb6fh7UR1mhwFiCn6f6bV\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','03:16:57',0.6294000,202504.96000000000000000000000000), (x'70654553583068437e334170316600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"jyMaBIVkIyBvgeoRugGve4nUiypoASICwGSRWCSChxtMhs0SCvvdhk5wtHLsRluT\", \"EXLhZWl2emDg4QPA5PiYp146T3BJyomWjo1JzJl1knlw0NBhHyZABchBjkibO7nq\", \"OvMaHKb3skX7YgO4XuMx1WJxSiF9c5wBz1xTcoclsbuDUaE2WegQFlx6YgWlGzW2\"]','[5597697846472424169]','03:19:54',8351.5859000,7.60870000000000000000000000), (x'3164376d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"0bL9fRidxFy9tz9YxS3Wnz7yQfWwsZV3D7nWCK7Z4TkiFHMaUMGye88VYP6YSk6u\", \"AZI1gDg9OAnza6enPt5ByeTXHkw2HoXS6F8Sj4PeH9bSiYZAPeN2m0ywQFBGG4FV\", \"ompXh17I19ZtJ1Hiilo8xkBLvbB0fkzXlDOwhJ8NHA2JyTiiuzf1qvS5Iux3XM26\", \"B2rswvo485v1BHMbfdYtzRyNNzymcx2LGKyxPZOUKY2bQuPJDBXLlK1MjClqBJfE\"]','[243761959681837133, -9223372036854775807, 5882634637536610457, 7779325492009429395, 737291628679551325]','05:07:02',0.2000000,0.25330000000000000000000000), (x'666d41720000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"nZ05MpjM3eBZFUnPYL37hua2XVzV7Sw2QQlat9oF6gchhx1aPrcUUcO0Bjc3boGS\", \"31nWnPHR2hdyWzLiz7sStbkwOoS8Rs3CqQbQci91PmazkTFuqOHliW6gna1vkosx\", \"wArBo9GtXXFlrJURACRmdvj5U1wHsqx35QTK52YyOKWmUgQs1woN0DLlACtxs869\", \"yz01vQzO3TizaArrpVMuH2iILuNl78VoN6tf7OBiWPeadhCFSLqdM2E3ADtVKiTB\", \"LmXV1FRGQG37FtrYOBCIjMGvKsQ9PnZoGOcChMt8hFPH2P8xFsTt8dmwuvImUoiB\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','05:07:06',4009.0000000,663143.00000000000000000000000000), (x'4b436a547656447970280000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"DqWVs51c7yR1r34N7qF6XZlgQzd4R6z2u7gc5cWrHaLrZ0InSUX5hP1GfPVuQJQz\", \"Ajb6MCdESuWOIOzjkwhLaoleFn4pkbW0hiivNWBzKhF1VVjbPXd73oo2kjRV8OqC\", \"XZ8jaIGWJa4KjtAsMbicW8GORBjFDZTp1IXRAD1xpQzD5azNeyhwphiGbz1uyIQs\"]','[7216284881446894887, 8999125470366471475]','05:08:48',755053.3000000,3265.00330000000000000000000000), (x'295764344871250000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"LjglzEU0kXGaXYpAQ7GFgqhVjg6FmSGoFaL4pgKW3NEC8xpDwya9ORUpz2VZyZPB\", \"F0zdxodj7MQb7F5AO8k10M7bDvSN7EZwuW4J2v7KRKa3Jm2d5ar1o76rz5FLOMpv\", \"B1OemlIFZRgY1x6nDXsVNAThOvAPcqMujs7c2UvE35kpxkk8YgVgESyDWoXDXHNF\", \"XGqvrRfs6kg31Z6kkvhqFSFSxNLyeG0LQ9bMq9LLLk9H4yAmKUx6owe5Y2YFu7bt\", \"gaIPsYIVYZD7X2846gYO8c03nVoZBFTEgCzSWxMsK8CUawBBOo1YHtcQxgCzUmTC\"]','[7216284881446894887, 8999125470366471475]','05:13:20',552473.8600000,3265.00330000000000000000000000), (x'21713d395921364e29597045303062000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"evDSD7dkJM7IdnGIYqH9zL2BEFl9SYFaDNZ1ZnH0TdMt8aH4k3mAxWFhDOedoOYS\", \"yC1Z8ldetXc9cyvmxXZe5E5Evlol6GX2vJZmGP8XxSwagkMdeFzPJObHep97rcnX\", \"qrFxrVLDv2PmGWQHQaanPFiwBJYODd1jBfiJGNTtWw3gvpRbJKlmfsNMpDAvP4ZP\", \"ufSy9MhFlb1XZrhPMp5BFBf4Eo6RMs51LufF3cfnCofCySbiu7UlgYL9qRHY1QPT\", \"9jO81cUoaR7v9Q3P0lBkz9NRojvCwO8OyuoV3hmqA3vjZBAUOxkRXLAhC89CbRhU\"]','[5521255350376635908, -9223372036854775808, 5036805497727022283, 3871748834820563775]','05:16:25',0.0000000,0.29900000000000000000000000), (x'705353230000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"eU6VDUcuRd8ZOxTwZ1Jxkkqz8YOm7YBoApJTIz86EvrqWBwcfOPTVoGVuDL9AeFz\", \"3EisKjcivBPwdHVhEdFypZrtaDIUfQ1BHVkWYUqa0WPsiDEzIb11sc51PEBeMn39\"]','[4838669407774589839, 8659499945201548865, 2, 2891941175022128880, 902472161874800730]','05:18:32',31998.5132000,73.38000000000000000000000000), (x'4538374f6868403654662352300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"TGpZv0pfxMCLS8Z8mcMFPJejdnzIWLfCwX5BC7TSofPcNbwBIf5JvKRnLlQ3K2qF\", \"SOS9p9Vehdr6cd0zD9GHY7SCmYtyG3P7rU1QUuxrEhbMWJZNFhxYURamkm7E9Xw8\", \"ASKkD0sReZw0EP5OSQGla89LejnDcrcCvoGR62CWESejLTKPIexo7dfk7WXRLC3X\", \"9inapm7NaT0JqmI8FcuExyDVrTokYiuw1ZUgtr8bRRLJ006xuyyO5VfyMt4xmMTU\", \"5rNIrLD8yztTPOsDtMnITqz7Q0vh9wqGPeU4AKdZvH1VUvi7IQFRt7TO6bdjDoHS\"]','[1, 9174467666217846695, 1700298982654282961]','05:29:28',3.2900000,8836.10750000000000000000000000), (x'346c5e437a76574a4e520000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"AH3cYVMBnoMgiZ0Y7149nXoGaVWTApI8OCTHhnBg0UtEuLrSuuxRUg2V5nKNzhZf\", \"NxOtxKWGUtrmDipiCOMbO2bvofOUWVnZAhuiOtCm2wmJVw9YuXWHUJsdrFkca2I2\", \"mEmhT6bDFHVyF4Mjsl6c3AsnhvacxDxGmPxrYLobcqJFdNz8T3BuAY4uNZ4wa9za\"]','[4599589272809564677, 2214405712712444873, 6141266385258171443]','05:45:29',410231.9100000,57.37290000000000000000000000), (x'3d316c574d42684775440000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"cf4VIXBNC0qqi4ezZSRVGHQKZ9JiiiqwVwbSmjBb1klzs3puWNIiSNPVMB4WLbJG\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','06:36:42',97970.0000000,0.45030000000000000000000000), (x'250000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"9aa2TzGYncVJJ4ALxhbQRWb62ECttuMzg3XCbilyruIxz9dTvLpgQ5mHttft7buV\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','06:54:03',0.1000000,2.00000000000000000000000000), (x'4b5626496c5a31485830746f484643554d41520000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"lzM1yTMMVNunujKJy9vRDiINsdjwj5vOqGrlQAbABtplxvl1wDq66AT32KU2QU1Z\", \"V5dFJUs6U1Or4Un2212EXwhcQV3IwpFjXl1LmJwaGnZhx51FQwGunBBWNV3MeTTX\"]','[1, 9197696108225162657]','08:01:19',4.6000000,691.80000000000000000000000000), (x'4a5a5e28643078675738406a5a5e42395500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"avggMvqluBSchlDzqJaFiNdqsOBnLnR4LaSX2P7zl6D1ZMXfF3RbvnZamIry9Fdy\", \"TXVe8asnw8OmJberSQmjrO2SMTIDItEQnwqOZgAaIwaDQWWP5ziowoPJDEpZYgL4\", \"coZK9XBWR3qE6ocqF28UgexUGRYNhWyPtzkZ6KiHSgqO0MbCvnSdf0CDqlfnHgva\"]','[4968553539194802379, 1546856369859242728, 4307318416105096837, 4024197478071471345]','08:17:14',658.6000000,193.43000000000000000000000000), (x'6e5a7456644734256f652570392167317800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"Ix1y5kb1F5XAAjbG7ly9FSjqiiCZDrBRcSlrwAfmTCZovRNMaTdW3iturHtsJefw\", \"pRzt9e0kwILMUmNPQyxwhyNmBwwVeOcYsyAIFWjmGElM1gqAWj7HnqfvRZy8bsNx\", \"VMVUzHEavs7SgLw325M1wVFuudb58NBzLUx6ZuMJcfGZx4GFEd83vTxQSbnO3NaY\", \"He6Fqg2O9B1PKxGmWpJYPa8NJ9fL7x8H9wTcVeK8Rmy81jHxLpMY7YI6t2Tt2hTr\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','08:24:09',45950.1220000,731730.99900000000000000000000000), (x'2470775428367942474d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"arOtGDesOdO77ea8g0edXMKkRL1C73x0rNivPrv0JEKL9TnCDWeHH4WlwWKzmUT8\", \"tLLAK6JTJR9cDH3QWX8WsfjuIz55WxvvRA37Rhq8N5mvZmkSJr2Awx0H1PwFmKlW\", \"aQadZkRoUh8LmkXsbozQrARDgNfQBkhu9f9iYJJfEZv1emhxtqLpkLF1resDBc3q\", \"fEnL4dwLLc4ThzE2MvbRDEzl0944S1PGu5WGObIClw2WEDjDdYmg37dr6BGlxCxE\", \"rv11Mmj84wiDT0fYT7YwoEUYpnvAYHiFKkGWNQfNbOJMihj9CXNienET83HzExGL\"]','[3647344625978033973, 5845152683285836838, 2]','08:59:30',61717.4300000,7.81300000000000000000000000), (x'40266a6744544e3859243d42280000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"0PcJTxXIUcvrb11FOJzvKFG29TDpEQbAqkhQflcZVeC0yTZ7UMmTjZk7Gw5S4lko\", \"Fy3goWC4Qpw9rlgmkiCEk21J6td4Q8kYgF5CCvTOSEd2lEysGwqyHFptm8sWwD55\", \"nw2bhfcs9Iu6bEipyzDqDcGs7zB21CrHWXAdiU3za0DlEO883P9s4DYQq0kShrdN\", \"W4Vqbjl9NhIATvnOtu5DhnhKKlRAu7kQei3bZIHgAqmBaLCQapyct6jyjCciCjbw\", \"wek9xmBTPgDtISniVQ76A0h0UUFrNCqBzYlVpiOwNpfrGDOaBb9tyJiQKd4yiwb5\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','09:06:57',3381.8310000,144.55000000000000000000000000), (x'32667955727e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"fPJmFWDtUDoevbB8AUqgbv3IfFWzVFU0GxKdJlEB6JBorWki1H434So59nJA3WxB\", \"iPJ0UAk8r0OjXUFj1v2CwIxjBlwJ027mzhwTliT3yw0tS9wyemZIVbKrLJueHNCR\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','09:07:56',889.0000000,43.55410000000000000000000000), (x'286953284834484840727863507678000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"Kg1sb9PFeBSpGFW8wT3qChkVlzs8vSuHJTAmPezz1aouHfSky964gclinzTAjfgX\", \"2IcYR8UG1qN1npC9pWnIEBpHw8DsGHEhieIrcWoEFv33uMqOQKsarL1QNbTqTg1o\", \"QGa9J61pzXQmw4qx8sk2iqleQXi8I9SVlWHXJVIlyZOcVQnFDQb42sGWB0XkzVjs\", \"9yUxUFq4TSJRxsWM53skeKom3uSVfNrrbtaUnbF48DE3GVm5qB6IsP8ecYoYyNZq\", \"9UGgv2ph1PBOCPdPAfO7P9B50HcNnv9EhIH5opyU62bfoi8QEv0oM33LcxUnxqHk\"]','[7473578819146234089, 6139427954264533504, 8250833070410818538]','09:33:44',81011.0920000,69147.60000000000000000000000000), (x'3161216d617a740000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"Nogxya2YOoKbnv4tR6mul6Nffx7W7Q4NzoJjhgKdfYwF51f7CFp7Apzqjk0rcHZe\", \"77HOPjqMYYNcH7s4Wek8OnhqzMhnjNFPCTMCj871wFFNlM2ekiwwCxzFTyOlcATH\", \"sFs0KUcQoERrHfBPOKx1YZkMXZcdQR3aWJ7fgyvWiOzfWF3cAf7lyntQKtccvvI5\"]','[7216284881446894887, 8999125470366471475]','11:06:22',861074.1200000,3265.00330000000000000000000000), (x'59626e693300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"MZY6uNxKgA5trARrsmlScURjOsQ1oZDieLaBF831b6frfFWezn3GEEgRdvtLmjKu\", \"vL5bScU48x7dWOwpHBVeAHxvp3JppLAWF2lUBQjQ9LK91lVk2yEGw6ksT8hUBqBP\", \"PNQMktj3blYacH9ryEhNEWDvSXJnDpvvbh6LsCUdR71pV83hvOuWP31pPZWpdlIj\", \"oQAYQUu06vkyXJmpUg80f0gk0xoXlIO8dHEE3IDnBQDwqV28Kdfyfadyn1dcbnbg\", \"oC8vF1Pm08VwBQLfVlPTzkcM9EuFskHfnpEl6AnnKUKLHMGn8HTgZDkS7Jpgc2gH\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','11:09:39',6387.0000000,980.90000000000000000000000000), (x'4a5e6a712524694448262d41387600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"5SaBhTyTXL2xaUgYKnnoIw64ZMZJOpXVcPUKFsjjFvLZKgAAQhEf1PKZIbMrHsil\", \"lt2rtKIJQfCDtdMAwPL2b8Z3T7NsJIvM3kF54N3Zk2NhHla4WcJjPr3VCkfy5Npj\", \"AIbwTTt74efFgZWCKeVFHtJH7kyBiE3ETDVI8lamjjPhpT6WrtR30zwCYuZFcZi6\", \"ibuCR68G0roW3LBsE4SD2PpObP2mjiSWaZIHLMPJmWnmu3O9YAabx84iCEXzdPVJ\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','12:41:39',2.9642000,4.94000000000000000000000000), (x'47766f31514b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"3HYGfIzxgh7IvrHAjwH4UqoUd5SK11jRtdzUWzU03DjknuDkS8BN7RczKHCUJEXJ\", \"HYyE4hr2ISi26LTkXhAUe5ekVTXdfnDI8ubOxpDhs2Fs6Ug8531edas2pb92NPeC\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','12:53:29',1.2100000,0.50000000000000000000000000), (x'735142547e4f665550466b525f352d670000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"JYgF3SCU5uRH9b9RMkoR73pM8POQ6oFM0hO24kU7VPL0va7nFq3iNtkxDxqNZvgV\"]','[4446829800604398230]','13:08:19',NULL,5.51000000000000000000000000), (x'423d665e212942306a236e73000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"neeUdcLXD4NFQbk0rzyVHP4najWzQkulPCBvZHAlD65x3FvssrgYqHf1hyNRVbiw\", \"QFJiusiTAfH88v2tjtnwHvXAGTAFcUhCVQukWF1wA2Gnt11E7oKCDHWLxcl8ejN1\", \"wxyAdjLF283PVD1b1g4ZdwmwxpdlZEWNsWslAeM9uK4krLItyQELJmauVNxvQ9iN\", \"MMYWvOXXBU8RouWi8uXCiAia6vXUsA8SbJxrfZbizQ9X6f0VjJ1yvP2zthklW0gG\", \"u71iiDTqKvtp7Q9p73ppOeTJy3AQQrP8aGFQ7TOJFicjUIDJDdP1zuPTCdCbypsT\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','13:44:41',NULL,6.54000000000000000000000000), (x'33704e4a6638216565465a36394863000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"rISzXmvFRvQ4roniza6Fod67Mg7xCiI0BuZNaPMfo83qPfA5BaG3lLPvza5YECqs\", \"yAGNq8mkbxsKdYabyubnyJUCViTVQEGRdW7QH4TtVaWqZ1Kez0Dx9FoyTgMbCjDU\", \"zLEEVh14ZNQQvTxYDciQVamRXSLsL7zlHmlcQhWEMI9P2LEppGG4XtFUlCiHEwEe\"]','[385747097861292463, 5184284095428640554, 8033425418213053746]','14:27:08',567.8690000,0.18310000000000000000000000), (x'58664c513100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"boImy2mm3vDpDD2hrTxA3QGxwSUGqSoed9wo3qXr53CXq50DxJGt16eXtE92D53H\"]','[2035289843645236591, 3323120620007518026, 3732211852853888761, 211314838517182162]','14:31:24',84.4000000,157865.13000000000000000000000000), (x'487a2344474f4f4d26410000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"Gvgqx51Py0qQnkAcf1Idqf2AVxUa9OGqwYxSI3KFmL3Mtiog2iVrUxgiahMkOqih\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','14:56:10',22.6200000,33.10000000000000000000000000), (x'51593962342171356a24414d667000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"ZUh4zDQA0fpMEDu0IR7hZRo5rSmnPkfrkz94mi2ecnVpnCDOqDMHBwlsEjGggLUA\", \"24VXZ2vl3WalzaPecv2nxdblYyWHNwKqDdBNlanw4WljkMnDzxk4xb0fPfvf9AE8\", \"mihWFn47NgnMkhTgyeLfC9JlA6jDUxFk8OZRHsaW96Bo1wP5c8KQmNLAqEuQYaAU\", \"iEDDj5kVdGKmDycj4Dy0m5vY9IDvbWrOH2D5rhYU0v6iIC3pmfmj3pfy2KmrTd9r\", \"LuyFYlqkyRLIlEebe7WBvHFnNPMNO9zuuhVBcci0tif0K75LD6mY906tWIwtFqwP\"]','[3217285921278628749, 3187779956725947694, 7740269725224318324, 2758461912585879117]','15:01:15',8.6740000,17.30000000000000000000000000), (x'7829486c6a7a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"qYAIZgOFgTGhHvNl0BwceyEnKKUSUooTPQu5jSvv81RQcyAYHoOrW9HtGkLcIAMW\", \"q7LOkitqUVKtJhzad3ckVxP3ZMhhtSJc3CRzJRQdxgHJS0xGkSPDrnV0xOJm5L8B\", \"fzrFZyJm8zG1t1jNVLqBmzxuL4HYXZK0Sf1qgZVd5ZscuMoG9TQbbpg962cP3TcM\", \"5RwErHqXoKLkXfi8SPmi1BR8R8tJ8bAvw8ZoBwdIs8RK79RKVnDh59G1uArZNlEf\"]','[5067280390132905286, 4289613602334864080, 7970597650756563241, 3634922341369442699, 874193698979944193]','15:38:25',0.7137000,832813.00000000000000000000000000), (x'694e6d57537453667e584200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"mbIft9ajPIEmImWTMxLWjtvcB7kldH0efqxePyxPYrevRY4JXCHT1OvXI34pQaiV\", \"ZROKCNP6pWjtPme8K05b2qekIoLlIfpITIQFE4UAMzRI3illCRZgZD2H6ZX0xg6s\", \"OWRpxsF5kfAIOKKFfXDZnmpDIWpGanBaNFy9WdI466u19AS4cal7yYFrZ8bHKFON\", \"giBi7RqvuK4SpsImxUtaVAn6UIeV0qQUUJyfYRotFF8vzKS8yC8AkLlK3428AuOt\"]','[3054774105952752371, 8518528075455269191]','15:59:17',0.5212000,8.00000000000000000000000000), (x'247941542b214439414b4e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"Ahuc8j6jANueUMD0GGAsAmerkuA14WhMI05M3p3Q1u1V0cmXrIW3UUjlejimuoSw\", \"fAFEmNBRRovA3WgcUWynxUhh0EFaRdbZsp2cTyFUX1Zs5ZrByAXUIwG2jFeCNXP3\", \"tnCpJb9hiEnjpl4n9VgIOutzHojUKOO2pmRnRapFFY9lHREQSWMjD2JSjPTovUva\", \"ynijp9V078rN0nJxSrGg3G79T3vIsRVTU7EwtAMV5h2cMOIUQlJczlG7O5s87Vrh\", \"Ps4OyClbhKbSNpzyhyPNh7QFVlB5p6kOzY7R0127zTNtlHWC6A26RBvrXHybTLTt\"]','[9223372036854775807, 8079390175419369885, 4423895769975039112]','16:14:57',3036.9950000,385.00000000000000000000000000), (x'567328440000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"8k5lj66ZWZ1eNMIWUy3WkeXQ6N2GcI4win8sJ4zI6Bu4NvNOB0x8mOO1k5mM9CLL\", \"x3eBY1MJkIASA28GMglCGKMamI1Yeg8f5HMphpmgo6nZOeFxDufhNH3fo2zkZhBU\", \"kBvugDw4SP5XVcCqZwhZthGp6yNYrF2ghewD3JJGHTLtF3fUp4A9wXEJwjF03cHZ\", \"PDJc6kzwLAo0pTZshji221VtrPeb52x00vswyLPDnAFepz4zXyJkQUk5RVLc61zR\", \"gdxQ8XWCb9SRQclZZfDmnxga7pejqDrcvhI5unHgGhsquF3XrW4V5IoWnYKqR04e\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','16:52:31',8.0000000,0.30000000000000000000000000), (x'780000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"uJJ8FolGLa4Ha4AuSjkIrTMNJYzWfv6maI9hZVCWO1Rzl7hYmt3l2xHpuDReS3sj\", \"hOLrkYZnL1K3vHri2cdu48uGJ8FaNhUEjZ4duJlYG8kemp9EflUZv9MoIxuSpdSj\", \"NXt0O6XIYpiosdiymQV9wO4R6jTAmuVvKgH7Kr20lAa9kTcK6QvdUmhC79WlY2iO\", \"4hNXTwTPXDMCq6qIxL8zR3qxaVGB5P2HTpc3wMBIWnNup24Xac40oo2lxb4oNTHc\"]','[899584129262392361]','18:16:02',73504.0461000,35.30000000000000000000000000), (x'764c415651625e5469314d43234f4224363d480000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"fOPbFv5II9h51v73BLoKZ4wDK9M4PdspcSypyxF7BkW3K4nvn0MzDTsIv7Tkq8en\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','18:34:40',0.5900000,312.06500000000000000000000000), (x'54785e6f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"plr3NWdbKu24FW6SLeFIZ96TA7AeebPiwMpwyRD4pOhHOdX5bU0A6i6IEXXQyy06\", \"ku0McS85aOGFpxafO7RhEkX5rHSYoX8V1R0tEKwUQ2O5sKnZkM2m5SkjdjbNpIK7\", \"5AFpnPpk3zzpV50MfwW0LmZZdDgPKI8DnqgDoae4SMrbbEojBsM7VzS9klgwcEoJ\", \"exGMCT6AmvzCx5i18xFR8DpRnjfETNSg2F2ktmvbDpSZDaStXoXzqTNVv2UBIgLu\", \"CyeCgMPCvqh2WXUcUcllIvPyTOnrbED66BhBIsagQ8H8xyY69vs3J8LeZZYceZc9\"]','[7216284881446894887, 8999125470366471475]','18:51:29',602340.9000000,3265.00330000000000000000000000), (x'2d726e294e72000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"O5TgpSneSz8S0xToj2xUTOawwxeXZiXPKmMa7XOkZiYJUbPJQjmDJcKtIeLsCqKL\", \"nx4iHyaRN5lrsRanq1r7ciwRChQzhzsrUf6Y8jEFTjDs7rGF24aZ8SkeIHrQUM0D\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','19:53:41',92172.6000000,18415.75000000000000000000000000), (x'4243705f4a7435305278435f75476b445174000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"FopWr58sIO0FbwZncac1jSB7M7lWFqBfdZZDxh4znl4Tz5lnxiunu7xiczDpsgCG\", \"ZhMG9WejvFViai0AG18iowdapGACMsSbtkigOAh6U8LE2MKEQX6XDRiKJLxaDCEK\", \"vKQsgvc0lfJRgbBUIaJRXzeU9pn8XjoqMwnQvnW3jlSqTbe0DDgOis6JY3LHaLYT\", \"iflaiEfuOsTuT22GKM41jODxGt28z8HMMixtEe94s39r1ZvusWRAwHqmrSmZKkQm\"]','[4917722292555559798, 195247832088578930]','20:15:15',965586.7000000,754002.91740000000000000000000000), (x'395e7e6229433064653d3231770000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"Hb1bh8fiXHeF7BcXudM6j2rj2IC74x06JTQCrbcj5VOShVgL2jYLs1eMbBbvEbd5\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','20:52:01',99432.3798000,660.00000000000000000000000000), (x'24446f452b76000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"uSY7t61C2v3goPmmdjT2YpfsPDEmm5Gxb4WwP1pdVvttcSCUeOBdsA6bLkI9E99F\", \"04Zb2dcyRkO4OctMx545cruK2G3p4mgZXVH4XSS1QllVXEPUKaXS3t9IneGi8J3K\", \"0jzOoNzWBH23BT1ZZnWdei925sH241CqGx0UjVwgq809yGaeWGjrGlbyennksF4J\", \"1xMftykR318BTEm2eHFwBLfTQqXQdsVmrlmmUrPUbxzOnizPTFBRBPSwf73lhv5Y\", \"B10eqpNG3lB4dWjf0aVjxUD5KZJDgulsnKpr3sfMcQaFBKjc640HwvHMUCV3qMQq\"]','[2914527110809693159, 5266280295700789199, 5498425371034880691]','22:20:25',67.6200000,6.00000000000000000000000000), (x'4a6700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"vipqi5gjAD9I8fhJxMz040Pky3CHgDZIq61FaMuOet9u5hSfNXrCP17FJRNxRhzj\", \"Baa5GVxYTFxNPJqsPX93rauzaClAC5L1wKVwhU9ZCYMzRdq3qb0LZTVRCGiLKOrE\", \"nlCwUuqUdgr5kSFm7zesQeZPoAdkZP3EJlwAms0AdUSeJWlOzd2o6tdmVYB8LUTc\"]','[6187388979490246237, 2116524619549367067, 4259668624579501328, 7474810889795008076, 7611341877013021521]','22:26:01',6.1430000,711.00000000000000000000000000), (x'37624b51634a33706b7e6f43536c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','[\"4iIqaKF1e5fRI2LHXbIsmuoKHJLhWAa7SKHh4gcFX0ZgllX5E4rwBzk83ntzoPC3\", \"8qXzveYlU2swiPATJJi3IDbdO5Mgj1DxWLMR1kjxGHLdFZX2wXfKLwB2hKTpzJ3z\", \"6qKh9wNhqqyie6NDvjpuLDgp1uygryy3tmDWseTLu2KwD3rynBqojX4SROJnsuSV\", \"GiUFKoDavMf5KJrglbyocT0GKjJ4lzRcp9GKyz3PxxaKGt0t9cUQ0x4eoiNNzfCt\", \"zTrpJf85PXkRSgh4Ao3ZPGHWdHuPsiaWOfejSefGO5i7DGGiYhZektfwjBwjqzHY\"]','[2183223470863315886, 2041556036099440625, 4499526998207770290]','23:53:53',89.4480000,874.50000000000000000000000000);

CREATE TABLE `tf14418cf` (
  `col_22` blob DEFAULT NULL,
  `col_23` smallint(6) NOT NULL DEFAULT '28009',
  `col_24` datetime NOT NULL DEFAULT '2013-04-29 00:00:00',
  `col_25` bit(36) NOT NULL,
  `col_26` char(117) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'bV0&qKaRWZ#xVkwu!d',
  `col_27` int(10) unsigned NOT NULL,
  `col_28` time DEFAULT NULL,
  `col_29` decimal(12,3) NOT NULL DEFAULT '102.37',
  `col_30` date NOT NULL,
  `col_31` varbinary(266) DEFAULT NULL,
  KEY `idx_10` (`col_31`(4))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `tf14418cf` VALUES (x'49795234255873684c41436f72536b696665',18733,'2020-11-16 00:00:00',x'041af1e7be','ZB^~TgKkR7GX_+Y',784381351,'18:31:27',4.260,'2029-06-24',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2000-03-19 00:00:00',x'04d19e9a0e','ZB^~TgKkR7GX_+Y',784381351,'11:15:21',4.260,'1970-06-30',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2024-01-07 00:00:00',x'0f0a9e0496','ZB^~TgKkR7GX_+Y',784381351,'10:33:28',4.260,'1979-03-01',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2018-05-03 00:00:00',x'0c9470c590','ZB^~TgKkR7GX_+Y',784381351,'07:16:49',4.260,'2005-01-14',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2023-03-23 00:00:00',x'079c5ae96a','ZB^~TgKkR7GX_+Y',784381351,'19:37:35',4.260,'2035-04-18',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'1994-08-28 00:00:00',x'0e236311d3','ZB^~TgKkR7GX_+Y',784381351,'00:48:14',4.260,'2011-08-01',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2001-11-05 00:00:00',x'0a756b71fa','ZB^~TgKkR7GX_+Y',784381351,'01:06:42',4.260,'1994-09-25',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2014-05-15 00:00:00',x'017b4bbe1d','ZB^~TgKkR7GX_+Y',784381351,'14:36:51',4.260,'2029-02-26',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2032-04-30 00:00:00',x'016fc32a37','ZB^~TgKkR7GX_+Y',784381351,'21:03:04',4.260,'2016-12-04',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2030-12-13 00:00:00',x'0316115b84','ZB^~TgKkR7GX_+Y',784381351,'23:30:11',4.260,'2028-11-23',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'1994-04-21 00:00:00',x'0000000000','ZB^~TgKkR7GX_+Y',784381351,'18:32:58',4.260,'1988-02-14',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2011-01-30 00:00:00',x'0000000000','ZB^~TgKkR7GX_+Y',784381351,'23:52:22',4.260,'1977-03-18',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2010-09-27 00:00:00',x'0410353c0e','ZB^~TgKkR7GX_+Y',784381351,'19:21:27',4.260,'2029-02-19',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2008-05-16 00:00:00',x'0060925a79','ZB^~TgKkR7GX_+Y',784381351,'20:51:33',4.260,'1997-03-07',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'1988-11-08 00:00:00',x'028b0a8d99','ZB^~TgKkR7GX_+Y',784381351,'10:08:06',4.260,'1975-07-02',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2024-04-15 00:00:00',x'0000000000','ZB^~TgKkR7GX_+Y',784381351,'07:49:20',4.260,'1990-03-18',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2014-10-13 00:00:00',x'063c5a9e53','ZB^~TgKkR7GX_+Y',784381351,'14:16:03',4.260,'2007-05-05',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2033-04-11 00:00:00',x'0c7655ba1c','ZB^~TgKkR7GX_+Y',784381351,'09:26:46',4.260,'1981-08-11',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2026-05-25 00:00:00',x'0ed35a4d9a','ZB^~TgKkR7GX_+Y',784381351,'14:35:07',4.260,'2030-02-13',x'5169'), (NULL,18733,'1988-10-27 00:00:00',x'02fcf2ae89','I$jq4qDL9zr#TZuXud',784381351,'02:22:59',4.260,'1995-06-10',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2000-09-14 00:00:00',x'0000000000','ZB^~TgKkR7GX_+Y',784381351,'20:04:38',4.260,'1984-03-25',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2006-04-28 00:00:00',x'06776bf0e6','ZB^~TgKkR7GX_+Y',784381351,'16:49:45',4.260,'1989-06-26',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'1997-01-07 00:00:00',x'0e507c3e8e','ZB^~TgKkR7GX_+Y',784381351,'23:30:53',4.260,'2020-06-24',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2030-04-18 00:00:00',x'022e82ee7d','ZB^~TgKkR7GX_+Y',784381351,'09:03:54',4.260,'1994-11-03',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2000-04-30 00:00:00',x'0bfb579ed3','ZB^~TgKkR7GX_+Y',784381351,'20:27:17',4.260,'2006-08-19',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2003-02-24 00:00:00',x'04c44ca7f7','ZB^~TgKkR7GX_+Y',784381351,'09:00:50',4.260,'1984-10-06',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'2015-04-07 00:00:00',x'0000000000','ZB^~TgKkR7GX_+Y',784381351,'18:07:10',4.260,'1991-07-21',x'5169'), (x'49795234255873684c41436f72536b696665',18733,'1988-04-26 00:00:00',x'0d42838521','ZB^~TgKkR7GX_+Y',784381351,'09:47:57',4.260,'2034-03-04',x'5169'), (x'47754952657170',18733,'2018-03-20 00:00:00',x'0e61f53a80','2$73A88t#XFIV*4sl',784381351,'01:41:42',4.260,'2017-02-03',x'5169'), (x'756a716c475124677a',18733,'2007-05-04 00:00:00',x'04b7546266','gtV8KAMA73',784381351,'12:58:49',4.260,'2021-04-03',x'5169'), (x'4942595e77',18733,'2011-05-03 00:00:00',x'0aaabefa7e','uW3GkO~o3fcQR',784381351,'10:37:03',4.260,'1997-01-08',x'5169'), (x'452b2957',18733,'2025-12-07 00:00:00',x'0c920f8e3c','bbGU!hQuD',784381351,'22:47:14',4.260,'2028-08-28',x'5169'), (x'495a536a24703d51474b532d2a366550294a',18733,'2022-01-10 00:00:00',x'0a4182471c','P4#vXEU*GRSiF8G',784381351,'13:47:47',4.260,'2024-06-09',x'5169'), (x'3528533028',18733,'2030-02-07 00:00:00',x'0849609344','k1-#W_',784381351,'19:41:51',4.260,'2012-03-01',x'5169'), (x'4b683721346b706855492d6a48',18733,'2012-11-09 00:00:00',x'0b3990cfeb','n$-cRIrf=YZ6Xe8H',784381351,'12:53:37',4.260,'2031-12-07',x'5169'), (x'',18733,'2004-05-10 00:00:00',x'0ca7f6ef7d','O-W',784381351,'11:02:23',4.260,'1977-06-11',x'5169'), (x'32612379326e4d69774548684a5a',18733,'2018-10-16 00:00:00',x'08886ae346','aI)',784381351,'07:04:40',4.260,'2010-01-02',x'5169'), (x'456b2633304b6561554c423939',18733,'1996-09-17 00:00:00',x'09e2a522b9','dcI0n@1PecflmTMU^Q',784381351,'04:16:46',4.260,'2021-07-16',x'5169'), (x'6f594524504d4f53704a523172586f3475',18733,'2014-05-06 00:00:00',x'0610a14630','#(1uKnrB(Y&i(',784381351,'06:37:02',4.260,'1999-06-19',x'5169'), (x'3378245268335940544d7e73',-15990,'2016-08-06 00:00:00',x'05f26a1dde','',784381351,'03:40:24',4.260,'1994-10-08',x'5169'), (x'2134287766375533',18733,'2025-09-07 00:00:00',x'037fa783d6','GI',784381351,'15:04:13',4.260,'1994-07-17',x'5169'), (x'4a4b762d5f4d52736a536372',18733,'2022-11-28 00:00:00',x'044075088f','kbWM',784381351,'21:53:49',4.260,'2034-04-22',x'5169'), (x'34',18733,'2031-08-17 00:00:00',x'0dc1979f63','oQu2g4tk9zr(VE%so-',784381351,'20:48:33',4.260,'1986-04-08',x'5169'), (x'3378245268335940544d7e73',-15990,'2000-11-12 00:00:00',x'05f26a1dde','',784381351,'06:30:06',4.260,'1998-09-15',x'5169'), (x'343d3274415a5a564f375f72466c4c34',18733,'1996-07-07 00:00:00',x'0000000000','M*&',784381351,'13:38:40',4.260,'1984-06-25',x'5169'), (x'3d7438594c6a332d663164436d',18733,'1996-08-21 00:00:00',x'004452b96e','DP)y)M=UvJ',784381351,'09:51:34',4.260,'2004-02-10',x'5169'), (x'4d3659334f6876346f4b6d5823',18733,'2031-04-28 00:00:00',x'0600b9ac50','(aL*7hg&sz',784381351,'13:40:34',4.260,'1976-06-25',x'5169'), (x'492d69754d7e78645a34664f744674',18733,'2009-10-23 00:00:00',x'0434bef752','Zr',784381351,'06:09:05',4.260,'2034-12-13',x'5169'), (x'',18733,'1996-09-17 00:00:00',x'07a5b8ed8d','+SD9TrLNvNF8=M',784381351,'04:16:46',4.260,'2023-01-30',x'5169'), (x'72',18733,'1992-10-22 00:00:00',x'07966dbe4a','~kz@7@+bF',784381351,'13:13:40',4.260,'1988-11-20',x'5169'), (x'5325454f5e5f785f31',18733,'2025-11-08 00:00:00',x'0000000000','q649MCwU6P',784381351,'17:24:43',4.260,'1987-11-04',x'5169'), (x'615a534728262a6e6945626753323d',18733,'2018-07-15 00:00:00',x'0f5107381c','ABa7QDNld7#fzB=o)t',784381351,'21:05:23',4.260,'2026-02-13',x'5169'), (x'6d23684441736c43484a',18733,'2033-03-22 00:00:00',x'05e0ac589f','2SW!@=h',784381351,'18:06:49',4.260,'2021-11-13',x'5169'), (x'3378245268335940544d7e73',-15990,'2021-03-22 00:00:00',x'05f26a1dde','',784381351,'11:20:32',4.260,'2003-08-12',x'5169'), (x'74',18733,'2017-03-09 00:00:00',x'08f21ffc7e','mYx~Hq55ZEDSje0qsLE',784381351,'23:51:24',4.260,'1973-07-15',x'5169'), (x'6e3734614058',18733,'1998-01-20 00:00:00',x'01368814cd','zMt!$s0DR1cQxnt',784381351,'17:39:49',4.260,'2013-10-22',x'5169'), (x'25242973695970744e5878567065',18733,'2030-02-22 00:00:00',x'07074140e2','(t',784381351,'23:23:45',4.260,'1980-11-25',x'5169'), (x'215072447e326856',18733,'2025-01-23 00:00:00',x'016cab95d4','t@ZWVsJGe7RBcnJx9',784381351,'18:59:45',4.260,'2030-01-03',x'5169'), (x'6f7e724f5a416750676263697738',18733,'2032-10-19 00:00:00',x'068544fddc','OBEU-!_',784381351,'09:15:27',4.260,'2015-01-04',x'5169'), (x'5830742b544350555852',18733,'2011-02-22 00:00:00',x'0000000000','71oSlq3',784381351,'02:24:56',4.260,'1987-01-13',x'5169'), (x'4642776e5371307a25663936306436355a5f70',18733,'1991-10-30 00:00:00',x'038a13853e','HusCb)65',784381351,'20:18:24',4.260,'2028-06-26',x'5169'), (x'7a61',18733,'2001-01-31 00:00:00',x'023a8d04aa','poU4J@',784381351,'12:03:46',4.260,'1992-04-30',x'5169'), (x'784e615a5829435551',18733,'2002-02-04 00:00:00',x'02a41da135','0IDgd-',784381351,'21:03:44',4.260,'2027-01-28',x'5169'), (x'4f4a684e615f55543d3d4b6f2a7841',18733,'2016-08-04 00:00:00',x'05cca2c754','rfO+Wb!P0c9s',784381351,'08:30:31',4.260,'2028-10-26',x'5169'), (x'377a',18733,'2009-09-04 00:00:00',x'0af8553988','PgQ^$40SVGXIHnL',784381351,'13:28:55',4.260,'2011-04-24',x'5169'), (x'496b44575939475e43395a7036',18733,'2033-11-16 00:00:00',x'084729cee7','Xm8P5VlfRwF',784381351,'08:02:50',4.260,'2025-06-02',x'5169'), (x'624048',18733,'2016-01-09 00:00:00',x'0862ff24fd','_2gc',784381351,'11:39:16',4.260,'2030-05-10',x'5169'), (x'48307445667e21616a49766e506f58',18733,'2022-12-29 00:00:00',x'0c80f1f2b2','0LGu!1Wv',784381351,'13:50:42',4.260,'2029-12-23',x'5169'), (x'726c7159744457244c6b473668',18733,'1990-12-28 00:00:00',x'0000000000','1',784381351,'23:22:58',4.260,'1984-04-07',x'5169'), (x'44487e',18733,'2013-06-28 00:00:00',x'0023ff26ea','ngH^NgnxrUl',784381351,'20:38:36',4.260,'1972-10-02',x'5169'), (x'473d7654634674',18733,'2026-04-05 00:00:00',x'025f3f932b','hKTLxzz(^kzSI',784381351,'19:27:36',4.260,'2004-03-26',x'5169'), (x'6e36402b4221713548696979564455',18733,'2021-09-12 00:00:00',x'022fe1fe21','MW9q~eKU2)sz~4_x',784381351,'21:19:21',4.260,'1974-12-22',x'5169'), (x'4c213628',18733,'1994-02-27 00:00:00',x'08649dd460','_pCXWiiUWs)vs',784381351,'07:56:16',4.260,'2035-12-24',x'5169'), (x'2457545738',18733,'2022-11-04 00:00:00',x'03182945c6','Xu&n#geQ(Qqe',784381351,'07:59:20',4.260,'2036-12-11',x'5169'), (x'712668',18733,'2007-01-04 00:00:00',x'000d401196','65Pr_8%6j~',784381351,'02:46:10',4.260,'2034-12-19',x'5169'), (x'78293270585f374d457e672b2533726a6f',18733,'2026-09-06 00:00:00',x'057b2625b5','ib3dJiO1Y7p49GwvQR',784381351,'09:26:12',4.260,'2009-07-18',x'5169'), (x'65253342707e2b735a44254521',-15990,'1995-05-11 00:00:00',x'05f26a1dde','O',784381351,'06:33:55',4.260,'1980-12-21',x'5169'), (x'347e5a4750',18733,'2012-12-14 00:00:00',x'0d10222177','P0hEqq8s7&%D^zy',784381351,'13:42:32',4.260,'1981-01-19',x'5169'), (x'5f6350',18733,'2016-10-07 00:00:00',x'08364f56e9','6x',784381351,'15:11:53',4.260,'1998-10-25',x'5169'), (x'50796341703974774e6647234c28334e6c4e6d',18733,'2016-01-25 00:00:00',x'03e40ec187','nvZ7Sd&L*ZrnOtEOk',784381351,'12:05:19',4.260,'1985-06-29',x'5169'), (x'31722d3d5168336a3239',18733,'2009-05-19 00:00:00',x'028ba6db55','-Dwq',784381351,'09:00:01',4.260,'2010-03-06',x'5169'), (x'5f25544f796a',18733,'2025-06-26 00:00:00',x'03480bd2bd','d',784381351,'21:01:10',4.260,'2028-04-11',x'5169'), (x'737025214c43595a37733d4562',18733,'1989-09-22 00:00:00',x'0892dfe54d','tPTdiidG%lAMVP+p',784381351,'20:01:19',4.260,'2027-07-03',x'5169'), (x'547126',-32768,'2029-05-02 00:00:00',x'0639cafb28','LvY',784381351,'05:30:20',4.260,'2023-08-03',x'5169'), (x'5737212d362b2640636e6865472a4e6a486546',-14975,'2014-10-12 00:00:00',x'0e5a79094a','QLrA)38o%dIM',784381351,'07:45:54',4.260,'1993-08-21',x'5169'), (x'75455f766253427a43263561672b',6598,'1982-08-13 00:00:00',x'039674a6bf','K)',4087635374,'21:10:13',605.198,'2025-12-20',x'4b5175745366355a2a24354c6b'), (x'655255395070236b',-10967,'2014-06-06 00:00:00',x'018de6507e','dln',784381351,'11:39:52',0.512,'2027-04-23',x'5169'), (x'6a307649414f734e6c4640',8360,'2035-08-30 00:00:00',x'056261057b','n',4061285505,'13:42:20',27740.530,'2014-05-01',NULL), (x'',-15766,'2000-09-27 00:00:00',x'0a4cd7af19','1(8~(',784381351,'15:38:24',11940.180,'2017-09-03',x'5169'), (x'7e6b754b5e33',16724,'2031-06-08 00:00:00',x'0afae25e07','tVk&RcV)QDL-q',784381351,'04:20:59',20523.840,'1989-02-21',x'5169'), (x'424e6f557e282b7a775a4d6a53',26734,'1999-08-12 00:00:00',x'0a5c68ca7c','tuT)lG&vcS-h',784381351,'13:17:02',9673.600,'1986-01-08',x'5169'), (x'646e6131',-25740,'1998-03-26 00:00:00',x'0a231cb719','L-^)',784381351,'17:49:05',79.200,'1974-12-04',x'5169'), (x'6d2d4e284e74765325754639762d58',0,'2018-07-25 00:00:00',x'03abaa0d94','P(PedJ',784381351,'15:05:43',999.910,'2025-05-14',x'5169'), (x'672d6c3654694c5670796d43774941',-12813,'1994-12-04 00:00:00',x'05461621cb','f',4147986205,'02:00:32',65.430,'2018-08-15',x'46673075504b784966782928775f416a6d30'), (x'56623078',-24816,'2024-05-22 00:00:00',x'0f47f05ff9','-BQK',2712994979,'10:51:50',798.066,'1991-09-13',x'5a2d65372d4b25555f5a3d774931577679'), (x'333179743053333475704f61682b6f',-30351,'2030-06-06 00:00:00',x'07b559ef0e','unsu(Dc~C67',589518469,'23:44:59',307.300,'2000-08-01',x'28487e79757e4b256c2430'), (x'655f4046657525',10058,'2006-04-21 00:00:00',x'0c35f4f74e','*XHsz0^Ad(pp',1048531787,'23:09:30',8.000,'2002-11-05',x'7359427228625844'), (x'6e6c4b50637e6a286b4f42753436584f76',-4667,'2035-02-28 00:00:00',x'04709a3883','tGo2EGbKV4wNX',3298662579,'05:26:30',2804.520,'1993-03-15',x'444746387539655a4462584d'), (x'374c7242524945',8317,'2003-07-24 00:00:00',x'0000000000','N(D!z',2343906553,'07:12:09',0.900,'2012-12-11',x'4c736632457e467758327130'), (x'',2,'1988-04-05 00:00:00',x'0375c592f2','MLL5$jv1__aU9ru#H%D',678124754,'21:12:02',0.702,'2003-06-17',x'5036'), (x'66286e422b5357642d4e6c5e39',2208,'2025-10-08 00:00:00',x'06e7264041','g',3558143705,'16:41:00',65419.870,'2008-04-06',x'28583d45412149316e654a62647e3d7a657a'), (x'552371516c7353364f393d4f7624',-29909,'1976-10-01 00:00:00',x'0ec03f372c','t2i*8ZbEN6Ob',3229198364,'15:28:32',0.363,'2022-02-17',x'3523236d457a734b77346a5024'), (x'4f2b7363747932727870',28204,'2007-01-06 00:00:00',x'0134740ba4','k0O3aTcLMm',2274437709,'12:33:26',14.810,'1986-07-26',x'77265f584751254c3137'), (x'542630252653364962473d38504625535f71',-21818,'1984-09-10 00:00:00',x'0000000000','v1mV42jR',129658614,'02:46:41',0.000,'2032-01-19',x'5f7365'), (x'5a7a544d433d744e6628',-9416,'1980-05-28 00:00:00',x'0bf3ff8f9e','i',399234443,'17:14:52',0.300,'1971-12-12',x'7025386d52'), (x'4b362d50',-20427,'2022-07-02 00:00:00',x'0000000000','bjel#c2opAXHYSP',891582315,'22:18:47',4650.400,'2030-10-08',x'785e5e46566c354247216a3633433866315e'), (x'484a554c',-3284,'1998-04-06 00:00:00',x'0f056a9130','_Zd3%MQ2Lp^nq^ZZ2)',2935469688,'05:15:53',0.000,'2000-06-29',x'4553307528');

update tl03d45331 set tl03d45331.col_79 = '[\"OT9z6a5Fnzu9iWFgErAfHfa79yv0faWQqxoQrhjN4VkAXx0FtKlm8TFPmmvnxpzo\",\"2ckVotr6Fh1rQiUwNRYZZthaDt9nHAFY82IpAqmSgf9mUA2PfjBXgIG4lufsEXiq\",\"jN5v314sBPtxWjl5ZKDpptq2FgNYpBSqrXfVQwoLDeBItcf9m3tbqQcmu9ut8LJH\"]' ,tl03d45331.col_79 = '[\"sItmP5CR5tG8XtE8YEYXQzqUbH1hEj0g50JPApS3KXy3fNOMMUDoRBye6XgrLc8x\",\"oExaxSZkmjrPLQyEBvTuoGat5YSMauGOXK3BgPenUTqeoKr5CeDhISmpzlg5aSi6\",\"0xB5ldw4hxuIwdcOsXy0ss0DpsFKIUqdsuHcjoDkN7eTuhwD353eQctRISBCZpvK\",\"KwQMOlw1b9pc5UL6w6Fk11QCNNBHhruhvDjsdVvpbmu9JcojX2Q9r9dtzEO71Hah\",\"PbGzWszChqMNlfU3039EqxyB78maIRXGMGrXugpZcmuSSVHtomrFgXDcuDCExQFS\"]' where tl03d45331.col_81 in ( '23:19:14.00' ) or not( tl03d45331.col_81 < ( select  /*+ use_index_merge( tf14418cf ) */   tf14418cf.col_25 as r0 from tf14418cf where tf14418cf.col_26 in ( 'GS8!9JMXF' ,'pTI' ,'OBEU-!_' ) order by r0 ) )  limit 1895566381;

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

No error

3. What did you see instead (Required)

mysql> update tl03d45331 set tl03d45331.col_79 = '[\"OT9z6a5Fnzu9iWFgErAfHfa79yv0faWQqxoQrhjN4VkAXx0FtKlm8TFPmmvnxpzo\",\"2ckVotr6Fh1rQiUwNRYZZthaDt9nHAFY82IpAqmSgf9mUA2PfjBXgIG4lufsEXiq\",\"jN5v314sBPtxWjl5ZKDpptq2FgNYpBSqrXfVQwoLDeBItcf9m3tbqQcmu9ut8LJH\"]' ,tl03d45331.col_79 = '[\"sItmP5CR5tG8XtE8YEYXQzqUbH1hEj0g50JPApS3KXy3fNOMMUDoRBye6XgrLc8x\",\"oExaxSZkmjrPLQyEBvTuoGat5YSMauGOXK3BgPenUTqeoKr5CeDhISmpzlg5aSi6\",\"0xB5ldw4hxuIwdcOsXy0ss0DpsFKIUqdsuHcjoDkN7eTuhwD353eQctRISBCZpvK\",\"KwQMOlw1b9pc5UL6w6Fk11QCNNBHhruhvDjsdVvpbmu9JcojX2Q9r9dtzEO71Hah\",\"PbGzWszChqMNlfU3039EqxyB78maIRXGMGrXugpZcmuSSVHtomrFgXDcuDCExQFS\"]' where tl03d45331.col_81 in ( '23:19:14.00' ) or not( tl03d45331.col_81 < ( select  /*+ use_index_merge( tf14418cf ) */   tf14418cf.col_25 as r0 from tf14418cf where tf14418cf.col_26 in ( 'GS8!9JMXF' ,'pTI' ,'OBEU-!_' ) order by r0 ) )  limit 1895566381;
ERROR 1105 (HY000): other error: [components/tidb_query_expr/src/types/expr_builder.rs:75]: Unsupported expression type MysqlBit

4. What is your TiDB version? (Required)

4e416993cc65b4da6786a7ce859b2ab99e5bba15

windtalker commented 8 months ago

The root cause is after https://github.com/tikv/tikv/pull/12037 and https://github.com/pingcap/tidb/pull/32497 bit column is supported at TiKV side, but in https://github.com/pingcap/tidb/pull/32497, it allow ExprType_MysqlBit to be pushed to TiKV, which is a bit constant, and TiKV does not supprt bit constant A simplified case of the query is

mysql>  update tl03d45331 set tl03d45331.col_79 = 1 where ( tl03d45331.col_81 < ( select tf14418cf.col_25 as r0 from tf14418cf limit 1) )  limit 1895566381;
ERROR 1105 (HY000): other error: [components/tidb_query_expr/src/types/expr_builder.rs:75]: Unsupported expression type MysqlBit