MySQL Forums
Forum List  »  Newbie

Re: Reverting SQL Standard to SQL-92
Posted by: Arun Kumar
Date: October 23, 2018 04:33AM

You can reproduce it you using Mysql 5.7 and above, what version are you using?

Create two tables Name ,location
Make sno column in "Name" table Primary Key [ Making it primary key would mean GROUP BY doesn't require name column in Name Table since sno is unique ]

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

The above query would get executed.. But in Mysql 5.6 and below, this query fails, I tried it. I need this query to fail in Mysql 5.7, what options do I have?

Options: ReplyQuote


Subject
Written By
Posted
October 09, 2018 07:26AM
Re: Reverting SQL Standard to SQL-92
October 23, 2018 04:33AM


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.