Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bug: Run Statement executes malformed SQL without failing

user11201487May 28 2026 — edited 6 days ago

Issue:
Run Statement (Ctrl+Enter/F9) may execute a malformed statement by dropping an invalid WHERE part, instead of raising syntax error.

Repro:

  1. SQL Worksheet, attached connection.

  2. Run this (cursor inside statement, no text selection):

    SELECT sys_context('USERENV', 'DB_NAME') AS db_name, last_login, account_status
    FROM DBA_USERS
    WHERE username = 'XYZ;

Expected:
Fail with syntax error (e.g. quoted string not properly terminated).

Actual:
Statement may execute as if WHERE clause is removed.

Note:
If the same malformed SQL is explicitly selected and run, error is shown correctly.

Impact:
Risk of unintended broad query results.

Request:
Please enforce strict parsing for Run Statement (or add a setting) so malformed SQL always fails and is never auto-truncated.

This post has been answered by thatJeffSmith-Oracle on May 29 2026
Jump to Answer
Comments
Post Details
Added on May 28 2026
2 comments
130 views