Changeset: 35c465c96d92 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/35c465c96d92 Added Files: sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.test Removed Files: sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.sql sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.stable.err sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.stable.out Branch: Jul2021 Log Message:
Converted test for Issue #7144 to SQLlogicTest diffs (100 lines): diff --git a/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.sql b/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.sql deleted file mode 100644 --- a/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.sql +++ /dev/null @@ -1,10 +0,0 @@ -create table ints (id int); -insert into ints values (24), (42); -create table t (i bigint, j bigint); -insert into t(i) select id from ints; -insert into t(j) select id from ints; -insert into t(i, j) select id, id from ints; -insert into t(i, j) select cast(id as bigint), id from ints; -insert into t(i, j) select id, cast(id as bigint) from ints; -drop table t; -drop table ints; diff --git a/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.stable.err b/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.stable.err deleted file mode 100644 --- a/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.stable.err +++ /dev/null @@ -1,11 +0,0 @@ -stderr of test 'type-upcasting-INT2BIGINT.Bug-7144` in directory 'sql/test/BugTracker-2021` itself: - - -# 10:56:57 > -# 10:56:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-1437508" "--port=33843" -# 10:56:57 > - -# 10:56:57 > -# 10:56:57 > "Done." -# 10:56:57 > - diff --git a/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.stable.out b/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.stable.out deleted file mode 100644 --- a/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.stable.out +++ /dev/null @@ -1,28 +0,0 @@ -stdout of test 'type-upcasting-INT2BIGINT.Bug-7144` in directory 'sql/test/BugTracker-2021` itself: - - -# 10:56:57 > -# 10:56:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-1437508" "--port=33843" -# 10:56:57 > - -#create table ints (id int); -#insert into ints values (24), (42); -[ 2 ] -#create table t (i bigint, j bigint); -#insert into t(i) select id from ints; -[ 2 ] -#insert into t(j) select id from ints; -[ 2 ] -#insert into t(i, j) select id, id from ints; -[ 2 ] -#insert into t(i, j) select cast(id as bigint), id from ints; -[ 2 ] -#insert into t(i, j) select id, cast(id as bigint) from ints; -[ 2 ] -#drop table t; -#drop table ints; - -# 10:56:57 > -# 10:56:57 > "Done." -# 10:56:57 > - diff --git a/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.test b/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.test @@ -0,0 +1,31 @@ +statement ok +create table ints (id int) + +statement ok rowcount 2 +insert into ints values (24), (42) + +statement ok +create table t (i bigint, j bigint) + +statement ok rowcount 2 +insert into t(i) select id from ints + +statement ok rowcount 2 +insert into t(j) select id from ints + +statement ok rowcount 2 +insert into t(i, j) select id, id from ints + +statement ok rowcount 2 +insert into t(i, j) select cast(id as bigint), id from ints + +statement ok rowcount 2 +insert into t(i, j) select id, cast(id as bigint) from ints + +statement ok +drop table t + +statement ok +drop table ints + + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
