[JBoss JIRA] (TEIIDDES-3028) Add "LoadNumber" column to Materialized View cache tables
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- April
- March
- February
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- 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/TEIIDDES-3028?page=com.atlassian.jira.plu...
]
Van Halbert commented on TEIIDDES-3028:
---------------------------------------
For The JDG materialize use case needs to be tested with this, so that the pojo that is
created will contain the loadnumber attribute. And for this use case, will also need to
do the following:
- do not fill in the following:
MATVIEW_BEFORE_LOAD_SCRIPT
MATVIEW_AFTER_LOAD_SCRIPT
MATERIALIZED_STAGE_TABLE
- do not create the "Staging" table
We need to fully discuss how this will all roll out and implications to the original
feature.
Add "LoadNumber" column to Materialized View cache tables
---------------------------------------------------------
Key: TEIIDDES-3028
URL: https://issues.jboss.org/browse/TEIIDDES-3028
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Reporter: Ramesh Reddy
Priority: Blocker
Fix For: 11.2
Based on TEIID-4628, to work with eager updates on materiliazed view, a materialized
view's cached table MUST contain an additional column called "LoadNumber"
along with rest of view columns. This column is used track the and update the cache
contents according to the
{code}
SYSADMIN.updatematView
{code}
procedure. The relevant document can be found at
https://teiid.gitbooks.io/documents/content/caching/External_Materializat...
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
3362
days inactive
3362
days old
teiid-designer-issues@lists.jboss.org
0 comments
1 participants
tags (0)
participants (1)
-
Van Halbert (JIRA)