[QUESTION]: How to escape in the expression?

[xiaofan-luan]

Is your question answered elsewhere?

• searched the existing issues.
• read the documentation.

What is your question?

I want the document of boolean expression explain more about escape and how to do escape on complicated scenarios

like what is difference between _suffix and _suffix? How to escape "" and '' in a string.

Anything else?

No response

[xiaofan-luan]

/assign @xiaocai2333

[xiaocai2333]

In milvus, if you want to match a string in an expression. Some special symbols need to be escaped. including but not limited to:

1. Various special characters, such as "\n", "\t", etc.
2. The expression supports ' or " to represent a string. The string contains the following characters:

• Additional same quotes need to be escaped. For example 'xxx\'xxx', "xxx\"xxx".
• By including additional distinct quotes, escaping can be omitted. For example 'xxx"xxx', "xxx'xxx".

Note:
% and _ in the string corresponding to the like expression do not support escaping and will be considered wildcard characters.

[xiaofan-luan]

after talk to @longjiquan
this seems to be a expect behaviour