Changeset: 5bf07a17cf38 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5bf07a17cf38 Modified Files: sql/test/subquery/Tests/subquery6.stable.err sql/test/subquery/Tests/subquery6.stable.out Branch: Oct2020 Log Message:
Approved output diffs (137 lines): diff --git a/sql/test/subquery/Tests/subquery6.stable.err b/sql/test/subquery/Tests/subquery6.stable.err --- a/sql/test/subquery/Tests/subquery6.stable.err +++ b/sql/test/subquery/Tests/subquery6.stable.err @@ -78,6 +78,30 @@ MAPI = (monetdb) /var/tmp/mtest-429967/ QUERY = select ntile(i) over (), count(*) from integers; ERROR = !SELECT: cannot use non GROUP BY column in query results without an aggregate function CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-6957/.s.monetdb.33856 +QUERY = select (select i2.i in (select sum(i1.i + i2.i)) from integers i2) from integers i1; +ERROR = !SELECT: cannot use non GROUP BY column in query results without an aggregate function +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-6957/.s.monetdb.33856 +QUERY = select (select i2.i in (select sum(i1.i + i2.i)) from integers i2) from integers i1 group by i1.i; +ERROR = !SELECT: cannot use non GROUP BY column in query results without an aggregate function +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-6957/.s.monetdb.33856 +QUERY = select (select i2.i in (select sum(i1.i + i2.i)) from integers i2 group by i2.i) from integers i1; +ERROR = !GDK reported error: mergejoin: more than one match +MAPI = (monetdb) /var/tmp/mtest-6957/.s.monetdb.33856 +QUERY = select (select i2.i in (select sum(i1.i + i2.i)) from integers i2 group by i2.i) from integers i1 group by i1.i; +ERROR = !GDK reported error: mergejoin: more than one match +MAPI = (monetdb) /var/tmp/mtest-6957/.s.monetdb.33856 +QUERY = select (select sum(i2.i) in (select sum(i1.i + i2.i)) from integers i2 group by i2.i) from integers i1 group by i1.i; +ERROR = !GDK reported error: mergejoin: more than one match +MAPI = (monetdb) /var/tmp/mtest-6957/.s.monetdb.33856 +QUERY = select (select sum(i1.i + i2.i) in (select sum(i1.i + i2.i)) from integers i2 group by i2.i) from integers i1 group by i1.i; +ERROR = !GDK reported error: mergejoin: more than one match +MAPI = (monetdb) /var/tmp/mtest-6957/.s.monetdb.33856 +QUERY = select (select sum(i1.i) > (select sum(i1.i + i2.i)) from integers i2) from integers i1; +ERROR = !SELECT: subquery uses ungrouped column from outer query +CODE = 42000 # 11:45:43 > # 11:45:43 > "Done." diff --git a/sql/test/subquery/Tests/subquery6.stable.out b/sql/test/subquery/Tests/subquery6.stable.out --- a/sql/test/subquery/Tests/subquery6.stable.out +++ b/sql/test/subquery/Tests/subquery6.stable.out @@ -28,8 +28,8 @@ stdout of test 'subquery6` in directory # WHERE ctr1.ctr_state = ctr2.ctr_state) # AND col1 = ColID # AND ctr1.ctr_customer_sk = TotalSales; -% .%45 # table_name -% %45 # name +% .%5 # table_name +% %5 # name % tinyint # type % 1 # length #SELECT (SELECT (SELECT SUM(col1)) IN (MAX(col2))) FROM another_t; @@ -169,8 +169,8 @@ stdout of test 'subquery6` in directory [ 222 ] [ 2222 ] #SELECT (SELECT 1) > ANY(SELECT 1); -% .%10 # table_name -% %10 # name +% .%7 # table_name +% %7 # name % boolean # type % 5 # length [ false ] @@ -242,8 +242,8 @@ stdout of test 'subquery6` in directory # RETURN n; #END; #SELECT debugme6(); -% .%6 # table_name -% %6 # name +% .%4 # table_name +% %4 # name % int # type % 1 # length [ NULL ] @@ -326,6 +326,66 @@ stdout of test 'subquery6` in directory % char, char, char, char, char, int # type % 0, 0, 3, 3, 3, 3 # length [ NULL, NULL, "bug", "oth", "bug", 500 ] +#select (select sum(i1.i + i2.i) in (select sum(i1.i + i2.i)) from integers i2) from integers i1; +% .%4 # table_name +% %4 # name +% boolean # type +% 5 # length +[ true ] +[ true ] +[ true ] +[ NULL ] +#select (select sum(i1.i + i2.i) > (select sum(i1.i + i2.i)) from integers i2) from integers i1; +% .%2 # table_name +% %2 # name +% boolean # type +% 5 # length +[ false ] +[ false ] +[ false ] +[ NULL ] +#select (select sum(i2.i) > (select sum(i1.i + i2.i)) from integers i2) from integers i1; +% .%3 # table_name +% %3 # name +% boolean # type +% 5 # length +[ false ] +[ false ] +[ false ] +[ NULL ] +#select (select sum(i1.i) > (select sum(i1.i + i2.i)) from integers i2) from integers i1 group by i1.i; +% .%3 # table_name +% %3 # name +% boolean # type +% 5 # length +[ false ] +[ false ] +[ false ] +[ NULL ] +#select (select sum(i1.i) < (select sum(sum(i1.i) + i2.i)) from integers i2) from integers i1; +% .%3 # table_name +% %3 # name +% boolean # type +% 5 # length +[ true ] +#select (select exists (select sum(i1.i + i2.i)) from integers i2) from integers i1; +% .%2 # table_name +% %2 # name +% boolean # type +% 5 # length +[ true ] +[ true ] +[ true ] +[ true ] +#select (select not exists (select sum(i1.i + i2.i)) from integers i2) from integers i1 group by i1.i; +% .%2 # table_name +% %2 # name +% boolean # type +% 5 # length +[ false ] +[ false ] +[ false ] +[ false ] #DROP TABLE tbl_ProductSales; #DROP TABLE another_T; #DROP TABLE integers; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
