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

Cannot prepare parameterized statement with a 'like' predicate

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 4.5.2
    • 4.14.0, 5.0.0
    • None

    • Using Fiddler or cURL to communicate with a Phoenix 4.5.2 queryserver using Avatica wire protocol

    Description

      POST

      request: { "request":"prepare", "connectionId":"1646a1b9-334e-4a21-ade8-47c3d0c8e5a3", "sql":"select * from emp where first_name like ?", "maxRowCount":-1 }
Host: 192.168.203.156:8765
Content-Length: 0

      select * from emp where first_name like ?

      RESPONSE

      HTTP/1.1 500 org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type mismatch. BOOLEAN for null
Date: Wed, 07 Oct 2015 22:42:26 GMT
Cache-Control: must-revalidate,no-cache,no-store
Content-Type: text/html; charset=ISO-8859-1
Content-Length: 368
Connection: close
Server: Jetty(9.2.z-SNAPSHOT)

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
<title>Error 500 </title>
</head>
<body>
<h2>HTTP ERROR: 500</h2>
<p>Problem accessing /. Reason:
<pre>    org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type mismatch. BOOLEAN for null</pre></p>
<hr /><i><small>Powered by Jetty://</small></i>
</body>
</html>

      org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type mismatch. BOOLEAN for null

      Attachments

        1. PHOENIX-2314.5.patch
          4 kB
          Kevin Liew
        2. PHOENIX-2314.4.patch
          4 kB
          Kevin Liew
        3. PHOENIX-2314.3.patch
          4 kB
          Kevin Liew
        4. PHOENIX-2314.2.patch
          4 kB
          Kevin Liew
        5. PHOENIX-2314.patch
          4 kB
          Kevin Liew

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. PHOENIX-3510 Phoenix LIKE operator with bind parameters - Error -1 (00000) : while preparing SQL; Binded parameter in the SELECT clause

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              kliew Kevin Liew
              kliew Kevin Liew
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: