count.sim 3.6 KB
Newer Older
S
slguan 已提交
1
system sh/stop_dnodes.sh
S
slguan 已提交
2 3

system sh/deploy.sh -n dnode1 -i 1
4
system sh/cfg.sh -n dnode1 -c walLevel -v 1
S
slguan 已提交
5
system sh/exec.sh -n dnode1 -s start
H
Haojun Liao 已提交
6
sleep 2000
S
slguan 已提交
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
sql connect

$dbPrefix = m_co_db
$tbPrefix = m_co_tb
$mtPrefix = m_co_mt
$tbNum = 10
$rowNum = 20
$totalNum = 200

print =============== step1
$i = 0
$db = $dbPrefix . $i
$mt = $mtPrefix . $i

sql drop database $db -x step1
step1:
sql create database $db
sql use $db
sql create table $mt (ts timestamp, tbcol int) TAGS(tgcol int)

$i = 0
while $i < $tbNum
  $tb = $tbPrefix . $i
  sql create table $tb using $mt tags( $i )
  
  $x = 0
  while $x < $rowNum
34 35 36 37
    $cc = $x * 60000
    $ms = 1601481600000 + $cc

    sql insert into $tb values ($ms , $x ) 
S
slguan 已提交
38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
    $x = $x + 1
  endw 
 
  $i = $i + 1
endw 

sleep 100

print =============== step2
$i = 1
$tb = $tbPrefix . $i


sql select count(*) from $tb
print ===> select count(*) from $tb => $data00
if $data00 != $rowNum then 
  return -1
endi

Y
yihaoDeng 已提交
57 58 59 60 61 62
sql select count(1) from $tb
print ===> select count(1) from $tb => $data00
if $data00 != $rowNum then 
  return -1
endi

S
slguan 已提交
63 64 65 66 67 68 69
sql select count(tbcol) from $tb
print ===> $data00
if $data00 != $rowNum then 
  return -1
endi

print =============== step3
70 71 72
$cc = 4 * 60000
$ms = 1601481600000 + $cc
sql select count(tbcol) from $tb where ts <= $ms
S
slguan 已提交
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
print ===> $data00
if $data00 != 5 then 
  return -1
endi

print =============== step4
sql select count(tbcol) as b from $tb
print ===> $data00
if $data00 != $rowNum then 
  return -1
endi

print =============== step5
sql select count(tbcol) as b from $tb interval(1m)
print ===> $data01
if $data01 != 1 then 
  return -1
endi

sql select count(tbcol) as b from $tb interval(1d)
print ===> $data01
if $data01 != $rowNum then 
  return -1
endi

print =============== step6
99 100 101
$cc = 4 * 60000
$ms = 1601481600000 + $cc
sql select count(tbcol) as b from $tb where ts <= $ms interval(1m)
S
slguan 已提交
102 103 104 105 106 107 108 109 110 111 112 113 114 115 116
print ===> $data01
if $data01 != 1 then 
  return -1
endi
if $rows != 5 then 
  return -1
endi

print =============== step7
sql select count(*) from $mt
print ===> $data00
if $data00 != $totalNum then 
  return -1
endi

Y
yihaoDeng 已提交
117 118 119 120 121 122 123
print =============== step8
sql select count(1) from $mt
print ===> $data00
if $data00 != $totalNum then 
  return -1
endi

S
slguan 已提交
124 125 126 127 128 129
sql select count(tbcol) from $mt
print ===> $data00
if $data00 != $totalNum then 
  return -1
endi

Y
yihaoDeng 已提交
130
print =============== step10
131 132 133
$cc = 4 * 60000
$ms = 1601481600000 + $cc
sql select count(tbcol) as c from $mt where ts <= $ms
S
slguan 已提交
134 135 136 137 138 139 140 141 142 143 144
print ===> $data00
if $data00 != 50 then 
  return -1
endi

sql select count(tbcol) as c from $mt where tgcol < 5
print ===> $data00
if $data00 != 100 then 
  return -1
endi

145 146 147
$cc = 4 * 60000
$ms = 1601481600000 + $cc
sql select count(tbcol) as c from $mt where tgcol < 5 and ts <= $ms
S
slguan 已提交
148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180
print ===> $data00
if $data00 != 25 then 
  return -1
endi

print =============== step9
sql select count(tbcol) as b from $mt interval(1m)
print ===> $data01
if $data01 != 10 then 
  return -1
endi
if $data11 != 10 then 
  return -1
endi

sql select count(tbcol) as b from $mt interval(1d)
print ===> $data01
if $data01 != 200 then 
  return -1
endi

print =============== step10
sql select count(tbcol) as b from $mt group by tgcol
print ===> $data00
if $data00 != $rowNum then 
  return -1
endi

if $rows != $tbNum then 
  return -1
endi

print =============== step11
181 182 183
$cc = 4 * 60000
$ms = 1601481600000 + $cc
sql select count(tbcol) as b from $mt  where ts <= $ms interval(1m) group by tgcol
S
slguan 已提交
184 185 186 187 188 189 190 191 192 193 194 195 196
print ===> $data01
if $data01 != 1 then 
  return -1
endi
if $rows != 50 then 
  return -1
endi

print =============== clear
sql drop database $db
sql show databases
if $rows != 0 then 
  return -1
guanshengliang's avatar
scripts  
guanshengliang 已提交
197 198
endi

Y
yihaoDeng 已提交
199
system sh/exec.sh -n dnode1 -s stop -x SIGINT