in reply to Re: Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI
in thread [SOLVED] Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI

I think that set_strict_mode is a DBIx::Class thing, not vanilla DBD::mysql. Though the underlying sql_mode settings can certainly be set either way. And I wouldn't conceptually lump compatibility settings like handling of double quotes with actual strict modes, which should definitely be used in all new code.
  • Comment on Re^2: Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI