You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by AsterixDB Code Review <do...@asterix-gerrit.ics.uci.edu> on 2022/02/15 20:04:03 UTC
Change in asterixdb[neo]: Remove tab from q15
From Vijay Sarathy <vi...@couchbase.com>:
Vijay Sarathy has uploaded this change for review. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/15304 )
Change subject: Remove tab from q15
......................................................................
Remove tab from q15
Change-Id: I2b2186269792746e650374cb9d810941f8dc13ac
---
M asterixdb/asterix-app/src/test/resources/optimizerts/queries/ch2/ch2_q15.sqlpp
1 file changed, 1 insertion(+), 1 deletion(-)
git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/04/15304/1
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/ch2/ch2_q15.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/ch2/ch2_q15.sqlpp
index adf1500..c24cb2f 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/ch2/ch2_q15.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/ch2/ch2_q15.sqlpp
@@ -40,7 +40,7 @@
WITH revenue AS (
SELECT s.s_w_id * s.s_i_id MOD 10000 as supplier_no, SUM(ol.ol_amount) AS total_rev
FROM stock s, orders o, o.o_orderline ol
- WHERE ol.ol_i_id = s.s_i_id
+ WHERE ol.ol_i_id = s.s_i_id
AND ol.ol_supply_w_id = s.s_w_id
AND ol.ol_delivery_d >= '2018-01-01 00:00:00.000000' AND ol.ol_delivery_d < '2018-04-01 00:00:00.000000'
GROUP BY s.s_w_id * s.s_i_id MOD 10000)
--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/15304
To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-Project: asterixdb
Gerrit-Branch: neo
Gerrit-Change-Id: I2b2186269792746e650374cb9d810941f8dc13ac
Gerrit-Change-Number: 15304
Gerrit-PatchSet: 1
Gerrit-Owner: Vijay Sarathy <vi...@couchbase.com>
Gerrit-MessageType: newchange
Change in asterixdb[neo]: Remove tab from q15
Posted by AsterixDB Code Review <do...@asterix-gerrit.ics.uci.edu>.
Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/15304 )
Change subject: Remove tab from q15
......................................................................
Patch Set 1:
Analytics Compatibility Compilation Successful
https://cbjenkins.page.link/e5ppgWmJgDFtkk5q6 : SUCCESS
--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/15304
To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-Project: asterixdb
Gerrit-Branch: neo
Gerrit-Change-Id: I2b2186269792746e650374cb9d810941f8dc13ac
Gerrit-Change-Number: 15304
Gerrit-PatchSet: 1
Gerrit-Owner: Vijay Sarathy <vi...@couchbase.com>
Gerrit-CC: Anon. E. Moose #1000171
Gerrit-CC: Jenkins <je...@fulliautomatix.ics.uci.edu>
Gerrit-Comment-Date: Tue, 15 Feb 2022 20:25:19 +0000
Gerrit-HasComments: No
Gerrit-Has-Labels: No
Gerrit-MessageType: comment
Change in asterixdb[neo]: Remove tab from q15
Posted by AsterixDB Code Review <do...@asterix-gerrit.ics.uci.edu>.
From Vijay Sarathy <vi...@couchbase.com>:
Vijay Sarathy has uploaded this change for review. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/15304 )
Change subject: Remove tab from q15
......................................................................
Remove tab from q15
Change-Id: I2b2186269792746e650374cb9d810941f8dc13ac
---
M asterixdb/asterix-app/src/test/resources/optimizerts/queries/ch2/ch2_q15.sqlpp
1 file changed, 1 insertion(+), 1 deletion(-)
git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/04/15304/1
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/ch2/ch2_q15.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/ch2/ch2_q15.sqlpp
index adf1500..c24cb2f 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/ch2/ch2_q15.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/ch2/ch2_q15.sqlpp
@@ -40,7 +40,7 @@
WITH revenue AS (
SELECT s.s_w_id * s.s_i_id MOD 10000 as supplier_no, SUM(ol.ol_amount) AS total_rev
FROM stock s, orders o, o.o_orderline ol
- WHERE ol.ol_i_id = s.s_i_id
+ WHERE ol.ol_i_id = s.s_i_id
AND ol.ol_supply_w_id = s.s_w_id
AND ol.ol_delivery_d >= '2018-01-01 00:00:00.000000' AND ol.ol_delivery_d < '2018-04-01 00:00:00.000000'
GROUP BY s.s_w_id * s.s_i_id MOD 10000)
--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/15304
To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-Project: asterixdb
Gerrit-Branch: neo
Gerrit-Change-Id: I2b2186269792746e650374cb9d810941f8dc13ac
Gerrit-Change-Number: 15304
Gerrit-PatchSet: 1
Gerrit-Owner: Vijay Sarathy <vi...@couchbase.com>
Gerrit-MessageType: newchange