← Back to branch summary

~clint-fewbar/ubuntu/natty/drizzle/beta1-fixes

« back to all changes in this revision

Viewing changes to tests/suite/mysql_migrate/r/real_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/real_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 real type
 
8
SHOW CREATE TABLE drizzledump_migrate_test.real_table;
 
9
Table   Create Table
 
10
real_table      CREATE TABLE `real_table` (
 
11
  `description` TEXT COLLATE utf8_general_ci,
 
12
  `col_real_unsigned` DOUBLE(22,0) DEFAULT NULL,
 
13
  `col_real2` DOUBLE(2,0) DEFAULT NULL,
 
14
  `col_real` DOUBLE(22,0) DEFAULT NULL,
 
15
  `col_real_5_2` DOUBLE(5,2) DEFAULT NULL,
 
16
  `col_real_23` DOUBLE(23,1) DEFAULT NULL,
 
17
  `col_real_not_null` DOUBLE(22,0) NOT NULL,
 
18
  `col_real_default_null` DOUBLE(22,0) DEFAULT NULL,
 
19
  `col_real_default` DOUBLE(5,2) DEFAULT '999.99'
 
20
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
21
SELECT * FROM drizzledump_migrate_test.real_table;
 
22
description     col_real_unsigned       col_real2       col_real        col_real_5_2    col_real_23     col_real_not_null       col_real_default_null   col_real_default
 
23
MIN     0       -99     -9999999999     -999.99 -10000000000000000000000.0      -9999999999     NULL    999.99
 
24
MAX     999999999       99      9999999999      999.99  10000000000000000000000.0       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;