FIXED: [V4MD] problem w/ Group By

[Ruslan Zasukhin]

on 3/17/03 9:03 PM, X Y at xyzabc1010 at yahoo.com wrote:

Hi X Y,

Thank you VERY MUCH for this bug report.
It have discover very interesting logic bug.

BUG:  summary functions on JOIN with one record,
      did not produce result.

----------------
> Hi Ruslan,
> Yes there is a problem in viSQL also. For instance, if
> you execute this query:
> 
> "select Student.username , Activity.activity_name ,
> count(*) from  Session , Activity , Student  where
> Student.username = 'Test02' AND Activity.activity_name
> = 'sd' GROUP BY Student.username,
> Activity.activity_name, Session.begin_date"
> 
> You will get nothing in return. However, if you take
> out the count(*) and execute this query, you will see
> one record returned.
> 
> "select Student.username , Activity.activity_name from
> Session , Activity , Student  where Student.username
> = 'Test02' AND Activity.activity_name = 'sd' GROUP BY
> Student.username, Activity.activity_name,
> Session.begin_date"


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------