# cmd: C:\usr\daemon\mysql\bin\mysql.exe --port=3333 --user=root --tee=log.root.txt

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.41-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE SCHEMA `bug`;
Query OK, 1 row affected (0.00 sec)

mysql> CREATE TABLE `bug`.`test` (`id` INTEGER, PRIMARY KEY(`id`)) ;
Query OK, 0 rows affected (0.02 sec)

mysql> SET SESSION SQL_MODE="";
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE PROCEDURE `bug`.`proc1`() INSERT INTO `bug`.`test` VALUES(1);
Query OK, 0 rows affected (0.00 sec)

mysql> SET SESSION SQL_MODE="STRICT_TRANS_TABLES";
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE PROCEDURE `bug`.`proc2`() INSERT INTO `bug`.`test` VALUES(1);
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT name, sql_mode FROM mysql.proc WHERE db='bug';
+-------+---------------------+
| name  | sql_mode            |
+-------+---------------------+
| proc1 |                     |
| proc2 | STRICT_TRANS_TABLES |
+-------+---------------------+
2 rows in set (0.01 sec)

mysql> CREATE USER bug_user@127.0.0.1 IDENTIFIED BY 'bug_user';
Query OK, 0 rows affected (0.00 sec)

mysql> SET PASSWORD FOR bug_user@127.0.0.1 = PASSWORD('');
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT EXECUTE ON bug.* TO bug_user@127.0.0.1;
Query OK, 0 rows affected (0.00 sec)

mysql> EXIT;
