sql.init();

v0:int := sql.mvc();
v1:bat[:oid] := sql.tid(v0, "sys", "customer");
v2:bat[:lng] := sql.bind(v0, "sys", "customer", "c_acctbal", 0:int);
(v3:bat[:oid], v4:bat[:lng]) := sql.bind(v0, "sys", "customer", "c_acctbal", 2:int);
v5:bat[:lng] := sql.bind(v0, "sys", "customer", "c_acctbal", 1:int);
v6:bat[:lng] := sql.delta(v2, v3, v4, v5);
v7:bat[:lng] := algebra.projection(v1, v6);
v8:sht := calc.sht("8500.0", 4:int, 0:int);
v9:lng := calc.lng(0:int, v8, 15:int, 2:int);
v10:bat[:oid] := algebra.subselect(v7, v9, nil:lng, false, false, false);
v11:bat[:lng] := algebra.projection(v10, v7);
(v12:bat[:lng], v13:bat[:oid], v14:bat[:oid]) := algebra.subsort(v11, nil:bat[:oid], nil:bat[:oid], false, false);
v15:bat[:lng] := algebra.projection(v13, v11);
v22:bat[:oid] := bat.mirror(v15);

# this line fails silently
(v23:bat[:oid], v24:bat[:oid], v25:bat[:oid]) := algebra.subsort(v22, nil:bat[:oid], nil:bat[:oid], true, false);

io.print("Hello, World!");