DBeaver在不需要时引用表和列

huangapple go评论52阅读模式
英文:

DBeaver quoting tables and columns when not needed

问题

I recently updated to DBeaver Community Version 23.1.1.202306251800. I guess that this issue is linked to that release, though I'm not certain.

When I dragged a table from the Database Navigator to a SQL editor tab in the past, I would get a value like this: CADDI_DEMO.CREDITCARDS.CREDIT_CARD_ACCOUNT

Today I get a value like this: "CADDI_DEMO"."CREDITCARDS"."CREDIT_CARD_ACCOUNT".

Both are valid, but I prefer the former. Is there a configuration option somewhere to return to the former?

NOTE: in general DBeaver is great about giving me TABLE_NAME in general but "Table Name" when the table contains spaces or other tricky bits. I have not changed my options as far as I know. But the behavior changed. At the moment it is quoting all of my column names as well. Yuck.

英文:

I recently updated to DBeaver Community Version 23.1.1.202306251800. I guess that this issue is linked to that release, though I'm not certain.

When I dragged a table from the Database Navigator to a SQL editor tab in the past, I would get a value like this: CADDI_DEMO.CREDITCARDS.CREDIT_CARD_ACCOUNT

Today I get a value like this: "CADDI_DEMO"."CREDITCARDS"."CREDIT_CARD_ACCOUNT".

Both are valid, but I prefer the former. Is there a configuration option somewhere to return to the former?

NOTE: in general DBeaver is great about giving me TABLE_NAME in general but "Table Name" when the table contains spaces or other tricky bits. I have not changed my options as far as I know. But the behavior changed. At the moment it is quoting all of my column names as well. Yuck.

答案1

得分: 0

已解决于版本 23.1.0.202306041918。
我今天在升级Homebrew时收到了这个稍微不寻常的日志:

==> 升级3个过期的软件包:
dbeaver-community 23.1.1 -> 23.1.0

最终我找到了解决办法:https://github.com/dbeaver/dbeaver/issues/20391

这是一个只影响Snowflake的问题,我之前没有意识到。

英文:

Solved in Version 23.1.0.202306041918.
I got this slightly unusual log from my homebrew upgrade today:

==> Upgrading 3 outdated packages:
dbeaver-community 23.1.1 -> 23.1.0

Eventually I found it: https://github.com/dbeaver/dbeaver/issues/20391

It was a Snowflake-only issue, which I had not realized.

huangapple
  • 本文由 发表于 2023年6月29日 02:59:51
  • 转载请务必保留本文链接:https://go.coder-hub.com/76575999.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定