[
https://issues.apache.org/jira/browse/DERBY-3310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12583229#action_12583229
]
Bryan Pendleton commented on DERBY-3310:
----------------------------------------
A little late on this, but I finally got around to having a close read
of Army's writeup and it seems 100% accurate to me. It's a
wonderful document, and it really helped me understand how
the Normalize node works, as well as the DERBY-2775 changes interacted
to exhibit this behavior.
I think that the document would be quite valuable in the
class-level javadoc for NormalizeResultSetNode.java, as it
really does an excellent job of explaining how NRSN is intended to work.
It's a clear example, and quite carefully worded and thorough.
I also think that the document would be quite useful in the wiki,
if that proves to be easier.
> 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
> Assignee: Kathey Marsden
> Priority: Minor
> Fix For: 10.4.1.0, 10.5.0.0
>
> Attachments: cast-repro.sql, d3310_writeup_1.html,
> derby-3310_diff.txt, derby-3310_diff.txt,
> derby-3310_remove_genNormalizeResultSetNode_diff.txt,
> derby-3310_try1_diff.txt, derby3310_rsn_cleanup_1.txt
>
>
> 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.
