~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/show_schema_proto/tests/t/basic.test

  • 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:
 
1
#SELECT SHOW_SCHEMA_PROTO('test');
 
2
--error 1049
 
3
SELECT SHOW_SCHEMA_PROTO('not_exists');
 
4
CREATE DATABASE foobar COLLATE = utf8_bin;
 
5
SELECT SHOW_SCHEMA_PROTO('foobar');
 
6
DROP DATABASE foobar;
 
7
CREATE DATABASE foobar;
 
8
SELECT SHOW_SCHEMA_PROTO('foobar');
 
9
ALTER DATABASE foobar COLLATE = utf8_bin;
 
10
SELECT SHOW_SCHEMA_PROTO('foobar');
 
11
DROP DATABASE foobar;