← 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: Brian Aker
  • Date: 2010-10-28 17:12:01 UTC
  • mfrom: (1887.1.3 merge)
  • Revision ID: brian@tangent.org-20101028171201-baj6l1bnntn1s4ad
Merge in POTFILES changes.

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;