search

pingcap / tidb

TiDB - the open-source, cloud-native, distributed SQL database designed for modern applications.
https://pingcap.com
Apache License 2.0
37.29k stars 5.85k forks source link

incorrect query result using subquery #54607

Open wjhuang2016 opened 4 months ago

wjhuang2016 commented 4 months ago

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE `t1d90f49d` (
  `col_54` decimal(7,1) DEFAULT NULL,
  KEY `idx_34` (`col_54`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `t1d90f49d` VALUES(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.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),(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.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),(40188.0),(6.8),(23.8),(721.9),(182054.9),(0.0),(682.0),(0.0),(794585.0),(37201.5),(13.2),(4384.7),(1634.8),(388.0),(486.9),(408.0),(18.0),(0.4),(342679.0),(0.5),(5902.3),(0.5),(39.2),(149963.0),(8.4),(54562.9),(15.1);

CREATE TABLE `tl14db775f` (
  `col_16` char(235) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'R)8Wl=kuthX',
  `col_17` text DEFAULT NULL,
  `col_18` json DEFAULT NULL,
  `col_19` float NOT NULL,
  `col_20` binary(157) DEFAULT 'X~vsscvNZ\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\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_21` float NOT NULL DEFAULT '8867.555',
  `col_22` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`col_21`) /*T![clustered_index] NONCLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

INSERT INTO `tl14db775f` VALUES('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8414.022,NULL,6367.9453,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',670.5333,NULL,7225.2227,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8955.219,NULL,4064.8599,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',4394.952,NULL,6553.64,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',7543.665,NULL,9069.905,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',813.4477,NULL,9755.067,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',4376.0684,NULL,3948.549,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2132.4534,NULL,6290.837,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2519.085,NULL,3457.863,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',1090.2753,NULL,4396.324,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8811.926,NULL,5917.7554,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',1300.4259,NULL,5631.1753,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',3169.0947,NULL,5661.0864,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',4810.4565,NULL,8970.73,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2357.1929,NULL,8089.117,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',5180.0303,NULL,8459.93,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',9499.141,NULL,4852.016,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',3092.6426,NULL,5457.676,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',6516.315,NULL,7659.939,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',5521.647,NULL,6987.889,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',120.783585,NULL,2205.9163,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',4935.4644,NULL,7693.5156,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',6216.835,NULL,2996.3987,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',9553.033,NULL,2016.09,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',4595.3555,NULL,9328.585,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8440.577,NULL,3366.8594,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',3101.112,NULL,5061.3384,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',38.74845,NULL,2174.485,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8151.88,NULL,6495.635,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',6181.3984,NULL,1667.4562,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',3911.9556,NULL,9746.718,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',4622.8315,NULL,6242.3745,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8335.697,NULL,6090.546,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',1401.9567,NULL,8526.467,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',425.57535,NULL,6666.9766,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',3568.234,NULL,5006.502,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',6804.367,NULL,9401.758,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',4952.45,NULL,8009.124,'a3xuQR黊'),('e#G7dW&F#*HP7!','rR*mb','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8080.9673,NULL,8080.684,'a3xuQR黊'),('e#G7dW&F#*HP7!','a^','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',890.7895,NULL,7751.7485,'a3xuQR黊'),('e#G7dW&F#*HP7!','96q1p','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',5570.176,NULL,8446.53,'a3xuQR黊'),('e#G7dW&F#*HP7!','nAaD+#r2FE','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',489.0036,NULL,1163.0916,'a3xuQR黊'),('e#G7dW&F#*HP7!','j*B!4*nWE','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',589.2439,NULL,8494.649,'a3xuQR黊'),('e#G7dW&F#*HP7!','T^','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2186.9524,NULL,9261.685,'a3xuQR黊'),('e#G7dW&F#*HP7!','lMjZxpCsS1=sfqH','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',9650.421,NULL,9586.574,'a3xuQR黊'),('e#G7dW&F#*HP7!','BS_YOuZNkhZup','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',6662.856,NULL,5524.432,'a3xuQR黊'),('e#G7dW&F#*HP7!','d','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8640.338,NULL,7772.014,'a3xuQR黊'),('e#G7dW&F#*HP7!','lX0IqnS_JSM_)*=4~yw','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',9357.874,NULL,2020.4995,'a3xuQR黊'),('e#G7dW&F#*HP7!','%Z&QHZ7vei+$i)b8E&','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8686.076,NULL,8661.5,'a3xuQR黊'),('e#G7dW&F#*HP7!','br5Y&LD8YJtd','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',9385.974,NULL,7818.0576,'a3xuQR黊'),('e#G7dW&F#*HP7!','7WpMJl(d*!o','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',9846.749,NULL,1208.4677,'a3xuQR黊'),('e#G7dW&F#*HP7!','-~f^8H','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',5537.78,NULL,1182.7218,'a3xuQR黊'),('e#G7dW&F#*HP7!','I&n#!RFs=cBUm-!','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',7397.4116,NULL,6579.1094,'a3xuQR黊'),('e#G7dW&F#*HP7!','P@E','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',1720.4636,NULL,6624.692,'a3xuQR黊'),('e#G7dW&F#*HP7!','eBwR^pe!','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8375.751,NULL,3033.4932,'a3xuQR黊'),('e#G7dW&F#*HP7!','','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',3135.489,NULL,4516.375,'a3xuQR黊'),('e#G7dW&F#*HP7!','4_n','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',6577.933,NULL,2672.04,'a3xuQR黊'),('e#G7dW&F#*HP7!','','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',724.21094,NULL,3020.6523,'a3xuQR黊'),('e#G7dW&F#*HP7!','@Y3OlTZ','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',7274.977,NULL,3529.0244,'a3xuQR黊'),('e#G7dW&F#*HP7!','X6%-','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',1143.3857,NULL,4117.598,'a3xuQR黊'),('e#G7dW&F#*HP7!','hrq*u5RBrU#hO','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',4539.4336,NULL,8553.718,'a3xuQR黊'),('e#G7dW&F#*HP7!','o136SnIQ5uLK9~LT','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8574.913,NULL,6557.248,'a3xuQR黊'),('e#G7dW&F#*HP7!','ICpNs0XiM','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',4523.7344,NULL,2953.1443,'a3xuQR黊'),('e#G7dW&F#*HP7!','Py&','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',7530.6475,NULL,2398.7578,'a3xuQR黊'),('e#G7dW&F#*HP7!','S(','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',6814.3286,NULL,2220.7585,'a3xuQR黊'),('e#G7dW&F#*HP7!','dkQY','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',7615.028,NULL,4745.1265,'a3xuQR黊'),('e#G7dW&F#*HP7!','PDP_OFJo','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',5642.648,NULL,1210.5972,'a3xuQR黊'),('e#G7dW&F#*HP7!','g@CvQu','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',9601.023,NULL,8393.882,'a3xuQR黊'),('e#G7dW&F#*HP7!','R=d9R^#M','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2597.1084,NULL,9435.061,'a3xuQR黊'),('e#G7dW&F#*HP7!','6Dm','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',104.79148,NULL,7852.457,'a3xuQR黊'),('e#G7dW&F#*HP7!','-l_g@0h3kOwqjgN','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',5194.8257,NULL,9630.952,'a3xuQR黊'),('e#G7dW&F#*HP7!','0@N)V&+=P-','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',3175.0735,NULL,7829.8926,'a3xuQR黊'),('e#G7dW&F#*HP7!','@=ptcq^Ozm$iI%e$PQk','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',6211.4116,NULL,9053.182,'a3xuQR黊'),('e#G7dW&F#*HP7!','4^N~','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2604.1191,NULL,3712.0518,'a3xuQR黊'),('e#G7dW&F#*HP7!','E','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',1912.172,NULL,9080.671,'a3xuQR黊'),('e#G7dW&F#*HP7!','^S6Plbda8','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',1293.2245,NULL,6828.841,'a3xuQR黊'),('e#G7dW&F#*HP7!','$5kfmQQ@Lp+TVzi1qo','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2798.7092,NULL,9059.176,'a3xuQR黊'),('e#G7dW&F#*HP7!','CB)Y#yHZI0&J','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',9825.837,NULL,7616.5503,'a3xuQR黊'),('e#G7dW&F#*HP7!','JcSCzVy','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',9069.954,NULL,9817.197,'a3xuQR黊'),('e#G7dW&F#*HP7!','Ay@3','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',6141.4917,NULL,7369.1206,'a3xuQR黊'),('e#G7dW&F#*HP7!','N~&aG4sh!Dn@U6!','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',637.751,NULL,7586.956,'a3xuQR黊'),('e#G7dW&F#*HP7!','G0mkixi','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',89.45848,NULL,4689.0117,'a3xuQR黊'),('e#G7dW&F#*HP7!','Rdk~lc4)oQ','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2912.0562,NULL,9039.166,'a3xuQR黊'),('e#G7dW&F#*HP7!','-vHlxYtDr0P','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',1328.3646,NULL,6458.874,'a3xuQR黊'),('e#G7dW&F#*HP7!','Mq#c','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2181.614,NULL,6610.545,'a3xuQR黊'),('e#G7dW&F#*HP7!','c=A~6LALt#mx*=VG4','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',9778.297,NULL,6106.2866,'a3xuQR黊'),('e#G7dW&F#*HP7!','tO8d(b(eL-4FT8n','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2472.1409,NULL,2768.8376,'a3xuQR黊'),('e#G7dW&F#*HP7!','ybGjGu%&s','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',1201.7369,NULL,4421.2866,'a3xuQR黊'),('e#G7dW&F#*HP7!','Gvrhu&pB','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',5203.8276,NULL,8951.198,'a3xuQR黊'),('e#G7dW&F#*HP7!','xHTeMw9V@)w','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',6225.3,NULL,8552.796,'a3xuQR黊'),('e#G7dW&F#*HP7!','0~T%5Es','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2473.8967,NULL,8800.52,'a3xuQR黊'),('e#G7dW&F#*HP7!','jZdzIMF(@1nBMXE8','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',6681.7817,NULL,5609.4243,'a3xuQR黊'),('e#G7dW&F#*HP7!','BN+~yEMt35lQ','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',1709.1562,NULL,4685.6904,'a3xuQR黊'),('e#G7dW&F#*HP7!','^Qkkrp^b@HzMF)86$','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',3295.7651,NULL,7775.631,'a3xuQR黊'),('e#G7dW&F#*HP7!','M$K9YYqpH~NYK','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',11.650068,NULL,5587.649,'a3xuQR黊'),('e#G7dW&F#*HP7!','XVd8t$g&qdOgskCbM','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',3578.6538,NULL,5299.19,'a3xuQR黊'),('e#G7dW&F#*HP7!','rFI0Rm','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',8427.368,NULL,6710.8257,'a3xuQR黊'),('e#G7dW&F#*HP7!','oPS7Eab=&0CRdglrMV','[\"qnh81cMXursAEaT4bc2ZfkTwfv8dQV7VtLfUBnVvyR6fTUIYWPZzS3GzPc7i8ER8\", \"G2T7xfraol7xaxkXEPc8INsxgI60wYe1t7Jm8rbJIoIbArmUXeODRAT9uxITTt9f\"]',2975.928,NULL,5958.361,'a3xuQR黊'),('e#G7dW&F#*HP7!','E-tu','[\"ySZq5LX1d1roCIXpKvqibax1frJZaKnXTR8A4af2J28F6IpOZnCePcHgywp4VNAm\", \"WsYhen3UALjaBSfMe7QBJte1ytn6uWOVXpa4RKSjql8f1Ba9IcnKRKuRVuTCTiqS\"]',7493.708,NULL,6876.7114,'a3xuQR黊'),('e#G7dW&F#*HP7!','gT*f__dpHua','[\"KSgEPIhy3vpcULGEi6CQ1cOdUkoUA71fAbkr4arhgWneeeYsAL0DLuru54aJUpeJ\", \"Kg3P5qhyMfs9pt5ZNMZRFxM8butKextnFyxUELCUeeMKZa9cAe4O8b12iKsR0VOn\", \"87aCMJmhcPqor7NSJp6HQBuGC5L809wZvPRDBHnE9xC5tXkc8iyukXCkN4I7cZNc\", \"tkyx7x57cmEb2VdwkWxD2VebxnWunu0rmH3bl4xq11s235g50HdZJ1W2nnWYaAOS\"]',5775.469,NULL,2615.741,'a3xuQR黊'),('e#G7dW&F#*HP7!','1*d$4#','[\"m6DhqQwhuYFVQmJ97nDlADSYAQwnTY0Q5lHeJCOy9Oam35Pv2BiWD3M7N26HUhF0\"]',6850.492,NULL,8549.42,'a3xuQR黊'),('e#G7dW&F#*HP7!',NULL,'[\"6DtXENjBNU89CWLPrV7Y0jyv1VsoDzLIpA1Qvm33S0ysDJoix1UVTShgBXMIORHk\"]',9454.75,NULL,5132.422,'a3xuQR黊'),('e#G7dW&F#*HP7!','_Q~+eR','[\"TY280GsYVLSosYvwekHVdvnlGntRX2Z84BnC9Sa2w0Yc13TJYxYmExvsvX1zOyWg\", \"k9CgVCj7ybWHtV9BqYpYuz6vxBc3xt7MakkzU8w5TUv0GPvFkdXTWER1l8VprtzF\"]',1714.0852,NULL,4288.495,'a3xuQR黊'),('e#G7dW&F#*HP7!','Q4jg','[\"UzxE5aik1ZCBsUR6LJR1GLUjMNEoAxehqIoqZ6Nw0klR0YxoHk79CmxiY1V1IEZ1\", \"PoNKgBNg8yhz3kPOtqtDznQyG7FtAoJ6Nf3q2pJW4H54EIlPgVot5Edv1JdIiwKf\", \"rknRukR6d55zAjeCgXK4EX1koeB2Cvk56wEfWG4kzFY1f0ldkUhaEZc7qEb2BdVD\", \"lKkVgK4A0Zz7FCpAEY1vgDfpWeqGqzHH3FPEMEnseggbR3C9jjTPAPqWRstkevWh\"]',5918.7734,NULL,3477.1475,'a3xuQR黊'),('e#G7dW&F#*HP7!','+JrguKmokwb6x5I5r','[\"T3OTPWybGyw10SxpxDjjyuXe8qwNAWrONOvisGo8Vr9aMw1V80GnnYVDkrspaNKT\", \"llylhZ8T4ui0qvaYtsPBklrzRstinbfyBPvZJsJcXH2p56h63ddY5s5NG52lD4J2\"]',6536.8447,NULL,7622.871,'a3xuQR黊'),('e#G7dW&F#*HP7!','lvuhKcPUF$uNW&~wcW','[\"ttettMM6vmakD9Nb2iIxOMUJWkGMHOKIRUBdznNV5dOkjBTujB7sSl3d45W4KYSQ\", \"9IUkm7CyWu4yNhsx6f4oQ6uLClgKsWA9MLmOrD4KZot4xXbrZijBAN8zkeRLSNYr\", \"vjzRVadQJ0a0oCasmthMIBormyeLq0hiudu9LK7uBnEjiXWs7MvwhgI7U9UIgJuo\"]',4308.1772,NULL,9841.445,'a3xuQR黊'),('e#G7dW&F#*HP7!','1(GPly','[\"liQtAvNAkXpTaZBvsJZfLvm2FWmRfItjCqRA2yZpRJeiu1spmsthSsARMcjrqL2V\"]',8197.447,NULL,6212.3164,'a3xuQR黊'),('e#G7dW&F#*HP7!','V)2lESph1su^x~&F',NULL,5530.1743,NULL,7168.779,'a3xuQR黊'),('e#G7dW&F#*HP7!','BXny+F_#LLl','[\"o8BhG79PEshkkG7NhMUQ4Wxk6TYBo0z75xAoJuOLMRHq1nYON7VA0Bz0gFi4F0rl\", \"U3ZIqmFV4evFprEjDWNcoLt1k5iUKGTwkUSuymm4HVh73RzEdE76GmE26ZEoD0jn\", \"Tl4QaFcXNnDPSHtleqM8gFvCxlRjxQ9OB89dbPd58rnuZr0s48bDylmf8qkzuZOM\"]',3380.6213,NULL,9402.196,'a3xuQR黊'),('e#G7dW&F#*HP7!','Zwz(','[\"fAhlCB2oqA4DCwjOgdp3VtJmp1Hoc2I8V5jqTMM0MPGV9jNt5pL3Qa5SWt6FE4QD\", \"HpyYZcbeXXLliLtfpmgt0ZhRiBmbtOwXGpTxL2DfX8jiEFOLhGYbnnNGnQhxAKDH\"]',8496.651,NULL,7793.395,'a3xuQR黊'),('e#G7dW&F#*HP7!','9q^H','[\"iKB7CNp1ccNFP6oKZ22wdbScWN6sJyFaZPgKtQXLvvNO45FfTwhHlhf2v5pBtmai\"]',6490.6265,NULL,9051.559,'a3xuQR黊'),('e#G7dW&F#*HP7!','66!ckN','[\"x7nIGRGshwIBxmxrryp9nJjNqLm6rlo3tj6TcacQDHLtxfyTTAqpeuBtXrdyfoDD\", \"ooav7X611ozm3Y8ySyKPzQGYzGfDT6JKLxxZH4mN93KPhp12C9oxyREYNWGP9LeT\", \"lIgDMB3D5aWwODisft6mvaW9wv8uE8wcQWf69qjeb5CuVjOpp2CWh3DaNKvnCMIv\", \"4Aov749jmdnrs3dkxERM1Kz64GFoey1LBH2tiK5XYtiju859vyse0N5lJoxdP6x5\", \"IgPAmFeHHJ8LKRlPrNECei9ACHLJCJL97wuxzsIFQ525CiuysEtWbzXp2pYue2A8\"]',9691.263,NULL,796.5654,'a3xuQR黊'),('e#G7dW&F#*HP7!','~eU)7m!cy9k!yw1S=r','[\"INDttZ2tuROkwnaU905qUlulCyWOTv0lP6fyF8ZEHFNLYi6bxHaeSkbpulh8gfq7\", \"LEHi2EdxJliNa90XcMfMXcsYjkKqv0c3gKvhFcnlaZqjlYMkdnrEo9w7hMmpfSrv\", \"AhdFqexf6BcQ8opIzOdVBWV1LPAwLciCEqTKoESP6r64w4IjjKWeOv059y5yA3eL\"]',4114.372,NULL,5438.805,'a3xuQR黊'),('e#G7dW&F#*HP7!','3ps','[\"2ZFncEatkH3fznUvahozYcdOlaBNESiHBli61p36RWh6bn0EHj5JU9iCVH3J8u2F\", \"pUgKzWf6Q363e3csRh74BqI8UXNSZARhnPbWHwag3eS7g9ixkBvF9h9lZBw6BPh8\", \"iVWyE3WM7dabzPtwKD8ChWyoBFRag5OaMOKTpjvDVOOO7s6VKIP9ten8SBPYI1FB\", \"vVzawnri3SvzES0SDGkdAvea3nKyiy4raf9lSTfB8gRogocmfYug38xBbu6XTU2a\", \"YusnOTJxvTB3Vpx8FZ9JdqZphn5bcOA27W6TeOpDmapyIvkdyTEu0FUBS7nrE9BW\"]',283.94336,NULL,2065.9717,'a3xuQR黊'),('e#G7dW&F#*HP7!','QdENt','[\"p8Ryd8tuWJWnnKdL6NmAfseLrHtjZvlHflwgzeTKgiIMgDyzMaAZyNZvLSVYqoDv\", \"rP7tjEMDugJGM2nvAHd9EqG4JYqQZIrwcexs0nRsd4NEdH1azBeSOaTXuR7Sr2dw\", \"rp01RZzdzknLOm0OBQrupiYOb5vcoc3NODPhHmDHEibKeZ60chodKMAy4KjDqGaP\"]',7579.4346,NULL,8935.063,'a3xuQR黊'),('e#G7dW&F#*HP7!','0=ugLGEhWBw','[\"EVyvJc9zs3kt5cwrr3UhTL0UvvEdr4q9GpqtxHla1ngcOR0NXXvLcd5JOo5rIGOe\", \"aVhF8vDpqgAIWJf01K6kqDTxNl0A2h8pPLeAQR2XvvAXVPEcdLJqzsiX67Vc5j2u\", \"68hWGqcaxnIZC7H2stPiaUT10udJsAyNCVQ5tDHRucnpKGONHBSDCojIHD9Lnq9v\"]',2901.0774,NULL,6841.532,'a3xuQR黊'),('e#G7dW&F#*HP7!','xt~YLJX_rO)p02wxmR$','[\"58PoALxwcCvfxBCt75KnSMB8dsqpxKV1UVNYSQ66Mlnoz2iezUyci91q9zOjiX6O\", \"uCWD1Eo38a1tM2yl7t3aUXNsRlzDqI18RJfQcsxDa1PhJ8nHfkqfEQYyJWamCwNM\", \"v6wrmSNpIXmzTiclmh6uaD4YAm4g2iMY3leNlFWCOnSx5rWPK75PYCgpcohpwAHr\"]',7423.025,NULL,9967.121,'a3xuQR黊'),('e)','Un+WEc','[\"423jcRRvvPlXsMpScK7HNdXrGDrks8qLEPrP3ibKGf8sQc99zAbBfOkFy4tRylyO\", \"bbXpSTBVq0Bjj3LCUksZrbDY6v7rd6ABpVaYBzun9cOFXWUwVbBXeocAgbAfEbPk\"]',1254.8938,x'61592332403400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',9542,'O*龫陑x3m8PB'),('&~+T','GE','[\"e5GQj0I75RU3enijIafzaZNqjjCb8J1VUnna9AcThMZKx6vRy0usbzxQrog1vYbG\", \"tAy51ARLzrWNwqKSbvNsCTJ0RqoAs7W1mi9JuGn1eZkNBi59TmQCUrY5o6fjfOqb\"]',3204.5825,x'584d7835624161000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',8153.4136,'襯'),(NULL,'#^','[\"M16BS7yX6Kg3rvXdDjxgdskcOUAxr6A5vI2Pz0LYJK2gynePn785sw0cKE7o1cjn\", \"NQZEHV56tnetvQe8HA9GA13TSOXG2OBJth7AHmswPEFFaB7nbORYmzN9aLnJWS42\", \"05eERRlutgNbY3R2VqtpzXp7Dacl4cf5Y6kmvHPJ02vBLK1rQZvymlTe4ygnhxpi\", \"QrMEcrKBTWw8fh1AG4tcTBOSDNygG47AvvDtnWZrDRwogRFeq2ewbvsktMb5Mr7o\"]',7166.3374,x'31775500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',1923.0172,'FJW2慅1蠰ejUf靓'),('8#-','0A@(bG','[\"Sdp9BlQ3ARn982XgiY2vvnolMGQzPWVqo1FSayRY26k67RW2FZyvLWCXfa5U4JYz\"]',838.9365,x'4b417a595067695549756a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',331.51254,'橀觋嶏_L怆箓芰xm#3縑蕚y'),('K7Wg1^_aY2b5&5oFlr','','[\"NZmBaTFdpEjyzUIv6LSqnaWi0ixD8UMUxStMheEUwRw4zv0a8e6W9okbFAUFxyhc\", \"6kHJIrHRtobxIrkbA43p4wVcZc1lOUvUrzZYaVInJBiyz4w9EFskgPDy6Mq2EPAq\"]',5865.814,x'78000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',7282.604,'槭挭mJ娘堬pp@E+p梟'),('Rk=N~e','_qK88xKJbqh','[\"BhS0G4q7sUwpddCXb4tJ9K3ObGuw4NjIuc1BILUh6vYoY3O6t4jBBid1cVwVaxEh\", \"2eDWLacRNPS794Naws6XFT8KpA8qQivmvvS1DPznmKJBE9Mi1P23O42wz8nlyX0P\", \"ACd0mOSEMToZDumiMVlOMUEcRPCGOFjXg3L5xatWmA17n7FjKNxvY4iuiZbisc9B\", \"LQZWeljLueyXSgwsiVIimOLxV4bYIqgNtNdlPruNsjQSIn9oTn57qOM72QSYqzkk\", \"r601HkTFmS51fgPjkP8R1XZrHuTJdbzWFMT3BnsZvHqdzPIfQ4EzrmiN7MEX0AKu\"]',3607.8455,x'77683770000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',6822.193,'C剃^c怬蓹v_)蹸W往ac拲Dbvs'),('RI-x1e','','[\"e5JHKN07ihwUN4yR1lyI38JB2GAimiajxfv0Yx8xjhrD4zAoCX7bK19nqrYLSNlg\"]',4306.3276,x'00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',1824.2982,'G6磒t棫遈ue6r歼fs'),('-1BTZc1e((QTt','9GMQxgP@!36-)8pkt','[\"9YP7tUBTg3WFRqcqSyyTjwq9agAluntVn1RDw6PpOEtSdWsAIYulO4wSZgx4YWxZ\"]',7784.2163,NULL,1393.5144,'E-CL痗M#o-$罽戃!');

SELECT `tl14db775f`.`col_21` AS `r0` FROM `tl14db775f` JOIN (SELECT `t1d90f49d`.`col_54` AS `r0`,UNHEX(`t1d90f49d`.`col_54`) AS `r1` FROM `t1d90f49d` WHERE `t1d90f49d`.`col_54` IN (0)) AS `st_3578` ON `tl14db775f`.`col_16`=`st_3578`.`r0` WHERE `tl14db775f`.`col_21` BETWEEN 2526.40073820865 AND 3321.717840116553 AND ISNULL(`st_3578`.`r1`);

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

MySQL:

1197 rows in set, 2394 warnings (0.02 sec)

3. What did you see instead (Required)

TiDB:

mysql> SELECT `tl14db775f`.`col_21` AS `r0` FROM `tl14db775f` JOIN (SELECT `t1d90f49d`.`col_54` AS `r0`,UNHEX(`t1d90f49d`.`col_54`) AS `r1` FROM `t1d90f49d` WHERE `t1d90f49d`.`col_54` IN (0)) AS `st_3578` ON `tl14db775f`.`col_16`=`st_3578`.`r0` WHERE `tl14db775f`.`col_21` BETWEEN 2526.40073820865 AND 3321.717840116553 AND ISNULL(`st_3578`.`r1`);
Empty set, 7 warnings (0.01 sec)

4. What is your TiDB version? (Required)

73472c2f3f9625b02013c5e4e9be563bb6ca9ca4

hawkingrei commented 4 months ago

the warning in the tidb:

+---------+------+----------------------------------------------------+
| Level   | Code | Message                                            |
+---------+------+----------------------------------------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!' |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!' |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!' |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!' |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!' |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!' |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!' |
+---------+------+----------------------------------------------------+

the warning in the Mysql.

+---------+------+--------------------------------------------------------------------------+
| Level   | Code | Message                                                                  |
+---------+------+--------------------------------------------------------------------------+
| Warning | 1411 | Incorrect string value: '`test`.`t1d90f49d`.`col_54`' for function unhex |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!'                       |
| Warning | 1411 | Incorrect string value: '`test`.`t1d90f49d`.`col_54`' for function unhex |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!'                       |
| Warning | 1411 | Incorrect string value: '`test`.`t1d90f49d`.`col_54`' for function unhex |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!'                       |
| Warning | 1411 | Incorrect string value: '`test`.`t1d90f49d`.`col_54`' for function unhex |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!'                       |
| Warning | 1411 | Incorrect string value: '`test`.`t1d90f49d`.`col_54`' for function unhex |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!'                       |
| Warning | 1411 | Incorrect string value: '`test`.`t1d90f49d`.`col_54`' for function unhex |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!'                       |
| Warning | 1411 | Incorrect string value: '`test`.`t1d90f49d`.`col_54`' for function unhex |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'e#G7dW&F#*HP7!'                       |
| Warning | 1411 | Incorrect string value: '`test`.`t1d90f49d`.`col_54`' for function unhex |
dash12653 commented 4 days ago

UNHEX() Function will return different values for 0 (decimal(1, 0)) and 0.0 (decimal(7, 1)).

In the SQL query, The subquery's condition t1d90f49d.col_54 IN (0) is rewritten as t1d90f49d.col_54 eq 0 (decimal(1, 0)).

Then, during predicate pushdown, "ISNULL(st_3578.r1)" condition in the WHERE clause is pushed down into the subquery, and the condition "t1d90f49d.col_54 eq 0 (decimal(1, 0))" is used to do constant propagation.

https://github.com/pingcap/tidb/blob/f27b3c25b2689d5ed90effe14f5087a93b72d187/pkg/planner/core/operator/logicalop/logical_selection.go#L109-L118

Here’s how the constant propagation works:

  1. ISNULL(st_3578.r1) --> ISNULL(UNHEX(t1d90f49d.col_54))
  2. ISNULL(UNHEX(t1d90f49d.col_54)) --> ISNULL(UNHEX(0) (decimal(1, 0)))

The final result is always false as shown below:

tidb> select ISNULL(UNHEX(cast(0 as decimal(1, 0))));
+-----------------------------------------+
| ISNULL(UNHEX(cast(0 as decimal(1, 0)))) |
+-----------------------------------------+
|                                       0 |
+-----------------------------------------+
1 row in set (0.01 sec)

Since the result is always false, WHERE clause: (ISNULL(UNHEX(t1d90f49d.col_54)) and t1d90f49d.col_54 IN (0)) is always false too, which makes the subquery always empty.

If we don't do predicate push down, "ISNULL(st_3578.r1)" will use col_54 ( 0.0 decimal(7, 1) ) as args like : ISNULL( UNHEX(0.0) ).

The final result is always true as shown below:

tidb> select ISNULL(UNHEX(cast(0.0 as decimal(7, 1))));
+-------------------------------------------+
| ISNULL(UNHEX(cast(0.0 as decimal(7, 1)))) |
+-------------------------------------------+
|                                         1 |
+-------------------------------------------+
1 row in set (0.00 sec)

To validate this, we can disable predicate push down:

tidb> INSERT INTO mysql.opt_rule_blacklist VALUES("predicate_push_down");
Query OK, 1 row affected (0.02 sec)

tidb> ADMIN reload opt_rule_blacklist;
Query OK, 0 rows affected (0.00 sec)

tidb> SELECT count(1) as cnt
    -> FROM `tl14db775f` 
    -> JOIN 
    -> (
    -> SELECT `t1d90f49d`.`col_54` AS `r0`,UNHEX(`t1d90f49d`.`col_54`) AS `r1` 
    -> FROM `t1d90f49d` 
    -> WHERE `t1d90f49d`.`col_54` IN (0)
    -> ) AS `st_3578` ON `tl14db775f`.`col_16`=`st_3578`.`r0` 
    -> WHERE `tl14db775f`.`col_21` BETWEEN 2526.40073820865 AND 3321.717840116553 AND ISNULL(`st_3578`.`r1`);
+------+
| cnt  |
+------+
| 1197 |
+------+
1 row in set, 1197 warnings (0.03 sec)

Also, we can modify the condition "WHERE t1d90f49d.col_54 IN (0)" to "WHERE t1d90f49d.col_54 IN (0.0)":

tidb> delete from mysql.opt_rule_blacklist;
Query OK, 1 row affected (0.00 sec)

tidb> admin reload opt_rule_blacklist;
Query OK, 0 rows affected (0.01 sec)

tidb> SELECT count(1) as cnt
    -> FROM `tl14db775f` 
    -> JOIN 
    -> (
    -> SELECT `t1d90f49d`.`col_54` AS `r0`,UNHEX(`t1d90f49d`.`col_54`) AS `r1` 
    -> FROM `t1d90f49d` 
    -> WHERE `t1d90f49d`.`col_54` IN (0.0)
    -> ) AS `st_3578` ON `tl14db775f`.`col_16`=`st_3578`.`r0` 
    -> WHERE `tl14db775f`.`col_21` BETWEEN 2526.40073820865 AND 3321.717840116553 AND ISNULL(`st_3578`.`r1`);
+------+
| cnt  |
+------+
| 1197 |
+------+
1 row in set, 7 warnings (0.01 sec)
dash12653 commented 4 days ago

Hi , @hawkingrei

Is the behavior I'm seeing with decimal(1, 0) vs decimal(7, 1) expected in TiDB? If not, what’s the recommended approach to resolve this issue?

Any guidance would be appreciated!