# HG changeset patch
# User Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
# Date 1618421374 -7200
# Node ID a888cabe2b15f249e1142d14d6eb7dbc54a6bd07
# Parent  171144a26ba09f7083ba1ff8cce6f14f555e0a67
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.

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},