Changeset: 73f25cb71e4f for monetdb-java
URL: https://dev.monetdb.org/hg/monetdb-java/rev/73f25cb71e4f
Modified Files:
        src/main/java/org/monetdb/util/SQLExporter.java
Branch: default
Log Message:

Adapt table DDL generator to deal with new UNIQUE NULLS NOT DISTINCT key_type.


diffs (17 lines):

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))) {
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org

Reply via email to