Case sensitive column-name problem

[Edwin Godefrooij]

If you create a table like:

-- Create table
create table TEST
(
"Id" NUMBER,
"Omschrijving" VARCHAR2(20)
)

and after that you use the assistent for filling in the columnnames (pulldown-list when you type t.), the following query is constructed:

select t.id from test t

After executed this you will receive the following error:
ORA-00904 - invalid column name

Because of the (maybe strange) way the table is created the query should be:

select t."Id" from test t

I ran into this problem after having done an import of table from MS Access.

 

[Marco Kalter]

There are indeed some restrictions with mixed case identifiers that call for some "post processing" when using the code assistant. This will be addressed in a future release.

 

[Edwin Godefrooij]

Also the beautifier does not work that well with those columnnames:
select t.id
, t.description
, t."Memo" --> one character to the right
from test t;

 

[Marco Kalter]

We'll fix it.