TDengine数据库查询关键字是否区分大小写？

Question

在创建了一个标签名与表名相同但大写的超级表之后：

taos> select *,tbname from stb001;
       point_time        |       value_double        |           tab_column           |             tbname             |
========================================================================================================================
 2021-08-14 12:51:46.235 |            1000.000000000 | STB001_AI001                   | stb001_ai001                   |
 2021-08-14 12:51:54.398 |            1001.000000000 | STB001_AI001                   | stb001_ai001                   |
 2021-08-14 12:51:56.734 |            1002.000000000 | STB001_AI001                   | stb001_ai001                   |

当我试图用大写标记筛选器查询超级表时，查询结果看起来很好，但是使用"tbname in“语法则没有查询输出。这是一个错误，还是TDengine对待不同的查询过滤器关键字区分大小写？

taos> select * from stb001 where tab_column = "STB001_AI001";
       point_time        |       value_double        |           tab_column           |
=======================================================================================
 2021-08-14 12:51:46.235 |            1000.000000000 | STB001_AI001                   |
 2021-08-14 12:51:54.398 |            1001.000000000 | STB001_AI001                   |
 2021-08-14 12:51:56.734 |            1002.000000000 | STB001_AI001                   |
Query OK, 3 row(s) in set (0.003173s)


taos> select * from stb001 where tbname in ('STB001_AI001');
Query OK, 0 row(s) in set (0.001668s)

Answer 1

结果在2.2版本中出现了一个错误。试用后的2.4版本，问题正在得到解决，tbname应该是不区分大小写的。

Answer 2

尝试最新版本的TDengine数据库(2.4.0.20)，现在应该支持它

taos> create table `TB`(ts timestamp, c1 int);
Query OK, 0 of 0 row(s) in database (0.011564s)

taos> insert into `TB` values(now, 1);
Query OK, 1 of 1 row(s) in database (0.001930s)

taos> select * from `TB`;
           ts            |     c1      |
========================================
 2022-05-18 22:55:34.706 |           1 |
Query OK, 1 row(s) in set (0.001631s)