| Bug #1003 | mysql error | ||
|---|---|---|---|
| Submitted: | 5 Aug 2003 10:09 | Modified: | 5 Aug 2003 10:31 |
| Reporter: | William Wang | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: MyISAM storage engine | Severity: | S3 (Non-critical) |
| Version: | MySQL 4.0.13 | OS: | FreeBSD (FreeBSD && WIN 2K) |
| Assigned to: | CPU Architecture: | Any | |
[5 Aug 2003 10:31]
Alexander Keremidarski
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php MySQL does not allow space between function name and parenthesis

Description: I have a table field defined as set This work SELECT * FROM tblName WHERE FIND_IN_SET('1',tblField)>0 but when there is a space between FIND_IN_SET and ('1',tblField), I got an mysql error. How to repeat: I have a table field defined as set This work SELECT * FROM tblName WHERE FIND_IN_SET('1',tblField)>0 but when there is a space between FIND_IN_SET and ('1',tblField), I got an mysql error. Suggested fix: Should be able to put a space between "FIND_IN_SET" and "('1',tblField)"