db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcin Cinik (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-2507) Query compiler assumes bad parameter type for ? is null expression
Date Sat, 01 Nov 2014 13:32:34 GMT

    [ 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)

Mime
View raw message