Studio Crash on SQL query

[Balestrieri, John]

Reported, #1925. The attached database is larger than the 500k limit, though.

John


-----Original Message-----
From: valentina-bounces at lists.macserve.net on behalf of Ruslan Zasukhin
Sent: Wed 10/18/2006 3:33 PM
To: valentina at lists.macserve.net
Subject: Re: Studio Crash on SQL query
 
On 18.10.2006 22:19, "Balestrieri, John" <jbalestrieri at ap.org> wrote:

Hi John,

Please report this into Mantis,
    attach small db and this query.

> The enclosed SELECT is crashing Valentina Studio on my database (valentina
> unexpectedly quits). If I omit the column Results.FocusParty there's no crash.
> Results.FocusPart is a calculation field:  if(party='GOP' or
> party='Dem',party,'Other')
> 
> Performing a SELECT on just Results.FocusParty is fine... no crash, and the
> correct results are being returned. Not performing any aggregate
> functions/grouping is also OK -- no crash. I'm going to run this query in Rb
> and see what happens now...
> 
> John
> 
> ------
> 
> SELECT
> Race.CountyName,
> Results.FocusParty,
>         Sum(Results.VoteCount) AS 'VoteTally',
>         Sum(Race.PrecinctsReporting) AS 'PrecinctTally',
>         Sum(Race.TotalPrecincts) AS 'PrecinctTotal'
> 
> FROM 
>         Results,
>         Race
>        
> WHERE
>         Race.RaceCountyID = Results.RaceCountyID
> AND Results.Meta_State = 'CA' --State postal
> AND Race.OfficeID = 'G' --Office
> 
> 
> GROUP BY
> Race.CountyName,
> Results.FocusParty
> 
> ORDER BY
> Race.CountyName,
>         VoteTally DESC

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina


The information contained in this communication is intended for the use of the designated recipients named above. If the reader of this communication is not the intended recipient, you are hereby notified that you have received this communication in error, and that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify The Associated Press immediately by telephone at +1-212-621-1898 and delete this email. Thank you.