[Bug 123199] New: Query wizard doesn't save search conditions

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=123199

            Bug ID: 123199
        Issue Type: DEFECT
           Summary: Query wizard doesn't save search conditions
           Product: Base
           Version: 4.0.0
          Hardware: Mac
                OS: Mac OSX, 10.8
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: dpj@sent.com
                CC: issues@openoffice.apache.org

Created attachment 81465
  --> https://issues.apache.org/ooo/attachment.cgi?id=81465&action=edit
Test base file

The Base Query Wizard does not apply search conditions.

Steps to reproduce:
1. Download the attached example file.
2. Create a new query with the query wizard.
3. Add the "Size" field to the query, then click 'Next >'.
4. Ignore the sorting order - click 'Next >'.
5. For search conditions, choose the "Table1.Size" field, condition "is equal
to" value "3".
6. Then click 'Finish'.

Notice that the results are not filtered. The resulting SQL query that the
wizard makes is -- SELECT "Table1"."Size" AS "Size" FROM "Table1" "Table1" --


An alternative set of steps, that results in a different error:
   Follow steps 1-5 above.
6. Click 'Next >' (instead of clicking 'Finish').
7. Click '< Back'.

Notice that the search conditions are all empty. If you enter in a search
condition now, and then hit 'Finish', then there is an SQL error:

---
Syntax error in SQL expression

SELECT "Table1"."Size" AS "Size" FROM "Table1" "Table1" WHERE (Size = 3)
---

The error seems to come about because the field name in the WHERE is not
enclosed by double-quotes.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123199] Query wizard doesn't save search conditions

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=123199

dpj@sent.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dpj@sent.com

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.