search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
40.68k stars 3.51k forks source link

Case in Generate script #18831

Open poolMiniDomo opened 1 year ago

poolMiniDomo commented 1 year ago

Description

Gennerate SQL not do not respect case preference. If "key word case" is set to lower, in genereted SQL, key words are always in upper case.

DBeaver Version

22.3.3

Operating System

macOS ventura

Database and driver

PostgresSQL 13

Steps to reproduce

No response

Additional context

No response

LonwoLonwo commented 1 year ago

Hello @poolMiniDomo

Please, clarify where "key word case" is set to lower?

poolMiniDomo commented 1 year ago

Hello, see screenshot below image

@LonwoLonwo

LonwoLonwo commented 1 year ago

This setting is used for formatting in the SQL Editor. In the SQL Editor, you can highlight part of the text and use Ctrl+Shift+F - and the text will be formatted. This setting does not work with other DBeaver parts.

bmoAtolcd commented 1 year ago

Why? it's not consistent.

LonwoLonwo commented 1 year ago

Because it is not the Editor. And not the SQL Editor as well.

2023-01-23 19_39_25-Case in Generate script · Issue #18831 · dbeaver_dbeaver — Mozilla Firefox

bmoAtolcd commented 1 year ago

Hum I configure SQL format like my usage, but when I use generate SQL, it's another format which is used. Not really good user experience. Perhaps add another option?

image