MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: How do I permanently disable ONLY_FULL_GROUP_BY
Posted by: Peter Brawley
Date: April 01, 2022 10:13AM

Okeh, strace finds just what you found.

The sql_mode setting you're seeing is the 8.0 default ...

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

Evidently MariaDB is not finding ...

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

... or is overwriting it with a default. You'll need to ask at the MariaDB site why that might be so.

As a workaround, you might add your sql_mode setting to every .cnf file in sight.

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.