We were updating one of our views in plsql developer and came across a weird bug. It mainly happens in 13.0.6.
The bug in 13.0.6 happens when there is a "with" and a "function" within 2 lines the code breaks and you use a semicolon to finish the code.
I also have 12.0.7 and if there is a "with" and a "function" on the same line and you use a semicolon to finish the code.
This breaks in 12.0.7 and 13.0.6
create or replace view uvic_common.v_test_view as
-- with function
select * from dual;
These break in 13.0.6:
create or replace view uvic_common.v_test_view as
/* with */
/* function */
select * from dual;
create or replace view uvic_common.v_test_view as
/* with function */
select * from dual;
The main issues isn't that the words are together either as this breaks in also
create or replace view uvic_common.v_test_view as
-- User was using first name with their last name
-- in the function call
select * from dual
However, these all work.
create or replace view uvic_common.v_test_view as
/* with */
/* function */
select * from dual;
create or replace view uvic_common.v_test_view as
/* with */
/* function */
select * from dual
Note: the last one doesn't have a ; which is allowing it to work. But, once you "edit" the new view you created. you can't recompile it by running the code.