[OS-JIRA] Created: (CAY-70) Openbase does not support "(COLUMN) NOT LIKE UPPER(binding)"

From: jir..bjectstyle.org
Date: Tue Dec 23 2003 - 22:07:17 EST

Next message: jir..bjectstyle.org: "[OS-JIRA] Created: (CAY-71) Default OpenBase TIMESTAMP type should be timestamp, not datetime"

Previous message: Andrus Adamchik: "Re: Object Graph Refreshing: design ideas?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Message:

A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-70

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: CAY-70
    Summary: Openbase does not support "(COLUMN) NOT LIKE UPPER(binding)"
       Type: Bug

Status: Assigned
Priority: Major

    Project: Cayenne
   Versions:
             1.1 [DEV]

Assignee: Andrus Adamchik
Reporter: Mike Kienenberger

Created: Tue, 23 Dec 2003 10:05 PM
Updated: Tue, 23 Dec 2003 10:05 PM
Environment: Windows 2000, Cayenne v.1.1-dev-2003-9-25 September 25 2003, OpenBase

Description:
qualifier = ExpressionFactory.notLikeIgnoreCaseExp(attributeString, argument);

SELECT [...all fields...] FROM USER_TABLE t0 WHERE (t0.USER_NAME) NOT LIKE UPPER(?) AND (t0.INVALIDATED <> ?) AND (t0.INVALIDATED <> ?) ORDER BY t0.USER_NAME [bind: 'mkienenb', 'Y', 'Y'] - prepared in 16 ms.
*** error.
java.sql.SQLException: SQL ERROR - [position 618, near 'NOT' in 'USER_NAME) NOT LIKE UPPER'] (0) and/or expected but not found at position 122.

SQL: SELECT [...all fields...] FROM USER_TABLE t0 WHERE (t0.USER_NAME) NOT LIKE UPPER('mkienenb') AND (t0.INVALIDATED <> 'Y') AND (t0.INVALIDATED <> 'Y') ORDER BY t0.USER_NAME

I've had this working using webobjects with

qualifier = new EONotQualifier(EOQualifier.qualifierWithQualifierFormat (COLUMN + " caseInsensitiveLike .., args));

so I will try to recreate the situation under a webobjects project and determine what sql can validly be used.

I've also opened a support issue with OpenBase.

---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
http://objectstyle.org/jira/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira

Next message: jir..bjectstyle.org: "[OS-JIRA] Created: (CAY-71) Default OpenBase TIMESTAMP type should be timestamp, not datetime"
Previous message: Andrus Adamchik: "Re: Object Graph Refreshing: design ideas?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Tue Dec 23 2003 - 22:07:18 EST