BUG #14681: Erroneous modulo (%) result

From: marc(at)daelemans(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14681: Erroneous modulo (%) result
Date: 2017-05-31 21:45:47
Message-ID: 20170531214547.1500.25117@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 ;

generates correct results on Win7 SP1, x64; 16GB machine, and

erroneous results on another PC (Win8.1, x64, GB RAM).

The Win8.1 PC has Postgresql 9.6.3 and the Win7SP1 PC has Postgresql 9.6.0,
both with PGAdmin3 1.21.1 and identical installation parameters. The only
obvious difference is that the Win8.1 PG installation has Python3.3
installed as an extension (plpython3u), while the Win7 installation does
not. The error remains even after rebooting the Win8.1 PC, and starting PG
without other applications running. I can send a screenshot to show the
problem.
Very strange.
Marc Daelemans +32 475 421 413

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2017-05-31 22:34:41 Re: BUG #14681: Erroneous modulo (%) result
Previous Message Andres Freund 2017-05-31 21:24:38 Re: [BUGS] Concurrent ALTER SEQUENCE RESTART Regression