Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Variable with underscore in front is ignored #32369

Open
tburk32 opened this issue May 13, 2024 · 1 comment
Open

Variable with underscore in front is ignored #32369

tburk32 opened this issue May 13, 2024 · 1 comment
Labels
bug xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc. xp:normal

Comments

@tburk32
Copy link

tburk32 commented May 13, 2024

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

image

@E1izabeth E1izabeth added xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc. xp:normal and removed wait for review labels May 14, 2024
@E1izabeth
Copy link
Member

Thank you for bug report.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc. xp:normal
Projects
None yet
Development

No branches or pull requests

2 participants