asterixdb/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue827-2.ast

DataverseUse tpch
TypeDecl LineItemType [
  closed RecordType {
    l_orderkey : integer,
    l_partkey : integer,
    l_suppkey : integer,
    l_linenumber : integer,
    l_quantity : double,
    l_extendedprice : double,
    l_discount : double,
    l_tax : double,
    l_returnflag : string,
    l_linestatus : string,
    l_shipdate : string,
    l_commitdate : string,
    l_receiptdate : string,
    l_shipinstruct : string,
    l_shipmode : string,
    l_comment : string
  }
]
DatasetDecl LineItem(LineItemType) partitioned by [[l_orderkey], [l_linenumber]]
Query:
RecordConstructor [
  (
    LiteralExpr [STRING] [sum_qty_partial]
    :
    FunctionCall tpch.sum@1[
      (
        SELECT ELEMENT [
        FieldAccessor [
          Variable [ Name=$i ]
          Field=l_quantity
        ]
        ]
        FROM [          FunctionCall Metadata.dataset@1[
            LiteralExpr [STRING] [LineItem]
          ]
          AS Variable [ Name=$i ]
        ]
        Where
          OperatorExpr [
            FieldAccessor [
              Variable [ Name=$i ]
              Field=l_shipdate
            ]
            <=
            LiteralExpr [STRING] [1998-09-02]
          ]
      )
    ]
  )
  (
    LiteralExpr [STRING] [sum_base_price]
    :
    FunctionCall tpch.sum@1[
      (
        SELECT ELEMENT [
        FieldAccessor [
          Variable [ Name=$i ]
          Field=l_extendedprice
        ]
        ]
        FROM [          FunctionCall Metadata.dataset@1[
            LiteralExpr [STRING] [LineItem]
          ]
          AS Variable [ Name=$i ]
        ]
      )
    ]
  )
  (
    LiteralExpr [STRING] [sum_disc_price]
    :
    FunctionCall tpch.sum@1[
      (
        SELECT ELEMENT [
        OperatorExpr [
          FieldAccessor [
            Variable [ Name=$i ]
            Field=l_extendedprice
          ]
          *
          OperatorExpr [
            LiteralExpr [LONG] [1]
            -
            FieldAccessor [
              Variable [ Name=$i ]
              Field=l_discount
            ]
          ]
        ]
        ]
        FROM [          FunctionCall Metadata.dataset@1[
            LiteralExpr [STRING] [LineItem]
          ]
          AS Variable [ Name=$i ]
        ]
      )
    ]
  )
  (
    LiteralExpr [STRING] [sum_charge]
    :
    FunctionCall tpch.sum@1[
      (
        SELECT ELEMENT [
        OperatorExpr [
          FieldAccessor [
            Variable [ Name=$i ]
            Field=l_extendedprice
          ]
          *
          OperatorExpr [
            LiteralExpr [LONG] [1]
            -
            FieldAccessor [
              Variable [ Name=$i ]
              Field=l_discount
            ]
          ]
          *
          OperatorExpr [
            LiteralExpr [LONG] [1]
            +
            FieldAccessor [
              Variable [ Name=$i ]
              Field=l_tax
            ]
          ]
        ]
        ]
        FROM [          FunctionCall Metadata.dataset@1[
            LiteralExpr [STRING] [LineItem]
          ]
          AS Variable [ Name=$i ]
        ]
      )
    ]
  )
  (
    LiteralExpr [STRING] [ave_qty]
    :
    FunctionCall tpch.avg@1[
      (
        SELECT ELEMENT [
        FieldAccessor [
          Variable [ Name=$i ]
          Field=l_quantity
        ]
        ]
        FROM [          FunctionCall Metadata.dataset@1[
            LiteralExpr [STRING] [LineItem]
          ]
          AS Variable [ Name=$i ]
        ]
        Where
          OperatorExpr [
            FieldAccessor [
              Variable [ Name=$i ]
              Field=l_shipdate
            ]
            <=
            LiteralExpr [STRING] [1998-09-02]
          ]
      )
    ]
  )
  (
    LiteralExpr [STRING] [ave_price]
    :
    FunctionCall tpch.avg@1[
      (
        SELECT ELEMENT [
        FieldAccessor [
          Variable [ Name=$i ]
          Field=l_extendedprice
        ]
        ]
        FROM [          FunctionCall Metadata.dataset@1[
            LiteralExpr [STRING] [LineItem]
          ]
          AS Variable [ Name=$i ]
        ]
      )
    ]
  )
  (
    LiteralExpr [STRING] [ave_disc]
    :
    FunctionCall tpch.avg@1[
      (
        SELECT ELEMENT [
        FieldAccessor [
          Variable [ Name=$i ]
          Field=l_discount
        ]
        ]
        FROM [          FunctionCall Metadata.dataset@1[
            LiteralExpr [STRING] [LineItem]
          ]
          AS Variable [ Name=$i ]
        ]
      )
    ]
  )
  (
    LiteralExpr [STRING] [count_order]
    :
    FunctionCall tpch.count@1[
      (
        SELECT ELEMENT [
        Variable [ Name=$l ]
        ]
        FROM [          FunctionCall Metadata.dataset@1[
            LiteralExpr [STRING] [LineItem]
          ]
          AS Variable [ Name=$l ]
        ]
      )
    ]
  )
]