Issue 94343 - "Function" in query designer breaks query
Summary: "Function" in query designer breaks query
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: ReportBuilder (show other issues)
Version: OOO300m7
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-09-25 20:09 UTC by leggewie
Modified: 2008-09-26 20:06 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
base debug file (10.41 KB, application/vnd.sun.xml.base)
2008-09-26 13:33 UTC, leggewie 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description leggewie 2008-09-25 20:09:42 UTC 
steps to reproduce problem:
* open the attached base file
* open "unnormalized table" query in edit mode
* Press F5, the query runs fine
* return to edit mode
* set Function "count" for productName field
* press F5 again

error message: "The data content could not be loaded.

not in aggregate function or group by clause: $somelengthySQLstatement"
Comment 1 leggewie 2008-09-26 13:33:05 UTC 
Created attachment 56852 [details]
base debug file
Comment 2 leggewie 2008-09-26 19:35:17 UTC 
Invalid bug. I needed to use group and function simultaneously (group by
category and count number of products for example). Thanks go to Mechtilde for
pointing out my obvious Paul.
Comment 3 Mechtilde 2008-09-26 20:06:17 UTC 
-> closed