Subject: | IN_BOOLEAN_MODE for full text search is not working for MySQL |
1. A where condition with IN_BOOLEAN_MODE is not working
f.e.
where=>[MATCH($column),AGAINST($sometext),IN_BOOLEAN_MODE]
or
where=>[MATCH($column),IN_BOOLEAN_MODE,AGAINST($sometext)]
2. The Alzabo::SQLMaker::Function method as_string returns
"IN_BOOLEAN_MODE" for IN_BOOLEAN_MODE and not "IN BOOLEAN MODE"
3. In addition to the MySQL documentation
"IN BOOLEAN MODE" is an option for AGAINST, thus the
API should be:
where=>[MATCH($column),AGAINST($sometext,IN_BOOLEAN_MODE)]