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:
None 
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 
Description:
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() 
 BEGIN
  select 1 ;
end;

# 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:

  http://lists.mysql.com/commits/22813
[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.