Skip to content

Inconsistent results when limiting select to specific columns #54

@sanketsarang

Description

@sanketsarang

In version 1.7.10, it is observed that when limiting a select to specific columns, the database occasionally misses a few records in the response.

The following are logs for the same query fired twice on the same table. The query was expected to respond with 2 records on both occasions.

blobcity>sql test: select col1, col2 from test.test
{"p":[{"col2":2,"col1":1}],"time(ms)":24,"ack":"1","rows":1}
blobcity>sql test: select col1, col2 from test.test
{"p":[{"col2":4,"col1":2},{"col2":2,"col1":1}],"time(ms)":3,"ack":"1","rows":2}

However, the following queries deliver consistent results
select col1 from test.test
select * from test.test

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions