Clone Tools
  • last updated 14 mins ago
Constraints: committers
Constraints: files
Constraints: dates
ASTERIXDB-1755: add UPSERT in SQL++.

Detailed list of changes included:

- Fix AQL RETURNING clause to use an expression instead of a query;

- Add a rule to check whether a RETURNING expression contains dataset accesses;

- Perform AST-level rewrites for INSERT/UPSERT as a whole, including the

body query and the returning expression.

Change-Id: I02b2be7ff2653573eccb48037895f5c8c4bc8c74


Tested-by: Jenkins <>

Integration-Tests: Jenkins <>

Reviewed-by: Yingyi Bu <>

  1. … 103 more files in changeset.
Enhanced Insert AQL

The optional "as Variable" provides a variable binding for the inserted records

The optional "returning Query" allows users to run simple

queries/functions on the records returned by the insert, and can refer

to the variable bound in "as Variable"

Allow commits to be non-sink operators (contnue job pipeline after commit)

Additionally, this change makes small modifications to

the extension code to prepare for the BAD extension

Also made the OptimizerTests able to work for Extensions

Change-Id: I65789d2a861d15232dd29156a6987d0635ec6c94


Reviewed-by: abdullah alamoudi <>

Tested-by: Jenkins <>

    • -0
    • +5
  1. … 80 more files in changeset.