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 ?
Subject
Written By
Posted
Re: Reverting SQL Standard to SQL-92
October 16, 2018 11:57PM
November 01, 2018 12:18AM
November 14, 2018 08:38AM
November 14, 2018 11:31AM
November 15, 2018 08:50AM
November 26, 2018 02:07AM
November 26, 2018 11:03AM
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.