Changeset: c91dfcfd4db3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c91dfcfd4db3 Added Files: sql/test/bugs/Tests/procedure-recompile.test Modified Files: sql/test/bugs/Tests/All Branch: default Log Message:
Issue to be looked on later, on DDL changes UDFs may have to be recompiled diffs (64 lines): diff --git a/sql/test/bugs/Tests/All b/sql/test/bugs/Tests/All --- a/sql/test/bugs/Tests/All +++ b/sql/test/bugs/Tests/All @@ -113,3 +113,4 @@ HAVE_GEOM?filter_error in rtrim_bug savepoint-release +procedure-recompile diff --git a/sql/test/bugs/Tests/procedure-recompile.test b/sql/test/bugs/Tests/procedure-recompile.test new file mode 100644 --- /dev/null +++ b/sql/test/bugs/Tests/procedure-recompile.test @@ -0,0 +1,51 @@ +statement ok +create table x (a int) + +statement ok rowcount 2 +insert into x values (1),(2) + +statement ok +create procedure myproc() begin insert into x values (3); end + +query I rowsort +select a from x +---- +1 +2 + +statement ok +call myproc() + +query I rowsort +select a from x +---- +1 +2 +3 + +statement ok +alter table x add constraint mycon primary key(a) + +query I rowsort +select a from x +---- +1 +2 +3 + +statement error primary key violation +call myproc() + +query I rowsort +select a from x +---- +1 +2 +3 + +statement ok +drop procedure myproc + +statement ok +drop table x + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
