[V4Rb] crash with GROUP BY

[Charles Yeomans]

On Wednesday, December 3, 2003, at 06:34  AM, Ruslan Zasukhin wrote:

> on 12/3/03 2:02 AM, Charles Yeomans at yeomans at desuetude.com wrote:
>
>> Valentina doesn't appear to like the following SQL:
>>
>> "SELECT Matters.RecID, SUM(time_worked) FROM Matters, TimeEntries 
>> GROUP
>> BY RecID".
>>
>> It crashes ViSQL; here is a piece of the crash log.
>
> Charles,
>
> Most probably this bug already fixed in latest 1.10 betas
>

Sort of; the query now results in error 346, "field name not unique", 
as does the query

SELECT Matters.recID, SUM(TimeEntries.time_worked) FROM Matters, 
TimeEntries GROUP BY Matters.recID

Charles Yeomans