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

Fix - remotes iterators #788

Closed
kuba-- opened this issue Apr 9, 2019 · 0 comments
Closed

Fix - remotes iterators #788

kuba-- opened this issue Apr 9, 2019 · 0 comments
Assignees
Labels
bug Something isn't working

Comments

@kuba--
Copy link
Contributor

kuba-- commented Apr 9, 2019

Test repos:

pga list -l ruby -f json | head -n 5 | jq -r '.sivaFilenames[]' | pga get -i -o repos
pga list -l python -f json | head -n 5 | jq -r '.sivaFilenames[]' | pga get -i -o repos
pga list -l javascript -f json | head -n 5 | jq -r '.sivaFilenames[]' | pga get -i -o repos

Test queries:

SELECT * FROM remotes WHERE remote_push_url REGEXP '^https://*';
SELECT * FROM remotes WHERE remote_push_url != 'trash';

CREATE INDEX uidx ON remotes USING pilosa (remote_push_url);

Both queries shall return 35 rows (based on test repos). After creating an index, the second query returns just 15 rows.

Note:
The issue can be related with indexes (then we'll have to transfer it to mysql) or just with remotes table iterator.

@kuba-- kuba-- added the bug Something isn't working label Apr 9, 2019
@kuba-- kuba-- self-assigned this Apr 9, 2019
@kuba-- kuba-- changed the title Index inconsistency result for remotes table Fix - remotes iterators Apr 9, 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
None yet
Development

No branches or pull requests

1 participant