Re: [HACKERS] Bug in LIKE ?

On Mon, 7 Jun 1999, Daniele Orlandi wrote:

> Date: Mon, 07 Jun 1999 14:27:46 +0200
> From: Daniele Orlandi <daniele(at)orlandi(dot)com>
> To: The Hermit Hacker <scrappy(at)hub(dot)org>
> Subject: Re: [HACKERS] Bug in LIKE ?
>
>
> > If I understand this correctly, IMHO, this would be asking for '^Sigma'
> > with at least one character after the 'a' ...
>
> Uhm.... I think the problem is a little worse:
>
> create table a ( b varchar(32) );
> insert into a values ( 'foo' );
> insert into a values ( 'bar' );
> insert into a values ( 'foobar' );
> insert into a values ( 'foobar2' );
>
> PostgreSQL 6.4.2
>
> tacacs=> select * from a where b like 'foo%';
> b
> -------
> foo
> foobar
> foobar2
> (3 rows)
>
> PostgreSQL 6.5beta2
>
> tacacs=> select * from a where b like 'foo%';
> b
> -
> (0 rows)
>
> tacacs=> select * from a where b like '%foo';
> b
> ---
> foo
> (1 row)
>
> tacacs=> select * from a where b ~ '^foo';
> b
> -------
> foo
> foobar
> foobar2
> (3 rows)
>

Hmm, just tried on current 6.5 from cvs:
test=> select version();
version
------------------------------------------------------------------------
PostgreSQL 6.5.0 on i586-pc-linux-gnulibc1, compiled by gcc egcs-2.91.66
(1 row)

test=> select * from a where b like 'foo%';
b
-------
foo
foobar
foobar2
(3 rows)

test=> select * from a where b like '%foo';
b
---
foo
(1 row)

test=> select * from a where b ~ '^foo';
b
-------
foo
foobar
foobar2
(3 rows)

Regards,
Oleg

> Bye.
>
> --
> Daniele
>
> -------------------------------------------------------------------------------
> Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
> Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
> -------------------------------------------------------------------------------
>
>
>

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83