Hi, It's true, in MySQL mode the database should return a different value. It's a bit hard to support those features, but it should be possible. I don't know if some applications call those methods a lot, so I guess it's best if the value is only read from the database once per connection (lazily) and from them on the same value is returned (for the given connection). Patches are welcome of course ;-)
Regards, Thomas On Sat, Sep 8, 2012 at 12:12 PM, Thomas <[email protected]> wrote: > Any thoughts on this? > > Am Montag, 20. August 2012 18:28:00 UTC+2 schrieb Thomas: > >> Hello, >> >> when starting H2 in "MySQL Mode" (using *MODE=MySQL* in the connection >> URL), the documentation says: "Meta data calls return identifiers in lower >> case." >> >> Unfortunatelyl DatabaseMetaData.**storesUpperCaseIdentifiers() still >> returns true in that case and DatabaseMetaData.** >> storesLowerCaseIdentifiers() still returns fals. >> >> If those methods are used to determine whether a table named test needs >> to be quoted (because it's stored in a non-default case) the test fails >> because of. >> >> I would expect DatabaseMetaData.**storesLowerCaseIdentifiers() to return >> true and DatabaseMetaData.**storesLowerCaseIdentifiers() to return false >> in MySQL mode - or am I missing something? >> > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/YwsPnuzJJKsJ. > > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
