At 11:53 -0400 5/18/04, Matt Mastrangelo wrote:
I'm running version 4.1.1-alpha. The 3 select statements below on
the following test table produce inconsitent results:
create table test (test varchar(20)) charset latin1 collate latin1_general_cs;
insert into test values ('abcField1');
insert into test values ('abcField2');
insert into test values ('abcField3');
insert into test values ('xyzField1');
insert into test values ('xyzField2');
insert into test values ('xyzField3');
select * from test where test like '___Field%'; /* Works */
select * from test where test like '%Fie%'; /* Works */
select * from test where test like '%Field%'; /* Does NOT work */
Am I doing something wrong?
Thanks.
I get the same results in 4.1.1, but in 4.1.2 the third SELECT returns
all six rows. I don't see any applicable bugfix item in the 4.1.2
change notes: http://dev.mysql.com/doc/mysql/en/News-4.1.2.html
However, so many problems are fixed that I may have missed it.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
