Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Run Query shows list totally filled with result of first row, when selecting from tables with an alias name | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Product: | Base | Reporter: | hboie <hans.boie> | ||||||||||||
Component: | MySQL Connector/OOo | Assignee: | marc.neumann | ||||||||||||
Status: | CLOSED FIXED | QA Contact: | issues@dba <issues> | ||||||||||||
Severity: | Trivial | ||||||||||||||
Priority: | P3 | CC: | issues, jhf.remmelzwaal, r4zoli | ||||||||||||
Version: | OOO330m3 | Keywords: | regression | ||||||||||||
Target Milestone: | OOo 3.3 | ||||||||||||||
Hardware: | PC | ||||||||||||||
OS: | Windows XP | ||||||||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||||||||
Developer Difficulty: | --- | ||||||||||||||
Issue Depends on: | |||||||||||||||
Issue Blocks: | 111112 | ||||||||||||||
Attachments: |
|
Description
hboie
2010-08-20 22:38:20 UTC
Created attachment 71227 [details]
Result of "Run Query"
Created attachment 71228 [details]
Result of "OpenQuery"
Created attachment 71229 [details]
Result of "Copy Query to Calc"
Created attachment 71230 [details]
Result "Copy Query to new table"
It is a duplicate to issue 113631. Workaround, run query in direct SQL mode. *** This issue has been marked as a duplicate of 113631 *** fs->hboie: If you have any chance, please check whether this issue is solved in the latest milestone build (OOO330.m8). I *suspect* it is not, since issue 113631 (which this one here is claimed to be a duplicate of) has been fixed in m7, but we got a similar bug report as this one here, applying to m7. So, to me this sounds as if this issue here might not be fixed in m7/m8, too. Created attachment 71801 [details]
document to reproduce the bug case
found the pattern: the table alias names are the culprit here, without them, the query works fine. The attached database contains a simple example to reproduce the issue. the bad news is: the bug still happens in OOO330.m8, where issue 113631 is fixed. Conclusion: This one here is not duplicate. Reopening it. *** Issue 114658 has been marked as a duplicate of this issue. *** grabbing, will investigate as long as the main developer is not available, to see if I can fix this for 3.3. works in OOo 3.2.1 => adding keyword "regression" adjusting target to 3.3 fixed in CWS dba33j find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dba33j fs->msc: please verify in CWS dba33j verified in CWS dba33j find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dba33j Something not good, but I'm not sure. Open attached database. Open "first row data only" Run query with UI it gives same results in first two(first) and second(second) two record. If you run in "direct mode" gives different records. May be needs to reopen it. I forget to mention I tested in OOO330m10. add cc. indeed, the values in the "sub" column are still wrong, though the values of the other columns are correct now ... re-opening checked in CWS dba33j, where this bug was claimed to be fixed: The wrong data in the "sub" column was present there, too - something which slipped my both my and QA's attention :( fs->oj: Could you please have a look at this remaining problem? You know the code (it's a problem of the newly introduced OptimisticSet) much better than /me Fixed in cws dba33k. The problem is that not all key column(s) of the S table are selected. Therefor refetching doesn't work. Now the query will return the correct result but isn't updateable until you insert the ID column of table S. This could also be a work a round for this issue. Please verify. Thanks. verified in cws dba33k I tried with 3.3 rc1 and as far as i can see the bug is fixed Checked in OOo 3.3RC2 (OOO330m12), it is OK. Closing. |