From: | Euler Taveira <euler(at)timbira(dot)com(dot)br> |
---|---|
To: | Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com> |
Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Akio Iwaasa <aki-iwaasa(at)vt(dot)jp(dot)nec(dot)com> |
Subject: | Re: power() function in Windows: "value out of range: underflow" |
Date: | 2018-04-10 14:04:17 |
Message-ID: | CAHE3wgj4BCyjVNtVn9HysoApzfT5zK2uFCgCG8g+Ow9G50v1+w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
2018-04-10 5:30 GMT-03:00 Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com>:
> There are some cases that power() function does not work
> correctly with 'NaN' arguments in Windows environment.
> Something like,
>
What is your exact OS version? What is your postgres version? I tested
with Windows 10 (10.0.16299) x64 and couldn't reproduce the error.
> postgres=# select power('NaN',11);
> ERROR: value out of range: underflow
> postgres=# select power('NaN','NaN');
> ERROR: value out of range: underflow
> postgres=# select power(11,'NaN');
> ERROR: value out of range: underflow
>
> In Linux environment, instead of ERROR it returns 'NaN'.
>
Could you show us a simple test case? Print arguments, result and errno.
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2018-04-10 15:55:04 | BUG #15149: Invalid cache id = 42 |
Previous Message | Stephen Frost | 2018-04-10 11:31:57 | Re: LDAP authentication fails with concurrent create extensions |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-04-10 14:06:24 | Re: lazy detoasting |
Previous Message | Tom Lane | 2018-04-10 14:01:16 | Re: submake-errcodes |