[JBoss JIRA] (TEIID-3732) Enable Infinispan-cache translator to negate intNum <> 1 returning true when column is null
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3732?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3732:
---------------------------------------
Google spreadsheets had a similar issue. It affected even ordered comparisons there since null was treated as a low value, so that may need to be checked here. Since Teiid does normalize / flatten the predicates prior to pushdown, this is valid workaround.
> Enable Infinispan-cache translator to negate intNum <> 1 returning true when column is null
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-3732
> URL: https://issues.jboss.org/browse/TEIID-3732
> Project: Teiid
> Issue Type: Feature Request
> Components: JDG Connector
> Reporter: Van Halbert
> Assignee: Van Halbert
>
> This is related to TEIID-3573. To add a support option so that when the translator sees criteria like intNum<>1 it would need to produce "intNum<>1 and intNum IS NOT NULL".
> This would negate the issue in JDG where it resolves intNum <> 1 to true when the column is null.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 10 months
[JBoss JIRA] (TEIID-2542) Utilize Teiid internal resultset buffering as a materialization mechanism to Infinspan
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2542?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2542:
----------------------------------
Fix Version/s: 10.0
We should be able to assess this further for 10.0. As the previous comment highlights there are a lot of issues with doing this integration at a low level. Instead we'd like to approach it at an entity level, but there are class loading and other issues that remain.
> Utilize Teiid internal resultset buffering as a materialization mechanism to Infinspan
> --------------------------------------------------------------------------------------
>
> Key: TEIID-2542
> URL: https://issues.jboss.org/browse/TEIID-2542
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors
> Reporter: Van Halbert
> Fix For: 10.0
>
>
> Add support for materialization to Infinispan by utilizing the Teiid internal buffering mechanism to Infinispan. Suggestion, turn that mechanism into a translator that can read/write to Infinispan.
> Pro's:
> - distributed data-grid fail-over and HA could be less costly than trying to do this with a database.
> - improved performance where each Infinispan instance could placed closer to its' users.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 10 months
[JBoss JIRA] (TEIID-2167) Permissions should also specify object type
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2167?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2167:
----------------------------------
Fix Version/s: 9.3
Now that we have this support in DDL it will be good to at least add the information to the xml/runtime format for round tripping purposes. It would still be optional though in the vdb.xml
> Permissions should also specify object type
> -------------------------------------------
>
> Key: TEIID-2167
> URL: https://issues.jboss.org/browse/TEIID-2167
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.3
>
>
> Teiid permissions only specify a resource name. However it is possible to have to have conflicting schema/table (since we are using non-sql safe unquoted names) or table/procedure names.
> Ideally we would use proper sql names (this is true everywhere, not just in permissions) and specify the object type (TABLE, PROCEDURE, SCHEMA, LANGUAGE, FUNCTION, etc.). This would also allow us to have a more standard USAGE permission, rather than something like LANGUAGE, which is used to convey the permission and object type.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 10 months
[JBoss JIRA] (TEIID-2123) Per model getMetadata() timeout
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2123?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2123:
----------------------------------
Component/s: Misc. Connectors
> Per model getMetadata() timeout
> -------------------------------
>
> Key: TEIID-2123
> URL: https://issues.jboss.org/browse/TEIID-2123
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors
> Affects Versions: 8.0
> Reporter: Mark Addleman
> Priority: Minor
> Fix For: Open To Community
>
>
> A way of specifying, per model, a timeout for the getMetadata() call. The timeout should be processed in such a way that delegating translators have an opportunity to intercept the interruption and, potentially, supply default metadata. I think the normal Thread.interrupt() approach should work.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 10 months