September 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5026) Add function to transform timestamp into Unix time

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5026?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5026. ----------------------------------- Resolution: Done For 10.0 resolved with a breaking change to align the from_unixtime function to the definition used by hive/impala - which were the only sources marked as supporting the pushdown. Sources supporting timestampadd will no longer have a compensating version of from_unixtime pushed as it only supports integers and returns a timestamp, not a string. Additionally unix_timestamp was added for the inverse operation - string to long. Neither function yet supports a format string, but rather assume the default format. For those that may need conversion to and from milliseconds the related to_millis and from_millis. > Add function to transform timestamp into Unix time > -------------------------------------------------- > > Key: TEIID-5026 > URL: https://issues.jboss.org/browse/TEIID-5026 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Jan Stastny > Assignee: Steven Hawkins > Fix For: 10.0 > > > Teiid supports function FROM_UNIXTIME as a result of TEIID-248. > There isn't its reverse counterpart though. > This is an issue, when there is a data source which doesn't support timestamp/date/time data types: > * users choose to use long(unix time) in the source > * by using FROM_UNIXTIME function they transform the long value (unix time) into respective data type value in their virtual model > * they can read such source. > * they can't insert/update it as this would require 'INSTEAD OF TRIGGER' with ability to transform timestamp/time/date back to long value - Unix time. This part is missing. > As an example could serve [MySQL's UNIX_TIMESTAMP|https://dev.mysql.com/doc/refman/5.5/en/date-and-time-func...] -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4577) Upgrade CXF to 3.1.8, which resolves password obfuscation issue

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4577?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-4577: ------------------------------------- Assignee: Ramesh Reddy > Upgrade CXF to 3.1.8, which resolves password obfuscation issue > --------------------------------------------------------------- > > Key: TEIID-4577 > URL: https://issues.jboss.org/browse/TEIID-4577 > Project: Teiid > Issue Type: Sub-task > Components: Misc. Connectors > Reporter: Van Halbert > Assignee: Ramesh Reddy > Fix For: 10.0 > > > Upgrade cxf from 3.1.4 to 3.1.8. > According to comment on JBEAP-1058, CXF 3.1.8 has resolved the ability to obfuscate passwords. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4577) Upgrade CXF to 3.1.8, which resolves password obfuscation issue

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4577?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4577: ---------------------------------- Parent: TEIID-5002 Issue Type: Sub-task (was: Enhancement) > Upgrade CXF to 3.1.8, which resolves password obfuscation issue > --------------------------------------------------------------- > > Key: TEIID-4577 > URL: https://issues.jboss.org/browse/TEIID-4577 > Project: Teiid > Issue Type: Sub-task > Components: Misc. Connectors > Reporter: Van Halbert > Fix For: 10.0 > > > Upgrade cxf from 3.1.4 to 3.1.8. > According to comment on JBEAP-1058, CXF 3.1.8 has resolved the ability to obfuscate passwords. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4577) Upgrade CXF to 3.1.8, which resolves password obfuscation issue

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4577?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4577: --------------------------------------- WildFly 11 upgrades to CXF 3.1.12 > Upgrade CXF to 3.1.8, which resolves password obfuscation issue > --------------------------------------------------------------- > > Key: TEIID-4577 > URL: https://issues.jboss.org/browse/TEIID-4577 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Van Halbert > Fix For: 10.0 > > > Upgrade cxf from 3.1.4 to 3.1.8. > According to comment on JBEAP-1058, CXF 3.1.8 has resolved the ability to obfuscate passwords. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4798) Support Full CRUD operations with SFDC Bulk API

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4798?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4798: ---------------------------------- Fix Version/s: 10.x (was: 10.0) > Support Full CRUD operations with SFDC Bulk API > ----------------------------------------------- > > Key: TEIID-4798 > URL: https://issues.jboss.org/browse/TEIID-4798 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Van Halbert > Fix For: 10.x > > > Support Full CRUD support for SFDC Bulk API. > Based on other comments, the bulk update/delete are not currently enabled. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5053) Env function usage should be restricted by default

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5053?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5053. ----------------------------------- Resolution: Done Added and documented a new EmbeddedConfiguration property to control the env function. > Env function usage should be restricted by default > -------------------------------------------------- > > Key: TEIID-5053 > URL: https://issues.jboss.org/browse/TEIID-5053 > Project: Teiid > Issue Type: Quality Risk > Components: Embedded, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > > Unlike the server there is no configuration for allowing the env function with embedded. To match the server it should be disabled by default. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5054) autoFailover with a multi-batch result timing issue

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5054?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-5054: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1488940|https://bugzilla.redhat.com/show_bug.cgi?id=1488940] from NEW to MODIFIED > autoFailover with a multi-batch result timing issue > --------------------------------------------------- > > Key: TEIID-5054 > URL: https://issues.jboss.org/browse/TEIID-5054 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 10.0, 8.12.x-6.4, 9.2.6, 9.3.3 > > > With autoFailover=true there is a periodic ping before usage of the connection. This ping may be called during processing of multi-batch results such that the ping call effectively hangs. 4 minutes later (or whatever the synch timeout is) the client will attempt to failover. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4992) Add OSDQ set functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4992?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4992: --------------------------------------- It also appears that the cost of computing for large sets will be expensive since it's roughly an n^2 operation where a lot of temporary state is being created sets of all characters from each string. > Add OSDQ set functions > ---------------------- > > Key: TEIID-4992 > URL: https://issues.jboss.org/browse/TEIID-4992 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > Attachments: SetUtil.java > > > There will be a new osdq core library drop in maven central soon containing additional functions for Teiid to add. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4992) Add OSDQ set functions

by vivek singh (JIRA)

[ https://issues.jboss.org/browse/TEIID-4992?page=com.atlassian.jira.plugin... ] vivek singh commented on TEIID-4992: ------------------------------------ Thanks for pointing out. I will look into it. regards, Vivek On Thu, Sep 7, 2017 at 5:42 AM, Steven Hawkins (JIRA) <issues(a)jboss.org> -- reagrds, Vivek Author of "The Reverse Journey" from Frogbooks > Add OSDQ set functions > ---------------------- > > Key: TEIID-4992 > URL: https://issues.jboss.org/browse/TEIID-4992 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > Attachments: SetUtil.java > > > There will be a new osdq core library drop in maven central soon containing additional functions for Teiid to add. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5055) Mark more functions using the TeiidFunction annotation as pushdown eligilble

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5055: ------------------------------------- Summary: Mark more functions using the TeiidFunction annotation as pushdown eligilble Key: TEIID-5055 URL: https://issues.jboss.org/browse/TEIID-5055 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 10.0 Functions added using the TeiidFunction annotation, such as for TEIID-4532, were not marked as pushdown eligible, even though they could be. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2017