Difference between revisions of "Database/Drivers/MySQL Native/Known Problems"
| Line 5: | Line 5: | ||
Create an empty schemata/database. Create a new Base database which connects to an empty MySQL database. The MySQL database is not shown. | Create an empty schemata/database. Create a new Base database which connects to an empty MySQL database. The MySQL database is not shown. | ||
| + | |||
| + | Severity: <span style="background-color:#f0ee00; padding:3px">desired</span> | ||
Reason: OOo calls getTables() - no tables - schema not displayed. Setting might even be cached - verify that database becomes visible after creating table (from mysql prompt) in schema. | Reason: OOo calls getTables() - no tables - schema not displayed. Setting might even be cached - verify that database becomes visible after creating table (from mysql prompt) in schema. | ||
| + | |||
| + | === DECIMAL shown as TEXT === | ||
| + | |||
| + | Base shows numerical DECIMAL columns as TEXT (in the table design?). | ||
| + | |||
| + | Severity: <span style="background-color:#FF8080; padding:3px">required</span> | ||
| + | |||
| + | I'm 95% sure C/C++ and C/OOo report a proper column type. | ||
| + | |||
| + | === OOo shows unrelated databases/schemata === | ||
| + | |||
| + | Create a new Base database that connects to a MySQL schemata "test". Have "test" in the connection settings! OOo will ignore it and query MySQL for all tables in all schematas, and also display all those tables. | ||
| + | |||
| + | As a consequence the user will see all schemata he has access to not only the schemata/database "test" as requested in the connection settings | ||
Severity: <span style="background-color:#f0ee00; padding:3px">desired</span> | Severity: <span style="background-color:#f0ee00; padding:3px">desired</span> | ||
Revision as of 08:05, 8 January 2009
This page lists the currently known problems with the MySQL Native Driver, aka MySQL Connector/OOo.
Empty schemata not shown
Create an empty schemata/database. Create a new Base database which connects to an empty MySQL database. The MySQL database is not shown.
Severity: desired
Reason: OOo calls getTables() - no tables - schema not displayed. Setting might even be cached - verify that database becomes visible after creating table (from mysql prompt) in schema.
DECIMAL shown as TEXT
Base shows numerical DECIMAL columns as TEXT (in the table design?).
Severity: required
I'm 95% sure C/C++ and C/OOo report a proper column type.
Create a new Base database that connects to a MySQL schemata "test". Have "test" in the connection settings! OOo will ignore it and query MySQL for all tables in all schematas, and also display all those tables.
As a consequence the user will see all schemata he has access to not only the schemata/database "test" as requested in the connection settings
Severity: desired
