Tag: h2db

H2 vs PostgreSQL generated column with function

I’m trying to setup a generated column which will also take null checks into consideration when subtracting values. In PostgreSQL I did: ALTER TABLE session ADD COLUMN duration INTERVAL GENERATED …

INSERT INTO table SELECT not working with constant values in H2 DB

h2 h2db liquibase sql

Following is the H2DB query What I am trying to achieve is to insert a record into userpermission for user with given email address in user table, for each permission in permission table. Following is the error The same query is working in MySQL. Answer As mentioned in the comments, Use single quotes for sting constants. Do not use braces