A query cannot be modeled when trying to visualize an SQL query with recursive sub query in Query Builder. (4226024)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

A query cannot be modeled when trying to visualize an SQL query with recursive sub query in Query Builder.
Description

A query with recursive sub query runs fine in the Editor. It will even run in the Query Builder when manually pasted into the Query tab. But when trying to visualize the query, it will error with "The query cannot be modeled."
The message also suggests addressing the highlighted errors within the query to address this issue. But the highlighted areas are correct.
Resolution

WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad Data Point
Defect ID

QAT-6984

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title