Bug description
- Go to SQL Lab
- Use the following query:
with ws1 as (
select 1 as one
)
select * from ws1 --{{ ref('value_date_delinquent_dates')|length }}
- Run query
Expected results
The query should run without errors
Actual results
This error is returned:
Parameter error: Failed to execute query '5' - 'with ws1 as ( select 1 as one ) select * from ws1 --{{ ref('value_date_delinquent_dates')|length }} ': The query contains one or more malformed template parameters. Please check your query and confirm that all template parameters are surround by double braces, for example, "{{ ds }}". Then, try running your query again.
Screenshots/recordings
Superset version
master / latest-dev
Python version
3.9
Node version
18 or greater
Browser
Chrome
Additional context
No response
Checklist
- [x] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [x] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
Comment From: b4s36t4
Would love to work on this, can I get assigned?
Comment From: syedbarimanjan
@geido I tried to reproduce the bug but it is working properly.
Comment From: syedbarimanjan
@geido I tried to reproduce this again this time with ENABLE_TEMPLATE_PROCESSING set to true and I got the same error.
Comment From: LisaHusband
@geido Would love to work on this, can I get assigned?
Comment From: LisaHusband
@msyavuz Would love to work on this, can I get assigned?