On Thu, 2006-05-25 at 16:04 -0400, Andrus Adamchik wrote: > On May 25, 2006, at 1:34 PM, Øyvind Harboe wrote: > > > NB!!! MS SQL server behaves the same way as MS Access. NB!!! > > > > In my tests HSQLDB will not yield a match for WHERE "foo"="foo<space>" > > And why should it? The two are not equal. (this is VARCHAR's, right?) > > Do you have that test case that actually shows what problems it > causes in Cayenne?
Yes, search for ObjectIdTrailingSpace.java in the attached MS Access adatper work-in-progress + JUnit test to CAY-550. http://issues.apache.org/cayenne/secure/attachment/10393/msaccessadapterwithtestcase.txt The fascinating thing with this test case is that it should: - Fail with HSQLDB - Fail with MS SQL server if constraints stop me from corrupting the database(not yet tested....) - Pass with MS SQL server if constraints are not used - Pass with MS Access Yuk! :-) -- Øyvind Harboe http://www.zylin.com
