Quick adaptation to Manticore, some SQL quirks puzzling

[altwazar]

I appreciate the ability to work with Manticore through familiar SQL, which allowed for quick adaptation for usage. I send logs to it from rsyslog for fast searching. As for my overall experience, it's positive. However, there are some undocumented peculiarities in SQL queries that are puzzling. For instance, if I select a column and then specify the same column in WHERE, I get 0 records in response. But if I alias the same column in SELECT using AS, everything works

[sanikolaev]

Thank you for your feedback @altwazar

It's cool, you send logs to Manticore from rsyslog. I'd love to know more about how it's done. I'll appreciate it if you share more details.

if I select a column and then specify the same column in WHERE, I get 0 records in response. But if I alias the same column in SELECT using AS, everything works

Oh yes, this is an old issue that we have never had time to address. Perhaps the core team, or someone else, might want to contribute this optimization as a Buddy plugin. It's not difficult in general (https://manticoresearch.com/blog/manticoresearch-buddy-pluggable-design/), but in case of this task may be a little challenging in terms of converting one SQL query to another. However it's easier to do in PHP than in C++.