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