bug for suppresing formating in beautifier

[Richard Wiener]

HI,
I have tried to use suppresing formating. When my setting has been without "Use tab character", then it has worked OK.
But when i have checked this checkbox, then my code has been moved to right for every beautify. Tab character size is 3

I am not able to add my example in this tools, because it always remove tab characters.

 

[Theod]

Hi,

use
[ code] sql_statement [ /code]

without space, to remain formating.

 

[Richard Wiener]

Before:

DECLARE
	ltxt_table  dba_tab_columns.table_name%TYPE;
	ltxt_column dba_tab_columns.column_name%TYPE;
BEGIN
	-- NoFormat Start
	SELECT table_name
	,column_name
	INTO ltxt_table
	,ltxt_column
	FROM dba_tab_columns
	WHERE ROWNUM = 1;
	-- NoFormat End
END;

After few beautify:

DECLARE
	ltxt_table  dba_tab_columns.table_name%TYPE;
	ltxt_column dba_tab_columns.column_name%TYPE;
BEGIN
	-- NoFormat Start
				SELECT table_name
				,column_name
				INTO ltxt_table
				,ltxt_column
				FROM dba_tab_columns
				WHERE ROWNUM = 1;
				-- NoFormat End
END;

 

[Marco Kalter]

We'll fix it.

 

[joachim]

This bug still exists in version 10.0.5.1710.
before

begin
    -- NoFormat Start
    l_stmt :=
    'select column_name from user_tab_cols where table_name = :p1
    intersect
    select column_name from user_tab_cols where table_name = :p2';
    -- NoFormat End
    open l_cur for l_stmt

after

begin
    -- NoFormat Start
    l_stmt :=
    'select column_name from user_tab_cols where table_name = :p1
intersect
select column_name from user_tab_cols where table_name = :p2';
    -- NoFormat End
    open l_cur for l_stmt

Regards
Joachim

 

[msu]

Is this fixed now? In which version? (I am on version 9 but this may be a business case for an upgrade )

 

[mike]

I tried the example above in 12.0.5 64 bit and it works now.

 

[Stephan B]

I tried the example above in 11.0.5.1775 and the bug still existed. Just for reference ;-)