Mercurial > hg > monetdb-java
changeset 491:5590589fe7c7
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
| author | Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
|---|---|
| date | Wed, 25 Aug 2021 18:57:17 +0200 (2021-08-25) |
| parents | a6c98b35a054 |
| children | 6f7a836a15d6 |
| files | src/main/java/org/monetdb/util/MDBvalidator.java |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- 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},