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 Fri Feb 02 2001 - 17:12:16 CST
