Dremio version: 15.0.0-202103312106020527-0be9c719
When I run the following SQL to get table names from current schema:
select * from "INFORMATION_SCHEMA"."TABLES" where "TABLE_SCHEMA" = CURRENT_SCHEMA
if I was in my home, it will return empty result. but if my default schema is something else, it can work correctly.
It turns out the following SQL returned wrong data for my home space.
It returns: “@bwu” instead of @bwu
But if I run the SELECT CURRENT_SCHEMA for other schemas (without any special character), it will not return double quote.
So, I think the double quote is not necessary as SQL return result.