Toad World® Forums

TDP 4.0.0.624- Errors with Join Analysis for valid query

Hey team!

Getting cast errors on occasion when bringing up the join analysis diagram for a join involving calculated field.
Oddly enough, the query runs fine, including result set.
Am able to reproduce with the Toad sample database.

Snap 1: showing definition of calculated column:

Snap 2: showing error when attempting to bring up join analysis between calculated column MyDate and Contact_ID. Note that the join analysis diagram for the other join worked fine, and the query does bring back expected result set.

Hi.

Reproducible also in Development version. Issue created: QAT-8558.

Regards,

Petr.