← 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: Andrew Hutchings
  • Date: 2011-01-21 11:23:19 UTC
  • mto: (2100.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 2101.
  • Revision ID: andrew@linuxjedi.co.uk-20110121112319-nj1cvg0yt3nnf2rr
https://launchpad.net/bugs/705771
Add errors page to drizzle client docs
Add link to specific error in migration docs
Minor changes to migration docs

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 1064,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 1064
 
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;