Title:
Bug 82075:ID of ormtype='char' is compared case-senstively with CF string comparison operators
| View in TrackerStatus/Resolution/Reason: Closed/Won't Fix/
Reporter/Name(from Bugbase): Henry Ho / Henry Ho (Henry Ho)
Created: 02/12/2010
Components: ORM Support
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Minor / Unknown
Locale/System: English / Platforms All
Vote Count: 0
Problem:
ID of ormtype='char' is compared case-senstively with CF string comparison operators. ID of ormtype="string" of length="1" is not affected.
Method:
component name="Status" persistent="true"{/** 'N' is new */
property name="id" type="string" ormtype="char" fieldtype="id" column="StatusID"; }
// assume the following coded already executed
n = new Status();
n.setID('N');
entitySave(n);
// then try this, both loaded 'casuse of MS SQL default collation:
n1 = entityLoadByPK("Status", "N");
// ID is 'N'
n2 = entityLoadByPK("Status", "n");
// ID is 'n'
writeDump(n1.getID() == n2.getID());
// expected: true , actual: false
Result:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3040932
External Customer Info:
External Company:
External Customer Name: Henry Ho
External Customer Email: 237A22C24921EDF5992015B9
External Test Config: 02/12/2010
Attachments:
Comments: