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
你可能想看: