Skip to content

Instantly share code, notes, and snippets.

@jcdang
Created August 29, 2019 20:36
Show Gist options
  • Save jcdang/b9a42a4976c389b2259202f8af264095 to your computer and use it in GitHub Desktop.
Save jcdang/b9a42a4976c389b2259202f8af264095 to your computer and use it in GitHub Desktop.
Clickhouse benchmark for multiquery vs keep alive
import requests
s = requests.Session()
with open('test.sql') as fp:
for c, line in enumerate(fp):
s.post('http://10.240.0.79:8123/?user=test&password=test', line)
#!/bin/bash
cat test.sql | curl -H 'Multi-Query: true' -sSg 'http://10.240.0.79:8123/?user=test&password=test' -d @-
#!/bin/bash
input="test.sql"
while IFS= read -r line
do
echo "${line}" | curl --no-keepalive -sSg 'http://10.240.0.79:8123/?user=test&password=test' -d @-
done < "${input}"
drop table if exists test.sequence_test;
drop table if exists test.sequence_updated;
create table test.sequence_test(x Integer, y Integer, z Integer) Engine=Memory;
insert into test.sequence_test select a.number as x, b.number as y, 1 as z from numbers(400) a cross join numbers(100) b;
create table test.sequence_updated(x Integer, y Integer, z Integer) Engine=Memory;
insert into test.sequence_updated select x, y, z from test.sequence_test where x = 0;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 1 and b.x = 0;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 2 and b.x = 1;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 3 and b.x = 2;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 4 and b.x = 3;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 5 and b.x = 4;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 6 and b.x = 5;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 7 and b.x = 6;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 8 and b.x = 7;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 9 and b.x = 8;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 10 and b.x = 9;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 11 and b.x = 10;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 12 and b.x = 11;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 13 and b.x = 12;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 14 and b.x = 13;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 15 and b.x = 14;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 16 and b.x = 15;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 17 and b.x = 16;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 18 and b.x = 17;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 19 and b.x = 18;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 20 and b.x = 19;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 21 and b.x = 20;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 22 and b.x = 21;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 23 and b.x = 22;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 24 and b.x = 23;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 25 and b.x = 24;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 26 and b.x = 25;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 27 and b.x = 26;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 28 and b.x = 27;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 29 and b.x = 28;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 30 and b.x = 29;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 31 and b.x = 30;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 32 and b.x = 31;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 33 and b.x = 32;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 34 and b.x = 33;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 35 and b.x = 34;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 36 and b.x = 35;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 37 and b.x = 36;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 38 and b.x = 37;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 39 and b.x = 38;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 40 and b.x = 39;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 41 and b.x = 40;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 42 and b.x = 41;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 43 and b.x = 42;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 44 and b.x = 43;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 45 and b.x = 44;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 46 and b.x = 45;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 47 and b.x = 46;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 48 and b.x = 47;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 49 and b.x = 48;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 50 and b.x = 49;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 51 and b.x = 50;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 52 and b.x = 51;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 53 and b.x = 52;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 54 and b.x = 53;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 55 and b.x = 54;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 56 and b.x = 55;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 57 and b.x = 56;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 58 and b.x = 57;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 59 and b.x = 58;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 60 and b.x = 59;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 61 and b.x = 60;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 62 and b.x = 61;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 63 and b.x = 62;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 64 and b.x = 63;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 65 and b.x = 64;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 66 and b.x = 65;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 67 and b.x = 66;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 68 and b.x = 67;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 69 and b.x = 68;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 70 and b.x = 69;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 71 and b.x = 70;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 72 and b.x = 71;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 73 and b.x = 72;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 74 and b.x = 73;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 75 and b.x = 74;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 76 and b.x = 75;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 77 and b.x = 76;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 78 and b.x = 77;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 79 and b.x = 78;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 80 and b.x = 79;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 81 and b.x = 80;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 82 and b.x = 81;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 83 and b.x = 82;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 84 and b.x = 83;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 85 and b.x = 84;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 86 and b.x = 85;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 87 and b.x = 86;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 88 and b.x = 87;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 89 and b.x = 88;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 90 and b.x = 89;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 91 and b.x = 90;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 92 and b.x = 91;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 93 and b.x = 92;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 94 and b.x = 93;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 95 and b.x = 94;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 96 and b.x = 95;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 97 and b.x = 96;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 98 and b.x = 97;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 99 and b.x = 98;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 100 and b.x = 99;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 101 and b.x = 100;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 102 and b.x = 101;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 103 and b.x = 102;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 104 and b.x = 103;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 105 and b.x = 104;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 106 and b.x = 105;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 107 and b.x = 106;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 108 and b.x = 107;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 109 and b.x = 108;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 110 and b.x = 109;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 111 and b.x = 110;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 112 and b.x = 111;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 113 and b.x = 112;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 114 and b.x = 113;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 115 and b.x = 114;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 116 and b.x = 115;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 117 and b.x = 116;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 118 and b.x = 117;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 119 and b.x = 118;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 120 and b.x = 119;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 121 and b.x = 120;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 122 and b.x = 121;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 123 and b.x = 122;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 124 and b.x = 123;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 125 and b.x = 124;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 126 and b.x = 125;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 127 and b.x = 126;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 128 and b.x = 127;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 129 and b.x = 128;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 130 and b.x = 129;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 131 and b.x = 130;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 132 and b.x = 131;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 133 and b.x = 132;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 134 and b.x = 133;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 135 and b.x = 134;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 136 and b.x = 135;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 137 and b.x = 136;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 138 and b.x = 137;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 139 and b.x = 138;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 140 and b.x = 139;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 141 and b.x = 140;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 142 and b.x = 141;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 143 and b.x = 142;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 144 and b.x = 143;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 145 and b.x = 144;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 146 and b.x = 145;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 147 and b.x = 146;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 148 and b.x = 147;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 149 and b.x = 148;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 150 and b.x = 149;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 151 and b.x = 150;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 152 and b.x = 151;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 153 and b.x = 152;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 154 and b.x = 153;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 155 and b.x = 154;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 156 and b.x = 155;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 157 and b.x = 156;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 158 and b.x = 157;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 159 and b.x = 158;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 160 and b.x = 159;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 161 and b.x = 160;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 162 and b.x = 161;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 163 and b.x = 162;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 164 and b.x = 163;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 165 and b.x = 164;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 166 and b.x = 165;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 167 and b.x = 166;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 168 and b.x = 167;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 169 and b.x = 168;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 170 and b.x = 169;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 171 and b.x = 170;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 172 and b.x = 171;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 173 and b.x = 172;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 174 and b.x = 173;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 175 and b.x = 174;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 176 and b.x = 175;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 177 and b.x = 176;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 178 and b.x = 177;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 179 and b.x = 178;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 180 and b.x = 179;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 181 and b.x = 180;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 182 and b.x = 181;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 183 and b.x = 182;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 184 and b.x = 183;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 185 and b.x = 184;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 186 and b.x = 185;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 187 and b.x = 186;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 188 and b.x = 187;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 189 and b.x = 188;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 190 and b.x = 189;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 191 and b.x = 190;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 192 and b.x = 191;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 193 and b.x = 192;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 194 and b.x = 193;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 195 and b.x = 194;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 196 and b.x = 195;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 197 and b.x = 196;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 198 and b.x = 197;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 199 and b.x = 198;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 200 and b.x = 199;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 201 and b.x = 200;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 202 and b.x = 201;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 203 and b.x = 202;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 204 and b.x = 203;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 205 and b.x = 204;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 206 and b.x = 205;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 207 and b.x = 206;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 208 and b.x = 207;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 209 and b.x = 208;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 210 and b.x = 209;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 211 and b.x = 210;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 212 and b.x = 211;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 213 and b.x = 212;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 214 and b.x = 213;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 215 and b.x = 214;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 216 and b.x = 215;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 217 and b.x = 216;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 218 and b.x = 217;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 219 and b.x = 218;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 220 and b.x = 219;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 221 and b.x = 220;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 222 and b.x = 221;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 223 and b.x = 222;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 224 and b.x = 223;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 225 and b.x = 224;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 226 and b.x = 225;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 227 and b.x = 226;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 228 and b.x = 227;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 229 and b.x = 228;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 230 and b.x = 229;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 231 and b.x = 230;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 232 and b.x = 231;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 233 and b.x = 232;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 234 and b.x = 233;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 235 and b.x = 234;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 236 and b.x = 235;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 237 and b.x = 236;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 238 and b.x = 237;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 239 and b.x = 238;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 240 and b.x = 239;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 241 and b.x = 240;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 242 and b.x = 241;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 243 and b.x = 242;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 244 and b.x = 243;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 245 and b.x = 244;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 246 and b.x = 245;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 247 and b.x = 246;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 248 and b.x = 247;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 249 and b.x = 248;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 250 and b.x = 249;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 251 and b.x = 250;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 252 and b.x = 251;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 253 and b.x = 252;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 254 and b.x = 253;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 255 and b.x = 254;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 256 and b.x = 255;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 257 and b.x = 256;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 258 and b.x = 257;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 259 and b.x = 258;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 260 and b.x = 259;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 261 and b.x = 260;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 262 and b.x = 261;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 263 and b.x = 262;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 264 and b.x = 263;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 265 and b.x = 264;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 266 and b.x = 265;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 267 and b.x = 266;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 268 and b.x = 267;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 269 and b.x = 268;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 270 and b.x = 269;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 271 and b.x = 270;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 272 and b.x = 271;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 273 and b.x = 272;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 274 and b.x = 273;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 275 and b.x = 274;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 276 and b.x = 275;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 277 and b.x = 276;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 278 and b.x = 277;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 279 and b.x = 278;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 280 and b.x = 279;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 281 and b.x = 280;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 282 and b.x = 281;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 283 and b.x = 282;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 284 and b.x = 283;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 285 and b.x = 284;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 286 and b.x = 285;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 287 and b.x = 286;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 288 and b.x = 287;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 289 and b.x = 288;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 290 and b.x = 289;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 291 and b.x = 290;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 292 and b.x = 291;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 293 and b.x = 292;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 294 and b.x = 293;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 295 and b.x = 294;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 296 and b.x = 295;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 297 and b.x = 296;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 298 and b.x = 297;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 299 and b.x = 298;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 300 and b.x = 299;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 301 and b.x = 300;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 302 and b.x = 301;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 303 and b.x = 302;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 304 and b.x = 303;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 305 and b.x = 304;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 306 and b.x = 305;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 307 and b.x = 306;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 308 and b.x = 307;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 309 and b.x = 308;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 310 and b.x = 309;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 311 and b.x = 310;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 312 and b.x = 311;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 313 and b.x = 312;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 314 and b.x = 313;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 315 and b.x = 314;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 316 and b.x = 315;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 317 and b.x = 316;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 318 and b.x = 317;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 319 and b.x = 318;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 320 and b.x = 319;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 321 and b.x = 320;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 322 and b.x = 321;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 323 and b.x = 322;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 324 and b.x = 323;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 325 and b.x = 324;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 326 and b.x = 325;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 327 and b.x = 326;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 328 and b.x = 327;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 329 and b.x = 328;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 330 and b.x = 329;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 331 and b.x = 330;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 332 and b.x = 331;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 333 and b.x = 332;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 334 and b.x = 333;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 335 and b.x = 334;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 336 and b.x = 335;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 337 and b.x = 336;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 338 and b.x = 337;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 339 and b.x = 338;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 340 and b.x = 339;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 341 and b.x = 340;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 342 and b.x = 341;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 343 and b.x = 342;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 344 and b.x = 343;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 345 and b.x = 344;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 346 and b.x = 345;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 347 and b.x = 346;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 348 and b.x = 347;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 349 and b.x = 348;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 350 and b.x = 349;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment