[teiid-issues] [JBoss JIRA] (TEIID-1958) Assertion failed in SortUtility

[Mark Addleman (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1958?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12672358#comment-12672358 ] 

Mark Addleman commented on TEIID-1958:
--------------------------------------

Easier just to copy & past plan: 
SQL:
SELECT DISTINCT c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23 

FROM (

	SELECT '__column__' AS c_0, dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, dsGroup AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, dsSystem AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, dsSSID AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23 

	FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase 

	GROUP BY dsConf, dsGroup, dsSystem, dsSSID 

	UNION ALL

	SELECT '__column__' AS c_0, dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, dsSystem AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, dsSSID AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23 

	FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsSystem, dsSSID

) AS u ORDER BY c_1
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<node name="AccessNode">
    <property name="Output Columns">
        <value>c_0 (string)</value>
        <value>c_1 (string)</value>
        <value>c_2 (string)</value>
        <value>c_3 (null)</value>
        <value>c_4 (string)</value>
        <value>c_5 (string)</value>
        <value>c_6 (null)</value>
        <value>c_7 (null)</value>
        <value>c_8 (string)</value>
        <value>c_9 (string)</value>
        <value>c_10 (string)</value>
        <value>c_11 (null)</value>
        <value>c_12 (string)</value>
        <value>c_13 (string)</value>
        <value>c_14 (string)</value>
        <value>c_15 (null)</value>
        <value>c_16 (string)</value>
        <value>c_17 (string)</value>
        <value>c_18 (string)</value>
        <value>c_19 (null)</value>
        <value>c_20 (string)</value>
        <value>c_21 (string)</value>
        <value>c_22 (string)</value>
        <value>c_23 (null)</value>
    </property>
    <property name="Statistics">
        <value>Node Output Rows: 0</value>
        <value>Node Process Time: 7</value>
        <value>Node Cumulative Process Time: 7</value>
        <value>Node Cumulative Next Batch Process Time: 1</value>
        <value>Node Next Batch Calls: 2</value>
        <value>Node Blocks: 1</value>
    </property>
    <property name="Cost Estimates">
        <value>Estimated Node Cardinality: -1.0</value>
    </property>
    <property name="Query">
        <value>SELECT '__column__' AS c_0, g_1.dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, g_1.dsGroup AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, g_1.dsSystem AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, g_1.dsSSID AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS g_1 GROUP BY g_1.dsConf, g_1.dsGroup, g_1.dsSystem, g_1.dsSSID UNION SELECT '__column__' AS c_0, g_0.dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, g_0.dsSystem AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, g_0.dsSSID AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS g_0 GROUP BY g_0.dsConf, g_0.dsSystem, g_0.dsSSID ORDER BY c_1</value>
    </property>
    <property name="Model Name">
        <value>DBMzDB2</value>
    </property>
</node>

                
> Assertion failed in SortUtility
> -------------------------------
>
>                 Key: TEIID-1958
>                 URL: https://issues.jboss.org/browse/TEIID-1958
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.7
>            Reporter: Mark Addleman
>            Assignee: Steven Hawkins
>
> Getting an assert failure in SortUtility.  Plan is attached.  Stack trace below:
> Caused by: java.lang.AssertionError: Assertion failed.
> at org.teiid.core.util.Assertion.failed(Assertion.java:73)
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68)
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60)
> at org.teiid.query.processor.relational.SortUtility.<init>(SortUtility.java:145)
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:96)
> at org.teiid.query.processor.relational.SortNode.getFinalBuffer(SortNode.java:180)
> at org.teiid.query.processor.relational.RelationalPlan.getFinalBuffer(RelationalPlan.java:307)
> at org.teiid.query.processor.QueryProcessor.getFinalBuffer(QueryProcessor.java:239)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:137)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
> ... 37 more

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira