MySQL Forums
Forum List  »  Newbie

Re: Reverting SQL Standard to SQL-92
Posted by: Arun Kumar
Date: October 19, 2018 01:21AM

I don't think you get my Problem. I will repeat it for clarity.
Problem:
Prior to upgrading Mysql to 5.7 ,we used Mysql 5.5 which has also has sql_mode='only_full_group_by'. This worked seamlessly.
After upgrading to Mysql 5.7 the "only_full_group_by" mode which follows SQL-Standard 99 started allowing queries that failed in Mysql5.5
E.g.,
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 would fail in Mysql 5.5 (or) 5.6, but will get executed properly in Mysql 5.7.
We want group by to work the same along all editions, so any way to revert it back to way it worked in Mysql 5.5 [We are setting the sql_mode - "only_full_group_by"]?

Options: ReplyQuote


Subject
Written By
Posted
October 09, 2018 07:26AM
Re: Reverting SQL Standard to SQL-92
October 19, 2018 01:21AM


Sorry, only registered users may post in this forum.

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.