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 h2database#2779: Fix incorrect FK restrictions and other changes
• PR h2database#2778: Assorted changes
• Issue h2database#2776: Referential constraint can create a unique constraint in the wrong schema
• Issue h2database#2771: Add documented DEFAULT ON NULL flag for all types of columns
• Issue h2database#2742 / PR h2database#2768: Better separation of MVStore aimed at smaller h2-mvstore jar
• Issue h2database#2764: Identity columns don't accept large numbers
• IDENTITY() function is removed, SCOPE_IDENTITY() is now available only in MSSQLServer compatibility mode.
• Issue h2database#2757: Intermittent TestFileSystem failures
• Issue h2database#2758: Issues with sequences
• PR h2database#2756: Prevent DROP NOT NULL for identity columns
• Issue h2database#2753: UPDATE statement changes value of GENERATED ALWAYS AS IDENTITY columns
• PR h2database#2751: Add comment explaining seemingly dummy operation
• PR h2database#2750: Use RFC 4122 compliant UUID comparison by default
• PR h2database#2748: PgServer set type text to NULL value
• Issue h2database#2746: Old TCP clients with current server
• PR h2database#2745: PgServer can send bool in binary mode
• PR h2database#2744: Remove jarSmall and jarClient targets
• PR h2database#2743: Add IS_TRIGGER_UPDATABLE and other similar fields to INFORMATION_SCHEMA
• PR h2database#2738: Fix VIEWS.VIEW_DEFINITION and support it for other databases in H2 Console
• PR h2database#2737: Assorted changes
• PR h2database#2734: Update dependencies and fix ResultSetMetaData.isSigned()
• PR h2database#2733: Replace h2.sortNullsHigh with DEFAULT_NULL_ORDERING setting
• PR h2database#2731: Fix spelling errors in German translation
• PR h2database#2728: Add and use DATA_TYPE_SQL() function and remove INFORMATION_SCHEMA.PARAMETERS.REMARKS
• Issue h2database#1015: ENUM and arithmetic operators
• Issue h2database#2711: Store normalized names of data types in metadata
• PR h2database#2722: Implement getRowCount() for some INFORMATION_SCHEMA tables
• PR h2database#2721: Improve LOCKS, SESSIONS, and USERS and optimize COUNT(*) on other isolation levels in some cases
• Issue h2database#2655: TestCrashAPI: AssertionError at MVPrimaryIndex.<init>
• Issue h2database#2716: Fix URL of Maven repository
• Issue h2database#2715: Mention `DB_CLOSE_DELAY=-1` flag in JDBC URL on the "Cheat Sheet" page
• PR h2database#2714: fixed few code smells discovered by PVS-Studio
• Issue h2database#2712: `NOT LIKE` to a sub-query doesn't work
• PR h2database#2710: PgServer: set oid and attnum in RowDescription
• Issue h2database#2254: Add standard DECFLOAT data type
• PR h2database#2708: Add declared data type attributes to the INFORMATION_SCHEMA
• Issue h2database#2706: Empty comments / remarks on objects
• PR h2database#2705: Return standard-compliant DATA_TYPE for strings
• PR h2database#2703: Fix case-insensitive comparison issues with national characters
• Issue h2database#2701: Subquery with FETCH should not accept global conditions
• Issue h2database#2699: Remove FUNCTIONS_IN_SCHEMA setting
• Issue h2database#452: Add possibility to use user-defined aggregate functions with schema
• PR h2database#2695: Refactor handling of parentheses in getSQL() methods
• PR h2database#2693: disallow VARCHAR_IGNORECASE in PostgreSQL mode
• Issue h2database#2407: Implement CHAR whitespace handling correctly
• PR h2database#2685: Check existing data in ALTER DOMAIN ADD CONSTRAINT
• PR h2database#2683: Fix data types in Transfer
• PR h2database#2681: Report user functions in standard ROUTINES and PARAMETERS views
• PR h2database#2680: Reimplement remaining DatabaseMetaData methods and fix precision of binary numeric types
• PR h2database#2679: Reimplement getTables(), getTableTypes(), and getColumns()
• PR h2database#2678: Reimplement getPrimaryKeys(), getBestRowIdentifier(), getIndexInfo() and others
• PR h2database#2675: Reimplement getImportedKeys(), getExportedKeys(), and getCrossReferences()
• PR h2database#2673: Reimplement some metadata methods
• PR h2database#2672: Forward DatabaseMetaData calls to server
• Issue h2database#2329: Content of INFORMATION_SCHEMA should be listed as VIEWS
• PR h2database#2668: Sequence generator data type option and length parameter for JSON data type
• PR h2database#2666: Add ALTER DOMAIN RENAME command
• PR h2database#2663: Add ALTER DOMAIN { SET | DROP } { DEFAULT | ON UPDATE }
• PR h2database#2661: Don't allow construction of incomplete ARRAY and ROW data types
• Issue h2database#2659: NULLIF with row values
• PR h2database#2658: Extract date-time and some other groups of functions into own classes
• PR h2database#2656: add `_int2` and `_int4` for PgServer
• PR h2database#2654: Move out JSON, cardinality, ABS, MOD, FLOOR, and CEIL functions from the Function class
• PR h2database#2653: Use full TypeInfo for conversions between PG and H2 data types
• PR h2database#2652: Add "SHOW ALL"
• PR h2database#2651: add `pg_type.typelem` and `pg_type.typdelim`
• PR h2database#2649: Extract some groups of functions from Function class
• PR h2database#2646: Add some PostgreSQL compatibility features
• PR h2database#2645: Add CURRENT_PATH, CURRENT_ROLE, SESSION_USER, and SYSTEM_USER
• Issue h2database#2643: Send PG_TYPE_TEXTARRAY values to ODBC drivers properly
• PR h2database#2642: Throw proper exceptions from array element reference and TRIM_ARRAY
• PR h2database#2640: German translations
• Issue h2database#2108: Add possible candidates in different case to table not found exception
• Issue h2database#2633: Multi-column UPDATE assignment needs to be reimplemented
• PR h2database#2635: Implement REGEXP_SUBSTR function
• PR h2database#2632: Improve ROW data type
• PR h2database#2630: fix: quoted VALUE in documentation
• Issue h2database#2628: Cached SQL throws JdbcSQLSyntaxErrorException if executed with different parameter values than before
• Issue h2database#2611: Add quantified distinct predicate
• Issue h2database#2620: LOBs in triggers
• PR h2database#2619: ARRAY_MAX_CARDINALITY and TRIM_ARRAY functions
• PR h2database#2617: Add Feature F262: Extended CASE expression
• PR h2database#2615: Add feature T461: Symmetric BETWEEN predicate
• PR h2database#2614: Fix support of multi-dimensional arrays in Java functions
• Issue h2database#2608: Improve concatenation operation for multiple operands
• PR h2database#2605: Assorted minor changes
• Issue h2database#2602: H2 doesn't allow to create trigger from Java source code if there are nested classes
• PR h2database#2601: Add field SLEEP_SINCE to INFORMATION_SCHEMA.SESSIONS table
• Issue h2database#1973: Standard MERGE statement doesn't work with views
• Issue h2database#2552: MERGE statement should process each row only once
• Issue h2database#2548: Wrong update count when MERGE statement visits matched rows more than once
• Issue h2database#2394: H2 does not accept DCL after source merge table
• Issue h2database#2196: Standard MERGE statement doesn't release the source view
• Issue h2database#2567: ARRAY-returning Java functions don't return the proper data type
• Issue h2database#2584: Regression in NULL handling in multiple AND or OR conditions
• PR h2database#2577: PgServer: `array_to_string()` and `set join_collapse_limit`
• PR h2database#2568: Add BIT_XOR_AGG aggregate function
• PR h2database#2565: Assorted minor changes
• PR h2database#2563: defrag is not contributing much, remove from test run
• PR h2database#2562: new exception MVStoreException
• PR h2database#2557: don't throw IllegalStateException in checkOpen
• PR h2database#2554: Reenable mvstore TestCrashAPI
• Issue h2database#2556: TestOutOfMemory: Table "STUFF" not found
• PR h2database#2555: Move current datetime value functions into own class
• PR h2database#2547: split up the ValueLob classes
• PR h2database#2542: Pipelining mvstore chunk creation / save
• Issue h2database#2550: NullPointerException with MERGE containing unknown column in AND condition of WHEN
• Issue h2database#2546: Disallow empty CASE specifications and END CASE
• Issue h2database#2530: Long query with many AND expressions causes StackOverflowError
• PR h2database#2543: Improve case specification support and fix some issues with it
• Issue h2database#2539: Replace non-standard functions with standard code directly in Parser
• Issue h2database#2521: Disallow untyped arrays
• Issue h2database#2532: Duplicate column names in derived table should be acceptable in the presence of a derived column list that removes ambiguities
• PR h2database#2527: Feature: allow @ meta commands from Console
• PR h2database#2526: Reduce I/O during database presence check and restrict some compatibility settings to their modes
• PR h2database#2525: Restore support of third-party drivers in the Shell tool
• Issue h2database#1710: getHigherType() returns incorrect type for some arguments
• PR h2database#2516: SHUTDOWN IMMEDIATELY should be a normal shut down
• PR h2database#2515: Fix nested comments in ScriptReader
• Issue h2database#2511: Restrict Oracle compatibility functions to Oracle compatibility mode
• PR h2database#2508: Minor refactoring around Tx isolation level
• PR h2database#2505: Assorted changes in DATEADD, DATEDIFF, DATE_TRUNC, and EXTRACT
• Issue h2database#2502: Combination of DML with data change delta table skips subsequent update
• PR h2database#2499: Performance fix for PageStore under concurrent load
• PR h2database#2498: Add some PostgreSQL compatibility features mentioned in issue h2database#2450
• Issue h2database#2496: Error when using empty JSON_OBJECT() or JSON_ARRAY() functions
• PR h2database#2495: Fix JSON_OBJECT grammar in documentation
• Issue h2database#2493 / PR h2database#2494: Replace ColumnNamer with mode-specific generation of column names for views
• PR h2database#2492: Assorted changes in parser, keywords, and ILIKE condition
• PR h2database#2490: Replace pg_catalog.sql with PgCatalogTable and use DATABASE_TO_LOWER in PG Server
• Issue h2database#2488 / PR h2database#2489: Mark version functions as not deterministic
• Issue h2database#2481: Convert TO to keyword
• PR h2database#2476: Add some PostgreSQL compatibility features mentioned in issue h2database#2450
• PR h2database#2479: Recognize absolute path on Windows without drive letter
• Issue h2database#2475: Select order by clause is exported with non-portable SQL
• Issue h2database#2472: Updating column to empty string in Oracle mode with prepared statement does not result in null
• PR h2database#2468: MVStore scalability improvements
• PR h2database#2466: Add partial support for MySQL COLLATE and CHARACTER statements
• Issue h2database#2464: `client_encoding='utf-8'` (single quoted) from `node-postgres` not recognized
• Issue h2database#2461: Support for binary_float and binary_double type aliases
• Issue h2database#2460: Exception when accessing empty arrays
• Issue h2database#2318: Remove incorrect rows from DatabaseMetaData.getTypeInfo() and INFORMATION_SCHEMA.TYPE_INFO
• Issue h2database#2455: `bytea` column incorrectly read by `psycopg2`
• PR h2database#2456: Add standard array value constructor by query
• PR h2database#2451: Add some PostgreSQL compatibility features mentioned in issue h2database#2450
• Issue h2database#2448: Change default data type name from DOUBLE to DOUBLE PRECISION
• PR h2database#2452: Do not use unsafe and unnecessary FROM DUAL internally
• PR h2database#2449: Add support for standard trigraphs
• Issue h2database#2439: StringIndexOutOfBoundsException when using TO_CHAR
• Issue h2database#2444: WHEN NOT MATCHED THEN INSERT should accept only one row
• Issue h2database#2434: Next value expression should return the same value within a processed row
• PR h2database#2437: Assorted changes in MVStore
• Issue h2database#2430: Postgres `bytea` column should be read with and without `forceBinary`
• Issue h2database#2267: BINARY and VARBINARY should be different
• Issue h2database#2266: CHAR and BINARY should have length 1 by default
• PR h2database#2426: Add MD5 and all SHA-1, SHA-2, and SHA-3 digests to the HASH() function
• Issue h2database#2424: 0 should not be accepted as a length of data type
• Issue h2database#2378: JAVA_OBJECT and TableLink
• Issue h2database#2417: Casts between binary strings and non-string data types
• Issue h2database#2416: OTHER and JAVA_OBJECT
• Issue h2database#2379: SQL export can change data type of a constant
• Issue h2database#2411: ArrayIndexOutOfBoundsException when HAVING and duplicate columns in SELECT
• Issue h2database#2194: Add own enumeration of data types to API
• PR h2database#2408: Descending MVMap and TransactionMap cursor
• Issue h2database#2399: Cast to ARRAY with a nested ARRAY does not check the maximum cardinality of the nested ARRAY
• Issue h2database#2402: Remove old ValueLob and DbUpgrade
• Issue h2database#2400: Inconsistent data type conversion between strings and LOBs
• PR h2database#2398: Add expandable flags for SQL generation methods
• PR h2database#2395: Fix for two recent page format bugs
• PR h2database#2386: Chunk occupancy mask
• PR h2database#2385: Memory estimate
• PR h2database#2381: Follow up REPEATABLE_READ-related changes
• PR h2database#2380: use JIRA tracker URLs for JDK bugs
• PR h2database#2376: Fix IN condition with row value expressions in its right side
• Issue h2database#2367 / PR h2database#2370: fix backward compatibility with 1.4.200
• Issue h2database#2371: REPEATABLE READ isolation level does not work in MVStore
• Issue h2database#2363: Soft links in -baseDir and database path cause error 90028
• Issue h2database#2364: TestScript datatypes/timestamp-with-time-zone.sql fails if TZ=Europe/Berlin
• Issue h2database#2359: Complete implementation of generated columns
• PR h2database#2361: Fix unused result
• PR h2database#2353: Push binary search operation from Page to DataType
• Issue h2database#2348: Add USING clause to ALTER COLUMN CHANGE DATA TYPE
• Issue h2database#2350: License Problem in POM
• Issue h2database#2345: Add standard SET TIME ZONE command to set current time zone of the session
• PR h2database#2341: Cleanup file backend sync
• Issue h2database#2343: Domain-based domains: Domain not found after reconnection
• Issue h2database#2338: Domains should not support NULL constraints
• Issue h2database#2334: build target mavenInstallLocal broken since commit 7cbbd55
• h2database#2335: TestDateTimeUtils fails if system timezone has DST in the future
• Issue h2database#2330: Syntax error with parenthesized expression in GROUP BY clause
• Issue h2database#2256: <interval value expression> with datetime subtraction
• Issue h2database#2325: H2 does not parse nested bracketed comments correctly
• Issue h2database#466: Confusion about INFORMATION_SCHEMA content related to UNIQUE constraints
• PR h2database#2323: Assorted changes
• Issue h2database#2320: Remove SAMPLE_SIZE clause from SELECT
• Issue h2database#2301: Add compatibility setting to accept some keywords as identifiers
• PR h2database#2317: Replace CHECK_COLUMN_USAGE with CONSTRAINT_COLUMN_USAGE and other changes
• Issue h2database#2315: Sequence must remember its original START WITH value
• Issue h2database#2313: DISTINCT does not work in ordered aggregate functions
• PR h2database#2306: Add support for RESTART of sequence without initial value
• Issue h2database#2304: NPE in multiple define commands in one statement after upgrade from H2 4.1.197
• PR h2database#2303: Assorted minor changes
• Issue h2database#2286: Inline check constraints not in INFORMATION_SCHEMA
• PR h2database#2300: Continue generification of MVStore codebase
• PR h2database#2298: add some minimal security documentation
• PR h2database#2292: synchronize fileBase subclasses use of position
• PR h2database#2238: Some MVStore refactoring
• Issue h2database#2288: ConcurrentModificationException during commit
• Issue h2database#2293: Remove TestClearReferences and workarounds for old versions of Apache Tomcat
• Issue h2database#2288: ConcurrentModificationException during commit
• PR h2database#2284: Remove unrelated information from README and add some information about H2
• PR h2database#2282: add PostgreSQL compatible variable STATEMENT_TIMEOUT
• PR h2database#2280: little comment
• Issue h2database#2205: H2 1.4.200 split FS issue
• Issue h2database#2272: UpdatableView and obtaining the Generated Keys
• PR h2database#2276: Split up filesystem classes
• PR h2database#2275: improve detection of JAVA_HOME on Mac OS
• Issue h2database#2268: Numeric division needs better algorithm for scale selection
• Issue h2database#2270: IGNORE_UNKNOWN_SETTINGS is ignored
• PR h2database#2269: Fix existence check of non-persistent databases
• Issue h2database#1910: BinaryOperation should evaluate precision and scale properly
• PR h2database#2264: Clean up redundant parts of file system abstraction
• PR h2database#2262: add setting AUTO_COMPACT_FILL_RATE
• Issue h2database#2255 / PR h2database#2259: Use NIO2 in main sources and build
• PR h2database#2257: Catch java.lang.NoClassDefFoundError
• Issue h2database#2241: Mark H2-specific and compatibility only clauses in documentation
• PR h2database#2246: Update third-party drivers
• Issue h2database#2239 / PR h2database#2236: Add NETWORK_TIMEOUT setting for SO_TIMEOUT
• PR h2database#2235: Don't use RandomAccessFile in FilePathNio
• Issue h2database#2233: "Prepared.getObjectId() was called before" when granting on multiple tables
• PR h2database#2230: Add factory methods for Row
• Issue h2database#2226, PR h2database#2227: Remove support of Apache Ignite
• PR h2database#2224: Update some hyperlinks and use https in them where possible
• PR h2database#2223: Fix data change delta tables in views
• Issue h2database#1943: Deadlock in TestTriggersConstraints
• PR h2database#2219: do not retry failed DDL commands
• PR h2database#2214: Fix TRACE_LEVEL_FILE=4 for in-memory databases
• PR h2database#2216: Add FileChannel.lock in the connection URL summary
• PR h2database#2215: Add white-space: pre to tables with query results
• Issue h2database#2213: NUMERIC scale can be larger than a precision
• PR h2database#2212: Get rid of multi-version CurrentTimestamp and fix negative scale of NUMERIC
• PR h2database#2210: Meta table extras
• PR h2database#2209: Add standard expressions with interval qualifier
• PR h2database#2195: Feature abort_session function
• PR h2database#2201: Add padding to negative years and other changes
• PR h2database#2197: Add some additional methods from JDBC 4.2 and return 4.2 as supported version
• PR h2database#2193: Require Java 8 and remove Java 7 support
• Issue h2database#2191: NPE with H2 v1.4.200 repeatable read select queries
• Issue h2database#1390: Add standard-compliant ARRAY data type syntax
• PR h2database#2186: Refactor Parser.parseColumnWithType() and fix some minor issues with CAST
• Issue h2database#2181: SET EXCLUSIVE quirks
• PR h2database#2173: Move snapshots from Transaction to TransactionMap
• Issue h2database#2175: Regression: NPE in ResultSet#getTime(int)
• Issue h2database#2171: Wrong PostgreSQL compatibility syntax for the creation of indexes
• PR h2database#2169: Clean up some find methods of indexes and fix minor issues with them