basic1.sim

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

print =============== show dnodes
sql show dnodes;
if $rows != 1 then 
  return -1
endi

if $data00 != 1 then 
  return -1
endi

sql show mnodes;
if $rows != 1 then 
  return -1
endi

if $data00 != 1 then 
  return -1
endi

if $data02 != master then 
  return -1
endi

print =============== create dnodes
sql create dnode $hostname port 7200
sleep 2000

sql show dnodes;
if $rows != 2 then 
  return -1
endi

if $data00 != 1 then 
  return -1
endi

if $data10 != 2 then 
  return -1
endi

print $data02
if $data02 != 0 then 
  return -1
endi

if $data12 != 0 then 
  return -1
endi

if $data04 != ready then 
  return -1
endi

if $data14 != ready then 
  return -1
endi

sql show mnodes;
if $rows != 1 then 
  return -1
endi

if $data00 != 1 then 
  return -1
endi

if $data02 != master then 
  return -1
endi

print =============== create drop qnode 1
sql create qnode on dnode 1
sql show qnodes
if $rows != 1 then 
  return -1
endi
if $data00 != 1 then 
  return -1
endi
sql_error create qnode on dnode 1

sql drop qnode on dnode 1
sql show qnodes
if $rows != 0 then 
  return -1
endi
sql_error drop qnode on dnode 1

print =============== create drop qnode 2
sql create qnode on dnode 2
sql show qnodes
if $rows != 1 then 
  return -1
endi
if $data00 != 2 then 
  return -1
endi
sql_error create qnode on dnode 2

sql drop qnode on dnode 2
sql show qnodes
if $rows != 0 then 
  return -1
endi
sql_error drop qnode on dnode 2

print =============== create drop qnodes
sql create qnode on dnode 1
sql create qnode on dnode 2
sql show qnodes
if $rows != 2 then 
  return -1
endi

print =============== restart
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 dnode1 -s start
system sh/exec.sh -n dnode2 -s start

sleep 2000
sql show qnodes
if $rows != 2 then 
  return -1
endi

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