To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63415
User fs changed the following:
What |Old value |New value
================================================================================
Status|NEW |RESOLVED
--------------------------------------------------------------------------------
Resolution| |FIXED
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Mon Aug 17 19:03:51 +0000
2009 -------
analysis:
That's a bug in the NotesSQL ODBC driver. OOo Base does a call to
SQLSetStmtAttr, setting the SQL_ATTR_MAX_LENGTH to 0. This attribute controls
how many data (at max) the ODBC driver should return for binary and text
columns. Per ODBC spec
(http://msdn.microsoft.com/en-us/library/ms712631(VS.85).aspx), "0" is a
dedicated value which means "return all available data".
Unfortunately, the NotesSQL driver interprets "0" as, well, "0" - and does not
return any data at all for text columns now.
The problem did not exist in OOo 1.1.x because this call to SQLSetStmtAttr was
not present there. It was introduced because another driver needed this call,
since it (also not conformant to the ODBC spec) did have a default other than 0,
which produced other problems. Adding this call was considered a good solution,
since it should not have had any side effects - obviously, we didn't care for
other broken drivers like NotesSQL.
So, we're down to: Doing this call breaks NotesSQL, not doing this call breaks
another database. In both cases, it's a bug in the respective ODBC driver of the
database vendor.
The good news is: In the most recent version of this "other" driver (namely:
PostgreSQL-ODBC), the bug is not present anymore. So, this bug here can be fixed
by simply omitting the call to SQLSetStmtAttr.
Fixed in CWS dba32f:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba32f.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
