Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1869750806.1203545023334.JavaMail.jira@brutus>
Date: Wed, 20 Feb 2008 14:03:43 -0800 (PST)
From: "Kathey Marsden (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-3310) ASSERT in
 MergeSort.checkColumnTypes() disallow legal type conversions
In-Reply-To: <4068391.1199894734052.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-3310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12570848#action_12570848 ] 

Kathey Marsden commented on DERBY-3310:
---------------------------------------

Thank you so much Bryan for your help with this issue.
I am a bit of a novice in this area so forgive if my questions
are basic.  You said:
- the PRN should sort values with integer type, and feed them up to the NRSN
 - the NRS should invoke normalizeRow() to convert the int to a long
 - the InsertNode should pull long values from the NRS and insert them
   into the target table. 

and also said in an earlier comment.
>So I'd suggest investigating the NormalizeResultSetNode, and
whether it is generating the proper buffering CAST operations. 

If the sort happens before normalization, how could CAST operations in 
NormalizeResultSetNode  have an effect on the sort?


> ASSERT in MergeSort.checkColumnTypes() disallow legal type conversions
> ----------------------------------------------------------------------
>
>                 Key: DERBY-3310
>                 URL: https://issues.apache.org/jira/browse/DERBY-3310
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.4.0.0
>            Reporter: Dyre Tjeldvoll
>            Priority: Minor
>         Attachments: cast-repro.sql
>
>
> The following code 
> CREATE TABLE U (SNAME VARCHAR(32000), TNAME VARCHAR(32000), C1 BIGINT);
> -- This triggers an ASSERT (because 2 is INTEGER and not BIGINT)
> INSERT INTO U(SNAME, TNAME, C1) SELECT DISTINCT SCHEMANAME, TABLENAME, 2
>  FROM SYS.SYSTABLES T JOIN SYS.SYSSCHEMAS S ON T.SCHEMAID = S.SCHEMAID;
> gives
> ERROR XJ001: Java exception: 'ASSERT FAILED col1.getClass() (class org.apache.derby.iapi.types.SQLInteger) expected to be the same as col2.getClass() (class org.apache.derby.iapi.types.SQLLongint): org.apache.derby.shared.common.sanity.AssertFailure'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.