MySQL Forums
Forum List  »  Views

Comments and sql formatting in views
Posted by: Antonio Garcia
Date: June 27, 2017 05:56AM

Hi,

This is really odd.

I have a few servers running different version of MySQL (5.4, 5.5., 5.6, 5.7...).
When creating a view like the one below in all servers some of them change the SQL query completely and take the comments out...but some others keep the format and the comments. I have checked everything, version of MySQL, my.conf...but I cannot find what the option is to keep or not the format and comments in.

/*
testing
*/
SELECT * FROM table1

=> changed to

SELECT 'table1'.'field1','table1','field2' from 'table1'

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Comments and sql formatting in views
869
June 27, 2017 05:56AM


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.