| Bug #67724 | like function not work. | ||
|---|---|---|---|
| Submitted: | 27 Nov 2012 8:45 | Modified: | 27 Jun 2013 20:30 |
| Reporter: | ws lee | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S1 (Critical) |
| Version: | 5.5.27-ndb-7.2.8 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[27 Nov 2012 9:07]
ws lee
also, same bug in 5.1.63-ndb-7.1.24
[27 Nov 2012 9:07]
ws lee
also, same bug in 5.5.28-ndb-7.2.9
[27 Nov 2012 17:29]
Sveta Smirnova
Thank you for the report. Verified as described. Only Cluster packages are affected. And this looks like re-occurrence or not proper fix of bug #64039
[28 Nov 2012 0:40]
ws lee
I got a blow my production service beacuse of this like function bug. Indeed, irresponsible version release. mysql cluster is not database-system ever. continuously to bug #64039 , like function bug occured, unbelibable.
[4 Dec 2012 3:05]
ws lee
I want to question mysql cluster engineer. When release patch about this bug?
[25 Dec 2012 9:20]
ws lee
do you think about mysql? do you think mysql is database? I am supprising this bug fix not yet.
[25 Dec 2012 9:26]
Sveta Smirnova
Workaround: set optimizer_switch = 'engine_condition_pushdown=off';
[1 May 2013 7:00]
李 源錫
also, same bug in 5.5.30-ndb-7.2.12
[1 May 2013 8:09]
李 源錫
This bug was reported 27 Nov 2012. Since this bug was reported already passed 6 month. unbilievelable! if this bug exists, mysql is not RDBMS. when do you going to patch this bug?
[27 Jun 2013 20:30]
Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.
Fixed in NDB 6.3+.
Documented as follows in the NDB 6.3.53, 7.0.39, 7.1.28, 7.2.14, and 7.3.3 changelogs:
SELECT ... WHERE ... LIKE from an NDB table could return
incorrect results when using engine_condition_pushdown=ON.
Closed.
Description: In ndb7.2.8 , like function not work. ndb 7.2 is gabage version indeed. i am using 7.2 business service. please I want to be patch A.S.A.P How to repeat: mysql> create table a(a varchar(7)) engine=ndb charset=utf8; mysql> insert into a values ('abcdefg'); mysql> select * from a; +---------+ | a | +---------+ | abcdefg | +---------+ 1 row in set (0.00 sec) mysql> select * from a where a like 'abcdefg%'; Empty set (0.00 sec)