topic Re: Metadata on a prepared statement return upper case column names in Data Engineering

Metadata on a prepared statement return upper case column names

EricCournarie — Tue, 24 Sep 2024 12:31:59 GMT

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

Re: Metadata on a prepared statement return upper case column names

gchandra — Tue, 24 Sep 2024 16:51:08 GMT

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

Re: Metadata on a prepared statement return upper case column names

EricCournarie — Wed, 25 Sep 2024 07:47:28 GMT

Hello, thanks for answering

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