MySQL 5.7 strict mode

[emanuele45]

http://www.elkarte.net/community/index.php?topic=4185.0 http://www.elkarte.net/community/index.php?topic=4443.0

If I got it right, "strict mode" is basically "let's use more SQL instead of our own dialect", so I guess we could just pick all the "tricks" we have in place for PostgreSQL and make them default. AFAIK the "correct" SQL syntax should work the same in old MySQLs as well. Or am I wrong?

Since we kind of support 5.7 (at least we have some tests), I would consider the dirty trick for 1.0.x and a proper fix for either 1.1 final or one of the micro just after (1.1.1 or 1.1.2).

What do you think?

[albertlast]

in my eyes the right way. maybe you should go one step further, and force strict mode on mysql setups.

[emanuele45]

Let's defer this to 2.0. Change mysql mode now is quite tricky, better have some development time ahead and the freedom to break everything! :D

[Spuds]

Fixed long ago