MySQL Bugs: #68155: LIKE operator for VARCHAR fields with full length doesn't work

Bug #68155	LIKE operator for VARCHAR fields with full length doesn't work
Submitted:	23 Jan 2013 14:12	Modified:	1 Oct 2013 12:33
Reporter:	Piercarlo Beghetto	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	7.2.10	OS:	Linux (CentOS 6.3 x86_64)
Assigned to:		CPU Architecture:	Any
Tags:	SELECT LIKE FIELD LENGTH

Description:
Hi,

in my web application i use some filters with LIKE operator for text field (VARCHAT(16) in my tables).

If i try match DB field with my Strings with operator "LIKE", if the field value is full lenght (16 chars), LIKE does not work returning 0 records.

Same match with operator "=" works fine.

Version of mySql cluster is 7.2.10 on a Linux system.
I don't have this problem in a NON cluster mySql.

I've seen some similar bugs posted for previus versions but none of those was about field lenght.

I 

How to repeat:
CREATE TABLE TEST_TABLE (
  ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  FIELD VARCHAR(10) NOT NULL,
  PRIMARY KEY (ID)
)
ENGINE = ndbcluster DEFAULT CHARSET=utf8;

INSERT INTO TEST_TABLE (FIELD) VALUES ('AAAAAAAAAA');

/* WORKS */
SELECT * FROM TEST_TABLE T WHERE FIELD LIKE 'AAAAAAAAAA';
Returns the record

/* DOESN'T WORK */
SELECT * FROM TEST_TABLE T WHERE FIELD LIKE '%AAAAAAAAAA%';
Returns 0 records

Suggested fix:
Make Like operator work in cluster version like it does in NON cluster one.

Hello Piercarlo,

Thank you for the report.

Verified as described.

Thanks,
Umesh

Hi,

any news for this issue?

Piercarlo Beghetto

Duplicate of http://bugs.mysql.com/bug.php?id=67724