V4RB Where condition in join query

[Ivan Smahin]

Hello Erne,

Thursday, June 5, 2008, 8:10:36 PM, you wrote:

> Hi Ruslan,

> I got this query:

> Select m.Recid as [m_Recid], m.Media_Description, m.Euro_Price,  
> m.Stock, m.Edition_Date, a.Artist, b.Title, b.Recorded, m.Media,  
> m.Items_in_Box, m.Filed_Date, m.Barcode
>  From [Media] m
> Inner Join [Alb_Med_Linker] bmk On Alb_Med_Linker_Med_link
> Inner Join [Albums] b On Alb_Med_Linker_Alb_link
> Inner Join [Art_Alb_Linker] abk On Art_Alb_Linker_Alb_link
> Inner Join [Artists] a On Art_Alb_Linker_Art_link
>   Where False

> that returns more than 70000 records...
> shouldn't it retun 0 records since Where condition is false?

Report it to Mantis please.
Definitely it should be zero records.

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com