Bug #27400 "CALL /* This is a comment */ PROC_NAME(ARGS)" does not work
Submitted: 23 Mar 2007 15:17 Modified: 13 Apr 2007 8:32
Reporter: John David Duncan Email Updates:
Status: Closed Impact on me:
Category:Connector / J Severity:S3 (Non-critical)
Version:5.0.4 OS:Any
Assigned to: Mark Matthews CPU Architecture:Any

[23 Mar 2007 15:17] John David Duncan
A SQL stored procedure call containing a comment between "CALL" and the procedure name is valid SQL through other connectors, but not connector/J 5.0.4

How to repeat:
create procedure my_proc() 
  select 1 ;

# From CLI:    (works)
CALL /* comment */ my_proc();

# From Connector/J: (fails)
CALL /* comment */ my_proc();
[23 Mar 2007 15:58] Tonci Grgin
Hi John and thanks for your report. Verified as described.
[23 Mar 2007 17:36] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

[23 Mar 2007 18:18] Mark Matthews
Fix available in nightly snapshot build after 00:00 GMT 24-Mar at http://downloads.mysql.com/snapshots.php#connector-j
[13 Apr 2007 8:32] MC Brown
A note has been added to the 5.0.6 changelog.