len.sim

system sh/stop_dnodes.sh

system sh/ip.sh -i 1 -s up
system sh/deploy.sh -n dnode1 -m 192.168.0.1 -i 192.168.0.1
system sh/cfg.sh -n dnode1 -c commitLog -v 0
system sh/cfg.sh -n dnode1 -c numOfTotalVnodes -v 4
system sh/cfg.sh -n dnode1 -c sessionsPerVnode -v 2000

system sh/exec.sh -n dnode1 -s start
sleep 3000
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
sql create database a012345678901201234567890120123456789012 -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