Skip to content

Text field in the index on JSON does not return values correctly #1272

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

Open
adamzrk opened this issue Sep 24, 2024 · 1 comment
Open

Text field in the index on JSON does not return values correctly #1272

adamzrk opened this issue Sep 24, 2024 · 1 comment

Comments

@adamzrk
Copy link

adamzrk commented Sep 24, 2024

I am using index on json like that:
SCHEMA $.relations[*].text as text TEXT

I have values like:
"name": "test",
"relations": [
{
"type": "3344d28-3af7-4bb4-9964-bc2b76b93d64",
"text": "emailemailcom4321e891-162a-456b-abf2-fd9b864df96d"
},
{
"type": "9876d28-3af7-4bb4-9964-bc2b76b93d64",
"text": "ABCD5d13e891-162a-456b-abf2-fd9b864df96d"
}
}

When I am searching like:
FT.SEARCH json:search '@text:"emailemailcom4321e891-162a-456b-abf2-fd9b864df96d"' DIALECT 2
the document is found, which is fine.
But when I try to search like this:
FT.SEARCH json:search '@text:"email*4321e891-162a-456b-abf2-fd9b864df96d"' DIALECT 2
no result is found.
Seems like searching on part of the content inside TEXT field does not work.

Modules

module:name=timeseries,ver=11202,api=1,filters=0,usedby=[],using=[],options=[]
module:name=redisgears_2,ver=20020,api=1,filters=0,usedby=[],using=[],options=[]
module:name=search,ver=21005,api=1,filters=0,usedby=[],using=[ReJSON],options=[handle-io-errors]
module:name=RedisCompat,ver=1,api=1,filters=0,usedby=[],using=[],options=[]
module:name=ReJSON,ver=20803,api=1,filters=0,usedby=[search],using=[],options=[handle-io-errors]
module:name=bf,ver=20802,api=1,filters=0,usedby=[],using=[],options=[]

@oshadmi
Copy link
Collaborator

oshadmi commented Sep 24, 2024

@adamzrk Please report this issue in RediSearch

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

No branches or pull requests

2 participants