Re: Oracle 7.3.3 for NT BUG?

Hi,

I have a similar problem with Oracle 7.3.2.1 on NT. After analyzing the tables some of the queries ( I was able to produce a test case. ) cause the session to be terminated and I get a core dump on the server. A TAR has been logged with Oracle. After deleting the statistics the query works fine. Will pass on any additional information I get on the TAR.

Denny

In article <6uapgs$9vl$1_at_nnrp1.dejanews.com>,   ryanm6741_at_my-dejanews.com wrote:
> I have a strange situation that I believe is an Oracle Bug...
>
> I have two tables (t1, t2 for this example) on which I have analyzed with
> compute statistics. Running a query such as:
>
> select t1.c1 from t1, t2
> where t1.c2=t2.c2 and
> t1.c1=27000
> order by t1.c3 desc
>
> ...I should only get one resulting row. When I run this query, I get results
> that are really WHACKY!!! Removing the 'desc', droping the indexes, or
> deleting statistics results in valid results. Otherwise, I get 100+ rows
> resulting with data that does not look as if it came from the selected table.
>
> What could be going on? Is this a know issue; is it resolved in 7.3.4?
>
> This makes NO sense to me...HELP!
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

--
Denny Varghese Koovakattu
E-Mail : denny_vk_at_hotmail.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 24 1998 - 21:52:04 CDT