~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/schema_dictionary/tests/r/columns.result

Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
CREATE SCHEMA test_columns;
 
2
use test_columns;
 
3
CREATE TABLE types (
 
4
a integer,
 
5
b bigint,
 
6
c varchar(10),
 
7
d double,
 
8
e blob,
 
9
f enum("yes", "no"),
 
10
g decimal,
 
11
h date,
 
12
j timestamp,
 
13
k datetime
 
14
);
 
15
SELECT DATA_TYPE  FROM data_dictionary.columns WHERE TABLE_SCHEMA="test_columns" GROUP BY DATA_TYPE;
 
16
DATA_TYPE
 
17
BIGINT
 
18
BLOB
 
19
DATE
 
20
DATETIME
 
21
DECIMAL
 
22
DOUBLE
 
23
ENUM
 
24
INTEGER
 
25
TIMESTAMP
 
26
VARCHAR
 
27
DROP SCHEMA test_columns;