Horton

sub_120.sql

application/octet-stream

Download
Filename: sub_120.sql
Type: application/octet-stream
Part: 2
Message: Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump 

BEGIN;
\set num random(1,10)
\set pnum random(1,9999999)
PREPARE sel_:pnum(integer) AS SELECT count(*) FROM contend:num WHERE id BETWEEN $1 AND $1 + 100;
PREPARE ist_:pnum(integer) AS insert into contend:num(id,val)  values ($1, 1);
PREPARE upd_:pnum(integer) AS UPDATE contend:num SET val = val + 1 WHERE id = $1;

SAVEPOINT a_1;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_1;
SAVEPOINT a_2;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_2;
SAVEPOINT a_3;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_3;
SAVEPOINT a_4;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_4;
SAVEPOINT a_5;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_5;
SAVEPOINT a_6;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_6;
SAVEPOINT a_7;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_7;
SAVEPOINT a_8;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_8;
SAVEPOINT a_9;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_9;
SAVEPOINT a_10;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_10;
SAVEPOINT a_11;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_11;
SAVEPOINT a_12;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_12;
SAVEPOINT a_13;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_13;
SAVEPOINT a_14;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_14;
SAVEPOINT a_15;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_15;
SAVEPOINT a_16;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_16;
SAVEPOINT a_17;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_17;
SAVEPOINT a_18;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_18;
SAVEPOINT a_19;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_19;
SAVEPOINT a_20;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_20;
SAVEPOINT a_21;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_21;
SAVEPOINT a_22;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_22;
SAVEPOINT a_23;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_23;
SAVEPOINT a_24;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_24;
SAVEPOINT a_25;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_25;
SAVEPOINT a_26;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_26;
SAVEPOINT a_27;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_27;
SAVEPOINT a_28;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_28;
SAVEPOINT a_29;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_29;
SAVEPOINT a_30;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_30;
SAVEPOINT a_31;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_31;
SAVEPOINT a_32;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_32;
SAVEPOINT a_33;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_33;
SAVEPOINT a_34;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_34;
SAVEPOINT a_35;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_35;
SAVEPOINT a_36;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_36;
SAVEPOINT a_37;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_37;
SAVEPOINT a_38;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_38;
SAVEPOINT a_39;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_39;
SAVEPOINT a_40;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_40;
SAVEPOINT a_41;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_41;
SAVEPOINT a_42;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_42;
SAVEPOINT a_43;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_43;
SAVEPOINT a_44;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_44;
SAVEPOINT a_45;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_45;
SAVEPOINT a_46;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_46;
SAVEPOINT a_47;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_47;
SAVEPOINT a_48;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_48;
SAVEPOINT a_49;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_49;
SAVEPOINT a_50;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_50;
SAVEPOINT a_51;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_51;
SAVEPOINT a_52;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_52;
SAVEPOINT a_53;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_53;
SAVEPOINT a_54;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_54;
SAVEPOINT a_55;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_55;
SAVEPOINT a_56;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_56;
SAVEPOINT a_57;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_57;
SAVEPOINT a_58;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_58;
SAVEPOINT a_59;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_59;
SAVEPOINT a_60;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_60;
SAVEPOINT a_61;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_61;
SAVEPOINT a_62;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_62;
SAVEPOINT a_63;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_63;
SAVEPOINT a_64;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_64;
SAVEPOINT a_65;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_65;
SAVEPOINT a_66;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_66;
SAVEPOINT a_67;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_67;
SAVEPOINT a_68;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_68;
SAVEPOINT a_69;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_69;
SAVEPOINT a_70;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_70;
SAVEPOINT a_71;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_71;
SAVEPOINT a_72;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_72;
SAVEPOINT a_73;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_73;
SAVEPOINT a_74;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_74;
SAVEPOINT a_75;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_75;
SAVEPOINT a_76;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_76;
SAVEPOINT a_77;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_77;
SAVEPOINT a_78;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_78;
SAVEPOINT a_79;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_79;
SAVEPOINT a_80;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_80;
SAVEPOINT a_81;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_81;
SAVEPOINT a_82;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_82;
SAVEPOINT a_83;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_83;
SAVEPOINT a_84;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_84;
SAVEPOINT a_85;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_85;
SAVEPOINT a_86;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_86;
SAVEPOINT a_87;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_87;
SAVEPOINT a_88;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_88;
SAVEPOINT a_89;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_89;
SAVEPOINT a_90;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_90;
SAVEPOINT a_91;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_91;
SAVEPOINT a_92;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_92;
SAVEPOINT a_93;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_93;
SAVEPOINT a_94;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_94;
SAVEPOINT a_95;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_95;
SAVEPOINT a_96;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_96;
SAVEPOINT a_97;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_97;
SAVEPOINT a_98;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_98;
SAVEPOINT a_99;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_99;
SAVEPOINT a_100;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_100;
SAVEPOINT a_101;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_101;
SAVEPOINT a_102;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_102;
SAVEPOINT a_103;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_103;
SAVEPOINT a_104;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_104;
SAVEPOINT a_105;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_105;
SAVEPOINT a_106;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_106;
SAVEPOINT a_107;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_107;
SAVEPOINT a_108;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_108;
SAVEPOINT a_109;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_109;
SAVEPOINT a_110;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_110;
SAVEPOINT a_111;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_111;
SAVEPOINT a_112;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_112;
SAVEPOINT a_113;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_113;
SAVEPOINT a_114;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_114;
SAVEPOINT a_115;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_115;
SAVEPOINT a_116;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_116;
SAVEPOINT a_117;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_117;
SAVEPOINT a_118;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_118;
SAVEPOINT a_119;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_119;
SAVEPOINT a_120;
\set rnd random(1,99990)
EXECUTE ist_:pnum(10 * :rnd + :client_id);
EXECUTE sel_:pnum(10 * :rnd + :client_id + 1);
release savepoint a_120;
DEALLOCATE ALL;
COMMIT;