Bug #3817 Portion of comment used inside field names
Submitted: 18 May 2004 19:31 Modified: 19 May 2004 11:19
Reporter: Ilia Alshanetksy Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.18 OS:Linux (Linux 2.4.2X)
Assigned to: CPU Architecture:Any

[18 May 2004 19:31] Ilia Alshanetksy
Description:
When using versioned comments, mysql seems to prepend the */ to the field 
following the comment. 

How to repeat:
SELECT /*!40000 SQL_CALC_FOUND_ROWS */ FROM some_table; 
SELECT /*!40000 FOUND_ROWS(), */ -1; 
 
| FOUND_ROWS() | */ -1 | 
| some_number  | -1 | 
 
The column name for the 2nd field should be just -1, not */ -1.
[19 May 2004 11:19] Alexander Keremidarski
Can't repeat it with 4.0 from BK tree which is Post-4.0.20

mysql> SELECT /*!40000 FOUND_ROWS(), */ -1, VERSION();
+--------------+----+------------------+
| FOUND_ROWS() | -1 | VERSION()        |
+--------------+----+------------------+
|            1 | -1 | 4.0.20-debug-log |
+--------------+----+------------------+