[OS-JIRA] Created: (CAY-112) The Remove of an Member of an Array creates an Update and sets the foreign key to null

From: jir..bjectstyle.org
Date: Mon Mar 29 2004 - 09:34:07 EST


Message:

  A new issue has been created in JIRA.

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

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

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: CAY-112
    Summary: The Remove of an Member of an Array creates an Update and sets the foreign key to null
       Type: Bug

     Status: Assigned
   Priority: Major

    Project: Cayenne
   Versions:
             1.1 [DEV]

   Assignee: Andrus Adamchik
   Reporter: Achim Dreyer

    Created: Mon, 29 Mar 2004 9:32 AM
    Updated: Mon, 29 Mar 2004 9:32 AM
Environment: Windows XP as Client; SQL Server 2000 on Windows 2000

Description:
From the Object DboUser i call the method remove removeFromDboUserContextArray.

Cayenne executes the Statement :
UPDATE dbo.DBO_User_Context SET userID = ? WHERE ID = ? AND contextID = ? AND userID = ?
[bind: NULL, 3, 5, 8]

I my oppinion the statement should look like:

Delete from dbo.DBO_User_Context where id = ?
[bind: 3]

I upload my DataMap and a small sample program after opening this Bugs.

Regards from good old Germany
Achim

---------------------------------------------------------------------
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 : Mon Mar 29 2004 - 09:34:10 EST