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.

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

incorrect query result using range partition #52198

Closed
wjhuang2016 opened this issue Mar 28, 2024 · 5 comments · Fixed by #52210
Closed

incorrect query result using range partition #52198

wjhuang2016 opened this issue Mar 28, 2024 · 5 comments · Fixed by #52210

Comments

@wjhuang2016
Copy link
Member

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE `tde5cf9ab` (
  `col_30` json NOT NULL,
  `col_31` json DEFAULT NULL,
  `col_32` tinyblob NOT NULL,
  `col_33` json DEFAULT NULL,
  `col_34` varbinary(487) DEFAULT '=HIwIv',
  `col_35` bigint(20) unsigned NOT NULL,
  UNIQUE KEY `idx_19` (`col_35`,`col_34`(2),`col_32`(4)),
  PRIMARY KEY (`col_35`,`col_32`(1)) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
PARTITION BY RANGE (`col_35`)
(PARTITION `p0` VALUES LESS THAN (0),
 PARTITION `p1` VALUES LESS THAN (14464107896361403404),
 PARTITION `p2` VALUES LESS THAN (15474042590907512091),
 PARTITION `p3` VALUES LESS THAN (15569789118590293107),
 PARTITION `p4` VALUES LESS THAN (18241271968789361726));
INSERT INTO `tde5cf9ab` VALUES('[\"Wz95PLRQliLnqOJGrZvtn6QcHdkxwyCI1fSiemUMuA2ghYHm6jBNEhEPIlIMMEMz\", \"GnUTig6aDuaTQxMHstD9JOiyVsMhEkDjmtwaUEVgiLL0reTKVSLSKsU4M1arDHaq\"]','[\"1vfZndKPtTkAOKFPQTKwSGGuYffnjTp7SILcVFGxLTA92YXeus0BRsIcY3kOc9VO\"]',x'2569517e3d4d704833644e5f2474466b','[0.4646976615861493, 0.9582927604035303, 0.8908512637173415, 0.8300351357548978, 0.6887815225915662]',x'7374674835743d7a31364e5f68',0),('[\"u5JTCUFl754vdvEmaBkSHkyLVHWHxLGWWAY6c8KAi4KR0mp9Ab4Y3J85S3fEciCt\", \"dfJAjmFMLb70UlMq4OfaT7yftdHf60GL1Abhnyk7bG0FrppVnnIhYku4t47esr9D\", \"qpRAR3qH3auqpbckbhsFefPgPXP1EIdEwwJnCet0XgxIDKOhJRmfbNRkpEMoz2TG\", \"DAoKZ1u7AKkE6TqEspAyiPHkAS5agfZQpwHc6dCMIpUIYZiEbbAvBvTALAhCNDFH\", \"oRQ4Aa0qjcLjVNGGBlwapfcegwF5Ptx7gVXzjOuN0hKs9w1UcTY76Bh5VcGE1WA7\"]','[\"HBcaDJIRVoKChADMHZQdayCtI7OndTYG9Jof6ZS2Xil2xTDnnepfigmKxeQWtlhA\", \"htuR2wKGpH4IzV8EpESYw5Dnof3Nwi82jHqlPgTLkK4h0C7CbbdEG3t0JDDKSUrL\"]',x'5e6a72704534402d3d4279543436692573','[0.17975531139017437, 0.6062629203033233, 0.8599170333050206, 0.6715847819290429]',x'65534a2937365444777578',1567779204212634758),('[\"bDfqRcm0l11U6i9eVYvh8MpjGbTN9Gca1XOZd9tFbjesUcz3mfozwfbuKhQTp8Yy\", \"y4spfXHabhDgNuZcvpmkIRmifuMbis4ACwERwFlPd8zgbhDao1DRu7KCEOoiOnZy\"]','[\"mGnKFNVsbxkL9NtWUD7RgoHCrWKHteHRmWIXqT5wnAvw9vHGUO7jXQRrwHuFie46\", \"me1oaqvBYRU3ynvnucfndpqg3hSHDMCKGxgngL2GkgS7hh6BYxuR24d0C7agbah0\", \"hxBpysKZIpnT6OdF7rye0yU6z53PGgd6yZxgHBpUPAhh8LReQtJ4TPEmtfVvAymI\"]',x'','[0.5007290180382064, 0.4657942932163316, 0.04236859852868916]',x'2455',2396287314775314828),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]','[\"vrAsS6t9Mdbo4McCAGz8I1u5QyXualbNsr2mRJlvPZXKDYsMapsR7aWSgkhPHfyh\", \"16HnAybO4mviImAjbp690tSnOUUVWsny7wijuiQoP0rqK3zNtThJKR8j9003EC8D\", \"lizUlpEZ8vbNT5BSN3ZmMUtHjc7Dt2F1ijaaks2cT2iJDhGrKGrX4ZCIFMTUWWBJ\", \"ZtJQDrKfGJaN71oSazvibAU2aLhdNntPgnUaCx1SgGRpX9BQOwDQP4FDJGYiMZcq\"]',x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',2684824597501773396),('[\"yxH9jpm5YK3yTORfHYpuwkh72ncXGWNGrzsWAdz0W9T7faOQeLW2tOsZiBjUNfO9\", \"1nCJv3aZsIYdMCtDS7rBynyU85Nagj2wSf6YsfGFk4QQ6vgFPzdFYzS26adNhesZ\", \"6GrzbuH5ZsdnPoFBq1UNhfyXITjcvPArfwrMrg98IOjewi1N1A08qre3xSrfxa5B\", \"hHKUq5H6bmgwmlr9yg26ixNd5lv38vpzEaIcVHqBoB9DgOqpL5y2hrfj4nHkNV6w\", \"EST1SKjQZPQJqo0zAPuvMpm6x8AgURwpReIQL5nxDKwKkRyr7xSIxe1iNwHwqryg\"]','[\"Wd2O0UF3sAwfarduwMGUApoV6mgXTl0XKLH21zT618l6FE50YbGp3VYIUdRMLInr\", \"thuGkVfKFdH8ubBvLYVvnBlPwSxe4Uu1GO4gBP7wTgRlu1hXO0wLw4H2J1h0Acqu\", \"f925VFkYcnCOZPjXUdUBuRNpbs63wRrqaH8SGMj4XWDdxKoppfq97D7St7sHtGpI\"]',x'2641326c5f4b6f','[0.1655914412460885]',x'72533728462146365965',2771059760938128257),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]','[\"vrAsS6t9Mdbo4McCAGz8I1u5QyXualbNsr2mRJlvPZXKDYsMapsR7aWSgkhPHfyh\", \"16HnAybO4mviImAjbp690tSnOUUVWsny7wijuiQoP0rqK3zNtThJKR8j9003EC8D\", \"lizUlpEZ8vbNT5BSN3ZmMUtHjc7Dt2F1ijaaks2cT2iJDhGrKGrX4ZCIFMTUWWBJ\", \"ZtJQDrKfGJaN71oSazvibAU2aLhdNntPgnUaCx1SgGRpX9BQOwDQP4FDJGYiMZcq\"]',x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',4158046210744577520),('[\"0zibTVWeikmgdXgdqg9jISmp6oDhYj78JBubXPcSuIr6lhqSkNdte8NT1C1bvcFA\", \"QYO5zzajsMXcxS60rlVLGC4iOwyZNxsUOTMA5Rpe3r8aN4ABV7fYR6MlJWzkwz6p\", \"lVGdBE1xiv0h4wcJac5Fks6rVTQiX6uJgrAdTjqwYzEcdDIGZqNPBdXHLQat8SDs\", \"0Z8vWwyKTsJXNWnXUKTGadWKU1He6hhpvO2n9JM2BpTlqa2vlqIWhYJnjwhCNgwd\", \"PtALIb8AFWahBJf8KnRB3BZBUH16GiJUku4RUPL6wjwBDAN37w55kucP6Vck48CD\"]','[\"YJD1tDsMWnFIKCska9b9KAZ57hC9G2gbqQ7E4yNd3qIy4mRREbENNlRT7ztkyq3A\"]',x'5770597250774e6534712372','[0.292880490089004, 0.7567811197142162, 0.4579668859908117]',x'302d214e5e424e67',5118930515042638219),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]','[\"vrAsS6t9Mdbo4McCAGz8I1u5QyXualbNsr2mRJlvPZXKDYsMapsR7aWSgkhPHfyh\", \"16HnAybO4mviImAjbp690tSnOUUVWsny7wijuiQoP0rqK3zNtThJKR8j9003EC8D\", \"lizUlpEZ8vbNT5BSN3ZmMUtHjc7Dt2F1ijaaks2cT2iJDhGrKGrX4ZCIFMTUWWBJ\", \"ZtJQDrKfGJaN71oSazvibAU2aLhdNntPgnUaCx1SgGRpX9BQOwDQP4FDJGYiMZcq\"]',x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',7276349901697860502),('[\"sGR526YdamJtUSOYwZEKdTxnNnmmLNBnhLk90dFPLHUocfzv0AQZPo9eDaAe8QAL\", \"K700JUnSJ4lB4Vip9e6ItNuicTmj9kjcECbXNE2YfQC5UwU6FjkGKNXI0TwUCCZz\"]','[\"UneqxjxBAxUlfRbSwZdwFLkLzhwpRfgDi3cX0raT7MPFHLj2nxauh1svVZgmJZ4G\", \"SI3TKHJsiidlzKSC3YVgU803QcYSlsU4Dhx7rvmkKny86Mf8heNMVerAQpUa46B7\"]',x'','[0.795118973877717, 0.9035005878221954]',x'737476526b',7694033135187929276),('[\"hxpXF1wcqpseUEEsaKmHHeGp2c9KWDz8njOkkIMtML46xANdQO9eqvLL0sIyWbcs\", \"8eX1Bli9sDUbx14mSB0grkn76HIDt7GZKureM72XIoXOl7D6Bm3fC8CNpKF5toSr\", \"moCSChSTzLz3FZ84ZMFwL0Ix9bOWjgE5VOqDCBLixh6FvErQ8taIjyd0P5Z2ehAn\", \"Ft0ZmxX3NMQbIBtZAcq3xEg6yBR5wnv6iRvtxGZw1dkoOziP7zMnB4s94cqYvhIJ\"]','[\"kKNsILLfPSoWavnl2LNE6fkKllYqaeqTj4zIS2lTG2d5O0F0e5jHes3Ua8GgzUNz\", \"eyOsTY1hmZgfg4y2maHbTMh4AdfDcGj7VrecfbagS1xJklJGV2NtVCtR9DsN69yj\", \"BZN4SWVR3MobJQsB5PjE6Pv9Q0zeReEoEIAq1ICYOR2ROGW6wsh3R41mHcsf0RZZ\"]',x'7773266823475072','[0.15744289393856822, 0.23338231412982055, 0.22757162912768308, 0.38605872273044883]',x'5568235877757158795678',8021484697390902738),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]','[\"vrAsS6t9Mdbo4McCAGz8I1u5QyXualbNsr2mRJlvPZXKDYsMapsR7aWSgkhPHfyh\", \"16HnAybO4mviImAjbp690tSnOUUVWsny7wijuiQoP0rqK3zNtThJKR8j9003EC8D\", \"lizUlpEZ8vbNT5BSN3ZmMUtHjc7Dt2F1ijaaks2cT2iJDhGrKGrX4ZCIFMTUWWBJ\", \"ZtJQDrKfGJaN71oSazvibAU2aLhdNntPgnUaCx1SgGRpX9BQOwDQP4FDJGYiMZcq\"]',x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',8260625723957049473),('[\"ZE6eF2xv1xkFuctk2AigidCUGkWKyI4SK0XW4895CtiMMPs8B2QPXL2dfEDqsJcU\"]','[\"5HcaARgbOJCStbIpffLbH61EWe5GD1sBwQ5aQNf2Lm2Rb4cFaaSt6hzVmgxBGpin\", \"7JN1NmQhMweq5633H3mVdYcXT6mGrV5vAaMABKugUhp46W7t0dgG7N6WUymTw8UN\", \"wVM5L0inrOAOWX2vIv9ODUZsVIy3eZxM6K5UCijEGhGZFcVEDiD9SownRzmxFYFr\"]',x'68','[0.049974563594808376, 0.09937511263049388, 0.9712576304190343, 0.49960134052404304, 0.2555888361215715]',NULL,8619475224050794690),('[\"U2ZqVY5zkdMro0ebGJ7QA2xxBszk9ENU2hZSOjGxLc8mcIQfqjVOplLCekLQPiKr\", \"n7g0hle2ZUEaxf34rkpR74QoD5nsNeX4AS93XEkGzB12k2S1UDo2go02vCokCAVn\", \"6oQEVfnkNVPTcicvyNatJE7fvFR2ygCZgar5cbPOPESfjKhAoyn0PEmE2knI3I7T\", \"Bj2icvUn3SXt9vsvuFNW49zc5ZpTG9TtnKzZAPnK8mhmc0AmqQrkppF5ujvW2uEW\", \"P6Rsf13o3Iv6qqSQWOOJKkQeg6hpp2RnFMGafL09yaaKh0Df8P1kLufe0iNRr8FR\"]','[\"TgnEstp7XwchGz82F4j73GztPybNbScQRUOpaF9RefyHGKZiC8Fps2ycOnpmbqCs\"]',x'55715079686b36','[0.03648504120105657, 0.7663623552993745, 0.5252041401881107]',x'5e6c3d4d457468294e587e',9053556814446246053),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]','[\"vrAsS6t9Mdbo4McCAGz8I1u5QyXualbNsr2mRJlvPZXKDYsMapsR7aWSgkhPHfyh\", \"16HnAybO4mviImAjbp690tSnOUUVWsny7wijuiQoP0rqK3zNtThJKR8j9003EC8D\", \"lizUlpEZ8vbNT5BSN3ZmMUtHjc7Dt2F1ijaaks2cT2iJDhGrKGrX4ZCIFMTUWWBJ\", \"ZtJQDrKfGJaN71oSazvibAU2aLhdNntPgnUaCx1SgGRpX9BQOwDQP4FDJGYiMZcq\"]',x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',9223372036854775808),('[\"GF9ZtEYXT12NeZKhbbK2CsgHrcEeqIce2ZDZfSzFJ5ERE983EiCsqYqCccrL6WiA\"]','[\"p4UlXvXUJEUc9iD9hZVl1xuo5ss3z2Q1YdIIVBBv7s7tk1Z6Eg9H49beduHQHGtS\", \"uPViYZfMAsif3QuoVGga1ysLPKB7lFfhxUPK98rmilpEDklg4gIkQshf8HlO28rf\", \"9c21KhAY1illzi9oDnmUtF1BPjjjKHugj4HVlIghVsqseMjZs1JZfTY1S4mJe3Dy\", \"lqZHsZx8UprThGfVn8s38dRkCRd8fpDP4PwoTw00VaklJp9Plo5OOn60rTD26jvM\", \"Ze5tUXSn5u2GrmPIvKdsh4QrXVGYrC0zpL17i8Dm1Jl9uwu9pDVv3yiM9b4v4td0\"]',x'485a247e4158463364366967445e294f695079','[0.11064612299736534, 0.8731056303073097, 0.8765364700727529]',x'30796e4564377825',9223372036854775808),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]','[\"vrAsS6t9Mdbo4McCAGz8I1u5QyXualbNsr2mRJlvPZXKDYsMapsR7aWSgkhPHfyh\", \"16HnAybO4mviImAjbp690tSnOUUVWsny7wijuiQoP0rqK3zNtThJKR8j9003EC8D\", \"lizUlpEZ8vbNT5BSN3ZmMUtHjc7Dt2F1ijaaks2cT2iJDhGrKGrX4ZCIFMTUWWBJ\", \"ZtJQDrKfGJaN71oSazvibAU2aLhdNntPgnUaCx1SgGRpX9BQOwDQP4FDJGYiMZcq\"]',x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',9748215865553509859),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]','[\"vrAsS6t9Mdbo4McCAGz8I1u5QyXualbNsr2mRJlvPZXKDYsMapsR7aWSgkhPHfyh\", \"16HnAybO4mviImAjbp690tSnOUUVWsny7wijuiQoP0rqK3zNtThJKR8j9003EC8D\", \"lizUlpEZ8vbNT5BSN3ZmMUtHjc7Dt2F1ijaaks2cT2iJDhGrKGrX4ZCIFMTUWWBJ\", \"ZtJQDrKfGJaN71oSazvibAU2aLhdNntPgnUaCx1SgGRpX9BQOwDQP4FDJGYiMZcq\"]',x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',9760468490470693505),('[\"ibLT8YJCusPeM36bwZ8flDqvrwncGj4730bGqbzqHjFWLnXRKsXvE9CdZ8gifFYm\", \"k7VNMj80mJ4HRbpDcQizKqe1beWAzrsAoOcCauR3YggcQ3Sf8oVFUrpEy6EkXfLQ\"]','[\"dAMuAgDBy6xFWt9JX4X1gxXD4iIG5QClasUY5Ln6sWIVIs2R6AwWomqwAzL9UcWp\", \"T2bRrlBfj1q6qDJsHrgEqAf8T1qH3IbMrNN6q0D9ZrWaHhltnInsZ1sGcKqBN5LG\", \"2oikAXBwn3TTQWCebiIGL7pD8o5I21ayl7TGwjgmSpTOJKXJmixEZlj3FZr8aLQR\", \"Wk8GYscXO8g02nWhPsXl2xjSFtm1hCIOgsrNRc5snDkgmnsoRDKlAgFS9GJh1Ded\"]',x'4243384c54','[0.20617946807749404, 0.501261699058806, 0.511250618115637]',x'347478653d4f765157576f4c',11461170185469616451),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]','[\"YJ1zBBialzQYBXIWLg6dkwARF9YOEON1y3gE4V2uRBxuoIFy2aGWfJEGC1bta8uk\", \"fJtAQmWYSwU9vM3aPkN4nl4VXRnA5PIfDSpMAdHLPoBwh3LmcBJ1sPgPug8XAd12\", \"V8q0j3QUgoZ531HSOoHNUqeYbXN0MhqyN13llN0pUHNesRBC5VdPPqqBIfW76FyX\", \"SB0LId8OSyOnvnq0DSpXSenUF0B8oGeOunkYFEl7EW2RGPYzfI8HFHOJDqkMbnZf\"]',x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',12344579753288860388),('[\"Mi1Z6BKd9WHOMyXHLJjFUhkBJqh1nlrmYFTWOM7EfFgK5tld77QoG4V3dLKXYrbU\", \"0mG3OPJKeYRyNdKrmiYH71l2FH9aF0vv5IFOCMr3LACEmJeK313UwJ6qLKqkdu1J\"]','[\"pknA2GfUUorCx7OY9s8PzftK8wHUnJK3LwPEzCLbVevTk4XrIWW7jDGHeCe1JfJ6\", \"LtLpHxI3jut0y6V9YDCSURHtiCmEVDZi78a5lHae0bywKo8lktwsXralsgliii4K\", \"Xx1JHro7JUn7EHcXSY2GT5nTGqV5ku7sNPMXvKYr12mRoqnyD5Uc1zwfSS0e37Et\"]',x'6c34416c456b6c','[0.5861391292409713, 0.35223440118823224]',x'6a2940535a4a234c232a4948346e6d582447',12471124777815378375),('[\"pT0Z2py4vhU2Sn1fOO1YAuw7ENHquSAyPfK5eEr6oaTj5iwjLEbCnTKuhBeFkdxw\", \"ns7Smz5MZonhHVveySZ6gtXSCxaPGAqcdtvlbf342Rkwxen1BdVHvfvsT1B0ORXr\"]','[\"IB6mxUgWNOb7AnryUcEHYZ0mz7VJoswK916zfgLJNhA9iC7MIoVoexpcVZ2NcXxM\", \"umQrHSNLveU86SeVg9gK1ShIwK3goQ9GrPixVvlrs6uWk32XyA7BFwBKG8Ja6L1m\", \"5j5VjJsH4zQMHzijTX9oKAfKZto0gIPoNS0mhx64qJVIUvm2s4yBLlAxfDqlbMsb\"]',x'2d5f482467594569795726494d76787355','[0.16902177794671622, 0.5850705243340889, 0.3451077790787441]',x'313361',12566881072169831726),('[\"ZlyKKYCLmTFbvbe6laelF7Vc4PXQkNqgZC0LSX0eyDwTVOIQdgakhu5XQ3vzTb1s\", \"tBQu8qXDz8bSbJiwqy2MyYhW4nW1d5kaoLZro0N0AumU40cXe9GEMlz9fFXpPqjv\", \"iqaJdEepzhI5p3jXebhL4Q6dMr6CwAOUVoYcMKei9qex9wQM9d2Kt4Uffb4YP2d0\", \"XxqMpC8ErdxIeRz14Sl3vdxbcQ1ju90U8mjzoBHWAuVKp6bqOVpvMAIclJXrv094\"]','[\"vn61BMecMvuo2qRApVnfciSRJJewcBRsKpTIgd6FLNIUFiADlJkYxtvwsPk47D1Y\", \"RRD3FI37yr4eBl6abi5vDWmdVoihIGtXkX7MQJ8lsp1Y1iBIkl6iM3Zj93lX29Bv\"]',x'2a245e325a6336737261292a7745','[0.6055285446218888, 0.2335982396952773, 0.6773961776160401]',x'7753587843',12783910262735102564),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]','[\"QIJk1vdVwX4wZigmX1sUfMKk00frsqxze8kzHm13541YXH7frbxZDZ0qXzxVsoQe\"]',x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',12910485282430732282),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]',NULL,x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',14272632288117041381),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]','[\"vNJZV4fsg3Pex7J4a2ZjM9HYK8iVFM1hdjHuXSgFqXkBIsE0SKzlnU07SVE1P3bJ\", \"eIoW9lRfjmaqcFwuwmgYw5od9I13JYyf6j7xPGfDkdgxcxNn8ZyylsrKMhIsZhqQ\", \"wfAxKVMxlA2KU3jE5f95uFnn8Ak93bzOpf0BTtfzO7sZFAQMcIK9TC0ueMBaokQY\", \"SY9bV2CSr4sri7fRfZqf3hOtHOt6sGrF8GwfCZVuxVOGSG2QNoQviPQuoiFXba0T\", \"Ro2Yq9sXOyeh79HKqKa5U0eKDk2HQ2wk3t2nMrrlez8ppR4a1EuADl0NACkEx4aN\"]',x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',14679767536905291788),('[\"60cLTQsk6aibsYBlEG7abm8NxcNYWpNf5RhEfFwOAAZy2HVi5rDiPlQ2CufCYM3W\", \"ALjtWgUF3yS6lY6zTqyAo40IXoIhE5dDa6AkBQDKBkrXjijz0bSQs1GKusBpDJ0z\", \"sjxgsbgRsvwrtB8U2TtK6sUn2XI2t4unckv6uO94iEAp0hrWORBzXCOiAknXZcMX\", \"Hjcw5gAvD5SvV8TmHjEiBDWJNZjGanrVej1TuWwl3wQ7pzkT5IizgQZdESomeyln\"]','[\"Gppsen7flRuGCyZnTqOz24LWbKQXjG4Hrvcg6B0xoZOvYeqU7JudtreNYwO7NbJM\"]',x'406532253549266348','[0.024834158705199283]',x'687857472932564d6225455079404936',15069582400360190992),('[\"gA9hl4RmccU1Vv6U6WIshs2lknzZ3QUIS8U0To69oOMug4l0HqqbpcxfqHnQ4W7w\", \"gKgDfyST3772fOsQzZQk8zvb3TuKPXBY5bUHjk27nSFVc1EZYnVuCOazB12ZO2O5\", \"VOBHTWkKimH231z4bRXIIInNEhP5NwPdomtthOUZy7Wv44rKvOGAxQmXOsElhZ3Z\"]','[\"7QXliYgvP2aL7LikmZIN09BskWqa8uCdxn54YxXhv3ceHWKlLFiSxsxK1oyLU1kS\", \"BaiigvPJFbCXVvqWV8HLk4fn5YfU01PmJ60jHVVrKqgy24oJaZ0QD5UhMW5Z4fxe\"]',x'74286137','[0.45837587966902954, 0.8437973281029107, 0.9710229823136485, 0.552103424629388]',x'28336e4f6528502172',15286328840732975636),('[\"OxeU4vGCNXJiZV1LYdkk9IdgHkIduJww0lW5fJ6PqeWLMyK4j3QGRG0r8jFIHUXm\", \"5HlOGYjMWMKcpGh461GvP2eX2T5UNnbxGXu1lbysfEF6syzgx2KtNYUut3K0YLfn\", \"ExBqAYaCfoi98ZdjKqytg9lqjlchIaIUacaPsuotSwFDzbORB0e1Chpvs3T7vHxa\"]','[\"YR7px824YytWCF0e8MDHrc8A5cnNm1EcZewhLzgtVojrZvNktQBCNg3VImgJtuRD\", \"mRESMvC5YOYaz7ETUxeyX9PrY1mMjdOnSnBU3uHauqjIAs8xRB2weXLIpl566m4H\", \"PbQJ1OZhiJEprQjbl7XFCMi5khDQSgg0aqJiAinve871YsYYDJKZ62ehIyuN24LZ\", \"RwfQOSxLpZ8UdcRli1zEfMaZzN28mEtaxhRDgmF9HqSmrA2Cav2n5XGHNAWDm8as\", \"i2pxIF4oAX1mP1C4carlTR0d09fXo8LtgbOUfXOmR4vI99zOnrezwJnhsz3IaV3v\"]',x'79594b3d4f70565e52','[0.8123190937332948, 0.03258766664706177, 0.2473114399039884]',x'6f2131256f744c636e2b3159484e',17073126758539490309),('[\"ivpvzbZ01Aqn2NdI2neW83CUmhlH1eWJ8eAHEUPEOwsqFNdmTAwnkDNwQ5kGHxji\", \"4jpPcVr0q3TY36jO3gdr5wp7uC1HZ4AWRLm5I0FLWd6vdQo3edGhO1AHIyrlnOuv\", \"dPbZ5rDle8Ko8laaLH4myRZesem8cHusJbvroETh46GIHsUaeyZn2FSLFimGkgFN\", \"ngRMkumeYOE33W8PrWHObpf3XfDcOengd9v5o5rIvnCakw0qbkZdIzRooj073UNa\"]','[\"eJgs698yTVt6CDctE6thrHi2ZIItFRFGeOALaugRMrmS6hlHBDx86cNonUvd5vdQ\"]',x'326a302a2d4145245a','[0.0659237005318939]',x'7a',17910151681881588230);

CREATE TABLE `te508771b` (
  `col_87` varbinary(38) DEFAULT NULL,
  `col_88` varchar(439) COLLATE utf8_general_ci NOT NULL,
  `col_89` decimal(12,2) NOT NULL DEFAULT '15300',
  `col_90` char(191) COLLATE utf8_general_ci DEFAULT NULL,
  `col_91` varchar(43) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'jT(vJPvYy',
  `col_92` double DEFAULT NULL,
  `col_93` tinyint(3) unsigned NOT NULL,
  `col_94` char(220) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
  `col_95` varchar(365) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `col_96` json DEFAULT NULL,
  PRIMARY KEY (`col_93`) /*T![clustered_index] CLUSTERED */,
  KEY `idx_41` (`col_90`,(cast(`col_96` as binary(64) array)),`col_87`),
  KEY `idx_43` (`col_94`(4))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
PARTITION BY RANGE (`col_93`)
(PARTITION `p0` VALUES LESS THAN (6),
 PARTITION `p1` VALUES LESS THAN (195),
 PARTITION `p2` VALUES LESS THAN (MAXVALUE));
INSERT INTO `te508771b` VALUES(x'45397470352355457625','lN俌z荳柿',77.12,'','y#F8IoWhPlYw8nqGI',5717.836515431098,1,'譆5錼獄fy6禞鶏E臾%旨','3ovXFXxPFJ=&B22i%=Y','[\"6s1YJEdbaleKr8LGVYkAVAK4OPh3v6mLDxkRaiSAP9S8uZ75x7rRG1JVdK68n8yn\", \"pXO4J8gB6PSaJXwISvBPbSMf1VmnZcu2ml3Tgp0rMAV1WxA3ZhOk7JaHRy9FPRhz\"]'),(x'45397470352355457625','_J鍭玼xHt&Zk免rw貾鉑#',45649.10,'','~ya$1t5TVk^1OHE2f',6838.942573493885,3,'詎~*%p6棥UsVP畡縼_盾','3ovXFXxPFJ=&B22i%=Y','[\"XOSADpJLP5WAVoKW2Yaf0h3wFTEshh60NDm0cNpjuQeShaTzIKnthPJidOtkkf7z\", \"dlMGj041ljldxN1wA735aqzPs4Ef9yKsFfDTBtTQADnwCKLLE0zp07fQQhI5leaQ\"]'),(x'50266a3343362148492d676c773659','5v=+',87.70,'87w撨衺梸導0彪wO5螶o揷0g~p','~R',870.8013953946693,5,'0樥扊#挓bt溙泮A','',NULL),(x'45397470352355457625','k~J',1267.60,'UY=r28t嬞5&r','1XjUFVD_BgI',6838.942573493885,11,'rzUSS轐+蓨鷚)','3ovXFXxPFJ=&B22i%=Y','[\"I4rOzvv3PGRXSni3hcB36T0dWXKhMMQE09ISrbsCtqXSPfGHl3te8ITxWpjMN9wx\"]'),(x'45397470352355457625','Ml#4疚1(蓵)',29.35,'m樗鼷%5','euQDDgAD',6838.942573493885,16,'DLHh#t儞W+$非泣RY獓睉溨','3ovXFXxPFJ=&B22i%=Y','[\"yLlgjrW3tdIENXJh0bfAuiLdWs73WsYLfW8TFdaGQPWxwMiWmB5ZyHaIpLtb8pLg\", \"koELACEfWJiCEF5MgzoV6M6gqau0x0lJyprp4wAWQUXPA6xs4CGS1VIisKBciN1l\", \"hFmIOaH1qtrQrdHBWMY2OKy4JpF2c80wqhcBgBvv7TpAnGHhnaHskiYR3cd5QyeC\", \"9qEY7RtWlFlpkfu8VM1G0mfz0Lw7HaWwYsW7jifVMXUYZ5L48XOFdhCfjPzKLWan\"]'),(x'45397470352355457625','m^畛9z淚緦C',2032.33,'s','lr+YImI9',9809.290737797808,18,'~0rq縊F1jW','3ovXFXxPFJ=&B22i%=Y','[\"pYkVduzpnODiRiYAwvsTyShia6dBtJZeomFfJqUEhD7ScJBtPdAfNIP1e93PyqM3\", \"AH3aqctdGEcNjXfvZNKboHZkpt6NJEiBIn5W20t18X5JxeY4BXsGaOsaQuzcme6f\", \"UOqukg8gLvpqfyPYNguocevJO0V6h2OErrJIfAFtOoZCoDGZCcOi3WlhzGoaUcTO\"]'),(x'45397470352355457625','Je互FVrT$',0.60,'虏讝梉*G旳NF鐱o櫴#槡C8','=',6838.942573493885,22,'Ai螺!胒G嗊wlH樽R&偱漗','3ovXFXxPFJ=&B22i%=Y','[\"aqYAqToi9F4px8jVLCY0OVsdl5PxP82voRbk5v0yMoCGaWCMWM4VQi6hndxTPeVo\"]'),(x'45397470352355457625','XKPV@NwE鬻D',1.50,'N8蔇Q畿q終俠_K^','v%C=7fdH',6838.942573493885,27,'p(祒W6f=w$估炳J)A睤YMl暩','3ovXFXxPFJ=&B22i%=Y','[\"wK9DlJ9nBJJD5eZ2olIpqnPMOgomVjKLntJQ9V53zoRrSJTiC9CDgTH2kVwQP8V7\", \"V7K21CvsBSQspkE4JWvuoh0M90nW8BLtw2LJnQtnd3MYKX7lG8DM84X7DPm99Uhf\"]'),(x'45397470352355457625','V%*=g9咎',6368.90,'(产勜_j蠄#j虢o畦顼z嚄0','vQZ8MSE*fQhWEU-6P',2302.9774232879035,30,'oAK*W肚掓WX庲窿bQ枨t','3ovXFXxPFJ=&B22i%=Y','[\"ONQrAX44Al0WXeWvif4Gb1VuHdiIPC0DQq75ZTkSzoPmenFhCbti81a3b44erkTo\"]'),(x'45397470352355457625','e牄*',0.00,'鯣#p9-^萓n+','*',9809.290737797808,31,'U89鲡r煑','3ovXFXxPFJ=&B22i%=Y','[\"oxHyyTajHLwjhdIrq5JHfmFkiQvg17p5dihzYofHQMZ2intpppaaNbRUGbjJV0Xg\", \"7vZKrtVetyjimTUiQ92iFBklmCv0RE9iRtnojgaYbNQj3jRObnzM0he8bxM96lau\", \"cmPigGpSrMoZfJiPL2Al4puBkm42RBe94WXeac3vT0I4w1oRSQGURtQmo3EDlsPi\"]'),(x'45397470352355457625','鎖殪%岽譬鴝mfR7_P狅n',23126.42,'','ODd@s(1mBlMmb-',5045.973260921493,32,'sUn瓄S惚exh箭3*僢r3-k2褂','3ovXFXxPFJ=&B22i%=Y','[\"eUk9sYI3mL94b6XhJ3w96deeoHGBUmOIXyAobOg1JlrJwhRv50vJVjEgP5HZmPXG\", \"h5KU5FshWfu9JklCVvzXcxAFtmJUaUJKFUAAcC9rdA8bSgD9grOlYjkuGtRzQHpU\", \"aYKEHqx7oAZl5F8DBRFouXbOSqIrpis6ecDU5i7dfIkiOFA6fRRhxzZAQfYjdFdr\", \"cbNTXetH2TY4DT8OIekX0eTTL2pBxcbgTfJw2FRwpbc0345VX5T6Th4iSBvQUBnG\"]'),(x'45397470352355457625','p-oBmWvG渰',9575.00,'o','SmOiIJ^vF',6838.942573493885,34,'噊曻b^pUU','3ovXFXxPFJ=&B22i%=Y','[\"QFAVtLry4MTn9viyMSbxwVqVGsamkCBGCKN7K2Ud4uWYVK88GPjot9j30hR9fwNH\"]'),(x'45397470352355457625','l1ArQP卋守',8.30,'(绮','Om*~6L!',6838.942573493885,38,'lp7业f34f诲C轲萾Pc櫍I3q','3ovXFXxPFJ=&B22i%=Y','[\"5BcnE2sSTfCFWIRpQVMPIrMuxstKEys1acTdE9YSkKmS0eMcpjSh5oxXJAr72Rmh\", \"G6tBe0NciJrunpMtAxPrjj9Sxd3YbdenJ6iCcdrrChg1z28pCyZx6cDm6mfHchEd\", \"G9QwGrYXBWlrsCSYPqTp1ELRRTd6vBbN7Ua6aaRHF5G4r3YYtiT2IMxhtnDQLG9H\", \"QMZRMr6jXViZJSdt89iZ8PC0XCLCc52kTS6j9NKu2vMbZq7oQgFo1QOlZA6ePxJ7\", \"Z83CUjLj9ra0pAkGdEnLYtGAfPD05QYnyFwMdzGpaNGdBBDjt9m2vN4CIADAVKYv\"]'),(x'45397470352355457625','Z媪罦逥*I',6475.50,'R29&JC飧笞峚1綹犭讪DF','',7738.4970491042195,47,'r','3ovXFXxPFJ=&B22i%=Y','[\"s8SKVGD5euYIjh4Uvhrg2BnD1rSww421936zzQHaaevkc3yBduvr4rsYq6E5Onzw\", \"DopryFpmWqEsycFSXsuYKVMxavNaedvc65sKPBhnbMxvfNqVl5bwobbm7l6dXDvV\", \"8dVfcFuiEtZ3cOOYXV6ur6jGcvIaH0NOL8mjOkQETESXpdXq2I6UruDJcdyPfYpX\", \"ZMdaWzqAyPuQM96xDt2B0eWJBDplGiSQwGAPUxi2dndVxfQExGOaE7E2pmnaDmCZ\"]'),(x'45397470352355457625','S',68.69,'奃S','ppIFZ5ce~su',6838.942573493885,55,'','3ovXFXxPFJ=&B22i%=Y','[\"gpnm2m8beo161NlYhG7jAg3WZKbUhH1KGAr2sLY9PHNkNLcyFyeacEVdOQjk7Xc1\", \"rGXr81A0cuIlwxbePTaRvvUOUDwaLN5hPwUEs9GwIWx9AeTiDHtuK94dD8hrr9BE\", \"xycB5jRja8I0Pv2vMb4iiC602lCrKgSlZcA6OHWXORtcRriCrzBUA5F5NgyF8iec\"]'),(x'45397470352355457625','4$@D8xzkg炤L淖J*',39758.00,'吩哺觼$9PK淠昦馏VbW','IJV6^8jljN=Eq=',8675.40167320168,57,'','3ovXFXxPFJ=&B22i%=Y','[\"8zOdxF4omN1gfpTepuQYoTvwwgI2VuqojbWyJPTT5XNGSuPXM1Zvci2YimF662PU\", \"4XEC2Tao6fWyEgw8xouuqsHLdvj6TzqwRLah7UhLAMZ0j1mzRMm8dCaAKjpg0XH5\", \"T55skVVwYsN6TQKrQS5yt3LOGZUZwNMJzWh7ubF7tKngDUyDVHUXsqQm3CUHizw1\"]'),(x'45397470352355457625','$(2鉲%hl弮d姆浛g5LKD(',195881.00,'篋贇r7+','Z7CxU6qEG6o',6838.942573493885,59,'C','3ovXFXxPFJ=&B22i%=Y','[\"uDGPxuVypMsI7NK1guNOGPh109PcjKOVDtJZ7hvpUpWWmW9w1otCujyy0LAzDe7a\", \"4df69ooyhsGxzUnWE4ReGif98dGpcvAeZXFDVlpamkJGL9khuQ16TUxizfnkepea\"]'),(x'45397470352355457625','l纴譄yj兾',0.90,'quk(脦aA摠掚S瓓獼蕼L3売瀑','^2X676KU*LSwGa',7466.250692887815,68,'DsY汴fb','3ovXFXxPFJ=&B22i%=Y','[\"lhoFmYVPS4n33qEKZyWzog2veJWyh15MnZ1cQRmSdKkItZREEWow4ACydw9KYgsD\"]'),(x'45397470352355457625','G-册壩s犑桠',916.10,'ygkk_颎埫1ME(稁&e','ypzm1ravj3',5541.517497688849,69,'J凣','3ovXFXxPFJ=&B22i%=Y','[\"Rw5I0LaSBVTTgnhtwS82ZELNLscZUgz9dmzR5Mped9y4QeKiFumXu1DeghSMxMPa\"]'),(x'45397470352355457625','覰軡~硂I3愿奏HaKm囔栴瘺',22508.60,'6蔏Ch磓hv蕡-AVg摯Wj羑_P','hA44_8Hcyo',8125.677813588512,72,'gB%椶','3ovXFXxPFJ=&B22i%=Y','[\"G5DI9qoiAnYtZEGpRleIBk7pauzuABhL5YaLBD6GLEY5f8UTha5bKxjar0RQu7UT\", \"MuXuKw4D8YwY3ijhP5wKx7VS4XNfSZuIP2XV45IZk1k2sHCR6Y9IwaB8qCPuII91\", \"6XPRFAvAwOoDBQXWMHb31ShfExpHOIOI1ME6jcA4xIednmbZSwG5YI69CxWPc4Cq\"]'),(x'45397470352355457625','9屉%95~栙蝲贱漋*3湩',7.98,'@和Q乒馼','hmtS!aTkxf%o',5661.849198851414,75,'4昫埧1陷hzdbb!','3ovXFXxPFJ=&B22i%=Y','[\"h5tPSirQXdkZ3uD7Z0RlFEitSkr54nKiPQQxURDotNLywuBJtfiYYPC3LLsjoPIb\", \"HFG39zLaggHTYTxx90RPrPTALqhZafOEyzG8vDiKP03C5nqSv98jTjWRa45ngpWf\"]'),(x'45397470352355457625','&稕',2.00,'2Bf臱機','pfy)%J%3Umx_',6838.942573493885,77,'JxF嚥g4q9V蘷o','3ovXFXxPFJ=&B22i%=Y','[\"oflb6LGlGpUDCEEQf96XtQAwnVRlmpdK3DgHyYM6lPeM43F608PE0gbAx1gq03ul\", \"7tLOXzotmiv5pxvrKvpSuL5TcMmwJqmNgWQAnOOQOVEKheRW813mAr05T8Era73n\"]'),(x'45397470352355457625','M抚c伦Gm姕ACa7閤輆璸姇',0.00,'説M褭f寂諗u','=dj3~wI#D&JNzbM',6838.942573493885,78,'重=b箠%B棏a5帔牀崌菈交Im*掆','3ovXFXxPFJ=&B22i%=Y','[\"VTDOsVkHKPnMQzEsAgCisfaZH55oRY4ugyWAG61TlWyO6TC9huqiAvw6mWiRM2p0\"]'),(x'45397470352355457625','Za7i撽4',885617.00,'CR僇)k5翰搬M~16嬦杠瀹','!Uh&6UC',6838.942573493885,79,'焬&V','3ovXFXxPFJ=&B22i%=Y','[\"liVpa0ynYaHcmmjOXnorapnLZxJNX4aEDkFJBDNhs5eV6PYsdKY23MuSm94aFmPc\"]'),(x'45397470352355457625','X0=Lt+nVF-dh媎鑨俴99j+',0.00,'j8V盐巊rp5檏','(Q-YV4K4pwj!FiMB',7620.968829130391,82,'!1j又~LecE笵)嘅','3ovXFXxPFJ=&B22i%=Y','[\"sNgkZyJPhEGDfJBw05Ix7jeTGZpYFOLG3v8rNWwto5noztJ6hoKtSlOdcSjGDFUA\", \"B7GavkpyUMUTONBwRrYbh6Ray4RmomBqxukwc9gQT3CrqKSZnhsBnSKbNuysNd4R\", \"Rt0LrZ2vc9VwlrFMNNyLsBxofrZLVfFzRhVXawJDF61JW5cAjHIHsC9XKTwdazI5\", \"Pd7u5Zuv1OhBBdE6jbKqQeZLWpfhNBgDgALNf81Sb8mOENYL7I6icw4iNmMlrheS\", \"Peq9Unuf9OgvsBwUyYHHHPwDEGVKRhtWVLrV2FRI70fvIy3gGY9PghvKI9vqrdxc\"]'),(x'45397470352355457625','^4g獫I驁hV謃Xc2J',4750.00,'W*z阐夈睏鄏','RK',6838.942573493885,84,'嵘','3ovXFXxPFJ=&B22i%=Y','[\"nI63yJb1NLw5zDMkzQM1D9c6tZoQYGgz9r31mSeQ2pJbqPdmFuaPMeWrblVCFwm8\", \"wSp99Sv3KvmiqSuRDC7xxt8EHnP2c7VsvaJybwlg1gZHZWbhbx0Cr0DPyLBGU3Mk\", \"bFnvOvO8dZO6cACfAuEuU9WQC41XMK17NDLIE3Ao1bvMitKGuX7jFxCFKC1DvNi7\", \"2X7kQx9mPWmXkwamj4rAOzjTkV4uLj8qPWs28D6090HufTrSrETUYM65uru0eHPm\", \"RK8j15uQrxCqQMkuHIF5qfeUrBFHTPjJw6QPJLrICGZea4rkXC2xvyG3PxoRw1Cf\"]'),(x'45397470352355457625','禑嵔X苞l跙l饓S=&ek0荲F糑t睔',95569.60,'躭畣b淅','*1_GjC+gN8=cDLD6',948.8021738248761,86,'幻~NWX餕0*','3ovXFXxPFJ=&B22i%=Y','[\"hYSH3zO1dDgAwA7NVLrYQaF2vXNNz2SwTIXda3VWoqaZrDHfF0zGAufzqhSYSIBU\", \"yGueFUDBHYW7Q5dk26ldF6l9XvEKVYuaCkfSmeYXcUNufblmXLUGZSEUVu3HoOGL\", \"jtc9u247YkRUe5a35kB1Ic69Q6ceJKLb7QCHEUEaiicFSTKCl4bahNbBdbfJDuwI\", \"efwGciiVbwwOZQpPDht8hGrrsDT7MaMQVpfn7jBsyZAuegYxXNN8zHGl0yMXzfQ3\"]'),(x'45397470352355457625','玨vNv寘瞖yw50tB(3E蓻=',581091.40,'廂bA','EHVP2frT0)8Sbx0',0.009701410061036973,87,'嘿','3ovXFXxPFJ=&B22i%=Y','[\"SshFt8Bu82vWv9apdOZiOngins2ATYutYs1C1SsnEqxmeXPfTDXMwNmJeiwR68fy\", \"uH2IgtRa8nbH7GynNgGFsA8jhkAWQyNPRFOEXfgLM7dY20sd8FvhHlEbEwivlJU1\", \"VzsdliQSoJshpEciBixXklDL70SAVHYJI2FQ5poAwt7stoMok7WQ1s5K3ABsdzlN\", \"8akUJASlkmKsBhNoqldGORXBe7GKCOXM7L35uRtAssaocygcIE8pGl7XiDuulFoy\", \"wQDUJrs8Kyn36K0Jrqe7xw3fNjCVXDMiVUIgTuFY7u8fj1A9vBOc3p9pqXoCHfIt\"]'),(x'45397470352355457625','v韽cLH憼ZJ$鵼s~(jK鮴2p',0.00,'aL楢@篏a=mmHt1wBo玐2D%','bF)',5403.04428996166,89,'僰糙鬂uw-M(@C($p沐','3ovXFXxPFJ=&B22i%=Y','[\"YmxQcPKZkZ9FYGN9iJ7wRUdckWGjvIPMvzAejg4eQYEg3u9dFcp86ulZDxMHHvRy\", \"r4MU316lNorCc4TiW3DIHEQF58iBSmr9GQpw9QcGahVbv3aFCoEEEd35WlzhZgKT\"]'),(x'45397470352355457625','8e錁吋5C羇u褈tm蹄#',0.00,'&*B','VzW*kLaU6q8zSc3ti%z',6838.942573493885,92,'#趺+n%悹s','3ovXFXxPFJ=&B22i%=Y','[\"dfdkPjhG51Hh3Y5z1h5UbrKSuSMa3fEr8ilWJ9XQokIzmeAwrD8KRct8AcGTKmX5\", \"uJdctUl0cXP9O1sgh9kln7DxpJLMU1tDHK1ldIL0ii8rEEgKjHDZHjhV1AroGTFs\", \"3quuLmoCqZ0o2v2TeG7uaoPZrup8nznSvGsab74PNjhgt2mUBCL7rRVViRREXTHN\", \"pBHmLJ6D6gu1S5do6lOd1RSdhHVXjesq4zYskwiX29x1SO33lKnQ0KPtGAIaWdPJ\", \"dfEpYhqKtUJLT0qmPkqT5aZw0k4LMkDB06uKnej10x8KHYjZibL4ICcKoKJDeYmf\"]'),(x'45397470352355457625','%T億Ld星啗',49352.00,'Qu槰Cw龿','z(A#Qjl&==XKZ^SeAX',6838.942573493885,93,'yAt諶L鬰谞襍v瞧$lC跟5広','3ovXFXxPFJ=&B22i%=Y','[\"hSPG6hTLDPq2m6YR0hgzhYRwm6qKL1oC0NCR36cDZolDFLOMemwATpMV5XPA4Tp2\", \"gttbhBy2hm3ypnxzuEMj73hCoo96B8Gyu24rDI6WMQ9TLWr4bvaIrTab8uh9DD6g\", \"DEMZXaUmvXzQvDJO3k96DgpAjMkWrgD57RG4CkV7CKoCNUswdkXZlyBK8wDpyzej\", \"nldnmjI5E73IYvhUNc8LAN9OL6nScaHbXTrnvj5LZHCWX24mCwqWuQ7ZyzWMkcDt\", \"T7nqodq9l6wAD0aauJEvapOFLlQgZM1MjZOaQolDnBvYclPltxxnq4fSEt8qsCCN\"]'),(x'45397470352355457625','嚸覊Lt軧f嗔',44.00,'s(s突袟椅仇quGaivm趯&Q旝f',')nE~3D4e~99-a',1761.3730283393754,95,'仡@m鼛x4Il蹌y馎Z譧','3ovXFXxPFJ=&B22i%=Y','[\"T3QBZyRfbqXJBs5nC1M64bD3WM2OAlOzbI4E9lAVIzQpG7PV1oxGuz4bqUeRglNa\", \"QZaQoZe7H1B86mzC3npee45X02CHC7hYsUfJE2UCA2FF75vSQ2mwgqX3IkBJF5GF\", \"ccNCUPalnYMdARCmjFdRNQxKI6Ts4jhuVkF6CNqgqJx53Vi8ZvUDDUwitUF0uPl5\", \"F56gkAuj093ZndETfbgru8JjILZ5UUMACW4KFBfA2AiiENBrUvcFGEd5s6nWXXX7\", \"YQ37bYY58DL6UfCPWL29w6fzh3noO9S1yojjGruTUkGOhOG60SA9FVttI6o7Xa7W\"]'),(x'45397470352355457625','鼚柵SP毃4e過p1儒沈2',18460.50,'儲剓)r糽v儔畿嘁趆Uo逼T','%IVZWNF)Z*c_p',9615.885171514492,97,'f疃甝嗞=鵸tYq$wr+3唳~趷龕','3ovXFXxPFJ=&B22i%=Y','[\"Om8OMdifh3IcECDsDGTmpQ8kKb9vmXO8XNyGWqm0twY6K9qSmTSeE1y21mztW1SL\", \"tkgoT7tBuicD34tFYtUu1gviMbfFa31l3jREtCmPX4DwI89QSu53DthERFHnrwhY\", \"qD3k9oYGoF9xeJv8uC758BGjfWIev4W9Wivhole32gL6LjChdye2gj66JEjupfRE\"]'),(x'45397470352355457625','歾堟F蚙',7795.95,'惵','&W',6838.942573493885,99,'fo潳AX橐敂襴6onU','3ovXFXxPFJ=&B22i%=Y','[\"r88MDJfnYj1mD6yS6nLlq2xB9MfMGe638fOvgmFYiTJdugTGqXvWUuzUYS5ZBsPs\", \"V25YhLtvFuzH2zGhhtD1yquPj5B3VBNBxYgM2vkWBb6z3qgEV3SVgAJXGqTm1dcC\", \"z0Ljz12nyu1WKESW6oLo3uuVa9UThHN48023IdHkUZ0a8gxhlQCLCuVXYXLoJhbH\", \"go5RwJT742IWQmICcdsDhI4jv0heK9MWJQErAiSwVDSB4DeI1We6jmygyw54JVl0\", \"9Q5ckFjaA6x3XrbuRSLmqe3vAXQGOOUk8D9zPO7BBoxOh4oVygngpIC04CtSJWTh\"]'),(x'45397470352355457625','9銞J罬u翨j礽斎q_D*^M^煟u',0.90,'%鐙v*崺rZ9_+v','gLOPaDI*',6838.942573493885,100,'徎1','3ovXFXxPFJ=&B22i%=Y','[\"7Cs7UpMGSR44JkjomezSJj7PaVdZHY1qC4vdeDYa3lfIvvvFN32D8K4q4dyEM51h\", \"t9lP9d4eMgYVETvLDoYlf0dWkirQBJMIKc4hvKJsO5rZ0iv5EnlhGJwREWWar81n\"]'),(x'45397470352355457625','6軳&J-owKI',70.00,'AY*侮Xc譁^h','fx%1g',9809.290737797808,102,'w嬀E=笜4!=QgRk','3ovXFXxPFJ=&B22i%=Y','[\"Vmoxm0SMaOU9E8aXQydhGR8zeHfnVgGzW5UT6pjxptLiXZXfgIhbIAVifTVcpeC7\", \"7b7QALe71TMNwObuqE5eZh7RBlZYE7WwGtIkdtZcy06c55T3GLITrFekMTGyNS2j\", \"rtIAEKgTDkfRFAqik5jTgC1YO7nZerSePKAq4fX3fdQqnxg3hWZUWzlmpI1PqIrv\"]'),(x'45397470352355457625','@h0Nq钎_)mpl鈢糤嶨豝圗鶍',872335.54,'妖9pqQ6熞罺雝','!-$5w(ZlMOi1$5',4815.720673709614,106,'詎1+Z%DSQHFk@倜49d藰','3ovXFXxPFJ=&B22i%=Y','[\"RzoykClHvyBrna4EXQZsxBhnfD6Vr1lC3rn1kHNkezlxx4mkZ8US3zeNq6ID8xFQ\"]'),(x'45397470352355457625','2钩T蚞f',59.26,'64e鮄o^辜锐C','R*FDs',4137.561222646485,109,'軴5=','3ovXFXxPFJ=&B22i%=Y','[\"VRYZ1QazJZEzLpZg4o8oMqLv97H9GPXpdaRL81sOYTx7Tyo7s3S0pDNn84AO9Y9d\", \"FA06if72KOK0qhxWgEEbAII5ARcE1YSk6L62TqS9A8BSicrNd8L0Tak8SpTHKY9A\"]'),(x'45397470352355457625','_JED$欁)A',27.00,'碎1+舂fPV','FnWwXlhX!yM!d4Z0tDk',6838.942573493885,115,'涇幭Oa淮scS猋穻J溱mr9','3ovXFXxPFJ=&B22i%=Y','[\"lwhVbAnzjSc1XX8JOlbFXXzGc2RxMsVnsM73ucpEgIfLdZ5z4aTboWKOslcmV2NP\", \"M9WApEa7s4UCEfSZgrq0vecXHlju89tPFwxTDgrDZNm4YawtVVXXo1wyl8qW85cc\", \"Nw0xnwgWssvv6wU6Jv6iBeuddmnNjYlgfzpnvO5Msh1AwtcEOhUxHSKj80eUa2H5\", \"Dx8NTHMFrifLPJGeh6Y9oc78Ii6AGH6zvOW3va0uyZUfzhJrBT5uGHg4Ne6DgCrq\", \"v2OVV3GYTPvjL7MZ4k4N09D6gTvuhc1NgnnTIn4cYHVBCeMsiFuTEu57RCU1c6He\"]'),(x'45397470352355457625','xx2裡~禞霯s&~t27杅1',27662.80,'楇9OaxReLU$ujQ靏Ut','A)f^Cdypn2bY',1306.7219291495294,116,'碿*O噪QqgK','3ovXFXxPFJ=&B22i%=Y','[\"36Hi8SSqjMAxjy47YVZ4gnDGKl4P9iBEbPddneZlM6UfrRAtV3jyWwZO8mqFx6Og\", \"tRrshiZHmOHw6BEsXaXktVAG4BOPrniuDUeZFmAPDZQ78gLXz64Zdyevxwm1NWYt\", \"pFtIFmr0ZAK9KZArdxsQHPHhUYKp8oFWGLepuU5UOq7b1bkAx03NzdleNLRAuimd\"]'),(x'45397470352355457625','M稬吅!F蔈@yQXb暥P',9.27,'+惟8Z卡gYg5pAQE脻栙P瑪','l++)VXMRdva48c&h#n',5475.8453400736225,118,'','3ovXFXxPFJ=&B22i%=Y','[\"iBPe4Ja0Czq3sGruXXfSrBDtnKXZcXW52VIHlquHpzI8yT842EB71vLXMcx1W9I3\", \"KrFHjuK1wgQKXqlLK1oFRKDv1eiC20L0xrJHUHdpAkyLQG8lX4SmVDwBVWnWrPrB\", \"AX4jABN3JP2prZSma7pBeyia1dD13wyvR2mTHSzoKeJ6pbUhnOMfgxZlZNL0x38J\"]'),(x'45397470352355457625','MHx阬蟇戠1蕀!借蘉劺)f$i',4.50,'*S*P嵖O坦AB','TG',6838.942573493885,119,'g鎙脂M稣拭戊弇nr','3ovXFXxPFJ=&B22i%=Y','[\"YEpy0yAX4KXsYqzskW3pEjuD2jr0dVzwVaUcz9K4ivjBr5lM7PY1fo0bz6EFIru3\", \"KqbfuODPgwghJXQpYKCqmV9U5Yj0So2IPwnb4eye9qhivTSxRvlTJT9Jl5CgjAdr\", \"d1u9bxv0kyFDvtzY9FtEsw9e3bGMt53CY9NKDU3Sycw5O9m2vfIq3iuEREvc5NAh\"]'),(x'45397470352355457625','(U豏囓',9.50,'唝d陕F糾J裪oPE9U釯Zc0M%','9PF-r++',1346.5630532459668,120,'Ib磘H襵_','3ovXFXxPFJ=&B22i%=Y','[\"LorgT8e8vNXRB9BSTpftL79KBeV44xJjTsQIirbh4Zjuy2ZxMXLr1fFGvEyhUmis\", \"MRSPbWsQi9ozThj1RjvPBiqYHU2hBikv5SopUn4ZCcJN40QYY3v7gtMYLVt94a5Z\", \"kEejezYSHbq3mzMvOFGFqNVddNSGcUVZKs51MaffNDXwjOqHiQbQFrsbSVtq2t8z\"]'),(x'45397470352355457625','!1X尊嶗6B5=',92753.60,'惊diiYl攼閁r3)','DEIn#2Ylwa',6710.289073423594,121,'l街輴','3ovXFXxPFJ=&B22i%=Y','[\"Wcd13F5lEUXyHiegzXQ9PUx4FwMSvJdHfTrbg8jjmUEBIcN8XkobD5sZcMX0sB9q\"]'),(x'45397470352355457625','dz#',198113.54,'zu%z','f&8%FU38!hE-Ew72',9809.290737797808,126,'','3ovXFXxPFJ=&B22i%=Y','[\"42ClBgOmK2QKxPmoTOjwa7zEtNcbIiJUlz247Z4sHgdXGthbv7lAFb1Hupkf5l4R\"]'),(x'45397470352355457625','yv笊蒄*亭(璻kG9@%所',950.72,'x(D碢Ve','FqJ@HMNwH2&8Y#(x',NULL,127,'c浐uXQI$槕','3ovXFXxPFJ=&B22i%=Y','[\"rSM5rWdskYUeh5ZRoPbe2xeVCvWxnUQWGfOrwbS9gNdMcBxFyP15GxqVwTlVisks\", \"Bwc2XtaPMITDfSznVVOVF5PfMSK88uNZZtLCU69NEY41pJZ9YMa0iPXczq5DO3iT\"]'),(x'45397470352355457625','F蔼UpsTdz篤',4.40,'Ov嘛^xgug7h譆毆','8YG@jA0W(8-w',8637.31756655737,128,'Uq7讦QKW_捤t9嘼0缧mK3','3ovXFXxPFJ=&B22i%=Y','[\"5ZJmQca4K44927MIN2xtFzOOJmcuMfTdUzXAOZ3FovRe4ISu7zcgEzkX8Y1dR9Va\"]'),(x'45397470352355457625','g8fvg&',417353.00,'wK','JwPKyotoS0KkxL_H-d0',7421.157943854137,129,'g3満D=缔vf9','3ovXFXxPFJ=&B22i%=Y','[\"xXcoCpIVvGmLiGrI5eUBHlk5J9x49OEKrWzsXJkTqyNVh4hGYCv7UQ0eKaCqWTCG\", \"33N0Ld6a5OXc7rJwwmnFAICVaaAgemgZTBwfmzu8yYRF7OyzsHI2zfyHuXL7oPHE\"]'),(x'45397470352355457625','^E6f缓(rY&N宱#',0.80,'ZM','~DU7KAnPqg',6838.942573493885,136,'鄫畕麛1!圑凞耔-','3ovXFXxPFJ=&B22i%=Y','[\"W8gfd7ygfV5H0I1o1wGqnVHbtWUoxqd6RfZYA3nuwsVNJQTnHXHkNKHuAhA3n3jX\", \"F6NvBLIWJy4qKZqs9TL0xCfM5mcYBiDhrMVoQvURI0JubkyAIwRxkGRRqqr0sLaK\", \"yxINEzztqN0OuWZuYoweQELvq55FSPDSymbA9AIzL1dsuyhIREekd0AqLSePzG5l\"]'),(x'45397470352355457625','齐Dm',66418.60,'嚽N9j%脳B甶fNc$B8廑%','ylLV#ij%boua!',6838.942573493885,138,'BuxrYI鉦z侰i','3ovXFXxPFJ=&B22i%=Y','[\"k1aKSFRaUDrARSyygqrPXl97fB25LnwBjtQytS4ExP3TldngNOlVab8gwIUqo1y4\", \"gFjhyQNbye1nr5ktLOaTKNcn5DiWgfBZRs0Q6W6FJuxpGOO3qsEMK01gsBeWSzLF\"]'),(x'45397470352355457625','',9443.84,'U描琙龍衬蠰趤嗡t%l辞郁3I鱡9抗','^W^kdjaDNL3$SDw',6838.942573493885,140,'=+巚涯n5縅謓ZvY&膅歔-!激u','3ovXFXxPFJ=&B22i%=Y','[\"QcVbfhJb7F1phewlPLAotu901thuAdou3obaMKv6IjUoodBlXQnG9Lcjp7dxWQP2\", \"CzJvMP9E6E8c7dc4jIpeevm3a0T3aU2PQG2xY0Z1N2B8fuuW1GxWBqqvcAPTDnJi\", \"6a5rv2qA7KrXZAyqjSTF6LaX2NTuiLNUZDW8MPVtHxjhuoCeM7VgOEdH6IZupHQf\"]'),(x'45397470352355457625','咱穣H',855.50,'藏秪纆唪','4nlt*R71-8r86',5428.8271600513335,141,'','3ovXFXxPFJ=&B22i%=Y','[\"pjORmixhdRqCNlK8UQhPMwJO9aBtAf0napqMdnE6DwFokD3MFr3UkI3LkgO6tycT\"]'),(x'45397470352355457625','v#',72.00,'魿pS猯7簲燚瓇烇韂势','EgXq+kXJ_AkjQKGh3',6838.942573493885,142,'-謊','3ovXFXxPFJ=&B22i%=Y','[\"C5MtAIUHsDokXhLsZDSOyM9XhH4UaTGCDE7tIo7j4VuOORSyDi6KubKxqZfEX0VP\", \"7wzm69ZFx65c8yn06i14CGX8kywKOoNe0S6PPt0duW0CWMJpjqNbGFvzrgXe9UOn\", \"8q60XSOXZZf8tQmC57z8BCubKPfxdOo3XXNQhSgTiKzjA8OD5yHKgVCm2K5TQg4W\", \"Uz7b8cEFBYL4FcIPhnIpodeUap6aVloZd4hFkZICqQaRuMjhhIy4UZucOvWAmrqp\"]'),(x'45397470352355457625','1I1騟+Si佡糜5',0.00,'衶鹯黺3d','sgS%s',6838.942573493885,144,'X+t篣#1IO恅^洘j','3ovXFXxPFJ=&B22i%=Y','[\"VcjJgC0LEwI0qLbONgbLQzAtE3aFZplIuLUUoW5DY1tZthassV04kbxHvC9ybQ8V\", \"yv78gPxX4c1MLL9N9h0tCnKss4UDFy505i7B2V75jLDUDhUwSvPzERWOAfCDxhws\", \"Bqh50i5i9p4NTlRAj6lQ04RG736dR7rgcj5iDMpHyYF4TN5SljQZd3oaFkSyhNo3\", \"u0Kf2vrOrUdFjVc6r4nUEtOkQvccPVItL7it5AoIQOrKoNVrqfqfZh5EC48oYERJ\", \"RAyBEZBT3b4a2Hm5udINUgn58cKTrsoqcYkv6nw0J0JrubPF781QfpzfWIxAOmOs\"]'),(x'45397470352355457625','箇鷷徔鱵Lz餍忉媦嫭8~=M媨jO',907347.02,'o溕4箬0悴eNip钚邤雖NM','@ZmDc-MV',12.364576604706953,145,'枾iwa','3ovXFXxPFJ=&B22i%=Y','[\"BIlc8ne5At6HQSyHMJGqEb65QGgqX7wruOd0vxsMsIKqkLIoCk7Q3yXyz7WECe34\", \"2sd8Z3tQpPJpeFScgqabLQpdh7RP7KFZqEVdnRIhREwKqKxuO48WArX3mQL2eG5J\", \"hiEiaNVIuGjVlT1TzCnLAm47npGEM2DuuniBj2RNOnwW7htg0DxPnrBPBYcuDeKY\", \"iihZh3Br7hXSz5aOlDMYAQKbIV0VqBvjSgSQAIiX5LfHGERidhAthbKFT9XPuNt3\"]'),(x'45397470352355457625','5',642.00,'','WW%Vl',NULL,149,'做f歴U辯啀!#WI醚ZF瘼PK#g','3ovXFXxPFJ=&B22i%=Y','[\"MDV9RX0WcKMckz1hrr8ecl3KurFsZcOAI8yZwjDz543ZIiwR0grJvsUg6pL8Npfw\"]'),(x'45397470352355457625','钅ZW!%',0.00,'h掷K質Ub@緾b鱊TC=婦','r%~',2965.195503936985,150,'~','3ovXFXxPFJ=&B22i%=Y','[\"lzZGrczoaDrDCYeedpgdqLrGUqyNCAbbkJnS80FIoNBqbDEQf9xYllnf6Y3rUsxx\"]'),(x'45397470352355457625','藙k猷珳',191.50,'嚥F1kPh鴶枯藉哪$%RC','6#go5(',9809.290737797808,151,'棋','3ovXFXxPFJ=&B22i%=Y','[\"IYrAxFewIwoNo4aCJoIrvYHEuFcfHWROuNtO0dKGBXfTf225LLTr2HmagzByQjYq\"]'),(x'45397470352355457625','傤妓Y1Ia',0.00,'jxT2桇Vii','zxRpoVUXS',6838.942573493885,153,'L!(u','3ovXFXxPFJ=&B22i%=Y','[\"VJsgiEuQF20bKVU4oYxcmsZkDQjBfW9qFpDBri3taPHNBF80FVD3HzWwweBSVVEp\", \"XdVhiA03CadQsz1UfB1a5T57JCSE02u39TKNMZfdlGrcmc3cLVWDxFhC4XFGcHrO\", \"Hnh2F9EPNkJins07AJKiccq9JhS1ej8eum7b9cm9DKjjoodLtlfMNZhLVNuKw07D\", \"QLV4XIE0dya5lSmFXfjVuq6K3fpEWWYK078X52cgsXDlbEGqC79IbYDQlfSVDZb8\"]'),(x'45397470352355457625','迂nH',45401.00,'','x!2742r',9809.290737797808,155,'潄T藺moS廑2+%+&yBV(','3ovXFXxPFJ=&B22i%=Y','[\"kzkmZGQT2qXuki3ZniblDgT63Z6A91ZEgl7tbggYA4QpTiQ3pgEnLCo5TrhKVlVX\", \"D08eKzwqYogyWqgQwcb9lIqYz8eM8yxI1mJdZNU2PjFyFUbacn1B9krG38Vlzh6b\", \"78yG37Ftlyygnhju42e8g2u7gKCp4gciAfkJdfchSWUhENFzB1N35Aaswfx8R3Ao\"]'),(x'45397470352355457625','凩怣z',7792.00,'idk致F蒰avZD燏f灧6瑮f恊','fhdxpT)$',9809.290737797808,156,'0_蜇襵诿苤覅#0k(躸','3ovXFXxPFJ=&B22i%=Y','[\"2nXFwXMFuugSbm6Jm2FyC9HtUZlfu46u10dwH2LymeUeuKb7T25aqSjQuJmcMDLM\"]'),(x'45397470352355457625','TY*綼JRG4垪撫FLqQ',144865.60,'笃B)pc閅輊(梵矫un','O3R9c7fjs%84qtDa',6838.942573493885,157,'fbug続T6秅M##*L溚d涂$膼','3ovXFXxPFJ=&B22i%=Y','[\"nMKFVntjJu0WelRZkGfXKV4jWkpiqrh1rm8nab3OHZvMU8yG1cokqXmHiN1s0VJ1\", \"aYKEUpFNfxxdA9djFXKsyfVnPrtPZkGHJZhUdQ0ASUXSzc0Sp5GGVL4U9yUpoz4C\"]'),(x'45397470352355457625','嫾q)^kLU!i2g',9.20,'嵤vf菼5H悂K毝珢_I甂','zhqqp*e+)M',9809.290737797808,163,'梇苷#H8CiFR鹳7Z琞墈','3ovXFXxPFJ=&B22i%=Y','[\"FZvNbcnQOLGEmRfafkP3ybA7WoVq9Q6PzJjk3AX8XkPyM0PN19pBOwm9L6HcSS8a\", \"H4JQo4nFEUA1E5n1otQJ15JeEtF1I6Zg5sVy9O7SCzdv4YjXaSkOljQWTDIVCty3\", \"Lruc8RZpT09H3k2eGbFxV97znhYYAFLraw7u1A6NcTayQfUXfWTximuMSHXX1zUd\", \"4Z95GO98EvTMurR7fBy1XXT1iXZCjThThhE30GHomdMQyHiXB4MZOWfdITkRWqWW\"]'),(x'45397470352355457625','M蜍篵p鱂怊+',3665.00,'Lk鏏Xs','MWT',6838.942573493885,164,'','3ovXFXxPFJ=&B22i%=Y','[\"QWJUPgYAcPI07FrGDrazRpbdXDQjSxSisMieQEJmxAU7Pjwg93sy3GvYkGHd89Vs\", \"W0chudnNM4QxKJ26HKHMGlGoLvgYAVYucBW8wBPiLn5WgdY7i6PzrzSgBSsZDYmW\", \"IMk0ETBeDlITBC3K8fA24kMuvgP0osoZ9Md4p2Kzhtuh0ScbPEXfVrEjblZuW3Yy\", \"bMPPeHXAuLy4catbYHXM09zlUKTtIDIYAxvGNbf1wsSuptJOO8RUSB3kPgnUsACV\", \"Q2CbBXWjD1jYYhXmHyOaTMpDd95VBf5kQXAWdWy6E0Fyja8HQYg9MLq8AjR2HhKY\"]'),(x'45397470352355457625','T抹勏(i闰鬘C窊',89.00,'G@仭1趍O鴭丘c颁i','vrDZ9',9064.889636879536,166,'~o総p&俟耈g萫鸷ZR蹅弝','3ovXFXxPFJ=&B22i%=Y','[\"XFMM0lxqPkDprYrzOSjFPQDYeoSNc0eXx9FQDj04YLjoNzWdwByF14WCvGUWASP1\"]'),(x'45397470352355457625','m簘+lb',451.91,'!沒踔_3swBuCA','ZHB$!cRC@2-~=t~n',9809.290737797808,168,'h47ba','3ovXFXxPFJ=&B22i%=Y','[\"nf6bkkSHXJrFYqHKSmP2kb2A1p6VuzY0tTtwI4WVVyy2k4FrTsgAfLuVK9X9xND6\"]'),(x'45397470352355457625','Mr暸T噷)Z9#^de',93.24,'蟦I嗴f衠萎','$6Q0^~%a',3845.5862302613177,171,'蚒t拸)D蚋橷fUB洖@','3ovXFXxPFJ=&B22i%=Y','[\"BNJxKwI99Ev6xIgZOOKQ9wg31q01MjHZ2el11LDSqrKFAFVitW7TARA6SrP922Nn\", \"c6cLEjDw0EIHr4BmQ2cMhQh2f26UZA4JQCBdg8tydnzySGlyHC39LjddDsdOEYzO\", \"q5sFGNZ7sPOqc08AnEPDinnPb494qeH0vPjXA0bwQX8mLGQqgQuIL7OaxqvRKKVa\", \"f9nHtDMPBCjYtLVznRINkNlV4exqpQvCGvU3MJQ57eKv9dZlZ6NdSh7oXz0pxQ80\"]'),(x'45397470352355457625','6奐Ux2Q',0.00,'&$v@','',9784.697455914344,172,'!dD敆$o','3ovXFXxPFJ=&B22i%=Y','[\"bA9RJAcSeSH15x4xa1PYhIoaBoRMcICEJfT0f1FAJYkQvgODz0nahGvhkEWSQz0P\", \"20ZcfcoOh1pbIOdRGJslqe13BUO79hQDKPY81zpSpXv60oC4HWwbmQfczYeGThEo\", \"LfTbhS0aYNLRW3PgZEFcJZVQ8qw4MGXiMdmNcgAMC4Sj4sKKAOGLBasOLU8d38O9\", \"kacBdPQ5dfkGz7ubJbfnP1Pa1jclmGboQWvZkConN9UlrQhpeTWEYKCSFUBORvpO\", \"wlAg0t0bVYhku7nl1oGxph90dCuC4YXOtWL8bs0nTrTS2zQDiaRiFRKA9oKPI2EF\"]'),(x'45397470352355457625','A',181792.00,'辕肈I贸X抩$KF_B','i*I-+L6',359.4696623955375,180,'c蒥2D枂a摅冤(4fAAc俍','3ovXFXxPFJ=&B22i%=Y','[\"sStDxKliSEwkSwFJGiiBXrxih6S4BrYBchuh6ZcvqtbT1jZGyIGYlVCPvjtfHQaJ\", \"HbuIMBo6xWyAPxlrrMVh2SZXLz9FPX7vIRIJkE49tZH6ypLdbqMaPgUa9nK2YZA3\", \"HDbFKuNOjICjQJj2cEcRcUxzigiRvFHHrwsR9F1S5MDr6FiMuUKcbJx87xefsRXo\", \"uhvpmGFoOgrKvYcJb7oAWoqWk4OMzp7A7x9qBFoVe2k7ICyTQhwIWiEEYtlUy2YB\", \"Ghn9GPbbbE9Xuju7lBQpbiiEnP0aB5Eqa2DyfIh94TwOVJKJyc7cspmwu7dVmxq4\"]'),(x'45397470352355457625','',0.11,'9&+坓YK嫧K螪m','6U9Pgcio@o8v',9809.290737797808,183,'i~Kj*24jM$蛇','3ovXFXxPFJ=&B22i%=Y','[\"UHz6jdVAg5upPWaYGx7lwJl1JBF1Y2xgxD35vDIPEKjJhvdvyn7ffWBvgQSwGp36\", \"roAtpUyKvj4A2k0oBMfS5lKu9DNignpm9nlUylk0VCAykgKptfJ15agzJ6CMZRCZ\", \"edGbzcysFuxGmumZkkeq8Dh5PhqAT9ECzYNObcJezcPHdyPAetMnftTAnTnm6D4y\", \"NwWnDpELYoylH3qlcT3g6pvuJS4YOFgaffHcBP4YGxru4XdFgdHXzpUtZrDYis7A\", \"pisAI8IfcorTCRDZcCoEjZhYg6yiLzZcpjvdjxe5XgzKyhqvdYfepIXsyE91UyY0\"]'),(x'45397470352355457625','Ak',907.00,'O~燇綇f_=$0V狆','2!UM',6838.942573493885,186,'Z^==i睡g6','3ovXFXxPFJ=&B22i%=Y','[\"XUjkWZlVS9s8xRHNO6UeqYM3roYQRyrtkaKu8tW1gJYxk5a60PFs63jFTgiMJvJv\"]'),(x'45397470352355457625','+m4_+e',43.00,'彯-唁lAyX7绛m','!Esjn',9809.290737797808,187,'&嬒y武恖餋l旵豟$縜郗贑翜','3ovXFXxPFJ=&B22i%=Y','[\"N5KBwMBKhwPPWBhbxrmVMdfi1YMapHzq53pRpZCDfFz3MTURkZcRygGT8C2ybeIC\", \"vyDDiRyyyKUgphqiebJtdnDiIs00rnIDgeS8lyasjFCQXCZjnh6ZSfRD2ZflngiY\", \"KBuQvFwH76XO21XYwYsAfm9tDWvvgDsD4oazG7PL4IWnM0RHEMlXyehf9PZ0Rswa\", \"XJTa2Yx8GrOYvR51AqkeAdEksSiFI4Qt9RsXc0hvjHxiONbelZ37Eje8QFs32baU\"]'),(x'45397470352355457625','5~',95170.70,'LZOWZ','1SX5PM#oH',6838.942573493885,189,'鮎^m1(甁O#瀊c8D','3ovXFXxPFJ=&B22i%=Y','[\"QSVKKg3uJjimfaWkqdkUg48hva2xLNwf93WA3xotQJkkF69vh8zF5MThx03vtM8M\", \"JzfPIjFVUzCXb3f7ObTohWJyYS52dOmq1jXiNvP23AEq7UMjBFq86Y1qYEgtk3Rv\"]'),(x'45397470352355457625','萗劕oAy嚯攗4冫',8412.70,NULL,'FU_=6JO1LF6',6736.430201712505,195,'lpF謶=螇Q','3ovXFXxPFJ=&B22i%=Y','[\"oWvgiG4gfgmMshiU06zuxr44ivuHDjpgsaxZatD5jJatv9PGRiIxh2msn3Mm1J8p\"]'),(x'45397470352355457625','榏夏S^',35.80,'W!劂嵅~IL顋p胱2#+BUz^c','VXh8nw)DOp@xDfkk&',6838.942573493885,204,'_!呒y媭','3ovXFXxPFJ=&B22i%=Y','[\"cLZRsyfhFSBJvXmnkL7Hi1GkGVxwai135774vtr4XBtQYF2D5zmcIBAaydpLS0mY\", \"ecwmLi6TWgxd3kNqxY5u2d8YK011gVH7fC1aDXrGanWJwtAJ6mAZTdJcgPstVGkJ\"]'),(x'45397470352355457625',')BOu淮Y1O',487165.90,'28Pgm^','BtJ)S0i%$S$(TzA!',9809.290737797808,206,'(Kuyw翘帯RzRW澈W厁','3ovXFXxPFJ=&B22i%=Y','[\"Ar4ZjEZKS04qc8EHwAZE2TLPt0FD40JIgua0rSoLaABSh6C92OGWCzCR8USSvYfJ\"]'),(x'45397470352355457625','铢J*aFri炑',7770.83,'鼧v藲fliT~fw','88mN-fjJ',4858.993433493079,207,'櫔禌敡','3ovXFXxPFJ=&B22i%=Y','[\"qnN3jRQQwRXEL7mVWTojE8sTrbZeN178ObyF1kQg48zBSsI3SJ2JuVKKPg4yasac\", \"fPyJpiaYnnbRIwRENMai03u9NdZ0x1WmIQAQrf1KAmToOzeFjh10hwB0f2ueOeCR\", \"PdRXkbOHlBxovzJQklXTWyRxTanpOllk9vGw3acITHuihNTYwbaSJUvVekBYkYb8\", \"mV6FRQ0KlKDg5dISsgeD8lhynQqsAIMBxHNfnDCB4czvRe9SPgYL22FiY2bTD7bU\"]'),(x'45397470352355457625','B秷溳sf倚攛',86.24,'=v矯k断Sk靭耽bWYvk耬vUJX','68F',6838.942573493885,215,'躕=僎BREf(竁錱鱅^','3ovXFXxPFJ=&B22i%=Y','[\"pZNewvCCcn7Ra51Q07EDxfCagqAI5br4umQwG7knLFEp3uoLCu6vDmbRoXWZiUor\", \"WBVPeaIS50yyt3nfBNAt0oKRlcgdfTinztRvgXosWWKccBQ0ZOa2yZdKDvIc9Bqd\", \"orXjQIsJi44eVgi9MbmBPa2Nt6qZi9snMpvSAVtBxeK2o5ARsJrhJYfixr1O1j7k\"]'),(x'45397470352355457625','餭V1銼U2Z远l',86.00,'E=-_f愓BeI喆駲髼囓6%','UTfvyO!8sk',6838.942573493885,217,'禚16緒u','3ovXFXxPFJ=&B22i%=Y','[\"WakIPBgVaSwQM96l6vwwLdKU2hAsYErIEooWV7Xg712IwPduJLxX9IsNubRhD2lk\", \"X5HfkC6m4JpC08R5XQ5mLqzo01lP7mfQxhAD2BYFix6mq5n5UW9Vk0DSWubcCYAG\", \"KfXtVXZCVR7Ppf45M68ya9AGvN5Urt70pT8iqdGRpouEcap8uB7YRkRF0MgpWyPe\", \"4IhLJUssOYn3ln80rXL3dvkchGNYXXjDp950R4Ag4Z8k6iKPBxVh3MwCfNLJsJ9i\"]'),(x'45397470352355457625','C緇诅旑K奴O潞%qv瀑搽63',50074.10,'@*kxR諉Zh','v%@nt6cKtftXz+-XL',6838.942573493885,218,')K詈豕2yh','3ovXFXxPFJ=&B22i%=Y','[\"MAX9bInBN9uW2arzAlRjcrpxPTc09dvj52YqxuRSjHaoZN6bLZ7xzGQ0lDm7EYO5\"]'),(x'45397470352355457625','nN晣濣u墬4$LzqiM',0.20,'*v3V','!wK4s)sCzOTn^h!C%tb',6838.942573493885,221,'罁~L怐zK涋avdqG溹缂_g#逗','3ovXFXxPFJ=&B22i%=Y','[\"xDIGGlbXac3Cw4DjgGhPgxe1FpIFcKGki2AKhSsVGZXqnk9iwZrLkGmg1hnR3j9n\"]'),(x'45397470352355457625','05蟧~抵etC',419175.00,'elw寓','j$8mWAUY9p#%Y0Ezfh#',8770.489412485314,223,'謜KiP妞庂照%d','3ovXFXxPFJ=&B22i%=Y','[\"wQy1yDrsVOYPvHRPJbFX8LqGrSWjXgy0pz5ltDfFCnh2elhKhZAjrBcwwtfR9JGk\"]'),(x'45397470352355457625','$蜛墣6k!Z湾4',98132.90,'鋵廪ELa呴歶oR^蜼','Q*8',6838.942573493885,224,'腬納','3ovXFXxPFJ=&B22i%=Y','[\"hMKNHdquogBwYCGCtWQOGNGoYAHGXavPJv110UM5KwK9V9MdgphyKuZG2671l403\", \"N7fJnJgLMrcCgr1a1n40DreGi3rfDIYbWJmMKfDghrWD3gL9pvGafUb32voZ3evU\", \"5M9hdqJZOVYn54JQYrJHmRjDlA0m0wZ6GbLgeo7dKDBkHxsFYh2CTqquFyFyjMYp\", \"JTiGh3OiNQWbhRPU1SMRg97flZwXnPFQ8gpvIatSHMx3FdjyWgNzTqTriVTHIK2d\", \"k5fEIWHr7SZpNxQgwjSug4nzuyyZZxOpoBtn7sqwdP2K6Xf1UnzkaoiBtRxBfRB4\"]'),(x'45397470352355457625','2处襤g',37.00,'騡(嵚4ii飹','983',6838.942573493885,226,'','3ovXFXxPFJ=&B22i%=Y','[\"VcjJgC0LEwI0qLbONgbLQzAtE3aFZplIuLUUoW5DY1tZthassV04kbxHvC9ybQ8V\", \"yv78gPxX4c1MLL9N9h0tCnKss4UDFy505i7B2V75jLDUDhUwSvPzERWOAfCDxhws\", \"Bqh50i5i9p4NTlRAj6lQ04RG736dR7rgcj5iDMpHyYF4TN5SljQZd3oaFkSyhNo3\", \"u0Kf2vrOrUdFjVc6r4nUEtOkQvccPVItL7it5AoIQOrKoNVrqfqfZh5EC48oYERJ\", \"RAyBEZBT3b4a2Hm5udINUgn58cKTrsoqcYkv6nw0J0JrubPF781QfpzfWIxAOmOs\"]'),(x'45397470352355457625','P',6048.00,'D鍴w7uD拧smV朖vXX','V1wuo-f&xl',6838.942573493885,231,'#ZOBYUa=瀒%=','3ovXFXxPFJ=&B22i%=Y','[\"OuHiJD73Kmh8Vz039cc5LMl7Q6JACvpYX4f5B8Py4hrqHwiJpWICsa9CJRGapMwr\", \"TJKC51JSAAvV329r2cdEiiu3jczu1Wx5tZqxtnZmCEpPwmIpDlk9RMIQW17nYTmA\", \"tb9C6Q6ewLXDRrgvKU4P6FKtMD9HOXxNXYbKlNYxwzzXPDcaqIgTT7KvCxsW9tS5\"]'),(x'45397470352355457625','V粭p韪UATd粓!轅',8.46,'曹RiTp%PRqdJ饺7&=钀','WxOa~pf',6838.942573493885,232,'w锢)SWu穘','3ovXFXxPFJ=&B22i%=Y','[\"2yafOGkKlEyuBif1C5GjBA4nzJF0JN5zYvKPwIyhXY7DudPffcZvh9n3DTJIqxdw\", \"poRgkwstQUlY2B2CQXHSinL6X2s0A4zsCDoED3NIE6C5uaWNJGb9rZtphzsmZKfq\", \"jHfFHMGOuVpDJYmX0Cw5JavLXgEZpfQa2JuRZRz0fhByEntaioMKsD7HqwCdWNP9\", \"4Ern6OSm4KYEmpIDTalF10fVChbjBsS1BT0D1RXhmBsvPighbYkjOzYRSW6j8ANz\", \"Qf80HsNf8qHR8fqVaWYoLz7J1Dd1S8k2JOoEACpcetutsyXSqsB8WfjPr3T9vISz\"]'),(x'45397470352355457625','$%Jv焒偶厩)疖K',147.00,'L甧娜jK闥1窴%v軥h','R@R=cp!X*',6838.942573493885,233,'hE輍','3ovXFXxPFJ=&B22i%=Y','[\"3KPrmXh5oOPrqyQldE6s6OWdJj2XPoQ7qzVQAsYYyQgvd2ZXbYlInL2nalyZAuAW\", \"ckCWMD2kd0WyiHWLj9JFHQeJbY0JojWDBcm0WJohbPFZe7nfUqgyPVJi3UTbRjCh\"]'),(x'45397470352355457625','jg橿B@jNczK偃#',92570.00,'0L墊ib86堟J鈥p瓶8mT怚M9','ms',318.6727891836038,234,'es@讀彝e-K','3ovXFXxPFJ=&B22i%=Y','[\"xFSxkXtRGZ7X8UlSce9bM3hujyBkfHtliF7h8YGWgqRayh7rJLy0bSVUFDPCbiQU\"]'),(x'45397470352355457625','+QPF愦K',9.95,'澊C銴T0eTWC*W趜ps','cJRveZI$oQ#hNt4l',6838.942573493885,239,'nv-yI4vi跧h弅)禐C','3ovXFXxPFJ=&B22i%=Y','[\"smMM9iqkNfyCdOWZSer0hXFH1Rd019z4F06bDI13YzCEk8kTeBz61w6uG3J46XFz\", \"dl2cMgoj2VjjtEgwT8lHLSAgE6DAjRwdEzmlgK6ttPDbkrQ6Th932wcYB3Wj5QCd\", \"BGr5BbBl7LHn25b8Bmpe276S9JiMqm9guMn6e0GzHYc5EVJ8B55ckraYnDtfGcfm\", \"wMJAtJmg21BJH8xtf2vsiTITxn058VWPQYuMYH3W3QkvPLBCAQr0xpOEYLBQ5vOK\", \"phXYFwYjfTykC028WHuhm5xqkZHdPXirHZ1R4FjNEGcRilOkA9O76VTzTkC1lkI9\"]'),(x'45397470352355457625','n9=gaoY鈜Oo夗b蝩魚4_i)1',22067.90,'kd橝q鄪趰','NGBL3)',6838.942573493885,244,'緉#V仨)f慬nKWF喱','3ovXFXxPFJ=&B22i%=Y','[\"eFj5Jhcquu6MZLdHSnqrppi4koOJ5aDra9vj08YpZJecBqzDBgP5FLftKdKlJWPK\", \"iuxIMCtIBmYgwwzdYjOFYdZEeJ23pVElZuN0iNfyxu1OwYR26J39rUARoXOj8LpA\"]'),(x'45397470352355457625','h8教E緆霧5*z*',0.17,'c觷p齡R橑eu','$jFShFfiM+d@fuK',6838.942573493885,246,'RqF媇odL蝁K-y麑','3ovXFXxPFJ=&B22i%=Y','[\"VPd5N5nR0EIee1rzDYwTBa7BXPmGOV5160bm787tQgto0wPZuECNlNlE5xulp8Qa\", \"ql5xaBmQb7oRQZjn29pF4G2kLga4BhjJmrdjnMSqblz8gdIqNB2k3VkDM7DXXSl7\", \"rz85BQ7k1cw27C1b5IbgrWXe0xOuEwCkWTVRcWBuSYsRt065Ob6NOAWt9JndUq8C\"]'),(x'45397470352355457625','my@扻棒z嚦1嬵QPv',8.00,'乱','N%fL!g5Zi=RLG=QD',9809.290737797808,254,'r3躝葯鷋h$轲眮b絋jZ喬KprN','3ovXFXxPFJ=&B22i%=Y','[\"EuyhAB8DsueD06eQekP39pTyUFJabFTUWvsl1mkwrsrGG6uBAEAQPa5DAwvs6wKw\", \"yQlyzNNyX2wtDBC4WKEZaJG11QQyO1InBNFjSOq5BgSprqvMx4FKSrebXX5W0cIv\"]'),(x'45397470352355457625','p擡sKPP嬑鮒牸鶸餒u*&',99.00,'范','',1621.465891863473,255,'','3ovXFXxPFJ=&B22i%=Y','[\"XhsyefxOM8zwmKctCleKwJZ1BVyE5glV0sShcxK64dYvffLzbj2NfbgzDHtdFp1X\", \"IRqgPqs4aD0iVlHbgAfqqLSsyCLx69hOCegAklL7aQkUO8e5Qfl6xNJpd9kMiIZx\", \"Q95kv0jnZBDXNQRceWEJX0AfYEQgNi6tgYYaiFmQZQySRCmj5Fr0xJysDSd1PZpV\"]');

SELECT col_93 FROM `tde5cf9ab` JOIN `te508771b` ON `tde5cf9ab`.`col_35`=`te508771b`.`col_87` WHERE `te508771b`.`col_93`=55;

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

One row in result

3. What did you see instead (Required)

mysql> SELECT col_93 FROM `tde5cf9ab` JOIN `te508771b` ON `tde5cf9ab`.`col_35`=`te508771b`.`col_87` WHERE `te508771b`.`col_93`=55;
Empty set (0.00 sec)

4. What is your TiDB version? (Required)

e4e08f0

@kennedy8312
Copy link

/type regression

@kennedy8312
Copy link

Regression Analysis
The testcase became successful since v6.6.0 but started to fail recently.
Version v6.6.0 : Success
Version v7.0.0 : Success
Version v7.1.0 : Success
Version v7.2.0 : Success
Version v7.3.0 : Success
Version v7.4.0 : Success
Version v7.5.0 : Success
Version v7.6.0 : Success
Version nightly : Failure

@kennedy8312
Copy link

Regression Analysis
PR caused this regression: #49161
The testcase was executed successfully on commit 2d57833 but started to failed on commit ccbab5e.
Commit 46e95f4 : Failure
Commit ccbab5e : Failure
Commit d604b06 : Success
Commit 2d57833 : Success

@wjhuang2016
Copy link
Member Author

CREATE TABLE `tac6a05e5` (
  `col_46` varchar(397) DEFAULT NULL,
  `col_47` int(11) DEFAULT NULL,
  `col_48` int(10) unsigned NOT NULL DEFAULT '2063908831',
  `col_49` varchar(217) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT '愃FV_灠蟟蠇驀泔N5惷cm澉痥邍H',
  `col_50` json DEFAULT NULL,
  `col_51` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `col_52` char(8) DEFAULT 'kf^n',
  `col_53` json DEFAULT NULL,
  PRIMARY KEY (`col_48`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
PARTITION BY HASH (`col_48`) PARTITIONS 5
INSERT INTO `tac6a05e5` VALUES('oCMu',1448604706,1,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('zwN0SwW5%',1654477251,2,'tbn觼労駋AqJ姤霔N','[0.8155019522715178, 0.16543520110622545, 0.0732445195875062]','B31lod','','[\"V9YRZJN4U1SHDuXm8SLApWUYf16t4EFIkAsI40aeAGOW0uKjwSEDvOeMgKnp3qjE\", \"QSRhG2z0yFXW6HMCVlPKD9LLfkdqj1uS9DgbVh1iJihPNN2lyMlk5Hi9HkUVuftE\", \"p65MERPWqPO62Z5iFEmZoruxzupWe9KIvCuCFLoAPEdBTpJ77hxfZCGY3Nmzw2Sf\"]'),('sEB~ppF*bG',1603138437,37843307,'氽鐓+絞qjWoq阔','[0.7819687681122546, 0.08170947631899626, 0.7197072719772959, 0.2523569657879634, 0.08216294018233623]','2^hNqtMblFLM','','[\"MMbF0Kuur8dXmdmO1Gd2Mc4SvbS6ZpjSMjwchZxHfjM12nwlSzEUaazDVs5gMPdY\", \"JL3VWeT1UihVPaO63uh7R7zemDh7seRiU7QKjPPyzvTIQ8TphvmofxaNYHEjWxfo\", \"LnpNrUPqMBraxCdpi5Tm5eMUHYFC6KF4iQ0qNHXFW80BpFY6KH0M5U0CzCJYvKdB\", \"Ot4P2HNNauuCDSMM5tqMDoBPD4JuhUIRS8bxV4UZjMwHfHQ5hGmu8CKBMcyp0Gzh\", \"KJiv4wA16p3oLnB9ZBfdNFqPRArNUO1ZwrhqtHK0JXUyTT3UTLDf6wmvMNn2PwBP\"]'),('bDjWyysVr9V+c',1268099130,107687302,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('hCGC',-2147483647,250644837,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('19BA',-1091021589,271806903,'O粣妡4X頞H*篱Db堷E餵','[0.8666308004313545, 0.2621532718342127, 0.5727019210960996, 0.9270058069442341]','oJ8b','eu)','[\"p8iYl7Mi4szkkdIBjeqIBkd7ndrciScbSwCmt8pggT6pGyGpmqqaVvYMYXiw2jKL\", \"uE4Uav5pCCzt56lOaO7Uek7H1rQ1yeu2ig0Q65ux0Wj88P0OqIgPj9m5oMW3zTEO\"]'),('-JZLWy8I-ganG$',442130558,512378048,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('$tV$~%WWTFHygJ6',1226826461,620530205,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('i1EQt3_2lXj',1492754603,721824456,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('',-1667908744,748708502,'Y佑%','[0.30715052035591783, 0.171552691907414, 0.0677093832181976, 0.8662012957586579, 0.49259869656729294]','L*Yb6pn$-tI2EHXF','nr','[\"AlCN5Jtn3u5s9QarwvqjsEbc6oFxsWbGc4HhpjQ41u9ThKiX1Drrm6C5qBh97j49\", \"JLDBBVe8MZJNg7O0ZDCKNLQGkwRzWmQ4UcA89C6qHeTMF20NkTX6LOYI2WHVS1ST\"]'),(NULL,-924970232,768812216,'嘏fd+',NULL,'T4-Lr056vo','Yo%Xd','[\"rkPsyCWIKPdgN5Suocz5dBnmiIDFvmBIZ8RSRnQYP2nlvE0Pkxzg757igdNueTXg\", \"EtEH8mMgkAC9wx4STNBVYnAtGE85HsgXE8A8MtDpNVVztdl6P454b4sucHFt4nsF\", \"W57qEmVtpSRO9khiSGTSCA34GbT7pOZvbYDVdDuPCabmwITGM8eKHMELZXrDDUO1\", \"aIkvnQPwsEB3ZWxfJcOhjgvDLCMbk6Bi1aYPmIBj2TnsI2CyxdRxtnjx5Fa5Yw4S\", \"dUnmeVxENvSMYqAh4ctC7xKd2ioqAuZ9CS5w53r1Bb6tdmBsxaQdb38FWCgWCmlY\"]'),('XlRZier^C!c',-73846817,813925959,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"Lh1NYh2U5v7rKPL55wsz7AZTZ5XwZE6s4uYZRxynyD41u2HvBhP0RsvVhPwp25yq\", \"WpBnk5LAxxaqWLXDKkza32JWMAeVJD6oGygGfpfVwdIbJ2rN6fy77UTMUGO81sC2\", \"TzRlZDEtEN0UbLxeRvMe7x7VxR6c7SJO9eoiSPoZiDiXf5LoAcjO40g9nnLca5I2\", \"By8TbJkifGZtPMWBssfeCZduFjCxAm8dsljIhEgXQlyu3JugjApxuINEj0ksepN5\"]'),('W+&uZc%G092)7sUC',1067999499,826505551,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('$nv)y',-1590101037,830721406,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"wrVLpQ3OdFT2B2V0eXp3L2dXryiKhp7R69jXgHQglCrz5g58oSo5PFyJiF7mJviU\", \"oO0g1RlW5KJIqL7YEeHhjeTJjEqHzHQqTcmo9XZa8kGJ4grA5Z8tOBPeTCSAGzHI\", \"CwlhJ1WMDWBfTOpBrtcD3MXlDqypHg3AlJE5t8kQLgKkp3jzGMawaN4n0ZF4JYfr\", \"6xnWkiwnszZ9oDnXNPK0M2gFbeZBGIxMqqFCe0BCTSBLnB23Tg8bGnascKMv4yTf\", \"uYHBZXRegMswxj4hhZQP5KhfFV7ugWgHTmrUDlmvkCHK8G1scCy6F7gaKAQsbrXx\"]'),('L-Tn',1,897936682,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"rVBAVVbBfpU2f6mcgYLDbdPIaY1AEDnMqs81bLW5CPRoMybisk9L9XZKaQ3C5cPw\", \"OEWgSv3WL0IXmEB5ueH2rtKbdQKNF3rn2KDwbZYSXqLUN5SWYp5d6tj3BN5vQQ9b\", \"uIzW3uyTagsrg3qg1Hbn58tyDUffeOBBhRgq2koCo6z6qXDcBsHtOENTyKTKbdmT\", \"1zDhkf8MH44Weig9WX9RUrW1a7Rx4qRpQylUIQScQle1qo9jcjXODH2RQkb2luZQ\", \"qSVloR5puaTgwGO8IHifJe6f6ygVXUtOkdSibrv20RdNNgpkN0c6BPUmwIlf3j7e\"]'),('OJ9$7XAac',-523480678,905091218,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('~xD%*&kLp3!',345260657,1024693685,'扫秙竢(&%嘛佀AxXH曩Hmq擩B','[0.6588246973722834, 0.33667419818281447, 0.6737910959588643]','h(','@Ia5g',NULL),('W%jFY0Bu',1328990238,1154666217,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('xdr-IdRvw=8%SPiOcu',1492754603,1278792746,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('VOccAg',-2144544676,1403585041,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('09tZ#_RdeXV9Wj',276279286,1569623309,'Xvn烪0亨檗Dw鄔','[0.3070584431898418]','B31lod','','[\"EBUuXLENn6DPodo0SRf4c4g9zlqyTQxziBCYgUoQsyzYMcTCX8PpzjHiDVxyKQU0\", \"kYI4Ne100b0hmRZtKpSH3WWAAikTkXsh7QcKyyWstnQSQhkriz2AKuPSgIv1nFTK\", \"E3wHUFBJAxCNVs8rJ8UzkFZHuLG9TpYaTJVyCu8G4hF00Sb17hhbffMsPzXQXkH2\", \"BwterZRjUtu3K3YiZ0tDLu3aXasWxA6g3EAFvcnUJob2bwe1zTXvQwEdl6GAZpcH\"]'),('eHPVOFr--@!c0p-B',393228015,1575641036,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('#',-2010279253,1633630583,'NjCQw_M5戂L(銴x伋@','[0.7950291567372625, 0.42457620669002893, 0.36216355140382955, 0.5918892588635414]','s6x(bmLbZwS','','[\"SgpQmsJv3crBQjQh5uko8mdZTfHujHmjbSq3YAPnW2AYEvOnZUeH1Bv135uRbz4Y\", \"UqpWPCmV5lKG7SQajlTPIdUyJDywZQSj9FH2vUOU7qzEXEJzllV3iPtpyI2wt0RO\"]'),(NULL,NULL,2023333960,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','_h','poE','[\"Pt8sXU4MHxymtcxqfQ4d8grL8Whnd5YALkfJWoq7QM1DdFBfSKTXmrjOB0bsdW1F\", \"MUSM5yay4pKIQUtvLEEogTCdJxCBp0tLnx2yrcjQEXz2UJPLrIlSAs9eSNE57gOh\"]'),('^',1493259749,2147483648,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('Jnyym~a#kL*d',1492754603,2148978401,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('yUXo&!xbypWxpPgc_',-1104403882,2199535815,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('m#@st',1099823302,2226127359,'udl豼K鶲Y07谒','[0.9763299237180068, 0.8587852925321978, 0.2436133606576937, 0.09349551243877566]','cwLhwP','CZm','[\"bfdOzIRLjfcXN2vmC74Mn9sSN8YvyfYQGBObFSkbU8sRPty0Azx6IR462GHbWL6U\", \"cLEbiY2YQlkKNTL7k0LSjI9k7QsYL3QumqALG3M6E0xOcgo8rVv6fxHFNGgQWL47\", \"A3tAPsqCFv2kc6Ak9Oq1NYmEotRpPw8XSMSav4fHJVn8OX9eOIV0i9fruOijOW48\", \"1dXVqIdT3uTMZ8wY2eKAoOUiRwbSAX3Nxs5vVWAxxxKpgTxYbgMx7rY6cLK4CJw2\"]'),('aiHRYa8uui-',-1138400969,2289157478,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"AKLQXETK5T49GWBzdNYWrrPggF7sCU4t2leNRbFmCbARyU55kjqCkEOlDNf8lpzi\", \"zSp1XU3S43jGbkD8Fx1EPjNcCu6fPfBy1YwUWIfP4aCb345oOewAQE1l24x04Fmw\", \"u9WBsM0Fr3T2VCEXBmzkjIacq4KKaZWrhlBPkRMVRufAopftyunzwIVmrNIq7qmB\"]'),('b5gIit5AEG&JAZ',1492754603,2349910941,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('do$KxdC02L-B)',199794886,2458846104,'z埜','[0.6644051004745527, 0.5803598251538569, 0.32008427501293013, 0.779018058250839, 0.7058791783606267]','','','[\"Uk0YaRJdgMmxiXGOyPz88xOFWf1Y3gFGTqD0qlDbJ5adiNVLpR5rGizLo6Ba9QhA\", \"vjTMY5MCz8MAGIvBZa4TROAydfwkfkPluN4BEz96NXhAzcStQIMeKeYqx1uTUv6y\", \"HonN9240KDhVXnhVXhEUNr2PxBU32GAPAQlsHJXGBRrgBtQ47xXD554sMoSH0hv4\", \"Q1bamk9I1cEov5lCrlne963qrLHTApCIjuVApLvzm5HsxNx22YibVdbND3NCrYbs\", \"KpAUfIukxFR9MhL78HORCKxLEYeWm1rXeYf4FDNCruwg4xgAvtONfIpYrZMUrD3D\"]'),('FHV-6J7W',-1413993681,2497561780,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('unK',1492754603,2583730738,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('QCkn',1460747060,2694613274,'Z檖緑鈐eL设C1方&尯輸u=鋒w#','[0.4345471608455741, 0.12204309748445161, 0.06619435345939846]','TZ','','[\"dydvRi30mutx6hTOXGqNcq2gCNpKWGBkcnkL2ouqHopwDt1TEj59DFJnxkm8UWWV\", \"emQk7RkFIK74YC2KJ3GXsLtH6wFVH7OKznvipDa1ecZWDCb2B7Hi7ONVXq6MrNRF\", \"guO1fMhOp91iCDTleN9EuY3ZrJN7PNxBQfUF2B5DW6TM8DpLStimR2FBMDfsOHNa\", \"SMlNz8vYPzsgrgjgeUYb6JxxgTvt2vYau4Q2hYt96dNP96HL3EkqwP0reecBBgub\", \"4UWKZjYdxGrboQQbVkFPOjfCfb1PZnvKBiFluq6sknu64QfJwtehoI1RLlhMWz42\"]'),('OnGUZw~_3aR1ukwa*R*',674119809,2752532792,'ml錴唬潓婫Yd蹝*~+o','[0.2922117688402791, 0.7420306580495416, 0.5041928940085125]','+D$nqv=MtH2cmSk-','$fr((2','[\"zO9Fnh56esuvXTcoab03qWKRvn2jVZUO8W6vw4Z9JrZu9jeGItevXpa4YPOGbAdf\", \"CjN032zZ5VSuPw8UQkevxPmPlYeZ754s3ezCPIz0yHYfWN2SQlRbnokGOy7pNTs2\", \"s28eTEyCEi5V1rR9AWyAxp9FLPvbkxOVWSunngUap08EDUT08eLSRSdT7wi2mIih\", \"ZsqZvR1acmF27LWcZesAPf9nz92Dn6ND2wjCjpZYGOaO0Gp9AY6e0ZbK9g4AW63f\", \"OH6NGfxxpNAGAZJqYeRjQzYYd8ysA7tX04K23CkN8LHiC6htog8TYC6Rak28XoDz\"]'),('mH',54107353,2787006270,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('iu2+nyfH9',1269293150,2793424570,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('SY%^pt*P)',NULL,2852635227,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"QyO5n2wWTjZuHc9Hj4FAZzYqxhX57X8cEN4yX2jmgtLJ7TiNAu71EPPJJhfSWd0Z\", \"HoDxPD7vHOdWanvVsewBZ6Yzx2DnYpf3g4Ui51Pt1tiVyoc8vfE6B8lyPw7TvBIo\", \"Z78sepKhx538Rri6NMGGvzuWaJW7wFomPyPDTYr8aW0iJio69LfEmArfDVaDjWxl\", \"CvVNlvu8p1lfiQlmfj4dSHQ59OwhKVYOtpBX8A90TfP42NooGKAR8SsYUbzWRC0T\"]'),('@eIa',748560374,2953298874,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('aR@ZgP',-1124151169,2965229458,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('P2',1492754603,3094328809,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('5scy',2,3156683030,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('7kl058i^eJ',-945474752,3204072901,'昋Wg輏曮荷t(B蝫YcF燿','[0.6877823942864568, 0.5012083843506608]','B31lod','','[\"3DPtht6IGsHBCBXeIfswrUx65MUMjBXAEqyQViZpFFzzO8Ca709kONHuL68uMoTb\", \"FTSj8BQvAMtTS2KWcfdPbobCOuxg5IStszWxftBfHeJMLq6VEX9Lf11dnuo6Subf\", \"FNlwqfxpXHfJrcoM4WQZ083cPu47UcovTojqXuqwIYAtXJDw1uL6ZoAF3Hjof5M4\"]'),('ntsU4Xa1YFaq7H*G',-1779829176,3311141989,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),(NULL,595970938,3458924918,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','sSZ=TbQGO!$rX','poE','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('G%Lq7CCPBO)*',1492754603,3616891219,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),(')d%#',945773292,3668259561,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('v',604755552,3839319591,'dFs殟懩bYD乨Aq1mQs=猻','[0.5821006441479657]','Mvhpo9@1WBn','ounJL','[\"NbKpzkDkbmwBhn6CnbRv7ETqcP07u5HkW15lPaNW4VF8uQ57WFFpMlE8TBFgvhFl\", \"nTdEE6dyBg5AMidmmNNLvzkTHbsGvLfFz5lYX8hiUbDaXZv9Ny3Gx08TLiU3dUP4\", \"emEI2YJgVM0HiRNpFejSUcNgIcXvBWTIipnAm870WahrQtQVTAet3xAn00FJLxnW\", \"Wtcly8BJRf1D2HaEgJ93zyemLbKqQhAJdoadP3ZhELCmQlsLSMGw4B2ASPNnFOQ8\", \"c06JYFvB1CX5qa7466jDvuy6aSZqVPmY5Xi0y1aOmADAkxLFjuZytUsanYqzHNUM\"]'),('aX8I@Jm',-2017571685,3975544550,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('ce1',486478968,4098921295,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"bNQMi82oNFrCxybf134ca5bT984zhzhjiiO4F6mMNgWR7FLhzTdurtuTfbh2Khho\", \"x19ksUSJBMbbIvOlH5nXDhhvJcvmYbWmqTDSg6NRR6oMmFH7w7Dyqqz1fZspcPuO\", \"bUljYZdKwiih5g6w3g3rS4mqLjaTfLvgxhLx1itakfMzCr7VvdteeGB6ScZYdx69\"]'),(')W~P=8Az',0,4107284102,'UL脠6頏w鯶','[0.6188795182532886, 0.6820914758996461]','B31lod','','[\"gl6Sfc0MuEekEwGJyxUlAQOS91JqCIdtiUreR7B5zbp9Y72DmrI9e9t5DSPnbpdt\", \"1MrO7eRopVnBfs6HeXjtkijEyeQoEhqMvC4ad0uzY1ouNpewAEweVyMV2kRJU4N6\", \"EEpLNiPwWHHkWcV44zPZ8ZtuP07vYDCqK9Ml0EhZhowhdYE9bkR0TPI9eUYyMmEP\"]'),('6PJ+ufKeLTFCW(@Yah',NULL,4219573686,'梻鏟','[0.7814882761502356, 0.3337397151698245, 0.3908971450854904, 0.26602783654136075, 0.7192424389018779]','3G(N-4','Y','[\"1xAWYMexygS8BQUlgYYns9leesdmeKA9GPRgvNFyBu3wPof55CDvZf2lhyh9MFXN\", \"nRNgvWb4v2aE87E6lBfxDBQnfph8OUO73Ot8ctHIS5eoIsCtiY66uP1pQZBa1BSh\"]');

select    tac6a05e5.col_52 as r0 , space( 1 ) as r1 , tac6a05e5.col_48 as r2  from tac6a05e5 where tac6a05e5.col_48 in ( 813925959 );

@mjonss
Copy link
Contributor

mjonss commented Mar 28, 2024

Minimal test case:

create table t (a int, b int, primary key (b)) partition by hash(b) partitions 5;
insert into t values (1,1);
select space(1), b from t where b in (1);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants