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>
63 lines
No EOL
1.1 KiB
Text
63 lines
No EOL
1.1 KiB
Text
sleep 100
|
|
sql connect
|
|
|
|
sql use db;
|
|
|
|
sql select cast(stb1.c4 as binary(10)),cast(stba.c5 as binary(10)) from stb1,stba where stb1.t1=stba.t1 and stb1.ts=stba.ts;
|
|
if $rows != 7 then
|
|
return -1
|
|
endi
|
|
if $data00 != 1 then
|
|
return -1
|
|
endi
|
|
if $data01 != 1 then
|
|
return -1
|
|
endi
|
|
if $data10 != NULL then
|
|
return -1
|
|
endi
|
|
if $data11 != 2 then
|
|
return -1
|
|
endi
|
|
if $data20 != 2 then
|
|
return -1
|
|
endi
|
|
if $data21 != 3 then
|
|
return -1
|
|
endi
|
|
if $data30 != NULL then
|
|
return -1
|
|
endi
|
|
if $data31 != 4 then
|
|
return -1
|
|
endi
|
|
if $data40 != 4 then
|
|
return -1
|
|
endi
|
|
if $data41 != 5 then
|
|
return -1
|
|
endi
|
|
if $data50 != 2147483647 then
|
|
return -1
|
|
endi
|
|
if $data51 != 6 then
|
|
return -1
|
|
endi
|
|
if $data60 != -214748364 then
|
|
return -1
|
|
endi
|
|
if $data61 != 7 then
|
|
return -1
|
|
endi
|
|
|
|
sql select cast(c4 as binary(10)) as a from stb1 union all select cast(c5 as binary(10)) as a from stba;
|
|
if $rows != 44 then
|
|
return -1
|
|
endi
|
|
|
|
sql select cast(c2 as bigint) from stba;
|
|
if $rows != 30 then
|
|
return -1
|
|
endi
|
|
|
|
|