stijn-vranckx

H2GISFunctions assumes that PUBLIC is the active schema

4

The following code fails: > public static void main(String[] args) throws LiquibaseException, SQLException { > JdbcDataSource dataSource = new JdbcDataSource(); > dataSource.setPassword("password"); > dataSource.setUser("sa"); > dataSource.setURL("jdbc:h2:mem:testdb"); > Connection connection =...

CREATE TABLE succeeds or fails depending on the order of the CONSTRAINT statements

3

For H2 versions 2.1.210 the following query works: > CREATE TABLE "meta_data" ( "meta_data_id" BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL, "identifier" VARCHAR(255) NOT NULL, "parent_identifier" VARCHAR(255), CONSTRAINT "meta_data_pk"...

SQL generated by Liquibase is not accepted by H2 because because foreign key constraint assume existence of a unique key.

1

### Search first - [X] I searched and no similar issues were found ### Description The order of the statements in the create table is incorrect. > Jan 12, 2024...