mirror of
https://github.com/taosdata/TDengine
synced 2026-05-24 10:09:01 +00:00
d69c5977db
* restore .gitmodules
* Revert "[TD-13408]<test>: move tests directory out"
This reverts commit 7db7bd9337.
* revert to make tests back
* immigrate file change in stand-alone repo to TDengine
* remove tests repository checkout
Co-authored-by: tangfangzhi <fztang@taosdata.com>
108 lines
No EOL
2.8 KiB
Text
108 lines
No EOL
2.8 KiB
Text
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 100
|
|
sql connect
|
|
|
|
$dbPrefix = slm_db
|
|
$tbPrefix = slm_tb
|
|
$stbPrefix = slm_stb
|
|
$tbNum = 10
|
|
$rowNum = 300
|
|
$totalNum = $tbNum * $rowNum
|
|
$ts0 = 1537146000000
|
|
$delta = 600000
|
|
print ========== slimit.sim
|
|
$i = 0
|
|
$db = $dbPrefix . $i
|
|
$stb = $stbPrefix . $i
|
|
|
|
sql drop database if exists $db
|
|
sql create database $db maxrows 200 cache 16
|
|
print ====== create tables
|
|
sql use $db
|
|
sql create table $stb (ts timestamp, c1 int, c2 bigint, c3 float, c4 double, c5 smallint, c6 tinyint, c7 bool, c8 binary(10), c9 nchar(10)) tags(t1 binary(15), t2 int, t3 bigint, t4 nchar(10), t5 double, t6 bool)
|
|
|
|
$i = 0
|
|
$ts = $ts0
|
|
$halfNum = $tbNum / 2
|
|
while $i < $tbNum
|
|
$tb = $tbPrefix . $i
|
|
$t1 = ' . $tb
|
|
$t1 = $t1 . '
|
|
$t2 = $i
|
|
$t3 = $i
|
|
$t4 = '涛思 . $tb
|
|
$t4 = $t4 . '
|
|
$t5 = $i
|
|
$t6 = true
|
|
sql create table $tb using $stb tags( $t1 , $t2 , $t3 , $t4 , $t5 , $t6 )
|
|
|
|
$x = 0
|
|
while $x < $rowNum
|
|
$xs = $x * $delta
|
|
$ts = $ts0 + $xs
|
|
$c = $x / 10
|
|
$c = $c * 10
|
|
$c = $x - $c
|
|
$binary = 'binary . $c
|
|
$binary = $binary . '
|
|
$nchar = '涛思nchar . $c
|
|
$nchar = $nchar . '
|
|
sql insert into $tb values ( $ts , $c , $c , $c , $c , $c , $c , true, $binary , $nchar )
|
|
$x = $x + 1
|
|
endw
|
|
$ts = $ts + $delta
|
|
sql insert into $tb values ( $ts , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL )
|
|
$i = $i + 1
|
|
endw
|
|
print ====== $db tables created
|
|
|
|
$db = $dbPrefix . 1
|
|
sql drop database if exists $db
|
|
sql create database $db maxrows 200 cache 16
|
|
sql use $db
|
|
sql create table $stb (ts timestamp, c1 int, c2 bigint, c3 float, c4 double, c5 smallint, c6 tinyint, c7 bool, c8 binary(10), c9 nchar(10)) tags(t1 binary(15), t2 int, t3 bigint, t4 nchar(10), t5 double, t6 bool)
|
|
|
|
$i = 0
|
|
$ts = $ts0
|
|
$halfNum = $tbNum / 2
|
|
while $i < $tbNum
|
|
$tb = $tbPrefix . $i
|
|
$t1 = ' . $tb
|
|
$t1 = $t1 . '
|
|
$t2 = $i
|
|
$t3 = $i
|
|
$t4 = '涛思 . $tb
|
|
$t4 = $t4 . '
|
|
$t5 = $i
|
|
$t6 = true
|
|
sql create table $tb using $stb tags( $t1 , $t2 , $t3 , $t4 , $t5 , $t6 )
|
|
|
|
$x = 0
|
|
while $x < $rowNum
|
|
$xs = $x * $delta
|
|
$ts = $ts0 + $xs
|
|
sql insert into $tb values ( $ts , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL )
|
|
$x = $x + 1
|
|
endw
|
|
$i = $i + 1
|
|
endw
|
|
print ====== $db tables created
|
|
|
|
run general/parser/slimit_query.sim
|
|
|
|
print ================== restart server to commit data into disk
|
|
system sh/exec.sh -n dnode1 -s stop -x SIGINT
|
|
sleep 500
|
|
system sh/exec.sh -n dnode1 -s start
|
|
print ================== server restart completed
|
|
sql connect
|
|
sleep 100
|
|
|
|
run general/parser/slimit_query.sim
|
|
|
|
system sh/exec.sh -n dnode1 -s stop -x SIGINT |