Issue 29736 - Count function broken in Query Designer when used with ODBC data sources
Summary: Count function broken in Query Designer when used with ODBC data sources
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: christoph.lukasiak
QA Contact: issues@dba
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2004-06-01 08:31 UTC by kelvine
Modified: 2006-05-31 14:29 UTC (History)
2 users (show)

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

Attachments
Excel data source to show Count does not work in query (8.50 KB, application/vnd.ms-excel)
2004-06-01 08:32 UTC, kelvine 		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 kelvine 2004-06-01 08:31:36 UTC 
Hi,

Between version 1.1.0 and 1.1.1 the Count function in the Query Designer has 
ceased to work properly when used with an ODBC data source.

I have tested this against an MS Access database which works properly under 
OO1.1.0 and fails under OO1.1.1.

I have also tested this with the attached Excel spreadsheet.

To duplicate this issue.

Set up the attached spreadsheet as a data source
Open the data source window and create a query

In the query we want to Group the teachers in the first field and provide a 
count of the number of times a teachers name appears in the second field.

Select Teacher for the first field and select Group as the function
Select Teacher for the second field and select Count as the function

Run the query.

The error which occurs is:

"[Microsoft][ODBC Excel Driver] You tried to execute a query that does not 
include the specified expression 'TEACHER' as part of an aggregate function."

Testing this on another machine with OO1.1.0 installed shows that it works 
fine.

A work around is to use SQL direct, but this really is not acceptable for end 
users. Obviously another work around is to reinstall OO1.1.0.

Thanks

Kelvin
Comment 1 kelvine 2004-06-01 08:32:37 UTC 
Created attachment 15603 [details]
Excel data source to show Count does not work in query
Comment 2 marc.neumann 2004-06-01 11:12:36 UTC 
reassign to clu
Comment 3 christoph.lukasiak 2004-06-08 13:33:43 UTC 
CLU->kelvine: we definetly had a count problem in former versions, but this
should be already fixed - could you please try your test in a current version
(680m38): http://download.openoffice.org/680/index.html

thx
Comment 4 kelvine 2004-06-08 15:27:47 UTC 
Hi,

Restested this under Win98/OO680m41 and it again works both for Excel and MS 
Access files.

Whilst I will probably leave my clients at OO1.1.0 (unless a bug in that 
version hits them), is it likely this change will make it into the OO1.1.x 
stream.

At this point this is not a concern to me. Just nice to know.

Please close this issue.

Thanks

Kelvin
Comment 5 christoph.lukasiak 2004-06-08 16:18:08 UTC 
CLU->kelvine: the next is the 2.0 (the roadmap and the specification you can
find on oo) - no secrets in this area :)
Comment 6 christoph.lukasiak 2004-06-08 16:19:00 UTC 
close
Comment 7 Frank Schönheit 2004-06-14 07:58:26 UTC 
fs->msc: Just from reading the issue (I did not test anything myself): Since
this is a regression between 1.1.0 and 1.1.1, I suggest we should fix this in
1.1.x line. What's your opinion on this?