[JBoss JIRA] (TEIID-3907) Support compensating transactions for updatable non-XA sources
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3907?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3907:
----------------------------------
Fix Version/s: 11.2
(was: 11.1)
> Support compensating transactions for updatable non-XA sources
> --------------------------------------------------------------
>
> Key: TEIID-3907
> URL: https://issues.jboss.org/browse/TEIID-3907
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Affects Versions: 9.x
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 11.2
>
>
> The transaction manager will fully support xa with all xa sources and a single local transaction resource. Beyond that however there is no built-in support for compensating transactions with non-XA sources. There has been work in Narayana on compensating transactions though that could be used by custom web apps consuming Teiid. We would like to eventually offer compensating options for some of our updatable non-XA sources, but it hasn't had sufficient priority yet.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 4 months
[JBoss JIRA] (TEIID-5459) Support for large counts/ranks
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-5459:
-------------------------------------
Summary: Support for large counts/ranks
Key: TEIID-5459
URL: https://issues.jboss.org/browse/TEIID-5459
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 11.2
Most databases implement analytical ranks/row_number as returning bigint - regardless of what type count returns. MS SQL introduced BIG_COUNT, and Postgresql switched everything to bigint in 7.2.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 4 months
[JBoss JIRA] (TEIID-5447) support for percent_rank, cume_dist, nth_value
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5447?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5447:
---------------------------------------
All of the remaining functions have been committed - however the implementation is based upon the old logic that does not yet support a windowing clause. That will be added in 11.2 - TEIID-5316
For now the logic uses temporary arrays and secondary computation of the final value using multiple values. That should change once the logic is refactored to provide the entire window frame to the evaluation of the function.
> support for percent_rank, cume_dist, nth_value
> ----------------------------------------------
>
> Key: TEIID-5447
> URL: https://issues.jboss.org/browse/TEIID-5447
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
>
> Implementations for percent_rank, cume_dist, nth_value will have similar logic to ntile TEIID-5442 so they will be simple to add as well.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 4 months