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

Cannot prepare parameterized statement with a 'like' predicate

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.5.2
    • Fix Version/s: 4.14.0, 5.0.0
    • Component/s: None
    • Labels:
    • Environment:

      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.patch
          4 kB
          Kevin Liew
        2. PHOENIX-2314.5.patch
          4 kB
          Kevin Liew
        3. PHOENIX-2314.4.patch
          4 kB
          Kevin Liew
        4. PHOENIX-2314.3.patch
          4 kB
          Kevin Liew
        5. PHOENIX-2314.2.patch
          4 kB
          Kevin Liew

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: