Changeset: 5ff6952a7069 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5ff6952a7069 Added Files: sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.sql sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.stable.err sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.stable.out sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.sql sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.stable.err sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.stable.out Modified Files: sql/test/BugTracker-2020/Tests/All Branch: Oct2020 Log Message:
Added tests for bugs 6964 and 6965 diffs (134 lines): diff --git a/sql/test/BugTracker-2020/Tests/All b/sql/test/BugTracker-2020/Tests/All --- a/sql/test/BugTracker-2020/Tests/All +++ b/sql/test/BugTracker-2020/Tests/All @@ -22,3 +22,5 @@ copy-empty-blob.Bug-6948 values-like-join.Bug-6954 round.Bug-6955 log.Bug-6960 +table-udf-column-descriptor.Bug-6964 +table-udf-distinct.Bug-6965 diff --git a/sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.sql b/sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.sql @@ -0,0 +1,9 @@ +START TRANSACTION; +CREATE OR REPLACE FUNCTION test(i integer) +RETURNS TABLE (value integer) +BEGIN + return select value from generate_series(1,i); +END; + +select value from test(3); +ROLLBACK; diff --git a/sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.stable.err b/sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.stable.err @@ -0,0 +1,12 @@ +stderr of test 'table-udf-column-descriptor.Bug-6964` in directory 'sql/test/BugTracker-2020` itself: + + +# 12:20:49 > +# 12:20:49 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-261339" "--port=32116" +# 12:20:49 > + + +# 12:20:49 > +# 12:20:49 > "Done." +# 12:20:49 > + diff --git a/sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.stable.out b/sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/table-udf-column-descriptor.Bug-6964.stable.out @@ -0,0 +1,26 @@ +stdout of test 'table-udf-column-descriptor.Bug-6964` in directory 'sql/test/BugTracker-2020` itself: + + +# 12:20:49 > +# 12:20:49 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-261339" "--port=32116" +# 12:20:49 > + +#START TRANSACTION; +#CREATE OR REPLACE FUNCTION test(i integer) +#RETURNS TABLE (value integer) +#BEGIN +# return select value from generate_series(1,i); +#END; +#select value from test(3); +% .%2 # table_name +% value # name +% int # type +% 1 # length +[ 1 ] +[ 2 ] +#ROLLBACK; + +# 12:20:49 > +# 12:20:49 > "Done." +# 12:20:49 > + diff --git a/sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.sql b/sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.sql @@ -0,0 +1,9 @@ +START TRANSACTION; +CREATE OR REPLACE FUNCTION test(i integer) +RETURNS TABLE (value integer) +BEGIN + return values (1), (2), (2), (3), (i); +END; + +select distinct value from test(3); +ROLLBACK; diff --git a/sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.stable.err b/sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.stable.err @@ -0,0 +1,12 @@ +stderr of test 'table-udf-distinct.Bug-6965` in directory 'sql/test/BugTracker-2020` itself: + + +# 12:23:31 > +# 12:23:31 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-261797" "--port=34289" +# 12:23:31 > + + +# 12:23:31 > +# 12:23:31 > "Done." +# 12:23:31 > + diff --git a/sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.stable.out b/sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/table-udf-distinct.Bug-6965.stable.out @@ -0,0 +1,27 @@ +stdout of test 'table-udf-distinct.Bug-6965` in directory 'sql/test/BugTracker-2020` itself: + + +# 12:23:31 > +# 12:23:31 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-261797" "--port=34289" +# 12:23:31 > + +#START TRANSACTION; +#CREATE OR REPLACE FUNCTION test(i integer) +#RETURNS TABLE (value integer) +#BEGIN +# return values (1), (2), (2), (3), (i); +#END; +#select distinct value from test(3); +% .%2 # table_name +% value # name +% int # type +% 1 # length +[ 1 ] +[ 2 ] +[ 3 ] +#ROLLBACK; + +# 12:23:31 > +# 12:23:31 > "Done." +# 12:23:31 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
