You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by im...@apache.org on 2016/04/07 16:59:56 UTC
[21/50] [abbrv] incubator-asterixdb git commit: Merge branch 'master'
into hyracks-merge2
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/8516517e/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/q06_forecast_revenue_change/q06_forecast_revenue_change.3.ast
----------------------------------------------------------------------
diff --cc asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/q06_forecast_revenue_change/q06_forecast_revenue_change.3.ast
index 592238f,0000000..c8abf8d
mode 100644,000000..100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/q06_forecast_revenue_change/q06_forecast_revenue_change.3.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/q06_forecast_revenue_change/q06_forecast_revenue_change.3.ast
@@@ -1,78 -1,0 +1,86 @@@
+DataverseUse tpch
+Query:
- RecordConstructor [
++SELECT [
++FunctionCall tpch.sum@1[
+ (
- LiteralExpr [STRING] [revenue]
- :
- FunctionCall tpch.sum@1[
- (
- SELECT ELEMENT [
- OperatorExpr [
- FieldAccessor [
- Variable [ Name=$l ]
- Field=l_extendedprice
- ]
- *
- FieldAccessor [
- Variable [ Name=$l ]
- Field=l_discount
- ]
++ SELECT ELEMENT [
++ OperatorExpr [
++ FieldAccessor [
++ FieldAccessor [
++ Variable [ Name=#2 ]
++ Field=l
+ ]
++ Field=l_extendedprice
++ ]
++ *
++ FieldAccessor [
++ FieldAccessor [
++ Variable [ Name=#2 ]
++ Field=l
+ ]
- FROM [ FunctionCall Metadata.dataset@1[
- LiteralExpr [STRING] [LineItem]
- ]
- AS
- Variable [ Name=$l ]
- ]
- Where
- OperatorExpr [
- OperatorExpr [
- FieldAccessor [
- Variable [ Name=$l ]
- Field=l_shipdate
- ]
- >=
- LiteralExpr [STRING] [1994-01-01]
- ]
- and
- OperatorExpr [
- FieldAccessor [
- Variable [ Name=$l ]
- Field=l_shipdate
- ]
- <
- LiteralExpr [STRING] [1995-01-01]
- ]
- and
- OperatorExpr [
- FieldAccessor [
- Variable [ Name=$l ]
- Field=l_discount
- ]
- >=
- LiteralExpr [DOUBLE] [0.05]
- ]
- and
- OperatorExpr [
- FieldAccessor [
- Variable [ Name=$l ]
- Field=l_discount
- ]
- <=
- LiteralExpr [DOUBLE] [0.07]
- ]
- and
- OperatorExpr [
- FieldAccessor [
- Variable [ Name=$l ]
- Field=l_quantity
- ]
- <
- LiteralExpr [LONG] [24]
- ]
- ]
- )
++ Field=l_discount
++ ]
++ ]
++ ]
++ FROM [ Variable [ Name=#1 ]
++ AS
++ Variable [ Name=#2 ]
+ ]
+ )
+]
++revenue
++]
++FROM [ FunctionCall Metadata.dataset@1[
++ LiteralExpr [STRING] [LineItem]
++ ]
++ AS
++ Variable [ Name=$l ]
++]
++Where
++ OperatorExpr [
++ OperatorExpr [
++ FieldAccessor [
++ Variable [ Name=$l ]
++ Field=l_shipdate
++ ]
++ >=
++ LiteralExpr [STRING] [1994-01-01]
++ ]
++ and
++ OperatorExpr [
++ FieldAccessor [
++ Variable [ Name=$l ]
++ Field=l_shipdate
++ ]
++ <
++ LiteralExpr [STRING] [1995-01-01]
++ ]
++ and
++ OperatorExpr [
++ FieldAccessor [
++ Variable [ Name=$l ]
++ Field=l_discount
++ ]
++ >=
++ LiteralExpr [DOUBLE] [0.05]
++ ]
++ and
++ OperatorExpr [
++ FieldAccessor [
++ Variable [ Name=$l ]
++ Field=l_discount
++ ]
++ <=
++ LiteralExpr [DOUBLE] [0.07]
++ ]
++ and
++ OperatorExpr [
++ FieldAccessor [
++ Variable [ Name=$l ]
++ Field=l_quantity
++ ]
++ <
++ LiteralExpr [LONG] [24]
++ ]
++ ]
++Group All