SELECT command that returns a strange RESULSET

[prrvchr]

Hi all,

During my tests for the integration of H2 in Base, I unwittingly discovered a strange behavior of a SELECT command with an error on the column name.

SELECT USER FROM INFORMATION_SCHEMA.USERS

The correct column name is USER_NAME but this SELECT does not throw an SQLException and return a strange ResultSet...

[Evgenij Ryazanov]

Hi!

USER is not an identifier. It is a reserved word in the SQL Standard. It has exactly the same meaning as CURRENT_USER in the SQL Standard and in H2.

https://h2database.com/html/functions.html#current_user

[prrvchr]

Newbie mistake, thank you Evgenij Ryazanov,, it took me a while to find the malfunction now I understand it.