We tested with ColdFusion and MySQL and are a little puzzled. We know that in the /etc/my.cnf file you can set different "sql-mode" flags, which will cause MySQL to behave in a certain way, depending on certain modes. We know that you can also set these flags when starting MySQL using the -sql-mode = flags.
In / etc / my.cnf we see that there were no specific modes (one of them was commented out), so we added 'sql-nodes = ""' and restarted mysql (restarting / etc / init.d / mysqld), Any time we go to the MySQL command line to find out which mode is set, here is the output:
mysql> SELECT @@GLOBAL.sql_mode;
+-------------------+
| @@GLOBAL.sql_mode |
+-------------------+
| |
+-------------------+
1 row in set (0.00 sec)
mysql> SELECT @@SESSION.sql_mode;
+--------------------+
| @@SESSION.sql_mode |
+--------------------+
| |
+--------------------+
1 row in set (0.00 sec)
This tells me that there is no mode for what we are going. However, doing the same in ColdFusion 8, we see the following:
SELECT @@GLOBAL.sql_mode;
[empty string]
SELECT @@SESSION.sql_mode;
STRICT_TRANS_TABLES
, sql- , sql- "STRICT_TRANS_TABLES", .
sql-mode ColdFusion , - , , .
() /etc/init.d/mysqld script, , , , .
, , - , ? ColdFusion -, ColdFusion , , .