Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2507

Query compiler assumes bad parameter type for ? is null expression

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.2.2.0
    • None
    • JDBC
    • Normal
    • Embedded/Client difference

    Description

      When using '? is null' in a prepared Statement, the compiler assumes ? as VARCHAR parameter, and thus fails if you bind a VARBINARY object to the parameter:
      org.apache.derby.impl.jdbc.EmbedSQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'VARBINARY'

      In Derby 10.2..2.0, only the embededded driver has the problem, the client driver works properly.

      See this thread for more details:
      http://mail-archive.com/derby-user%40db.apache.org/msg06503.html

      Attachments

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-5728 Add Support for NULL IS NULL

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Activity

            People

              Unassigned Unassigned
              xavier Xavier Hanin
              Votes:
              2 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: