Bug: Click on column title to sort by column makes all records disappear in UI

[maximkhatskevich]

Describe the bug

Clicking on column title to sort by column makes all records disappear in UI. NOTE: if you go to "Query" tab and select all records from that table - they are all there. Switching from between tables does not help - this table stays empty until you restart the app. Also, it does not happen to all columns, in my case it consistently happens with 1 column called "name". See below table and columns definition.

DEFINE TABLE OVERWRITE buyer SCHEMALESS TYPE NORMAL;

DEFINE FIELD OVERWRITE name ON TABLE buyer TYPE option<string>;
DEFINE FIELD OVERWRITE email ON TABLE buyer TYPE option<string> VALUE (IF $value THEN string::lowercase($value) ELSE NONE END) ASSERT string::is::email($value);
DEFINE FIELD OVERWRITE phone ON TABLE buyer TYPE option<string> VALUE (IF $value THEN fn::extractPhoneDigits($value) ELSE NONE END);
DEFINE FIELD OVERWRITE notes ON TABLE buyer TYPE option<string>;
DEFINE FIELD OVERWRITE recordedAt ON TABLE buyer TYPE datetime;

DEFINE INDEX OVERWRITE buyerEmailIndex ON TABLE buyer FIELDS email UNIQUE;
DEFINE INDEX OVERWRITE buyerPhoneIndex ON TABLE buyer FIELDS phone UNIQUE;

DEFINE INDEX OVERWRITE buyerSearchNameIndex ON TABLE buyer FIELDS name SEARCH ANALYZER ngram_text_analyzer BM25 HIGHLIGHTS;
DEFINE INDEX OVERWRITE buyerSearchPhoneIndex ON TABLE buyer FIELDS phone SEARCH ANALYZER edgengram_phone_analyzer BM25 HIGHLIGHTS;

Steps to reproduce

1. Launch Surrealist macOS app,
2. Connect to local DB isntance.
3. Navigate to "Esplore" tab.
4. Select the "buyers" table.
5. Make sure you see existing recods.
6. Click with left mouse button on "name" column tytpe to sort by title.

Expected behaviour

The recods dataset gets sorted by "name" column and same total amount of recods is displayed.

Surrealist Environment

Surrealist: Version: 3.0.7
Flags: feature_flags: false, query_view: true, explorer_view: true, graphql_view: true, designer_view: true, auth_view: true, functions_view: true, models_view: true, apidocs_view: true, cloud_view: true, themes: true, newsfeed: true, database_version_check: true, highlight_tool: false, legacy_serve: false, cloud_endpoints: production, cloud_access: false, cloud_killswitch: true, changelog: auto

SurrealDB: 2.0.1.

Start command:

surreal start -u root -p root rocksdb://SurrealDB --allow-scripting

Contact Details

[email protected]

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