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 

0
4 comments

Does it help to insert AS between chema.t_~p_src_code~_tablename and d? 

0

No, it doesn't help.

0

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

0

Thank you. 

As I said in the request, I submitted the bug: https://youtrack.jetbrains.com/issue/DBE-15772

Please follow it. 

1

Please sign in to leave a comment.