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