clickhouse-datasource icon indicating copy to clipboard operation
clickhouse-datasource copied to clipboard

Ad hoc filter values ​​are incorrectly escaped when used with the IN operator

Open Kenterfie opened this issue 7 months ago • 1 comments

What happened: We switched some weeks ago from the Altinity plugin for clickHouse to the official grafana clickhouse source plugin and we noticed that something was not working anymore as expected. We use extensively the in operator in our ad-hoc filters, which works fine with the previous plugin, but now the values are incorrectly escaped.

settings additional_table_filters={'table' : ' IPv4NumToStringClassC(ipv4Dst) IN \'('1.1.1.xxx','2.2.2.xxx')\' '}

What you expected to happen: settings additional_table_filters={'table' : ' IPv4NumToStringClassC(ipv4Dst) IN (\'1.1.1.xxx\',\'2.2.2.xxx\')'}

Anything else we need to know?:

Environment:

  • Grafana version: v10.4.1
  • Plugin version: 4.1.0

Kenterfie avatar Jun 28 '24 11:06 Kenterfie