# HG changeset patch
# User Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
# Date 1717088780 -7200
# Node ID 73f25cb71e4fb61fe2ac03339fba1cd9476635d8
# Parent  be8476c1acecdce9b9a1a5599c6adc3afc9531b7
Adapt table DDL generator to deal with new UNIQUE NULLS NOT DISTINCT key_type.

diff --git a/src/main/java/org/monetdb/util/SQLExporter.java b/src/main/java/org/monetdb/util/SQLExporter.java
--- a/src/main/java/org/monetdb/util/SQLExporter.java
+++ b/src/main/java/org/monetdb/util/SQLExporter.java
@@ -216,7 +216,12 @@ public final class SQLExporter extends E
 			final String idxname = cols.getString(colIndexNm);
 			if (idxname != null && !idxname.endsWith("_pkey")) {
 				out.println(",");
-				out.print("\tCONSTRAINT " + dq(idxname) + " UNIQUE (" + dq(cols.getString(colNmIndex)));
+				out.print("\tCONSTRAINT " + dq(idxname));
+				if (idxname.endsWith("_nndunique"))
+					out.print(" UNIQUE NULLS NOT DISTINCT (");	// new since release 11.50 (Aug2024)
+				else
+					out.print(" UNIQUE (");
+				out.print(dq(cols.getString(colNmIndex)));
 
 				boolean next;
 				while ((next = cols.next()) && idxname.equals(cols.getString(colIndexNm))) {