Code completion ignoring code style for function
Hi, just wanted to see if this is a bug or maybe I'm just missing a setting.
For most elements code completion follows code style. However when typing built-in function case depends on the first letter, as seen below:
This is SQL Sever, but it happens on generic functions like SUM() or COUNT() as well.
I've tried various configuration of settings both from Code Completion section (including Match Case option, ML completion etc.) and Code Styles. But that did not make any difference. There are some similar bug reports mostly for Oracle, some open: https://youtrack.jetbrains.com/issue/DBE-12733/Autocompletion-in-Oracle-ignores-code-style-case-settings, some closed: https://youtrack.jetbrains.com/issue/DBE-5640/Oracle-SQL-completion-no-longer-obeys-identifier-style
请先登录再写评论。
Hi,
Please check your formatter settings in File | Settings | Editor | Code Style | SQL | General and ensure you have Built-In functions option set accordingly
Thanks Aleksandr, that's how I have it set up:
That's for “General” setting, the one for “SQL Server, Azure…” I've set up to inherit (but I also tried to configure it instead, no difference). Does it work for you?
Actually changing "Build-in functions' doesn't make a difference in the code completion behavior I described, i.e. if I set it to “To lower” the case will still depend on the first letter's case. It makes a difference when I hit “Reformat code”, the case is changed to the correct one, but I'd expect it to happen with code completion directly.
Hi, I've tried this in SQLite under Linux on another PC and it's the same, so it's not just SQL Server.
https://youtrack.jetbrains.com/issue/DBE-24196/Formatting-settings-are-not-applied-to-routines-in-code-completion
Thanks.
This has been corrected in the issue.