11-PseudoColumn¶
¶
Pseudo column basic
1. Create 1 database 1 stable 2 child tables
2. Insert 1 rows for each child table
3. select tbname from stable and check the result
4. order by tbname and check the result
5. select tbname with backquote and check the result
6. select tbname with table prefix and check the result
7. select _wstart, _wend, _wduration with interval clause and check the result
8. select _wstart, _wend, _wduration without interval clause and expect error
9. select _irowts with range clause and check the result
10. select _irowts without range clause and expect error
11. select _wstart, _wend, _wduration with nested query and check the result
¶
Pseudo column tbname
1. Create 1 database 1 stable 2000 child tables
2. Insert 10 rows for each child table
3. Select tbname from stable with tbname in (...)
4. Select tbname from child table with tbname in (...)
5. Select tbname from stable with tbname in (...) and other tag filtering
6. Select tbname from stable with tbname in (...) and group by tag
7. Select tbname from stable with duplicated tbnames in (...)
8. Select tbname from stable with wrong tbnames in (...)
9. Select tbname from stable with tbname in (...) and column filtering
10. Select tbname from stable with tbname in (...) with Upper case table name
11. Restart dnode and check tbname in query again
12. Query tbname in where clause
13. Query tbname in join condition
14. Query tbname with special characters: ` (backquote)
15. Query tbname with special characters in virtual table
16. Query tbname in virtual table
17. Show create table tbname with special characters: ` (backquote)
18. Show create table tbname in virtual table
19. Drop and recreate tables with special characters: ` (backquote)
20. Drop and recreate virtual table with special characters: ` (backquote)
21. Join query with tbname in virtual table
22. Tbname in clause with special characters in virtual table