<h2>Next Version (unreleased)</h2>

<li>nothing here yet</li>

<li>Issue #4302: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Check constraint invalid

<li>Issue #4286: [2.4.240] SHUTDOWN COMPACT failure

<li>Issue #4293: Data Race in org.h2.mvstore.tx.TransactionStore.registerTransaction

<li>Issue #4299: READ_COMMITTED isolation level sometimes doesn't see uncommitted changes from the same transaction 2.4.240

<li>Issue #4048: Assertion error in shrinkStoreIfPossible

<li>Issue #4304: DROP SCHEMA &amp; DROP ALL OBJECTS is broken if a materialized view is present in the schema

<h2>Version 2.4.240 (2025-09-22)</h2>

importjava.util.List;

importjava.util.TreeSet;

importorg.h2.engine.Database;

importorg.h2.engine.SessionLocal;

importorg.h2.expression.Expression;

importorg.h2.expression.ExpressionColumn;

ConditionInConstantSet(SessionLocalsession,Expressionleft,booleannot,booleanwhenOperand,

ArrayList<Expression>valueList) {

super(left,not,whenOperand,valueList);

this.valueSet =newTreeSet<>(session);

Databasedb =session.getDatabase();

this.valueSet =newTreeSet<>((o1,o2) ->o1.compareTo(o2,db,db.getCompareMode()));

TypeInfotype =left.getType();

for (Expressionexpression :valueList) {

type =TypeInfo.getHigherType(type,expression.getType());

testTriggerAsJavascript();

testTriggers();

testConstraints();

testCheckConstraints();

testCheckConstraintErrorMessage();

testMultiPartForeignKeys();

testConcurrent();

conn.close();

}

privatevoidtestCheckConstraints()throwsSQLException {

Connectionconn =getConnection("trigger");

Statementstat =conn.createStatement();

stat.execute("DROP TABLE IF EXISTS TEST");

stat.execute("CREATE TABLE TEST(ID BIGINT PRIMARY KEY, A INT, B INT, CHECK (B IN (2, 3, 5)))");

ConnectionotherConnection =getConnection("trigger");

conn.close();

stat =otherConnection.createStatement();

stat.execute("INSERT INTO TEST VALUES (2, 3, 2)");

stat.execute("DROP TABLE TEST");

otherConnection.close();

}

privatevoidtestCheckConstraintErrorMessage()throwsSQLException {

Connectionconn =getConnection("trigger");

Statementstat =conn.createStatement();