Mercurial > hg > monetdb-java
changeset 468:a888cabe2b15
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.
| author | Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
|---|---|
| date | Wed, 14 Apr 2021 19:29:34 +0200 (2021-04-14) |
| parents | 171144a26ba0 |
| children | 53911f29093c |
| files | src/main/java/org/monetdb/util/MDBvalidator.java |
| diffstat | 1 files changed, 2 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- 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},