kuzu icon indicating copy to clipboard operation
kuzu copied to clipboard

Bug: data type problem with SERIAL

Open ubmarco opened this issue 4 months ago • 3 comments

Kùzu version

v0.6.0

What operating system are you using?

Arch Linux x64

What happened?

I'm running this list of queries against an empty DB:

CREATE NODE TABLE Person(id SERIAL, name STRING, PRIMARY KEY(id));
CREATE NODE TABLE Company(id STRING, name STRING, PRIMARY KEY(id));
MATCH (a) RETURN a;

and get this error: Binder exception: Expected the same data type for property id but found STRING and SERIAL. The error appears when running the MATCH query.

What's the problem? Thanks for helping out!

Are there known steps to reproduce?

docker run -p 8001:8000 --rm -e KUZU_IN_MEMORY=true kuzudb/explorer:latest

CREATE NODE TABLE Person(id SERIAL, name STRING, PRIMARY KEY(id));
CREATE NODE TABLE Company(id STRING, name STRING, PRIMARY KEY(id));
MATCH (a) RETURN a;

ubmarco avatar Oct 01 '24 18:10 ubmarco