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: Problem with a view: table from it contains wrong number of rows

Re: Problem with a view: table from it contains wrong number of rows

From: <schonlinner_at_yahoo.com>
Date: 17 Feb 2006 12:38:39 -0800
Message-ID: <1140208719.377959.219850@g14g2000cwa.googlegroups.com>


Sybrand Bakker wrote:

> Check for implicit type conversions, both in creating the view and in
> selecting from the view.

I already thought about that: Perhaps it's a NULL value in the view which gets eliminated by the "group by", and then for an unknown reason appears in the view, but not in the table, as it has been "grouped" to another group...

But no luck: The three "group by" fields contain not null three-letter airport codes, all of type CHAR(3), the values afterwards indeed often contain NULL (they are numbers).

So at last when doing a "select * from t_200601 where a='TXL' and b='MUC' and c='BER';" and querying the three not-null fields I must have found that specific, definitely available row. This combination (i.e. "group") is available in the base table, it's available in view V1, V2 and the view v_200601, but it's not available in table t_200601 (created as select * from v_200601)...

Regards,
  Alex Received on Fri Feb 17 2006 - 14:38:39 CST

Original text of this message

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