IN operator not correctly constructed in Query Builder Filter

[ryn9]

What happened:
When constructing a query using Query Builder, if using the 'IN' operator for a filter, the generated SQL is not correct

What you expected to happen:
the generated SQL for XXX IN (1,2,3) would be expected to be
XXX IN (1,2,3)
Instead it produces
XXX IN '(1,2,3)'

How to reproduce it (as minimally and precisely as possible):

1. Go to Query Builder, Query Type: Time Series
2. Create a Filter using the 'IN' operator
3. View the generated SQL Preview

Anything else we need to know?:
n/a

Environment:

• Grafana version:
• Plugin version: grafana-clickhouse-datasource v4.0.7
• OS Grafana is installed on:
• User OS & Browser:
• Others:

[Guille-vn]

I reported something similar . It's seems like "Clickhouse" connector is not working well

[ryn9]

@Guille-vn do you have a link to your issue?
The data source plugin has actually been working quite well in my tests, but like anything, there are some bugs.

[Guille-vn]

@Guille-vn do you have a link to your issue? The data source plugin has actually been working quite well in my tests, but like anything, there are some bugs.

Sure

grafana/grafana#87573
#828

[SpencerTorres]

Thank you for submitting this issue, I am able to reproduce this bug. This is an issue with the SQL generator converting the input to a string instead of splitting into a proper array, I will look into this and let you know when I push a fix.

Thanks!