Re: mysql-create_system_tables "proc" table creation

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

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]