len.sim 1.4 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13
system sh/stop_dnodes.sh
system sh/deploy.sh -n dnode1 -i 1
system sh/exec.sh -n dnode1 -s start
sql connect

print =============== step1
sql_error drop database dd

sql create database -x step1
	return -1
step1:

sql show databases
S
Shengliang Guan 已提交
14
if $rows != 2 then 
15 16 17 18 19 20
  return -1
endi

print =============== step2
sql create database a
sql show databases
S
Shengliang Guan 已提交
21
if $rows != 3 then 
22 23 24 25 26
  return -1
endi

sql drop database a
sql show databases
S
Shengliang Guan 已提交
27
if $rows != 2 then 
28 29 30 31 32 33
  return -1
endi

print =============== step3
sql create database a12345678
sql show databases
S
Shengliang Guan 已提交
34
if $rows != 3 then 
35 36 37 38 39
  return -1
endi

sql drop database a12345678
sql show databases
S
Shengliang Guan 已提交
40
if $rows != 2 then 
41 42 43 44 45 46 47 48
  return -1
endi

print =============== step4
sql create database a012345678901201234567890120123456789012a012345678901201234567890120123456789012 -x step4
	return -1
step4:
sql show databases
S
Shengliang Guan 已提交
49
if $rows != 2 then 
50 51 52 53 54 55 56
  return -1
endi

print =============== step5
sql create database a;1 
sql drop database a
sql show databases
S
Shengliang Guan 已提交
57
if $rows != 2 then 
58 59 60 61 62 63 64 65 66
  return -1
endi

print =============== step6
sql create database a'1 -x step6
	return -1
step6:

sql show databases
S
Shengliang Guan 已提交
67
if $rows != 2 then 
68 69 70 71 72 73 74 75
  return -1
endi

print =============== step7
sql create database (a) -x step7
	return -1
step7:
sql show databases
S
Shengliang Guan 已提交
76
if $rows != 2 then 
77 78 79 80 81 82 83 84
  return -1
endi

print =============== step8
sql create database a.1 -x step8
	return -1
step8:
sql show databases
S
Shengliang Guan 已提交
85
if $rows != 2 then 
86 87 88 89
  return -1
endi

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