~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/information_schema_dictionary/tests/t/table_constraints.test

  • Committer: Monty Taylor
  • Date: 2010-07-11 17:57:33 UTC
  • mfrom: (1657.1.3 build)
  • Revision ID: mordred@inaugust.com-20100711175733-4avg0pa7h2c8cb1s
Merged in Brian's I_S changes and fixes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
create schema everything;
 
2
use everything;
 
3
-- source include/everything.sql
 
4
--sorted_result
 
5
select * from information_schema.TABLE_CONSTRAINTS WHERE table_schema="everything" ORDER BY CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME;
 
6
drop schema everything;
 
7
 
 
8
create schema slashdot;
 
9
use slashdot;
 
10
-- source include/slashdot.sql
 
11
--sorted_result
 
12
select * from information_schema.TABLE_CONSTRAINTS WHERE table_schema="slashdot" ORDER BY CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME;
 
13
drop schema slashdot;