← 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: Stewart Smith
  • Date: 2009-12-08 04:23:00 UTC
  • mto: (1240.3.5 build)
  • mto: This revision was merged to the branch mainline in revision 1241.
  • Revision ID: stewart@flamingspork.com-20091208042300-1etig1dsnfig2qwr
small SHOW_SCHEMA_PROTO() function (like SHOW_TABLE_PROTO()) to show content of Schema proto message in db.opt to test what we're storing.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/show_schema_proto/tests/r/basic.result
 
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
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;