#########################################################
# 
# DELETE ACROSS ENGINES
#
#########################################################

--source suite/interact/include/interact.inc

SET @uuid = UUID();

SET AUTOCOMMIT=OFF;
START TRANSACTION;

INSERT INTO view1 (t1_uuid) VALUES (@uuid);

SELECT t1_autoinc FROM view1 WHERE t1_uuid = @uuid INTO @t1_autoinc;
INSERT INTO view2 (t1_uuid, t2_date) VALUES (@uuid, '2009-09-09');

SAVEPOINT setup;

CALL delete_multi(@uuid);
SELECT view1.t1_uuid, view2.t2_date FROM view1 LEFT JOIN view2 USING (t1_uuid) WHERE t1_blob = @t1_uuid;

ROLLBACK TO SAVEPOINT setup;
SELECT view1.t1_uuid, view2.t2_date FROM view1 LEFT JOIN view2 USING (t1_uuid) WHERE t1_uuid = @t1_uuid;

CALL delete_multi(@uuid);
COMMIT;
SELECT view1.t1_uuid, view2.t2_date FROM view1 LEFT JOIN view2 USING (t1_uuid) WHERE t1_uuid = @t1_uuid;