查询时 order by 与 limit 同时使用的情况可能提示 Unknown datatype: STRING #14307
Description
Discussed in #14173
Originally posted by ptma November 22, 2024
IoTDB 版本： 1.3.3
操作系统：WIndows 11
运行环境：WSL 内的 Docker
复现步骤：
create database root.test;
create aligned timeseries root.test.dev (name STRING encoding=PLAIN compressor=LZ4, enum STRING encoding=DICTIONARY compressor=LZ4, ts INT64 encoding=TS_2DIFF compressor=LZ4, context TEXT encoding=PLAIN compressor=LZ4);
insert into root.test.dev(timestamp, name, enum, ts, context) aligned values(1732186175000, 'n1', 'e1', 1732186175000, null),(1732186175001, 'n2', 'e2', 1732186175001, null),(1732186175002, 'n3', 'e3', 1732186175002, null),(1732186175003, 'n4', 'e4', 1732186175003, 'empty context');
select * from root.test.dev order by ts desc limit 1 offset 0 align by device;
以上SQL均通过 /rest/v2 相应接口执行。
执行最后的查询语句时， 返回结果是：
{
"code": 301,
"message": "Unsupported dataType: Unknown datatype: STRING"
}
去除 order by 或 limit offset 后查询结果均符合预期。