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 "Xavier Hanin (JIRA)" <ji...@apache.org> on 2007/04/01 19:06:32 UTC
[jira] Created: (DERBY-2507) Query compiler assumes bad parameter
type for ? is null expression
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
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.
[jira] Updated: (DERBY-2507) Query compiler assumes bad parameter
type for ? is null expression
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (DERBY-2507) Query compiler assumes bad parameter
type for ? is null expression
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ 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)
JDBC
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: 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.