← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to plugin/schema_dictionary/tests/t/show_fields.test

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-03-18 12:12:31 UTC
  • Revision ID: james.westby@ubuntu.com-20100318121231-k6g1xe6cshbwa0f8
Tags: upstream-2010.03.1347
Import upstream version 2010.03.1347

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/schema_dictionary/tests/t/show_fields.test
 
1
# Testing information from show fields.
 
2
 
 
3
create table a ( a serial);
 
4
show fields from a;
 
5
show create table a;
 
6
 
 
7
create table b ( b int);
 
8
show fields from b;
 
9
show create table b;
 
10
 
 
11
create table c ( b int NOT NULL);
 
12
show fields from c;
 
13
show create table c;
 
14
 
 
15
create table d ( b int NOT NULL DEFAULT 10);
 
16
show fields from d;
 
17
show create table d;
 
18
 
 
19
create table e ( b int DEFAULT NULL);
 
20
show fields from e;
 
21
show create table e;
 
22
 
 
23
drop tables a,b,c,d,e;