inet function return untestable texts

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: inet function return untestable texts
Date: 2001-04-06 15:40:33
Message-ID: 200104061540.f36FeXR25734@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Laurent Wacrenier (lwa(at)teaser(dot)fr) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
inet function return untestable texts

Long Description
I'm running 7.0.3 on FreeBSD

host, netmask, etc.. inet function return unusable strings :
for example, host('10.0.0.1') print '10.0.0.1' but
is you make a comparison with '=', the result is alway false.

char_length reports this two strings have differents length.


Sample Code
test=# select host('10.0.0.1'), char_length(host('10.0.0.1')), char_length('10.0.0.1');
host | char_length | char_length
----------+-------------+-------------
10.0.0.1 | 9 | 8
(1 row)
test=# select host('10.0.0.1') = '10.0.0.1', host('10.0.0.1') like '10.0.0.1';
?column? | ?column?
----------+----------
f | t

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-04-06 16:27:56 Re: inet function return untestable texts
Previous Message Thomas Lockhart 2001-04-06 15:12:30 Re: Re: to_char miscalculation on April Fool's Day - the start of daylight savings