V4RB Where condition in join query

[Ernesto Giannotta]

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?


Cool Runnings,
erne.