← Back to branch summary

~ubuntu-branches/ubuntu/saucy/drizzle/saucy-proposed

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2011-03-15 10:41:18 UTC
  • mfrom: (1.2.10 upstream)
  • Revision ID: james.westby@ubuntu.com-20110315104118-eaf0hvlytjdl4zrf
Tags: 2011.03.13-0ubuntu1
* New upstream release.
* Added slave plugin.
* Removed archive, blackhole and blitzdb plugins.
* Moved location of libdrizzle headers.
* Removed drizzleadmin manpage patch.
* Add drizzle_safe_write_string to symbols.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/mysql_migrate/r/year_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
year
 
8
SHOW CREATE TABLE drizzledump_migrate_test.year_table;
 
9
Table   Create Table
 
10
year_table      CREATE TABLE `year_table` (
 
11
  `description` TEXT COLLATE utf8_general_ci,
 
12
  `col_year` INT DEFAULT NULL,
 
13
  `col_year_not_null` INT NOT NULL,
 
14
  `col_year_default_null` INT DEFAULT NULL,
 
15
  `col_year_default_min` INT DEFAULT '0000',
 
16
  `col_year_default_max` INT DEFAULT '2155',
 
17
  `col_year2` INT DEFAULT NULL,
 
18
  `col_year2_not_null` INT NOT NULL,
 
19
  `col_year2_default_null` INT DEFAULT NULL,
 
20
  `col_year2_default_min` INT DEFAULT '00',
 
21
  `col_year2_default_max` INT DEFAULT '99'
 
22
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
23
SELECT * FROM drizzledump_migrate_test.year_table;
 
24
description     col_year        col_year_not_null       col_year_default_null   col_year_default_min    col_year_default_max    col_year2       col_year2_not_null      col_year2_default_null  col_year2_default_min   col_year2_default_max
 
25
MIN     0       0       NULL    0       2155    0       0       NULL    0       99
 
26
MAX     2155    2155    NULL    0       2155    99      99      NULL    0       99
 
27
NULL_ROW        NULL    2099    NULL    0       2155    NULL    22      NULL    0       99
 
28
ZERO    0       0       0       0       0       0       0       0       0       0
 
29
Dropping test database on MySQL...
 
30
DROP SCHEMA drizzledump_migrate_test;