[BUG] v4.0.281 -Auto-aliases with quotation / Авто-алиасы с кавычками
[BUG] v4.0.281 -Auto-aliases with quotation / Авто-алиасы с кавычками
RUSSIAN
----
Привет.
Начиная с 4 версии стали появляться кавычки у алиасов таблиц. Это крайне раздражает, потому что требует дополнительных действий.
Мало того, это не отключается никак.
Под "никак" - я подразумеваю - никак. Есть три варианта выбора в "Квотирование идентификаторов" - и ни один не оказывает никакого влияния.
Пример
SELECT * FROM TABLE_X "tx"
Зачем сломали и как починить?
-------
ENGLISH
-------
Hi!
Since 4th version a quotes have been appeared along with the aliases for tables. This is really distubing, because additional moves are required now.
And there is no way to turn it off.
By "no way" I mean - "no way at all". There are three choices in "Quote identifiers" setup. but none of it makes sense.
Example
SELECT * FROM TABLE_X "tx"
Why did you ruin that and how to fix it?
----
Привет.
Начиная с 4 версии стали появляться кавычки у алиасов таблиц. Это крайне раздражает, потому что требует дополнительных действий.
Мало того, это не отключается никак.
Под "никак" - я подразумеваю - никак. Есть три варианта выбора в "Квотирование идентификаторов" - и ни один не оказывает никакого влияния.
Пример
SELECT * FROM TABLE_X "tx"
Зачем сломали и как починить?
-------
ENGLISH
-------
Hi!
Since 4th version a quotes have been appeared along with the aliases for tables. This is really distubing, because additional moves are required now.
And there is no way to turn it off.
By "no way" I mean - "no way at all". There are three choices in "Quote identifiers" setup. but none of it makes sense.
Example
SELECT * FROM TABLE_X "tx"
Why did you ruin that and how to fix it?
Re: [BUG] v4.0.281 -Auto-aliases with quotation / Авто-алиасы с кавычками
We implemented such a behavior in dbForge in accordance with Oracle, where, if alias is not enclosed in double quotes, Oracle server itself makes it upper case.
So, if you need the alias to be kept in lower case, you need to enclose it in double quotes.
So, if you need the alias to be kept in lower case, you need to enclose it in double quotes.
Re: [BUG] v4.0.281 -Auto-aliases with quotation / Авто-алиасы с кавычками
Oracle forces developers to use the double quotes or this is by needs and occasions and in a free way?
I don't want the alias to be in double quotes, when it is auto-generated by code-completion.
How do I prevent this?
PS: It's not about lower or upper case.
I don't want the alias to be in double quotes, when it is auto-generated by code-completion.
How do I prevent this?
PS: It's not about lower or upper case.
Re: [BUG] v4.0.281 -Auto-aliases with quotation / Авто-алиасы с кавычками
You could try selecting the 'Generate aliases in UPPER case' option (select 'SQL Complete -> Options...', navigate to the 'Alias' section).
Re: [BUG] v4.0.281 -Auto-aliases with quotation / Авто-алиасы с кавычками
Thank you for the reply.
We will reconsider this behavior when developing the next product versions.
We will reconsider this behavior when developing the next product versions.
Re: [BUG] v4.0.281 -Auto-aliases with quotation / Авто-алиасы с кавычками
Thank you for letting us know this.
We will take this into account.
We will take this into account.