gistfile1.sql

create table ten(a int);
insert into ten values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

create table one_k(a int);
insert into one_k select A.a + B.a* 10 + C.a * 100 from ten A, ten B, ten C;

create table r100 (
  id int primary key,
  value1 int, 
  value2 int, 
  value3 int, 
  value4 int, 
  value5 int, 
  value6 int, 
  value7 int, 
  value8 int, 
  value9 int, 
  value10 int, 
  value11 int, 
  value12 int, 
  value13 int, 
  value14 int, 
  value15 int, 
  value16 int, 
  value17 int, 
  value18 int, 
  value19 int, 
  value20 int, 
  value21 int, 
  value22 int, 
  value23 int, 
  value24 int, 
  value25 int, 
  value26 int, 
  value27 int, 
  value28 int, 
  value29 int, 
  value30 int, 
  value31 int, 
  value32 int, 
  value33 int, 
  value34 int, 
  value35 int, 
  value36 int, 
  value37 int, 
  value38 int, 
  value39 int, 
  value40 int, 
  value41 int, 
  value42 int, 
  value43 int, 
  value44 int, 
  value45 int, 
  value46 int, 
  value47 int, 
  value48 int, 
  value49 int, 
  value50 int, 
  value51 int, 
  value52 int, 
  value53 int, 
  value54 int, 
  value55 int, 
  value56 int, 
  value57 int, 
  value58 int, 
  value59 int, 
  value60 int, 
  value61 int, 
  value62 int, 
  value63 int, 
  value64 int, 
  value65 int, 
  value66 int, 
  value67 int, 
  value68 int, 
  value69 int, 
  value70 int, 
  value71 int, 
  value72 int, 
  value73 int, 
  value74 int, 
  value75 int, 
  value76 int, 
  value77 int, 
  value78 int, 
  value79 int, 
  value80 int, 
  value81 int, 
  value82 int, 
  value83 int, 
  value84 int, 
  value85 int, 
  value86 int, 
  value87 int, 
  value88 int, 
  value89 int, 
  value90 int, 
  value91 int, 
  value92 int, 
  value93 int, 
  value94 int, 
  value95 int, 
  value96 int, 
  value97 int, 
  value98 int, 
  value99 int, 
  value100 int,
  key(value1)
) engine=rocksdb;

set @a:=-1;
# insert into r100 select
#   @a:=@a+1,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a
# from one_k;



set @a:=-1;
insert into r100 select
@a:=@a+1,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a
from one_k A, one_k B;