Return
-
Title
Nothing happens when running the Formatter on SQL containing concatenation pipes -
Description
When formatting SQL that contains concatenation pipes, nothing happens. The comment gets added in front of the code, but the code does not actually get formatted. -
Cause
There is a space in between two concatenation pipes. -
Resolution
WORKAROUND:
Delete any spaces that are in between concatenation pipes.
Example:
colA | |colB
should be changed to
colA||colB
STATUS:
Waiting for a fix for defect ID 'QP-569' to be released in a future version of Toad for Oracle. -
Defect ID
QP-569