Could you possibly submit patch (attach it to CAY-550) with a unit
test that demonstrates the problem - I'll run it on SQLServer.
Andrus
On May 20, 2006, at 3:45 PM, Øyvind Harboe wrote:
> On Sat, 2006-05-20 at 13:34 -0400, Andrus Adamchik wrote:
>> Other adapters address trailing space problem by some combination of
>> a trimming CharType and TrimmingQualifierTranslator (see
>> SybaseAdapter and SQLServerAdapter):
>
> I see this problem w/MS SQL server as well as MS Access. I suspect the
> same problem exists with all database types and further that this
> problem has nothing to do with trimming trailing space of database
> fields.
>
> The primary key is a VARCHAR, so I believe that Cayenne is correctly
> translating the VARCHAR to have a trailing space.
>
> The primary key(VARCHAR) in my case is stored *without* the trailing
> space. The reference to the primary key in other tables sometimes
> have a trailing space which is where the trouble starts since WHERE
> "foo"="foo<SPACE>" will yield a match, whereas ObjectId will not
> yield
> a match in this case.
>
>> From my limited understanding of the finer points of Cayenne & SQL, I
> can arrive at no other conclusion than that ObjectId's concept of
> equality should match that of SQL's concept of equality in a WHERE
> clause.
>
>
>
>
> --
> Øyvind Harboe
> http://www.zylin.com
>
>
This archive was generated by hypermail 2.0.0 : Sat May 20 2006 - 16:11:36 EDT