Changeset: 42955ea716d1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/42955ea716d1 Added Files: sql/test/BugTracker-2022/Tests/dependencies.Bug-7328.test Modified Files: sql/test/BugTracker-2022/Tests/All Branch: Sep2022 Log Message:
Add test for https://github.com/MonetDB/MonetDB/issues/7328 diffs (48 lines): diff --git a/sql/test/BugTracker-2022/Tests/All b/sql/test/BugTracker-2022/Tests/All --- a/sql/test/BugTracker-2022/Tests/All +++ b/sql/test/BugTracker-2022/Tests/All @@ -14,3 +14,4 @@ create_func_with_case_and_in single_row_in_rel_order_by_column.Bug-7306 push-aggr-down-removes-distinct-on-union-all.Bug-7318 temp-table-create-index-drop-issue +dependencies.Bug-7328 diff --git a/sql/test/BugTracker-2022/Tests/dependencies.Bug-7328.test b/sql/test/BugTracker-2022/Tests/dependencies.Bug-7328.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2022/Tests/dependencies.Bug-7328.test @@ -0,0 +1,35 @@ +statement ok +START TRANSACTION + +statement ok +CREATE TABLE mmtest01 ( id int, name text) + +statement ok +CREATE OR REPLACE FUNCTION mmtest02() +RETURNS int +BEGIN + INSERT INTO mmtest01(id) VALUES (1); + RETURN 1; +END + +query I nosort +SELECT count(*) as count +FROM sys.dependency_columns_on_functions +WHERE function_name LIKE 'mmtest02' +---- +1 + +query TTII nosort +SELECT name, function_name, function_type, depend_type +FROM sys.dependency_columns_on_functions +WHERE function_name LIKE 'mmtest02' +ORDER BY name +---- +id +mmtest02 +1 +7 + +statement ok +ROLLBACK + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
