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

FACET return null row #54

Closed
airolg opened this issue Feb 8, 2018 · 1 comment
Closed

FACET return null row #54

airolg opened this issue Feb 8, 2018 · 1 comment
Labels

Comments

@airolg
Copy link
Contributor

airolg commented Feb 8, 2018

From Manticore forum https://forum.manticoresearch.com/t/facet-return-null-row/95

I just installed manticoresearch 2.6.1 to test it, made a delta/main structure and noticed that adding FACET query after WHERE condition that return 0 results, a row will be added
±-------------±-------------±------+
| NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
±-----±--------±----------±---------±-----±-------------±-------±----------±-------±-----------±-------±-------±------------±--------------±---------±---------------±-------------±-------------±------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

Query is: select * from main where is_banned=1 FACET user_type
is_banned=1 returns empty set without FACET.

It's reproduced on also on manticore 2.5.1
Added to backlog

@tomatolog
Copy link
Contributor

fixed at 2376e8f

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants