len.sim

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