incorrect alias
Answered
Hi, help me please.
Using this sql:
select *
from schema.t_~p_src_code~_tablename d
left join schema.t_~p_src_code~_pre_tablename tu on d.dfdogovor = tu.dfdogovor and to_date ('~p_end_dt~','~p_dt_format~') + interval '1 day - 1 sec' between tu.start_date and tu.end_date
where coalesce(d.dfdelete, 'F') = 'F'
and d.deleted_ind = 0;
~p_src_code~ as user parametr, it works fine
but sql editor find alias as "_tablename" not as "d"
from table - schema.t_~p_src_code~_tablename
Please sign in to leave a comment.
Does it help to insert AS between chema.t_~p_src_code~_tablename and d?
No, it doesn't help.
I made a request to intellij-support.jetbrains.com - Request #4107586. There is a screenshot of the problem, maybe it will help to understand the essence of the problem
Thank you.
As I said in the request, I submitted the bug: https://youtrack.jetbrains.com/issue/DBE-15772
Please follow it.