← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-02-16 01:28:56 UTC
  • mto: (1273.16.5 fix_is)
  • mto: This revision was merged to the branch mainline in revision 1301.
  • Revision ID: brian@gaz-20100216012856-huxialrgud0shhw5
Modify return type for COLUMNS type.

Show diffs side-by-side

added added

removed removed

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