~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/show_schema_proto/tests/r/basic.result

  • Committer: Monty Taylor
  • Date: 2009-12-08 22:43:58 UTC
  • mfrom: (1240.1.5 build)
  • mto: (1240.1.6 build)
  • mto: This revision was merged to the branch mainline in revision 1241.
  • Revision ID: mordred@inaugust.com-20091208224358-u1pazjsnn4n932cu
MergedĀ upĀ build.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
SELECT SHOW_SCHEMA_PROTO('not_exists');
 
2
ERROR 42000: Unknown database 'not_exists'
 
3
CREATE DATABASE foobar COLLATE = utf8_bin;
 
4
SELECT SHOW_SCHEMA_PROTO('foobar');
 
5
SHOW_SCHEMA_PROTO('foobar')
 
6
name: "foobar"
 
7
collation: "utf8_bin"
 
8
 
 
9
DROP DATABASE foobar;
 
10
CREATE DATABASE foobar;
 
11
SELECT SHOW_SCHEMA_PROTO('foobar');
 
12
SHOW_SCHEMA_PROTO('foobar')
 
13
name: "foobar"
 
14
 
 
15
ALTER DATABASE foobar COLLATE = utf8_bin;
 
16
SELECT SHOW_SCHEMA_PROTO('foobar');
 
17
SHOW_SCHEMA_PROTO('foobar')
 
18
name: "foobar"
 
19
collation: "utf8_bin"
 
20
 
 
21
DROP DATABASE foobar;