2022-11-28 mysql列存储引擎-varchar(255) The result of adding data is not queried-问题记录

摘要:

mysql列存储引擎-varchar(255) The result of adding data is not queried-问题记录

关联ISSUE:https://github.com/stoneatom/stonedb/issues/959

DDL: 表结构:

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 into device_delta_collect (reportTime, deviceId, deltaJgs, multiple) values ('2022-08-20 22:33:58', '1547034559760195585', '1', '1');

查询SQL:

select * from device_delta_collect a where a.deviceId = 154703