Query with usage of a variable not working after updating to 9.4.2

[github-ps1304]

What happened:
upgraded Grafana to version 9.4.2 - queries with a variable (multiply a value with a variable to get €) are not working anymore. Error: "An error occurred within the plugin"
What you expected to happen:
multiply a value with a variable
How to reproduce it (as minimally and precisely as possible):
use value in query and multiply with a defined dashboard variable
Anything else we need to know?:

Environment:

• Grafana version: 9.4.2
• Data source type & version: InfluxDB 1.8.10
• OS Grafana is installed on: Ubuntu 22.04 LTS
• User OS & Browser: Mac OS Safarai
• Grafana plugins:
• Others: see info from Query Inspector:

Object request:Object url:"api/ds/query" method:"POST" data:Object queries:Array[6] range:Object from:"1677711600000" to:"1677797999999" hideFromInspector:false response:Object message:"An error occurred within the plugin" messageId:"plugin.downstreamError" statusCode:500 traceID:""

[mellieA]

@github-ps1304 can you share steps to reproduce and a screenshot or example of how the query variable is defined and used in the query that produces this error?

[github-ps1304]

I do a simple query to aggregate values (integral) and multiply the result to get the € amount.

Query I am using

Variable 1 I am using

Variable 2 I am using

[chrishoage]

I am having the same issue.

My observations:

• The variable containing a float fails
  • 
• The variable containing an integer works
  • 
• Avoiding the variable with the float works
  • 

Variable config

I have also tried removing the spaces after the commas, which did not help 0.35,0.35625,0.35375,0.365,0.38

[CatCookie]

I have the same issue after the upgrade.

My workaround for now is, that i define my variables as integer and divide them by a factor, so that i use integer values in my formulas only.

So instead of * ($__to -$__from) / 3600000 * $cost with $cost being 0.3456, i use * ($__to -$__from) / 3600000 * $cost/$factor in my query and define $cost as 3456 and $factor as 10000

It is just a lot of clicking to change it everywhere.

[github-ps1304]

I did a short test with 2 variables; VK = 425 div = 100000 - so my query is working again with the following:
SELECT integral("Verbrauch",1h)*$VK/$div FROM "AC" WHERE time>$Heute

so the issue is with constants < 1 for example 0.000425 as a variable - please troubleshoot and fix it.

[github-ps1304]

just updated Grafana to V9.3.7 - for or me everything is working again !!!

[github-ps1304]

fixed in version 9.3.7