'question about creating upper case database name or table name in TDengine database

In TDengine shell, any upper case letter is automatically converted to a lower case letter like below:

taos> create database TEST;
Query OK, 0 of 0 row(s) in database (0.002404s)

taos> show databases;
              name              |      created_time       |   ntables   |   vgroups   | replica | quorum |  days  |           keep           |  cache(MB)  |   blocks    |   minrows   |   maxrows   | wallevel |    fsync    | comp | cachelast | precision | update |   status   |
====================================================================================================================================================================================================================================================================================
 test                           | 2021-11-16 16:07:47.410 |           0 |           0 |       1 |      1 |     10 | 3650                     |          16 |           6 |         100 |        4096 |        1 |        3000 |    2 |         0 | ms        |      0 | ready      |
 db                             | 2021-11-16 13:30:46.858 |          13 |           1 |       1 |      1 |     10 | 3650                     |          16 |           6 |         100 |        4096 |        1 |        3000 |    2 |         0 | ms        |      0 | ready      |
Query OK, 2 row(s) in set (0.001591s)

taos> use test;
Database changed.

taos> create table STB(ts timestamp, c1 int) tags(t1 int);
Query OK, 0 of 0 row(s) in database (0.002349s)

taos> show stables;
              name              |      created_time       | columns |  tags  |   tables    |
============================================================================================
 stb                            | 2021-11-16 16:08:34.322 |       2 |      1 |           0 |
Query OK, 1 row(s) in set (0.001501s)

Is there any way to create a database name or table name in upper case letters?



Solution 1:[1]

upper case database name is not supported in TDengine database, but upper case table name is supported by use following SQL:

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

taos> show tables;
           table_name           |      created_time       | columns |          stable_name           |          uid          |     tid     |    vgId     |
==========================================================================================================================================================
 UPPER_CASE_TABLE_NAME          | 2022-05-05 18:40:21.011 |       2 |                                |     40813871670686384 |           2 |         145 |
Query OK, 1 row(s) in set (0.007461s)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Xiao Ping