Skip to content

sql: views don't track their dependencies correctly (again...) #17306

@knz

Description

@knz
CREATE TABLE t(x INT);
CREATE VIEW v AS SELECT x FROM t WHERE false;
DROP TABLE t; -- succeeds, it shouldn't
SELECT * FROM v; -- broken

The problem is again that dependency analysis looks at the query plan after optimization (and thus filter elimination), not the tables actually named.

Metadata

Metadata

Assignees

Labels

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions