SNOW-2160960: JDBC Not sending the correct sql for getColumns

[Keithbas]

Please answer these questions before submitting your issue.
In order to accurately debug the issue this information is required. Thanks!

1. What version of JDBC driver are you using? 3.9.2

2. What operating system and processor architecture are you using? Windows

3. What version of Java are you using? 1.8

4. What did you do?

I have run the getColumns method multiple times with no success in filtering by a schema and table name resulting in long (up to 5 minutes) run time per call.

5. What did you expect to see?
   I have run the command multiple ways:

getColumns("DATABASE_NAME",'SCHEMA_NAME", "TABLE_NAME", "%")

When I look in the Query History in Snowflake I see:

show columns in database "DATABASE_NAME"

When I would expect to see:

show columns in database "DATABASE_NAME".'SCHEMA_NAME"."TABLE_NAME"."%"

I have tried the escape character solution(because _ can be a wildcard:

getColumns("DATABASE_NAME",'SCHEMA_NAME", "TABL\E_NAME", "%")

result SQL in Snowflake:

show columns in database "DATABASE_NAME"

Which resulted in a SQL failure saying that "DATABASE_NAME" does not exist

6. Can you set logging to DEBUG and collect the logs?

[Keithbas]

A little more information. I tried to execute the command that JDBC was executing directly in Snowflake with the fully qualified:

show columns in database "DATABASE_NAME"."SCHEAMA_NAME"."TABLE_NAME"

Snowflake returned with the error:

"Must specify the full search path starting from database for TABLE_NAME"

Which was when it clicked, JDBC must be filtering AFTER it calls show columns in database "DATABASE_NAME" because the correct sql to get a tables columns is:

show columns in table "DATABASE_NAME"."SCHEAMA_NAME"."TABLE_NAME"

[sfc-gh-dszmolka]

hello @Keithbas - thanks for raising this issue.

1. please upgrade your Snowflake JDBC driver to a supported version (preferably the latest 3.24.2) because 3.9.2 is unsupported and very old
2. if the issue persists after upgrade, does it work with getColumns("DBNAME", "PUBLIC", "MYTABLE", null); ?
3. if the TABLE_NAME contains _ you might need to indeed escape it
4. if none of the above helps, please could you send us some reproduction data, like dbname schemaname tablename in a format which is either the same as the actual data, or has dummy name with the same naming method , so I could try and reproduce it on my end?

Snowflake documentation
In getColumns if the table name is not left out or matching the 'any' regex then the driver should insert the in table filter, too, so wondering why it isn't happening in your case and would like to see it for myself if possible.

Thank you in advance!