MySQL Forums
Forum List  »  Newbie

Re: Reverting SQL Standard to SQL-92
Posted by: Arun Kumar
Date: October 16, 2018 11:57PM

"The Group By feature is defeated by setting @@only_full_group_by. "
How so?
WE tried setting it to ANSI and "only_full_group_by"
Both produced identical results [ this is with respect to our case]

Our Scenario:
SELECT a.sno,b.sno,a.name,b.location
FROM Name AS a
JOIN Location AS b ON a.sno=b.sno
GROUP BY a.sno,b.location

This works in Mysql5.7.18 but not on Mysql 5.6, we need 'GROUP BY' to work as before
Any solutions ?

Options: ReplyQuote


Subject
Written By
Posted
October 09, 2018 07:26AM
Re: Reverting SQL Standard to SQL-92
October 16, 2018 11:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.