用DBeaver生成Delete语句

DELETE FROM iotdb.car
WHERE ts = ‘2024-08-31 07:21:14.000’ AND val = 200.0

执行后报错：The DELETE statement must have a definite time window range

以为是要加时间范围。修改成

DELETE FROM iotdb.car
WHERE ts > ‘2024-08-31 07:21:13.000’ AND
ts > ‘2024-08-31 07:21:14.000 AND val = 200.0

还是报同样的错误，以为是时间范围太大还是太小，进行各种修改时间范围还是报错依旧。

看了官方文档说明：

0x80002655

The DELETE statement must have a definite time window range

DELETE语句中存在非法WHERE条件

检查并修正SQL语句

结果官方示例，修改为：

DELETE FROM iotdb.car
WHERE ts = ‘2024-08-31 07:21:14.000’

果然执行成功了。TDEngine还是有些和Mysql有些不同，现在用的
DBeaver 进行删除行也是报错，用DBeaver生成的sql有时是存在问题。还是要结合官方文档进行判断。