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

Index lookups on string primary keys fail on Linux when the database files are created on MacOS #2943

Closed
ray6080 opened this issue Feb 26, 2024 · 0 comments · Fixed by #2952
Assignees
Labels
bug Something isn't working high-priority

Comments

@ray6080
Copy link
Contributor

ray6080 commented Feb 26, 2024

The bug can be reproduced as following:

  1. Create kuzu db on MacOS.
CREATE NODE TABLE DimensionNode(model_key STRING, technical_name STRING, name STRING, aliases STRING[], PRIMARY KEY (model_key));
COPY DimensionNode FROM "<file>" (HEADER=true, DELIM=',');

dimNode.csv

  1. Transport the db files on Mac to a Linux machine (I tried it with Ubuntu 22.04.3 LTS).

  2. Open the transported db files and run the query, which returns empty.

match (n:DimensionNode) where n.model_key='businessEntity::tpcds_1.tpcds.store' return n;

while, regex matching on scanned tuples can correctly return the matching tuple

kuzu> match (n:DimensionNode) where n.model_key=~'businessEntity::tpcds_1.tpcds.store' return n;
-----------------------------------------------------------------------------------------------------------------------------------------------------
| n                                                                                                                                                 |
-----------------------------------------------------------------------------------------------------------------------------------------------------
| {_ID: 0:11, _LABEL: DimensionNode, model_key: businessEntity::tpcds_1.tpcds.store, technical_name: tpcds_1.tpcds.store, name: Store, aliases: []} |
-----------------------------------------------------------------------------------------------------------------------------------------------------
(1 tuple)
(1 column)

Possibly, this bug can be reproduced between other platforms, but I haven't checked yet.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working high-priority
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants