Nothing happens when running the Formatter on SQL containing concatenation pipes
说明
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.
原因
There is a space in between two concatenation pipes.
解决办法
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.