[JBoss JIRA] (TEIID-3205) Push down supported select expression even if other select expressions are not supported by the source
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3205?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3205.
-----------------------------------
Resolution: Done
Added initial support based upon pushing to a direct descendant access node during the last run of rule assign output elements (similar to the existing logic handling must pushdown functions). This is not the same as a complete notion of partial projection pushing - that would require quite a bit more code. However the current solution will only work in simplistic scenarios and is not based upon a notion of cost (that is a general rule would push projections based upon where the evaluation was least expensive).
> Push down supported select expression even if other select expressions are not supported by the source
> ------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3205
> URL: https://issues.jboss.org/browse/TEIID-3205
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7
> Reporter: Sanjeev Gour
> Assignee: Steven Hawkins
> Fix For: 8.10
>
>
> If the source supports for example the searched case expression and does not support a custom function, having both in the select caused searched case expression not to be pushed. More details are here-
> https://developer.jboss.org/message/909439#909439
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months
[JBoss JIRA] (TEIID-3212) Materialized Views Documentation Issues
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3212?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-3212.
---------------------------------
Labels: alpha1 (was: )
Resolution: Done
Also fixed in 8.9 and 8.7
> Materialized Views Documentation Issues
> ---------------------------------------
>
> Key: TEIID-3212
> URL: https://issues.jboss.org/browse/TEIID-3212
> Project: Teiid
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 8.7
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
> Labels: alpha1
> Fix For: 8.10
>
>
> On the documentation page https://docs.jboss.org/author/display/teiid87final/External+Materialization there are several inconsistencies within the text:
> 1. In doc property teiid_rel:MATVIEW_STAGE_TABLE is stated as optional, but in fact to activate the vdb setting of property teiid_rel:MATERIALIZED_STAGE_TABLE is required which is also in the sample code.
> 2. teiid_rel:MATVIEW_TTL stated as optional, but if not set error occurs on deploy.
> 3. In the table of properties is teiid_rel:ON_VDB_START_SCRIPT, but under the table there is teiid_rel:ON_VDB_CREATE_SCRIPT property.
> 4. in the sample vdb definition the Cache Hint with the query is misleading, as the teiid_rel:MATVIEW_TTL is required. In sync with issue TEIID-3209.
> On the https://docs.jboss.org/author/display/teiid87final/Internal+Materialization page:
> 1. in section "Updatable" the "Update SQL" query calls wrong procedure. It calls updateMatViewRow, but should call refreshMatViewRow as is stated in the surrounding text.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months
[JBoss JIRA] (TEIID-3219) Excel Translator Wrong Result From Columns With Interleaved Null Values
by Jan Stastny (JIRA)
Jan Stastny created TEIID-3219:
----------------------------------
Summary: Excel Translator Wrong Result From Columns With Interleaved Null Values
Key: TEIID-3219
URL: https://issues.jboss.org/browse/TEIID-3219
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.7.1
Reporter: Jan Stastny
Assignee: Steven Hawkins
When querying a column which has a null value somewhere in it, the result set is missing all the rows under the null value in the xlsx file. When querying more columns, the result set is missing some values only if there is a row, where both columns contains null value.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months
[JBoss JIRA] (TEIID-3214) Dynamic vdb is redeployed twice
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3214?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3214:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1163651|https://bugzilla.redhat.com/show_bug.cgi?id=1163651] from NEW to CLOSED
> Dynamic vdb is redeployed twice
> -------------------------------
>
> Key: TEIID-3214
> URL: https://issues.jboss.org/browse/TEIID-3214
> Project: Teiid
> Issue Type: Bug
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
>
> I have a dynamic vdb. When I redeploy it with command 'touch vdbname-vdb.xml.deployed' then the vdb is redeployed twice within 5 seconds. Whole the procedure runs twice - see the log in the end of description. When the vdb is redeployed by 'touch vdbname-vdb.xml' everything is fine. Happens only with dynamic vdbs, static vdbs and wars,etc work fine.
> Log:
> 09:23:13,599 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50026 VDB "mat-views.1[Source{Source=Source, h2-override, java:/mat-views-ds}, View{}]" undeployed.
> 09:23:13,604 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015877: Stopped deployment mat-views-vdb.xml (runtime-name: mat-views-vdb.xml) in 7ms
> 09:23:13,604 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "mat-views-vdb.xml" (runtime-name: "mat-views-vdb.xml")
> 09:23:13,629 INFO [org.teiid.SECURITY] (MSC service thread 1-1) TEIID40009 Admin [null] is terminating this session: ItnNDZmYCq/y.
> 09:23:13,633 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB mat-views.1 model "Source" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:13,634 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB mat-views.1 model "View" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:13,634 INFO [org.teiid.CONNECTOR] (teiid-async-threads - 3) H2ExecutionFactory Commit=true;DatabaseProductName=H2;DatabaseProductVersion=@PROJECT_VERSION@ (2012-07-13);DriverMajorVersion=1;DriverMajorVersion=3;DriverName=H2 JDBC Driver;DriverVersion=@PROJECT_VERSION@ (2012-07-13);IsolationLevel=2
> 09:23:13,636 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB mat-views.1 model "View" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:13,683 INFO [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS018562: Redeployed "mat-views-vdb.xml"
> 09:23:13,840 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50030 VDB mat-views.1 model "Source" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:13,846 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB mat-views.1 is set to ACTIVE
> 09:23:18,757 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50026 VDB "mat-views.1[Source{Source=Source, h2-override, java:/mat-views-ds}, View{}]" undeployed.
> 09:23:18,760 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015877: Stopped deployment mat-views-vdb.xml (runtime-name: mat-views-vdb.xml) in 4ms
> 09:23:18,761 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "mat-views-vdb.xml" (runtime-name: "mat-views-vdb.xml")
> 09:23:18,789 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB mat-views.1 model "Source" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:18,791 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB mat-views.1 model "View" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:18,795 INFO [org.teiid.CONNECTOR] (teiid-async-threads - 2) H2ExecutionFactory Commit=true;DatabaseProductName=H2;DatabaseProductVersion=@PROJECT_VERSION@ (2012-07-13);DriverMajorVersion=1;DriverMajorVersion=3;DriverName=H2 JDBC Driver;DriverVersion=@PROJECT_VERSION@ (2012-07-13);IsolationLevel=2
> 09:23:18,807 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50030 VDB mat-views.1 model "View" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:18,820 INFO [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS018565: Replaced deployment "mat-views-vdb.xml" with deployment "mat-views-vdb.xml"
> 09:23:18,999 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB mat-views.1 model "Source" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:19,005 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB mat-views.1 is set to ACTIVE
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months
[JBoss JIRA] (TEIID-3214) Dynamic vdb is redeployed twice
by Jan Stastny (JIRA)
[ https://issues.jboss.org/browse/TEIID-3214?page=com.atlassian.jira.plugin... ]
Jan Stastny commented on TEIID-3214:
------------------------------------
No problems using supported methods have been found so far.
> Dynamic vdb is redeployed twice
> -------------------------------
>
> Key: TEIID-3214
> URL: https://issues.jboss.org/browse/TEIID-3214
> Project: Teiid
> Issue Type: Bug
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
>
> I have a dynamic vdb. When I redeploy it with command 'touch vdbname-vdb.xml.deployed' then the vdb is redeployed twice within 5 seconds. Whole the procedure runs twice - see the log in the end of description. When the vdb is redeployed by 'touch vdbname-vdb.xml' everything is fine. Happens only with dynamic vdbs, static vdbs and wars,etc work fine.
> Log:
> 09:23:13,599 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50026 VDB "mat-views.1[Source{Source=Source, h2-override, java:/mat-views-ds}, View{}]" undeployed.
> 09:23:13,604 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015877: Stopped deployment mat-views-vdb.xml (runtime-name: mat-views-vdb.xml) in 7ms
> 09:23:13,604 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "mat-views-vdb.xml" (runtime-name: "mat-views-vdb.xml")
> 09:23:13,629 INFO [org.teiid.SECURITY] (MSC service thread 1-1) TEIID40009 Admin [null] is terminating this session: ItnNDZmYCq/y.
> 09:23:13,633 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB mat-views.1 model "Source" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:13,634 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB mat-views.1 model "View" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:13,634 INFO [org.teiid.CONNECTOR] (teiid-async-threads - 3) H2ExecutionFactory Commit=true;DatabaseProductName=H2;DatabaseProductVersion=@PROJECT_VERSION@ (2012-07-13);DriverMajorVersion=1;DriverMajorVersion=3;DriverName=H2 JDBC Driver;DriverVersion=@PROJECT_VERSION@ (2012-07-13);IsolationLevel=2
> 09:23:13,636 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB mat-views.1 model "View" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:13,683 INFO [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS018562: Redeployed "mat-views-vdb.xml"
> 09:23:13,840 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50030 VDB mat-views.1 model "Source" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:13,846 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB mat-views.1 is set to ACTIVE
> 09:23:18,757 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50026 VDB "mat-views.1[Source{Source=Source, h2-override, java:/mat-views-ds}, View{}]" undeployed.
> 09:23:18,760 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015877: Stopped deployment mat-views-vdb.xml (runtime-name: mat-views-vdb.xml) in 4ms
> 09:23:18,761 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "mat-views-vdb.xml" (runtime-name: "mat-views-vdb.xml")
> 09:23:18,789 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB mat-views.1 model "Source" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:18,791 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB mat-views.1 model "View" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:18,795 INFO [org.teiid.CONNECTOR] (teiid-async-threads - 2) H2ExecutionFactory Commit=true;DatabaseProductName=H2;DatabaseProductVersion=@PROJECT_VERSION@ (2012-07-13);DriverMajorVersion=1;DriverMajorVersion=3;DriverName=H2 JDBC Driver;DriverVersion=@PROJECT_VERSION@ (2012-07-13);IsolationLevel=2
> 09:23:18,807 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50030 VDB mat-views.1 model "View" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:18,820 INFO [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS018565: Replaced deployment "mat-views-vdb.xml" with deployment "mat-views-vdb.xml"
> 09:23:18,999 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB mat-views.1 model "Source" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:19,005 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB mat-views.1 is set to ACTIVE
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months
[JBoss JIRA] (TEIID-3214) Dynamic vdb is redeployed twice
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3214?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3214.
-----------------------------------
Resolution: Rejected
Resolving as rejected based upon Ramesh's comment. Jan if you see duplicate deployment with a supported deployment method let us know.
> Dynamic vdb is redeployed twice
> -------------------------------
>
> Key: TEIID-3214
> URL: https://issues.jboss.org/browse/TEIID-3214
> Project: Teiid
> Issue Type: Bug
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
>
> I have a dynamic vdb. When I redeploy it with command 'touch vdbname-vdb.xml.deployed' then the vdb is redeployed twice within 5 seconds. Whole the procedure runs twice - see the log in the end of description. When the vdb is redeployed by 'touch vdbname-vdb.xml' everything is fine. Happens only with dynamic vdbs, static vdbs and wars,etc work fine.
> Log:
> 09:23:13,599 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50026 VDB "mat-views.1[Source{Source=Source, h2-override, java:/mat-views-ds}, View{}]" undeployed.
> 09:23:13,604 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015877: Stopped deployment mat-views-vdb.xml (runtime-name: mat-views-vdb.xml) in 7ms
> 09:23:13,604 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "mat-views-vdb.xml" (runtime-name: "mat-views-vdb.xml")
> 09:23:13,629 INFO [org.teiid.SECURITY] (MSC service thread 1-1) TEIID40009 Admin [null] is terminating this session: ItnNDZmYCq/y.
> 09:23:13,633 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB mat-views.1 model "Source" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:13,634 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB mat-views.1 model "View" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:13,634 INFO [org.teiid.CONNECTOR] (teiid-async-threads - 3) H2ExecutionFactory Commit=true;DatabaseProductName=H2;DatabaseProductVersion=@PROJECT_VERSION@ (2012-07-13);DriverMajorVersion=1;DriverMajorVersion=3;DriverName=H2 JDBC Driver;DriverVersion=@PROJECT_VERSION@ (2012-07-13);IsolationLevel=2
> 09:23:13,636 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB mat-views.1 model "View" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:13,683 INFO [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS018562: Redeployed "mat-views-vdb.xml"
> 09:23:13,840 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50030 VDB mat-views.1 model "Source" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:13,846 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB mat-views.1 is set to ACTIVE
> 09:23:18,757 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50026 VDB "mat-views.1[Source{Source=Source, h2-override, java:/mat-views-ds}, View{}]" undeployed.
> 09:23:18,760 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015877: Stopped deployment mat-views-vdb.xml (runtime-name: mat-views-vdb.xml) in 4ms
> 09:23:18,761 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "mat-views-vdb.xml" (runtime-name: "mat-views-vdb.xml")
> 09:23:18,789 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB mat-views.1 model "Source" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:18,791 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB mat-views.1 model "View" metadata is currently being loaded. Start Time: 11/13/14 9:23 AM
> 09:23:18,795 INFO [org.teiid.CONNECTOR] (teiid-async-threads - 2) H2ExecutionFactory Commit=true;DatabaseProductName=H2;DatabaseProductVersion=@PROJECT_VERSION@ (2012-07-13);DriverMajorVersion=1;DriverMajorVersion=3;DriverName=H2 JDBC Driver;DriverVersion=@PROJECT_VERSION@ (2012-07-13);IsolationLevel=2
> 09:23:18,807 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50030 VDB mat-views.1 model "View" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:18,820 INFO [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS018565: Replaced deployment "mat-views-vdb.xml" with deployment "mat-views-vdb.xml"
> 09:23:18,999 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB mat-views.1 model "Source" metadata loaded. End Time: 11/13/14 9:23 AM
> 09:23:19,005 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB mat-views.1 is set to ACTIVE
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months