← 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/timestamp_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/timestamp_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 timestamp type
 
8
SHOW CREATE TABLE drizzledump_migrate_test.timestamp_table;
 
9
Table   Create Table
 
10
timestamp_table CREATE TABLE `timestamp_table` (
 
11
  `description` TEXT COLLATE utf8_general_ci,
 
12
  `col_timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
 
13
  `col_timestamp_not_null` TIMESTAMP NULL DEFAULT NULL,
 
14
  `col_timestamp_default_zero` TIMESTAMP NULL DEFAULT NULL,
 
15
  `col_timestamp_default_cur_time` TIMESTAMP NULL DEFAULT '1970-12-12 00:00:00'
 
16
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
17
SELECT * FROM drizzledump_migrate_test.timestamp_table;
 
18
description     col_timestamp   col_timestamp_not_null  col_timestamp_default_zero      col_timestamp_default_cur_time
 
19
MIN     NULL    NULL    NULL    2015-12-19 11:11:11
 
20
MAX     NULL    NULL    NULL    2015-12-19 11:11:11
 
21
ZERO    NULL    NULL    NULL    NULL
 
22
Dropping test database on MySQL...
 
23
DROP SCHEMA drizzledump_migrate_test;