HiveBrain v1.2.0
Get Started
← Back to all entries
debugMinor

how to let dbeaver to highlight sql error for easier development process

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
errorprocesssqldbeaverletfordevelopmenthowhighlighteasier

Problem

I had a sql that had some error. Although the error says

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 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.