Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1650293073.1235578381843.JavaMail.jira@brutus>
Date: Wed, 25 Feb 2009 08:13:01 -0800 (PST)
From: "Aaron Digulla (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-4071) AssertFailure when selecting rows
 from a table with CHARACTER and VARCHAR columns
In-Reply-To: <1454652923.1235578265805.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ 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.