Difference between revisions of "Database/Drivers/MySQL Native/Known Problems"

From Apache OpenOffice Wiki
Jump to: navigation, search
(No way to set MySQL specific table attributes)
(No way to set MySQL specific table attributes (<span style="background-color:#c0ffc0; padding:3px">1.1</span>))
Line 32: Line 32:
 
Severity: <span style="background-color:#f0ee00; padding:3px">desired</span>
 
Severity: <span style="background-color:#f0ee00; padding:3px">desired</span>
  
=== No way to set MySQL specific table attributes (<span style="background-color:#c0ffc0; padding:3px">1.1</span>) ===
+
=== No way to set MySQL specific table attributes ===
  
 
The Base table editor does not give access to table attributes. Not even basic ones such as the Engine (MyISAM: non-transactional, InnoDB: transactional).
 
The Base table editor does not give access to table attributes. Not even basic ones such as the Engine (MyISAM: non-transactional, InnoDB: transactional).
  
 
Severity: <span style="background-color:#c0ffc0; padding:3px">1.1</span>
 
Severity: <span style="background-color:#c0ffc0; padding:3px">1.1</span>

Revision as of 08:08, 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.

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: desired

No default schema on table creation

Base does not preselect a default schema in the table editor dialog. Its does not even if you connect to a certain schema by specifying it in the connection settings.

Severity: desired

No way to set MySQL specific table attributes

The Base table editor does not give access to table attributes. Not even basic ones such as the Engine (MyISAM: non-transactional, InnoDB: transactional).

Severity: 1.1

Personal tools