Re: ORACLE DOESN'T COMPLY TO BASIC STANDARD SQL: SIMPLE QUERIES DOESN'T WORK

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORACLE DOESN'T COMPLY TO BASIC STANDARD SQL: SIMPLE QUERIES DOESN'T WORK

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 24 Sep 1999 11:01:10 +0100
Message-ID: <938169968.24939.0.nnrp-13.9e984b29@news.demon.co.uk>

The expression you are looking for is:

"There is a bug in the rule-based optimiser which causes some SQL statements to fail."

Fortunately this was fixed in the cost based optimiser quite a long time ago.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

laurent_pele_at_my-deja.com wrote in message <7scu8a$sjo$1_at_nnrp1.deja.com>...
>ORACLE DOESN'T COMPLY TO BASIC STANDARD SQL: SIMPLE QUERIES DOESN'T WORK
>
>BUG on all Oracle versions including 8.0.5.0.0 Oracle Server on Unix
>
>I found it in July 1994, yes 1994 ! tested on V7 Netware, V6 SUN, V6 Dos
>standalone,
Received on Fri Sep 24 1999 - 05:01:10 CDT