Difference between revisions of "Database/Drivers/MySQL Native/Beta/Known Issues"
(Added the MySQL bug ID to the Linux issue) |
B michaelsen (Talk | contribs) |
||
| (6 intermediate revisions by one other user not shown) | |||
| Line 4: | Line 4: | ||
The extension ships with an own version of <code> libmysql.dll </code>. When Windows loads the driver library (<code> mysqlc.uno.dll </code>), it also implicitly loads the <code> libmysql.dll </code>, which <code> mysqlc.uno.dll </code> is linked against. Unfortunately, Windows first searches in the folders specified by your <code> PATH </code> environment variable. If it finds a <code> libmysql.dll </code> in one of those folders, this one is used instead of the one from the extension - no matter whether it is really compatible. | The extension ships with an own version of <code> libmysql.dll </code>. When Windows loads the driver library (<code> mysqlc.uno.dll </code>), it also implicitly loads the <code> libmysql.dll </code>, which <code> mysqlc.uno.dll </code> is linked against. Unfortunately, Windows first searches in the folders specified by your <code> PATH </code> environment variable. If it finds a <code> libmysql.dll </code> in one of those folders, this one is used instead of the one from the extension - no matter whether it is really compatible. | ||
| − | + | <!-- | |
| − | + | ||
=== Linux: Cannot install without <code> libstdc++.so.5 </code> === | === Linux: Cannot install without <code> libstdc++.so.5 </code> === | ||
| Line 37: | Line 36: | ||
For other Linux distributions please have a look onto your installation CD/DVD for a similar name of the package. You can also search in the Web (Examples: [http://rpmfind.net/linux/rpm2html/search.php?query=libstdc++.so.5 RPMFind] or [http://rpmseek.com/rpm-pl/compat-libstdc\\-33.html RPMSeek]) where to get and how to install it. | For other Linux distributions please have a look onto your installation CD/DVD for a similar name of the package. You can also search in the Web (Examples: [http://rpmfind.net/linux/rpm2html/search.php?query=libstdc++.so.5 RPMFind] or [http://rpmseek.com/rpm-pl/compat-libstdc\\-33.html RPMSeek]) where to get and how to install it. | ||
| + | --> | ||
| + | |||
| + | === Cannot access non-intranet servers via IP === | ||
| + | |||
| + | Reportedly, the Alpha version of the driver was able to connect to a remote MySQL server in the internet, using the server's IP address. The Beta version is not able to do this anymore, while, on the very same machine, e.g. the Connector/J works fine for the very same server. | ||
| + | |||
| + | === Much slower than the ODBC driver === | ||
| + | |||
| + | The Connector/OOo is way slower (when fetching all records, i.e. by traveling to the last record in the table data view) than the ODBC driver. This issue was revealed after the release of the Beta version, and will be fixed in the GA release. | ||
| + | |||
| + | === Standard Filter dialog fails to set a column filter === | ||
| + | |||
| + | Using the "Standard Filter" dialog in either the table data view or a form fails to properly set the filter, instead you get an error message talking about a non-existent column "database.table.column". | ||
| + | The bad news is: That's a bug in OOo itself, which is only triggered by the way how the driver (legitimately) exposes its database/tables, so, it cannot be fixed in the driver, but in OOo only. | ||
| + | |||
| + | === Port setting is ignored === | ||
| + | |||
| + | When you enter a port other than the default <code>3306</code>, then this is ignored. Effectively, this means you cannot connect to a MySQL database using a non-standard port. Will be fixed in the final release. | ||
| + | [[Category:MySQL]] | ||
Latest revision as of 21:39, 15 December 2009
Contents
Windows: OOo will crash on systems with pre-installed libmysql.dll when installing and using the extension
The extension ships with an own version of libmysql.dll . When Windows loads the driver library ( mysqlc.uno.dll ), it also implicitly loads the libmysql.dll , which mysqlc.uno.dll is linked against. Unfortunately, Windows first searches in the folders specified by your PATH environment variable. If it finds a libmysql.dll in one of those folders, this one is used instead of the one from the extension - no matter whether it is really compatible.
Cannot access non-intranet servers via IP
Reportedly, the Alpha version of the driver was able to connect to a remote MySQL server in the internet, using the server's IP address. The Beta version is not able to do this anymore, while, on the very same machine, e.g. the Connector/J works fine for the very same server.
Much slower than the ODBC driver
The Connector/OOo is way slower (when fetching all records, i.e. by traveling to the last record in the table data view) than the ODBC driver. This issue was revealed after the release of the Beta version, and will be fixed in the GA release.
Standard Filter dialog fails to set a column filter
Using the "Standard Filter" dialog in either the table data view or a form fails to properly set the filter, instead you get an error message talking about a non-existent column "database.table.column". The bad news is: That's a bug in OOo itself, which is only triggered by the way how the driver (legitimately) exposes its database/tables, so, it cannot be fixed in the driver, but in OOo only.
Port setting is ignored
When you enter a port other than the default 3306, then this is ignored. Effectively, this means you cannot connect to a MySQL database using a non-standard port. Will be fixed in the final release.
