"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 garydg...@gmail.com 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 andrei...@gmail.com >> 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/6ffeec91-8d63-4ec2-9df7-70052e0670e3n%40googlegroups.com.
