Bug #32510 LIKE search fails with indexed 'eucjpms' and 'ujis' char column
Submitted: 20 Nov 2007 7:55 Modified: 31 Mar 2008 16:46
Reporter: Mikiya Okuno Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Charsets Severity:S2 (Serious)
Version:5.0.50 OS:Any
Assigned to: Alexander Barkov CPU Architecture:Any
Tags: bfsm_2007_12_06, charset eucjpms like

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[20 Nov 2007 7:56] Mikiya Okuno
Statements to create the table and populate the data into it.

Attachment: DDL.sql (, text), 618 bytes.

[20 Nov 2007 7:58] Mikiya Okuno
The SELECT statement with a problematic pattern.

Attachment: select.sql (, text), 58 bytes.

[20 Nov 2007 7:59] Mikiya Okuno
Example result.

Attachment: query_and_result.txt (text/plain), 1.89 KiB.