[
https://issues.apache.org/jira/browse/DERBY-4071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12676689#action_12676689
]
Aaron Digulla commented on DERBY-4071:
--------------------------------------
This is the query:
[code]
SELECT *
FROM DEMO.TEST S
WHERE S.VCHR IN (
SELECT VCHR
FROM DEMO.TEST
GROUP BY VCHR
HAVING COUNT (VCHR) > 1
)
AND CHR NOT IN (
SELECT MAX(CHR)
FROM DEMO.TEST T
WHERE S.VCHR = T.VCHR
GROUP BY T.VCHR
HAVING COUNT(T.VCHR) > 1
)
[code]
> AssertFailure when selecting rows from a table with CHARACTER and VARCHAR
> columns
> ---------------------------------------------------------------------------------
>
> Key: DERBY-4071
> URL: https://issues.apache.org/jira/browse/DERBY-4071
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.4.2.0
> Reporter: Aaron Digulla
> Attachments: DerbyTest.java
>
>
> When running a complex query on this table:
> [code]
> Create table DEMO.TEST (
> CHR CHARACTER(26) ,
> VCHR VARCHAR(25) )
> [code]
> then I get this exception:
> AssertFailure: ASSERT FAILED col1.getClass() (class ...SQLChar) expected to
> be the same as col2.getClass() (class ....SQLVarchar)' was thrown while
> evaluating an expression.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
