Undesired behavior when renaming column

[jlcox]

Create a table called "mytable" with "col1" and "col2" of any datatype. Table name and column names will be uppercased as usual. Edit the table and rename "COL2" to "col3". "col3" will remain in lowercase. SQL will look like this:

create table MYTABLE
(
col1 NUMBER,
"col3" VARCHAR2(3)
)

This is not consistent with previous behavior.

 

[Marco Kalter]

If you enclose the column name in quotes, Oracle will retain the lowercase characters. This has not changed as far as I know.

 

[jlcox]

No, I'm not enclosing it in quotes, PL/SQL Developer is.

I'm showing you the result of renaming a column inside the editor.

See the steps to reproduce above the DDL.

 

[jlcox]

BTW, I'm using quotes in my steps to reproduce above as a text delimiter, but I didn't use them when I edited the table, in other words, I changed COL2 to col3.

 

[Marco Kalter]

I see. This does indeed not seem right. We'll fix it.

 

[youngBull]

This is a bug.