← Back to branch summary

~barry-leslie/drizzle/drizzle_pbmsV2

« back to all changes in this revision

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

  • Committer: Barry.Leslie at PrimeBase
  • Date: 2011-04-04 14:40:45 UTC
  • mfrom: (1919.2.344 build)
  • Revision ID: barry.leslie@primebase.com-20110404144045-etbtnq340cgy2dw3
Merged in lp:drizzle.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/mysql_migrate/r/time_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 time type
 
8
SHOW CREATE TABLE drizzledump_migrate_test.time_table;
 
9
Table   Create Table
 
10
time_table      CREATE TABLE `time_table` (
 
11
  `description` TEXT COLLATE utf8_general_ci,
 
12
  `col_time` INT DEFAULT NULL,
 
13
  `col_time_not_null` INT DEFAULT NULL,
 
14
  `col_time_default_null` INT DEFAULT NULL,
 
15
  `col_time_default_min` INT DEFAULT '0',
 
16
  `col_time_default_max` INT DEFAULT '86399',
 
17
  `col_time_default_large_min` INT DEFAULT '-3020399',
 
18
  `col_time_default_large_max` INT DEFAULT '3020399'
 
19
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
20
SELECT * FROM drizzledump_migrate_test.time_table;
 
21
description     col_time        col_time_not_null       col_time_default_null   col_time_default_min    col_time_default_max    col_time_default_large_min      col_time_default_large_max
 
22
MIN     0       0       NULL    0       86399   -3020399        3020399
 
23
MAX     86399   86399   NULL    0       86399   -3020399        3020399
 
24
NULL_ROW        NULL    73220   NULL    0       86399   -3020399        3020399
 
25
ZERO    0       0       0       0       0       0       0
 
26
Dropping test database on MySQL...
 
27
DROP SCHEMA drizzledump_migrate_test;