3 messages in com.mysql.lists.bugsRe: mysql-create_system_tables "proc"...
FromSent OnAttachments
Francesco Riosa19 Apr 2005 03:07.patch
Bastian Balthazar Bux19 Apr 2005 03:07.patch
Sergei Golubchik25 Apr 2005 03:34 
Subject:Re: mysql-create_system_tables "proc" table creation
From:Sergei Golubchik (se@mysql.com)
Date:04/25/2005 03:34:45 AM
List:com.mysql.lists.bugs

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