MySQL Bugs: #64350: In mysql cluster 7.2 GA, LIKE function not work.

Bug #64350	In mysql cluster 7.2 GA, LIKE function not work.
Submitted:	16 Feb 2012 8:54	Modified:	17 Feb 2012 0:24
Reporter:	ws lee	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S1 (Critical)
Version:	5.5.19-ndb-7.2.4-gpl	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
In mysql cluster 5.5.19-ndb-7.2.4-gpl version, LIKE function not work.

How to repeat:
mysql> select version();
+----------------------+
| version()            |
+----------------------+
| 5.5.19-ndb-7.2.4-gpl |
+----------------------+
1 row in set (0.00 sec)

mysql> create database test1 default character set utf8; 
Query OK, 1 row affected (0.00 sec)

mysql> use test1;
Database changed

mysql> insert into a values(1,'test1');
Query OK, 1 row affected (0.00 sec)

mysql> select * from a;
+------+-------+
| id   | name  |
+------+-------+
|    1 | test1 |
+------+-------+
1 row in set (0.00 sec)

mysql> select * from a where name like 'test%';
Empty set (0.00 sec)

NOT searched any value.

HI .. 

You omitted the "CREATE TABLE `a` ..." statement in the test case.  It could be important (if this is reproducible with or without an index only).

Peter
(not a MySQL person)

Yes, exact CREATE TABLE is missing. Also, what is the value of engine_condition_pushdown in your case?

Also see http://bugs.mysql.com/bug.php?id=64351

in my.cnf
engine_condition_pushdown=1

and I created table like below.

create table a(id int, name varchar(50)) engine=ndb;
This table surely is created in utf8 with database defalut character set.

I have reported same bug about mysql clustger 7.1

Why not release patch ASAP this bug???
http://bugs.mysql.com/bug.php?id=64039

mysql cluster 7.2 GA released a few day ago.,
bug has same like bug.

in other words, mysql cluter 7.2 is not GA yet as far as this bug exists.
why did you say GA 7.2 version???

Hi,

This is a duplicate of http://bugs.mysql.com/bug.php?id=64039.
This bug is fixed in upcoming 7.1.20 and 7.2.5.
I.e this bug did not make the 7.2.4 cut-off date.

Closing this as duplicate

/Jonas

>This bug is fixed in upcoming 7.1.20 and 7.2.5.

I sincerely expect patch release about this bug in next 7.2.5.
but i can't found the comment about this bug at below.

http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-news-5-5-20-ndb-7-2-5.html