Version 2.0.201

• Issue h2database#3174: Add keyword AUTOCOMMIT on create linked table to control the commit mode
• Issue h2database#3130: Precision of NUMERIC values isn't verified in the Oracle compatibility mode
• Issue h2database#3122: Documentation: Syntax diagram for RENAME CONSTRAINT incorrect
• PR h2database#3129: remove LOB compression
• PR h2database#3127: Cleanups post PageStore removal
• PR h2database#3126: Change nested classes to static nested classes where possible
• PR h2database#3125: Strongly typed LobStorageMap
• PR h2database#3124: Remove PageStore engine
• Issue h2database#3118: SHUTDOWN COMPACT causes 2PC to corrupt database in a simulated crash
• Issue h2database#3115: Infinite loop then OOM in org.h2.mvstore.tx.Transaction.waitFor() when deadlock occurs
• Issue h2database#3113: Data lost when 2 threads read/write TransactionStore and close it normally even if MVStore autoCommit disabled
• PR h2database#3110: Fix possible int overflow and minor doc change
• Issue h2database#3036: A database that contains BLOBs might grow without being able to be compacted
• Issue h2database#3097: Possible MVStore compaction issue
• PR h2database#3096: Add separate LOB data layer for values
• Issue h2database#3093: ROWNUM filter doesn't work with more than one table
• PR h2database#3087: Add "CONVERT TO CHARACTER SET" to compatibility modes
• Issue h2database#3080: Complex Query returns different results depending on the number of arguments in the IN clause
• Issue h2database#3066: Very high DB opening/closing times
• PR h2database#3077: Add CREATE UNIQUE INDEX ... INCLUDE
• Issue h2database#3061 / PR h2database#3074: GROUP BY using column index for MySQL/MariaDB/PostgreSQL compatibility modes
• PR h2database#3067: Restrict identity data types and result limitation clauses to compatibility modes
• PR h2database#3065: Remove duplicate method IOUtils.getBufferedReader
• Issue h2database#3055: Phantom table leftover after INSERT .. WITH
• PR h2database#3062: Add ALTER DOMAIN RENAME CONSTRAINT command
• Issue h2database#3059: ALTER TABLE DROP CONSTRAINT doesn't check owner of constraint
• Issue h2database#3054: Add binary set aggregate functions
• Issue h2database#3049: Java value getters of ValueNull should throw exceptions
• Issue h2database#3046: SYSTEM_RANGE can't handle bind variable as step size and produces wrong error message
• Issue h2database#3033: NPE during BLOB read after 2PC rollback
• PR h2database#3034: Don't evaluate ValueTimestampTimeZone at begin and end of each command
• PR h2database#3029: Optimize row storage in MVStore and other changes
• PR h2database#3028: Remove back compatibility
• PR h2database#3025: Switch from Travis CI to GitHub Workflows
• PR h2database#3024: Add initial version of upgrade utility
• Issue h2database#3017: ROUND() does not set correct precision and scale of result
• Issue h2database#3003: CREATE TABLE ... AS SELECT ... FROM creates invalid column definition when aggregate functions are used
• Issue h2database#3008: TestCrashAPI: Exception in Arrays.sort() called by LocalResult.done()
• Issue h2database#3006 / PR h2database#3007: Unlock meta during query execution in CREATE TABLE AS query
• PR h2database#3001: PostgreSQL compatibility: UPDATE with FROM
• PR h2database#2998: Fix off-by-one error with -webAdminPassword in Server
• PR h2database#2995: Add FETCH_SIZE clause to CREATE LINKED TABLE
• Issue h2database#2907 / PR h2database#2994: Prevent "Chunk not found" on LOB operations
• PR h2database#2993: Update copyright years
• Issue h2database#2991: TestCrashAPI: NPE in ScriptCommand.dumpDomains()
• Issue h2database#2950 / PR h2database#2987: Issue commit() right before "non-transactional" DDL command starts
• PR h2database#2980: Assorted minor changes
• PR h2database#2966: H2 2.0.201: Linked Tables freeze the Database and freeze the Server Process
• Issue h2database#2972: Memory leak due to negative Page memory in the MVStore
• PR h2database#2971: create skeleton of migration to V2 document
• Issue h2database#2967: MVStore: averageSize int overflow in the class ObjectDataType
• Issue h2database#2963: Syntax error for large hexadecimal constants with DATABASE_TO_UPPER=false
• Issue h2database#2961: Accept CREATE PRIMARY KEY only in metadata or in quirks mode
• Issue h2database#2960: Reject invalid CREATE { UNIQUE | HASH } SPATIAL INDEX
• Issue h2database#2958: TableLink is broken for Oracle database after pull request h2database#2903
• PR h2database#2955: Prevent incorrect index sorting
• PR h2database#2951: Add documentation for INFORMATION_SCHEMA
• PR h2database#2943: some small prep for next release
• PR h2database#2948: Add support of Infinity, -Infinity, and NaN to DECFLOAT data type
• Issue h2database#2947: Encoding of Unicode and special characters in error messages
• Issue h2database#2891: Fix import of unnamed referential constraints from SQL scripts generated by older versions of H2
• Issue h2database#2812: Unexpected result for query that compares an integer with a string
• Issue h2database#2936: Add data type conversion code from datetime and UUID values to JSON
• Issue h2database#2935: ENUM ARRAY isn't read properly from persisted data
• Issue h2database#2923: Combination of fileName() with fileStore() should throw an exception
• Issue h2database#2928: JSON_ARRAYAGG and all NULL values
• PR h2database#2918: Removal of unnecessary lock
• Issue h2database#2911: org.h2.mvstore.MVStoreException: Transaction was illegally transitioned from ROLLING_BACK to ROLLED_BACK
• Issue h2database#1022: JdbcDatabaseMetaData.getPseudoColumns() should be implemented
• Issue h2database#2914: (T1.A = T2.B) OR (T1.A = T2.C) should be optimized to T1.A IN(T2.B, T2.C) to allow index conditions
• PR h2database#2903: Assorted changes
• Issue h2database#2901: PgServer returns less rows when fetchSize is set
• Issue h2database#2894: NPE in DROP SCHEMA when unique constraint is removed before linked referential constraint
• Issue h2database#2888: H2 should pass time zone of client to the server
• PR h2database#2890: Fixed possible eternal wait(0)
• Issue h2database#2846: GRANT SELECT, INSERT, UPDATE, DELETE incorrectly gives privileges to drop a table
• Issue h2database#2882: NPE in UPDATE with SELECT UNION
• PR h2database#2881: Store users and roles together and user-defined functions and aggregates together
• Issue h2database#2878: Disallow spatial indexes in PageStore databases
• PR h2database#2874: Use 64-bit row counts in results and other changes
• Issue h2database#2866: New INFORMATION_SCHEMA should not use keywords as column names
• Issue h2database#2867: PageStore + Lazy + INSERT ... SELECT cause infinite loop
• PR h2database#2869: Normalize binary geometry literals and improve EWKB representation of POLYGON EMPTY
• Issue h2database#2860: CHAR columns in PgCatalogTable have incorrect length
• Issue h2database#2848: Add support for standard <listagg overflow clause>
• Issue h2database#2858: Throw 22001 on attempt to use getString() or getBytes() on LOB object longer than 1,048,576 chars/octets
• Issue h2database#2854: Define limits for identifiers, number of columns, etc.
• PR h2database#2853: Small optimization for Page compression / decompression
• Issue h2database#2832: Define length limits for non-LOB data types
• Issue h2database#2842: Querying view that uses LTRIM/RTRIM results in a syntax error
• Issue h2database#2841: Call to STRINGDECODE results in StringIndexOutOfBoundsException
• Issue h2database#2839: Querying a view that uses the POSITION() function results in an unexpected syntax error
• Issue h2database#2838: INSERT() with NULL arguments for the original string and string to be added results in NPE
• Issue h2database#2837: ROUND() function should reject invalid number of digits immediately
• Issue h2database#2835: Calling math functions with a string argument results in a NullPointerException
• Issue h2database#2833: MERGE INTO causes an unexpected syntax error
• Issue h2database#2831: Restore YEAR data type for MySQL compatibility mode
• Issue h2database#2822: Suspicious logic in Database.closeImpl()
• Issue h2database#2829: Incorrect manifest entries in sources jar
• Issue h2database#2828: Parser can't parse NOT in simple when operand
• Issue h2database#2826: Table with a generated column cycle results in a NullPointerException
• Issue h2database#2825: Query with % operator results in a ClassCastException
• Issue h2database#2818: TableFilter.getValue() can read value of delegated column faster
• Issue h2database#2816: Query on view that uses the BETWEEN operator results in an unexpected syntax error
• PR h2database#2815: Remove BINARY_COLLATION and UUID_COLLATION settings
• Issue h2database#2813: Query with CASE operator unexpectedly results in "Column must be in the GROUP BY list" error
• Issue h2database#2811: Update build numbers and data format versions
• Issue h2database#2674: OPTIMIZE_IN_SELECT shouldn't convert value to incompatible data types
• Issue h2database#2803: Disallow comparison operations between incomparable data types
• Issue h2database#2561: Separate normal functions and table value functions
• Issue h2database#2804: NPE in ConditionNot.getNotIfPossible()
• Issue h2database#2801: Instances of TableView objects leaking
• PR h2database#2799: Additional bit functions BITNAND, BITNOR, BITXNOR, BITCOUNT, ULSHIFT, URSHIFT, ROTATELEFT, ROTATERIGHT, BIT_NAND_AGG, BIT_NOR_AGG, and BIT_XNOR_AGG.
• PR h2database#2798: Complete separation of Function class
• Issue h2database#2795: Sporadic issues with trigger during concurrent insert in 1.4.199/1.4.200
• PR h2database#2796: Assorted refactorings
• Issue h2database#2786: Failure in CREATE TABLE AS leaves inconsistent transaction if some rows were successfully inserted
• Issue h2database#2790: Examples in documentation of CREATE ALIAS should use standard literals only
• Issue h2database#2787: CONCAT and CONCAT_WS functions
• PR h2database#2784: Oracle REGEXP_REPLACE support
• Issue h2database#2780: Remove SCOPE_GENERATED_KEYS setting
• PR #2...