Issue 10479 - Incorrect results from Count(*) in database query
Summary: Incorrect results from Count(*) in database query
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
: 14556 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-01-06 13:38 UTC by tonybloom
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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

Attachments
1. script to load sample dbase. 2. .odbc.ini extract (2.59 KB, text/plain)
2003-01-06 13:42 UTC, tonybloom 		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 tonybloom 2003-01-06 13:38:56 UTC 
Using   o Suse Linux 8.1 
        o unixODBC 2.2.2 
        o myodbc 3.10.4 
        o mysql  Ver 11.18 Distrib 3.23.52, for suse-linux (i686) 
The query 
 
select price_range, count(*) from testcds group by price_range 
 
produces correct values for price_range field but count is always zero. 
 
This happens both within data source view, and when run within a Basic macro. 
 
The query works correctly in the UnixODBC utility isql.
Comment 1 tonybloom 2003-01-06 13:42:37 UTC 
Created attachment 4218 [details]
1. script to load sample dbase. 2. .odbc.ini extract
Comment 2 marc.neumann 2003-01-13 09:16:56 UTC 
Hi,

This is a problem with oder myodbc drivers, please use the newest
myodbc driver which is 3.51.5. With this driver the problem doesn't
occure anymore.

Bye Marc
Comment 3 marc.neumann 2003-01-13 09:17:11 UTC 
closed
Comment 4 Unknown 2003-05-22 13:49:04 UTC 
*** Issue 14556 has been marked as a duplicate of this issue. ***
Comment 5 hans_werner67 2004-02-02 12:32:00 UTC 
change subcomponent to 'none'