Quest SQL Optimizer 7.5.0 prompting for bind variables of SQL aliases (4305299)

User is trying to run SQL Optimizer on a SQL statement that consists of an UPDATE statement followed by multiple columns with the SET clause and using table aliases.

When clicking on the Optimize icon, the SQL Optimizer will incorrectly prompt to enter bind variables where the name of the bind variable is the same as the aliases used in the SQL.

The same SQL statement runs fine in SQL Plus or Toad Editor without need for any bind variables. The SQL statement can be Optimized in version 7.4 without being prompted for bind variables.

There is a defect in the SQL Optimizers 7.5.0 parser which causes the prompt for bind variables to appear.

WORKAROUND: Temporarily fall back to version 7.4.1 of Quest SQL Optimizer.

STATUS: Issue fixed in version 7.5.1. The latest version of SQL Optimizer can be downloaded here .