Changeset: 00000046f794 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/00000046f794 Modified Files: sql/test/BugTracker-2022/Tests/dependencies.Bug-7328.test Branch: Sep2022 Log Message:
The function does depend on both columns in the table. Both columns must be filled by the INSERT, hence both are dependents. diffs (73 lines): diff --git a/sql/test/BugTracker-2022/Tests/dependencies.Bug-7328.test b/sql/test/BugTracker-2022/Tests/dependencies.Bug-7328.test --- a/sql/test/BugTracker-2022/Tests/dependencies.Bug-7328.test +++ b/sql/test/BugTracker-2022/Tests/dependencies.Bug-7328.test @@ -15,7 +15,7 @@ END statement ok select mmtest02() -query TI nosort +query IT nosort SELECT * FROM mmtest01 ---- 1 @@ -26,7 +26,7 @@ SELECT count(*) as count FROM sys.dependency_columns_on_functions WHERE function_name LIKE 'mmtest02' ---- -1 +2 query TTII nosort SELECT name, function_name, function_type, depend_type @@ -38,10 +38,13 @@ id mmtest02 1 7 +name +mmtest02 +1 +7 # as only 1 column is specified in the function mmtest02 we expect only 1 dependency, instead we get 2 columns returned - # an extra test to check what happens when no columns are listed in the insert statement statement ok CREATE OR REPLACE FUNCTION mmtest03() @@ -54,7 +57,7 @@ END statement ok select mmtest03() -query TI nosort +query IT nosort SELECT * FROM mmtest01 ---- 1 @@ -83,10 +86,17 @@ FROM sys.dependency_columns_on_functions WHERE function_name LIKE 'mmtest03' ORDER BY name ---- +id +mmtest03 +1 +7 +name +mmtest03 +1 +7 # as no columns are specified in the function mmtest03 we expect also 0 dependencies here, instead we get 2 columns returned - # also check what happens when you specify DELETE instead of INSERT statement ok CREATE OR REPLACE FUNCTION mmtest04() @@ -99,7 +109,7 @@ END statement ok select mmtest04() -query TI nosort +query IT nosort SELECT * FROM mmtest01 ---- _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
