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

system sh/deploy.sh -n dnode1 -i 1
H
hjxilinx 已提交
4
system sh/cfg.sh -n dnode1 -c walLevel -v 0
S
slguan 已提交
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 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225
system sh/exec.sh -n dnode1 -s start
sleep 3000
sql connect

$dbPrefix = db
$tbPrefix = tb
$mtPrefix = 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, tbcol2 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
    $ms = $x . m 
	
	$v1 = $x 
	$v2 = $x
	if $x == 0 then
	  $v1 = NULL
	endi
    sql insert into $tb values (now + $ms , $v1 , $v2 ) 
    $x = $x + 1
  endw 
 
  $i = $i + 1
endw 

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

sql select * from $tb
print $data00 $data01 $data02
if $data01 != null then
  return -1
endi
if $data02 != 0 then
  return -1
endi
if $rows != 20 then
  return -1
endi

print =============== step3
sql select count(tbcol), count(tbcol2), avg(tbcol), avg(tbcol2), sum(tbcol), sum(tbcol2) from $tb 
print ===> $data00 $data01 $data02 $data03 $data04 $data05 
if $data00 != 19 then 
  return -1
endi
if $data01 != 20 then 
  return -1
endi
if $data02 != 10.000000000 then 
  return -1
endi
if $data03 != 9.500000000 then 
  return -1
endi
if $data04 != 190 then 
  return -1
endi
if $data05 != 190 then 
  return -1
endi

print =============== step4
sql select * from $tb  where tbcol2 = 19
print ===> $data01 $data02
if $rows != 1 then 
  return -1
endi
if $data01 != 19 then 
  return -1
endi
if $data02 != 19 then 
  return -1
endi

sql select * from $tb  where tbcol = NULL -x step3
  return -1
step3:

print =============== step5
sql create table $tb using $mt tags( NULL )
#  return -1
#step51:

#sql alter table $tb set tgcol=NULL -x step52
#  return -1
#step52:

sql select * from $mt  where tgcol = NULL -x step5
  return -1
step5:

print =============== step6
sql select count(tbcol), count(tbcol2), avg(tbcol), avg(tbcol2), sum(tbcol), sum(tbcol2) from $mt 
print ===> $data00 $data01 $data02 $data03 $data04 $data05 
if $data00 != 190 then 
  return -1
endi
if $data01 != 200 then 
  return -1
endi
if $data02 != 10.000000000 then 
  return -1
endi
if $data03 != 9.500000000 then 
  return -1
endi
if $data04 != 1900 then 
  return -1
endi
if $data05 != 1900 then 
  return -1
endi

print =============== step7
sql create table t1 (ts timestamp, i bool)
sql create table t2 (ts timestamp, i smallint)
sql create table t3 (ts timestamp, i tinyint)
sql create table t4 (ts timestamp, i int)
sql create table t5 (ts timestamp, i bigint)
sql create table t6 (ts timestamp, i float)
sql create table t7 (ts timestamp, i double)
sql create table t8 (ts timestamp, i binary(10))
sql insert into t1 values(now, NULL)
sql insert into t2 values(now, NULL)
sql insert into t3 values(now, NULL)
sql insert into t4 values(now, NULL)
sql insert into t5 values(now, NULL)
sql insert into t6 values(now, NULL)
sql insert into t7 values(now, NULL)
#sql insert into t8 values(now, NULL)

#sql select * from t1
#if $rows != 1 then 
#  return -1
#endi
#if $data01 != NULL then 
#  return -1
#endi

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

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

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

sql select * from t5
if $rows != 1 then 
  return -1
endi
if $data01 != null then
  return -1
endi

sql select * from t6
if $rows != 1 then 
  return -1
endi
if $data01 != null then
  return -1
endi

sql select * from t7
if $rows != 1 then 
  return -1
endi
if $data01 != null then
  return -1
endi

#sql select * from t8
#if $rows != 1 then 
#  return -1
#endi
#if $data01 != null then
#  return -1
#endi

print =============== clear
sql drop database $db
sql show databases
if $rows != 0 then 
  return -1
endi