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:
None 
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:09] William Wang
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)"
[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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.