[Bug 122286] New: postgres DB query using ilike '%something%' result in syntax error

[bu...@apache.org]

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

            Bug ID: 122286
        Issue Type: DEFECT
           Summary: postgres DB query using ilike '%something%' result in
                    syntax error
    Classification: Application
           Product: Base
           Version: AOO 3.4.1
          Hardware: PC
                OS: Windows XP
            Status: UNCONFIRMED
          Severity: major
          Priority: P3
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: woodz@andechs.net
                CC: issues@openoffice.apache.org

Be precise:
- client OS-version: Windows XP 5.1 (Build 2600.xpsp_sp3_gdr.130307-0422 :
Service Pack 3) 32bit
- DB-Version: PostgreSQL 9.0.12 running on localhost:5432
- server OS-version: openSUSE 11.4 (i586), VERSION = 11.4. CODENAME = Celadon
- JDBC-Version: postgresql-9.2-1002.jdbc4.jar

Overview:
In AOO query design, if using the ilike comparator in a where clause of a query
to a postgres DB-table connected through a registerd JDBC databese file, a
message box appears on saving the query saying: "Syntax error in SQL
expression"

Steps to Reproduce:
- having a running postgres DB service
- connect to DB via JDBC, registered database file *.odb
- establishing the proper tables to do the following query:
select name, surname from names
where name ilike '%myname%' and surname not ilike '%Miller%'
order by surname,name;

Actual Results:
message box: OpenOffice.org base "Syntax error in SQL expression"
hit 'More' button:
- lists 3 errors
1. SQL Status: HY000, Error code: 1000, Syntax error in SQL expression
2. SQL Status: HY000 Error code: 1000
3. SQL Status: HY000, Error code: 1000, syntax error, unexpected $end,
expecting BETWEEN or IN or SQL_TOKEN_LIKE

unable to store my query

Expected Results:
same as the query would be (replacing any "ilike" by "like" as a rotten
compromise):
select name, surname from names
where name like '%myname%' and surname not like '%Miller%'
order by surname,name;

able to store my query without errors

Build Date & Platform: Date and platform of the build in which you first
encountered the bug.

Build: AOO 3.4.1, AOO341m1(Build9593) - Rev.1372282, OS: Windows XP

Additional Builds and Platforms: none

Additional Information: see 'Be precise'

Regression info: none

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