[BUGS] BUG #14681: Erroneous modulo (%) result - Mailing list pgsql-bugs

From marc@daelemans.com
Subject [BUGS] BUG #14681: Erroneous modulo (%) result
Date
Msg-id 20170531214547.1500.25117@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14681: Erroneous modulo (%) result  (Thomas Munro <thomas.munro@enterprisedb.com>)
Re: [BUGS] BUG #14681: Erroneous modulo (%) result  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: [BUGS] BUG #14681: Erroneous modulo (%) result  (Andres Freund <andres@anarazel.de>)
Re: [BUGS] BUG #14681: Erroneous modulo (%) result  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [BUGS] BUG #14681: Erroneous modulo (%) result  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14681
Logged by:          Marc Daelemans
Email address:      marc@daelemans.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



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] [BUGS] Concurrent ALTER SEQUENCE RESTART Regression
Next
From: Thomas Munro
Date:
Subject: Re: [BUGS] BUG #14681: Erroneous modulo (%) result