Re: Inconsistent % Wildcard behaviour
Sergei Golubchik <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Hi!
On Apr 07, Andreas Pardeike wrote:
> Hi,
>
> If I run
>
> drop table if exists t;
> create table t (f varchar(32) not null);
> alter table t add index (f);
> insert into t VALUES ('Guldböcker'),('Presentböcker');
> select count(*) from t where f like '%böcker%';
> select count(*) from t where f like '%böcker';
>
> I get "1" from the first select and "2" from the second
> select. This seems like a bug.
>
>
> INFO
> mysqladmin Ver 8.40 Distrib 4.1.1-alpha, for pc-linux on i686
> Server version 4.1.1-alpha-standard
As far as I remember it was a bug that is already fixed in the
development tree (at least I failed to repeat it).
Should be out soon in 4.1.2.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[email protected]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/[email protected]