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

Add missing FKey check from sessions.optimzer to optimizers.name.
Remove old no longer usefull fk checks for queue.tag It used to be from qtag to 
tag but column qtag has been removed since Jun2020.


diffs (17 lines):

diff --git a/src/main/java/org/monetdb/util/MDBvalidator.java 
b/src/main/java/org/monetdb/util/MDBvalidator.java
--- a/src/main/java/org/monetdb/util/MDBvalidator.java
+++ b/src/main/java/org/monetdb/util/MDBvalidator.java
@@ -1123,11 +1123,10 @@ public final class MDBvalidator {
                {"querylog_history", "id", "id", "querylog_catalog", null},
                {"querylog_history", "owner", "name", "users", null},
                {"querylog_history", "pipe", "name", "optimizers", null},
-               {"queue WHERE tag > cast(0 as oid) AND ", "tag", "tag", 
"queue", null},
-               {"queue WHERE tag > cast(0 as oid) AND ", "tag", "cast(tag as 
oid)", "queue", null},
-               {"queue", "tag", "cast(tag as oid)", "queue", null},
+// not a fk:   {"queue", "sessionid", "sessionid", "sessions", "37"},  // as 
queue contains a historical list, the session may have been closed in the 
meantime, so not a real persistent fk
 // not a fk:   {"queue", "\"username\"", "name", "users", null},       // as 
queue contains a historical list, the user may have been removed in the 
meantime, so not a real persistent fk
                {"sessions", "\"username\"", "name", "users", null},
+               {"sessions", "optimizer", "name", "optimizers", "37"},
                {"statistics", "column_id", "id", "(SELECT id FROM sys._columns 
UNION ALL SELECT id FROM tmp._columns) as c", null},
                {"statistics", "type", "sqlname", "types", null},
                {"storage()", "schema", "name", "schemas", null},
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to