← Back to branch summary

~clint-fewbar/drizzle/regex-policy-cache-limiter

« back to all changes in this revision

Viewing changes to tests/suite/mysql_migrate/r/decimal_type.result

  • Committer: Clint Byrum
  • Date: 2012-03-15 18:05:43 UTC
  • mfrom: (2224.1.302 workspace)
  • Revision ID: clint@ubuntu.com-20120315180543-9jxxm4q10k3np2ws
merging with latest trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/mysql_migrate/r/decimal_type.result
 
1
DROP SCHEMA IF EXISTS drizzledump_migrate_test;
 
2
Dropping test database on MySQL...
 
3
Create test database on MySQL...
 
4
populating MySQL with test data...
 
5
calling drizzledump to populate Drizzle...
 
6
test our table:
 
7
test decimal type
 
8
SHOW CREATE TABLE drizzledump_migrate_test.decimal_table;
 
9
Table   Create Table
 
10
decimal_table   CREATE TABLE `decimal_table` (
 
11
  `description` TEXT COLLATE utf8_general_ci,
 
12
  `col_decimal_unsigned` DECIMAL(10,0) DEFAULT NULL,
 
13
  `col_decimal1` DECIMAL(1,0) DEFAULT NULL,
 
14
  `col_decimal` DECIMAL(10,0) DEFAULT NULL,
 
15
  `col_decimal_5_2` DECIMAL(5,2) DEFAULT NULL,
 
16
  `col_decimal_65` DECIMAL(65,1) DEFAULT NULL,
 
17
  `col_decimal_not_null` DECIMAL(10,0) NOT NULL,
 
18
  `col_decimal_default_null` DECIMAL(10,0) DEFAULT NULL,
 
19
  `col_decimal_default` DECIMAL(5,2) DEFAULT '999.99'
 
20
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
21
SELECT * FROM drizzledump_migrate_test.decimal_table;
 
22
description     col_decimal_unsigned    col_decimal1    col_decimal     col_decimal_5_2 col_decimal_65  col_decimal_not_null    col_decimal_default_null        col_decimal_default
 
23
MIN     0       -9      -9999999999     -999.99 -9999999999999999999999999999999999999999999999999999999999999999.9     -9999999999     NULL    999.99
 
24
MAX     999999999       9       9999999999      999.99  9999999999999999999999999999999999999999999999999999999999999999.9      9999999999      NULL    999.99
 
25
NULL    NULL    NULL    NULL    NULL    NULL    1000    NULL    999.99
 
26
Dropping test database on MySQL...
 
27
DROP SCHEMA drizzledump_migrate_test;