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>
214 lines
4.2 KiB
Text
214 lines
4.2 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/cfg.sh -n dnode1 -c cache -v 1
|
|
system sh/exec.sh -n dnode1 -s start
|
|
|
|
sleep 100
|
|
sql connect
|
|
|
|
sql drop database if exists cdb
|
|
sql create database if not exists cdb
|
|
sql use cdb
|
|
|
|
sql create table stb4 (ts timestamp, c1 int, c2 float, c3 bigint, c4 smallint, c5 tinyint, c6 double, c7 bool, c8 binary(10), c9 nchar(9),c10 binary(16300)) TAGS(t1 int, t2 binary(10), t3 double)
|
|
|
|
sql create table tb4_0 using stb4 tags(0,'0',0.0)
|
|
sql create table tb4_1 using stb4 tags(1,'1',1.0)
|
|
sql create table tb4_2 using stb4 tags(2,'2',2.0)
|
|
sql create table tb4_3 using stb4 tags(3,'3',3.0)
|
|
sql create table tb4_4 using stb4 tags(4,'4',4.0)
|
|
|
|
$i = 0
|
|
$ts0 = 1625850000000
|
|
$blockNum = 5
|
|
$delta = 0
|
|
$tbname0 = tb4_
|
|
$a = 0
|
|
$b = 200
|
|
$c = 400
|
|
while $i < $blockNum
|
|
$x = 0
|
|
$rowNum = 200
|
|
while $x < $rowNum
|
|
$ts = $ts0 + $x
|
|
$a = $a + 1
|
|
$b = $b + 1
|
|
$c = $c + 1
|
|
$d = $x / 10
|
|
$tin = $rowNum
|
|
$binary = 'binary . $c
|
|
$binary = $binary . '
|
|
$nchar = 'nchar . $c
|
|
$nchar = $nchar . '
|
|
$tbname = 'tb4_ . $i
|
|
$tbname = $tbname . '
|
|
sql insert into $tbname values ( $ts , $a , $b , $c , $d , $d , $c , true, $binary , $nchar , $binary )
|
|
$x = $x + 1
|
|
endw
|
|
|
|
$i = $i + 1
|
|
$ts0 = $ts0 + 259200000
|
|
endw
|
|
|
|
sleep 100
|
|
|
|
sql connect
|
|
sql use cdb;
|
|
|
|
sql_error select apercentile(c1,101,1) from stb4 group by tbname;
|
|
sql_error select apercentile(c1,100,2) from stb4 group by tbname;
|
|
sql_error select apercentile(c1,52.111111111111,1,1) from stb4 group by tbname ;
|
|
|
|
sql select apercentile(c1,90,0) from stb4 group by tbname;
|
|
if $rows != 5 then
|
|
return -1
|
|
endi
|
|
if $data00 != @180.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @380.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @580.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @780.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @980.000000000@ then
|
|
return -1
|
|
endi
|
|
|
|
sql select apercentile(c1,90,1) from stb4 group by tbname;
|
|
if $rows != 5 then
|
|
return -1
|
|
endi
|
|
if $data00 != @180.500000000@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @380.500000000@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @580.500000000@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @780.500000000@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @980.500000000@ then
|
|
return -1
|
|
endi
|
|
|
|
sql select apercentile(c1,1,0) from stb4 group by tbname;
|
|
if $rows != 5 then
|
|
return -1
|
|
endi
|
|
if $data00 != @2.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @202.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @402.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @602.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @802.000000000@ then
|
|
return -1
|
|
endi
|
|
|
|
sql select apercentile(c1,1,1) from stb4 group by tbname;
|
|
if $rows != 5 then
|
|
return -1
|
|
endi
|
|
if $data00 != @2.500000000@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @202.500000000@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @402.500000000@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @602.500000000@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @802.500000000@ then
|
|
return -1
|
|
endi
|
|
|
|
sql select apercentile(c1,52.111111111111,0) from stb4 group by tbname;
|
|
if $rows != 5 then
|
|
return -1
|
|
endi
|
|
if $data00 != @104.222222222@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @304.222222222@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @504.222222222@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @704.222222222@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @904.222222222@ then
|
|
return -1
|
|
endi
|
|
|
|
sql select apercentile(c1,52.111111111111) from stb4 group by tbname;
|
|
if $rows != 5 then
|
|
return -1
|
|
endi
|
|
if $data00 != @104.222222222@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @304.222222222@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @504.222222222@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @704.222222222@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @904.222222222@ then
|
|
return -1
|
|
endi
|
|
|
|
|
|
sql select apercentile(c1,52.111111111111,1) from stb4 group by tbname;
|
|
if $rows != 5 then
|
|
return -1
|
|
endi
|
|
if $data00 != @104.722222222@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @304.722222222@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @504.722222222@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @704.722222222@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @904.722222222@ then
|
|
return -1
|
|
endi
|
|
|
|
sql select apercentile(c1,52.111111111111,1) from tb4_0;
|
|
if $rows != 1 then
|
|
return -1
|
|
endi
|
|
if $data00 != @104.722222222@ then
|
|
return -1
|
|
endi
|
|
|
|
|