Default SQL modes for MySQL 8 are incorrect
complete
Rob Taylor
The documentation states ANSI as being included in the default sql modes "The default SQL modes for MySQL on managed databases are as follows:". However, as of now on new MySQL 8 managed DB deployments, ANSI_QUOTES is the mode which is set, and not the ANSI shorthand mode.
Also, some explanation as to why this mode is the default on DO managed databases when it's not one of the default MySQL 8 SQL modes would be appreciated.
G
Gabriel Marimón
marked this post as
complete
G
Gabriel Marimón
Thank you for your feedback, Rob! We've updated the page to include the most up-to-date list of default SQL modes: