Support for sql_mode in CodeIgniter

sysown / proxysql

High-performance MySQL proxy with a GPL license.

http://www.proxysql.com

GNU General Public License v3.0

6.01k stars 978 forks source link

Support for sql_mode in CodeIgniter #1083

Open renecannao opened 7 years ago

renecannao commented 7 years ago

CodeIgniter uses a "bizarre" SET sql_mode:

SET SESSION sql_mode =
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
@@sql_mode,
"STRICT_ALL_TABLES,", ""),
",STRICT_ALL_TABLES", ""),
"STRICT_ALL_TABLES", ""),
"STRICT_TRANS_TABLES,", ""),
",STRICT_TRANS_TABLES", ""),
"STRICT_TRANS_TABLES", "")

Ref : https://github.com/sysown/proxysql/issues/1020#issuecomment-313254496

dennisoderwald commented 7 years ago

Is there news or a workaround? The problem does not seem to be fixed.