Beta Notes
Compare Schemas
Schema Compare is now threaded, so should not block other activities in Toad.
Formatting/Parsing (QP5)
Formatter
Fix (QP 2788) :
- Distance between parameters and data types fixed to become exactly one indent (from one indent + one space). This change is due to a required major refactoring of the parameter declaration formatter code.
- Stacked parameter declaration lists now have the IN, OUT, INOUT and NOCOPY keywords of their parameter declarations justified:
CREATE PROCEDURE astron.extern (
IN a DATE,
OUT CHAR,
INOUT c TIMESTAMP)
FUNCTION func1 (par1 INT,
par2 IN INT := 3,
par3 INT := 3,
par4 IN OUT NOCOPY INT)
Code Analysis
Fix (QP 2800) : Rule 5914 (“Use untransformed column values in the WHERE clause.”)
-
Speedup (around 70 times) fixing possible multi-second delays.
-
Parameter specifications were not taken into account.
Fix (QP 2786) : Rule 5920 (“Apply the invoker rights method to all stored code that executes dynamic SQL”) -
Speedup (around 70 times) fixing possible multi-second delays.
�