Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query gives incorrect results

Re: Query gives incorrect results

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 05 Jun 2003 03:37:21 GMT
Message-ID: <RVyDa.602$BG1.327@news01.roc.ny.frontiernet.net>


This might just be a BUG/problem related to your 7 -> 9i upgrade. I do not see problems with any of the queries you posted in our 9.2.0.3 db's.

Anurag

"Edzard" <edzard_at_volcanomail.com> wrote in message news:5d75e934.0306040440.7cb23b11_at_posting.google.com...
> Here is another case. Again it is an artificial query, written just to
> reproduce certain behaviour of 9.2.0.3 RDBMS.
>
> SELECT COUNT (*)
> FROM dba_indexes i, dba_ind_columns ic, dba_tab_columns c
> WHERE i.table_owner = 'SYS'
> AND ic.index_name = i.index_name
> AND ic.table_name = i.table_name
> AND ic.table_owner = i.table_owner
> AND ic.column_position =
> (SELECT MIN (ic2.column_position)
> FROM dba_ind_columns ic2
> WHERE ic2.index_name = ic.index_name
> AND ic2.table_name = ic.table_name
> AND ic2.table_owner = ic.table_owner)
> AND c.table_name = ic.table_name
> AND c.owner = ic.table_owner
> AND c.column_name = ic.column_name
> AND c.data_type = 'VARCHAR2'
> /
>
> COUNT(*)
> ----------
> 306
>
> Now change COUNT (*) to * and at the bottom of the output you get:
>
> 51 rows selected.
Received on Wed Jun 04 2003 - 22:37:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US