incorrect result order when reusing aliases

DROP TABLE IF EXISTS `foobar`;

CREATE  TABLE IF NOT EXISTS `foobar` (

  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

  `name` VARCHAR(45) NULL )

ENGINE = InnoDB;

INSERT INTO `foobar` (`name`) VALUES ('A');

INSERT INTO `foobar` (`name`) VALUES ('B');

INSERT INTO `foobar` (`name`) VALUES ('C');

INSERT INTO `foobar` (`name`) VALUES ('D');

INSERT INTO `foobar` (`name`) VALUES ('E');

SELECT

  `SubQuery`.`Static` AS `Random`,

  `SubQuery`.`Name`

FROM (

  SELECT

    RAND() AS `Random`,

    1 AS `Static`,

    `Name`

  FROM `foobar`

  ) AS `SubQuery`

ORDER BY

`SubQuery`.`Random`,

`SubQuery`.`Name`;