TDengine/tests/script/windows/db/len.sim
Shuduo Sang d69c5977db
Test/sangshuduo/td 13408 move tests in (#10589)
* 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>
2022-03-07 17:59:24 +08:00

92 lines
No EOL
1.4 KiB
Text

sleep 2000
sql connect
sql show databases
sql drop database $data00 -x e1
e1:
sql show databases
sql drop database $data00 -x e2
e2:
print =============== step1
sql_error drop database dd
sql create database -x step1
return -1
step1:
sql show databases
if $rows != 0 then
return -1
endi
print =============== step2
sql create database a
sql show databases
if $rows != 1 then
return -1
endi
sql drop database a
sql show databases
if $rows != 0 then
return -1
endi
print =============== step3
sql create database a12345678
sql show databases
if $rows != 1 then
return -1
endi
sql drop database a12345678
sql show databases
if $rows != 0 then
return -1
endi
print =============== step4
sql create database a012345678901201234567890120123456789012a012345678901201234567890120123456789012 -x step4
return -1
step4:
sql show databases
if $rows != 0 then
return -1
endi
print =============== step5
sql create database a;1
sql drop database a
sql show databases
if $rows != 0 then
return -1
endi
print =============== step6
sql create database a'1 -x step6
return -1
step6:
sql show databases
if $rows != 0 then
return -1
endi
print =============== step7
sql create database (a) -x step7
return -1
step7:
sql show databases
if $rows != 0 then
return -1
endi
print =============== step8
sql create database a.1 -x step8
return -1
step8:
sql show databases
if $rows != 0 then
return -1
endi