db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2507) Query compiler assumes bad parameter type for ? is null expression
Date Mon, 06 Jul 2009 19:11:14 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Rick Hillegas updated DERBY-2507:

           Component/s:     (was: SQL)
               Urgency: Normal
    Bug behavior facts: [Embedded/Client difference]

Triaged for 10.5.2: assigned normal urgency, reclassified as JDBC and embedded/client difference.

> Query compiler assumes bad parameter type for ? is null expression
> ------------------------------------------------------------------
>                 Key: DERBY-2507
>                 URL: https://issues.apache.org/jira/browse/DERBY-2507
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions:
>            Reporter: Xavier Hanin
> 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
> See this thread for more details:
> http://mail-archive.com/derby-user%40db.apache.org/msg06503.html

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message