Mercurial > hg > monetdb-java

changeset 901:73f25cb71e4f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adapt table DDL generator to deal with new UNIQUE NULLS NOT DISTINCT key_type.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 30 May 2024 19:06:20 +0200 (10 months ago)
parents be8476c1acec
children 65d42db0c831
files src/main/java/org/monetdb/util/SQLExporter.java
diffstat 1 files changed, 6 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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))) {