[ https://issues.apache.org/jira/browse/DERBY-4071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12676705#action_12676705 ]
Bryan Pendleton commented on DERBY-4071: ---------------------------------------- I'm not sure what you mean by "swap the two columns". Can you explain further? Also, have you experimented with using CAST() to make the data type conversion more explicit? > 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.