MySQL Bugs: #21566: Query Working With Windows XP is not Working in LINUX 2.4.20-8

Bug #21566	Query Working With Windows XP is not Working in LINUX 2.4.20-8
Submitted:	10 Aug 2006 12:25	Modified:	10 Sep 2006 12:35
Reporter:	saravanan Amoor	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	VERSION 5.1.17	OS:	Linux (LINUX 2.4.20-8)
Assigned to:		CPU Architecture:	Any

Description:
Hai,
        The below mentioned query is working in windows xp, but  not in linux 2.4.20-8. May I know why it happens? 
  
SELECT SQL_CALC_FOUND_ROWS  H.HQ_DIST_CODE,max(H.MDM_DIST_NAME) as MDM_DIST_NAME,  
SUM(p.PAY_TOTAL) AS "TOTPENDING"  FROM view_hq_distributor_mast H  ,payable_dtl p where p.HQ_DIST_CODE = H.HQ_DIST_CODE  GROUP BY H.HQ_DIST_CODE ORDER BY TOTPENDING DESC  LIMIT 0,25

 It throw error like: " 1055  'view_hq_distributor_mast.H.MDM_DIST_NAME' isn't in GROUP BY

How to repeat:
.

Suggested fix:
.

Thank you for the bug report. Could you please provide a repeatable script
test case and the correct server version, 5.1 in source tree is today:

miguel@hegel:~/dbs/5.1> libexec/mysqld -V
libexec/mysqld  Ver 5.1.12-beta-debug for suse-linux on i686 (Source distribution)

and you are reporting 5.1.17, could be 5.0.17? in this case please test
released version 5.0.24.

Thanks in advance.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".