Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-338
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-338
Summary: Sybase Identity Syntax
Type: New Feature
Status: Assigned
Priority: Major
Project: Cayenne
Components:
Cayenne Core Library
Versions:
1.2 [DEV]
Assignee: Andrus Adamchik
Reporter: Joe McDaniel
Created: Mon, 27 Jun 2005 2:18 PM
Updated: Mon, 27 Jun 2005 2:18 PM
Environment: Sybase
Description:
For Sybase, the syntax for using identity is a bit different than for SQLServer. You currently generate "CREATE TABLE myTable (IdNum int NOT NULL IDENTITY (1, 1))" but for Sybase the syntax needs to be just "IDENTITY" and, if you must set the increment, that goes on the end as in "create table mytable (IdNum numeric(12,0) identity) with identity_gap = 10".
You can probably simplify the current generator to never put out the (1, 1) since that is probably the default for SQLServer and Sybase defaults to incrementing by 1.
---------------------------------------------------------------------
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 Jun 27 2005 - 14:18:37 EDT