asterixdb/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/prim-idx-search.ast

DataverseUse prim_index_search
TypeDecl OrderType [
  closed RecordType {
    o_orderkey : integer,
    o_custkey : integer,
    o_orderstatus : string,
    o_totalprice : double,
    o_orderdate : string,
    o_orderpriority : string,
    o_clerk : string,
    o_shippriority : integer,
    o_comment : string
  }
]
DatasetDecl Orders(OrderType) partitioned by [[o_orderkey]]
WriteOutputTo asterix_nc1:/tmp/prim_index_search.adm
Query:
SELECT ELEMENT [
RecordConstructor [
  (
    LiteralExpr [STRING] [o_orderkey]
    :
    FieldAccessor [
      Variable [ Name=$o ]
      Field=o_orderkey
    ]
  )
  (
    LiteralExpr [STRING] [o_custkey]
    :
    FieldAccessor [
      Variable [ Name=$o ]
      Field=o_custkey
    ]
  )
]
]
FROM [  FunctionCall Metadata.dataset@1[
    LiteralExpr [STRING] [Orders]
  ]
  AS Variable [ Name=$o ]
]
Where
  OperatorExpr [
    FieldAccessor [
      Variable [ Name=$o ]
      Field=o_orderkey
    ]
    =
    LiteralExpr [LONG] [34]
  ]