Bug #10336 Access Tables Not Being Migrated
Submitted: 3 May 2005 14:03 Modified: 3 May 2005 14:47
Reporter: Eric Anderson Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S2 (Serious)
Version:1.05 OS:Microsoft Windows (Windows XP)
Assigned to: CPU Architecture:Any

[3 May 2005 14:03] Eric Anderson
Description:
Access tables that contain double precision fields are not migrated.  The error occurs during the 'Create Objects' step.  Following is the log:

Initializing JDBC driver. 
Driver class com.mysql.jdbc.Driver
Opening connection.
Connection jdbc:mysql://localhost:3306/?user=root&password=appoint
Deactivate foreign key constraints.
SET FOREIGN_KEY_CHECKS = 0;
Drop schema test if it already exists.
DROP DATABASE IF EXISTS `test`;
Creating schema test ...
CREATE DATABASE `test`
  CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Creating tables ...
Creating table tChecks ...
CREATE TABLE `test`.`tChecks` (
  `CheckID` INTEGER(10) NOT NULL AUTO_INCREMENT,
  `MfgID` INTEGER(10) NULL,
  `CheckNumber` INTEGER(10) NULL,
  `CheckDate` DATETIME NULL,
  `DepositDate` DATETIME NULL,
  `Amount` (nil) NULL,
  `CheckStatus` VARCHAR(10) NULL,
  `OpenAmount` (nil) NULL,
  UNIQUE INDEX `CheckID` (`CheckID`),
  INDEX `MfgID` (`MfgID`)
)
ENGINE = INNODB;
An error occured while executing the SQL statement.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(nil) NULL,
  `CheckStatus` VARCHAR(10) NULL,
  `OpenAmount` (nil) NULL,
  UN' at line 7
Creating views ...
Creating procedures ...
Reactivate foreign key constraints.
SET FOREIGN_KEY_CHECKS = 1;

Both the 'Amount' and 'Open Amount' fields are defined as:

Data Type:  Number
Field Size:  Double
Format:  Standard
Decimal Places:  2
Default Value:  0
Required:  No
Indexed:  No

When I change the field size to 'Single' the migration works but amounts to the right of the decimal place are lost.

How to repeat:
Create an Access table with a similar field and run the Migration utility.
[3 May 2005 14:04] Eric Anderson
Simple Access Database to observe the problem

Attachment: test.ldb (application/octet-stream, text), 64 bytes.

[3 May 2005 14:47] MySQL Verification Team
Thank you for the bug report. related to:

http://bugs.mysql.com/bug.php?id=9918