Issue 100867

Summary: aggregates out of Base and into Writer table controls are zero
Product: General Reporter: hisdad <john>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: ab, elish, issues
Version: OOO310m8Keywords: needhelp
Target Milestone: ---   
Hardware: Unknown   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
DB with a couple,of records and a query. It works fine
none
The DB, the other is the containing test document none

Description hisdad 2009-04-06 06:13:33 UTC 
It is possible to create a query in base which SELECTS MAX(sometextfield) GROUP
BY Someintfield.

This works perfectly in base.

If you were to then create text document and a Table Object by using this query,
or by entering it as SQL into the Form. The Aggregate field will show as Zero,
if the value is not a representation of an integer.

Or to put it another way, the table object is attempting to perform a cast to
Numeric on that column. Failure results in a Zero.

This issue is with version 3.0.1 as well as the current 3.1 snap.

I shall attach a simple text doc and DB that shows this behaviour.

Priority is 4 because this renders my current project utterly impossible.
Maybe you can fix before 3.1 goes gold.
Comment 1 hisdad 2009-04-06 06:18:08 UTC 
Created attachment 61400 [details]
DB with a couple,of records and a query. It works fine
Comment 2 hisdad 2009-04-06 06:20:15 UTC 
Created attachment 61401 [details]
The DB, the other is the containing test document
Comment 3 Olaf Felka 2010-07-08 15:28:26 UTC 
reassigned
Comment 4 joerg.skottke 2010-07-09 07:28:02 UTC 
Not me, really. Forwarding to MSC