[teiid-issues] [JBoss JIRA] (TEIID-1958) Assertion failed in SortUtility
Mark Addleman (JIRA)
jira-events at lists.jboss.org
Wed Feb 29 20:16:36 EST 2012
[ 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
More information about the teiid-issues
mailing list