refcount.sim 2.7 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
system sh/stop_dnodes.sh

system sh/deploy.sh -n dnode1 -i 1
system sh/cfg.sh -n dnode1 -c walLevel -v 1
system sh/cfg.sh -n dnode1 -c maxtablesPerVnode -v 4
system sh/exec.sh -n dnode1 -s start

sleep 2000
sql connect

print =============== step1
sql create database d1;
sql use d1;
sql create table d1.t1 (ts timestamp, i int);
sql create table d1.t2 (ts timestamp, i int);
sql create table d1.t3 (ts timestamp, i int);
sql insert into d1.t1 values(now, 1);
sql insert into d1.t2 values(now, 1);
19
# sql drop table d1.t1;
20 21 22
sql drop database d1;

sql show databases;
23
if $rows != 1 then
24 25 26 27 28 29 30 31 32 33 34
  return -1
endi

print =============== step2
sql create database d2;
sql use d2;
sql create table d2.t1 (ts timestamp, i int);
sql create table d2.t2 (ts timestamp, i int);
sql create table d2.t3 (ts timestamp, i int);
sql insert into d2.t1 values(now, 1);
sql insert into d2.t2 values(now, 1);
35 36 37 38 39 40 41 42
# sql drop table d2.t1;
# sql drop table d2.t2;
# sql drop table d2.t3;
#
# sql show d2.tables;
# if $rows != 0 then
#   return -1
# endi
43 44

sql show d2.vgroups;
45
if $rows != 2 then
46 47 48 49 50 51
  return -1
endi

sql drop database d2;

sql show databases;
52
if $rows != 1 then
53 54 55 56 57 58 59 60 61 62 63
  return -1
endi

print =============== step3
sql create database d3;
sql use d3;
sql create table d3.st (ts timestamp, i int) tags (j int);
sql create table d3.t1 using d3.st tags(1);
sql create table d3.t2 using d3.st tags(1);
sql create table d3.t3 using d3.st tags(1);
sql insert into d3.t1 values(now, 1);
64 65 66 67 68 69 70 71
# sql drop table d3.t1;
# sql drop table d3.t2;
# sql drop table d3.t3;
#
# sql show d3.tables;
# if $rows != 0 then
#   return -1
# endi
72 73

sql show d3.vgroups;
74
if $rows != 2 then
75 76 77 78 79 80
  return -1
endi

sql drop database d3;

sql show databases;
81
if $rows != 1 then
82 83 84 85 86 87 88 89 90 91 92
  return -1
endi

print =============== step4
sql create database d4;
sql use d4;
sql create table d4.st (ts timestamp, i int) tags (j int);
sql create table d4.t1 using d4.st tags(1);
sql create table d4.t2 using d4.st tags(1);
sql create table d4.t3 using d4.st tags(1);
sql insert into d4.t1 values(now, 1);
93
# sql drop table d4.t1;
94
sql drop table d4.st;
95 96 97 98 99
#
# sql show d4.tables;
# if $rows != 0 then
#   return -1
# endi
100 101

sql show d4.stables;
102
if $rows != 0 then
103 104 105 106 107 108
  return -1
endi

sql drop database d4;

sql show databases;
109
if $rows != 1 then
110 111 112 113 114 115 116 117 118 119 120
  return -1
endi

print =============== step5
sql create database d5;
sql use d5;
sql create table d5.st (ts timestamp, i int) tags (j int);
sql create table d5.t1 using d5.st tags(1);
sql create table d5.t2 using d5.st tags(1);
sql create table d5.t3 using d5.st tags(1);
sql insert into d5.t1 values(now, 1);
121
# sql drop table d5.t1;
122 123 124 125

sql drop database d5;

sql show databases;
126
if $rows != 1 then
127 128 129 130 131
  return -1
endi

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