1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
DROP SCHEMA IF EXISTS drizzledump_migrate_test;
Dropping test database on MySQL...
Create test database on MySQL...
populating MySQL with test data...
calling drizzledump to populate Drizzle...
test our table:
test float type
SHOW CREATE TABLE drizzledump_migrate_test.float_table;
Table Create Table
float_table CREATE TABLE `float_table` (
`description` TEXT COLLATE utf8_general_ci,
`col_float_unsigned` DOUBLE(12,0) DEFAULT NULL,
`col_float0` DOUBLE(12,0) DEFAULT NULL,
`col_float1` DOUBLE(12,0) DEFAULT NULL,
`col_float2` DOUBLE(2,0) DEFAULT NULL,
`col_float2_1` DOUBLE(12,0) DEFAULT NULL,
`col_float` DOUBLE(12,0) DEFAULT NULL,
`col_float_5_2` DOUBLE(5,2) DEFAULT NULL,
`col_float_23` DOUBLE(23,1) DEFAULT NULL,
`col_float_not_null` DOUBLE(12,0) NOT NULL,
`col_float_default_null` DOUBLE(12,0) DEFAULT NULL,
`col_float_default` DOUBLE(5,2) DEFAULT '999.99'
) ENGINE=InnoDB COLLATE = utf8_general_ci
SELECT * FROM drizzledump_migrate_test.float_table;
description col_float_unsigned col_float0 col_float1 col_float2 col_float2_1 col_float col_float_5_2 col_float_23 col_float_not_null col_float_default_null col_float_default
MIN 0 NULL -9 -99 -99 -10000000000 -999.99 -9999999778196308000000.0 -10000000000 NULL 999.99
MAX 1000000000 NULL 9 99 99 10000000000 999.99 9999999778196308000000.0 10000000000 NULL 999.99
NULL NULL NULL NULL NULL NULL NULL NULL NULL 1000 NULL 999.99
Dropping test database on MySQL...
DROP SCHEMA drizzledump_migrate_test;
|