[ https://issues.apache.org/jira/browse/DERBY-4071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12676916#action_12676916 ] Aaron Digulla commented on DERBY-4071: -------------------------------------- Update: The quick fix doesn't work with my more complex real table. But it might get you on the right track. > 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.