9:56 a.m.
Steven Hawkins created TEIID-2185:
-------------------------------------
Summary: Cost estimation for temp table index selection is incorrect
Key: TEIID-2185
URL: https://issues.jboss.org/browse/TEIID-2185
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.2
The index selection for temporary tables incorrectly computes an additional cost factor
that biases the selection against secondary indexies.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:32 p.m.
[
https://issues.jboss.org/browse/TEIID-2185?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2185.
-----------------------------------
Resolution: Done
Corrected the logic and added a performance test to show index improvement. There's a
big todo to develop a planned form of a temp query to make it easier for unit testing to
show index usage.
Cost estimation for temp table index selection is incorrect
-----------------------------------------------------------
Key: TEIID-2185
URL: https://issues.jboss.org/browse/TEIID-2185
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.2
The index selection for temporary tables incorrectly computes an additional cost factor
that biases the selection against secondary indexies.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:22 p.m.
[
https://issues.jboss.org/browse/TEIID-2185?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2185:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=855966
Cost estimation for temp table index selection is incorrect
-----------------------------------------------------------
Key: TEIID-2185
URL: https://issues.jboss.org/browse/TEIID-2185
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.2
The index selection for temporary tables incorrectly computes an additional cost factor
that biases the selection against secondary indexies.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:22 p.m.
[
https://issues.jboss.org/browse/TEIID-2185?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2185:
-------------------------------------------
Bugzilla Update: Perform
Cost estimation for temp table index selection is incorrect
-----------------------------------------------------------
Key: TEIID-2185
URL: https://issues.jboss.org/browse/TEIID-2185
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.2
The index selection for temporary tables incorrectly computes an additional cost factor
that biases the selection against secondary indexies.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:34 p.m.
[
https://issues.jboss.org/browse/TEIID-2185?page=com.atlassian.jira.plugin...
]
Johnathon Lee updated TEIID-2185:
---------------------------------
Affects Version/s: 7.7.2
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=855966 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=855966)
Cost estimation for temp table index selection is incorrect
-----------------------------------------------------------
Key: TEIID-2185
URL: https://issues.jboss.org/browse/TEIID-2185
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4, 7.7.2
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.2
The index selection for temporary tables incorrectly computes an additional cost factor
that biases the selection against secondary indexies.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:53 a.m.
[
https://issues.jboss.org/browse/TEIID-2185?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-2185:
----------------------------------
Fix Version/s: 7.7.2
Cost estimation for temp table index selection is incorrect
-----------------------------------------------------------
Key: TEIID-2185
URL: https://issues.jboss.org/browse/TEIID-2185
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4, 7.7.2
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7.2, 8.2
The index selection for temporary tables incorrectly computes an additional cost factor
that biases the selection against secondary indexies.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:55 a.m.
[
https://issues.jboss.org/browse/TEIID-2185?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-2185.
---------------------------------
Cost estimation for temp table index selection is incorrect
-----------------------------------------------------------
Key: TEIID-2185
URL: https://issues.jboss.org/browse/TEIID-2185
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4, 7.7.2
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7.2, 8.2
The index selection for temporary tables incorrectly computes an additional cost factor
that biases the selection against secondary indexies.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4415
days inactive
4491
days old
6 comments
3 participants
participants (3)
-
Johnathon Lee (JIRA) -
RH Bugzilla Integration (JIRA)
-
Steven Hawkins (JIRA)