Consider this query
CREATE TABLE Clock AS SELECT CAST('2001-01-07' AS DATE) +
(n || ' minute')::INTERVAL as clock_time
FROM generate_series(0, 1440*30) n;
When run on XC through psql it results in
INSERT 0 43201
and creates the table successfully, whereas it fails when run through JDBC
Statement stmt = conn.createStatement();
stmt.executeUpdate("CREATE TABLE Clock AS SELECT CAST('2001-01-07' "
+"AS DATE) + (n || ' minute')::INTERVAL "
+"as clock_time FROM generate_series(0, 1440*30) n");
resulting in
ERROR: relation "clock" already exists
