mysql-create_system_tables "proc" table creation
Francesco Riosa <[email protected]> Tue, 19 Apr 2005 12:07:27 +0200
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
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 -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]
mysql-create_system_tables-5.0.patch
(text/x-patch, 650 B)
--- mysql.old/scripts/mysql_create_system_tables.sh 2005-04-19 12:08:40.000000000 +0200 +++ mysql-5.0.4-beta/scripts/mysql_create_system_tables.sh 2005-04-19 12:09:18.000000000 +0200 @@ -714,7 +714,7 @@ c_p="$c_p 'TRADITIONAL'," c_p="$c_p 'NO_AUTO_CREATE_USER'," c_p="$c_p 'HIGH_NOT_PRECEDENCE'" - c_p="$c_p ) DEFAULT 0 NOT NULL," + c_p="$c_p ) DEFAULT '' NOT NULL," c_p="$c_p comment char(64) binary DEFAULT '' NOT NULL," c_p="$c_p PRIMARY KEY (db,name,type)" c_p="$c_p ) comment='Stored Procedures';"