Parsing query BUG

[Victorious]

Try open test window, place query text and invoke Explain Plan.

Select rc.period_id
,rc.emp_id
,ed.dep_id
,cp.finish_date
,rc.Unpaid_Fee_Prcnt
,rc.Is_Paid
,Sum(rc.to_pay) As To_Pay
From Res_Corr rc
Join qw.Emp_Dep ed On ed.emp_id = rc.emp_id
And ed.isactive = 'Y'
Left Outer Join msal.Calc_Progress cp On cp.period_id = rc.Period_Id
And cp.dep_id = ed.dep_id
Where rc.Pub_Id = x.Pub_Id Having Sum(rc.to_pay) > 0
Group By rc.period_id, rc.emp_id, ed.dep_id, cp.finish_date, rc.Unpaid_Fee_Prcnt, rc.Is_Paid

Result is...

Select rc.period_id
,rc.emp_id
,ed.dep_id
,cp.finish_date
,rc.Unpaid_Fee_Prcnt
,rc.Is_Paid
,Sum(rc.to_pay) As To_Pay
From Res_Corr rc
Join qw.Emp_Dep ed On ed.emp_id = rc.emp_id
And ed.isactive = 'Y'
Left Outer Join msal.Calc_Progress cp On cp.period_id = rc.Period_Id
And cp.dep_id = ed.dep_id
Where rc.Pub_Id = x.Pub_I:d Having Sum(rc.to_pay) > 0
Group By rc.period_id, rc.emp_id, ed.dep_id, cp.finish_date, rc.Unpaid_Fee_Prcnt, rc.Is_Paid

Bug in replacing variables with parameters.

 

[Marco Kalter]

That doesn't seem right. We'll fix it.