Bug #53360 No result for requests using LIKE condition on ENUM fields
Submitted: 3 May 2010 7:12 Modified: 11 Nov 2010 11:42
Reporter: Azeddine ESSAI Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.1-telco-6.3 OS:Any
Assigned to: Martin Skold CPU Architecture:Any
Tags: 6.3.11, cluster, enum, like, mysql-5.1.39 ndb-7.0.9

[3 May 2010 7:12] Azeddine ESSAI 
Description:
Hi.
We use MySQL Cluster. Since version 7.0.9 (MySQL 5.1.39), we have no result for requests using LIKE condition on ENUM fields.
Problem occurs on NDBD tables but doesn't on MyIsam tables.

How to repeat:
# NDBD table
CREATE TABLE IF NOT EXISTS `table` (
  enumfield enum('YES','NO') COLLATE latin1_general_ci NOT NULL
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

INSERT INTO `table` VALUES('NO');
INSERT INTO `table` VALUES('YES');

SELECT * FROM `table` WHERE `enumfield` like 'YES';
# No result

# MyIsam
CREATE TABLE IF NOT EXISTS `table` (
  enumfield enum('YES','NO') COLLATE latin1_general_ci NOT NULL
) ENGINE=myisam DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

INSERT INTO `table` VALUES('NO');
INSERT INTO `table` VALUES('YES');

SELECT * FROM `table` WHERE `enumfield` like 'YES';
# Result : YES
[3 May 2010 10:45] Hartmut Holzgraefe 
Behavior changed somewhere between ndb-6.3.10 and ndb-6.3.11
[3 May 2010 13:05] Jørgen Austvik 
Workaround: S/LIKE/=/
[3 May 2010 14:05] Hartmut Holzgraefe 
Only happens with engine_condition_pushdown enabled, without pushdown it works fine even after 6.3.10
[17 May 2010 9:14] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108432

3199 Martin Skold	2010-05-17
      Bug#53360 No result for requests using LIKE condition on ENUM fields: Transform scanfiter for LIKE/NOT LIKE of ENUM into EQ/NE
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
[17 May 2010 9:55] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108434

3539 Martin Skold	2010-05-17 [merge]
      Merge
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
[17 May 2010 10:03] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108435

3609 Martin Skold	2010-05-17 [merge]
      Merge
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
[18 May 2010 9:57] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108497

3199 Martin Skold	2010-05-18
      Bug#53360 No result for requests using LIKE condition on ENUM fields: Disable pushdown of scanfiter for LIKE/NOT LIKE of ENUM
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
        sql/ha_ndbcluster_cond.h
[11 Nov 2010 8:08] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/123533

3139 Martin Skold	2010-11-11
      Bug#53360 No result for requests using LIKE condition on ENUM fields: Disable pushdown of scan filter for LIKE/NOT LIKE of ENUM
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
        sql/ha_ndbcluster_cond.h
[11 Nov 2010 8:21] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/123534

3337 Martin Skold	2010-11-11 [merge]
      Merge
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
        sql/ha_ndbcluster_cond.h
[11 Nov 2010 8:22] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/123535

3977 Martin Skold	2010-11-11 [merge]
      Merge
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
        sql/ha_ndbcluster_cond.h
[11 Nov 2010 8:23] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/123536

3967 Martin Skold	2010-11-11 [merge]
      Merge
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
        sql/ha_ndbcluster_cond.h
[11 Nov 2010 8:50] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/123538

3977 Martin Skold	2010-11-11 [merge]
      Merge
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
        sql/ha_ndbcluster_cond.h
[11 Nov 2010 9:01] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/123540

3995 Martin Skold	2010-11-11 [merge]
      Merge
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
        sql/ha_ndbcluster_cond.h
[11 Nov 2010 9:02] Bugs System 
Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.21 (revid:martin.skold@mysql.com-20101111090029-asg5xumiwz69fqpt) (version source revid:martin.skold@mysql.com-20101111090029-asg5xumiwz69fqpt) (merge vers: 5.1.51-ndb-7.0.21) (pib:21)
[11 Nov 2010 9:06] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/123541

3338 Martin Skold	2010-11-11 [merge]
      Merge
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
        sql/ha_ndbcluster_cond.h
[11 Nov 2010 9:07] Bugs System 
Pushed into mysql-5.1-telco-6.3 5.1.51-ndb-6.3.40 (revid:martin.skold@mysql.com-20101111090543-li6avbdacr1sgbyy) (version source revid:martin.skold@mysql.com-20101111090543-li6avbdacr1sgbyy) (merge vers: 5.1.51-ndb-6.3.40) (pib:21)
[11 Nov 2010 9:10] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/123543

3139 Martin Skold	2010-11-11 [merge]
      Merge
      modified:
        mysql-test/suite/ndb/r/ndb_condition_pushdown.result
        mysql-test/suite/ndb/t/ndb_condition_pushdown.test
        sql/ha_ndbcluster_cond.cc
        sql/ha_ndbcluster_cond.h
[11 Nov 2010 9:11] Bugs System 
Pushed into mysql-5.1-telco-6.2 5.1.51-ndb-6.2.19 (revid:martin.skold@mysql.com-20101111091014-tf39lc40xm4ff47b) (version source revid:martin.skold@mysql.com-20101111091014-tf39lc40xm4ff47b) (merge vers: 5.1.51-ndb-6.2.19) (pib:21)
[11 Nov 2010 11:42] Jon Stephens 
Documented bugfix in the NDB-6.2.19, 6.3.40, 7.0.21, and 7.1.9 changelogs, as follows:

        With engine_condition_pushdown enabled, a query using LIKE on an
        ENUM column of an NDB table failed to return any results. This
        issue is resolved by disabling engine_condition_pushdown when
        performing such queries.

Closed.