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