Remap TEXT to VARCHAR and other changes #3503

katzyn · 2022-05-10T14:30:40Z

TEXT (type from PostgreSQL and maybe some other DBMS) is now treated as CHARACTER VARYING instead of CHARACTER LARGE OBJECT. CHARACTER VARYING with our new limit of 1,000,000,000 characters should be good enough for TEXT emulation. TEXT in PostgreSQL is a not a LOB (PostgreSQL doesn't have standard LOBs), it is a regular value and its maximum size is 1GB. Closes Conversion 'text' to 'integer' doesn't work anymore #3444.
Combination of AUTO_SERVER=TRUE with DB_CLOSE_ON_EXIT=FALSE is now explicitly disallowed.
BNF grammar in documentation doesn't have incorrect subqueries without parentheses any more. Parentheses are actually optional in H2, but when they aren't specified ambiguous constructions are possible.
Maximum allowed length of binary and character strings in documentation is updated, it was actual for 2.0.202–2.1.210, but H2 2.1.212 has larger limits.
Various legacy weird non-portable alternative names of data types (like TYNYBLOB) are removed from BNF in documentation to make it cleaner.

…check back to ValueBytesBase

katzyn added 5 commits May 10, 2022 21:10

Remap TEXT to VARCHAR and update documentation of data types

f98e859

Disallow AUTO_SERVER=TRUE && DB_CLOSE_ON_EXIT=FALSE

6a0f7a9

Add parentheses around queries to BNF where they should be required

39ddbbe

Additional fixes in documentation

eaf9109

Fix GEOMETRY, JSON, and JAVA_OBJECT limits in documentation and move …

8027b1d

…check back to ValueBytesBase

katzyn merged commit 5b4ac39 into h2database:master May 11, 2022

katzyn deleted the misc branch May 11, 2022 11:57

Provide feedback