[ https://issues.jboss.org/browse/TEIID-1958?page=com.atlassian.jira.plugin... ] 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> -- 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

[ https://issues.jboss.org/browse/TEIID-1958?page=com.atlassian.jira.plugin... ] Mark Addleman commented on TEIID-1958: -------------------------------------- Fixed our SQL conversion error and ended up right where I started: An assertion failure in SortUtility. Full query plan and exception traces attached. -- 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

[ https://issues.jboss.org/browse/TEIID-1958?page=com.atlassian.jira.plugin... ] Mark Addleman commented on TEIID-1958: -------------------------------------- I have rewritten our query to avoid the problem: the GROUP BYs in the inner SELECT statements are redundant with the outer SELECT DISTINCT. When I remove the GROUP BY clauses, I can avoid the bug (and achieve better performance, it seems). -- 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

[ https://issues.jboss.org/browse/TEIID-1958?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1958: --------------------------------------- Can you confirm is this was on 7.7 or 7.6? If it is 7.7, do you want to resolve it as incomplete description given that you have a workaround or can you provide additional information? -- 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

[ https://issues.jboss.org/browse/TEIID-1958?page=com.atlassian.jira.plugin... ] Mark Addleman closed TEIID-1958. -------------------------------- Resolution: Incomplete Description -- 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