[SQL-CVS] [ sqlobject-Bugs-2855422 ] sybase tables with identity column fire two identity_inserts

[SourceForge.net <no...@so...>]

Bugs item #2855422, was opened at 2009-09-09 14:13
Message generated for change (Tracker Item Submitted) made by mcw_chi
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=2855422&group_id=74338

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Sybase
Group: SQLObject from repository
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Matthew Wright (mcw_chi)
Assigned to: Nobody/Anonymous (nobody)
Summary: sybase tables with identity column fire two identity_inserts

Initial Comment:
All tables with an identity column will cause the sybaseconnection to execute two 'SET IDENTITY_INSERT tablename on/off' for every row insert, even if the user is not supplying the id.

The set identity_insert command requires object ownership or sa privs.

Attaching a patch that allows inserts to work for the usual case of not supplying the identity column.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=2855422&group_id=74338