ddl:
	/* Sequence start */ CREATE DATABASE testdb_S ; SELECT SLEEP( 2 * { $rand_val = $prng->int(0,100) / 100 } ) ; DROP DATABASE testdb_S /* Sequence end */ |
	/* Sequence start */ CREATE TABLE testdb_S . tname1 AS SELECT 1 AS f1,1 AS pk; DROP TABLE testdb_S . tname1 /* Sequence end */ |
	CREATE PROCEDURE testdb_S . p1 () BEGIN UPDATE testdb_S . tname1 AS A NATURAL JOIN testdb_S . tname1 B SET A. pk = _digit , B. pk = _digit ; END;

tname1:
	t1 | t2 ;

query:
	CALL testdb_S . p1 |
	ddl;

query_init:
	SET SESSION optimizer_use_mrr='disable' ; SET SESSION optimizer_switch = 'semijoin=off';