[ https://issues.apache.org/jira/browse/DERBY-2998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12573457#action_12573457 ]
Thomas Nielsen commented on DERBY-2998: --------------------------------------- It seems from a debugging session that the two last join queries Army posted both fail due to failure to classify some of the PRNs as noops. If a PRN is classified a noop, the RCL nodes are maked as redundant, and during code generation we walk further down the RC-tree to lay out the code at a lower level. If not marked as redundant we pull the value from the current level result set. If I understand this correctly the last two queries end up trying to get the values from the current level when it should really look even further down. Manually changing the isRedundant flag in the debugger actually produces what seems to be the correct results. > Add support for ROW_NUMBER() window function > -------------------------------------------- > > Key: DERBY-2998 > URL: https://issues.apache.org/jira/browse/DERBY-2998 > Project: Derby > Issue Type: Sub-task > Components: SQL > Reporter: Thomas Nielsen > Assignee: Thomas Nielsen > Priority: Minor > Attachments: d2998-10.diff, d2998-10.stat, d2998-11.diff, > d2998-12.diff, d2998-12.stat, d2998-13.diff, d2998-13.stat, d2998-14.diff, > d2998-14.stat, d2998-15.diff, d2998-15.stat, d2998-16.diff, d2998-16.stat, > d2998-17.diff, d2998-17.stat, d2998-18.diff, d2998-18.stat, d2998-4.diff, > d2998-4.stat, d2998-5.diff, d2998-5.stat, d2998-6.diff, d2998-6.stat, > d2998-7.diff, d2998-7.stat, d2998-8.diff, d2998-8.stat, d2998-9-derby.log, > d2998-9.diff, d2998-9.stat, d2998-doc-1.diff, d2998-doc-1.stat, > d2998-test.diff, d2998-test.stat, d2998-test2.diff, d2998-test2.stat, > d2998-test3.diff, d2998-test3.stat, d2998-test4.diff, d2998-test4.stat, > d2998-test6.diff, d2998-test7.diff, d2998-test8.diff > > > As part of implementing the overall OLAP Operations features of SQL > (DERBY-581), implement the ROW_NUMBER() window function. > More information about this feature is available at > http://wiki.apache.org/db-derby/OLAPRowNumber -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.