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

Inconsistent results when limiting select to specific columns #54

Open
sanketsarang opened this issue Aug 17, 2019 · 0 comments
Open

Inconsistent results when limiting select to specific columns #54

sanketsarang opened this issue Aug 17, 2019 · 0 comments
Labels
bug Something isn't working
Projects

Comments

@sanketsarang
Copy link
Contributor

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

@sanketsarang sanketsarang added the bug Something isn't working label Aug 17, 2019
@sanketsarang sanketsarang added this to Needs triage in BlobCity DB via automation Aug 17, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
BlobCity DB
  
Needs triage
Development

No branches or pull requests

1 participant