tables.sim

system sh/stop_dnodes.sh


system sh/deploy.sh -n dnode1 -i 1
system sh/cfg.sh -n dnode1 -c commitLog -v 0
system sh/cfg.sh -n dnode1 -c numOfTotalVnodes -v 4
system sh/cfg.sh -n dnode1 -c sessionsPerVnode -v 2000

system sh/exec.sh -n dnode1 -s start
sleep 3000
sql connect

print =============== step2
sql create database db tables 2
sql show databases
print $rows $data07

if $rows != 1 then 
  return -1
endi

if $data07 != 2 then
  return -1
endi

print =============== step3
sql use db
sql create table t1 (ts timestamp, i int)
sql create table t2 (ts timestamp, i int)
sql create table t3 (ts timestamp, i int)
sql create table t4 (ts timestamp, i int)
sql create table t11 (ts timestamp, i int)
sql create table t22 (ts timestamp, i int)
sql create table t33 (ts timestamp, i int)
sql create table t44 (ts timestamp, i int)

print =============== step4
sql insert into t1 values(now, 1)
sql insert into t2 values(now, 2)
sql insert into t3 values(now, 3)
sql insert into t4 values(now, 4)
sql insert into t11 values(now, 1)
sql insert into t22 values(now, 2)
sql insert into t33 values(now, 3)
sql insert into t44 values(now, 4)

print =============== step5
sql select * from t1
if $data01 != 1 then
  return -1
endi

sql select * from t2
if $data01 != 2 then
  return -1
endi

sql select * from t3
if $data01 != 3 then
  return -1
endi

sql select * from t4
if $data01 != 4 then
  return -1
endi

print =============== step6
sql drop database db
sql reset query cache
sleep 20000

print =============== step7
sql create database db tables 2
sql show databases
print $rows $data07

if $rows != 1 then
  return -1
endi

if $data07 != 2 then
  return -1
endi

print =============== step8
sql use db
sql create table t1 (ts timestamp, i int)
sql create table t2 (ts timestamp, i int)
sql create table t3 (ts timestamp, i int)
sql create table t4 (ts timestamp, i int)
sql create table t11 (ts timestamp, i int)
sql create table t22 (ts timestamp, i int)
sql create table t33 (ts timestamp, i int)
sql create table t44 (ts timestamp, i int)

print =============== step9
sql insert into t1 values(now, 1)
sql insert into t2 values(now, 2)
sql insert into t3 values(now, 3)
sql insert into t4 values(now, 4)
sql insert into t11 values(now, 1)
sql insert into t22 values(now, 2)
sql insert into t33 values(now, 3)
sql insert into t44 values(now, 4)

print =============== step10
sql select * from t1
if $data01 != 1 then
  return -1
endi

sql select * from t2
if $data01 != 2 then
  return -1
endi

sql select * from t3
if $data01 != 3 then
  return -1
endi

sql select * from t4
if $data01 != 4 then
  return -1
endi