Changeset: 4375fb7e1ddd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4375fb7e1ddd Modified Files: sql/test/BugTracker-2025/Tests/7625_missing_temporary_view_types.test Branch: Mar2025 Log Message:
Extend test with creating a temporary view with a qualified name other than schema tmp. It should give an error. diffs (13 lines): diff --git a/sql/test/BugTracker-2025/Tests/7625_missing_temporary_view_types.test b/sql/test/BugTracker-2025/Tests/7625_missing_temporary_view_types.test --- a/sql/test/BugTracker-2025/Tests/7625_missing_temporary_view_types.test +++ b/sql/test/BugTracker-2025/Tests/7625_missing_temporary_view_types.test @@ -139,6 +139,9 @@ create temporary view tv as select name, 31 +statement error 3F000!CREATE VIEW: local temporary views should be stored in the 'tmp' schema +CREATE LOCAL TEMPORARY VIEW sys.sysltv AS select name, schema_id, query, type, system, commit_action, access, temporary from sys.tables where not system + statement ok CREATE OR REPLACE VIEW v AS select name, schema_id, query, type, system, commit_action, access, temporary from sys.tables where not system _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
