Daniel John Debrunner <[EMAIL PROTECTED]> writes: > Rick Hillegas wrote: > >>> Rick, why do you believe that Derby will return a subset of the >>> rows, it doesn't seem to follow from any of the other posts in this >>> thread? >>> >>> Dan. >> Hi Dan, >> >> Thanks for helping me puzzle through this. Consider the example we >> are working with, a collation in which 'z' = 'xy'. What happens with >> the following insert: >> >> insert into T(A) values ( 'zcb' ), ( 'xycb' ) >> >> followed by this query: >> >> select * from T where T.A like 'xy_b' >> >> If I understand what is being said, it seems like the following >> happens: the ANSI rules return both rows but Derby returns only ( >> xycb' ) > > I thought Derby was following the ANSI rules for LIKE. From memory, > LIKE operators on a character by character basis, not collation > elements.
Yes, I remember that we discussed this and came to that conclusion. See ISO/IEC 9075-2:2003 (E), Section 8.5 <like predicate>, general rule 3c. -- Knut Anders
