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.