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 2015/08/01 00:43:02 UTC
[25/50] [abbrv] incubator-calcite git commit: Upgrade quidem
Upgrade quidem
Project: http://git-wip-us.apache.org/repos/asf/incubator-calcite/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/88599ef5
Tree: http://git-wip-us.apache.org/repos/asf/incubator-calcite/tree/88599ef5
Diff: http://git-wip-us.apache.org/repos/asf/incubator-calcite/diff/88599ef5
Branch: refs/heads/branch-release
Commit: 88599ef5c9dbce95d3155474f2286d4087724a2f
Parents: f98d567
Author: Julian Hyde <jh...@apache.org>
Authored: Fri May 8 15:50:06 2015 -0700
Committer: Julian Hyde <jh...@apache.org>
Committed: Fri May 8 17:06:02 2015 -0700
----------------------------------------------------------------------
core/src/test/resources/sql/misc.oq | 24 ++++++++++++------------
core/src/test/resources/sql/subquery.oq | 8 ++++----
pom.xml | 2 +-
3 files changed, 17 insertions(+), 17 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-calcite/blob/88599ef5/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 4d4bc80..75af0bc 100644
--- a/core/src/test/resources/sql/misc.oq
+++ b/core/src/test/resources/sql/misc.oq
@@ -805,18 +805,18 @@ select distinct gender, sum(deptno) as s from emp group by gender;
(2 rows)
!ok
-# The following queries should give error. Uncomment when
-# [QUIDEM-1] Add '!error' command
-# is fixed.
-#select distinct gender, deptno from emp group by gender;
-#Expression 'DEPTNO' is not being grouped
-#!error
-#select distinct gender, deptno from emp group by gender, ename;
-#Expression 'DEPTNO' is not being grouped
-#!error
-#select distinct gender, deptno, sum(deptno) as s from emp group by gender;
-#Expression 'DEPTNO' is not being grouped
-#!error
+
+select distinct gender, deptno from emp group by gender;
+Expression 'DEPTNO' is not being grouped
+!error
+
+select distinct gender, deptno from emp group by gender, ename;
+Expression 'DEPTNO' is not being grouped
+!error
+
+select distinct gender, deptno, sum(deptno) as s from emp group by gender;
+Expression 'DEPTNO' is not being grouped
+!error
!use scott
http://git-wip-us.apache.org/repos/asf/incubator-calcite/blob/88599ef5/core/src/test/resources/sql/subquery.oq
----------------------------------------------------------------------
diff --git a/core/src/test/resources/sql/subquery.oq b/core/src/test/resources/sql/subquery.oq
index 72349a6..9db95d3 100644
--- a/core/src/test/resources/sql/subquery.oq
+++ b/core/src/test/resources/sql/subquery.oq
@@ -131,7 +131,7 @@ select deptno, deptno not in (select deptno from emp where deptno is null) from
# RHS has only NOT NULL keys
select * from dept where deptno not in (select deptno from emp where deptno is not null);
- DEPTNO | DNAME
+ DEPTNO | DNAME
--------+-------------
40 | Empty
(1 row)
@@ -161,7 +161,7 @@ select deptno, deptno not in (select deptno from emp where deptno is not null) f
# RHS has no rows
# Even 'NULL NOT IN ...' is TRUE.
select * from dept where deptno not in (select deptno from emp where false);
- DEPTNO | DNAME
+ DEPTNO | DNAME
--------+-------------
10 | Sales
20 | Marketing
@@ -195,7 +195,7 @@ select deptno, deptno not in (select deptno from emp where false) from dept;
select * from dept
where deptno in (select deptno from emp where gender = 'F')
or deptno in (select deptno from emp where gender = 'M');
- DEPTNO | DNAME
+ DEPTNO | DNAME
--------+-------------
30 | Engineering
10 | Sales
@@ -208,7 +208,7 @@ or deptno in (select deptno from emp where gender = 'M');
select * from dept
where deptno in (select deptno from emp where gender = 'F')
or exists (select 99, 101 from emp where gender = 'X');
- DEPTNO | DNAME
+ DEPTNO | DNAME
--------+-------------
30 | Engineering
10 | Sales
http://git-wip-us.apache.org/repos/asf/incubator-calcite/blob/88599ef5/pom.xml
----------------------------------------------------------------------
diff --git a/pom.xml b/pom.xml
index 37efe84..1572a57 100644
--- a/pom.xml
+++ b/pom.xml
@@ -200,7 +200,7 @@ limitations under the License.
<dependency>
<groupId>net.hydromatic</groupId>
<artifactId>quidem</artifactId>
- <version>0.3</version>
+ <version>0.4</version>
</dependency>
<dependency>
<groupId>net.hydromatic</groupId>