# HG changeset patch
# User Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
# Date 1629910637 -7200
# Node ID 5590589fe7c778a607c00da69ded4f81513c6725
# Parent  a6c98b35a054e9993770107240ce14327635ed5c
Fix for error reported when system catalog validations (\vsci command) are run on Jun2020 releases.
It would report:
Failed to execute query: SELECT optimizer, * FROM sys.sessions WHERE (optimizer) NOT IN (SELECT name FROM sys.optimizers);
42000 SELECT: identifier 'optimizer' ambiguous

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
@@ -1126,7 +1126,7 @@ public final class MDBvalidator {
 // 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"},
+		{"sessions", "sessions.optimizer", "name", "optimizers", "37"}, 	// without the sessions. prefix it will give an error on Jun2020 release
 		{"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},