Re: Oracle SQL bug in 9.2.0.8

On Feb 10, 11:06 am, DG problem <skatef..._at_gmail.com> wrote:
> I've only just come across this possible SQL bug and was wondering why> this SQL returns a result? I got it through an email and had to change> it to Oracle's syntax as the original used the concat operator of +> and it didn't use DUAL.>> -- Note the spaces after 'WHY '> select> '<'||Y||'>', Y> from> ( select 'WHY ' Y from dual) x> where> Y = 'WHY'> ;>> P.S. Yes I know that 9i is well and truly obsolete :)

Same in 10gr2. And I suspect it'd be the same in 11g.
I think you've been trapped by implicit conversion in Oracle, which
doesn't happen in the original MSSQL.

This produces the expected result and eliminates implicit conversions: