2022-11-28 mysql column storage engine-varchar(255) The result of adding data is not queried-problem record

Summary:

mysql column storage engine-varchar(255) The result of adding data is not queried-problem record

Related ISSUE: https://github.com/stoneatom/stonedb/issues/959

DDL: Table structure:

CREATE TABLE device_delta_collect(reportTime varchar(255) DEFAULT NULL,deviceId varchar(255) DEFAULT NULL,multiple varchar(255) DEFAULT NULL,deltaJgs varchar(255) DEFAULT NULL) ENGINE = tianmu;

Insert data:

insert into device_delta_collect (reportTime, deviceId, deltaJgs, multiple) values ​​('2022-08-20 22:33:58', '1547034559760195585', '1', '1');

Query SQL:

select * from device_delta_collect a where a.deviceId = 154703