@avergison I noticed a small glitch with Formatter aligning Table Aliases. It seems to align all aliases one space short of where the longest table name alias is. Here is my initial example where the third table has the longest name:
If I pull the schema off the front of the third table and re-format the code, now the alias for table 1 and table 3 are one space short of the alias for table 2:
Let me know if you need my Formatter settings.
Hmm, no luck in reproducing it. Please paste your settings, as well as your statement in text format (if possible).
Here are my Formatter settings:
Formatter Options.txt (864 Bytes)
Here is a sample query:
Sample.sql (1.0 KB)
Initially I only copied the first 2 statements in the Where clause to stop the code assistant from warning of cartesian products, but when I formatted that the table aliases aligned correctly. Once I added the full where clause from my original, the formatter went back to the behavior I had reported. Some additional playing around with the query allowed me to determine the issue appears once an Order By statement is added to the query. Let me know you need any additional info.
The ORDER BY clause is the culprit indeed. So here's a "minimal" (or almost minimal) affected example:
FROM MEDLKPADM.IE_DOCUMENTED_INTEREST_DTL DI
, MEDLKPADM.VA_NA_FIELD_FORCE__ALN FF
, MEDLKPADM.VCRM_PRODUCT_VOD__C PC
ORDER BY y
I can't fix it right now but I filed the issue to appear in QP version 5.383 or 384. (QP-3935)
Thanks for reporting!
As always I am impressed with the speed the support teams at Quest respond. The issue I raised is just a small annoyance, not a major issue, so as long as it is registered to be addressed in some future release, I am happy. Thanks for your assistance.
FYI it's still in my (long) queue, sorry. But not forgotten.