[JBoss JIRA] (TEIID-3362) Additional language constructs for arrays
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3362?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3362.
-----------------------------------
Resolution: Done
We already added support for values with multiple row values -
VALUES (1, 2), (3, 4)
To provide a quick way of producing rows.
So for this issue a new system procedure ARRAYITERATE was added -
select * from (call ARRAYITERATE((1, 2, 3, 4, 5))) as x
would produce 5 single column rows. However for simplicity it is weakly typed. It expects an object[] parameter, and produces an object result. So more than likely a cast will be needed in most scenarios.
> Additional language constructs for arrays
> -----------------------------------------
>
> Key: TEIID-3362
> URL: https://issues.jboss.org/browse/TEIID-3362
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.11
>
>
> Additional handling for arrays, such as an unnest function (columns to rows), a 2 dimensional form or arraytable, array concat etc. would be beneficial.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3394) Null values in oidvector and int2vector should be 0
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3394?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3394.
-----------------------------------
Resolution: Done
Updated the logic to use a 0 for null.
> Null values in oidvector and int2vector should be 0
> ---------------------------------------------------
>
> Key: TEIID-3394
> URL: https://issues.jboss.org/browse/TEIID-3394
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Affects Versions: 8.4
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.11
>
>
> If an oid or int2 vector has a null value in it our logic will omit that value, which results in an array out of bounds exception in the pg JDBC client. PostgreSQL will actually substitute 0 for null values. This can occur in querying pg_proc with a procedure that has an array argument.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3394) Null values in oidvector and int2vector should be 0
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3394:
-------------------------------------
Summary: Null values in oidvector and int2vector should be 0
Key: TEIID-3394
URL: https://issues.jboss.org/browse/TEIID-3394
Project: Teiid
Issue Type: Bug
Components: ODBC
Affects Versions: 8.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.11
If an oid or int2 vector has a null value in it our logic will omit that value, which results in an array out of bounds exception in the pg JDBC client. PostgreSQL will actually substitute 0 for null values. This can occur in querying pg_proc with a procedure that has an array argument.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3393) Add an adminapi interface impl for embedded
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3393:
-------------------------------------
Summary: Add an adminapi interface impl for embedded
Key: TEIID-3393
URL: https://issues.jboss.org/browse/TEIID-3393
Project: Teiid
Issue Type: Feature Request
Components: Embedded
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.11
For as many methods as seems reasonable we should implement the adminapi interface for embedded.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3380) Simplify Kerberos configuration with Embedded
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3380?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3380:
---------------------------------------
To follow the server paradigm, you'd need multiple session services then. It probably makes more sense just to have people rely on setting the security-domain in the VDB. The only reason to go the multiple session service direction is if there seems to be a need to independently configure session settings per transport (max, expiration, etc.).
> Simplify Kerberos configuration with Embedded
> ---------------------------------------------
>
> Key: TEIID-3380
> URL: https://issues.jboss.org/browse/TEIID-3380
> Project: Teiid
> Issue Type: Quality Risk
> Components: Embedded
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Fix For: 8.11
>
>
> The current code requires overriding the embedded server to install a custom session service. It may be good to have some base level of functionality built-in and/or just delegated to the security helper.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3380) Simplify Kerberos configuration with Embedded
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3380?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3380:
-------------------------------------
Do we want to introduce security domain per transport in the Embedded too? right now there is only single security domain per instance.
> Simplify Kerberos configuration with Embedded
> ---------------------------------------------
>
> Key: TEIID-3380
> URL: https://issues.jboss.org/browse/TEIID-3380
> Project: Teiid
> Issue Type: Quality Risk
> Components: Embedded
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Fix For: 8.11
>
>
> The current code requires overriding the embedded server to install a custom session service. It may be good to have some base level of functionality built-in and/or just delegated to the security helper.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3392) cached result set with lobs reports incorrect row number
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3392:
-------------------------------------
Summary: cached result set with lobs reports incorrect row number
Key: TEIID-3392
URL: https://issues.jboss.org/browse/TEIID-3392
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 8.11
Using the cached result when a lob is part of the result will only report rows up to the beginning of the last batch.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3380) Simplify Kerberos configuration with Embedded
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3380?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3380:
-------------------------------------
Looks like I can introduce a interface called "SecurityDomain" like
{code}
public interface SecurityDomain {
TeiidLoginContext authenticate(String userName, Credentials credentials, String applicationName, String domain)
throws LoginException;
GSSResult neogitiateGssLogin(String securityDomain, byte[] serviceTicket) throws LoginException;
}
{code}
then we can have embedded users register a implementation along with the name, that way it is abstracted away from the session service.
> Simplify Kerberos configuration with Embedded
> ---------------------------------------------
>
> Key: TEIID-3380
> URL: https://issues.jboss.org/browse/TEIID-3380
> Project: Teiid
> Issue Type: Quality Risk
> Components: Embedded
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Fix For: 8.11
>
>
> The current code requires overriding the embedded server to install a custom session service. It may be good to have some base level of functionality built-in and/or just delegated to the security helper.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years