Issue 16273 - MySQL tables created in unwanted database
Summary: MySQL tables created in unwanted database
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: OOo 1.1.1
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-01 09:01 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

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2003-07-01 09:01:03 UTC
* have a MySQL server hosting at least two databases
* Have a MySQL ODBC driver greater or equal 3.51, so it supports catalogs (as
database names)
* in OOo, create a MySQL/ODBC data source for the _alphabetically_second_ of the
databases on this server
* open a new table design for this data source
* insert some arbitary fields
* save the table
=> in the dialog where the name is to be entered, there is also a selection box
for the catalog in which the table should be created. This lists contains the
databases. By default, the alphabetically first database/catalog is selected
(note that this is not the one which the data source works with).
* press OK
=> the table is created, but in the wrong database. If you want to display it in
the data source browser (where it appears), then nothing happens - not even an
error message.

This is bad, as unexperienced users won't know what the catalog is for, and thus
leave it untouched.
Comment 1 Frank Schönheit 2003-07-01 09:02:13 UTC
targeting. I consider this 1.1.1 worth, because for n-1 databases on a
MySQL server (with n database at all), the creation of tables will
yield unwanted results.

FS->OJ: please also have a look why selection the table in the DSB
fails silently - normally there should be an error message.
Comment 2 ocke.janssen 2003-10-13 07:50:16 UTC
Fixed in cws dba01pp1.
Comment 3 marc.neumann 2003-11-21 14:10:53 UTC
verifiy in dba01pp1
Comment 4 ocke.janssen 2003-12-03 14:20:23 UTC
.
Comment 5 hans_werner67 2004-02-02 12:29:26 UTC
change subcomponent to 'none'