Hi all !
The following query gave no error earlier in version 5.6
SELECT mr.xid,
fd.fname, fd.lname, fd.cell, fd.email,
a.country_id, a.state_id, a.city_id, a.pin_id,
sd.center_No,
count(sd.fid) total,
sum(case when sd.member_center_status='R' then 1 else 0 end) Acticount
FROM master_recruitment as mr
JOIN user_details as fd ON fd.user_id = mr.xid
JOIN addresses as a ON a.fid = mr.xid
JOIN member_details as sd ON sd.fid = mr.xid
WHERE mr.mid = 6
GROUP by sd.fid, sd.center_No
LIMIT 1, 10;
gives the error : Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mytestdb.a.country_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by; in version 5.7 of mysql.
I have googled but could not really understand the reason the problem is occuring.
Please help
Thanks.