table.sim

system sh/stop_dnodes.sh
system sh/deploy.sh -n dnode1 -i 1
system sh/exec.sh -n dnode1 -s start
sql connect

print ======== step1 
sql create database d1
sql use d1
sql create table tb (ts timestamp, a int)
sql insert into tb values(now-28d, -28)
sql insert into tb values(now-27d, -27)
sql insert into tb values(now-26d, -26)
sql select * from tb
if $rows != 3 then
  return -1
endi
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi

print ======== step2
sql alter table tb add column b smallint
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != b then
  return -1
endi
if $data21 != SMALLINT then
  return -1
endi

print ======== step3
sql alter table tb add column c tinyint
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != b then
  return -1
endi
if $data21 != SMALLINT then
  return -1
endi
if $data30 != c then
  return -1
endi
if $data31 != TINYINT then
  return -1
endi

print ======== step4
sql alter table tb add column d int
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != b then
  return -1
endi
if $data21 != SMALLINT then
  return -1
endi
if $data30 != c then
  return -1
endi
if $data31 != TINYINT then
  return -1
endi
if $data40 != d then
  return -1
endi
if $data41 != INT then
  return -1
endi

print ======== step5
sql alter table tb add column e bigint
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != b then
  return -1
endi
if $data21 != SMALLINT then
  return -1
endi
if $data30 != c then
  return -1
endi
if $data31 != TINYINT then
  return -1
endi
if $data40 != d then
  return -1
endi
if $data41 != INT then
  return -1
endi
if $data50 != e then
  return -1
endi
if $data51 != BIGINT then
  return -1
endi

print ======== step6
sql alter table tb add column f float
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != b then
  return -1
endi
if $data21 != SMALLINT then
  return -1
endi
if $data30 != c then
  return -1
endi
if $data31 != TINYINT then
  return -1
endi
if $data40 != d then
  return -1
endi
if $data41 != INT then
  return -1
endi
if $data50 != e then
  return -1
endi
if $data51 != BIGINT then
  return -1
endi
if $data60 != f then
  return -1
endi
if $data61 != FLOAT then
  return -1
endi

print ======== step7
sql alter table tb add column g double
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != b then
  return -1
endi
if $data21 != SMALLINT then
  return -1
endi
if $data30 != c then
  return -1
endi
if $data31 != TINYINT then
  return -1
endi
if $data40 != d then
  return -1
endi
if $data41 != INT then
  return -1
endi
if $data50 != e then
  return -1
endi
if $data51 != BIGINT then
  return -1
endi
if $data60 != f then
  return -1
endi
if $data61 != FLOAT then
  return -1
endi
if $data70 != g then
  return -1
endi
if $data71 != DOUBLE then
  return -1
endi

print ======== step8
sql alter table tb add column h binary(10)
sql select * from tb
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != b then
  return -1
endi
if $data21 != SMALLINT then
  return -1
endi
if $data30 != c then
  return -1
endi
if $data31 != TINYINT then
  return -1
endi
if $data40 != d then
  return -1
endi
if $data41 != INT then
  return -1
endi
if $data50 != e then
  return -1
endi
if $data51 != BIGINT then
  return -1
endi
if $data60 != f then
  return -1
endi
if $data61 != FLOAT then
  return -1
endi
if $data70 != g then
  return -1
endi
if $data71 != DOUBLE then
  return -1
endi
if $data80 != h then
  return -1
endi
if $data81 != VARCHAR then
  return -1
endi
if $data82 != 10 then
  return -1
endi

print ======== step9
print ======== step10
system sh/exec.sh -n dnode1 -s stop -x SIGINT
system sh/exec.sh -n dnode1 -s start

sql use d1
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != b then
  return -1
endi
if $data21 != SMALLINT then
  return -1
endi
if $data30 != c then
  return -1
endi
if $data31 != TINYINT then
  return -1
endi
if $data40 != d then
  return -1
endi
if $data41 != INT then
  return -1
endi
if $data50 != e then
  return -1
endi
if $data51 != BIGINT then
  return -1
endi
if $data60 != f then
  return -1
endi
if $data61 != FLOAT then
  return -1
endi
if $data70 != g then
  return -1
endi
if $data71 != DOUBLE then
  return -1
endi
if $data80 != h then
  return -1
endi
if $data81 != VARCHAR then
  return -1
endi
if $data82 != 10 then
  return -1
endi

print ======== step11
sql alter table drop column a -x step111
  return -1
step111:

sql alter table drop column ts -x step112
  return -1
step112:

sql alter table drop column cdfg -x step113
  return -1
step113:

sql alter table add column a -x step114
  return -1
step114:

sql alter table add column b -x step115
  return -1
step115:

print ======== step12
sql alter table tb drop column b
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != c then
  return -1
endi
if $data21 != TINYINT then
  return -1
endi
if $data30 != d then
  return -1
endi
if $data31 != INT then
  return -1
endi
if $data40 != e then
  return -1
endi
if $data41 != BIGINT then
  return -1
endi
if $data50 != f then
  return -1
endi
if $data51 != FLOAT then
  return -1
endi
if $data60 != g then
  return -1
endi
if $data61 != DOUBLE then
  return -1
endi
if $data70 != h then
  return -1
endi
if $data71 != VARCHAR then
  return -1
endi
if $data72 != 10 then
  return -1
endi

print ======== step13
sql alter table tb drop column c
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != d then
  return -1
endi
if $data21 != INT then
  return -1
endi
if $data30 != e then
  return -1
endi
if $data31 != BIGINT then
  return -1
endi
if $data40 != f then
  return -1
endi
if $data41 != FLOAT then
  return -1
endi
if $data50 != g then
  return -1
endi
if $data51 != DOUBLE then
  return -1
endi
if $data60 != h then
  return -1
endi
if $data61 != VARCHAR then
  return -1
endi
if $data62 != 10 then
  return -1
endi

print ======== step14
sql alter table tb drop column d
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != e then
  return -1
endi
if $data21 != BIGINT then
  return -1
endi
if $data30 != f then
  return -1
endi
if $data31 != FLOAT then
  return -1
endi
if $data40 != g then
  return -1
endi
if $data41 != DOUBLE then
  return -1
endi
if $data50 != h then
  return -1
endi
if $data51 != VARCHAR then
  return -1
endi
if $data52 != 10 then
  return -1
endi

print ======== step15
sql alter table tb drop column e
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != f then
  return -1
endi
if $data21 != FLOAT then
  return -1
endi
if $data30 != g then
  return -1
endi
if $data31 != DOUBLE then
  return -1
endi
if $data40 != h then
  return -1
endi
if $data41 != VARCHAR then
  return -1
endi
if $data42 != 10 then
  return -1
endi

print ======== step16
sql alter table tb drop column f
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != g then
  return -1
endi
if $data21 != DOUBLE then
  return -1
endi
if $data30 != h then
  return -1
endi
if $data31 != VARCHAR then
  return -1
endi
if $data32 != 10 then
  return -1
endi

print ======== step17
sql alter table tb drop column g
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != h then
  return -1
endi
if $data21 != VARCHAR then
  return -1
endi
if $data22 != 10 then
  return -1
endi

print ============= step18
sql alter table tb drop column h
sql describe tb
if $data00 != ts then
  return -1
endi
if $data01 != TIMESTAMP then
  return -1
endi
if $data10 != a then
  return -1
endi
if $data11 != INT then
  return -1
endi
if $data20 != null then
  return -1
endi

print ======= over
sql drop database d1
sql select * from information_schema.ins_databases
if $rows != 2 then
  return -1
endi

system sh/exec.sh -n dnode1 -s stop -x SIGINT