\set aid1 random(1, 10000)
\set aid2 random(1, 10000)
\set aid3 random(1, 10000)
\set aid4 random(1, 10000)
\set aid5 random(1, 10000)
\set aid6 random(1, 10000)
\set aid7 random(1, 10000)
\set aid8 random(1, 10000)
\set aid9 random(1, 10000)
\set aid10 random(1, 10000)
\set aid11 random(1, 10000)
\set aid12 random(1, 10000)
\set aid13 random(1, 10000)
\set aid14 random(1, 10000)
\set aid15 random(1, 10000)
\set aid16 random(1, 10000)
\set aid17 random(1, 10000)
\set aid18 random(1, 10000)
\set aid19 random(1, 10000)
\set aid20 random(1, 10000)
\set aid21 random(1, 10000)
\set aid22 random(1, 10000)
\set aid23 random(1, 10000)
\set aid24 random(1, 10000)
\set aid25 random(1, 10000)
\set aid26 random(1, 10000)
\set aid27 random(1, 10000)
\set aid28 random(1, 10000)
\set aid29 random(1, 10000)
\set aid30 random(1, 10000)

\set bid random(1, 10000)


BEGIN;

UPDATE test_table SET b = :bid WHERE a = :aid1;
UPDATE test_table SET b = :bid WHERE a = :aid2;
UPDATE test_table SET b = :bid WHERE a = :aid3;
UPDATE test_table SET b = :bid WHERE a = :aid4;
UPDATE test_table SET b = :bid WHERE a = :aid5;
UPDATE test_table SET b = :bid WHERE a = :aid6;
UPDATE test_table SET b = :bid WHERE a = :aid7;
UPDATE test_table SET b = :bid WHERE a = :aid8;
UPDATE test_table SET b = :bid WHERE a = :aid9;
UPDATE test_table SET b = :bid WHERE a = :aid10;
UPDATE test_table SET b = :bid WHERE a = :aid11;
UPDATE test_table SET b = :bid WHERE a = :aid12;
UPDATE test_table SET b = :bid WHERE a = :aid13;
UPDATE test_table SET b = :bid WHERE a = :aid14;
UPDATE test_table SET b = :bid WHERE a = :aid15;
UPDATE test_table SET b = :bid WHERE a = :aid16;
UPDATE test_table SET b = :bid WHERE a = :aid17;
UPDATE test_table SET b = :bid WHERE a = :aid18;
UPDATE test_table SET b = :bid WHERE a = :aid19;
UPDATE test_table SET b = :bid WHERE a = :aid20;
UPDATE test_table SET b = :bid WHERE a = :aid21;
UPDATE test_table SET b = :bid WHERE a = :aid22;
UPDATE test_table SET b = :bid WHERE a = :aid23;
UPDATE test_table SET b = :bid WHERE a = :aid24;
UPDATE test_table SET b = :bid WHERE a = :aid25;
UPDATE test_table SET b = :bid WHERE a = :aid26;
UPDATE test_table SET b = :bid WHERE a = :aid26;
UPDATE test_table SET b = :bid WHERE a = :aid27;
UPDATE test_table SET b = :bid WHERE a = :aid28;
UPDATE test_table SET b = :bid WHERE a = :aid29;

COMMIT;