[influxdb] Error on retrieval of data with non-standard retention policy name (escape issue)

[DrTron]

Ever since I migrated to OH3 (now on OH3.1M2), I am no longer able to retrieve historical data from influxdb (1.8). OH3 does, however, persist all the data into the database.

To limit the influxdb size, I am using it as a round-robin-database, and created new retention policies. The default one is named "1m_for_24h", and while this is a valid influxdb name (and works for inserting data into the database from the binding), the binding fails to correctly escape the underscores when retrieving data.

A minimal example from a rule to retrieve data from 10 Minutes ago would be:
item.historicState(now.minusMinutes(10),"influxdb")

The query generated by this is:
SELECT value FROM 1m_for_24h.item WHERE time <= '2021-03-26T01:41:27.811737Z' ORDER BY time DESC LIMIT 1;
which gives the following error:
19:19:18.284 [ERROR] [.internal.handler.ScriptActionHandler] - Script execution of rule with UID 'influxtest-1' failed: error parsing query: found 1m, expected identifier at line 1, char 19 in influxtest

Modifying the query to the correct escape sequence like this:
SELECT value FROM "1m_for_24h".item WHERE time <= '2021-03-26T01:41:27.811737Z' ORDER BY time DESC LIMIT 1;
results in correctly retrieving data from the database.