Rewrite SQL++ functions.
-Maps SQL function names to internal names.
-Allows SQL++ builtin functions to be case-insensitive.
-Rewrites SQL-92 global aggregates.
-Refactors SQL++ AST visitors.
-Cleans up semantics of COLL_AGG and SQL-92 AGG.
Change-Id: Idb5a7c6780669b27065b0928bec7e4700cfb53a9
Reviewed-on: https://asterix-gerrit.ics.uci.edu/759
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Till Westmann <tillw@apache.org>
diff --git a/asterix-app/src/test/resources/optimizerts/queries_sqlpp/split-materialization-above-join.sqlpp b/asterix-app/src/test/resources/optimizerts/queries_sqlpp/split-materialization-above-join.sqlpp
index 07ccedc..94bcbf1 100644
--- a/asterix-app/src/test/resources/optimizerts/queries_sqlpp/split-materialization-above-join.sqlpp
+++ b/asterix-app/src/test/resources/optimizerts/queries_sqlpp/split-materialization-above-join.sqlpp
@@ -54,7 +54,7 @@
from DBLP as paper,
fuzzyjoin."counthashed-word-tokens"(paper.title) as token
group by token as tokenGroupped
- order by fuzzyjoin.count(paper),tokenGroupped
+ order by count(paper),tokenGroupped
) as tokenRanked at i
where (tokenUnranked = tokenRanked)
order by i
@@ -68,7 +68,7 @@
from DBLP as paper,
fuzzyjoin."counthashed-word-tokens"(paper.title) as token
group by token as tokenGroupped
- order by fuzzyjoin.count(paper),tokenGroupped
+ order by count(paper),tokenGroupped
) as tokenRanked at i
where (tokenUnranked = tokenRanked)
order by i