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 

4 comments
Comment actions Permalink

Thank you. 

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

Please follow it. 

1
Comment actions Permalink

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

0
Comment actions Permalink

No, it doesn't help.

0
Comment actions Permalink

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

Please sign in to leave a comment.