On Wed, 19 Oct 2005, Dann Corbit wrote:
> Yes, clearly that is the wrong result according to the SQL standard.
>
> Here is a SQL*Server query:
> select 1 where 'a' = 'a ' AND 'a' = 'a ' AND 'a ' = 'a '
>
> It returns (correctly): 1
Doesn't that depend on the collating sequence in use, or is a NO PAD
collating sequence not allowed here?
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
