Bug #17990 Missing right parenthesis in general log

• Submitted: 6 Mar 2006 20:14
• Modified: 9 Aug 2006 11:03
• Reporter: Peter Gulutzan
• Status: Duplicate
• Category: MySQL Server: Stored Routines
• Severity: S3 (Non-critical)
• Version: 5.1.8-beta-debug
• OS: Linux (SUSE 10.0)
• Assigned to: Assigned Account
• CPU Architecture: Any

[6 Mar 2006 20:14] Peter Gulutzan

Description:
I'm using stored procedures and events and the general log.

One of my statements is "create event ... call p(1)".
This appears in the log file as "call p(1".
The ")" is missing.

How to repeat:
I started mysqld with
--user=root --skip-networking --log=/tmp/tmp.txt --log-output=file

With mysql I did this:

mysql> drop procedure p;
Query OK, 0 rows affected (0.00 sec)

mysql> drop table t;
Query OK, 0 rows affected (0.00 sec)

mysql> delete from mysql.event;
Query OK, 1 row affected (0.01 sec)

mysql> create table t (s1 int);
Query OK, 0 rows affected (0.00 sec)

mysql> create procedure p (vi int) insert into t values (vi);
Query OK, 0 rows affected (0.00 sec)

mysql> create event e on schedule every 1 day do call p(1);
Query OK, 1 row affected (0.01 sec)

mysql> set global event_scheduler = 1;
Query OK, 0 rows affected (0.00 sec)

The general log looks like this:

/usr/local/mysql/libexec/mysqld, Version: 5.1.8-beta-debug-log. started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument
060306 13:12:53    1 Connect	root@localhost on 
060306 13:12:56    1 Query	SELECT DATABASE()
		    1 Init DB	db1
		    1 Query	show databases
		    1 Query	show tables
		    1 Field List	t 
		    1 Field List	t2 
		    1 Field List	t99 
		    1 Field List	tkill 
060306 13:13:02    1 Query	drop procedure p
060306 13:13:06    1 Query	drop table t
060306 13:13:12    1 Query	delete from mysql.event
060306 13:13:18    1 Query	create table t (s1 int)
060306 13:13:34    1 Query	create procedure p (vi int) insert into t values (vi)
060306 13:14:01    1 Query	create event e on schedule every 1 day do call p(1)
060306 13:14:10    1 Query	set global event_scheduler = 1
		    3 Query	call p(1

[6 Mar 2006 22:32] MySQL Verification Team

Thank you for the bug report.

libexec/mysqld, Version: 5.1.8-beta-debug-log. started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument
060306 19:29:50    1 Connect    root@localhost on test
                    1 Query     show databases
                    1 Query     show tables
                    1 Field List        k1 
                    1 Field List        t1 
                    1 Field List        t2 
                    1 Field List        tm1 
                    1 Field List        tm4 
060306 19:30:01    1 Query      drop procedure p
060306 19:30:08    1 Query      drop procedure p
060306 19:30:16    1 Query      delete from mysql.event
060306 19:30:25    1 Query      create table t (s1 int)
060306 19:30:34    1 Query      create procedure p (vi int) insert into t values (vi)
060306 19:30:42    1 Query      create event e on schedule every 1 day do call p(1)
060306 19:30:52    1 Query      set global event_scheduler = 1
                    3 Query     call p(1

[9 Aug 2006 11:03] Andrey Hristov

Probably will be fixed by the patch for
bug#19207: Final parenthesis omitted for CREATE INDEX in Stored Procedure
which is already patch queued and pushed into 5.0.25

[9 Aug 2006 11:03] Tomash Brechko

This bug is a duplicate of bug#19207.