[CAY-835] setting meaningful pk to zero turn on autogenerated keys

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0M2
• Component/s: Core Library
• Environment: 3.0M1, derby, mac, java 5
• Assignee: Unassigned
• Reporter: Tore Halset
• Created: 30/Jul/07 07:37
• Updated: 09/Nov/08 01:07
• Resolved: 03/Aug/07 07:17

Description

Having a table with a int primary key mapped to a Integer. Setting this value to Integer.valueOf(0) makes cayenne create its own primary key. So instead of value zero, the primary key will be 200 or whatever.

Here is a test that shows this behaviour:
public void testInsertWithMeaningfulPKValueZero() throws Exception

{ Integer zero = new Integer(0); MeaningfulPKTest1 obj = (MeaningfulPKTest1) context .newObject("MeaningfulPKTest1"); obj.setPkAttribute(zero); obj.setDescr("aaa-aaa-bbb"); context.commitChanges(); assertEquals(zero, obj.getPkAttribute()); ObjectIdQuery q = new ObjectIdQuery(new ObjectId( "MeaningfulPKTest1", MeaningfulPKTest1.PK_ATTRIBUTE_PK_COLUMN, zero.intValue()), true, ObjectIdQuery.CACHE_REFRESH); assertEquals(1, context.performQuery(q).size()); }