You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jh...@apache.org on 2014/07/16 22:47:53 UTC
git commit: Add test case for [DRILL-1149].
Repository: incubator-optiq
Updated Branches:
refs/heads/master aacbeb524 -> a1baf68df
Add test case for [DRILL-1149].
Project: http://git-wip-us.apache.org/repos/asf/incubator-optiq/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-optiq/commit/a1baf68d
Tree: http://git-wip-us.apache.org/repos/asf/incubator-optiq/tree/a1baf68d
Diff: http://git-wip-us.apache.org/repos/asf/incubator-optiq/diff/a1baf68d
Branch: refs/heads/master
Commit: a1baf68dfdca88a0cca5dba87bc84bb23ffd877f
Parents: aacbeb5
Author: Julian Hyde <jh...@apache.org>
Authored: Wed Jul 16 10:46:08 2014 -0700
Committer: Julian Hyde <jh...@apache.org>
Committed: Wed Jul 16 10:46:08 2014 -0700
----------------------------------------------------------------------
core/src/test/resources/sql/misc.oq | 15 +++++++++++++++
1 file changed, 15 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-optiq/blob/a1baf68d/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 7f4f31d..13b66c3 100644
--- a/core/src/test/resources/sql/misc.oq
+++ b/core/src/test/resources/sql/misc.oq
@@ -61,6 +61,21 @@ select cast(c_timestamp as varchar(20)), cast(c_timestamp as date) from data whe
!ok
!}
+# [DRILL-1149]
+select *, upper("name")
+from "hr"."emps";
++-------+--------+-----------+---------+------------+-----------+
+| empid | deptno | name | salary | commission | EXPR$5 |
++-------+--------+-----------+---------+------------+-----------+
+| 100 | 10 | Bill | 10000.0 | 1000 | BILL |
+| 110 | 10 | Theodore | 11500.0 | 250 | THEODORE |
+| 150 | 10 | Sebastian | 7000.0 | | SEBASTIAN |
+| 200 | 20 | Eric | 8000.0 | 500 | ERIC |
++-------+--------+-----------+---------+------------+-----------+
+(4 rows)
+
+!ok
+
# [OPTIQ-340] SqlToRelConverter fails with complex join condition
select e."deptno", d."deptno"
from "hr"."emps" as e