Beta Notes
Datagrids
You can now select a pair of cells in the grid and choose “Compare Selected Values” to send them to the side-by-side viewer. Any datatype is supported, but obviously this is most useful for large varchar2’s and CLOBs. Grid selection style has not changed, so the cells must be side-by-side or above/below each other, but you can drag columns around and/or adjust your sql to make that happen.
Formatting/Parsing (QP5)
Parser
Fix (QP 2986) : Added support for analytic functions with a qualified schema names.
Formatter
Fix (QP 1530 + QP 2562) : After a CASE expression the alias wraps onto the next line (CSR#: 3310865-1)
Code Analysis
Fix (QP 2987): Spurious AV in QP5CA.dll at 00000000240D32F8, reading FFFFFFFF817E92A8.
New (QP 2468): Rule 6741 (“Variable assigned twice successively such as A := B; A := C;”): This rule should help catching typos. The following cases will NOT cause a hit:
- Double assignments to a same variable with at least one other statement in between,
- The second assignment has the left hand side variable somewhere in its right hand side.
Fix (QP 3017): Rule 2141 (“Make sure the given Schema Prefix name exists for all objects.”) : Will no longer work on schema names. Only object names are considered. In addition, the hardcoded size of the prefix has been omitted allowing proper operation of the PREFIX parameter with various prefix sizes.