How to execute the entire query when the selected statement is incorrectly split

Issue 

For queries that use syntax highlighting that is not yet fully supported, manual selection may be split into separate fragments. As a result, only part of the selected query is executed, even when the entire statement appears to be selected.

This can cause errors such as SQL compilation errors or syntax errors:

image2.png

Workaround 

First, please check whether the issue has already been reported in YouTrack. If not, please create a new ticket so that we can support the missing syntax and fix the issue.

Starting with version 2026.1 (supported in DBE-24132), use the Execute Selection as Single Statement context action to execute the entire selection as one statement:

Execute Selection as Single Statement.png

For versions earlier than 2026.1, temporarily change the query execution settings:

  1. Open Settings | Database | Query Execution.

  2. Set Selection execute to Exactly as one statement.

image.png
0 out of 0 found this helpful

Please sign in to leave a comment.

Have more questions?

Submit a request