basic2.sim

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

print =============== one table
sql create database d1
sql create table d1.n1 (ts timestamp, i int)
sql create table d1.n2 (ts timestamp, i int)
sql create table d1.n3 (ts timestamp, i int)
sql create table d1.n4 (ts timestamp, i int)

sql drop table d1.n1
sql drop table d1.n2

sql show d1.tables
if $rows != 2 then 
  return -1
endi

print =============== show
sql show databases
if $data02 != 2 then 
  return -1
endi

if $data03 != 1 then 
  return -1
endi

sql show d1.vgroups
if $data00 != 1 then 
  return -1
endi

if $data01 != 2 then 
  return -1
endi

print =============== insert data1
sql_error insert into d1.n1 values(now, 1)
sql_error insert into d1.n2 values(now, 1)

print =============== insert data2
sql insert into d1.n3 values(now, 1)
sql insert into d1.n3 values(now, 2)
sql insert into d1.n3 values(now, 3)

print =============== query data
sql select * from d1.n3
if $rows != 3 then 
  return -1
endi

if $data01 != 1 then 
  return -1
endi

if $data11 != 2 then 
  return -1
endi

if $data21 != 3 then 
  return -1
endi