system sh/stop_dnodes.sh
system sh/deploy.sh -n dnode1 -i 1
system sh/deploy.sh -n dnode2 -i 2
system sh/deploy.sh -n dnode3 -i 3
system sh/deploy.sh -n dnode4 -i 4
system sh/cfg.sh -n dnode1 -c supportVnodes -v 0
system sh/exec.sh -n dnode1 -s start
system sh/exec.sh -n dnode2 -s start
system sh/exec.sh -n dnode3 -s start
system sh/exec.sh -n dnode4 -s start
sql connect

print =============== step1: create dnodes
sql create dnode $hostname port 7200
sql create dnode $hostname port 7300
sql create dnode $hostname port 7400

$x = 0
step1:
	$x = $x + 1
	sleep 1000
	if $x == 10 then
	  print ====> dnode not ready!
		return -1
	endi
sql select * from information_schema.ins_dnodes
print ===> rows: $rows
print ===> $data00 $data01 $data02 $data03 $data04 $data05
print ===> $data10 $data11 $data12 $data13 $data14 $data15
print ===> $data20 $data21 $data22 $data23 $data24 $data25
print ===> $data30 $data31 $data32 $data33 $data24 $data35
if $rows != 4 then
  return -1
endi
if $data(1)[4] != ready then
  goto step1
endi
if $data(2)[4] != ready then
  goto step1
endi
if $data(3)[4] != ready then
  goto step1
endi
if $data(4)[4] != ready then
  goto step1
endi

print =============== step2: create database
sql create database db vgroups 4 replica 3
sql select * from information_schema.ins_databases
if $rows != 3 then
  return -1
endi
if $data(db)[4] != 3 then
  return -1
endi

# vnodes
sql select * from information_schema.ins_dnodes
if $data(2)[2] != 4 then
  return -1
endi
if $data(3)[2] != 4 then
  return -1
endi
if $data(4)[2] != 4 then
  return -1
endi

# v1_dnode
$hasleader = 0
$x = 0
step2:
	$x = $x + 1
	sleep 1000
	if $x == 20 then
	  print ====> dnode not ready!
		return -1
	endi
sql show db.vgroups
print ===> $data00 $data01 $data02 $data03 $data04 $data05 $data06 $data07 $data08
if $data(2)[3] != 2 then
  return -1
endi
if $data(2)[5] != 3 then
  return -1
endi
if $data(2)[7] != 4 then
  return -1
endi
if $data(2)[4] == leader then
  $hasleader = 1
endi
if $data(2)[6] == leader then
  $hasleader = 1
endi
if $data(2)[8] == leader then
  $hasleader = 1
endi
if $hasleader != 1 then
  goto step2
endi

sql create table db.stb (ts timestamp, c1 int, c2 binary(4)) tags(t1 int, t2 binary(16)) comment "abd"
sql create table db.ctb0 using db.stb tags(100, "100")
sql create table db.ctb1 using db.stb tags(101, "101")
sql create table db.ctb2 using db.stb tags(102, "102")
sql create table db.ctb3 using db.stb tags(103, "103")
sql create table db.ctb4 using db.stb tags(104, "104")
sql create table db.ctb5 using db.stb tags(105, "105")
sql create table db.ctb6 using db.stb tags(106, "106")
sql create table db.ctb7 using db.stb tags(107, "107")
sql create table db.ctb8 using db.stb tags(108, "108")
sql create table db.ctb9 using db.stb tags(109, "109")
sql insert into db.ctb0 values(now, 0, "0")
sql insert into db.ctb1 values(now, 1, "1")
sql insert into db.ctb2 values(now, 2, "2")
sql insert into db.ctb3 values(now, 3, "3")
sql insert into db.ctb4 values(now, 4, "4")
sql insert into db.ctb5 values(now, 5, "5")
sql insert into db.ctb6 values(now, 6, "6")
sql insert into db.ctb7 values(now, 7, "7")
sql insert into db.ctb8 values(now, 8, "8")
sql insert into db.ctb9 values(now, 9, "9")

sql show db.vgroups
print ===> $data00 $data01 $data02 $data03 $data04 $data05 $data06 $data07 $data08

sql select * from db.ctb0
if $rows != 1 then
  return -1
endi

sql select * from db.ctb1
if $rows != 1 then
  return -1
endi

sql select * from db.ctb2
if $rows != 1 then
  return -1
endi

sql select * from db.stb
if $rows != 10 then
  return -1
endi

print ============= step3: alter database
sql alter database db replica 1
wt = 0
 stepwt1:
 	$wt = $wt + 1
 	sleep 1000
 	if $wt == 200 then
 	  print ====> dnode not ready!
 		return -1
 	endi
sql show transactions
if $rows != 0 then
  print wait 1 seconds to alter
  goto stepwt1
endi

sql show db.vgroups
print ---> $data00 $data01 $data02 $data03 $data04 $data05 $data06 $data07 $data08 $data09
print ---> $data10 $data11 $data12 $data13 $data14 $data15 $data16 $data27 $data28 $data29
print ---> $data10 $data11 $data12 $data13 $data14 $data15 $data26 $data37 $data38 $data39
print ---> $data10 $data11 $data12 $data13 $data14 $data15 $data36 $data47 $data48 $data49

$hasleader = 0

$x = 0
step3:
	$x = $x + 1
	sleep 1000
	if $x == 10 then
	  print ====> dnode not ready!
		return -1
	endi
sql show db.vgroups
print ===> rows: $rows
if $rows != 4 then
  goto step3
endi
if $data(2)[4] == leader then
  $hasleader = 1
endi
if $data(2)[6] == leader then
  $hasleader = 1
endi
if $data(2)[8] == leader then
  $hasleader = 1
endi
if $hasleader != 1 then
  goto step3
endi

print ============= step5: stop dnode 2
sql select * from db.ctb0
if $rows != 1 then
  return -1
endi

sql select * from db.ctb1
if $rows != 1 then
  return -1
endi

sql select * from db.ctb2
if $rows != 1 then
  return -1
endi

sql select * from db.stb
if $rows != 10 then
  return -1
endi

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