|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | query wizard: cannot set (anymore) conditions other than "equal" | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Base | Reporter: | Frank Schönheit <frank.schoenheit> | ||||
| Component: | code | Assignee: | marc.neumann | ||||
| Status: | CLOSED FIXED | QA Contact: | issues@dba <issues> | ||||
| Severity: | Trivial | ||||||
| Priority: | P3 | CC: | issues | ||||
| Version: | OOo 3.3 Beta 1 | ||||||
| Target Milestone: | OOo 3.3 | ||||||
| Hardware: | All | ||||||
| OS: | All | ||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
| Developer Difficulty: | --- | ||||||
| Issue Depends on: | |||||||
| Issue Blocks: | 111112 | ||||||
| Attachments: |
|
||||||
Created attachment 71747 [details]
document to reproduce the bug case
worked fine in 3.2.1 => keyword regression fs->oj: The problem here seems to be that the query composer returns an invalid structured filter: The single condition delivered by the component is Name: "ID" Handle: 2 (SQLFilterOperator.NOT_EQUAL) Value: "<> 3" => the "Value" is wrong, it should be "3" only, not "<> 3" Set as duplicate. *** This issue has been marked as a duplicate of 114273 *** Closing. no, those are different issues, sorry :) back to NEW have a patch, which fixes all condition types except "is not null", which has yet another root cause. Submitted this as issue 114617. grabbing adjusting target 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 oops, didn't want to revert the target - had the old value still in the browser ... 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 Checked in OOO330m10, Ok. Closing. |
- open the attached database document - select "Queries" on the left hand side - select "Use Wizard to Create Query" in the task pane - in the query wizard - on the first page, move all fields to the right - advance to the "Search Conditions" page - in the first condition, select "names.ID" as field, and "is not equal to" as condition. Enter an arbitrary numeric value in the "Value" field - advance to the "Overview" page => note that it says "Search conditions: ID is not equal to <> 3" - this is already strange - finish the wizard => you get an error message saying something about a syntax error in SELECT "names"."ID" AS "ID", "names"."name" AS "name" FROM "names" "names" WHERE ("names"."ID" <> <> 3) (Well, that error message is right) => the query is not created This happens with all conditions except equal, not/like, not/null