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

Bug: OPTION IMPORT causes bugs with FTS indexes #4031

Closed
2 tasks done
vitorTheDev opened this issue May 13, 2024 · 0 comments · Fixed by #4047
Closed
2 tasks done

Bug: OPTION IMPORT causes bugs with FTS indexes #4031

vitorTheDev opened this issue May 13, 2024 · 0 comments · Fixed by #4047
Labels
bug Something isn't working triage This issue is new

Comments

@vitorTheDev
Copy link

Describe the bug

After using the CLI to import a surql file with OPTION IMPORT; in it, full-text search indexes start to ignore any previously inserted records (records inserted before the import).

Steps to reproduce

Fist, create a record:

create user content {name: 'Tobie'};

Then import with the surreal CLI:

OPTION IMPORT;
DEFINE ANALYZER edgeNgram TOKENIZERS class FILTERS lowercase,ascii,edgeNgram(1,10);
DEFINE INDEX idxUserName ON TABLE user COLUMNS name SEARCH ANALYZER edgeNgram BM25;

After that, do a query:

select * from user where name @1@ 't';

It returns [] an empty array.

Expected behaviour

Should return the record with name 'Tobie'.

SurrealDB version

1.4.2

Contact Details

netd777@gmail.com

Is there an existing issue for this?

  • I have searched the existing issues

Code of Conduct

  • I agree to follow this project's Code of Conduct
@vitorTheDev vitorTheDev added bug Something isn't working triage This issue is new labels May 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working triage This issue is new
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant