Re: Weird SQL error in 8.1.6

Ditto: Cannot reproduce you error on 8.1.6. Must be specific to some particular circumstance.

"Jining Han" <hanj_at_mailcity.com> wrote in message news:95fes8$snc$1_at_nnrp1.deja.com...
> I ran this in 8.0.4 and 8.1.6 without any problems! Apparently the
> parser sees the and as a key word and processes the statement as
> normal , though the vendor script apparently forgot to put a space
> between '1'and. Do you think Oracle changed its parser in a minor
> release/build? It'd be interesting to know.
>
> --
> Jining Han
> Sallie Mae
>
>
> In article <95fc8b$io7$1_at_news.duke.edu>,
> "John Jones" <john.jones_at_duke.edu> wrote:
> > We are in the middle of testing of upgrading from Oracle 8.0.5.1 to
 8.1.6.2
> > My technical team has come up with an interesting error that Oracle
 Support
> > seems unable to reproduce or answer. We have a vendor package that
> > generates SQL code and then submits it. Below is an example of the
 code we
> > are having problems with. The code will run in 8.0.5.1 but not in
 8.1.6.1
> > We are running AIX 4.3.3
> >
> > select sysdate from dual where '1' = '1'and '2' ='2'
> > /
> >
> > **** notice that there is no space between '1'and **********
> >
> > Anybody ever see this behaviour or can you recreate on your system.
> >
> > --
> > John Jones
> > Senior Oracle DBA
> > Duke University, OIT
> > john.jones_at_duke.edu
> > 419-5737
> >
> >
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Feb 03 2001 - 14:37:59 CST