BUG report: CURRENT_SCHEMA returned extra double-quote when the current schema contains special character

1

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.

SELECT CURRENT_SCHEMA

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.

2

Thanks for reporting @Baoqi We have opened an internal ticket to address the issue