[DERBY-4071] AssertFailure when selecting rows from a table with CHARACTER and VARCHAR columns

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0
• Fix Version/s: 10.4.2.1, 10.5.1.1, 10.6.1.0
• Component/s: SQL
• Issue & fix info: High Value Fix
• Bug behavior facts: Crash, Regression
• Assignee: Dag H. Wanvik
• Reporter: Aaron Digulla
• Created: 25/Feb/09 16:09
• Updated: 05/Jul/10 16:58
• Resolved: 19/Mar/09 15:45

Description

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.

Issue Links

• is duplicated by: DERBY-4247 Null pointer exception generated when preparing a statement containing "IN (?)" or "= ?", but not if using "IN (?, ?)" or enclosing the select query in another query.
• is related to: DERBY-4247 Null pointer exception generated when preparing a statement containing "IN (?)" or "= ?", but not if using "IN (?, ?)" or enclosing the select query in another query.
• relates to: DERBY-681 Eliminate the parser's rewriting of the abstract syntax tree for queries with GROUP BY and/or HAVING clauses