inet function return untestable texts

Started by PostgreSQL Bugs Listabout 25 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

Laurent Wacrenier (lwa@teaser.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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: inet function return untestable texts

pgsql-bugs@postgresql.org writes:

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.

This is fixed in 7.1. Someone forgot that text values shouldn't
have trailing nulls ...

regards, tom lane