[JBoss JIRA] (TEIID-4544) Change Teradata defaults for dependent joins
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-4544?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-4544.
-----------------------------------
Resolution: Done
Updated to use a max in of 1024 (taken from the hibernate docs) and a max dependent in
predicates of 5 (from the associated forum post). Also added the class name for the
hibernate dialect to allow dependent join pushdown. If this is backported to 8.12.x the
reference to the Teradata14Dialect will not be valid and must be removed.
Change Teradata defaults for dependent joins
--------------------------------------------
Key: TEIID-4544
URL: https://issues.jboss.org/browse/TEIID-4544
Project: Teiid
Issue Type: Enhancement
Components: JDBC Connector
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.2
Teradata does not suggest hard limits on in predicates, but uses the wording:
"Queries that contain thousands of arguments within an IN or NOT IN clause sometimes
fail."
It has been reported that the defaults of 50 in predicates with 1000 values each will
cause such a failure.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
2933
days inactive
2933
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)