Re: [BUGS] BUG #14681: Erroneous modulo (%) result

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [BUGS] BUG #14681: Erroneous modulo (%) result
Дата
Msg-id 20170531223749.p6spzrgwtb3n2k65@alap3.anarazel.de
обсуждение исходный текст
Ответ на [BUGS] BUG #14681: Erroneous modulo (%) result  (marc@daelemans.com)
Список pgsql-bugs
On 2017-05-31 21:45:47 +0000, marc@daelemans.com wrote:
> 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 ;

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


-- 
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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [BUGS] BUG #14681: Erroneous modulo (%) result
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] BUG #14681: Erroneous modulo (%) result