search

questdb / grafana-questdb-datasource

Questdb datasource plugin for Grafana.
Apache License 2.0
9 stars 0 forks source link

Item names including a Dollar-sign are modified by datasource plugin #109

Open jbsgh opened 4 months ago

jbsgh commented 4 months ago

To reproduce

Using item names including a Dollar sign (e. g. "my$item") are modified by the datasource plugin

Steps to reproduce:

  1. Switch to SQL Editor
  2. Enter simple SQL statement: SELECT time,my$item FROM "my_table"; (this query shouldn't be too complex to convert)
  3. Switch to Query Builder; Confirm warning

Observations:

  1. The query is of type "Time series"
  2. The SQL preview contains SELECT time as time FROM "my_table" WHERE $__timeFilter(time) SAMPLE BY $__sampleByInterval LIMIT 100. my$item is missing

Steps to reproduce:

  1. Switch to Query Type "Table"

Observations:

  1. The field "time" is missing now
  2. The listbox "Fields" contains myf9qx7sitem instead of my$item
  3. The SQL Preview contains SELECT myf9qx7sitem FROM "my_table" LIMIT 100
  4. The Dollar sign of field "my$item" has been replaced with a random string like "f9qx7s"

QuestDB version:

8.0.1

Grafana version:

11.1.0

Plugin version:

0.13.0

OS, in case of Docker specify Docker and the Host OS:

Debian 12

Full Name:

Jan Bartels

Affiliation:

Siempelkamp

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

Additional context

No response