← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-03-16 23:42:10 UTC
  • mto: This revision was merged to the branch mainline in revision 1350.
  • Revision ID: brian@gaz-20100316234210-t1vr23lqw48vy5o9
A first pass through adding a timestamp to our proto.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/show_schema_proto/tests/r/basic.result
1
1
SELECT SHOW_SCHEMA_PROTO('not_exists');
2
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
 
collation: "utf8_general_ci"
15
 
 
16
 
ALTER DATABASE foobar COLLATE = utf8_bin;
17
 
SELECT SHOW_SCHEMA_PROTO('foobar');
18
 
SHOW_SCHEMA_PROTO('foobar')
19
 
name: "foobar"
20
 
collation: "utf8_bin"
21
 
 
22
 
DROP DATABASE foobar;