MySQL Forums
Forum List  »  Newbie

Re: Reverting SQL Standard to SQL-92
Posted by: Peter Brawley
Date: October 24, 2018 10:03AM

> Making it primary key would mean GROUP BY doesn't require name column in Name Table since sno is unique

Doesn't follow. The issue is functional dependency of `name` on `sno---data determines whether an error occurs, so please post a test case that reproduces the problem,

Options: ReplyQuote

Written By
October 09, 2018 07:26AM
Re: Reverting SQL Standard to SQL-92
October 24, 2018 10:03AM

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.