[JBoss JIRA] (TEIID-3298) invokeHttp procedure should support returning HTTP Response Code
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-3298?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-3298.
-----------------------------------
Fix Version/s: (was: 13.x)
Resolution: Out of Date
Marking as out of date as there's been no movement on this. All of the paths that use the return code have direct access to the execution. Given the way the procedure logic works, this would require a new output parameter and/or a new invoke call.
> invokeHttp procedure should support returning HTTP Response Code
> ----------------------------------------------------------------
>
> Key: TEIID-3298
> URL: https://issues.redhat.com/browse/TEIID-3298
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Affects Versions: 8.4
> Reporter: Ramesh Reddy
> Priority: Major
>
> Currently WS Translator supplied "invokeHttp" procedure only returns the result and as well as the content-type. It should also return response code.
> It may be useful to check if there is any other return parameters can be useful too. Like cookie etc.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
[JBoss JIRA] (TEIID-2554) Enhance MERGE to support INSERT/UPDATE and DELETE
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-2554?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-2554.
-----------------------------------
Fix Version/s: (was: 13.x)
Resolution: Deferred
> Enhance MERGE to support INSERT/UPDATE and DELETE
> -------------------------------------------------
>
> Key: TEIID-2554
> URL: https://issues.redhat.com/browse/TEIID-2554
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 8.4
> Reporter: Van Halbert
> Priority: Major
>
> Add delete support to MERGE. Example is SQL Server:
> MERGE <target_table> [AS TARGET]
> USING <table_source> [AS SOURCE]
> ON <search_condition>
> [WHEN MATCHED
> THEN <merge_matched> ]
> [WHEN NOT MATCHED [BY TARGET]
> THEN <merge_not_matched> ]
> [WHEN NOT MATCHED BY SOURCE
> THEN <merge_ matched> ];
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
[JBoss JIRA] (TEIID-1226) Reuse dynamic sql plans and allow for prepared statements in procedure logic
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-1226?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-1226.
-----------------------------------
Fix Version/s: (was: 13.x)
Resolution: Deferred
Marking as deferred as there's been no customer/community request for this functionality. A quick alternative would be to develop prepared plans from dynamic sql when applicable.
> Reuse dynamic sql plans and allow for prepared statements in procedure logic
> ----------------------------------------------------------------------------
>
> Key: TEIID-1226
> URL: https://issues.redhat.com/browse/TEIID-1226
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 7.1
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Minor
>
> Dynamic sql plans (for dynamic sql statements, lookup, and matview refreshes) should allow for plan reuse.
> Also procedure logic should have a mechanism to execute prepared statements for further plan reuse.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
[JBoss JIRA] (TEIID-992) Improve update of source costing statistics
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-992?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-992:
---------------------------------
Parent: (was: TEIID-245)
Issue Type: Feature Request (was: Sub-task)
> Improve update of source costing statistics
> -------------------------------------------
>
> Key: TEIID-992
> URL: https://issues.redhat.com/browse/TEIID-992
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors, Query Engine
> Reporter: Marc Shirley
> Priority: Major
>
> It is very important that we support the ability to update source statistics at runtime. This is important due to the changing nature of read/write sources and differences between a development data source and a production data source.
> The following options should be possible:
> 1) Update model/source statistics on VDB deployment.
> 2) Update model/source statistics on connector startup.
> 3) Update model/source statistics on at a scheduled time.
> 4) Update model/source statistics upon a manual request.
> case 5920
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
[JBoss JIRA] (TEIID-5913) Assist with productization of the documentation
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-5913?focusedWorklogId=12450520&pag... ]
Steven Hawkins logged work on TEIID-5913:
-----------------------------------------
Author: Steven Hawkins
Created on: 14/Mar/20 9:55 PM
Start Date: 14/Mar/20 9:55 PM
Worklog Time Spent: 30 minutes
Issue Time Tracking
-------------------
Time Spent: 2 days, 2 hours (was: 2 days, 1 hour, 30 minutes)
Worklog Id: (was: 12450520)
> Assist with productization of the documentation
> -----------------------------------------------
>
> Key: TEIID-5913
> URL: https://issues.redhat.com/browse/TEIID-5913
> Project: Teiid
> Issue Type: Task
> Components: Documentation
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.x
>
> Original Estimate: 1 day, 2 hours
> Time Spent: 2 days, 2 hours
> Remaining Estimate: 0 minutes
>
> Assist the documentation team in merging changes and keeping the community docs building.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
[JBoss JIRA] (TEIID-5876) MongoDB import name conflict issues
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-5876?focusedWorklogId=12450519&pag... ]
Steven Hawkins logged work on TEIID-5876:
-----------------------------------------
Author: Steven Hawkins
Created on: 14/Mar/20 9:54 PM
Start Date: 14/Mar/20 9:54 PM
Worklog Time Spent: 1 hour, 30 minutes
Issue Time Tracking
-------------------
Remaining Estimate: 30 minutes (was: 2 hours)
Time Spent: 3 hours, 30 minutes (was: 2 hours)
Worklog Id: (was: 12450519)
> MongoDB import name conflict issues
> -----------------------------------
>
> Key: TEIID-5876
> URL: https://issues.redhat.com/browse/TEIID-5876
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 14.0
>
> Original Estimate: 4 hours
> Time Spent: 3 hours, 30 minutes
> Remaining Estimate: 30 minutes
>
> There are two issues with the import logic and naming:
> 1. There's an assumption that any table in the schema was created by the mongodb import. In general this is not true as other imports or ddl may have already run.
> 2. If a child construct has a field name that matches an existing table, the two entities will get intertwined in the metadata, which is invalid.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
[JBoss JIRA] (TEIID-5876) MongoDB import name conflict issues
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-5876?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-5876.
-----------------------------------
Resolution: Done
Added and documented a new property to control if full embedded names are used.
> MongoDB import name conflict issues
> -----------------------------------
>
> Key: TEIID-5876
> URL: https://issues.redhat.com/browse/TEIID-5876
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 14.0
>
> Original Estimate: 4 hours
> Time Spent: 2 hours
> Remaining Estimate: 2 hours
>
> There are two issues with the import logic and naming:
> 1. There's an assumption that any table in the schema was created by the mongodb import. In general this is not true as other imports or ddl may have already run.
> 2. If a child construct has a field name that matches an existing table, the two entities will get intertwined in the metadata, which is invalid.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
[JBoss JIRA] (TEIID-5895) Review/create common mongodb logic
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-5895?focusedWorklogId=12450518&pag... ]
Steven Hawkins logged work on TEIID-5895:
-----------------------------------------
Author: Steven Hawkins
Created on: 14/Mar/20 9:53 PM
Start Date: 14/Mar/20 9:52 PM
Worklog Time Spent: 2 hours, 30 minutes
Issue Time Tracking
-------------------
Remaining Estimate: 1 hour, 30 minutes (was: 4 hours)
Time Spent: 2 hours, 30 minutes
Worklog Id: (was: 12450518)
> Review/create common mongodb logic
> ----------------------------------
>
> Key: TEIID-5895
> URL: https://issues.redhat.com/browse/TEIID-5895
> Project: Teiid
> Issue Type: Quality Risk
> Components: Misc. Connectors
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 14.0
>
> Original Estimate: 4 hours
> Time Spent: 2 hours, 30 minutes
> Remaining Estimate: 1 hour, 30 minutes
>
> Similar to the refactoring of infinispan connectivity, the logic should be shared between teiid and teiid spring boot. As well as a review of similar potential issues with the join filtering and TEIID-5876
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years