| Summary: | Other: MySQL/MariaDB direct connection - Fields in a form are limited by the max. numbers of characters entered before in the field | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Lelanthran <lelanthran> |
| Component: | Base | Assignee: | Lionel Elie Mamane <lionel> |
| Status: | RESOLVED NOTOURBUG | ||
| Severity: | normal | CC: | robert |
| Priority: | medium | ||
| Version: | 4.0.3.3 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
|
Description
Lelanthran
2013-12-10 15:58:12 UTC
I have tested with LO 4.1.1.2 and OpenSUSE 12.3 64bit rpm Linux. There are different behaviors with different connections from Base to MariaDB (haven't MySQL on my system). Have created a form for every of the following connections and tried the input in the form and the input in the table. No problem, when connection with ODBC or connecting with JDBC to the MariaDB. The following buggy behavior appears on my system only with the direct driver, supported by SUSE only for my system: Tyope a new text in the field of a form. The text is limited to the maximum inputted chars in this field of the table. If there had been the maximum 15 chars, the text in the form ends with 15 chars - more input impossible. I changed to the table - could input more text, for example up to 25 chars. Went back to the form and I could input 25 chars in the form - no more. Seems the max textlength of the field in the form is limited by the max text-length selected form the field - not selected from the properties of the field of the table. Do you have the same problems with the same connection? If yes I will put this bug to new and change the title a little bit (MySQL/MariaDB and direct connection). Work-around: set the "Max. text length" property on the affected control. This comes directly from the MySQL Connector/C++ which reports the maximum occuring length (and not the maximum possible length) as getPrecision(). In my understanding, that's a bug in MySQL Connector/C++, wich claims it follows the JDBC API, so there is "no reason" to return a different result than the JDBC (or ODBC) drivers. While helping other people with database I have again problems with this bug. Numbers of characters are limited in forms to the maximum numbers, which had been read out of the field before. This bug in forms only appears with the direct connection, doesn't appear with the JDBC-connection. So it seems to be a special bug of the enstions: http://extensions.libreoffice.org/extension-center/mysql-native-connector 2 possibilities: Anybody, who is able to fix the bug will fix it. Delete the mysql-native-connector from the list of extensions, because it is unusable with forms. (In reply to robert from comment #4) > While helping other people with database I have again problems with this > bug. Numbers of characters are limited in forms to the maximum numbers, > which had been read out of the field before. As I explained above, report the bug to MySQL Connector/C++ |