Metadata on a prepared statement return upper case column names

EricCournarie
New Contributor III

Hello,

Using the JDBC Driver , when I check the metadata of a prepared statement, the column names names are all uppercase . This does not happen when running a DESCRIBE on the same select. 

Any properties to set , or it is a known issue ? or a workaround ?

SELECT `ColumnName` will return COLUMNNAME if I check PreparedStatement.getMetadata()

DESCRIBE SELECT `ColumnName` returns ColumnName

thanks for your help

Eric

gchandra
Databricks Employee
Databricks Employee

Looks like a bug. Can you try using double quotes?  SELECT "ColumnName" instead of backticks? 

 



~

Hello, thanks for answering

Sadly, changing the quoting does not change the result. Still uppercase with double quotes