mysql-create_system_tables "proc" table creation - Bastian Balthazar Bux - com.mysql.lists.bugs

3 messages in com.mysql.lists.bugsmysql-create_system_tables "proc" tab...

From	Sent On	Attachments
Francesco Riosa	19 Apr 2005 03:07	.patch
Bastian Balthazar Bux	19 Apr 2005 03:07	.patch
Sergei Golubchik	25 Apr 2005 03:34

Subject:	mysql-create_system_tables "proc" table creation
From:	Bastian Balthazar Bux (Bast...@pnpitalia.it)
Date:	04/19/2005 03:07:42 AM
List:	com.mysql.lists.bugs
Attachments:	mysql-create_system_tables-5.0.patch - 0.6k

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)

sql_mode set( 'REAL_AS_FLOAT', .... 'HIGH_NOT_PRECEDENCE' ) DEFAULT '' NOT NULL

attached there is a patch that change this default, mysql-5.0.4-beta used as base

Best regards Francesco