You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Dmitry Lychagin (Code Review)" <do...@asterixdb.incubator.apache.org> on 2018/01/16 20:48:10 UTC
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Dmitry Lychagin has uploaded a new change for review.
https://asterix-gerrit.ics.uci.edu/2288
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
[ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
- user model changes: yes
- storage format changes: no
- interface changes: no
Details:
- Column aliases defined by SELECT clause should not be referenceable
from other clauses because aliases are not variables
Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
---
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-10/q2-10.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-11/q2-11.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-12/q2-12.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-4/q2-4.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-5/q2-5.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-6/q2-6.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-7/q2-7.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-8/q2-8.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-9/q2-9.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.4.deferred.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.6.async.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at06/at06.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-02/policy-02.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-03/policy-03.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-04/policy-04.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-05/policy-05.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/decorrelate_with_unique_id/decorrelate_with_unique_id.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/gby_inline/gby_inline.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/not_in/not_in.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/query-ASTERIXDB-1329.24.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.24.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q03/q03.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q19/q19.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24a/q24a.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24b/q24b.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q43/q43.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q52/q52.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q55/q55.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q90/q90.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q98/q98.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate/nest_aggregate.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q03_shipping_priority_nt/q03_shipping_priority_nt.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q05_local_supplier_volume/q05_local_supplier_volume.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item/q10_returned_item.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item_int64/q10_returned_item_int64.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q13_customer_distribution/q13_customer_distribution.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/query-issue786/query-issue786.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/nest_aggregate/nest_aggregate.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q03_shipping_priority_nt/q03_shipping_priority_nt.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q05_local_supplier_volume/q05_local_supplier_volume.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item/q10_returned_item.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item_int64/q10_returned_item_int64.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q13_customer_distribution/q13_customer_distribution.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue786/query-issue786.3.query.sqlpp
M asterixdb/asterix-app/src/test/resources/runtimets/results/explain/explain_field_access/explain_field_access.1.adm
M asterixdb/asterix-app/src/test/resources/runtimets/results/explain/explain_field_access_closed/explain_field_access_closed.1.adm
M asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
M asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/SqlppFunctionBodyRewriter.java
M asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/SqlppQueryRewriter.java
D asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/visitor/InlineColumnAliasVisitor.java
56 files changed, 146 insertions(+), 278 deletions(-)
git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/88/2288/1
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-10/q2-10.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-10/q2-10.3.query.sqlpp
index 119f28b..4005e84 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-10/q2-10.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-10/q2-10.3.query.sqlpp
@@ -23,7 +23,7 @@
// Tests references to a WITH binding variable in nested GROUP BY.
WITH t AS 1
-SELECT sponsor.sig_id, COUNT(2 * t) total_count,
+SELECT sponsor.sig_id, total_count,
(
SELECT e.sponsor.chapter_name, COUNT(2 * t) AS escount
FROM es AS e
@@ -32,6 +32,7 @@
FROM Event,
Event.sponsoring_sigs AS sponsor
GROUP BY sponsor.sig_id GROUP AS es
+LET total_count = COUNT(2 * t)
ORDER BY total_count DESC
LIMIT 5
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-11/q2-11.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-11/q2-11.3.query.sqlpp
index 0b90993..656cfba 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-11/q2-11.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-11/q2-11.3.query.sqlpp
@@ -26,7 +26,7 @@
FROM [1, 2, 3] v
)[0]
-SELECT sponsor.sig_id, COUNT(2 * t) total_count,
+SELECT sponsor.sig_id, total_count,
(
SELECT e.sponsor.chapter_name, COUNT(2 * t) AS escount
FROM es AS e
@@ -35,6 +35,7 @@
FROM Event,
Event.sponsoring_sigs AS sponsor
GROUP BY sponsor.sig_id GROUP AS es
+LET total_count = COUNT(2 * t)
ORDER BY total_count DESC
LIMIT 5
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-12/q2-12.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-12/q2-12.3.query.sqlpp
index 5210ced..c2fd943 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-12/q2-12.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-12/q2-12.3.query.sqlpp
@@ -26,7 +26,7 @@
FROM [1, 2, 3] v
)[0]
-SELECT sponsor.sig_id, COUNT(2 * t) total_count,
+SELECT sponsor.sig_id, total_count,
(
SELECT sponsor.sig_id, COUNT(e)
FROM es AS e
@@ -34,6 +34,7 @@
FROM Event,
Event.sponsoring_sigs AS sponsor
GROUP BY sponsor.sig_id GROUP AS es
+LET total_count = COUNT(2 * t)
ORDER BY total_count DESC
LIMIT 5
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-4/q2-4.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-4/q2-4.3.query.sqlpp
index 7aa1ca9..87043f1 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-4/q2-4.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-4/q2-4.3.query.sqlpp
@@ -25,7 +25,7 @@
USE test;
-SELECT sig_id, COUNT(1) total_count,
+SELECT sig_id, total_count,
(
SELECT chapter_name, COUNT(e) AS escount
FROM es AS e
@@ -34,6 +34,7 @@
FROM Event,
Event.sponsoring_sigs AS sponsor
GROUP BY sponsor.sig_id GROUP AS es
+LET total_count = COUNT(1)
ORDER BY total_count DESC
LIMIT 5
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-5/q2-5.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-5/q2-5.3.query.sqlpp
index 7eaaf0f..f5a6eb7 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-5/q2-5.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-5/q2-5.3.query.sqlpp
@@ -25,7 +25,7 @@
USE test;
-SELECT sig_id, COUNT(1) total_count,
+SELECT sig_id, total_count,
(
SELECT chapter_name, COUNT(e) AS escount
FROM es AS e
@@ -34,6 +34,7 @@
FROM Event,
Event.sponsoring_sigs AS sponsor
GROUP BY sponsor.sig_id GROUP AS es
+LET total_count = COUNT(1)
ORDER BY total_count DESC
LIMIT 5
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-6/q2-6.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-6/q2-6.3.query.sqlpp
index 1c7e44a..7122193 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-6/q2-6.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-6/q2-6.3.query.sqlpp
@@ -21,7 +21,7 @@
USE test;
-SELECT sponsor.sig_id, COUNT(1) total_count,
+SELECT sponsor.sig_id, total_count,
(
SELECT e.sponsor.chapter_name, COUNT(e) AS escount
FROM es AS e
@@ -30,6 +30,7 @@
FROM Event,
Event.sponsoring_sigs AS sponsor
GROUP BY sponsor.sig_id GROUP AS es
+LET total_count = COUNT(1)
ORDER BY total_count DESC
LIMIT 5
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-7/q2-7.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-7/q2-7.3.query.sqlpp
index 92039e0..841268d 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-7/q2-7.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-7/q2-7.3.query.sqlpp
@@ -21,7 +21,7 @@
USE test;
// Tests nested SELECT * for nested GROUP BY.
-SELECT sponsor.sig_id, COUNT(1) total_count,
+SELECT sponsor.sig_id, total_count,
(
SELECT *
FROM es AS e
@@ -30,6 +30,7 @@
FROM Event,
Event.sponsoring_sigs AS sponsor
GROUP BY sponsor.sig_id GROUP AS es
+LET total_count = COUNT(1)
ORDER BY total_count DESC
LIMIT 5
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-8/q2-8.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-8/q2-8.3.query.sqlpp
index 28a3317..3d3a4f0 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-8/q2-8.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-8/q2-8.3.query.sqlpp
@@ -21,7 +21,7 @@
USE test;
// Tests the case that a GROUP BY key expression appears in an aggregation function.
-SELECT sponsor.sig_id, COUNT(sponsor.sig_id) total_count,
+SELECT sponsor.sig_id, total_count,
(
SELECT e.sponsor.chapter_name, COUNT(e.sponsor.chapter_name) AS escount
FROM es AS e
@@ -30,6 +30,7 @@
FROM Event,
Event.sponsoring_sigs AS sponsor
GROUP BY sponsor.sig_id GROUP AS es
+LET total_count = COUNT(sponsor.sig_id)
ORDER BY total_count DESC
LIMIT 5
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-9/q2-9.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-9/q2-9.3.query.sqlpp
index 7044711..b0acf97 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-9/q2-9.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-9/q2-9.3.query.sqlpp
@@ -21,7 +21,7 @@
USE test;
// Tests outer scope variable references in nested GROUP BY.
-SELECT sponsor.sig_id, COUNT(1) total_count,
+SELECT sponsor.sig_id, total_count,
(
SELECT sponsor.sig_id, e.sponsor.chapter_name, COUNT(e.sponsor.chapter_name) AS escount
FROM es AS e
@@ -30,6 +30,7 @@
FROM Event,
Event.sponsoring_sigs AS sponsor
GROUP BY sponsor.sig_id GROUP AS es
+LET total_count = COUNT(1)
ORDER BY total_count DESC
LIMIT 5
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.3.query.sqlpp
index cb47163..2f2a04e 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.3.query.sqlpp
@@ -33,4 +33,4 @@
) as gen0,
gen0.i as j at p
where p < 4
-order by partkey, shipdate;
+order by gen0.partkey, j.l_shipdate;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.4.deferred.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.4.deferred.sqlpp
index 12c03c0..d1e2913 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.4.deferred.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.4.deferred.sqlpp
@@ -34,4 +34,4 @@
) as gen0,
gen0.i as j at p
where p < 4
-order by partkey, shipdate;
+order by gen0.partkey, j.shipdate;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.6.async.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.6.async.sqlpp
index 7ba0e96..751c5b3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.6.async.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at00/at00.6.async.sqlpp
@@ -34,4 +34,4 @@
) as gen0,
gen0.i as j at p
where p < 4
-order by partkey, shipdate;
+order by gen0.partkey, j.shipdate;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at06/at06.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at06/at06.3.query.sqlpp
index 1f4c1c1..c036cee 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at06/at06.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/flwor/at06/at06.3.query.sqlpp
@@ -37,5 +37,5 @@
order by ii.l_shipdate, ii.l_orderkey
) as j at p
where (p < 4)
-order by partkey, shipdate, orderkey
+order by gen0.partkey, j.l_shipdate, j.l_orderkey
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-02/policy-02.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-02/policy-02.3.query.sqlpp
index 5a524a2..e25ad1f 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-02/policy-02.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-02/policy-02.3.query.sqlpp
@@ -21,16 +21,16 @@
FROM policies p
GROUP BY state GROUP AS g
-SELECT state,
- (
- FROM g
- SELECT VALUE SUM(
- (
- FROM g.p.accidents a
- WHERE a.year = "2016"
- SELECT VALUE COUNT(*)
- )[0]
- )
- )[0] / (COUNT(*) * 1.0 ) AS risk
+LET risk = (
+ FROM g
+ SELECT VALUE SUM(
+ (
+ FROM g.p.accidents a
+ WHERE a.year = "2016"
+ SELECT VALUE COUNT(*)
+ )[0]
+ )
+)[0] / (COUNT(*) * 1.0 )
+SELECT state, risk
ORDER BY risk DESC
LIMIT 5;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-03/policy-03.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-03/policy-03.3.query.sqlpp
index 4d12f37..f812385 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-03/policy-03.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-03/policy-03.3.query.sqlpp
@@ -21,17 +21,16 @@
FROM policies p
GROUP BY state GROUP AS g
-SELECT state,
- COUNT(*) num_policies,
- (
- FROM g
- SELECT VALUE SUM(
- (
- FROM g.p.accidents a
- WHERE a.year = "2016"
- SELECT VALUE COUNT(*)
- )[0]
- )
- )[0] / (COUNT(*) * 1.0 ) AS risk
+LET risk = (
+ FROM g
+ SELECT VALUE SUM(
+ (
+ FROM g.p.accidents a
+ WHERE a.year = "2016"
+ SELECT VALUE COUNT(*)
+ )[0]
+ )
+)[0] / (COUNT(*) * 1.0 )
+SELECT state, COUNT(*) num_policies, risk
ORDER BY risk DESC
LIMIT 5;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-04/policy-04.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-04/policy-04.3.query.sqlpp
index e2e3f23..ed35974 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-04/policy-04.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-04/policy-04.3.query.sqlpp
@@ -21,18 +21,20 @@
FROM policies p
GROUP BY state GROUP AS g
-SELECT state,
- COUNT(*) num_policies,
- (
- FROM g
- SELECT VALUE SUM(
+
+LET risk_2016 =
+ (
+ FROM g
+ SELECT VALUE SUM(
(
FROM g.p.accidents a
WHERE a.year = "2016"
SELECT VALUE COUNT(*)
)[0]
)
- )[0] / (COUNT(*) * 1.0 ) AS risk_2016,
+ )[0] / (COUNT(*) * 1.0 ),
+
+ risk_2015 =
(
FROM g
SELECT VALUE SUM(
@@ -42,6 +44,8 @@
SELECT VALUE COUNT(*)
)[0]
)
- )[0] / (COUNT(*) * 1.0 ) AS risk_2015
+ )[0] / (COUNT(*) * 1.0 )
+
+SELECT state, COUNT(*) num_policies, risk_2016, risk_2015
ORDER BY risk_2016 DESC
LIMIT 5;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-05/policy-05.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-05/policy-05.3.query.sqlpp
index 9a03c50..a70b7bd 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-05/policy-05.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/policy-05/policy-05.3.query.sqlpp
@@ -21,7 +21,7 @@
FROM policies p
GROUP BY state GROUP AS g
-SELECT state,
+LET risk =
(
FROM g
SELECT VALUE SUM(
@@ -31,6 +31,7 @@
SELECT COUNT(*)
)[0]
)
- )[0] / (COUNT(*) * 1.0 ) AS risk
+ )[0] / (COUNT(*) * 1.0 )
+SELECT state, risk
ORDER BY risk DESC
LIMIT 5;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/decorrelate_with_unique_id/decorrelate_with_unique_id.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/decorrelate_with_unique_id/decorrelate_with_unique_id.3.query.sqlpp
index b78ab6f..99984c5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/decorrelate_with_unique_id/decorrelate_with_unique_id.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/decorrelate_with_unique_id/decorrelate_with_unique_id.3.query.sqlpp
@@ -29,4 +29,4 @@
SELECT ELEMENT o
)
SELECT c.c_custkey customer_name, orders orders
-ORDER BY customer_name;
+ORDER BY c.c_custkey;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/gby_inline/gby_inline.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/gby_inline/gby_inline.3.query.sqlpp
index 955aa4c..41e8cb3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/gby_inline/gby_inline.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/gby_inline/gby_inline.3.query.sqlpp
@@ -30,4 +30,4 @@
SELECT ELEMENT o
)
SELECT ccustkey customer_name, orders orders
-ORDER BY customer_name;
+ORDER BY ccustkey;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/not_in/not_in.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/not_in/not_in.3.query.sqlpp
index 36819df..02203d9 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/not_in/not_in.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/not_in/not_in.3.query.sqlpp
@@ -25,4 +25,4 @@
SELECT VALUE o.o_custkey
FROM Orders o
) AND c.c_nationkey = 5
-ORDER BY customer_name;
+ORDER BY c.c_custkey;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/query-ASTERIXDB-1329.24.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/query-ASTERIXDB-1329.24.query.sqlpp
index 66e99ab..a0c70ef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/query-ASTERIXDB-1329.24.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/query-ASTERIXDB-1329.24.query.sqlpp
@@ -23,11 +23,12 @@
SELECT user.name AS uname,
user.alias AS alias,
- substring(message.message, 30) AS msg
+ msg
FROM FacebookMessages AS message,
FacebookUsers AS user
+LET msg = substring(message.message, 30)
WHERE message.`author-id` = user.id and
message.`in-response-to` >= 1 and
message.`in-response-to` < 11
-ORDER BY uname, alias, msg;
+ORDER BY user.uname, user.alias, msg;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.24.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.24.query.sqlpp
index 7f84895..a7425fb 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.24.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.24.query.sqlpp
@@ -21,11 +21,12 @@
SELECT user.name AS uname,
user.alias AS alias,
- substring(message.message, 30) AS msg
+ msg
FROM FacebookMessages AS message,
FacebookUsers AS user
+LET msg = substring(message.message, 30)
WHERE message.`author-id` = user.id and
message.`in-response-to` >= 1 and
message.`in-response-to` < 11
-ORDER BY uname, alias, msg;
+ORDER BY user.uname, user.alias, msg;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q03/q03.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q03/q03.3.query.sqlpp
index 612a8c5..e2ac29f 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q03/q03.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q03/q03.3.query.sqlpp
@@ -23,7 +23,7 @@
SELECT d_year
,item.i_brand_id brand_id
,item.i_brand brand
- ,sum(store_sales.ss_ext_sales_price) sum_agg
+ ,sum_agg
FROM date_dim dt
,store_sales
,item
@@ -34,7 +34,8 @@
GROUP BY dt.d_year
,item.i_brand
,item.i_brand_id
+LET sum_agg = sum(store_sales.ss_ext_sales_price)
ORDER BY d_year
,sum_agg desc
- ,brand_id
+ ,i_brand_id
LIMIT 100;
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q19/q19.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q19/q19.3.query.sqlpp
index 5e3b339..d63df36 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q19/q19.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q19/q19.3.query.sqlpp
@@ -21,7 +21,7 @@
SELECT i_brand_id brand_id, i_brand brand, i_manufact_id, i_manufact,
- SUM(ss.ss_ext_sales_price) ext_price
+ ext_price
FROM date_dim d, store_sales ss, item i, customer c, customer_address ca, store s
WHERE d.d_date_sk = ss.ss_sold_date_sk
AND ss.ss_item_sk = i.i_item_sk
@@ -36,6 +36,7 @@
,i.i_brand_id
,i.i_manufact_id
,i.i_manufact
+LET ext_price = SUM(ss.ss_ext_sales_price)
ORDER BY ext_price desc
,i_brand
,i_brand_id
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24a/q24a.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24a/q24a.3.query.sqlpp
index c24c10e..95e4e8c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24a/q24a.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24a/q24a.3.query.sqlpp
@@ -59,12 +59,13 @@
SELECT c_last_name
,c_first_name
,s_store_name
- ,SUM(netpaid) paid
+ ,paid
FROM ssales
WHERE i_color = 'orchid'
GROUP BY c_last_name
,c_first_name
,s_store_name
GROUP AS g
+LET paid = SUM(netpaid)
HAVING paid > (SELECT value 0.05*avg(g.ssales.netpaid) FROM g)[0]
;
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24b/q24b.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24b/q24b.3.query.sqlpp
index 86ffa7b..3a1590d 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24b/q24b.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24b/q24b.3.query.sqlpp
@@ -59,12 +59,13 @@
SELECT c_last_name
,c_first_name
,s_store_name
- ,SUM(netpaid) paid
+ ,paid
FROM ssales
WHERE i_color = 'chiffon'
GROUP BY c_last_name
,c_first_name
,s_store_name
GROUP AS g
+LET paid = SUM(netpaid)
HAVING paid > (SELECT value 0.05*avg(g.ssales.netpaid) FROM g)[0]
;
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q43/q43.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q43/q43.3.query.sqlpp
index 4db7758..d102364 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q43/q43.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q43/q43.3.query.sqlpp
@@ -21,18 +21,19 @@
USE tpcds;
SELECT s_store_name, s_store_id,
- SUM(CASE WHEN (d.d_day_name='Sunday') THEN ss.ss_sales_price ELSE null END) sun_sales,
- SUM(CASE WHEN (d.d_day_name='Monday') THEN ss.ss_sales_price ELSE null END) mon_sales,
- SUM(CASE WHEN (d.d_day_name='Tuesday') THEN ss.ss_sales_price ELSE null END) tue_sales,
- SUM(CASE WHEN (d.d_day_name='Wednesday') THEN ss.ss_sales_price ELSE null END) wed_sales,
- SUM(CASE WHEN (d.d_day_name='Thursday') THEN ss.ss_sales_price ELSE null END) thu_sales,
- SUM(CASE WHEN (d.d_day_name='Friday') THEN ss.ss_sales_price ELSE null END) fri_sales,
- SUM(CASE WHEN (d.d_day_name='Saturday') THEN ss.ss_sales_price ELSE null END) sat_sales
+ sun_sales, mon_sales, tue_sales, wed_sales, thu_sales, fri_sales, sat_sales
FROM date_dim d, store_sales ss, store s
where d.d_date_sk = ss.ss_sold_date_sk and
s.s_store_sk = ss.ss_store_sk and
s.s_gmt_offset = -5 and
d.d_year = 1998
GROUP BY s.s_store_name, s.s_store_id
+ LET sun_sales = SUM(CASE WHEN (d.d_day_name='Sunday') THEN ss.ss_sales_price ELSE null END),
+ mon_sales = SUM(CASE WHEN (d.d_day_name='Monday') THEN ss.ss_sales_price ELSE null END),
+ tue_sales = SUM(CASE WHEN (d.d_day_name='Tuesday') THEN ss.ss_sales_price ELSE null END),
+ wed_sales = SUM(CASE WHEN (d.d_day_name='Wednesday') THEN ss.ss_sales_price ELSE null END),
+ thu_sales = SUM(CASE WHEN (d.d_day_name='Thursday') THEN ss.ss_sales_price ELSE null END),
+ fri_sales = SUM(CASE WHEN (d.d_day_name='Friday') THEN ss.ss_sales_price ELSE null END),
+ sat_sales = SUM(CASE WHEN (d.d_day_name='Saturday') THEN ss.ss_sales_price ELSE null END)
ORDER BY s_store_name, s_store_id,sun_sales,mon_sales,tue_sales,wed_sales,thu_sales,fri_sales,sat_sales
LIMIT 100;
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q52/q52.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q52/q52.3.query.sqlpp
index 4b27365..486ee61 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q52/q52.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q52/q52.3.query.sqlpp
@@ -23,7 +23,7 @@
SELECT dt.d_year
,item.i_brand_id brand_id
,item.i_brand brand
- ,SUM(store_sales.ss_ext_sales_price) ext_price
+ ,ext_price
FROM date_dim dt
,store_sales
,item
@@ -35,7 +35,8 @@
GROUP BY dt.d_year
,item.i_brand
,item.i_brand_id
+ LET ext_price = SUM(store_sales.ss_ext_sales_price)
ORDER BY d_year
,ext_price desc
- ,brand_id
+ ,i_brand_id
LIMIT 100 ;
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q55/q55.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q55/q55.3.query.sqlpp
index d30e267..cc8f822 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q55/q55.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q55/q55.3.query.sqlpp
@@ -21,7 +21,7 @@
USE tpcds;
SELECT i_brand_id brand_id, i_brand brand,
- SUM(ss.ss_ext_sales_price) ext_price
+ ext_price
FROM date_dim d, store_sales ss, item i
WHERE d.d_date_sk = ss.ss_sold_date_sk
AND ss.ss_item_sk = i.i_item_sk
@@ -29,5 +29,6 @@
AND d.d_moy=12
AND d.d_year=2001
GROUP BY i.i_brand, i.i_brand_id
+ LET ext_price = SUM(ss.ss_ext_sales_price)
ORDER BY ext_price desc, i_brand_id
LIMIT 100 ;
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q90/q90.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q90/q90.3.query.sqlpp
index 82c4097..2d17857 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q90/q90.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q90/q90.3.query.sqlpp
@@ -38,6 +38,4 @@
and time_dim.t_hour <= 14+1
and household_demographics.hd_dep_count = 8
and web_page.wp_char_count >= 5000
- and web_page.wp_char_count <= 5200 limit 10)))) am_pm_ratio
- order by am_pm_ratio
- limit 100;
\ No newline at end of file
+ and web_page.wp_char_count <= 5200 limit 10)))) am_pm_ratio
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q98/q98.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q98/q98.3.query.sqlpp
index 17038de..5758245 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q98/q98.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q98/q98.3.query.sqlpp
@@ -26,7 +26,7 @@
currpricetable.i_class,
currpricetable.i_current_price,
currpricetable.itemrevenue,
- (currpricetable.itemrevenue * 100 / revrattable.revrat) revenueratio
+ revenueratio
FROM
(SELECT i_item_desc,
i_category,
@@ -67,6 +67,7 @@
AND currpricetable.i_class = revrattable.i_class
AND currpricetable.i_item_desc = revrattable.i_item_desc
AND currpricetable.i_category = revrattable.i_category
+LET revenueratio = (currpricetable.itemrevenue * 100 / revrattable.revrat)
ORDER BY
currpricetable.i_category,
currpricetable.i_class,
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.3.query.sqlpp
index c13f668..d66eef8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.3.query.sqlpp
@@ -19,7 +19,7 @@
use tpcds;
-select a.ca_state state, count(a) cnt
+select a.ca_state state, cnt
from customer_address a
,customer c
,store_sales s
@@ -30,6 +30,7 @@
and s.ss_sold_date_sk = d.d_date_sk
and s.ss_item_sk = i.i_item_sk
group by a.ca_state group as stategrp
+let cnt = count(a)
having coll_count((select value a from stategrp)) >= 10
order by cnt
limit 100;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate/nest_aggregate.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate/nest_aggregate.3.query.sqlpp
index ba3297f..1845780 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate/nest_aggregate.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate/nest_aggregate.3.query.sqlpp
@@ -34,7 +34,7 @@
Customer c
WHERE o.o_custkey = c.c_custkey AND c.c_nationkey = Nation.n_nationkey
GROUP BY o.o_orderdate AS orderdate
- ORDER BY sum_price
+ ORDER BY sum(o.o_totalprice)
LIMIT 3
) AS aggregates
FROM Nation,
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q03_shipping_priority_nt/q03_shipping_priority_nt.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q03_shipping_priority_nt/q03_shipping_priority_nt.3.query.sqlpp
index f5dcb4a..802cf55 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q03_shipping_priority_nt/q03_shipping_priority_nt.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q03_shipping_priority_nt/q03_shipping_priority_nt.3.query.sqlpp
@@ -30,6 +30,6 @@
where c.c_mktsegment = 'BUILDING' AND c.c_custkey = o.o_custkey AND l.l_orderkey = o.o_orderkey AND o.o_orderdate < '1995-03-15' AND l.l_shipdate > '1995-03-15'
/* +hash */
GROUP BY l.l_orderkey, o.o_orderdate, o.o_shippriority
-ORDER BY revenue DESC,o_orderdate
+ORDER BY sum(l.l_extendedprice * (1 - l.l_discount)) DESC,o_orderdate
LIMIT 10
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q05_local_supplier_volume/q05_local_supplier_volume.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q05_local_supplier_volume/q05_local_supplier_volume.3.query.sqlpp
index 921810b..a575ca9 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q05_local_supplier_volume/q05_local_supplier_volume.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q05_local_supplier_volume/q05_local_supplier_volume.3.query.sqlpp
@@ -39,4 +39,4 @@
) o1
ON c.c_nationkey = o1.s_nationkey AND c.c_custkey = o1.o_custkey
GROUP BY o1.n_name
-ORDER BY revenue DESC;
+ORDER BY sum(o1.l_extendedprice * (1 - o1.l_discount)) DESC;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item/q10_returned_item.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item/q10_returned_item.3.query.sqlpp
index f2f15ae..05cb123 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item/q10_returned_item.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item/q10_returned_item.3.query.sqlpp
@@ -37,7 +37,7 @@
WHERE l.l_orderkey = ocn.o_orderkey and l.l_returnflag = 'R'
) AS locn
GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment
-ORDER BY revenue DESC
+ORDER BY sum(l_extendedprice * (1 - l_discount)) DESC
LIMIT 20
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item_int64/q10_returned_item_int64.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item_int64/q10_returned_item_int64.3.query.sqlpp
index 846954c..16780b0 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item_int64/q10_returned_item_int64.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item_int64/q10_returned_item_int64.3.query.sqlpp
@@ -38,7 +38,7 @@
WHERE l.l_orderkey = ocn.o_orderkey and l.l_returnflag = 'R'
) AS locn
GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment
-ORDER BY revenue DESC
+ORDER BY sum(l_extendedprice * (1 - l_discount)) DESC
LIMIT 20
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q13_customer_distribution/q13_customer_distribution.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q13_customer_distribution/q13_customer_distribution.3.query.sqlpp
index f8211c9..1656d75 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q13_customer_distribution/q13_customer_distribution.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q13_customer_distribution/q13_customer_distribution.3.query.sqlpp
@@ -36,5 +36,5 @@
GROUP BY c_custkey
) gco
GROUP BY c_count
-ORDER BY custdist DESC,c_count DESC
+ORDER BY count(gco) DESC,c_count DESC
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.query.sqlpp
index f253f86..38429ab 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.query.sqlpp
@@ -43,5 +43,5 @@
GROUP BY p_brand, p_type, p_size, ps_suppkey
) AS t2
GROUP BY p_brand, p_type, p_size
-ORDER BY supplier_cnt DESC, p_brand, p_type, p_size
+ORDER BY count(ps_suppkey) DESC, p_brand, p_type, p_size
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp
index 13ea032..4646369 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp
@@ -66,5 +66,5 @@
JOIN tmp2 AS t2 ON t2.count_suppkey >= 0 AND t3.l_orderkey = t2.l_orderkey
) AS t4
GROUP BY s_name
-ORDER BY numwait DESC, s_name
+ORDER BY count(t4) DESC, s_name
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/query-issue786/query-issue786.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/query-issue786/query-issue786.3.query.sqlpp
index 5eda643..097d2ac 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/query-issue786/query-issue786.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/query-issue786/query-issue786.3.query.sqlpp
@@ -34,7 +34,7 @@
Customer c
WHERE o.o_custkey = c.c_custkey AND c.c_nationkey = nation.n_nationkey
GROUP BY o.o_orderdate as orderdate
- ORDER BY sum_price DESC
+ ORDER BY sum(o.o_totalprice) DESC
LIMIT 3
) AS aggregates
FROM Nation AS nation,
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/nest_aggregate/nest_aggregate.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/nest_aggregate/nest_aggregate.3.query.sqlpp
index a4396d7..57ea0e5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/nest_aggregate/nest_aggregate.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/nest_aggregate/nest_aggregate.3.query.sqlpp
@@ -29,11 +29,12 @@
SELECT nation.n_nationkey AS nation_key,
nation.n_name AS name,
(
- SELECT orderdate AS order_date, sum(orders.o_totalprice) AS sum_price
+ SELECT orderdate AS order_date, sum_price
FROM Orders AS orders,
Customer AS customer
WHERE orders.o_custkey = customer.c_custkey AND customer.c_nationkey = nation.n_nationkey
GROUP BY orders.o_orderdate AS orderdate
+ LET sum_price = sum(orders.o_totalprice)
ORDER BY sum_price
LIMIT 3
) AS aggregates
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q03_shipping_priority_nt/q03_shipping_priority_nt.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q03_shipping_priority_nt/q03_shipping_priority_nt.3.query.sqlpp
index 5e65cb7..2085caa 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q03_shipping_priority_nt/q03_shipping_priority_nt.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q03_shipping_priority_nt/q03_shipping_priority_nt.3.query.sqlpp
@@ -32,6 +32,6 @@
GROUP BY l.l_orderkey AS l_orderkey,
o.o_orderdate AS o_orderdate,
o.o_shippriority AS o_shippriority
-ORDER BY revenue DESC,o_orderdate
+ORDER BY sum(l.l_extendedprice * (1 - l.l_discount)) DESC,o_orderdate
LIMIT 10
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q05_local_supplier_volume/q05_local_supplier_volume.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q05_local_supplier_volume/q05_local_supplier_volume.3.query.sqlpp
index 7f84ccb..117528f 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q05_local_supplier_volume/q05_local_supplier_volume.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q05_local_supplier_volume/q05_local_supplier_volume.3.query.sqlpp
@@ -50,4 +50,4 @@
) o1
ON c.c_nationkey = o1.s_nationkey AND c.c_custkey = o1.o_custkey
GROUP BY o1.n_name AS n_name
-ORDER BY revenue DESC;
+ORDER BY sum(o1.l_extendedprice * (1 - o1.l_discount)) DESC;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item/q10_returned_item.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item/q10_returned_item.3.query.sqlpp
index 286a593..b3cffa7 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item/q10_returned_item.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item/q10_returned_item.3.query.sqlpp
@@ -63,7 +63,7 @@
locn.n_name AS n_name,
locn.c_address AS c_address,
locn.c_comment AS c_comment
-ORDER BY revenue DESC
+ORDER BY sum(locn.l_extendedprice * (1 - locn.l_discount)) DESC
LIMIT 20
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item_int64/q10_returned_item_int64.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item_int64/q10_returned_item_int64.3.query.sqlpp
index fd24025..4f660ed 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item_int64/q10_returned_item_int64.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item_int64/q10_returned_item_int64.3.query.sqlpp
@@ -64,7 +64,7 @@
locn.n_name AS n_name,
locn.c_address AS c_address,
locn.c_comment AS c_comment
-ORDER BY revenue DESC
+ORDER BY sum(locn.l_extendedprice * (1 - locn.l_discount)) DESC
LIMIT 20
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q13_customer_distribution/q13_customer_distribution.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q13_customer_distribution/q13_customer_distribution.3.query.sqlpp
index fb3e8e7..d9f5185 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q13_customer_distribution/q13_customer_distribution.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q13_customer_distribution/q13_customer_distribution.3.query.sqlpp
@@ -19,7 +19,7 @@
USE tpch;
-SELECT c_count AS c_count, count(gco) AS custdist
+SELECT c_count AS c_count, custdist
FROM (
SELECT c_custkey AS c_custkey, sum(co.o_orderkey_count) AS c_count
FROM (
@@ -36,5 +36,6 @@
GROUP BY co.c_custkey c_custkey
) gco
GROUP BY gco.c_count as c_count
+LET custdist = count(gco)
ORDER BY custdist desc,c_count DESC
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.query.sqlpp
index 18a4d43..bb7e289 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.query.sqlpp
@@ -43,5 +43,5 @@
GROUP BY t.p_brand as p_brand1,t.p_type as p_type1,t.p_size as p_size1,t.ps_suppkey as ps_suppkey1
) AS t2
GROUP BY t2.p_brand p_brand,t2.p_type p_type,t2.p_size p_size
-ORDER BY supplier_cnt DESC,p_brand,p_type,p_size
+ORDER BY count(t2.ps_suppkey) DESC,p_brand,p_type,p_size
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp
index c916481..22c3a66 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp
@@ -76,5 +76,5 @@
WHERE t2.count_suppkey >= 0 AND t3.l_orderkey = t2.l_orderkey
) AS t4
GROUP BY t4.s_name AS s_name
-ORDER BY numwait DESC,s_name
+ORDER BY count(t4) DESC,s_name
;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue786/query-issue786.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue786/query-issue786.3.query.sqlpp
index 65c1219..239ec9b 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue786/query-issue786.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue786/query-issue786.3.query.sqlpp
@@ -34,7 +34,7 @@
Customer AS customer
WHERE orders.o_custkey = customer.c_custkey AND customer.c_nationkey = nation.n_nationkey
GROUP BY orders.o_orderdate as orderdate
- ORDER BY sum_price DESC
+ ORDER BY sum(orders.o_totalprice) DESC
LIMIT 3
) AS aggregates
FROM Nation AS nation,
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/explain/explain_field_access/explain_field_access.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/explain/explain_field_access/explain_field_access.1.adm
index 5f25e64..d5b4917 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results/explain/explain_field_access/explain_field_access.1.adm
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/explain/explain_field_access/explain_field_access.1.adm
@@ -1,44 +1,44 @@
-distribute result [$$36]
+distribute result [$$35]
-- DISTRIBUTE_RESULT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
- project ([$$36])
+ project ([$$35])
-- STREAM_PROJECT |PARTITIONED|
- assign [$$36] <- [{"deptId": $#1, "star_cost": $$39}]
+ assign [$$35] <- [{"deptId": $#1, "star_cost": $$38}]
-- ASSIGN |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
- group by ([$#1 := $$44]) decor ([]) {
- aggregate [$$39] <- [agg-sql-sum($$43)]
+ group by ([$#1 := $$43]) decor ([]) {
+ aggregate [$$38] <- [agg-sql-sum($$42)]
-- AGGREGATE |LOCAL|
nested tuple source
-- NESTED_TUPLE_SOURCE |LOCAL|
}
- -- SORT_GROUP_BY[$$44] |PARTITIONED|
+ -- SORT_GROUP_BY[$$43] |PARTITIONED|
exchange
- -- HASH_PARTITION_EXCHANGE [$$44] |PARTITIONED|
- group by ([$$44 := $$37]) decor ([]) {
- aggregate [$$43] <- [agg-local-sql-sum($$34)]
+ -- HASH_PARTITION_EXCHANGE [$$43] |PARTITIONED|
+ group by ([$$43 := $$36]) decor ([]) {
+ aggregate [$$42] <- [agg-local-sql-sum($$33)]
-- AGGREGATE |LOCAL|
nested tuple source
-- NESTED_TUPLE_SOURCE |LOCAL|
}
- -- SORT_GROUP_BY[$$37] |PARTITIONED|
+ -- SORT_GROUP_BY[$$36] |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
- project ([$$34, $$37])
+ project ([$$33, $$36])
-- STREAM_PROJECT |PARTITIONED|
- assign [$$37] <- [substring($$41.getField("department_id"), 1)]
+ assign [$$36] <- [substring($$40.getField("department_id"), 1)]
-- ASSIGN |PARTITIONED|
- project ([$$34, $$41])
+ project ([$$33, $$40])
-- STREAM_PROJECT |PARTITIONED|
- assign [$$34, $$41] <- [$$e.getField("salary"), $$e.getField("dept")]
+ assign [$$33, $$40] <- [$$e.getField("salary"), $$e.getField("dept")]
-- ASSIGN |PARTITIONED|
project ([$$e])
-- STREAM_PROJECT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
- data-scan []<-[$$38, $$e] <- gby.Employee
+ data-scan []<-[$$37, $$e] <- gby.Employee
-- DATASOURCE_SCAN |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/explain/explain_field_access_closed/explain_field_access_closed.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/explain/explain_field_access_closed/explain_field_access_closed.1.adm
index 92df490..86d2892 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results/explain/explain_field_access_closed/explain_field_access_closed.1.adm
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/explain/explain_field_access_closed/explain_field_access_closed.1.adm
@@ -1,40 +1,40 @@
-distribute result [$$35]
+distribute result [$$34]
-- DISTRIBUTE_RESULT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
- project ([$$35])
+ project ([$$34])
-- STREAM_PROJECT |PARTITIONED|
- assign [$$35] <- [{"deptId": $#1, "star_cost": $$38}]
+ assign [$$34] <- [{"deptId": $#1, "star_cost": $$37}]
-- ASSIGN |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
- group by ([$#1 := $$42]) decor ([]) {
- aggregate [$$38] <- [agg-sql-sum($$41)]
+ group by ([$#1 := $$41]) decor ([]) {
+ aggregate [$$37] <- [agg-sql-sum($$40)]
-- AGGREGATE |LOCAL|
nested tuple source
-- NESTED_TUPLE_SOURCE |LOCAL|
}
- -- SORT_GROUP_BY[$$42] |PARTITIONED|
+ -- SORT_GROUP_BY[$$41] |PARTITIONED|
exchange
- -- HASH_PARTITION_EXCHANGE [$$42] |PARTITIONED|
- group by ([$$42 := $$36]) decor ([]) {
- aggregate [$$41] <- [agg-local-sql-sum($$33)]
+ -- HASH_PARTITION_EXCHANGE [$$41] |PARTITIONED|
+ group by ([$$41 := $$35]) decor ([]) {
+ aggregate [$$40] <- [agg-local-sql-sum($$32)]
-- AGGREGATE |LOCAL|
nested tuple source
-- NESTED_TUPLE_SOURCE |LOCAL|
}
- -- SORT_GROUP_BY[$$36] |PARTITIONED|
+ -- SORT_GROUP_BY[$$35] |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
- project ([$$33, $$36])
+ project ([$$32, $$35])
-- STREAM_PROJECT |PARTITIONED|
- assign [$$36, $$33] <- [substring($$e.getField(1), 1), $$e.getField(2)]
+ assign [$$35, $$32] <- [substring($$e.getField(1), 1), $$e.getField(2)]
-- ASSIGN |PARTITIONED|
project ([$$e])
-- STREAM_PROJECT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
- data-scan []<-[$$37, $$e] <- gby.Employee
+ data-scan []<-[$$36, $$e] <- gby.Employee
-- DATASOURCE_SCAN |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
index 14784d6..506d265 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
@@ -1563,6 +1563,7 @@
<test-case FilePath="dapd">
<compilation-unit name="q2-3">
<output-dir compare="Text">q2</output-dir>
+ <expected-error>Cannot resolve ambiguous alias reference for undefined identifier sig_id</expected-error>
</compilation-unit>
</test-case>
<test-case FilePath="dapd">
@@ -2901,11 +2902,13 @@
<test-case FilePath="group-by">
<compilation-unit name="sugar-02">
<output-dir compare="Text">core-02</output-dir>
+ <expected-error>Cannot resolve ambiguous alias reference for undefined identifier deptId</expected-error>
</compilation-unit>
</test-case>
<test-case FilePath="group-by">
<compilation-unit name="sugar-02-2">
<output-dir compare="Text">core-02</output-dir>
+ <expected-error>Cannot resolve ambiguous alias reference for undefined identifier deptId</expected-error>
</compilation-unit>
</test-case>
<test-case FilePath="group-by">
@@ -2926,6 +2929,7 @@
<test-case FilePath="group-by">
<compilation-unit name="sugar-04-2">
<output-dir compare="Text">core-04</output-dir>
+ <expected-error>Cannot resolve ambiguous alias reference for undefined identifier deptId</expected-error>
</compilation-unit>
</test-case>
<test-case FilePath="group-by">
diff --git a/asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/SqlppFunctionBodyRewriter.java b/asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/SqlppFunctionBodyRewriter.java
index cd57396..0a18688 100644
--- a/asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/SqlppFunctionBodyRewriter.java
+++ b/asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/SqlppFunctionBodyRewriter.java
@@ -35,9 +35,6 @@
// Sets up parameters.
setup(declaredFunctions, topStatement, metadataProvider, context);
- // Inlines column aliases.
- inlineColumnAlias();
-
// Generates column names.
generateColumnNames();
diff --git a/asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/SqlppQueryRewriter.java b/asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/SqlppQueryRewriter.java
index befa5ab..c83d74e 100644
--- a/asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/SqlppQueryRewriter.java
+++ b/asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/SqlppQueryRewriter.java
@@ -51,7 +51,6 @@
import org.apache.asterix.lang.sqlpp.parser.FunctionParser;
import org.apache.asterix.lang.sqlpp.parser.SqlppParserFactory;
import org.apache.asterix.lang.sqlpp.rewrites.visitor.GenerateColumnNameVisitor;
-import org.apache.asterix.lang.sqlpp.rewrites.visitor.InlineColumnAliasVisitor;
import org.apache.asterix.lang.sqlpp.rewrites.visitor.InlineWithExpressionVisitor;
import org.apache.asterix.lang.sqlpp.rewrites.visitor.OperatorExpressionVisitor;
import org.apache.asterix.lang.sqlpp.rewrites.visitor.SetOperationVisitor;
@@ -95,9 +94,6 @@
// Sets up parameters.
setup(declaredFunctions, topStatement, metadataProvider, context);
-
- // Inlines column aliases.
- inlineColumnAlias();
// Generates column names.
generateColumnNames();
@@ -196,12 +192,6 @@
// Rewrites like/not-like/in/not-in operators into function call expressions.
OperatorExpressionVisitor operatorExpressionVisitor = new OperatorExpressionVisitor(context);
topExpr.accept(operatorExpressionVisitor, null);
- }
-
- protected void inlineColumnAlias() throws CompilationException {
- // Inline column aliases.
- InlineColumnAliasVisitor inlineColumnAliasVisitor = new InlineColumnAliasVisitor(context);
- topExpr.accept(inlineColumnAliasVisitor, null);
}
protected void variableCheckAndRewrite() throws CompilationException {
diff --git a/asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/visitor/InlineColumnAliasVisitor.java b/asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/visitor/InlineColumnAliasVisitor.java
deleted file mode 100644
index 628bf57..0000000
--- a/asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/visitor/InlineColumnAliasVisitor.java
+++ /dev/null
@@ -1,147 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one
- * or more contributor license agreements. See the NOTICE file
- * distributed with this work for additional information
- * regarding copyright ownership. The ASF licenses this file
- * to you under the Apache License, Version 2.0 (the
- * "License"); you may not use this file except in compliance
- * with the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing,
- * software distributed under the License is distributed on an
- * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
- * KIND, either express or implied. See the License for the
- * specific language governing permissions and limitations
- * under the License.
- */
-package org.apache.asterix.lang.sqlpp.rewrites.visitor;
-
-import java.util.Collections;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
-
-import org.apache.asterix.common.exceptions.CompilationException;
-import org.apache.asterix.lang.common.base.Expression;
-import org.apache.asterix.lang.common.base.Expression.Kind;
-import org.apache.asterix.lang.common.base.ILangExpression;
-import org.apache.asterix.lang.common.base.Literal;
-import org.apache.asterix.lang.common.clause.LetClause;
-import org.apache.asterix.lang.common.expression.FieldBinding;
-import org.apache.asterix.lang.common.expression.LiteralExpr;
-import org.apache.asterix.lang.common.expression.RecordConstructor;
-import org.apache.asterix.lang.common.expression.VariableExpr;
-import org.apache.asterix.lang.common.rewrites.LangRewritingContext;
-import org.apache.asterix.lang.common.struct.VarIdentifier;
-import org.apache.asterix.lang.sqlpp.clause.Projection;
-import org.apache.asterix.lang.sqlpp.clause.SelectBlock;
-import org.apache.asterix.lang.sqlpp.clause.SelectClause;
-import org.apache.asterix.lang.sqlpp.clause.SelectElement;
-import org.apache.asterix.lang.sqlpp.clause.SelectRegular;
-import org.apache.asterix.lang.sqlpp.expression.SelectExpression;
-import org.apache.asterix.lang.sqlpp.util.SqlppVariableUtil;
-import org.apache.asterix.lang.sqlpp.visitor.SqlppSubstituteExpressionVisitor;
-import org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor;
-
-public class InlineColumnAliasVisitor extends AbstractSqlppExpressionScopingVisitor {
-
- public InlineColumnAliasVisitor(LangRewritingContext context) {
- super(context);
- }
-
- @Override
- public Expression visit(SelectBlock selectBlock, ILangExpression arg) throws CompilationException {
- // Gets the map from select clause.
- Map<Expression, Expression> map = getMap(selectBlock.getSelectClause());
-
- // Removes all FROM/LET binding variables
- if (selectBlock.hasFromClause()) {
- map.keySet().removeAll(SqlppVariableUtil.getBindingVariables(selectBlock.getFromClause()));
- }
- if (selectBlock.hasLetClauses()) {
- map.keySet().removeAll(SqlppVariableUtil.getBindingVariables(selectBlock.getLetList()));
- }
-
- // Creates a substitution visitor.
- SqlppSubstituteExpressionVisitor visitor = new SqlppSubstituteExpressionVisitor(context, map);
-
- // Rewrites GROUP BY/LET/HAVING clauses.
- if (selectBlock.hasGroupbyClause()) {
- selectBlock.getGroupbyClause().accept(visitor, arg);
- }
- if (selectBlock.hasLetClausesAfterGroupby()) {
- for (LetClause letClause : selectBlock.getLetListAfterGroupby()) {
- letClause.accept(visitor, arg);
- }
- }
- if (selectBlock.hasHavingClause()) {
- selectBlock.getHavingClause().accept(visitor, arg);
- }
- SelectExpression selectExpression = (SelectExpression) arg;
-
- // For SET operation queries, column aliases will not substitute ORDER BY nor LIMIT expressions.
- if (!selectExpression.getSelectSetOperation().hasRightInputs()) {
- if (selectExpression.hasOrderby()) {
- selectExpression.getOrderbyClause().accept(visitor, arg);
- }
- if (selectExpression.hasLimit()) {
- selectExpression.getLimitClause().accept(visitor, arg);
- }
- }
- return super.visit(selectBlock, arg);
- }
-
- private Map<Expression, Expression> getMap(SelectClause selectClause) throws CompilationException {
- if (selectClause.selectElement()) {
- return getMap(selectClause.getSelectElement());
- }
- if (selectClause.selectRegular()) {
- return getMap(selectClause.getSelectRegular());
- }
- return null;
- }
-
- private Map<Expression, Expression> getMap(SelectElement selectElement) {
- Expression expr = selectElement.getExpression();
- if (expr.getKind() == Kind.RECORD_CONSTRUCTOR_EXPRESSION) {
- // Rewrite top-level field names (aliases), in order to be consistent with SelectRegular.
- return mapRecordConstructor((RecordConstructor) expr);
- }
- return Collections.emptyMap();
- }
-
- private Map<Expression, Expression> getMap(SelectRegular selectRegular) {
- return mapProjections(selectRegular.getProjections());
- }
-
- private Map<Expression, Expression> mapRecordConstructor(RecordConstructor rc) {
- Map<Expression, Expression> exprMap = new HashMap<>();
- for (FieldBinding binding : rc.getFbList()) {
- Expression leftExpr = binding.getLeftExpr();
- // We only need to deal with the case that the left expression (for a field name) is
- // a string literal. Otherwise, it is different from a column alias in a projection
- // (e.g., foo.name AS name) in regular SQL SELECT.
- if (leftExpr.getKind() != Kind.LITERAL_EXPRESSION) {
- continue;
- }
- LiteralExpr literalExpr = (LiteralExpr) leftExpr;
- if (literalExpr.getValue().getLiteralType() == Literal.Type.STRING) {
- String fieldName = SqlppVariableUtil.toInternalVariableName(literalExpr.getValue().getStringValue());
- exprMap.put(new VariableExpr(new VarIdentifier(fieldName)), binding.getRightExpr());
- }
- }
- return exprMap;
- }
-
- private Map<Expression, Expression> mapProjections(List<Projection> projections) {
- Map<Expression, Expression> exprMap = new HashMap<>();
- for (Projection projection : projections) {
- exprMap.put(
- new VariableExpr(new VarIdentifier(SqlppVariableUtil.toInternalVariableName(projection.getName()))),
- projection.getExpression());
- }
- return exprMap;
- }
-}
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-verify-no-installer-app/2857/ (11/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-sonar/6275/ (8/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-verify-asterix-app/2877/ (10/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-cancellation-test/2248/ (3/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Dmitry Lychagin (Code Review)" <do...@asterixdb.incubator.apache.org>.
Dmitry Lychagin has abandoned this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Abandoned
new change: https://asterix-gerrit.ics.uci.edu/2294
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: abandon
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Integration Tests Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/5277/
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app/3103/ (12/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-ensure-ancestor/333/ (9/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-rebalance-cancellation/1467/ (2/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-verify-storage/2856/ (7/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-source-assemblies/2555/ (5/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Anon. E. Moose (Code Review)" <do...@asterixdb.incubator.apache.org>.
Anon. E. Moose #1000171 has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Analytics Compatibility Compilation Successful
https://goo.gl/btySQN : SUCCESS
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Anon. E. Moose (Code Review)" <do...@asterixdb.incubator.apache.org>.
Anon. E. Moose #1000171 has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1: Contrib-2
Analytics Compatibility Tests Failed
https://goo.gl/rxTpVw : UNSTABLE
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-notopic/7780/ (6/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/hyracks-gerrit/2226/ (4/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1:
Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app-sql-execution/2269/ (1/12)
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in cl...
Posted by "Jenkins (Code Review)" <do...@asterixdb.incubator.apache.org>.
Jenkins has posted comments on this change.
Change subject: [ASTERIXDB-2248][SQLPP] Disallow use of column aliases in clauses
......................................................................
Patch Set 1: Integration-Tests+1
Integration Tests Successful
https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/5277/ : SUCCESS
--
To view, visit https://asterix-gerrit.ics.uci.edu/2288
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I2fc73a2f7da9e11f04dbcc868e9aef25090037e9
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Dmitry Lychagin <dm...@couchbase.com>
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-HasComments: No