From: | Carsten Klein <c(dot)klein(at)datagis(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Strange results when casting string to double |
Date: | 2022-02-16 18:38:01 |
Message-ID: | a89c2e30-3775-799b-37f0-bd07d3b7c55f@datagis.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Feb 16, 2022 at 05:46 PM Adrian Klaver wrote
> On 2/16/22 05:27, Carsten Klein wrote:
>> Hi there,
>>
>> I'm using several (now unsupported) PostgreSQL 9.3.24 servers on
>> different (ancient) Ubuntu 14.04 LTS machines. On only one of those
>> servers, I get strange/wrong results when converting a string into a
>> double value:
>>
>
>> Has anyone an idea of what's going on here? I know, this version is
>> far from still being supported, however, there's not much real changes
>> in file float.c between these versions (in other words, this may
>> happen with recent versions as well?). The database instances on all
>> servers are configured quite the same (more or less).
> What is the more or less for the problem server?
What? Didn't get that...
> Are the hardware(CPU) architectures the same for all the servers?
The problem server is a virtual machine (VMware). I've tested this on
two other servers and do receive probably correct results. One of these
is also a virtual machine (same VMware, running on different hardware),
the other one is a physical box with an AMD Athlon(tm) II X4 640 64-bit
processor.
Customer site:
Production System: VMware (ESX Host A) works as expected
Testing System: VMware (ESX Host B) DOES NOT WORK as expected
Our site:
Development System: AMD Athlon(tm) II works as expected
However, since the strtod function works correctly from my tiny C
program on all these machines, I don't believe that this problem has to
do with hardware or architecture. I guess, PostgreSQL dynamically links
to these C library functions, right?
> If not how does the problem server differ?
I certainly have no idea. Actually, I don't see any more relevant
differences.
> Was Postgres installed from the same source/same way on all the server?
PostgreSQL was installed from Ubuntu's official repositories (14.04 LTS)
on all servers.
--
Carsten Klein
c(dot)klein(@)datagis(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2022-02-16 19:11:57 | Re: Strange results when casting string to double |
Previous Message | Laurenz Albe | 2022-02-16 17:06:38 | Re: if not exists (SELECT 1... UNION SELECT 1...) |