On 10/14/2022 9:28 AM, Gerhard Duennebeil wrote:
Maybe it's a bit naive, but wouldn't it be possible to store the original name beside the local name and reflect that
original name back to the linked database?
Oh, we wish, that would be so awesome.
The case-sensitivity of identifiers in SQL is a horrible, terrible, no-good
mess.
So..... when we ask the Postgresql JDBC driver what the column name is, we receive
"rf".
Now, unfortunately, we need to know:
Is this the "one true name" of the column?
Or is it just a representation of an identifier that is case-insensitive, for which any of 'RF' 'rf' 'Rf' 'rF' is
acceptable ?
And....... we don't know, and there is insufficient information to be sure. So we have to guess, and in your case, we
guess wrong.
The simplest fix, is for you to change your query to quote 'rf' at source i.e.
to write
update reloadflag_disabled set 'rf'=true
The longer, nastier fix, would be that in TableLink#readMetaData we would have add extra logic to detect the ambiguous
case, and issue some test queries to find out which of the cases we are dealing with.
If you want to spin up a patch/PR to add the logic, feel free, but I'll
understand if you're not interested :-)
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/640887e8-028b-70dd-6289-2a58432fef0e%40gmail.com.
