Variable with underscore in front is ignored #32369
Labels
bug
xf:sql editor
SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc.
xp:normal
Description
In our ETL we use parameters for the environment (development & production) as well as our database. The environment and database are separated with an underscore and when trying to execute a query in dBeaver (24.0.4), the variable with an underscrore in front of it is ignored. I'm not sure if this is a bug or an intentional feature, but I'd like to be able to utilize the variable function instead of doing a find & replace on the database string if possible.
Example would look like the query below and only the ${var:environment} and ${var:table} would be recognized as a variable, while ${var:database} is not due to the underscore.
SELECT
*
from ${var:environment}_${var:database}.${var:table}
DBeaver Version
Community Edition 24.0.4
Operating System
Windows 11
Database and driver
Hadoop / Cloudera Impala driver
Steps to reproduce
sample query
SELECT
*
from ${var:environment}_${var:database}.${var:table}
Additional context
The text was updated successfully, but these errors were encountered: