SQL Bug set " newid () problem in random order "

Sort | random | questions
/**==** 2. NEWID () problem in random sort **==**/--test data declare @t table (name char (1), value int) insert INTO @tselect ' a ', 1union all select ' A ', 2unio n All select ' B ', 3union all select ' B ', 4union all select ' C ', 5union all select ' C ', 6

--require, random sort, but the same name to be ranked together select A.*from @t a Join (select Aa=newid (), name from (select distinct name from @t) a) b on a.name= B.nameorder by B.aa,newid ()

One of the/*--test results did not meet the requirements. If you change the join to a left right full join, the correct name value---------------B 4b 3c 5a 1a 2c 6

(The number of rows affected is 6 rows)--*/