len.sim 1.5 KB
Newer Older
S
slguan 已提交
1 2
system sh/stop_dnodes.sh

S
slguan 已提交
3 4

system sh/deploy.sh -n dnode1 -i 1
5
system sh/cfg.sh -n dnode1 -c walLevel -v 1
S
scripts  
slguan 已提交
6
system sh/cfg.sh -n dnode1 -c maxtablesPerVnode -v 2000
S
slguan 已提交
7 8

system sh/exec.sh -n dnode1 -s start
H
Haojun Liao 已提交
9
sleep 2000
S
slguan 已提交
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
sql connect

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
S
Shengliang Guan 已提交
51
sql create database a012345678901201234567890120123456789012a012345678901201234567890120123456789012 -x step4
S
slguan 已提交
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
	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
S
scripts  
slguan 已提交
93 94 95
endi

system sh/exec.sh -n dnode1 -s stop -x SIGINT