Changeset: 439a106d4bea for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=439a106d4bea
Added Files:
sql/test/BugTracker-2020/Tests/drop-table-with-auto_increment.Bug-7030.test
Branch: default
Log Message:
Converted new test.
diffs (31 lines):
diff --git
a/sql/test/BugTracker-2020/Tests/drop-table-with-auto_increment.Bug-7030.test
b/sql/test/BugTracker-2020/Tests/drop-table-with-auto_increment.Bug-7030.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker-2020/Tests/drop-table-with-auto_increment.Bug-7030.test
@@ -0,0 +1,26 @@
+statement ok
+create local temp table "depend_count" ("a" bigint) on commit preserve rows
+
+statement ok
+insert into "depend_count" values ((select count(*) from dependencies,
sequences))
+
+statement ok
+create schema s1
+
+statement ok
+create table s1.t (i int not null auto_increment)
+
+statement ok
+drop table s1.t
+
+statement ok
+drop schema s1
+
+query I nosort
+select cast(count(*) - (select "a" from "depend_count") as bigint) from
dependencies, sequences
+----
+0
+
+statement ok
+drop table "depend_count"
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
