Issue: Execution Plan Generation - Complex Statements

[wi937c-amr]

Issue:
dbForge Studio for Oracle (v3.1.206) fails to generate execution plans for complex statements.

Steps to Reproduce:
1 - Connect to database
2 - Open new SQL tab/document (CTRL-N)
3 - Enter a complex statement, for example:

Code: Select all

WITH
  MYTABLE AS (
    SELECT 1 COL_A FROM DUAL
  ),
  MYTABLE2 AS (
    SELECT 2 COL_A FROM DUAL
  ),
  MYTABLEUNION AS (
    SELECT * FROM MYTABLE
      UNION
    SELECT * FROM MYTABLE2
  )
  SELECT * FROM MYTABLEUNION;

4 - Generate Execution Plan using the toolbar icon or by the menu barl (SQL/Generate Execution Plan)

Expected Result:
Execution plan is generated for evaluation, for example:

Code: Select all

SELECT STATEMENT   COST=6
  VIEW             COST=6
    SORT (UNIQUE)  COST=6
      UNION-ALL
        FAST_DUAL  COST=2
        FAST_DUAL  COST=2

Actual Result:
Error: This statement cannot be profiled.

[alexa]

This issue will be fixed in the next build of the product.

[wi937c-amr]

Thank you for the update.