# HG changeset patch
# User Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
# Date 1721324723 -7200
# Node ID a8ca336e7f1a6cf7c35f2b6f230df7a1c41dcab3
# Parent  e85dcb3ea4a6ed78c08862bb85094a274d7f3b1e
supportsIntegrityEnhancementFacility() should return true when connected to Aug2024 (11.51) or higher servers.

diff --git a/src/main/java/org/monetdb/jdbc/MonetDatabaseMetaData.java b/src/main/java/org/monetdb/jdbc/MonetDatabaseMetaData.java
--- a/src/main/java/org/monetdb/jdbc/MonetDatabaseMetaData.java
+++ b/src/main/java/org/monetdb/jdbc/MonetDatabaseMetaData.java
@@ -938,13 +938,16 @@ public final class MonetDatabaseMetaData
 	 * inter-column constraints to be maintained by the database system.
 	 * Default clauses provide optional default values for missing data.
 	 *
-	 * We currently do not supprt CHECK constraints (see bug 3568) nor deferrable FK constraints.
-	 *
 	 * @return true if so
 	 */
 	@Override
 	public boolean supportsIntegrityEnhancementFacility() {
-		return false;
+		// Starting with release Aug2024 (11.51.1) MonetDB now also supports CHECK constraints (ref issue 3335, 3568).
+		try {
+			if ((con.getDatabaseMajorVersion() == 11) && (con.getDatabaseMinorVersion() >= 51))
+				return true;
+		} catch (SQLException e) { /* ignore */	}
+		return false;	// for older servers
 	}
 
 	/**