|
1273.13.66
by Brian Aker
Modify return type for COLUMNS type. |
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; |