Re: BUG #14681: Erroneous modulo (%) result

On 2017-05-31 21:45:47 +0000, marc(at)daelemans(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14681
> Logged by: Marc Daelemans
> Email address: marc(at)daelemans(dot)com
> PostgreSQL version: 9.6.3
> Operating system: Win8.1 x64
> Description:
>
> select i, i&11 as j from generate_series ( 1, 100 ) i ;

Thats not the modulo operator? You're binary bitwise and-ing i and the
number 11 here.

> generates correct results on Win7 SP1, x64; 16GB machine, and
> erroneous results on another PC (Win8.1, x64, GB RAM).

Which results are you getting, and what you expecting?

Greetings,

Andres Freund