[Bug]: documentation example gives error

[AgNess-G]

Is there an existing issue for this?

• I have searched the existing issues

Environment

Current Behavior

using AND and IN operator as in the screenshot from documentation is giving the following error.

RPC error: [search], <MilvusException: (code=1100, message=failed to create query plan: cannot parse expression: price < {price} AND avg_rating > {avg_rating} AND colour IN {colour}, error: invalid expression: price < {price} AND avg_rating > {avg_rating} AND colour IN {colour}: invalid parameter)>

but using and or in works

can i get clarity if this is an error in the documentation ? if yes, can this be corrected?

Expected Behavior

No response

Steps To Reproduce

Milvus Log

No response

Anything else?

No response

[xiaofan-luan]

Is there an existing issue for this?

• I have searched the existing issues

Environment

Current Behavior

using AND and IN operator as in the screenshot from documentation is giving the following error.

RPC error: [search], <MilvusException: (code=1100, message=failed to create query plan: cannot parse expression: price < {price} AND avg_rating > {avg_rating} AND colour IN {colour}, error: invalid expression: price < {price} AND avg_rating > {avg_rating} AND colour IN {colour}: invalid parameter)>

but using `and` or `in` works can i get clarity if this is an error in the documentation ? if yes, can this be corrected?

Expected Behavior

No response

Steps To Reproduce

Milvus Log

No response

Anything else?

No response

The reason is for older milvus version, AND is not a keyword, you should use and or &&.

2.5.4 or 2.4.21 already support AND as a keyword

[AgNess-G]

thanks. will test it there @xiaofan-luan

[yanliang567]

/assign @AgNess-G
/unassign