Re: VARCHAR and trailing space

From: Øyvind Harboe (oyvind.harbo..ylin.com)
Date: Thu May 25 2006 - 16:26:38 EDT

  • Next message: Andrus Adamchik: "Fwd: Call for Papers Opens for ApacheCon US 2006"

    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

    This archive was generated by hypermail 2.0.0 : Thu May 25 2006 - 16:27:22 EDT