【Bug】ORDER BY not working

[hiroyuki0415]

SELECT   a1.entitylogicalname,
         a1.logicalname,
         a1.environment
FROM     (SELECT entitylogicalname,
                 logicalname,
                 'env1' AS environment
          FROM   [env1].metadata.attribute
          UNION ALL
          SELECT entitylogicalname,
                 logicalname,
                 'env2' AS environment
          FROM   [env2].metadata.attribute) AS a1
         INNER JOIN
         [env3].metadata.attribute AS a2
         ON a1.entitylogicalname = a2.entitylogicalname
            AND a1.logicalname = a2.logicalname
WHERE    a1.entitylogicalname IN ('systemuser', 'businessunit')
         AND a1.logicalname IN ('createdon')
ORDER BY a1.entitylogicalname;

The result of this SQL is below: ORDER BY is not working

	entitylogicalname	logicalname	environment
	businessunit	createdon	env1
	systemuser	createdon	env1
	businessunit	createdon	env2
	systemuser	createdon	env2

Thanks in advance for your support.