between_and.sim 3.3 KB
Newer Older
D
dapan1121 已提交
1 2
system sh/stop_dnodes.sh
system sh/deploy.sh -n dnode1 -i 1
H
Haojun Liao 已提交
3
system sh/cfg.sh -n dnode1 -c walLevel -v 1
D
dapan1121 已提交
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165
system sh/cfg.sh -n dnode1 -c maxtablesPerVnode -v 2
system sh/exec.sh -n dnode1 -s start

sleep 100
sql connect
print ======================== dnode1 start

$db = testdb

sql create database $db
sql use $db

sql create stable st2 (ts timestamp, f1 int, f2 float, f3 double, f4 bigint, f5 smallint, f6 tinyint, f7 bool, f8 binary(10), f9 nchar(10)) tags (id1 int, id2 float, id3 nchar(10), id4 double, id5 smallint, id6 bigint, id7 binary(10))

sql create table tb1 using st2 tags (1,1.0,"1",1.0,1,1,"1");
sql create table tb2 using st2 tags (2,2.0,"2",2.0,2,2,"2");
sql create table tb3 using st2 tags (3,3.0,"3",3.0,3,3,"3");
sql create table tb4 using st2 tags (4,4.0,"4",4.0,4,4,"4");
 
sql insert into tb1 values (now-200s,1,1.0,1.0,1,1,1,true,"1","1")
sql insert into tb1 values (now-100s,2,2.0,2.0,2,2,2,true,"2","2")
sql insert into tb1 values (now,3,3.0,3.0,3,3,3,true,"3","3")
sql insert into tb1 values (now+100s,4,4.0,4.0,4,4,4,true,"4","4")
sql insert into tb1 values (now+200s,4,4.0,4.0,4,4,4,true,"4","4")
sql insert into tb1 values (now+300s,4,4.0,4.0,4,4,4,true,"4","4")
sql insert into tb1 values (now+400s,4,4.0,4.0,4,4,4,true,"4","4")
sql insert into tb1 values (now+500s,4,4.0,4.0,4,4,4,true,"4","4")

sql select tbname,id1 from st2;

if $rows != 4 then
  return -1
endi


sql select * from st2;

if $rows != 8 then
  return -1
endi

sql select * from st2 where ts between now-50s and now+450s

if $rows != 5 then
  return -1
endi

sql select tbname,id1 from st2 where id1 between 2 and 3;

if $rows != 2 then
  return -1
endi

if $data00 != tb2 then 
  return -1
endi
if $data01 != 2 then 
  return -1
endi
if $data10 != tb3 then 
  return -1
endi
if $data11 != 3 then 
  return -1
endi

sql select tbname,id2 from st2 where id2 between 2.0 and 3.0;

if $rows != 2 then
  return -1
endi

if $data00 != tb2 then 
  return -1
endi
if $data01 != 2.00000 then 
  return -1
endi
if $data10 != tb3 then 
  return -1
endi
if $data11 != 3.00000 then 
  return -1
endi


sql select tbname,id4 from st2 where id4 between 2.0 and 3.0;

if $rows != 2 then
  return -1
endi

if $data00 != tb2 then 
  return -1
endi
if $data01 != 2.000000000 then 
  return -1
endi
if $data10 != tb3 then 
  return -1
endi
if $data11 != 3.000000000 then 
  return -1
endi


sql select tbname,id5 from st2 where id5 between 2.0 and 3.0;

if $rows != 2 then
  return -1
endi

if $data00 != tb2 then 
  return -1
endi
if $data01 != 2 then 
  return -1
endi
if $data10 != tb3 then 
  return -1
endi
if $data11 != 3 then 
  return -1
endi

sql select tbname,id6 from st2 where id6 between 2.0 and 3.0;

if $rows != 2 then
  return -1
endi

if $data00 != tb2 then 
  return -1
endi
if $data01 != 2 then 
  return -1
endi
if $data10 != tb3 then 
  return -1
endi
if $data11 != 3 then 
  return -1
endi

sql select * from st2 where f1 between 2 and 3 and f2 between 2.0 and 3.0 and f3 between 2.0 and 3.0 and f4 between 2.0 and 3.0 and f5 between 2.0 and 3.0 and f6 between 2.0 and 3.0;

if $rows != 2 then
  return -1
endi

if $data01 != 2 then 
  return -1
endi
if $data11 != 3 then 
  return -1
endi

sql_error select * from st2 where f7 between 2.0 and 3.0;
sql_error select * from st2 where f8 between 2.0 and 3.0;
sql_error select * from st2 where f9 between 2.0 and 3.0;

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