mysql-create_system_tables "proc" table creation

--------------040706040408070505030105
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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


--
No problem is so formidable that you can't walk away from it.
~ Charles M. Schulz
But sometimes run fast is better
~ Francesco R.

--------------040706040408070505030105
Content-Type: text/x-patch;
name="mysql-create_system_tables-5.0.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="mysql-create_system_tables-5.0.patch"

--- 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';"



--------------040706040408070505030105
Content-Type: text/plain; charset=us-ascii

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
--------------040706040408070505030105--