You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mike Matrigali (JIRA)" <ji...@apache.org> on 2007/04/17 23:22:15 UTC

[jira] Updated: (DERBY-2507) Query compiler assumes bad parameter type for ? is null expression

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

Mike Matrigali updated DERBY-2507:
----------------------------------

    Component/s: SQL

> 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: SQL
>    Affects Versions: 10.2.2.0
>            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 properly.
> 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.