debugMinor
how to let dbeaver to highlight sql error for easier development process
Viewed 0 times
errorprocesssqldbeaverletfordevelopmenthowhighlighteasier
Problem
I had a sql that had some error. Although the error says
. However, it seems dbeaver didn't highlight exactly where the error is. It tells me it is position 420, but i don't know where is position 420 intuitively....
Is it possible to let DBeaver to highlight error for me.
PS: I could identify the error by eyeballing this time... but other times seem difficult...
SQL Error [42601]: ERROR: syntax error at or near "from"
Position: 420. However, it seems dbeaver didn't highlight exactly where the error is. It tells me it is position 420, but i don't know where is position 420 intuitively....
Is it possible to let DBeaver to highlight error for me.
PS: I could identify the error by eyeballing this time... but other times seem difficult...
Solution
I'm not sure the accepted answer is correct. Normally I'd go into
Tooltip: Shows individual markers near the failed queries and highlights the problematic segment of it in the editor. if disabled, selects the problematic segment in the editor.
Window | Preferences | Editors | SQL Editor | Code Editor and turn on the option Show problem markers.Tooltip: Shows individual markers near the failed queries and highlights the problematic segment of it in the editor. if disabled, selects the problematic segment in the editor.
Context
StackExchange Database Administrators Q#299602, answer score: 5
Revisions (0)
No revisions yet.