← 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-07 22:29:56 UTC
  • mfrom: (1747.1.3 build)
  • Revision ID: lbieber@orisndriz03-20100907222956-d60u695b7hx3zs0d
Merge Andrew - bug 597778 - Timestamp cannot reliably store leap seconds, so don't try. Leave that to datetime only
Merge Andrew - bug 621862 - Add / clean-up error messages for unireg_abort
Merge Andrew - bug 629563 - Drop the broken --mysql options and Change the --protocol option to accept 'mysql' or 'drizzle' ('mysql' currently default)

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;