← 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

Merged embedded-innodb-write-row into embedded-innodb-rnd-read.

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;