asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/temporal/interval_functions/interval_functions.3.ast

DataverseUse test
Query:
Let Variable [ Name=$itv1 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.date@1[
      LiteralExpr [STRING] [2010-10-30]
    ]
    FunctionCall test.date@1[
      LiteralExpr [STRING] [2010-12-21]
    ]
  ]
Let Variable [ Name=$itv2 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.date@1[
      LiteralExpr [STRING] [2011-10-30]
    ]
    FunctionCall test.date@1[
      LiteralExpr [STRING] [2012-10-21]
    ]
  ]
Let Variable [ Name=$itv3 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.date@1[
      LiteralExpr [STRING] [2010-12-21]
    ]
    FunctionCall test.date@1[
      LiteralExpr [STRING] [2013-01-01]
    ]
  ]
Let Variable [ Name=$blnBefore1 ]
  :=
  FunctionCall test.interval-before@2[
    Variable [ Name=$itv1 ]
    Variable [ Name=$itv2 ]
  ]
Let Variable [ Name=$blnAfter1 ]
  :=
  FunctionCall test.interval-after@2[
    Variable [ Name=$itv2 ]
    Variable [ Name=$itv1 ]
  ]
Let Variable [ Name=$blnBefore2 ]
  :=
  FunctionCall test.interval-before@2[
    Variable [ Name=$itv1 ]
    Variable [ Name=$itv3 ]
  ]
Let Variable [ Name=$blnAfter2 ]
  :=
  FunctionCall test.interval-after@2[
    Variable [ Name=$itv3 ]
    Variable [ Name=$itv1 ]
  ]
Let Variable [ Name=$itv4 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [2012-06-26T01:01:01.111]
    ]
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [2012-07-27T02:02:02.222]
    ]
  ]
Let Variable [ Name=$itv5 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [20120727T020202222]
    ]
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [2013-08-08T03:03:03.333]
    ]
  ]
Let Variable [ Name=$itv6 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [19000707T020202222]
    ]
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [2013-08-07T03:03:03.333]
    ]
  ]
Let Variable [ Name=$blnMeet1 ]
  :=
  FunctionCall test.interval-meets@2[
    Variable [ Name=$itv4 ]
    Variable [ Name=$itv5 ]
  ]
Let Variable [ Name=$blnMetBy1 ]
  :=
  FunctionCall test.interval-met-by@2[
    Variable [ Name=$itv5 ]
    Variable [ Name=$itv4 ]
  ]
Let Variable [ Name=$blnMeet2 ]
  :=
  FunctionCall test.interval-meets@2[
    Variable [ Name=$itv6 ]
    Variable [ Name=$itv4 ]
  ]
Let Variable [ Name=$blnMetBy2 ]
  :=
  FunctionCall test.interval-met-by@2[
    Variable [ Name=$itv6 ]
    Variable [ Name=$itv4 ]
  ]
Let Variable [ Name=$itv7 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.time@1[
      LiteralExpr [STRING] [12:32:38]
    ]
    FunctionCall test.time@1[
      LiteralExpr [STRING] [20:29:20]
    ]
  ]
Let Variable [ Name=$itv8 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.time@1[
      LiteralExpr [STRING] [17:48:19]
    ]
    FunctionCall test.time@1[
      LiteralExpr [STRING] [22:19:49]
    ]
  ]
Let Variable [ Name=$itv9 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.time@1[
      LiteralExpr [STRING] [01:32:49]
    ]
    FunctionCall test.time@1[
      LiteralExpr [STRING] [17:48:19]
    ]
  ]
Let Variable [ Name=$blnOverlaps1 ]
  :=
  FunctionCall test.interval-overlaps@2[
    Variable [ Name=$itv7 ]
    Variable [ Name=$itv8 ]
  ]
Let Variable [ Name=$blnOverlapped1 ]
  :=
  FunctionCall test.interval-overlapped-by@2[
    Variable [ Name=$itv8 ]
    Variable [ Name=$itv7 ]
  ]
Let Variable [ Name=$blnOverlaps2 ]
  :=
  FunctionCall test.interval-overlaps@2[
    Variable [ Name=$itv9 ]
    Variable [ Name=$itv8 ]
  ]
Let Variable [ Name=$blnOverlapped2 ]
  :=
  FunctionCall test.interval-overlapped-by@2[
    Variable [ Name=$itv8 ]
    Variable [ Name=$itv9 ]
  ]
Let Variable [ Name=$blnOverlap1 ]
  :=
  FunctionCall test.interval-overlapping@2[
    Variable [ Name=$itv9 ]
    Variable [ Name=$itv7 ]
  ]
Let Variable [ Name=$blnOverlap2 ]
  :=
  FunctionCall test.interval-overlapping@2[
    Variable [ Name=$itv9 ]
    Variable [ Name=$itv8 ]
  ]
Let Variable [ Name=$itv10 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.date@1[
      LiteralExpr [STRING] [2010-10-30]
    ]
    FunctionCall test.date@1[
      LiteralExpr [STRING] [2010-11-30]
    ]
  ]
Let Variable [ Name=$blnStarts1 ]
  :=
  FunctionCall test.interval-starts@2[
    Variable [ Name=$itv10 ]
    Variable [ Name=$itv1 ]
  ]
Let Variable [ Name=$blnStarts2 ]
  :=
  FunctionCall test.interval-starts@2[
    Variable [ Name=$itv10 ]
    Variable [ Name=$itv2 ]
  ]
Let Variable [ Name=$blnStartedBy1 ]
  :=
  FunctionCall test.interval-started-by@2[
    Variable [ Name=$itv1 ]
    Variable [ Name=$itv10 ]
  ]
Let Variable [ Name=$blnStartedBy2 ]
  :=
  FunctionCall test.interval-started-by@2[
    Variable [ Name=$itv10 ]
    Variable [ Name=$itv2 ]
  ]
Let Variable [ Name=$itv10 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [19000707T020202222]
    ]
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [2013-08-07T03:03:03.333]
    ]
  ]
Let Variable [ Name=$itv11 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [19990707T020202222]
    ]
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [2013-08-07T03:03:03.333]
    ]
  ]
Let Variable [ Name=$itv12 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [-19990707T020202222]
    ]
    FunctionCall test.datetime@1[
      LiteralExpr [STRING] [2013-08-07T03:03:03.333]
    ]
  ]
Let Variable [ Name=$blnCovers1 ]
  :=
  FunctionCall test.interval-covers@2[
    Variable [ Name=$itv10 ]
    Variable [ Name=$itv11 ]
  ]
Let Variable [ Name=$blnCovers2 ]
  :=
  FunctionCall test.interval-covers@2[
    Variable [ Name=$itv10 ]
    Variable [ Name=$itv12 ]
  ]
Let Variable [ Name=$blnCoveredBy1 ]
  :=
  FunctionCall test.interval-covered-by@2[
    Variable [ Name=$itv11 ]
    Variable [ Name=$itv10 ]
  ]
Let Variable [ Name=$blnCoveredBy2 ]
  :=
  FunctionCall test.interval-covered-by@2[
    Variable [ Name=$itv12 ]
    Variable [ Name=$itv10 ]
  ]
Let Variable [ Name=$itv11 ]
  :=
  FunctionCall test.interval@2[
    FunctionCall test.time@1[
      LiteralExpr [STRING] [19:00:00.009]
    ]
    FunctionCall test.time@1[
      LiteralExpr [STRING] [20:29:20.000]
    ]
  ]
Let Variable [ Name=$blnEnds1 ]
  :=
  FunctionCall test.interval-ends@2[
    Variable [ Name=$itv11 ]
    Variable [ Name=$itv7 ]
  ]
Let Variable [ Name=$blnEnds2 ]
  :=
  FunctionCall test.interval-ends@2[
    Variable [ Name=$itv11 ]
    Variable [ Name=$itv8 ]
  ]
Let Variable [ Name=$blnEndedBy1 ]
  :=
  FunctionCall test.interval-ended-by@2[
    Variable [ Name=$itv7 ]
    Variable [ Name=$itv11 ]
  ]
Let Variable [ Name=$blnEndedBy2 ]
  :=
  FunctionCall test.interval-ended-by@2[
    Variable [ Name=$itv8 ]
    Variable [ Name=$itv11 ]
  ]
Let Variable [ Name=$null1 ]
  :=
  FunctionCall test.interval-before@2[
    LiteralExpr [NULL]
    Variable [ Name=$itv2 ]
  ]
Let Variable [ Name=$null2 ]
  :=
  FunctionCall test.interval-covered-by@2[
    Variable [ Name=$itv11 ]
    LiteralExpr [NULL]
  ]
Let Variable [ Name=$null3 ]
  :=
  FunctionCall test.interval-overlapping@2[
    LiteralExpr [NULL]
    LiteralExpr [NULL]
  ]
SELECT ELEMENT [
RecordConstructor [
  (
    LiteralExpr [STRING] [before1]
    :
    Variable [ Name=$blnBefore1 ]
  )
  (
    LiteralExpr [STRING] [before2]
    :
    Variable [ Name=$blnBefore2 ]
  )
  (
    LiteralExpr [STRING] [after1]
    :
    Variable [ Name=$blnAfter1 ]
  )
  (
    LiteralExpr [STRING] [after2]
    :
    Variable [ Name=$blnAfter2 ]
  )
  (
    LiteralExpr [STRING] [meet1]
    :
    Variable [ Name=$blnMeet1 ]
  )
  (
    LiteralExpr [STRING] [meet2]
    :
    Variable [ Name=$blnMeet2 ]
  )
  (
    LiteralExpr [STRING] [metby1]
    :
    Variable [ Name=$blnMetBy1 ]
  )
  (
    LiteralExpr [STRING] [metby2]
    :
    Variable [ Name=$blnMetBy2 ]
  )
  (
    LiteralExpr [STRING] [overlaps1]
    :
    Variable [ Name=$blnOverlaps1 ]
  )
  (
    LiteralExpr [STRING] [overlaps2]
    :
    Variable [ Name=$blnOverlaps2 ]
  )
  (
    LiteralExpr [STRING] [overlapped1]
    :
    Variable [ Name=$blnOverlapped1 ]
  )
  (
    LiteralExpr [STRING] [overlapped2]
    :
    Variable [ Name=$blnOverlapped2 ]
  )
  (
    LiteralExpr [STRING] [overlap1]
    :
    Variable [ Name=$blnOverlap1 ]
  )
  (
    LiteralExpr [STRING] [overlap2]
    :
    Variable [ Name=$blnOverlap2 ]
  )
  (
    LiteralExpr [STRING] [starts1]
    :
    Variable [ Name=$blnStarts1 ]
  )
  (
    LiteralExpr [STRING] [starts2]
    :
    Variable [ Name=$blnStarts2 ]
  )
  (
    LiteralExpr [STRING] [startedby1]
    :
    Variable [ Name=$blnStartedBy1 ]
  )
  (
    LiteralExpr [STRING] [startedby2]
    :
    Variable [ Name=$blnStartedBy2 ]
  )
  (
    LiteralExpr [STRING] [covers1]
    :
    Variable [ Name=$blnCovers1 ]
  )
  (
    LiteralExpr [STRING] [covers2]
    :
    Variable [ Name=$blnCovers2 ]
  )
  (
    LiteralExpr [STRING] [coveredby1]
    :
    Variable [ Name=$blnCoveredBy1 ]
  )
  (
    LiteralExpr [STRING] [coveredby2]
    :
    Variable [ Name=$blnCoveredBy2 ]
  )
  (
    LiteralExpr [STRING] [ends1]
    :
    Variable [ Name=$blnEnds1 ]
  )
  (
    LiteralExpr [STRING] [ends2]
    :
    Variable [ Name=$blnEnds2 ]
  )
  (
    LiteralExpr [STRING] [endedby1]
    :
    Variable [ Name=$blnEndedBy1 ]
  )
  (
    LiteralExpr [STRING] [endedby2]
    :
    Variable [ Name=$blnEndedBy2 ]
  )
  (
    LiteralExpr [STRING] [null1]
    :
    Variable [ Name=$null1 ]
  )
  (
    LiteralExpr [STRING] [null2]
    :
    Variable [ Name=$null2 ]
  )
  (
    LiteralExpr [STRING] [null3]
    :
    Variable [ Name=$null3 ]
  )
]
]