format: db Identifier case issue,it does not work for similarly named columns
When you format text based on
Text Case > Identifier Case > As in database
It does not work as expected.
e.g. supposedly i have some tables definitions
CREATE TABLE DUCK1(Abc int)
CREATE TABLE DUCK2(aBc int)
CREATE TABLE DUCK3(abC int)
I these are the statements i want to format
select d.abc from duck2 as d
select d.abc FROM duck3 as d
but what i get after formatting is this
SELECT d.aBc FROM DUCK2 AS d
SELECT d.aBc FROM DUCK3 AS d
this is not what was expected.
4
votes
salman mubbashir
shared this idea
In case there are multiple objects with different case in the database, dbForge remembers the case of the first found identifier in the database and uses it for all identifiers with this name.