← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/identifiers/t/schema.test

  • Committer: lbieber
  • Date: 2010-09-11 16:33:45 UTC
  • mfrom: (1757.1.2 build)
  • Revision ID: lbieber@orisndriz03-20100911163345-na1t8m18at9thsjl
Merge Vijay - added utf 8 tamil test case suite and test case for creating a database in tamil
Merge Brian - Small set of refactoring (includes one case of memset on a table object).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/identifiers/t/schema.test
1
 
#
2
 
# We check that no one can create bad schemas
3
 
#
4
 
 
5
 
CREATE SCHEMA admin;
6
 
CREATE SCHEMA temporary;
7
 
 
8
 
SELECT SCHEMA();
9
 
 
10
 
--error ER_PARSE_ERROR,ER_SYNTAX_ERROR
11
 
CREATE SCHEMA .admin;
12
 
 
13
 
--error ER_WRONG_DB_NAME
14
 
CREATE SCHEMA `.admin `;
15
 
 
16
 
--error ER_WRONG_DB_NAME
17
 
CREATE SCHEMA `.admin`;
18
 
 
19
 
--error ER_PARSE_ERROR
20
 
CREATE SCHEMA #admin;
21
 
 
22
 
CREATE SCHEMA `#admin`;
23
 
DROP SCHEMA `#admin`;
24
 
 
25
 
SELECT TABLE_NAME FROM DATA_DICTIONARY.TABLES WHERE TABLE_SCHEMA=SCHEMA();
26
 
 
27
 
--error ER_WRONG_DB_NAME
28
 
CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
29
 
 
30
 
DROP SCHEMA admin;
31
 
DROP SCHEMA temporary;