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
你可能想看:
分享给朋友: