MySQL Forums
Forum List  »  Newbie

Reverting SQL Standard to SQL-92
Posted by: Arun Kumar
Date: October 09, 2018 07:26AM

After upgrading to Mysql 5.7.18, queries which are invalid by SQL-92 Standard are getting executed in mysql (sql_mode is set to "ANSI").
After doing a little reading about Mysql 5.7 features over previous editions,
I found that Mysql switched SQL standards to SQL-99 from SQL-92 which may allow queries if all functionally independent columns are mentioned in group by.

Is there any way to revert the SQL standard by which all queries are validated to previous standards such as SQL-92 ?

Options: ReplyQuote


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


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.