-- Test temp tables with upper/lower case names | |
create temporary table Default.Temp_Table_Names (C1 string, c2 string); | |
show tables 'Temp_Table%'; | |
show tables in default 'temp_table_names'; | |
show tables in DEFAULT 'TEMP_TABLE_NAMES'; | |
select c1 from default.temp_table_names; | |
select C1 from DEFAULT.TEMP_TABLE_NAMES; | |
drop table Default.TEMP_TABLE_names; | |
show tables 'temp_table_names'; |