[OS-JIRA] Created: (CAY-231) Generated SQL ends in "WHERE column = NULL"

From: jir..bjectstyle.org
Date: Tue Nov 09 2004 - 12:20:46 EST

  • Next message: jir..bjectstyle.org: "[OS-JIRA] Created: (CAY-232) modeler throws an exception in various circumstances"

    Message:

      A new issue has been created in JIRA.

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

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

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-231
        Summary: Generated SQL ends in "WHERE column = NULL"
           Type: Bug

         Status: Assigned
       Priority: Major

        Project: Cayenne
     Components:
                 Cayenne Core Library
       Versions:
                 1.1

       Assignee: Andrus Adamchik
       Reporter: Bryan Lewis

        Created: Tue, 9 Nov 2004 12:19 PM
        Updated: Tue, 9 Nov 2004 12:19 PM
    Environment: Cayenne 1.1RC2, j2sdk1.4.2_04, Windows XP local, Oracle 8i on Solaris.

    Description:
    I'm attaching jd.zip, See ReadMe.txt. The heart of it is:

        // This should return a list of 3 records, using SQL like:
        // SELECT * FROM CRCOMPANIESTOWATCHFORUSERS t0 WHERE t0.USERNAME = 'some value'
        // Instead the SQL ends in "t0.USERNAME = NULL".
        List cwList = user.getCompaniesToWatch();

    That's a simple one-to-many relationship using a VARCHAR field as the key.

    ---------------------------------------------------------------------
    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

    This archive was generated by hypermail 2.0.0 : Tue Nov 09 2004 - 12:20:49 EST