Evgenij Ryazanov
Evgenij Ryazanov
H2 and many other systems support more powerful [`MERGE`](https://h2database.com/html/commands.html#merge_using) command from the SQL Standard, support for this command was recently added to PostgreSQL too and it is available since PostgreSQL...
`MERGE` implementation for PostgreSQL was discussed since 2005, I guess. It took a long time to finally write and accept it into main sources. Stable version of PostgreSQL with this...
A possible better implementation is to convert ```SQL create table test(a int , b int, c int, unique(a, b)); insert into test values (1, 2, 3); insert into test values...
When parameter is used inside an expression, H2 can't determine its data type. You need to specify the exact data type with a `CAST`. ```SQL CAST(? AS BIGINT) ``` This...
Yes, it is possible because various places where data type of expression was determined incorrectly and caused other issues is some cases were fixed and, unfortunately, it means that parameters...
Bitwise functions need to know data types of their arguments due to another reason: they now support various data types, previously they were implemented only for `BIGINT` data type.
If your database was created by an older version of H2 you need to use the recommended way to update a database with `SCRIPT TO 'filename.sql'` using the old version,...
What version of H2 database IntelliJ IDEA uses by itself?
I think this is the main reason of your problem. Only the JDBC client can have different version safely. Embedded and auto-server databases should use the same version of H2...
If you want to know the version of H2's jar, you can use `Constants.BUILD_ID`, better with reflection for safety, because that class is not a part of API of H2....