[PHOENIX-2073] Two bytes character in LIKE expression is not allowed

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.5.0, 4.4.1
• Assignee: Unassigned
• Reporter: Yuhao Bi
• Created: 25/Jun/15 01:45
• Updated: 21/Nov/15 02:16
• Resolved: 26/Jun/15 18:11

Description

If you use some two bytes character like Chinese characters in like expression, you will get a SQLException.

SELECT * FROM TEST.TEST WHERE name LIKE '中文%';

java.sql.SQLException: ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters (中文)