Evgenij Ryazanov

Unfortunately, the JDBC specification, unlike the SQL Standard, doesn't describe details of its features, so every driver may implement various things in any way without being incompatible with this specification....

1. According to documentation of H2 1.4.200 (available in its [full distribution](https://h2database.com/html/download-archive.html)), `LTRIM` and `RTRIM` functions have only one parameter. You should avoid both these functions, they are deprecated in...

In MySQL, `CREATE SCHEMA` and `CREATE DATABASE` are the same command, but `CREATE SCHEMA`, unlike `CREATE DATABASE`, is a part of the SQL Standard. You need to change `CREATE DATABASE`...

From my point of view H2 should disallow subqueries without parentheses at least in `STRICT` and some other compatibility modes to avoid such surprises. We can't disallow them in `LEGACY`...

1. Recovery tool doesn't use additional indexes. 2. If implementation of some index writes incorrect data, it cannot affect content of other indexes in H2. 3. Usually indexes aren't that...

Recursive CTEs are experimental in H2 and may have any issues. I think this query worked in H2 only due to buggy implementation of sequence value expressions in old versions...

Actually it was discussed 12 years ago on the closed Google Code service, there is an archive copy with replaced usernames: https://code.google.com/archive/p/h2database/issues/196 H2 doesn't have a roadmap any more, but...

`JSON_VALUE`, `JSON_QUERY`, `JSON_TABLE`, and `JSON_EXISTS` need an implementation of SQL/JSON path language, H2 currently doesn't have it and most likely nobody works on it; this task requires a lot of...

I think current behavior with exception is correct. It isn't possible to construct a `DATE` value when only year is known.

https://github.com/katzyn/h2database/tree/bnf `TestWeb` fails and code completion also can't complete names of columns etc. Actually we need more changes, I fixed only small part of the grammar.