Formatting bug

jmeyer · January 8, 2015 1:26PM

ORDER BY statements after a HAVING clause do not receive their aliases.

Repo:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE &#91;dbo&#93;.&#91;Project_Express_MR53_stg&#93; (&#91;DataFile&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;BF-SSN&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LN-SEQ&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LN-FAT-SEQ&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LC-FAT-REV-REA&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;WX-FAT-REV-REA&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LD-FAT-APL&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LD-FAT-PST&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LD-FAT-EFF&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LD-FAT-DPS&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LC-CSH-ADV&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;WX-CSH-ADV&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LD-STA-LON90&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LC-STA-LON90&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;WX-STA-LON90&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LA-FAT-PCL-FEE&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LA-FAT-NSI&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LA-FAT-LTE-FEE&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LA-FAT-ILG-PRI&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LA-FAT-CUR-PRI&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;PC-FAT-TYP&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;WX-FAT-TYP&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;PC-FAT-SUB-TYP&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;WX-FAT-SUB-TYP&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LA-FAT-NSI-ACR&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;WD-RPT-MTH-BEG&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;WD-RPT-MTH-END&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;WX-FIN-ATY-RPT-LN&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;WX-LI-FAT-RAP&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;IF-OWN&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;IF-BND-ISS&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;IC-LON-PGM&#93; &#91;VARCHAR&#93;(50) NULL
                                             , &#91;LC-LO-AUT-RAL&#93; &#91;VARCHAR&#93;(50) NULL)
ON
  &#91;PRIMARY&#93;

GO


SELECT  s.&#91;BF-SSN&#93;
      , s.&#91;LN-SEQ&#93;
      , s.&#91;LN-FAT-SEQ&#93;
      , s.&#91;WX-FIN-ATY-RPT-LN&#93;
      , s.&#91;LC-LO-AUT-RAL&#93;
      , s.&#91;LC-FAT-REV-REA&#93;
      , s.&#91;WD-RPT-MTH-END&#93;
FROM    dbo.Project_Express_MR53_stg s
GROUP BY s.&#91;BF-SSN&#93;
      , s.&#91;LN-SEQ&#93;
      , s.&#91;LN-FAT-SEQ&#93;
      , s.&#91;WX-FIN-ATY-RPT-LN&#93;
      , s.&#91;LC-LO-AUT-RAL&#93;
      , s.&#91;LC-FAT-REV-REA&#93;
      , s.&#91;WD-RPT-MTH-END&#93;
HAVING  COUNT(*) &gt; 1
ORDER BY &#91;BF-SSN&#93;
      , &#91;LN-SEQ&#93;
      , &#91;LN-FAT-SEQ&#93;
      , &#91;WX-FIN-ATY-RPT-LN&#93;
      , &#91;LC-LO-AUT-RAL&#93;
      , &#91;LC-FAT-REV-REA&#93;
      , &#91;WD-RPT-MTH-END&#93;

Aaron L · January 9, 2015 5:15AM

Hi Jens,

Thanks for the reproduction script! I see the same behavior here and I'll look into a fix for you now.

Thanks,
Aaron.

Aaron L · January 9, 2015 9:23AM

I think I've got a fix for you in this private build. We'll do some more testing and will hopefully include this in our stable release next week.

Thanks again!
Aaron.

jmeyer · January 22, 2015 10:31AM

Aaron:

Sorry for the late reply but I can confirm that this bug is fixed in your latest release.

Thanks,
Jens

Aaron L · January 22, 2015 11:52AM

Hi Jens,
Thanks for letting us know its fix for you!

Thanks,
Aaron.

Formatting bug

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk