Thanks for checking Evgenij. I was mistaken - adding "YEAR" to the
"NON_KEYWORDS" does indeed work. There was a different issue on my end that was
throwing things off. Appreciate everyone's help.
Best,Peter
On Saturday, February 17, 2024 at 02:19:07 AM EST, Evgenij Ryazanov
<kat...@gmail.com> wrote:
Hello!
YEAR is a reserved word even in archaic SQL-92, so it was a bad idea to use it
as unquoted identifier. BTW, DATE and TRANSACTION are reserved words too, but
H2 allows their usage as identifiers. Also there is no YEAR function in the
Standard, correct syntax is EXTRACT(YEAR FROM someValue).
Newer versions of H2 may have more keywords than old versions and reserved
words from the latest version of the SQL Standard (from SQL:2023 for now) are
potential candidates.
Anyway, the following test case prints 2024 as expected, so NON_KEYWORDS
settings works well and you have some other problem in your application, most
likely your query is executed from a connection with different settings.
Properties p = new Properties();
p.put("MODE", "PostgreSQL");
p.put("DATABASE_TO_LOWER", "TRUE");
p.put("DEFAULT_NULL_ORDERING", "HIGH");
p.put("NON_KEYWORDS", "YEAR");
try (Connection connection = DriverManager.getConnection("jdbc:h2:mem:", p)) {
Statement s = connection.createStatement();
s.execute("CREATE TABLE transaction(date DATE) AS VALUES CURRENT_DATE");
ResultSet rs = s.executeQuery("SELECT year(date) AS year FROM transaction");
rs.next();
System.out.println(rs.getInt(1));
}
--
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/fc4ea7a4-c9f8-47a1-89be-191e9d807f15n%40googlegroups.com.
--
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/797384501.3014179.1708171658213%40mail.yahoo.com.
