← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-02-16 01:41:47 UTC
  • mfrom: (1273.13.66 build)
  • Revision ID: brian@gaz-20100216014147-d14la0yrezusgisn
Merge of Brian stuff

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/schema_dictionary/tests/t/columns.test
 
1
# Drizzle's data dictionary, column specific test.
 
2
 
 
3
CREATE SCHEMA data_dictionary;
 
4
CREATE SCHEMA test_columns;
 
5
 
 
6
use test_columns;
 
7
CREATE TABLE types (
 
8
  a integer,
 
9
  b bigint,
 
10
  c varchar(10),
 
11
  d double,
 
12
  e blob,
 
13
  f enum("yes", "no"),
 
14
  g decimal,
 
15
  h date,
 
16
  j timestamp,
 
17
  k datetime
 
18
);
 
19
 
 
20
SELECT DATA_TYPE  FROM data_dictionary.columns WHERE TABLE_SCHEMA="test_columns" GROUP BY DATA_TYPE;
 
21
 
 
22
DROP SCHEMA test_columns;
 
23
DROP SCHEMA data_dictionary;