CODEWITHSUNDEEP
mysql
sita3021
sita3021

Reputation: 71

Show mysql ONLY_FULL_GROUP_BY violations as warnings

Doing MYSQL update, and it would be awesome if I could use the application as is, and see the ONLY_FULL_GROUP_BY violations as warnings, so I could test the different features one-by-one, without fixing all the queries first. Is there a way to do this with PDO?

Upvotes: 1

Views: 79

Answers (1)

Shadow
Shadow

Reputation: 34285

Unfortunately, when you disable ONLY_FULL_GROUP_BY, then mysql is not going to generate a warning if the query broke the sql standard on group by, therefore there is no warning that PDO could capure and report.

Upvotes: 1

Related Questions