Bug: Failed to evaluate queries and expressions: input data must be a wide series but got type long (input refid)

This is the query I’m running for alerts:

SELECT slaveIO FROM table

It results in a 1 or a 0

This is what I get in Grafana 9.3:

Failed to evaluate queries and expressions: input data must be a wide series but got type long (input refid)

This works in Grafana 6.9. This needs to work in 9.3. I am not reconstructing dashboards and panels for a newer version that has more issues

This query works in Grafana 6.9 timeseries panel?

This query works in the panel but not for alerts

you might want to report this bug in grafana github

Also where did you get this 6.9 version from I am not seeing it in order to replicate the issue