insert1.sim

system sh/stop_dnodes.sh

system sh/deploy.sh -n dnode1 -i 1
system sh/cfg.sh -n dnode1 -c wallevel -v 2
system sh/exec.sh -n dnode1 -s start

sleep 2000
sql connect

print ======== step1 
sql create database d3
sql use d3
sql create table tb (ts timestamp, a int)
sql insert into tb values(now-28d, -28)
sql select * from tb order by ts desc
print $data00 $data01 $data02 $data03 $data04 $data05 $data06

if $rows != 1 then
  return -1
endi
if $data01 != -28 then
  return -1
endi
if $data02 != null then
  return -1
endi
if $data03 != null then
  return -1
endi
if $data04 != null then
  return -1
endi
if $data05 != null then
  return -1
endi
if $data06 != null then
  return -1
endi
if $data07 != null then
  return -1
endi
if $data08 != null then
  return -1
endi

print ======== step2
sql alter table tb add column b smallint
sql insert into tb values(now-25d, -25, 0)
sql select * from tb order by ts desc
print $data00 $data01 $data02 $data03 $data04 $data05 $data06
print $data10 $data11 $data12 $data13 $data14 $data15 $data16
if $rows != 2 then
  return -1
endi
if $data01 != -25 then
  return -1
endi
if $data11 != -28 then
  return -1
endi
if $data02 != 0 then
  return -1
endi
if $data12 != NULL then
  return -1
endi
if $data13 != null then
  return -1
endi
if $data14 != null then
  return -1
endi
if $data15 != null then
  return -1
endi
if $data16 != null then
  return -1
endi
if $data17 != null then
  return -1
endi
if $data18 != null then
  return -1
endi

print ======== step3
sql alter table tb add column c tinyint
sql insert into tb values(now-22d, -22, 3, 0)
sql select * from tb order by ts asc
print $data00 $data01 $data02 $data03 $data04 $data05 $data06
print $data10 $data11 $data12 $data13 $data14 $data15 $data16
print $data20 $data21 $data22 $data23 $data24 $data25 $data26
if $rows != 3 then then
  return -1
endi
if $data01 != -28 then
  return -1
endi
if $data02 != NULL then
  return -1
endi
if $data03 != NULL then
  return -1
endi
if $data04 != null then
  return -1
endi
if $data05 != null then
  return -1
endi
if $data06 != null then
  return -1
endi
if $data07 != null then
  return -1
endi
if $data08 != null then
  return -1
endi
if $data11 != -25 then
  return -1
endi
if $data12 != 0 then
  return -1
endi
if $data13 != NULL then
  return -1
endi
if $data14 != null then
  return -1
endi
if $data15 != null then
  return -1
endi
if $data16 != null then
  return -1
endi
if $data17 != null then
  return -1
endi
if $data18 != null then
  return -1
endi
if $data21 != -22 then
  return -1
endi
if $data22 != 3 then
  return -1
endi
if $data23 != 0 then
  return -1
endi
if $data24 != null then
  return -1
endi
if $data25 != null then
  return -1
endi
if $data26 != null then
  return -1
endi
if $data27 != null then
  return -1
endi
if $data28 != null then
  return -1
endi

print ======== step4
sql alter table tb add column d int
sql insert into tb values(now-19d, -19, 6, 3, 0)
sql select * from tb order by ts asc
if $rows != 4 then then
  return -1
endi
if $data01 != -28 then
  return -1
endi
if $data02 != NULL then
  return -1
endi
if $data03 != NULL then
  return -1
endi
if $data04 != NULL then
  return -1
endi
if $data05 != null then
  return -1
endi
if $data06 != null then
  return -1
endi
if $data07 != null then
  return -1
endi
if $data08 != null then
  return -1
endi
if $data11 != -25 then
  return -1
endi
if $data12 != 0 then
  return -1
endi
if $data13 != NULL then
  return -1
endi
if $data14 != NULL then
  return -1
endi
if $data15 != null then
  return -1
endi
if $data16 != null then
  return -1
endi
if $data17 != null then
  return -1
endi
if $data18 != null then
  return -1
endi
if $data21 != -22 then
  return -1
endi
if $data22 != 3 then
  return -1
endi
if $data23 != 0 then
  return -1
endi
if $data24 != NULL then
  return -1
endi
if $data25 != null then
  return -1
endi
if $data26 != null then
  return -1
endi
if $data27 != null then
  return -1
endi
if $data28 != null then
  return -1
endi
if $data31 != -19 then
  return -1
endi
if $data32 != 6 then
  return -1
endi
if $data33 != 3 then
  return -1
endi
if $data34 != 0 then
  return -1
endi
if $data35 != null then
  return -1
endi
if $data36 != null then
  return -1
endi
if $data37 != null then
  return -1
endi
if $data38 != null then
  return -1
endi

print ======== step5
sql alter table tb add column e bigint
sql insert into tb values(now-16d, -16, 9, 5, 4, 3)
sql select count(e) from tb
if $data00 != 1 then
  return -1
endi
sql select count(c) from tb
if $data00 != 3 then then
  return -1
endi
sql select * from tb order by ts asc
if $rows != 5 then then
  return -1
endi
if $data01 != -28 then
  return -1
endi
if $data02 != NULL then
  return -1
endi
if $data03 != NULL then
  return -1
endi
if $data04 != NULL then
  return -1
endi
if $data05 != NULL then
  return -1
endi
if $data06 != null then
  return -1
endi
if $data07 != null then
  return -1
endi
if $data08 != null then
  return -1
endi
if $data11 != -25 then
  return -1
endi
if $data12 != 0 then
  return -1
endi
if $data13 != NULL then
  return -1
endi
if $data14 != NULL then
  return -1
endi
if $data15 != NULL then
  return -1
endi
if $data16 != null then
  return -1
endi
if $data17 != null then
  return -1
endi
if $data18 != null then
  return -1
endi
if $data21 != -22 then
  return -1
endi
if $data22 != 3 then
  return -1
endi
if $data23 != 0 then
  return -1
endi
if $data24 != NULL then
  return -1
endi
if $data25 != NULL then
  return -1
endi
if $data26 != null then
  return -1
endi
if $data27 != null then
  return -1
endi
if $data28 != null then
  return -1
endi
if $data31 != -19 then
  return -1
endi
if $data32 != 6 then
  return -1
endi
if $data33 != 3 then
  return -1
endi
if $data34 != 0 then
  return -1
endi
if $data35 != NULL then
  return -1
endi
if $data36 != null then
  return -1
endi
if $data37 != null then
  return -1
endi
if $data38 != null then
  return -1
endi
if $data41 != -16 then
  return -1
endi
if $data42 != 9 then
  return -1
endi
if $data43 != 5 then
  return -1
endi
if $data44 != 4 then
  return -1
endi
if $data45 != 3 then
  return -1
endi
if $data46 != null then
  return -1
endi
if $data47 != null then
  return -1
endi
if $data48 != null then
  return -1
endi

print ======== step6
sql alter table tb add column f float
sql insert into tb values(now-13d, -13, 12, 11, 10, 9, 8)
sql select * from tb order by ts asc
if $rows != 6 then then
  return -1
endi
if $data01 != -28 then
  return -1
endi
if $data02 != NULL then
  return -1
endi
if $data03 != NULL then
  return -1
endi
if $data04 != NULL then
  return -1
endi
if $data05 != NULL then
  return -1
endi
if $data06 != NULL then
  return -1
endi
if $data07 != null then
  return -1
endi
if $data08 != null then
  return -1
endi
if $data11 != -25 then
  return -1
endi
if $data12 != 0 then
  return -1
endi
if $data13 != NULL then
  return -1
endi
if $data14 != NULL then
  return -1
endi
if $data15 != NULL then
  return -1
endi
if $data16 != NULL then
  return -1
endi
if $data17 != null then
  return -1
endi
if $data18 != null then
  return -1
endi
if $data21 != -22 then
  return -1
endi
if $data22 != 3 then
  return -1
endi
if $data23 != 0 then
  return -1
endi
if $data24 != NULL then
  return -1
endi
if $data25 != NULL then
  return -1
endi
if $data26 != NULL then
  return -1
endi
if $data27 != null then
  return -1
endi
if $data28 != null then
  return -1
endi
if $data31 != -19 then
  return -1
endi
if $data32 != 6 then
  return -1
endi
if $data33 != 3 then
  return -1
endi
if $data34 != 0 then
  return -1
endi
if $data35 != NULL then
  return -1
endi
if $data36 != NULL then
  return -1
endi
if $data37 != null then
  return -1
endi
if $data38 != null then
  return -1
endi
if $data41 != -16 then
  return -1
endi
if $data42 != 9 then
  return -1
endi
if $data43 != 5 then
  return -1
endi
if $data44 != 4 then
  return -1
endi
if $data45 != 3 then
  return -1
endi
if $data46 != NULL then
  return -1
endi
if $data47 != null then
  return -1
endi
if $data48 != null then
  return -1
endi
if $data51 != -13 then
  return -1
endi
if $data52 != 12 then
  return -1
endi
if $data53 != 11 then
  return -1
endi
if $data54 != 10 then
  return -1
endi
if $data55 != 9 then
  return -1
endi
if $data56 != 8.00000 then
  return -1
endi
if $data57 != null then
  return -1
endi
if $data58 != null then
  return -1
endi

print ======== step7
sql alter table tb add column g double
sql insert into tb values(now-10d, -10, 15, 14, 13, 12, 11, 10)
sql select * from tb order by ts asc
if $rows != 7 then
  return -1
endi
if $data01 != -28 then
  return -1
endi
if $data02 != NULL then
  return -1
endi
if $data03 != NULL then
  return -1
endi
if $data04 != NULL then
  return -1
endi
if $data05 != NULL then
  return -1
endi
if $data06 != NULL then
  return -1
endi
if $data07 != NULL then
  return -1
endi
if $data08 != null then
  return -1
endi
if $data11 != -25 then
  return -1
endi
if $data12 != 0 then
  return -1
endi
if $data13 != NULL then
  return -1
endi
if $data14 != NULL then
  return -1
endi
if $data15 != NULL then
  return -1
endi
if $data16 != NULL then
  return -1
endi
if $data17 != NULL then
  return -1
endi
if $data18 != null then
  return -1
endi
if $data21 != -22 then
  return -1
endi
if $data22 != 3 then
  return -1
endi
if $data23 != 0 then
  return -1
endi
if $data24 != NULL then
  return -1
endi
if $data25 != NULL then
  return -1
endi
if $data26 != NULL then
  return -1
endi
if $data27 != NULL then
  return -1
endi
if $data28 != null then
  return -1
endi
if $data31 != -19 then
  return -1
endi
if $data32 != 6 then
  return -1
endi
if $data33 != 3 then
  return -1
endi
if $data34 != 0 then
  return -1
endi
if $data35 != NULL then
  return -1
endi
if $data36 != NULL then
  return -1
endi
if $data37 != NULL then
  return -1
endi
if $data38 != null then
  return -1
endi
if $data41 != -16 then
  return -1
endi
if $data42 != 9 then
  return -1
endi
if $data43 != 5 then
  return -1
endi
if $data44 != 4 then
  return -1
endi
if $data45 != 3 then
  return -1
endi
if $data46 != NULL then
  return -1
endi
if $data47 != NULL then
  return -1
endi
if $data48 != null then
  return -1
endi
if $data51 != -13 then
  return -1
endi
if $data52 != 12 then
  return -1
endi
if $data53 != 11 then
  return -1
endi
if $data54 != 10 then
  return -1
endi
if $data55 != 9 then
  return -1
endi
if $data56 != 8.00000 then
  return -1
endi
if $data57 != NULL then
  return -1
endi
if $data58 != null then
  return -1
endi
if $data61 != -10 then
  return -1
endi
if $data62 != 15 then
  return -1
endi
if $data63 != 14 then
  return -1
endi
if $data64 != 13 then
  return -1
endi
if $data65 != 12 then
  return -1
endi
if $data66 != 11.00000 then
  return -1
endi
if $data67 != 10.000000000 then
  return -1
endi
if $data68 != null then
  return -1
endi

print ======== step8
sql alter table tb add column h binary(10)
sql insert into tb values(now-7d, -7, 18, 17, 16, 15, 14, 13, '11')
sql select * from tb order by ts asc
if $rows != 8 then
  return -1
endi
if $data01 != -28 then
  return -1
endi
if $data02 != NULL then
  return -1
endi
if $data03 != NULL then
  return -1
endi
if $data04 != NULL then
  return -1
endi
if $data05 != NULL then
  return -1
endi
if $data06 != NULL then
  return -1
endi
if $data07 != NULL then
  return -1
endi
if $data08 != NULL then
  return -1
endi
if $data11 != -25 then
  return -1
endi
if $data12 != 0 then
  return -1
endi
if $data13 != NULL then
  return -1
endi
if $data14 != NULL then
  return -1
endi
if $data15 != NULL then
  return -1
endi
if $data16 != NULL then
  return -1
endi
if $data17 != NULL then
  return -1
endi
if $data18 != NULL then
  return -1
endi
if $data21 != -22 then
  return -1
endi
if $data22 != 3 then
  return -1
endi
if $data23 != 0 then
  return -1
endi
if $data24 != NULL then
  return -1
endi
if $data25 != NULL then
  return -1
endi
if $data26 != NULL then
  return -1
endi
if $data27 != NULL then
  return -1
endi
if $data28 != NULL then
  return -1
endi
if $data31 != -19 then
  return -1
endi
if $data32 != 6 then
  return -1
endi
if $data33 != 3 then
  return -1
endi
if $data34 != 0 then
  return -1
endi
if $data35 != NULL then
  return -1
endi
if $data36 != NULL then
  return -1
endi
if $data37 != NULL then
  return -1
endi
if $data38 != NULL then
  return -1
endi
if $data41 != -16 then
  return -1
endi
if $data42 != 9 then
  return -1
endi
if $data43 != 5 then
  return -1
endi
if $data44 != 4 then
  return -1
endi
if $data45 != 3 then
  return -1
endi
if $data46 != NULL then
  return -1
endi
if $data47 != NULL then
  return -1
endi
if $data48 != NULL then
  return -1
endi
if $data51 != -13 then
  return -1
endi
if $data52 != 12 then
  return -1
endi
if $data53 != 11 then
  return -1
endi
if $data54 != 10 then
  return -1
endi
if $data55 != 9 then
  return -1
endi
if $data56 != 8.00000 then
  return -1
endi
if $data57 != NULL then
  return -1
endi
if $data58 != NULL then
  return -1
endi
if $data61 != -10 then
  return -1
endi
if $data62 != 15 then
  return -1
endi
if $data63 != 14 then
  return -1
endi
if $data64 != 13 then
  return -1
endi
if $data65 != 12 then
  return -1
endi
if $data66 != 11.00000 then
  return -1
endi
if $data67 != 10.000000000 then
  return -1
endi
if $data68 != NULL then
  return -1
endi
if $data71 != -7 then
  return -1
endi
if $data72 != 18 then
  return -1
endi
if $data73 != 17 then
  return -1
endi
if $data74 != 16 then
  return -1
endi
if $data75 != 15 then
  return -1
endi
if $data76 != 14.00000 then
  return -1
endi
if $data77 != 13.000000000 then
  return -1
endi
if $data78 != 11 then
  return -1
endi
if $data79 != null then
  return -1
endi

print ======== step9

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

sql select * from tb order by ts asc
if $rows != 8 then
  return -1
endi
if $data01 != -28 then
  return -1
endi
if $data02 != NULL then
  return -1
endi
if $data03 != NULL then
  return -1
endi
if $data04 != NULL then
  return -1
endi
if $data05 != NULL then
  return -1
endi
if $data06 != NULL then
  return -1
endi
if $data07 != NULL then
  return -1
endi
if $data08 != NULL then
  return -1
endi
if $data11 != -25 then
  return -1
endi
if $data12 != 0 then
  return -1
endi
if $data13 != NULL then
  return -1
endi
if $data14 != NULL then
  return -1
endi
if $data15 != NULL then
  return -1
endi
if $data16 != NULL then
  return -1
endi
if $data17 != NULL then
  return -1
endi
if $data18 != NULL then
  return -1
endi
if $data21 != -22 then
  return -1
endi
if $data22 != 3 then
  return -1
endi
if $data23 != 0 then
  return -1
endi
if $data24 != NULL then
  return -1
endi
if $data25 != NULL then
  return -1
endi
if $data26 != NULL then
  return -1
endi
if $data27 != NULL then
  return -1
endi
if $data28 != NULL then
  return -1
endi
if $data31 != -19 then
  return -1
endi
if $data32 != 6 then
  return -1
endi
if $data33 != 3 then
  return -1
endi
if $data34 != 0 then
  return -1
endi
if $data35 != NULL then
  return -1
endi
if $data36 != NULL then
  return -1
endi
if $data37 != NULL then
  return -1
endi
if $data38 != NULL then
  return -1
endi
if $data41 != -16 then
  return -1
endi
if $data42 != 9 then
  return -1
endi
if $data43 != 5 then
  return -1
endi
if $data44 != 4 then
  return -1
endi
if $data45 != 3 then
  return -1
endi
if $data46 != NULL then
  return -1
endi
if $data47 != NULL then
  return -1
endi
if $data48 != NULL then
  return -1
endi
if $data51 != -13 then
  return -1
endi
if $data52 != 12 then
  return -1
endi
if $data53 != 11 then
  return -1
endi
if $data54 != 10 then
  return -1
endi
if $data55 != 9 then
  return -1
endi
if $data56 != 8.00000 then
  return -1
endi
if $data57 != NULL then
  return -1
endi
if $data58 != NULL then
  return -1
endi
if $data61 != -10 then
  return -1
endi
if $data62 != 15 then
  return -1
endi
if $data63 != 14 then
  return -1
endi
if $data64 != 13 then
  return -1
endi
if $data65 != 12 then
  return -1
endi
if $data66 != 11.00000 then
  return -1
endi
if $data67 != 10.000000000 then
  return -1
endi
if $data68 != NULL then
  return -1
endi
if $data71 != -7 then
  return -1
endi
if $data72 != 18 then
  return -1
endi
if $data73 != 17 then
  return -1
endi
if $data74 != 16 then
  return -1
endi
if $data75 != 15 then
  return -1
endi
if $data76 != 14.00000 then
  return -1
endi
if $data77 != 13.000000000 then
  return -1
endi
if $data78 != 11 then
  return -1
endi
if $data79 != null then
  return -1
endi

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