Yii2 sphinx extension show less results then native query about yii2-sphinx

[klimov-paul]

https://github.com/yiisoft/yii2-sphinx/blob/master/docs/guide/usage-match.md

[klimov-paul]

Unable to reproduce

[korvinko]

I solved it problem by refactoring query to follow view:

$sql = 'SELECT * FROM main WHERE MATCH (''.$keyword.'')';
$rows = \Yii::$app->sphinx->createCommand($sql)->queryAll();

Maybe it will help someone in feature.

[korvinko]

Better solution:
$sql = 'SELECT * FROM main WHERE MATCH (:keyword)';
$params = [
'keyword' => $keyword
];
$rows = \Yii::$app->sphinx->createCommand($sql, $params)->queryAll();

[korvinko]

Thank you, now it work correctly. Refactored query:
$query = $query->select(['id'])
->from('main')
->match(new Expression("'$keyword'"));