ORDER BY results in empty results, cmd query tool

[mwyvr]

What version of Genji are you using?

$ genji version
Genji v0.14.0
Genji CLI v0.14.0

Same behaviour with Boltdb/Badgerdb. To be clear, this is only in the genji cmd tool; I'm not seeing issues using the Genji API.

What did you do?

Using the command line query tool:

Example data:

select * from person limit 1; { "sid": "af879a5vfpdad6wd", "firstname": "Bolt0", "lastname": "Smith", "primaryemail": "foo-0@example.com" }

Example query without ORDER BY genji> select sid, firstname from person limit 5; { "sid": "af879a5vfpdad6wd", "firstname": "Bolt0" } { "sid": "af879a5vfpdad6we", "firstname": "Bolt1" } { "sid": "af879a5vftdad6wf", "firstname": "Bolt2" }

What did you expect to see?

5 documents, ordered ASC or DESC

What did you see instead?

FAILing query - it doesn't matter what field or direction the order by is issued, always empty N results. genji> select sid, firstname from person ORDER BY sid limit 5; {} {} {} {} {}

[asdine]

Thanks for reporting, I managed to reproduce it. I'll investigate and release a fix soon

[asdine]

This has been fixed by v0.14.1, you can run:

go get github.com/genjidb/genji@latest
go install github.com/genjidb/genji/cmd/genji@latest