[2/3] git commit: Add test case for [OPTIQ-411] duplicate column aliases

[jh...@apache.org]

Add test case for [OPTIQ-411] duplicate column aliases


Project: http://git-wip-us.apache.org/repos/asf/incubator-optiq/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-optiq/commit/f7158805
Tree: http://git-wip-us.apache.org/repos/asf/incubator-optiq/tree/f7158805
Diff: http://git-wip-us.apache.org/repos/asf/incubator-optiq/diff/f7158805

Branch: refs/heads/master
Commit: f7158805013c03f9e0252cb7808c26358a5c111c
Parents: 3148ca3
Author: Julian Hyde <jh...@apache.org>
Authored: Tue Sep 16 15:04:10 2014 -0700
Committer: Julian Hyde <jh...@apache.org>
Committed: Tue Sep 16 15:04:26 2014 -0700

----------------------------------------------------------------------
 core/src/test/resources/sql/misc.oq | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-optiq/blob/f7158805/core/src/test/resources/sql/misc.oq
----------------------------------------------------------------------
diff --git a/core/src/test/resources/sql/misc.oq b/core/src/test/resources/sql/misc.oq
index f5b7e1c..5aff02c 100644
--- a/core/src/test/resources/sql/misc.oq
+++ b/core/src/test/resources/sql/misc.oq
@@ -514,4 +514,26 @@ having exists
 
 !ok
 
+# [OPTIQ-411] Duplicate aliases
+select 1 as a, 2 as a from (values (true));
++---+---+
+| A | A |
++---+---+
+| 1 | 2 |
++---+---+
+(1 row)
+
+!ok
+
+select "day", "day" from "days" where "day" < 3;
++-----+-----+
+| day | day |
++-----+-----+
+|   1 |   1 |
+|   2 |   2 |
++-----+-----+
+(2 rows)
+
+!ok
+
 # End misc.oq