Summary: | EDITING: ODBC - Firebird: Could not input Integer-values | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Robert Großkopf <robert> |
Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | normal | CC: | iplaw67, lionel, robinson.libreoffice, serval2412 |
Priority: | medium | ||
Version: | 4.1.0.3 rc | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Linux (All) | ||
See Also: |
https://bugs.freedesktop.org/show_bug.cgi?id=45881 https://issues.apache.org/ooo/show_bug.cgi?id=112753 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | Failure-message when primarykey is integer in firebird, connected through ODBC |
Description
Robert Großkopf
2013-07-21 20:00:52 UTC
Could be the same bug as described here: https://bugs.freedesktop.org/show_bug.cgi?id=45881 ... don't know. (In reply to comment #1) > Could be the same bug as described here: > https://bugs.freedesktop.org/show_bug.cgi?id=45881 ... don't know. Hi Robert, Are you still seeing this problem with modern builds? (e.g. 4.2.0.0.beta2) Created attachment 90839 [details]
Failure-message when primarykey is integer in firebird, connected through ODBC
I have created a table for firebird with JDBC and LO. There is an Integer-field for the primary-key. Then I put values in the table through JDBC.
When I try the same with ODBC through the GUI an error occurs:
validation error for column ID, value "***null***".
When I try it with the same connection with Tools → SQL it works.
So this is an error produced from LO, not from ODBC.
It is the same error in all LO-versions, up to LO 4.3.alpha, also 4.2.0.0beta2.
This smells like bug 45881; try with INT64 or SMALLINT instead of INTEGER. (In reply to Lionel Elie Mamane from comment #4) > This smells like bug 45881; try with INT64 or SMALLINT instead of INTEGER. You are right, works with SMALLINT. I could input values in this way, but it works with Integer-values through tools → SQL. If it works through Tools → SQL - isn't it a buggy behavior of LO? (In reply to robert from comment #5) > (In reply to Lionel Elie Mamane from comment #4) >> This smells like bug 45881; try with INT64 or SMALLINT instead of INTEGER. > You are right, works with SMALLINT. > I could input values in this way, but it works with Integer-values through > tools → SQL. > If it works through Tools → SQL - isn't it a buggy behavior of LO? It means it is a bug of something that sits between the user and Firebird. In the case of bug 45881, it is the ODBC driver. I think the best way to proceed is get bug 45881 fixed in the ODBC driver, and take it from there. In the meantime, I'm marking this as a duplicate of bug 45881, since the fact that it is specific to INTEGER (and does not happen with SMALLINT) is a strong clue. *** This bug has been marked as a duplicate of bug 45881 *** |