Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

use dataverse tpch;

for $d in dataset Lineitem

for $t in dataset Orders
/*+ psort */

where 4 * $d.l_extendedprice - 4 * $t.o_totalprice > -2 and4 * $d.l_extendedprice - 4 * $t.o_totalprice < 2

return

{"ok": $d.l_orderkey, "ln": $d.l_linenumber, "ep": $l.l_extendedprice, "tp": $t.o_totalprice}

...