Changeset: 6f5b27e7b427 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6f5b27e7b427 Modified Files: sql/test/miscellaneous/Tests/simple_selects.sql Branch: octbugs Log Message:
New small bugs, the grouping and order identifiers on these queries should be ambiguous :( diffs (13 lines): diff --git a/sql/test/miscellaneous/Tests/simple_selects.sql b/sql/test/miscellaneous/Tests/simple_selects.sql --- a/sql/test/miscellaneous/Tests/simple_selects.sql +++ b/sql/test/miscellaneous/Tests/simple_selects.sql @@ -207,3 +207,9 @@ select cast(interval '3' second as clob) select cast(13121 as varchar(2147483647)) || cast(231231 as varchar(2147483647)); --error, too big select date_to_str(a,'%y/%m/%d') from (values (date '2012-02-11'), (date '2012-02-12'),(date '2012-02-13')) as a(a); + +select x as z, y as z from (select 1, 2) as x(x,y) group by z; + -- error 'z' identifier is ambiguous + +select x as z, y as z from (select 1, 2) as x(x,y) order by z; + -- error 'z' identifier is ambiguous _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
