To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=50175
User wurzel changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|INVALID |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sun Jan 15 07:39:31 -0800
2006 -------
Hmm..., try this query in a hsqldb and parameterized querying with a query
already containing an aggregate function (SUM, COUNT, AVG, etc) fails :
SELECT SUM( "collecte"."Litrage" ) AS "Litrage par mois", "collecte"."mois",
"Adhérents"."Société", "Adhérents"."Nom", "Adhérents"."Prénom",
"Adhérents"."Adresse", "Adhérents"."CP", "Adhérents"."Ville" FROM "collecte"
"collecte", "Adhérents" "Adhérents" WHERE ( "collecte"."Producteur" =
"Adhérents"."Nom" ) GROUP BY "collecte"."mois", "Adhérents"."Société",
"Adhérents"."Nom", "Adhérents"."Prénom", "Adhérents"."Adresse",
"Adhérents"."CP", "Adhérents"."Ville" HAVING ( ( "collecte"."mois" = :mois ) )
The above is the query constructed by OOo 2.0.2 (m150) when the query was built
using the GUI query builder.
In order to compare, the following queries work :
SELECT SUM( "Litrage" ), "Cuve" FROM "collecte" "collecte" GROUP BY "Cuve"
SELECT "Date", "Producteur", "Litrage", "mois" FROM "collecte" "collecte" WHERE
( ( "mois" = :mois ) )
The sample database is included.
Setting oooqa and confirming.
alex
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
