Select on View

[Ruslan Zasukhin]

On 29/7/07 4:21 PM, "Beatrix Willius" <bwillius at gmx.de> wrote:

> Hello,
> 
> is the following a problem or a feature:
> 
> - The table Message contains a field called CheckSum.
> - A view is created with
> 
> create or replace view CheckDuplicates as (select CheckSum, count
> (CheckSum) as CountOfDup from Message group by CheckSum)
> 
> - A view is created on this view
> 
> create or replace view DeleteDups1 as (select RecID, * from Message
> inner join CheckDuplicates on CheckDuplicates.CheckSum =
> Message.CheckSum where CheckDuplicates.CountOfDup > 1)
> 
> - A select done on this view like the very simple
> 
> select * from DeleteDups
> 
> gives the error message
> 
> 15:18:48: Error: Field name "CheckSum" is not unique.
> 15:18:48: Error: Kernel error: 0x80501
> 15:18:48: Error: Field name "CheckSum" is not unique.

I think it is a bug (of e.g. MS SQL can do this :-)
So please add into Mantis for Ivan.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]