← 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: Stewart Smith
  • Date: 2010-11-07 04:22:31 UTC
  • mto: (1911.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1912.
  • Revision ID: stewart@flamingspork.com-20101107042231-ola4sl7j0qvg58tz
https://launchpad.net/bugs/668880
fix ARCHIVE storage engine calling exit (lintian warning). Was because we were linking in libinternal into libazio, which links into archive plugin. Just link libinternal into the command line utilities.

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;