July 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3592) REST war returns source column names instead of the virtual table column names

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIID-3592?page=com.atlassian.jira.plugin... ] Ted Jones reassigned TEIID-3592: -------------------------------- Assignee: Steven Hawkins (was: Ted Jones) > REST war returns source column names instead of the virtual table column names > ------------------------------------------------------------------------------ > > Key: TEIID-3592 > URL: https://issues.jboss.org/browse/TEIID-3592 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1 > Reporter: Marc Shirley > Assignee: Steven Hawkins > > When querying a REST procedure built off of a virtual table, it returns the physical source column name instead of the virtual table column name. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3592) REST war returns source column names instead of the virtual table column names

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIID-3592?page=com.atlassian.jira.plugin... ] Ted Jones moved TEIIDDES-2567 to TEIID-3592: -------------------------------------------- Project: Teiid (was: Teiid Designer) Key: TEIID-3592 (was: TEIIDDES-2567) Affects Version/s: 8.7.1 (was: 9.0.1) Component/s: Query Engine (was: Web Services Support) Fix Version/s: (was: 9.2) (was: 9.0.3) > REST war returns source column names instead of the virtual table column names > ------------------------------------------------------------------------------ > > Key: TEIID-3592 > URL: https://issues.jboss.org/browse/TEIID-3592 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1 > Reporter: Marc Shirley > Assignee: Ted Jones > > When querying a REST procedure built off of a virtual table, it returns the physical source column name instead of the virtual table column name. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3573) Infinispan-dsl-cache translator: Operator <> incorrectly handles NULL values

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3573?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3573: --------------------------------------- > I'm thinking, as a workaround for now, turn off support of IS NULL and ISNOTNULL in the translator and let Teiid handle it. Sounds fine. So then until that bug and/or three value logic is addressed, then user query containing something like intnum<>1 could still return invalid results. That implies we may need to turn negation support entirely for now. > Infinispan-dsl-cache translator: Operator <> incorrectly handles NULL values > ---------------------------------------------------------------------------- > > Key: TEIID-3573 > URL: https://issues.jboss.org/browse/TEIID-3573 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Filip Elias > Assignee: Van Halbert > > Operator '<>' returns true for NULL <> 1 > Example: > {code} > select intKey,intNum from smallA where intNum<>1 > {code} > It returns also rows which have NULL in column intNum > I believe that NULL <> 1 is not true in SQL. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3573) Infinispan-dsl-cache translator: Operator <> incorrectly handles NULL values

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3573?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3573: ------------------------------------ Unfortunately, this maybe harder to fix, as I've logged a bug with JDG (https://bugzilla.redhat.com/show_bug.cgi?id=1247191) regarding an issue with using IS NULL and IS NOT NULL with numeric columns. So adding IS NOT NULL when intNum <> 1 is specified will not work at this time. I'm thinking, as a workaround for now, turn off support of IS NULL and ISNOTNULL in the translator and let Teiid handle it. So that its consistent across all data types. Otherwise, mix-and-matching support for IS NULL and IS NOT NULL will be confusing. > Infinispan-dsl-cache translator: Operator <> incorrectly handles NULL values > ---------------------------------------------------------------------------- > > Key: TEIID-3573 > URL: https://issues.jboss.org/browse/TEIID-3573 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Filip Elias > Assignee: Van Halbert > > Operator '<>' returns true for NULL <> 1 > Example: > {code} > select intKey,intNum from smallA where intNum<>1 > {code} > It returns also rows which have NULL in column intNum > I believe that NULL <> 1 is not true in SQL. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3544) teiid-odata-*.war not deploying in EAP when using domain

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3544?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3544: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1233001|https://bugzilla.redhat.com/show_bug.cgi?id=1233001] from ASSIGNED to MODIFIED > teiid-odata-*.war not deploying in EAP when using domain > -------------------------------------------------------- > > Key: TEIID-3544 > URL: https://issues.jboss.org/browse/TEIID-3544 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7.1.6_2 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 8.7.1.6_2 > > > The Teiid odata war, located: > modules/system/layers/dv/org/jboss/teiid/main/deployments/teiid-odata-8.7.1.6_2-redhat-2.war > was not being deployed. It's working in standalone. > The workaround in domain mode is to re-deploy the war using the admin console. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3591) Report user query CPU time

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3591?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3591: ---------------------------------- Fix Version/s: 8.12 > Report user query CPU time > -------------------------- > > Key: TEIID-3591 > URL: https://issues.jboss.org/browse/TEIID-3591 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Fix For: 8.12 > > > Just like TEIID-2813 it would useful to be useful to report CPU time for user query overall. This can help determine load on CPU got given user query vs wait time. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3577) Add cli script to configure audit and command logging

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3577?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3577: ------------------------------------------------ Thomas Hauser <thauser(a)redhat.com> changed the Status of [bug 1240673|https://bugzilla.redhat.com/show_bug.cgi?id=1240673] from NEW to ASSIGNED > Add cli script to configure audit and command logging > ----------------------------------------------------- > > Key: TEIID-3577 > URL: https://issues.jboss.org/browse/TEIID-3577 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Affects Versions: 8.7.1.6_2 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7.1.6_2, 8.12 > > > Need a cli script to configure the audit and command logging, that include the async-handlers for performance improvements. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3591) Report user query CPU time

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-3591: ----------------------------------- Summary: Report user query CPU time Key: TEIID-3591 URL: https://issues.jboss.org/browse/TEIID-3591 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Ramesh Reddy Assignee: Steven Hawkins Just like TEIID-2813 it would useful to be useful to report CPU time for user query overall. This can help determine load on CPU got given user query vs wait time. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2813) Report translator CPU time

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2813?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2813: --------------------------------------- > If DB logging is ASYNC it hopefully is negligible to account or remove from calculations. I don't mean in the calculation, I mean it would need another column. > Do you want me to add another request for User queries? IMO, we can ignore the serial execution part or noted as such any docs. Yes, let's open another issue for that. > Report translator CPU time > -------------------------- > > Key: TEIID-2813 > URL: https://issues.jboss.org/browse/TEIID-2813 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 8.12 > > > The COMMAND_LOG ought to report the CPU time accumulated by the translator for performance tuning purposes. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2813) Report translator CPU time

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2813?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2813: ------------------------------------- If DB logging is ASYNC it hopefully is negligible to account or remove from calculations. Do you want me to add another request for User queries? IMO, we can ignore the serial execution part or noted as such any docs. > Report translator CPU time > -------------------------- > > Key: TEIID-2813 > URL: https://issues.jboss.org/browse/TEIID-2813 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 8.12 > > > The COMMAND_LOG ought to report the CPU time accumulated by the translator for performance tuning purposes. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2015