V4RB Where condition in join query

[Ivan Smahin]

Hello Ernesto,

Thursday, June 5, 2008, 10:59:21 PM, you wrote:

> Thanks Ivan,

> On 05-giu-08, at 20:56, Ivan Smahin wrote:

>> 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.

> Another thing I've noticed is that resulting cursor is writable,
> shouldn't it be read only since it's a result of a join?

It will be RO anyway.

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