Evgenij Ryazanov
Evgenij Ryazanov
One more in another test case, this time with unencrypted database on Java 7, but there was a previous failure in encrypted mode: ``` ERROR: FAIL (mvStore AES SOFT_LRU diskUndo...
``` Test AES SOFT_LRU diskUndo diskResult traceLevelFile throttle:1 (29625 KB used) 12:08:06 00:00.000 org.h2.test.mvcc.TestMvccMultiThreaded FAIL org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-229] ERROR: FAIL (AES SOFT_LRU diskUndo diskResult traceLevelFile throttle:1...
You shouldn't use `CHARACTER` / `CHAR` data type for variable-length character strings. There is a `CHARACTER VARYING` (`VARCHAR`) data type for this purpose.
Actually it looks more like a bug in Oracle. If comparison between `CHAR(3)` and character string literal with 1 character uses a collation with `PAD SPACE` characteristic that makes these...
There is no with clause in DML in the SQL Standard. Support of these invalid commands was intentionally removed, because correct execution of valid commands in more important for us...
I [reverted](https://github.com/h2database/h2database/pull/3986/commits/f961e9a0fc380314587a7455665e848ffe804568) my changes in BNF of CTEs, because they break code completion, this is the same issue as #3372
(It the worst case we can remove links to DML commands from the old grammar.)
We don't have a versioned documentation on website. There is a separate feature request for it somewhere, but we need to re-organize everything before any attempts to provide such documentation....
Documentation of H2 contains some static pages, but the main documentation is generated from the source data of built-in help system and Markdown is not an option here (at least...
H2 supports only standard JSON functions and operators and you need to use them with H2. Unfortunately, `JSON_VALUE`, `JSON_QUERY`, `JSON_TABLE`, and `JSON_EXISTS` aren't yet supported due to complexity of SQL/JSON...