Overriding Spring Boot h2.version to 2.0.206 (from 1.4.200) throws an error
Column \"TABLE1_ID_SEQ.NEXTVAL\" not found
in the following SQL which worked previously:
CREATE SEQUENCE table1_id_seq;
CREATE TABLE table1 (
id integer default table1_id_seq.nextval NOT NULL UNIQUE,
versionid integer NOT NULL,
table2id integer,
externalid character varying(255),
value character varying(255)
);
Neither of the documented alternate forms worked either:
... default nextval('table1_id_seq') ...
or
... default next value for table1_id_seq ...
Is there a preferred version of getting nextval in h2 v2.0.206, or any
other way of getting an id from a sequence (for various reasons this is a
requirement)?
--
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/6dc31aec-89ff-45cf-a3fc-d7a8a2830727n%40googlegroups.com.
