incorrect query result using tiflash

[wjhuang2016]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE `t5d83c14e` (
  `col_71` datetime NOT NULL,
  `col_72` smallint NOT NULL,
  `col_73` vector DEFAULT NULL,
  `col_74` vector(3) NOT NULL,
  `col_75` timestamp NOT NULL DEFAULT '2022-10-30 00:00:00',
  PRIMARY KEY (`col_72`,`col_75`) /*T![clustered_index] CLUSTERED */,
  VECTOR INDEX `idx_60_30`((VEC_COSINE_DISTANCE(`col_74`))),
  KEY `idx_86_32` (`col_72`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
INSERT INTO `t5d83c14e` VALUES('1997-06-02 00:00:00',-32767,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.595202,0.98292,0.211111]','1970-03-08 00:00:00'),('1997-06-02 00:00:00',-32767,'[0.111203,0.922779,0.078851,0.518938,0.293612,0.68666,0.718667,0.419476,0.050084]','[0.750333,0.212158,0.506806]','1989-05-03 00:00:00'),('1997-06-02 00:00:00',-32767,'[0.305545,0.57718,0.599675,0.699096,0.201702,0.325823]','[0.449097,0.358288,0.181479]','2005-06-30 00:00:00'),('1997-06-02 00:00:00',-32767,'[0.261856,0.54542,0.817123]','[0.185462,0.264841,0.143094]','2031-05-11 00:00:00'),('1997-06-02 00:00:00',-31774,'[0.643742,0.284385,0.805546,0.834912,0.981526,0.824475,0.631402,0.972308,0.592998]','[0.0679,0.404766,0.606834]','2018-08-04 00:00:00'),('1997-06-02 00:00:00',-31545,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.75995,0.240068,0.959031]','2019-05-12 00:00:00'),('1997-06-02 00:00:00',-31423,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.549259,0.936732,0.28461]','2008-11-15 00:00:00'),('1997-06-02 00:00:00',-31388,'[0.944119,0.933736,0.267912,0.957544,0.063457,0.788025,0.066535,0.227337,0.073602]','[0.911794,0.634423,0.05987]','1979-04-03 00:00:00'),('1997-06-02 00:00:00',-31067,'[0.904569,0.042623,0.275234,0.448158]','[0.102349,0.998145,0.260784]','2027-01-22 00:00:00'),('1997-06-02 00:00:00',-30376,'[0.263938,0.053424,0.798511,0.549358,0.684768,0.479332,0.822059,0.172083,0.506088]','[0.327285,0.44601,0.853258]','1986-01-18 00:00:00'),('1997-06-02 00:00:00',-29324,'[0.572096,0.381374,0.352808,0.02629,0.0838]','[0.441045,0.191118,0.297384]','2008-02-21 00:00:00'),('1977-05-10 00:00:00',-29074,'[0.926449,0.917026,0.281132,0.749969,0.548502,0.739047,0.760415,0.156273,0.31303,0.870361]','[0.010795,0.33175,0.20399]','1981-07-11 00:00:00'),('1997-06-02 00:00:00',-29030,'[0.795087,0.365764,0.771946,0.926134,0.329711,0.465957,0.039973,0.081334]','[0.360753,0.883274,0.597173]','2009-03-09 00:00:00'),('1997-06-02 00:00:00',-29023,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.643277,0.201494,0.193228]','2028-09-03 00:00:00'),('1997-06-02 00:00:00',-29004,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.568867,0.883071,0.739418]','1973-03-22 00:00:00'),('1997-06-02 00:00:00',-28455,'[0.470043,0.96056,0.349549,0.948879,0.945241]','[0.371677,0.62727,0.870428]','2015-04-21 00:00:00'),('1997-06-02 00:00:00',-28245,'[0.138897,0.301961,0.187254]','[0.213915,0.719106,0.339919]','2000-02-16 00:00:00'),('1997-06-02 00:00:00',-28079,'[0.217444,0.122493,0.635234,0.671389]','[0.217165,0.287665,0.870418]','2009-08-15 00:00:00'),('1997-06-02 00:00:00',-27422,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.546929,0.45166,0.382006]','1977-09-18 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','1971-01-10 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','1972-07-26 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.436422,0.81716,0.435776,0.801028,0.347929,0.740871,0.548766,0.669011,0.263547]','[0.533222,0.020095,0.068165]','1974-06-22 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.162271]','[0.080818,0.230495,0.821841]','1974-08-02 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','1975-10-31 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','1983-06-10 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','1987-03-18 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.839583,0.7915,0.819966,0.058658,0.840964,0.043864]','[0.148285,0.430067,0.279138]','1988-04-26 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.436422,0.81716,0.435776,0.801028,0.347929,0.740871,0.548766,0.669011,0.263547]','[0.179372,0.359242,0.883401]','1990-05-31 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','1992-07-24 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.792731,0.317742,0.043808]','1998-07-23 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','1999-06-15 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','1999-12-04 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.436422,0.81716,0.435776,0.801028,0.347929,0.740871,0.548766,0.669011,0.263547]','[0.414621,0.610404,0.490467]','2005-04-01 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','2012-03-01 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.436422,0.81716,0.435776,0.801028,0.347929,0.740871,0.548766,0.669011,0.263547]','[0.258907,0.88228,0.251092]','2012-04-04 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','2015-01-29 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','2016-04-02 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.923781]','[0.481126,0.413321,0.520981]','2016-08-27 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','2018-06-21 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.693763,0.072145,0.481052]','2019-05-01 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.436422,0.81716,0.435776,0.801028,0.347929,0.740871,0.548766,0.669011,0.263547]','[0.332398,0.374968,0.949825]','2020-03-16 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.83797,0.126929,0.402656,0.443782,0.11819]','[0.076335,0.545897,0.777522]','2023-01-23 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.029346,0.216222,0.1495,0.131974,0.700883,0.182017,0.966644,0.173443,0.757102,0.071411]','[0.520871,0.531145,0.252846]','2032-08-04 00:00:00'),('1997-06-02 00:00:00',-27140,'[0.642713,0.071229]','[0.523883,0.095082,0.785508]','2036-07-05 00:00:00'),('1997-06-02 00:00:00',-26477,'[0.246193,0.929303]','[0.123971,0.909009,0.851098]','1981-02-13 00:00:00'),('1997-06-02 00:00:00',-25771,'[0.558028]','[0.316255,0.518072,0.963122]','2025-09-12 00:00:00'),('1997-06-02 00:00:00',-24742,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.868444,0.383286,0.472138]','1996-12-24 00:00:00'),('1997-06-02 00:00:00',-24167,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.747364,0.687567,0.513857]','2009-06-17 00:00:00'),('1997-06-02 00:00:00',-23517,'[0.204282,0.898598,0.853397,0.838249,0.455578]','[0.440706,0.881371,0.012134]','2016-08-19 00:00:00'),('2012-01-11 00:00:00',-20813,'[0.353558,0.028926]','[0.801093,0.536665,0.798821]','1975-11-22 00:00:00'),('1997-06-02 00:00:00',-20765,'[0.905892]','[0.505051,0.949984,0.881741]','2024-10-04 00:00:00'),('1997-06-02 00:00:00',-19890,'[0.704729,0.140507,0.697433,0.977614]','[0.037301,0.502117,0.700696]','2030-05-03 00:00:00'),('1997-06-02 00:00:00',-19610,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.968941,0.863596,0.157642]','2005-09-29 00:00:00'),('1997-06-02 00:00:00',-18646,'[0.606213,0.418275,0.932638,0.756802,0.326164,0.579533,0.463055,0.63766]','[0.833692,0.249217,0.949573]','2010-10-30 00:00:00'),('1997-06-02 00:00:00',-18084,'[0.73,0.624852,0.745538,0.142759,0.712692,0.550932,0.917636,0.127436]','[0.299531,0.582318,0.391042]','1986-02-17 00:00:00'),('1997-06-02 00:00:00',-17798,'[0.58473,0.945404,0.672817,0.873964]','[0.220463,0.095369,0.77867]','2028-09-28 00:00:00'),('1997-06-02 00:00:00',-17466,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.585812,0.496254,0.200593]','2033-07-04 00:00:00'),('1997-06-02 00:00:00',-15846,'[0.615215,0.742124]','[0.467695,0.411116,0.594731]','1970-12-03 00:00:00'),('1997-06-02 00:00:00',-14281,'[0.116327,0.830822,0.7343,0.968369,0.284138,0.404053,0.744056,0.094552]','[0.795985,0.062203,0.032218]','2013-10-29 00:00:00'),('1997-06-02 00:00:00',-14002,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.669977,0.341963,0.174516]','1998-08-10 00:00:00'),('1997-06-02 00:00:00',-13442,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.788343,0.732875,0.227611]','2028-04-16 00:00:00'),('1997-06-02 00:00:00',-12157,'[0.938243,0.612517,0.648816,0.602262,0.260585,0.780004,0.659188,0.438334,0.862088]','[0.130693,0.775648,0.040674]','1998-06-06 00:00:00'),('1997-06-02 00:00:00',-11932,'[0.792037,0.417108,0.990066,0.62562,0.276641,0.448564,0.564967,0.13108]','[0.302105,0.367515,0.265714]','2036-11-07 00:00:00'),('1997-06-02 00:00:00',-11915,'[0.239337,0.929709,0.605503,0.679705,0.784454]','[0.36479,0.413154,0.77407]','2021-07-31 00:00:00'),('1997-06-02 00:00:00',-10060,'[0.210816,0.815036]','[0.037694,0.819224,0.41912]','2003-06-27 00:00:00'),('1997-06-02 00:00:00',-8606,'[0.678971,0.331149,0.751366,0.503358]','[0.515358,0.976332,0.93167]','1993-06-06 00:00:00'),('1997-06-02 00:00:00',-7322,'[0.558212,0.621172,0.605991,0.998753,0.963854,0.771264,0.991773,0.096717]','[0.354047,0.139515,0.073578]','1984-01-18 00:00:00'),('1997-06-02 00:00:00',-6745,'[0.709779,0.299463,0.66877,0.858386,0.710414,0.979218,0.520103]','[0.456509,0.055517,0.089071]','1970-07-04 00:00:00'),('1997-06-02 00:00:00',-6735,'[0.644818,0.487893,0.361372,0.85803,0.407489,0.654923,0.608347,0.932282,0.527457]','[0.92789,0.432053,0.513989]','1997-02-03 00:00:00'),('1997-06-02 00:00:00',-5846,'[0.036923,0.951582,0.07405,0.080189,0.432236,0.388789,0.319183,0.164996,0.871319,0.97481]','[0.463683,0.415362,0.540749]','1974-05-04 00:00:00'),('1997-06-02 00:00:00',-5713,'[0.248731,0.839886,0.796755]','[0.094965,0.56304,0.594243]','2005-05-29 00:00:00'),('1997-06-02 00:00:00',-5044,'[0.182719,0.141849,0.454529]','[0.328172,0.757291,0.567552]','2032-01-04 00:00:00'),('1997-06-02 00:00:00',-3450,'[0.266931,0.905647,0.217645,0.66789,0.693226,0.03474,0.824322,0.590255]','[0.496186,0.522227,0.30044]','1972-02-29 00:00:00'),('1997-06-02 00:00:00',-2024,'[0.836463,0.161147,0.669181,0.762311,0.712299]','[0.036765,0.894557,0.715755]','1978-02-11 00:00:00'),('1997-06-02 00:00:00',-1813,'[0.066097,0.992733]','[0.519306,0.676324,0.426584]','2013-05-20 00:00:00'),('1997-06-02 00:00:00',-1259,'[0.08293,0.852405,0.06795,0.652395,0.160144,0.102795,0.744408]','[0.241912,0.230552,0.905672]','1995-01-25 00:00:00'),('1997-06-02 00:00:00',-1078,'[0.206559]','[0.375252,0.808161,0.340824]','1978-12-26 00:00:00'),('1997-06-02 00:00:00',-710,'[0.468705,0.800974,0.314842,0.060456,0.747271,0.093119,0.09361,0.167831,0.635606,0.301627]','[0.15459,0.803296,0.887383]','1979-10-25 00:00:00'),('1997-06-02 00:00:00',-591,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.91371,0.155934,0.997282]','1993-01-25 00:00:00'),('1997-06-02 00:00:00',-128,'[0.580843,0.767614,0.420904]','[0.201869,0.152869,0.562923]','1991-08-26 00:00:00'),('1997-06-02 00:00:00',-1,'[0.512163,0.946596,0.694348,0.232772,0.814843,0.722616]','[0.417499,0.886816,0.691939]','1986-07-26 00:00:00'),('1997-06-02 00:00:00',-1,'[0.048471,0.454008,0.201151,0.279706,0.70385,0.306999]','[0.04313,0.836976,0.963444]','1990-06-23 00:00:00'),('1997-06-02 00:00:00',-1,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.607145,0.077383,0.549859]','2032-03-18 00:00:00'),('1997-06-02 00:00:00',0,'[0.227897,0.171346,0.602098,0.160819,0.473462,0.695291,0.603213,0.37813,0.107578,0.32491]','[0.587948,0.381758,0.172168]','1974-10-20 00:00:00'),('1997-06-02 00:00:00',0,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.621945,0.81087,0.067789]','1984-03-27 00:00:00'),('1997-06-02 00:00:00',0,'[0.90594,0.769834,0.415263,0.309526,0.621504,0.28099,0.582957,0.461259,0.928059]','[0.462744,0.387698,0.250341]','2017-07-12 00:00:00'),('1997-06-02 00:00:00',1,'[0.915965,0.690688,0.287329]','[0.649645,0.700846,0.357651]','1971-07-15 00:00:00'),('1997-06-02 00:00:00',1,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.759466,0.026615,0.093144]','2008-12-26 00:00:00'),('1997-06-02 00:00:00',2,'[0.644871,0.617948]','[0.07348,0.054846,0.73245]','1984-12-21 00:00:00'),('1997-06-02 00:00:00',2,'[0.879756,0.163417,0.458478]','[0.528069,0.306994,0.902827]','2003-04-21 00:00:00'),('1997-06-02 00:00:00',101,'[0.73203,0.47908,0.929754,0.873762,0.775943,0.389491,0.872362]','[0.170177,0.529683,0.430224]','1989-12-19 00:00:00'),('1997-06-02 00:00:00',781,'[0.617438,0.862482,0.152748,0.252133,0.799755,0.965555,0.425263,0.37743]','[0.460341,0.532234,0.929476]','2020-04-18 00:00:00'),('1997-06-02 00:00:00',1377,'[0.362592,0.78014,0.360264,0.933672]','[0.153427,0.476106,0.530388]','2003-03-18 00:00:00'),('1997-06-02 00:00:00',1808,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.558912,0.591262,0.259974]','2007-06-15 00:00:00'),('1997-06-02 00:00:00',2108,'[0.355761]','[0.048524,0.472802,0.305596]','1983-11-11 00:00:00'),('1997-06-02 00:00:00',2265,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.763784,0.383653,0.914299]','2026-12-20 00:00:00'),('1997-06-02 00:00:00',2529,'[0.157812,0.662156,0.117386,0.115383,0.272807]','[0.749587,0.926414,0.385066]','1992-04-20 00:00:00'),('1997-06-02 00:00:00',3924,'[0.526968,0.532248,0.326827,0.742487,0.389879,0.719619,0.542522]','[0.499689,0.283433,0.855286]','2015-01-02 00:00:00'),('1997-06-02 00:00:00',4594,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.949773,0.589892,0.8734]','2002-12-26 00:00:00'),('1997-06-02 00:00:00',4948,'[0.477111,0.441435,0.624306,0.512708]','[0.390883,0.415051,0.745345]','2030-04-04 00:00:00'),('1997-06-02 00:00:00',5426,'[0.354145,0.955804,0.268801,0.720179,0.645833,0.033789,0.731001]','[0.505081,0.657301,0.774887]','2016-09-06 00:00:00'),('1997-06-02 00:00:00',5814,'[0.650813,0.67853,0.752939,0.07734,0.598264,0.223905]','[0.196915,0.389067,0.051825]','2021-10-20 00:00:00'),('1997-06-02 00:00:00',6429,'[0.236525]','[0.079631,0.314033,0.725756]','2014-11-06 00:00:00'),('1997-06-02 00:00:00',6700,'[0.917408,0.839418]','[0.410396,0.420213,0.915877]','1986-05-07 00:00:00'),('1997-06-02 00:00:00',7496,'[0.630268,0.424013,0.998856,0.80986,0.148159,0.300593,0.297564,0.930509]','[0.261173,0.53851,0.444395]','1976-09-02 00:00:00'),('1997-06-02 00:00:00',8059,'[0.000542,0.855915,0.339465,0.22014,0.683612]','[0.335187,0.78416,0.914216]','1985-05-13 00:00:00'),('1997-06-02 00:00:00',8620,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.98854,0.035032,0.178086]','1971-03-29 00:00:00'),('1997-06-02 00:00:00',8665,'[0.17023,0.010956,0.914915,0.968624,0.762164,0.191117,0.412171,0.274581,0.841887]','[0.028723,0.148392,0.315962]','2007-07-23 00:00:00'),('1997-06-02 00:00:00',8909,'[0.393766,0.433964,0.834358,0.582876,0.5098,0.147707,0.142755,0.8334,0.228697]','[0.995651,0.143873,0.575409]','2026-02-02 00:00:00'),('1997-06-02 00:00:00',9305,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.804867,0.306324,0.045743]','2034-10-04 00:00:00'),('1997-06-02 00:00:00',10149,'[0.132284]','[0.102044,0.096328,0.816535]','1980-09-19 00:00:00'),('1997-06-02 00:00:00',10979,'[0.079725,0.112657,0.386772,0.136804,0.259315,0.181471,0.835833,0.897405,0.395241]','[0.037374,0.115705,0.539118]','1978-01-11 00:00:00'),('1997-06-02 00:00:00',11263,'[0.040007,0.872071,0.141019]','[0.557159,0.51142,0.403913]','1985-04-19 00:00:00'),('1997-06-02 00:00:00',11565,'[0.557002,0.240106,0.401333,0.515782,0.166882]','[0.465048,0.314894,0.797501]','2006-02-14 00:00:00'),('1997-06-02 00:00:00',12561,'[0.414186,0.179795,0.877938,0.521613,0.479459,0.096933,0.323415,0.161412,0.445268]','[0.123436,0.53021,0.239652]','1970-09-06 00:00:00'),('1997-06-02 00:00:00',12842,'[0.809147,0.064878,0.826763,0.99146,0.522108,0.159389,0.60235]','[0.112754,0.51213,0.715499]','1977-06-20 00:00:00'),('1997-06-02 00:00:00',12987,'[0.832472,0.963883,0.598955,0.202983,0.05175,0.564043,0.851419,0.312211]','[0.695233,0.461154,0.276001]','2033-05-29 00:00:00'),('1997-06-02 00:00:00',13126,'[0.563346]','[0.246747,0.782023,0.594368]','1980-12-28 00:00:00'),('1997-06-02 00:00:00',13141,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.804952,0.580389,0.631699]','2016-02-14 00:00:00'),('1997-06-02 00:00:00',13656,'[0.32523,0.45188,0.755795,0.764398,0.453529,0.920324,0.678236,0.864446,0.62861,0.168533]','[0.500735,0.947617,0.830805]','1980-08-20 00:00:00'),('1997-06-02 00:00:00',13748,'[0.617602,0.101207,0.891953,0.240062]','[0.51545,0.377134,0.836258]','1988-03-07 00:00:00'),('1997-06-02 00:00:00',13845,'[0.748656,0.371344,0.328238]','[0.70196,0.913622,0.836453]','2010-07-14 00:00:00'),('1997-06-02 00:00:00',14702,'[0.321025,0.703877,0.561852,0.885014,0.138747,0.851483,0.273262,0.981995]','[0.246795,0.169079,0.499562]','1978-11-21 00:00:00'),('1997-06-02 00:00:00',14918,'[0.040287,0.208895,0.294009,0.209695,0.406874]','[0.872073,0.148826,0.111457]','2003-05-09 00:00:00'),('1997-06-02 00:00:00',15336,'[0.976924,0.297578,0.968448,0.52727,0.788236]','[0.345283,0.782659,0.8057]','2001-08-15 00:00:00'),('1997-06-02 00:00:00',15748,'[0.937917]','[0.493594,0.620889,0.491436]','2022-05-08 00:00:00'),('1997-06-02 00:00:00',16027,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.618642,0.300181,0.966082]','2001-11-12 00:00:00'),('1997-06-02 00:00:00',16789,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.727132,0.395474,0.247396]','2016-12-08 00:00:00'),('1997-06-02 00:00:00',16790,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.989215,0.332718,0.605322]','1994-10-14 00:00:00'),('1997-06-02 00:00:00',17732,'[0.225545,0.332613,0.901425,0.469466,0.330146]','[0.531578,0.754772,0.716965]','1977-07-17 00:00:00'),('1997-06-02 00:00:00',17926,'[0.703532,0.279244,0.204721,0.968268,0.437175,0.9034]','[0.385932,0.363988,0.828921]','1988-04-18 00:00:00'),('1997-06-02 00:00:00',18051,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.71312,0.145941,0.961243]','1996-01-16 00:00:00'),('1997-06-02 00:00:00',18447,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.561824,0.59188,0.262115]','2033-06-11 00:00:00'),('1997-06-02 00:00:00',18740,'[0.569001,0.648725,0.410501]','[0.099171,0.921481,0.560982]','2011-01-05 00:00:00'),('1997-06-02 00:00:00',19288,'[0.051643,0.420254,0.278209,0.663792,0.989067,0.149104,0.224404]','[0.468737,0.169459,0.251146]','1997-07-17 00:00:00'),('1997-06-02 00:00:00',19605,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.768078,0.747396,0.883766]','1997-07-15 00:00:00'),('1997-06-02 00:00:00',21182,'[0.963124,0.420641]','[0.000275,0.521818,0.646271]','2010-06-29 00:00:00'),('1997-06-02 00:00:00',21344,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.792012,0.438891,0.902374]','2011-04-04 00:00:00'),('1997-06-02 00:00:00',21429,'[0.01609,0.956163,0.087327,0.169958,0.441536]','[0.529478,0.066176,0.208356]','2011-04-11 00:00:00'),('1997-06-02 00:00:00',21731,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.659615,0.569634,0.892593]','2003-08-04 00:00:00'),('1997-06-02 00:00:00',21888,'[0.512928,0.547885,0.587924,0.663873]','[0.461235,0.650872,0.10527]','1982-09-26 00:00:00'),('1997-06-02 00:00:00',22729,'[0.226025,0.507183,0.456076]','[0.290328,0.803145,0.730777]','2003-02-04 00:00:00'),('1997-06-02 00:00:00',23481,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.833653,0.182406,0.064925]','1977-07-25 00:00:00'),('1997-06-02 00:00:00',23717,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.758385,0.198662,0.514837]','2008-10-07 00:00:00'),('1997-06-02 00:00:00',23816,'[0.062936,0.041644,0.721756,0.036719,0.894998,0.350239,0.153187,0.35676,0.736834,0.259712]','[0.477808,0.413003,0.419167]','1970-12-15 00:00:00'),('1997-06-02 00:00:00',24030,'[0.547654,0.20873,0.795017,0.542626,0.339659,0.863195,0.797091,0.104426,0.045414,0.352137]','[0.38643,0.559859,0.715574]','1979-01-25 00:00:00'),('1997-06-02 00:00:00',24548,'[0.200885,0.091479,0.09662,0.035522,0.594101,0.689325,0.913436,0.35476,0.069401]','[0.408614,0.549409,0.017597]','1970-06-27 00:00:00'),('1997-06-02 00:00:00',24613,'[0.811107,0.78634,0.490741,0.435246,0.399039,0.571054]','[0.599308,0.304368,0.304884]','1975-07-17 00:00:00'),('1997-06-02 00:00:00',24717,'[0.088809,0.208642,0.442263,0.975738,0.651782,0.754665]','[0.487949,0.76594,0.184108]','2027-07-26 00:00:00'),('1997-06-02 00:00:00',25382,'[0.027959,0.879189,0.443762,0.170091,0.626107,0.733082,0.807158,0.266388,0.453898,0.681306]','[0.96783,0.576442,0.041146]','1993-11-09 00:00:00'),('1997-06-02 00:00:00',25662,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.55748,0.820662,0.44314]','1991-09-28 00:00:00'),('1997-06-02 00:00:00',25738,'[0.087672,0.332177]','[0.111499,0.735495,0.034318]','2020-07-01 00:00:00'),('1997-06-02 00:00:00',25819,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.537711,0.320084,0.647907]','1992-03-14 00:00:00'),('1997-06-02 00:00:00',26109,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.788238,0.443163,0.008931]','1996-10-22 00:00:00'),('1974-06-06 00:00:00',26353,'[0.298946,0.005813,0.90995,0.399349,0.093597,0.4038,0.964141]','[0.393695,0.07929,0.665814]','2014-10-13 00:00:00'),('1997-06-02 00:00:00',27347,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.579569,0.389749,0.992825]','1986-01-09 00:00:00'),('1997-06-02 00:00:00',27586,'[0.552053,0.831146,0.843679,0.480601,0.232361,0.461416]','[0.289525,0.316021,0.641343]','2024-10-04 00:00:00'),('1997-06-02 00:00:00',27694,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.710473,0.41509,0.668539]','2014-10-02 00:00:00'),('1974-03-25 00:00:00',27796,'[0.398946]','[0.962618,0.178736,0.780836]','1983-05-10 00:00:00'),('1997-06-02 00:00:00',27881,'[0.764718,0.075587]','[0.052795,0.733927,0.134488]','1978-05-06 00:00:00'),('1997-06-02 00:00:00',27983,'[0.162036,0.573583,0.432368,0.127483,0.339862,0.596939,0.038368,0.572115]','[0.107182,0.612622,0.233181]','1975-03-30 00:00:00'),('1997-06-02 00:00:00',28079,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.993938,0.108779,0.072633]','1984-05-12 00:00:00'),('1997-06-02 00:00:00',28686,'[0.869424,0.538353,0.850895,0.619763,0.507878,0.62915,0.011967,0.458862,0.163026,0.953876]','[0.709941,0.895302,0.857838]','2009-08-06 00:00:00'),('1997-06-02 00:00:00',29110,'[0.529746,0.708191,0.669088,0.674597,0.479649,0.132891]','[0.009537,0.799011,0.614103]','2029-12-20 00:00:00'),('1997-06-02 00:00:00',29518,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.927138,0.883522,0.388456]','1981-12-05 00:00:00'),('1997-06-02 00:00:00',31080,'[0.287959,0.001217]','[0.262704,0.542489,0.623862]','1982-01-28 00:00:00'),('1997-06-02 00:00:00',31772,'[0.889929,0.536995,0.811611,0.05697,0.690353,0.135837,0.480615]','[0.338621,0.657552,0.473951]','2011-01-17 00:00:00'),('1997-06-02 00:00:00',31959,'[0.823521,0.954945,0.560966,0.407334,0.26126,0.465878,0.126109]','[0.370785,0.999911,0.87469]','2004-05-14 00:00:00'),('1997-06-02 00:00:00',32116,'[0.550544,0.219204]','[0.711775,0.798893,0.159745]','1991-02-18 00:00:00'),('1997-06-02 00:00:00',32222,'[0.492261,0.606988,0.647302,0.155809,0.346871,0.700184]','[0.887919,0.829547,0.906738]','1979-01-03 00:00:00'),('1997-06-02 00:00:00',32767,'[0.348211,0.885971,0.939769,0.638827]','[0.514159,0.971358,0.305287]','1996-09-15 00:00:00');

SELECT /*+ READ_FROM_STORAGE(TIFLASH[`t5d83c14e`])*/ TRIM(`t5d83c14e`.`col_75`) AS `r0`,`t5d83c14e`.`col_74` AS `r1`,GROUP_CONCAT(`t5d83c14e`.`col_72` ORDER BY `t5d83c14e`.`col_72` SEPARATOR ',') AS `r2` FROM `t5d83c14e` WHERE `t5d83c14e`.`col_75` IN ('2001-08-15','1980-12-28','1973-07-10') GROUP BY `t5d83c14e`.`col_75`,`t5d83c14e`.`col_74`,`t5d83c14e`.`col_71` HAVING `t5d83c14e`.`col_75`<='2026-03-24' AND `t5d83c14e`.`col_74`<='[0.496186, 0.522227, 0.300440]' LIMIT 31822173;

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

mysql> SELECT /*+ READ_FROM_STORAGE(TIFLASH[`t5d83c14e`])*/ TRIM(`t5d83c14e`.`col_75`) AS `r0`,`t5d83c14e`.`col_74` AS `r1`,GROUP_CONCAT(`t5d83c14e`.`col_72` ORDER BY `t5d83c14e`.`col_72` SEPARATOR ',') AS `r2` FROM `t5d83c14e` WHERE `t5d83c14e`.`col_75` IN ('2001-08-15','1980-12-28','1973-07-10') GROUP BY `t5d83c14e`.`col_75`,`t5d83c14e`.`col_74`,`t5d83c14e`.`col_71` HAVING `t5d83c14e`.`col_75`<='2026-03-24' AND `t5d83c14e`.`col_74`<='[0.496186, 0.522227, 0.300440]' LIMIT 31822173;
Empty set (0.32 sec)

mysql> SELECT /*+ READ_FROM_STORAGE(TIKV[`t5d83c14e`])*/ TRIM(`t5d83c14e`.`col_75`) AS `r0`,`t5d83c14e`.`col_74` AS `r1`,GROUP_CONCAT(`t5d83c14e`.`col_72` ORDER BY `t5d83c14e`.`col_72` SEPARATOR ',') AS `r2` FROM `t5d83c14e` WHERE `t5d83c14e`.`col_75` IN ('2001-08-15','1980-12-28','1973-07-10') GROUP BY `t5d83c14e`.`col_75`,`t5d83c14e`.`col_74`,`t5d83c14e`.`col_71` HAVING `t5d83c14e`.`col_75`<='2026-03-24' AND `t5d83c14e`.`col_74`<='[0.496186, 0.522227, 0.300440]' LIMIT 31822173;
+---------------------+------------------------------+-------+
| r0                  | r1                           | r2    |
+---------------------+------------------------------+-------+
| 1980-12-28 00:00:00 | [0.246747,0.782023,0.594368] | 13126 |
| 2001-08-15 00:00:00 | [0.345283,0.782659,0.8057]   | 15336 |
+---------------------+------------------------------+-------+
2 rows in set (0.02 sec)

3. What did you see instead (Required)

The results are not the same between TiKV and TiFlash

4. What is your TiDB version? (Required)

a5832b4