Code Assistant adding Double Quotes

[marottem]

I installed version 12.0.2.1818 today and just noticed a change in behavior of the code assistant. Now it is wrapping field names in double quotes when the object being queried is a view. But it is still just filling in the field name when the object being queried is a table.

This is the result with a table:

select * from ODBC_IMPORT t
where t.EMPLOYEE_NUMBER = 1;

This is the result for a view of the same table:

select * from ODBC_IMPORT_VW v
where v."EMPLOYEE_NUMBER" = 1;

I do not want to have the double quotes automatically added and I could not find a preference setting to turn this behavior off. Is there a new setting that I have not found to turn this off?

Thanks!

 

[Marco Kalter]

My guess is that the view is created with these quotes. Right-click on the view and select "Edit" to verify. There are 2 ways to omit the quotes:

1. Remove them from the view definition. Specify the column names in the same way as you would like to see them in your own queries.
2. Disable the "Use original case if possible" on the Code Assistant preference page (Configure > Preferences > Code Assistant). Now the Code Assistant items will be formatted based on general rules instead of the source (in this case a view source) where they are defined.

 

[marottem]

Disabling the "Use original case if possible" preference solved the problem. The interesting thing is I went back to version 11 and even though the "Use original case if possible" preference was also enabled, that version does not include the quotes when querying the same views. So the same preference setting now produces a different result in version 12, which is why I would not have thought that changing it would resolve the problem.

Thanks!