Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2354

use like expression in SELECT query. It works well when I put Chinese characters

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.4.0
    • Fix Version/s: 4.5.0
    • Labels:
      None
    • Environment:

      Phoenix on Hbase

      Description

      When I use like expression in SELECT query. It works well when I put Chinese characters in
      LIKE expression on NONE PRIMARY KEY columns . BUT when I put them in LIKE expression on PRIMARY
      KEY , it occurs an Exception:‍

      select * from "test3" where PK like '手机%'; ‍

      org.apache.phoenix.schema.IllegalDataException: CHAR types may only contain single byte characters
      (手机) ‍

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              tzpBingo tzpBingo
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: