July 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5425) Concurrency/timing issues observed with travis builds

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5425: ------------------------------------- Summary: Concurrency/timing issues observed with travis builds Key: TEIID-5425 URL: https://issues.jboss.org/browse/TEIID-5425 Project: Teiid Issue Type: Bug Components: Build/Kits Reporter: Steven Hawkins Assignee: Steven Hawkins Several unit tests have been observed to fail during travis builds occasionally: TestODBCSocketTransport.testRegClass:757 Â» PSQL ResultSet not positioned prope... and TestExternalMatViews.testLazyUpdate:930 expected:<2> but was:<1> (see https://api.travis-ci.org/v3/job/405801976/log.txt) -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5424) timestampadd/diff with quarter should not use 91 days

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5424?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5424. ----------------------------------- Resolution: Done Changed quarter to use 3 months instead. > timestampadd/diff with quarter should not use 91 days > ----------------------------------------------------- > > Key: TEIID-5424 > URL: https://issues.jboss.org/browse/TEIID-5424 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.1, 11.0.1, 10.3.3 > > > Teiid 8.2 and prior used interval approximations including 91 days for a quarter - which is still reflected in the jdbc translator. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5415) Simplify connection handling

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5415?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5415. ----------------------------------- Fix Version/s: 11.1 (was: 11.x) Resolution: Done Updated the docs to remove any post connection load balancing and added references to haproxy. > Simplify connection handling > ---------------------------- > > Key: TEIID-5415 > URL: https://issues.jboss.org/browse/TEIID-5415 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Driver > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.1 > > > With the removal of TEIID-5411 we can further simplify our notion of connection handling. The current logic maintains a set of logins for known server instances under one logical connection. When a connection is returned to an XA pool (or the client issues special sql) the logical connection will select a new instance using a cached login if possible. > The benefits of the current approach are: > * works just from the hosts listed in the url > * works with XA connection pooling or connection pooling in general with additional setup to provide simple load balancing > The drawbacks are: > * creates a set of logins which may mostly sit idle > * is not load balancer aware - for example when just a load balanced end point is used. And the load balancing is just random, not intelligent. > * requires the client to keep a pool of physical connections > A proposal would be to keep multiple url failover, but removal all of the logic related to maintaining multiple logins under a logical connection. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5363) SimpleDB connector not quoting table names in internal Select queries

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5363?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5363: --------------------------------------- The query being issued is of the form: SELECT `col` ... FROM `some-name` correct? > SimpleDB connector not quoting table names in internal Select queries > --------------------------------------------------------------------- > > Key: TEIID-5363 > URL: https://issues.jboss.org/browse/TEIID-5363 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Pranav K > Assignee: Steven Hawkins > Fix For: 11.0, 10.3.2 > > > Facing an issue while querying the Simple DB connector for a specific type of tables - the tables that contain a hyphen in the name. > According to the SimpleDB documentation: > Attribute and domain names may appear without quotes if they contain only letters, numbers, underscores (_), or dollar symbols ($) and do not start with a number. You must quote all other attribute and domain names with the backtick (`). > (https://docs.aws.amazon.com/AmazonSimpleDB/latest/DeveloperGuide/QuotingR...) -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5424) timestampadd/diff with quarter should not use 91 days

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5424: ------------------------------------- Summary: timestampadd/diff with quarter should not use 91 days Key: TEIID-5424 URL: https://issues.jboss.org/browse/TEIID-5424 Project: Teiid Issue Type: Bug Components: JDBC Connector Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 11.1, 11.0.1, 10.3.3 Teiid 8.2 and prior used interval approximations including 91 days for a quarter - which is still reflected in the jdbc translator. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5419) timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5419?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5419. ----------------------------------- Resolution: Done > timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327 > -------------------------------------------------------------------- > > Key: TEIID-5419 > URL: https://issues.jboss.org/browse/TEIID-5419 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.3 > Environment: WFLYSRV0049: WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: Ivan Semenov > Assignee: Steven Hawkins > Fix For: 11.1, 11.0.1, 10.3.3 > > > After adding support for timestampadd() pushdown to Oracle in TEIID-5327 - Oracle is throwing errors for some pushed queries -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5419) timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5419?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5419: --------------------------------------- > I'm not sure if this is completely resolved That's due to the logic being adapted from the existing modifier used with h2/hsql - which was developed much earlier when Teiid used interval approximations. See https://docs.jboss.org/author/display/teiid830final/Date_Time+Functions That does need updated, but I'll do that under a separate issue. > timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327 > -------------------------------------------------------------------- > > Key: TEIID-5419 > URL: https://issues.jboss.org/browse/TEIID-5419 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.3 > Environment: WFLYSRV0049: WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: Ivan Semenov > Assignee: Steven Hawkins > Fix For: 11.1, 11.0.1, 10.3.3 > > > After adding support for timestampadd() pushdown to Oracle in TEIID-5327 - Oracle is throwing errors for some pushed queries -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5419) timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327

by Ivan Semenov (JIRA)

[ https://issues.jboss.org/browse/TEIID-5419?page=com.atlassian.jira.plugin... ] Ivan Semenov edited comment on TEIID-5419 at 7/19/18 8:15 AM: -------------------------------------------------------------- I'm not sure if this is completely resolved {code:sql} select hire_date, timestampadd(SQL_TSI_QUARTER, 2, hire_date) from HR.employees where employee_id = 100 {code} hire_date here is "2003-06-*17* 00:00:00.0" while timestampadd(SQL_TSI_QUARTER, 2, hire_date) renders "2003-12-*16* 00:00:00.0" i.e. 1 day less than 6 months' difference was (Author: isemenov): I'm not sure this is completely resolved {code:sql} select hire_date, timestampadd(SQL_TSI_QUARTER, 2, hire_date) from HR.employees where employee_id = 100 {code} hire_date here is "2003-06-*17* 00:00:00.0" while timestampadd(SQL_TSI_QUARTER, 2, hire_date) renders "2003-12-*16* 00:00:00.0" i.e. 1 day less than 6 months difference > timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327 > -------------------------------------------------------------------- > > Key: TEIID-5419 > URL: https://issues.jboss.org/browse/TEIID-5419 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.3 > Environment: WFLYSRV0049: WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: Ivan Semenov > Assignee: Steven Hawkins > Fix For: 11.1, 11.0.1, 10.3.3 > > > After adding support for timestampadd() pushdown to Oracle in TEIID-5327 - Oracle is throwing errors for some pushed queries -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5419) timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327

by Ivan Semenov (JIRA)

[ https://issues.jboss.org/browse/TEIID-5419?page=com.atlassian.jira.plugin... ] Ivan Semenov reopened TEIID-5419: --------------------------------- I'm not sure this is completely resolved {code:sql} select hire_date, timestampadd(SQL_TSI_QUARTER, 2, hire_date) from HR.employees where employee_id = 100 {code} hire_date here is "2003-06-*17* 00:00:00.0" while timestampadd(SQL_TSI_QUARTER, 2, hire_date) renders "2003-12-*16* 00:00:00.0" i.e. 1 day less than 6 months difference > timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327 > -------------------------------------------------------------------- > > Key: TEIID-5419 > URL: https://issues.jboss.org/browse/TEIID-5419 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.3 > Environment: WFLYSRV0049: WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: Ivan Semenov > Assignee: Steven Hawkins > Fix For: 11.1, 11.0.1, 10.3.3 > > > After adding support for timestampadd() pushdown to Oracle in TEIID-5327 - Oracle is throwing errors for some pushed queries -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5417) Performance degradation with large in predicate against temp table

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5417?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-5417: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1602809 Bugzilla Update: Perform > Performance degradation with large in predicate against temp table > ------------------------------------------------------------------ > > Key: TEIID-5417 > URL: https://issues.jboss.org/browse/TEIID-5417 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.1, 11.0.1, 10.3.3 > > > Dependent joins producing a large in predicate will do a linear search over the predicate. The predicate should be marked as all constants and dealt with as a set instead. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 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 July 2018