V4RB Where condition in join query

[Ernesto Giannotta]

Hi Ivan,

On 05-giu-08, at 22:06, Ivan Smahin wrote:

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

So why it shows up as Writable in the debugger and, worst, the  
Cursor.AddRecord function returns a non zero value?

I can confirm that no data is actually written in the cursor and the  
table, but this is really weird behaviour.


Anyway I can live with it

I'm a lot more concerned about the ReadPicture crash I reported in  
previous post.
This is causing me big trouble since I can't runaround it without  
writing my own getPicture function.

What's worst I can't currently reproduce it reliably in a demo, but I  
really need a fix for this urgently.




Cool Runnings,
erne.