|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Dataview and Grid controls display error with Sqlite ODBC driver | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | Base | Reporter: | eziomartello <martelozzo1> | ||||||||||
| Component: | code | Assignee: | marc.neumann | ||||||||||
| Status: | CLOSED FIXED | QA Contact: | issues@dba <issues> | ||||||||||
| Severity: | Trivial | ||||||||||||
| Priority: | P2 | CC: | issues, mechtilde, vitriol_vitriol | ||||||||||
| Version: | OOO320m15 | ||||||||||||
| Target Milestone: | OOo 3.2.1 | ||||||||||||
| Hardware: | All | ||||||||||||
| OS: | Windows XP | ||||||||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||||||
| Developer Difficulty: | --- | ||||||||||||
| Issue Depends on: | |||||||||||||
| Issue Blocks: | 109046 | ||||||||||||
| Attachments: |
|
||||||||||||
|
Description
eziomartello
2010-04-16 12:16:34 UTC
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 |