[Bug]: When the like expression for query is incorrect, it will not throw an error but instead return an empty result

[zhuwenxing]

Is there an existing issue for this?

• I have searched the existing issues

Environment

- Milvus version:2.3/2.4/master
- Deployment mode(standalone or cluster):
- MQ type(rocksmq, pulsar or kafka):    
- SDK version(e.g. pymilvus v2.0.0rc2):
- OS(Ubuntu or CentOS): 
- CPU/Memory: 
- GPU: 
- Others:

Current Behavior

the expression is "color like \"red\""

the response is empty instead of returning an error

Expected Behavior

should raise error

Steps To Reproduce

No response

Milvus Log

No response

Anything else?

No response

[zhuwenxing]

/assign @longjiquan

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
Rotten issues close after 30d of inactivity. Reopen the issue with /reopen.

[xiaofan-luan]

why this should return an error?

"color like "red""
seems to be a valid expression

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
Rotten issues close after 30d of inactivity. Reopen the issue with /reopen.

[yanliang567]

@longjiquan any comments?

[zhuwenxing]

why this should return an error?

"color like "red"" seems to be a valid expression

@xiaofan-luan
lack of %

It should be "color like '%red'" , "color like 'red%'" or "color like '%red%'"

[xiaofan-luan]

even with out %， this could be a valid expr?

[xiaofan-luan]

you just don't have any data match "red"

[longjiquan]

"color like 'red'" is equal to "color == 'red'"

[longjiquan]

/unassign
/assign @zhuwenxing

[zhuwenxing]

ok, I got it. In my previous understanding, I always thought that the "like" expression must be followed by a %.

and yes, it works like ==