Issue 18612 - unable to copy bugdoc table from ADO/MDB to MySQL
Summary: unable to copy bugdoc table from ADO/MDB to MySQL
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-25 08:48 UTC by Frank Schönheit
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2003-08-25 08:48:34 UTC 
* create an ADO data source for an MDB file of your choice
* create the table CHECKS as described in issue 18594
* create a data source for a MySQL database, using ODBC 3.51 (not sure if this
matters)
* in the data source browser, drag'n'drop the table CHECKS to the "tables"
container of the MySQL data source
=> the "Copy Table" auto pilot pops up
* first page: press Next
* second page: copy all fields to the right (ignore the two warnings)
* press "Create"
=> an error message pops up saying "Incorrect table definition. There can be
only one auto column, and it must be defined as key."
Note that the source table does not contain any auto column (but some "entry
required" columns, perhaps this matters)
Comment 1 Frank Schönheit 2003-08-25 08:48:47 UTC 
targeting
Comment 2 ocke.janssen 2003-09-15 13:25:41 UTC 
.
Comment 3 marc.neumann 2003-09-29 11:20:02 UTC 
"According to the OpenOffice.org roadmap
(http://tools.openoffice.org/releases) this issue was retargeted to
OOo Later."
Comment 4 hans_werner67 2004-02-02 12:17:34 UTC 
change subcomponent to 'none'
Comment 5 ocke.janssen 2004-05-26 08:28:50 UTC 
fixed in cws insight01
Comment 6 marc.neumann 2004-06-15 14:34:41 UTC 
reopen
Comment 7 marc.neumann 2004-06-15 14:35:11 UTC 
reassign to fs
Comment 8 marc.neumann 2004-06-15 14:35:40 UTC 
fixed in cws insight01 -> please verify
Comment 9 Frank Schönheit 2004-06-17 12:03:18 UTC 
still happens in CWS insight01
Comment 10 Frank Schönheit 2004-06-17 12:48:55 UTC 
re-assign to oj
Comment 11 ocke.janssen 2004-06-28 13:31:15 UTC 
set to fixed.
Comment 12 ocke.janssen 2004-07-16 15:15:38 UTC 
.
Comment 13 ocke.janssen 2004-07-16 15:15:59 UTC 
Please verify
Comment 14 ocke.janssen 2004-07-16 15:16:16 UTC 
.
Comment 15 marc.neumann 2004-07-19 11:25:15 UTC 
verified in cws insight01
Comment 16 marc.neumann 2005-04-26 13:23:32 UTC 
Hi,

fixed in current developer build -> close.
The current developer build can be found at
http://download.openoffice.org/680/index.html
Feel free to reopen if this issue is not fixed in the developer build.

Bye Marc