Changeset: 2b8db34e9bae for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2b8db34e9bae
Modified Files:
sql/test/miscellaneous/Tests/simple_selects.sql
sql/test/miscellaneous/Tests/simple_selects.stable.out
Branch: octbugs
Log Message:
Another bug, the alias must be found again on the grouping clause :(
diffs (32 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
@@ -208,6 +208,12 @@ select cast(13121 as varchar(2147483647)
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, 2 from (select 1) as x(x) order by z, z;
+ -- 1 2
+
+select x as z, 2 from (select 1) as x(x) group by z, z;
+ -- 1 2
+
select x as z, y as z from (select 1, 2) as x(x,y) group by z;
-- error 'z' identifier is ambiguous
diff --git a/sql/test/miscellaneous/Tests/simple_selects.stable.out
b/sql/test/miscellaneous/Tests/simple_selects.stable.out
--- a/sql/test/miscellaneous/Tests/simple_selects.stable.out
+++ b/sql/test/miscellaneous/Tests/simple_selects.stable.out
@@ -400,6 +400,12 @@ stdout of test 'simple_selects` in direc
[ "12/02/11" ]
[ "12/02/12" ]
[ "12/02/13" ]
+#select x as z, 2 from (select 1) as x(x) order by z, z;
+% ., .%1 # table_name
+% z, %1 # name
+% tinyint, tinyint # type
+% 1, 1 # length
+[ 1, 2 ]
# 17:31:38 >
# 17:31:38 > "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
