Bug Report - Setting Default Table Value

[sofko936]

I would like to report a bug that exists in both V6 and V7 Beta. When PL/SQL Developer is used to modify the default value of a column, extra non-whitespace, non-visible characters are appended to the end of the value. These extra characters cause '=' comparisions to fail.

To reproduce:
1) PL/SQL Dev ---> Edit Table
2) Columns Tab ---> Set a default value for a column.
3) Execute this query:
SELECT data_default
FROM user_tab_columns
WHERE table_name = 'YOUR TABLE NAME'
AND column_name = 'YOUR COLUMN';

4) From the results, click the "..." button.
5) Change to the HEX tab, the default value will be followed by ".." characters. If my default value is 'DEFAULT' the HEX view displays 'DEFAULT'..
6) If you set the default value using SQL Plus and execute the above query, the ".." characters do not appear.

 

[Marco Kalter]

What does this query return for your column?

SELECT data_default, default_length
FROM user_tab_columns
WHERE table_name = 'YOUR TABLE NAME'
AND column_name = 'YOUR COLUMN';

 

[sofko936]

Marco, your query returns a default_length = 10 when the value is 'DEFAULT'

'DEFAULT' should have a length of 9.

When I use SQL Plus to set the default value, your query returns a length of 9.

 

[Marco Kalter]

That's very strange, because PL/SQL Developer simply passes an

alter table DEPT modify DNAME default 'DEFAULT';

statement to the server.