recreate table ttt (id varchar(1000) NOT NULL primary key);
SET TERM ^ ;
CREATE OR ALTER PROCEDURE P0 RETURNS ( V blob sub_type text) AS BEGIN SUSPEND; END^
CREATE OR ALTER PROCEDURE P1 RETURNS ( V blob sub_type text) AS BEGIN SUSPEND; END^
CREATE OR ALTER PROCEDURE P2 RETURNS ( V blob sub_type text) AS BEGIN SUSPEND; END^
CREATE OR ALTER PROCEDURE P3 RETURNS ( V blob sub_type text) AS BEGIN SUSPEND; END^
CREATE OR ALTER PROCEDURE P4 RETURNS ( V blob sub_type text) AS BEGIN SUSPEND; END^
CREATE OR ALTER PROCEDURE P5 RETURNS ( V blob sub_type text) AS BEGIN SUSPEND; END^
CREATE OR ALTER PROCEDURE P6 RETURNS ( V blob sub_type text) AS BEGIN SUSPEND; END^
CREATE OR ALTER PROCEDURE P7 RETURNS ( V blob sub_type text) AS BEGIN SUSPEND; END^
CREATE OR ALTER PROCEDURE P8 RETURNS ( V blob sub_type text) AS BEGIN SUSPEND; END^
CREATE OR ALTER PROCEDURE P9 RETURNS ( V blob sub_type text) AS BEGIN SUSPEND; END^

CREATE OR ALTER PROCEDURE P0 RETURNS ( V blob sub_type text) AS begin insert into ttt values (uuid_to_char(gen_uuid())); for select '123'||V from P1 into V do suspend; end^
CREATE OR ALTER PROCEDURE P1 RETURNS ( V blob sub_type text) AS begin insert into ttt values (uuid_to_char(gen_uuid())); for select '123'||V from P2 into V do suspend; end^
CREATE OR ALTER PROCEDURE P2 RETURNS ( V blob sub_type text) AS begin insert into ttt values (uuid_to_char(gen_uuid())); for select '123'||V from P3 into V do suspend; end^
CREATE OR ALTER PROCEDURE P3 RETURNS ( V blob sub_type text) AS begin insert into ttt values (uuid_to_char(gen_uuid())); for select '123'||V from P4 into V do suspend; end^
CREATE OR ALTER PROCEDURE P4 RETURNS ( V blob sub_type text) AS begin insert into ttt values (uuid_to_char(gen_uuid())); for select '123'||V from P5 into V do suspend; end^
CREATE OR ALTER PROCEDURE P5 RETURNS ( V blob sub_type text) AS begin insert into ttt values (uuid_to_char(gen_uuid())); for select '123'||V from P6 into V do suspend; end^
CREATE OR ALTER PROCEDURE P6 RETURNS ( V blob sub_type text) AS begin insert into ttt values (uuid_to_char(gen_uuid())); for select '123'||V from P7 into V do suspend; end^
CREATE OR ALTER PROCEDURE P7 RETURNS ( V blob sub_type text) AS begin insert into ttt values (uuid_to_char(gen_uuid())); for select '123'||V from P8 into V do suspend; end^
CREATE OR ALTER PROCEDURE P8 RETURNS ( V blob sub_type text) AS begin insert into ttt values (uuid_to_char(gen_uuid())); for select '123'||V from P9 into V do suspend; end^
CREATE OR ALTER PROCEDURE P9 RETURNS ( V blob sub_type text) AS begin insert into ttt values (uuid_to_char(gen_uuid())); for select '123'||V from P0 into V do suspend; end^
SET TERM ; ^