In version 2 of H2 `value` is a reserved keyword #310

New issue

Closed

opened 2021-12-11 16:34:05 +00:00 by p3k · 1 comment

p3k commented

2021-12-11 16:34:05 +00:00

(Migrated from github.com)

In version 2 of H2 value is a reserved keyword. Thus, the postgre.sql script fails to create the metadata table when running ./gradlew :antclick:build.

While this can be worked around by wrapping the keyword in quotes ("value"), it still causes problems in subsequent SQL statements because Helma still tries to access the column without quotes.

Renaming the column and adding an updater script for existing databases seems to be a better solution.

Originally posted by @p3k in https://github.com/antville/antville/issues/309#issuecomment-991704185

In version 2 of H2 `value` is a reserved keyword. Thus, the `postgre.sql` script fails to create the `metadata` table when running `./gradlew :antclick:build`. While this can be worked around by wrapping the keyword in quotes (`"value"`), it still causes problems in subsequent SQL statements because Helma still tries to access the column without quotes. Renaming the column and adding an updater script for existing databases seems to be a better solution. _Originally posted by @p3k in https://github.com/antville/antville/issues/309#issuecomment-991704185_