[
https://issues.apache.org/jira/browse/DERBY-2507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14193160#comment-14193160
]
Marcin Cinik commented on DERBY-2507:
-------------------------------------
reproducible in 10.10.1.1 embeeded as well
> 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: 10.2.2.0
> Reporter: Xavier Hanin
> Labels: derby_triage10_5_2
>
> 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 was sent by Atlassian JIRA
(v6.3.4#6332)
