ZF-7083: trying to fetchAll with fulltext search will end in a null result

Issue Type: Bug Created: 2009-06-22T05:15:10.000+0000 Last Updated: 2009-06-22T07:34:49.000+0000 Status: Resolved Fix version(s): Reporter: Christoph, René Pardon (renepardon) Assignee: Dolf Schimmel (Freeaqingme) (freak) Tags: - Zend_Db_Table

Related issues: Attachments:


If i try to fetch my table questions with column keywords which has fulltext index like this:

bq. $result = $this->fetchAll(array("MATCH (keywords) AGAINST (? IN BOOLEAN MODE)" => $string));

firebug says:

bq. SELECT questions.* FROM questions WHERE (MATCH (keywords) AGAINST ('+blöd du +bist' IN BOOLEAN MODE))

This is the right syntax but i'm getting no result. If i copy this statement in mysql-querybrowser one result will be displayed.


Posted by Dolf Schimmel (Freeaqingme) (freak) on 2009-06-22T07:12:38.000+0000

ZF doesn't alter your query at all. I guess you'd have to debug this one yourself (probably in order to discover you actually do something wrong yourself).

Posted by Dolf Schimmel (Freeaqingme) (freak) on 2009-06-22T07:34:49.000+0000

Closing this issue as cannot reproduce. Please provide a testcase which proves the 'bug' (which I promise you, is not there).

Have you found an issue?

See the Overview section for more details.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.