Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

support () around MATCH() #143

Closed
manticoresearch opened this issue Dec 27, 2018 · 1 comment
Closed

support () around MATCH() #143

manticoresearch opened this issue Dec 27, 2018 · 1 comment

Comments

@manticoresearch
Copy link
Contributor

manticoresearch commented Dec 27, 2018

Based on https://manticore-community.slack.com/archives/C7NSLK1NE/p1545918569000700 :

    
Serge [8:49 PM]
    
hi all! there are interesting situation with sql
    
select id FROM `search_ru` WHERE (MATCH('водитель '));
    

    
got the error
    
sphinx works well
    
manticore works only with
    
select id FROM `search_ru` WHERE MATCH('водитель ');
    

    
snikolaev.manticore [9:04 PM]
    
@Serge Hi. Thanks for letting us know. Can you please tell me why () around MATCH() is important for you?
    

    
Serge [9:05 PM]
    
() comes from yii2 query builder
    
and now its really hard to remove it
    
try to make a hack but it will be weird
    

The problem is that yii2 query builder puts () around MATCH, but it's not supported in Manticore (but supported in Sphinx). We need to consider adding the support.

@ivinco-sergey
Copy link

Fixed in 349e0e2

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants