Changeset: 7445b3487a57 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7445b3487a57 Added 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 Modified Files: sql/test/BugTracker-2021/Tests/All Branch: Oct2020 Log Message:
Added test for Issue #7144 diffs (72 lines): diff --git a/sql/test/BugTracker-2021/Tests/All b/sql/test/BugTracker-2021/Tests/All --- a/sql/test/BugTracker-2021/Tests/All +++ b/sql/test/BugTracker-2021/Tests/All @@ -15,3 +15,4 @@ KNOWNFAIL?WITH-alias-DELETE-2.deletes-to HAVE_LIBPY3?python-aggregates-void-bat.Bug-7138 count-distinct.Bug-7141 HAVE_LIBPY3?aggregates-tables.Bug-7142 +type-upcasting-INT2BIGINT.Bug-7144 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 new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.sql @@ -0,0 +1,10 @@ +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 new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.stable.err @@ -0,0 +1,11 @@ +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 new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.stable.out @@ -0,0 +1,28 @@ +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 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
