Return-Path: X-Original-To: apmail-phoenix-dev-archive@minotaur.apache.org Delivered-To: apmail-phoenix-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0F7BA187BA for ; Fri, 26 Jun 2015 18:11:32 +0000 (UTC) Received: (qmail 70097 invoked by uid 500); 26 Jun 2015 18:11:31 -0000 Delivered-To: apmail-phoenix-dev-archive@phoenix.apache.org Received: (qmail 70042 invoked by uid 500); 26 Jun 2015 18:11:31 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 70031 invoked by uid 99); 26 Jun 2015 18:11:31 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Jun 2015 18:11:31 +0000 X-ASF-Spam-Status: No, hits=-2001.4 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 26 Jun 2015 18:09:21 +0000 Received: (qmail 67172 invoked by uid 99); 26 Jun 2015 18:11:08 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Jun 2015 18:11:08 +0000 Date: Fri, 26 Jun 2015 18:11:08 +0000 (UTC) From: "Thomas D'Silva (JIRA)" To: dev@phoenix.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (PHOENIX-2073) Two bytes character in LIKE expression is not allowed MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/PHOENIX-2073?page=3Dcom.atlass= ian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-2073: ------------------------------------ Fix Version/s: 4.4.1 4.5.0 5.0.0 > Two bytes character in LIKE expression is not allowed > ----------------------------------------------------- > > Key: PHOENIX-2073 > URL: https://issues.apache.org/jira/browse/PHOENIX-2073 > Project: Phoenix > Issue Type: Bug > Reporter: Yuhao Bi > Fix For: 5.0.0, 4.5.0, 4.4.1 > > Attachments: PHOENIX-2073-v1.patch, PHOENIX-2073.patch > > > If you use some two bytes character like Chinese characters in like expre= ssion, you will get a SQLException. > SELECT * FROM TEST.TEST WHERE name LIKE '=E4=B8=AD=E6=96=87%'; > java.sql.SQLException: ERROR 201 (22000): Illegal data. CHAR types may on= ly contain single byte characters (=E4=B8=AD=E6=96=87) -- This message was sent by Atlassian JIRA (v6.3.4#6332)