"KEY" (as well as "VALUE") is a keyword now, and if used as identifier has to be quoted.
https://h2database.com/html/advanced.html#keywords On Thursday, December 23, 2021 at 8:26:19 AM UTC-5 [email protected] wrote: > To be more precise, we are calling Connection#prepareStatement(String) > with: > > "CREATE TABLE TEST_DATA (KEY VARCHAR(100), ID BIGINT, VALUE DOUBLE > PRECISION, INFO TEXT, TS TIMESTAMP)" > > Gary > > On Thursday, December 23, 2021 at 8:23:58 AM UTC-5 Gary Gregory wrote: > >> Hello from Apache Commons DBCP: There appears to be some breakage we >> notice when updating from 200 to 204. >> >> The full build log for the PR "Bump h2 from 1.4.200 to 2.0.204 Java CI >> #560" is here: >> https://github.com/apache/commons-dbcp/runs/4614345120?check_suite_focus=true >> >> For example: >> >> org.h2.jdbc.JdbcSQLSyntaxErrorException: >> 129 >> <https://github.com/apache/commons-dbcp/runs/4614345120?check_suite_focus=true#step:5:129> >> Syntax error in SQL statement "CREATE TABLE TEST_DATA (KEY[*] >> VARCHAR(100), ID BIGINT, VALUE DOUBLE PRECISION, INFO TEXT, TS TIMESTAMP)"; >> expected "identifier"; SQL statement: >> 130 >> <https://github.com/apache/commons-dbcp/runs/4614345120?check_suite_focus=true#step:5:130> >> CREATE TABLE TEST_DATA (KEY VARCHAR(100), ID BIGINT, VALUE DOUBLE >> PRECISION, INFO TEXT, TS TIMESTAMP) [42001-204] >> 131 >> <https://github.com/apache/commons-dbcp/runs/4614345120?check_suite_focus=true#step:5:131> >> >> at >> org.apache.commons.dbcp2.managed.TestConnectionWithNarayana.setUp(TestConnectionWithNarayana.java:91) >> >> Any thoughts? >> >> Gary >> >> On Wednesday, December 22, 2021 at 1:56:44 PM UTC-5 [email protected] >> wrote: >> >>> Hello, >>> >>> A new version 2.0.204 of H2 is available at http://www.h2database.com >>> (you may have to click 'Refresh'). >>> >>> For details, see the 'Change Log' at >>> http://www.h2database.com/html/changelog.html >>> >>> >>> P.S. If you reply to this message please use a different subject. >>> >>> Have fun, >>> Andrei Tokar >>> >> -- 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/6ffeec91-8d63-4ec2-9df7-70052e0670e3n%40googlegroups.com.
