Well, I did some heavy debugging :-)
As a reminder: All this applies to the following artifact and it's
associated source code from the maven repo:
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>2.1.214</version>
</dependency>
I found the code which sets up the connection (org.h2.table.TableLink).
Line 123ff has a routine "private void readMetaData() throws SQLException
{..."
Within the routine at line 199 a routine is called "n =
convertColumnName(n);"
Prior to the call the variable n holds the name of the column as provided
by the postgres jdbc driver, which is lower case.
After the call n holds the same name but now in upper case.
Not sure, whether this is the intended behavior due to some requirements of
H2.
But at least it looks suspicious to me.
Anyone who has more insight on the intentions of these code lines who can
advise?
BR
Gerhard
On Thu, Oct 13, 2022 at 10:23 PM Noel Grandin <[email protected]> wrote:
> Unfortunately that smells like the postgresql database driver is returning
> bad metadata,
> because it should be returning column names with the correct case from the
> SELECT.
>
> But you'd have to debug way down to be sure.
>
> --
> 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 [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/h2-database/CAFYHVnUxR2JFq-RTMWoxhQKuiQOtG_-MFwXXHhQrJ-W_uLYnQw%40mail.gmail.com
> <https://groups.google.com/d/msgid/h2-database/CAFYHVnUxR2JFq-RTMWoxhQKuiQOtG_-MFwXXHhQrJ-W_uLYnQw%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/CAJxppmZkgE5E3WVLt-%2B6V_S%2B%3D1rCdC8rOAYT41tnq2GmpPenbw%40mail.gmail.com.
