What happened?

Numerical ascending sort of values for a query-type variable is broken in 11.4.

Example:

My query is:

select 50 as row_count 
union all select 500 
union all select 100 
union all select 1000

What did you expect to happen?

I expected the values to be sorted numerically:

• 50
• 100
• 500
• 1000

Did this work before?

Works fine in Grafana 8.5

How do we reproduce it?

1. Create a new dashboard
2. Add a variable of type "query" with a datasource of "clickhouse" and query of:

select 50 as row_count 
union all  select 500 
union all select 100  
union all select 1000 

3. Set the sort to Numerical (asc)

Reload the dashboard several times and check the variable values selector pull-down.

The values seem to come back in some kind of random order? And the order changes between reloads? Example:

Is the bug inside a dashboard panel?

No

Environment (with versions)?

Grafana: 11.4.0
OS: Ubuntu 24 LTS
Browser: Chrome

Grafana platform?

A package manager (APT, YUM, BREW, etc.)

Datasource(s)?

clickhouse