PLSQL 13.0.6 comment bugs.

[Randomized J]

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.

 

[Marco Kalter]

We'll fix it.