Hi!
On Apr 19, Francesco Riosa wrote:
here "mysql_create_system_tables" invoked from "mysql_install_db" try to
create the `mysql`.`proc`.`sql_mode` with a default of 0 (zero) .
sql_mode is a set and it should be defaulted to '' (empty string)
It's only partically correct.
SET is a string type, and '' is the correct value for an empty set.
But one can assign numeric values to it, and then set will be
initialized according to bits set in that number. Thus, 0 is correct
too :)
http://dev.mysql.com/doc/mysql/en/set.html
Regards,
Sergei