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 ?
Subject
Written By
Posted
Reverting SQL Standard to SQL-92
October 09, 2018 07:26AM
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.