Apache OpenOffice (AOO) Bugzilla – Issue 110942
Dataview and Grid controls display error with Sqlite ODBC driver
Last modified: 2017-05-20 10:22:20 UTC
Bug in filtered table controls with Sqlite ODBC driver. Found in OOO320m15 Regression. Steps to reproduce: - Unzip attached folder. - Must be administrator - In xp install SQLITE ODBC driver with the file sqliteodbc.exe - Open the document 'Connect.odt' and push the button 'Connect' (This operation automatically creates a DSN and registers DataBase) - Close the document - Open the document 'RicettarioOOo.odt' - modify the ComboBox field (This operation, using a macro, changes the filter of the table field) - Bug: the table records are all the same - I don't know if the problem is in all ODBC connections. Thank you.
Created attachment 68965 [details] Data Base document with form
Bug in filtered table controls with Sqlite ODBC driver. Found in OOO320m15 Regression. Steps to reproduce: - Unzip attached folder. - Must be administrator - In xp install SQLITE ODBC driver with the file sqliteodbc.exe - Open the document 'Connect.odt' and push the button 'Connect' (This operation automatically creates a DSN and registers DataBase) - Close the document - Open the document 'RicettarioOOo.odt' - modify the ComboBox field (This operation, using a macro, changes the filter for the table field) - Bug: the table records are all the same - I don't know if the problem is in all ODBC connections. Thank you.
It's a regression from 3.2
clearly a regression
Created attachment 68968 [details] Screenshot OOo 3.2 - Correct result
Created attachment 68969 [details] Screenshot OOO320m15 - Bug
Checking w/ OOO320m_15 (build:9492) under Vista (home) Installed the odbc driver - the data is displayed incorrectly, repeating a single record in both Dataview windows and Form Grid controls. With this build (this one is the special build from today) filters are not the problem - in fact if you apply an autofilter to the dataview it seems to be the only way to get an accurate result. No such luck with form grid controls it seems. see attached screen shot of dataview window. set target to 3.2.1
Created attachment 68970 [details] data view window - no filter
Altering summary to reflect change
is this issue a 3.2.1 stopper now?
@tommy27 - I only set the initial Target Milestone, the release team determines when an issue is or isn't a show stopper, after input from the developer, for a particular issue. A request for them to treat as such is already posted to that mailing list.
The fix is easy. I just read the best row identifiers for the table but I had no fallback when the columns returned are not part of the reference result set.
this issue has been officially accepted as a 3.2.1 stopper
Fixed in cws dba321b
Please verify. Thanks. To verify it, it is enough to open just the table.
verified in cws dba321b
please checked with OpenOffice.org 3.2.1