Re: [GENERAL] Custom shuffle function stopped working in 9.6

On 02/11/2017 11:36 AM, Adrian Klaver wrote:
> On 02/11/2017 09:17 AM, Alexander Farber wrote:
>> I think ORDER BY RANDOM() has stopped working in 9.6.2:
>>
>> words=> select unnest(ARRAY['a','b','c','d','e','f']) order by random();
>>   unnest
>> --------
>>   a
>>   b
>>   c
>>   d
>>   e
>>   f
>> (6 rows)
>>
> postgres=> select version();
>                                         version
> -------------------------------------------------------------------------------------
>   PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (SUSE Linux) 4.8.5, 64-bit
> (1 row)
>
> postgres=> select * from  unnest(ARRAY['a','b','c','d','e','f']) order by random();
>   unnest
> --------
>   d
>   c
>   a
>   f
>   e
>   b
> (6 rows)
>
> postgres=> select * from  unnest(ARRAY['a','b','c','d','e','f']) order by random();
>   unnest
> --------
>   b
>   d
>   e
>   c
>   a
>   f
> (6 rows)
>
>
>

I can duplicate issue on 9.6.2.

jack=# select version();
                                                  version
----------------------------------------------------------------------------------------------------------
  PostgreSQL 9.6.2 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.3.1-14ubuntu2) 5.3.1 20160413, 64-bit
(1 row)

jack=# select unnest(ARRAY['a','b','c','d','e','f']) order by random();
  unnest
--------
  a
  b
  c
  d
  e
  f
(6 rows)

jack=# select unnest(ARRAY['a','b','c','d','e','f']) order by random();
  unnest
--------
  a
  b
  c
  d
  e
  f
(6 rows)

Jack