Horton

test_script.tar

application/x-tar

Download
Filename: test_script.tar
Type: application/x-tar
Part: 0
Message: RE: Parallel scan with SubTransGetTopmostTransaction assert coredump 
test_script/0000700000175700017570000000000014045210021012424 5ustar  liupcliupctest_script/sub_120.sql0000600000175700017570000004502614045210021014331 0ustar  liupcliupc

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;
test_script/init_test.sql0000600000175700017570000000125114045210021015150 0ustar  liupcliupc do language plpgsql $$                             
	 declare
	 begin
	   execute 'drop table if exists contend';
	     execute 'create table contend(id int, val int, c2 int default 0,c3 int default 0,c4 int default 0,c5 int default 0,c6 int default 0,c7 int default 0,c8 int default 0,c9
	       int default 0,c10 int default 0, crt_time timestamp default now())';
	         execute 'insert into contend(id,val) select generate_series(1,1000000),1 ';
		   
		  
		   for i in 1..10 loop
			       execute format('drop table if exists contend%s', i);
			           execute format('create table contend%s as select * from contend ', i);
				     end loop;
			     end;
			     $$;