Changeset: 2b89c15ece0a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2b89c15ece0a Added Files: sql/test/BugTracker-2022/Tests/delete-update.Bug-7267.test Modified Files: sql/test/BugTracker-2022/Tests/All Branch: Jan2022 Log Message:
Add test for bug 7267. diffs (32 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 @@ -4,3 +4,4 @@ insert-not-null.Bug-7232 recreate-view.Bug-7241 HAVE_LIBPY3?python-udf-inside-udf.Bug-7252 pkey-restart.Bug-7263 +delete-update.Bug-7267 diff --git a/sql/test/BugTracker-2022/Tests/delete-update.Bug-7267.test b/sql/test/BugTracker-2022/Tests/delete-update.Bug-7267.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2022/Tests/delete-update.Bug-7267.test @@ -0,0 +1,19 @@ +statement ok +create table tmp(i,s) as (select i, cast(i as string) from generate_series(1,1000) as t(i)) + +statement ok +delete from tmp where i in (5,6,7) + +statement ok +update tmp set s = 'hello' + +query I nosort +select count(*) from tmp where s = 'hello' +---- +996 + +query I nosort +select count(*) from tmp where s <> 'hello' +---- +0 + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
