Closed dl-github-reporter closed 5 months ago
Current workaround for this problem is downgrade to vertamedia-clickhouse-datasource v2.5.4
$conditionalTest
works there
Could you provide ogirinal SQL query which you tried to use with $conditionalTest macro?
And maybe CREATE TABLE statements and panel JSON for reproduce?
@Slach it is business dashboard with financial data under NDA. Will try to reproduce error in other dashboard and send required query and JSON, if succeed.
@Slach reproduced this error locally in other dashboard based on system.query_log
table
Error occurres during editing query in SQL query editor
For example
SELECT
$timeSeries as t,
if(initial_user='', 'unknown', initial_user) as user,
count() as queries
FROM clusterAllReplicas(clickhouse_cluster, $table)
WHERE $timeFilter
and query_kind = 'Select'
and type in ('QueryFinish','ExceptionWhileProcessing')
GROUP BY t,user
ORDER BY t, queries desc
shared query is not contains $conditionalTest only screenshot which query exactly did you try?
SELECT
$timeSeries as t,
if(initial_user='', 'unknown', initial_user) as user,
count() as queries,
$conditionalTest(what here?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
FROM clusterAllReplicas(clickhouse_cluster, $table)
WHERE $timeFilter
and query_kind = 'Select'
and type in ('QueryFinish','ExceptionWhileProcessing')
GROUP BY t,user
ORDER BY t, queries desc
ok. found it in shared JSON, thank for sharing, we will try to reproduce and fix it
ClickHouse.Loading.Stats.json @lunaticusgreen could you look and try to reproduce?
which query exactly did you try?
Doesn't matter, error occurs when I add new $conditionalTest
in any query.
On the screen was an example of query I started editing.
JS code crashed right in the moment I ended typing $conditionalTest
@Slach @lunaticusgreen
I'm experiencing the same
Plugin crashes while start typing macro
$conditionalTest
in SQL query editor form.Reproduced on version:
Error log in plugin interface
Error log in browser console