August 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4247) OData - support date and time functions

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4247?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4247: --------------------------------- Fix Version/s: 8.12.6.6_3 > OData - support date and time functions > --------------------------------------- > > Key: TEIID-4247 > URL: https://issues.jboss.org/browse/TEIID-4247 > Project: Teiid > Issue Type: Feature Request > Components: OData > Affects Versions: 8.12.x > Reporter: Andrej Šmigala > Assignee: Ramesh Reddy > Fix For: 9.1, 8.12.6.6_3 > > > The functions date() and time() are currently not supported in odata queries, e.g. running query {noformat}http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable?$filter=timeval%20gt%20time(now()){noformat} > returns {code:xml} > <?xml version='1.0' encoding='UTF-8'?> > <error xmlns="http://docs.oasis-open.org/odata/ns/metadata"> > <code>TEIID16027</code> > <message>TEIID16027 Function time is not currently supported </message> > </error> > {code} > This is allowed behaviour per the [odata spec|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/par...], but it would be good to have these functions implemented. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4271) Consume Teiid OData from Salesforce

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4271?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4271: --------------------------------- Fix Version/s: 8.12.6.6_3 > Consume Teiid OData from Salesforce > ----------------------------------- > > Key: TEIID-4271 > URL: https://issues.jboss.org/browse/TEIID-4271 > Project: Teiid > Issue Type: Feature Request > Components: OData > Reporter: Steven Hawkins > Assignee: Johnathon Lee > Fix For: 8.12.x, 8.12.6.6_3 > > > At least when consuming OData 2, Salesforce does not support Collection(Int16|Int32|String). Since we expose our system metadata, including pg metadata, in the OData metadata, this means that Salesforce won't consume. If the pg metadata is disabled and there are not primitive array columns in the rest of the metadata, then Salesforce can consume. > Since this is working around a Salesforce issue, we shouldn't introduce too intrusive of a mechanism for this. And in general we may need to use extension metadata to allow users to exclude objects in a more granular way from being exposed in OData metadata. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4358) JDG: Retain supported dependencies in the module.xml for out-of-the-box usage

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4358?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4358: --------------------------------- Fix Version/s: 8.12.6.6_3 > JDG: Retain supported dependencies in the module.xml for out-of-the-box usage > ----------------------------------------------------------------------------- > > Key: TEIID-4358 > URL: https://issues.jboss.org/browse/TEIID-4358 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 9.1 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.1, 8.12.6.6_3 > > > In the JDG translator/connector, retain the dependencies to prior versions so that they can be integrated out-of-the-box. > The dependencies are marked as optional, so there should be no impact until a corresponding JDG version is installed. > Include the following prior versions: > slot="jdg-6.5" > slot="jdg-6.6" -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4329) Using JDG annotations, unable to provide package name qualification for serialization

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4329?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4329: --------------------------------- Fix Version/s: 8.12.6.6_3 > Using JDG annotations, unable to provide package name qualification for serialization > ------------------------------------------------------------------------------------- > > Key: TEIID-4329 > URL: https://issues.jboss.org/browse/TEIID-4329 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.x, 8.12.5 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.1, 8.12.6.6_3 > > > When using the JDG annotations as the means of configuring the cache and serialization, its not specifying the package name qualifier. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4325) ASSERTION FAILED: expected reference to be not null

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4325?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4325: --------------------------------- Fix Version/s: 8.12.6.6_3 > ASSERTION FAILED: expected reference to be not null > --------------------------------------------------- > > Key: TEIID-4325 > URL: https://issues.jboss.org/browse/TEIID-4325 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Reporter: Mark Tawk > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.2, 8.12.6.6_3 > > Attachments: show_plan_debug.txt > > > I'm using teiid 9.0.0 over h2 : > > I'm getting ASSERTION_FAILED over the following query and can not find what is causing this exception: > > select "Sheet1"."AvgAmoutRange" as "Sheet1_EBt_211215_AvgAmoutRa1",COUNT( distinct IFNULL("CEGlobalView"."Customer_CustomerID",-2147483648)) as "CEGlobalView_Customer_Custom2","CEGlobalView"."Customer_GenderID" as "CEGlobalView_Customer_Gender1","Gender"."Gender" as "Gender_Gender","Sheet1"."Sheet1_EBt_211215ID" as "Sheet1_EBt_211215_Sheet1_EBt11" from "CEBanksBusinessModel"."CEGlobalView" "CEGlobalView" LEFT JOIN "h2dbimplify_data_cebankModel_ST"."implify_data_cebank"."Sheet1_EBt_211215" "Sheet1" ON ( ("CEGlobalView"."StreamCardsvt3r_StreamCards_1" BETWEEN "Sheet1"."Min" and "Sheet1"."Max") ) > LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."Gender" "Gender" ON "CEGlobalView"."Customer_GenderID" = "Gender"."GenderID" > LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."CustomerTag" "CustomerTag" ON "CEGlobalView"."Customer_CustomerID" = "CustomerTag"."Customer_CustomerID" AND ( ( ("CustomerTag"."EndDateTime" > CURDATE()) OR ( ("CustomerTag"."EndDateTime" IS null ) ) ) ) > LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagValue" "TagValue" ON "CustomerTag"."TagValue_TagValueID" = "TagValue"."TagValueID" > LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagName" "TagName" ON "TagValue"."TagName_TagNameID" = "TagName"."TagNameID" AND ( ( ("TagName"."TagType_TagTypeID" IN (1.0) ) ) AND ( ("TagName"."TagScope_TagScopeID" IN (1.0) ) ) ) > where ( ( ( ("TagName"."TagName" IN ('Behavior') ) ) ) AND ( ("Sheet1"."AvgAmoutRange" IS NOT null ) ) AND ( ("CEGlobalView"."Customer_GenderID" IS NOT null ) ) AND ( ("Gender"."Gender" IS NOT null ) ) ) group by "Sheet1"."AvgAmoutRange","CEGlobalView"."Customer_GenderID","Gender"."Gender","Sheet1"."Sheet1_EBt_211215ID" order by "Sheet1"."Sheet1_EBt_211215ID" ASC,"Sheet1"."AvgAmoutRange" ASC,"Gender"."Gender" DESC,"CEGlobalView"."Customer_GenderID" DESC > > The exception stack: > > ERROR TEIID_DQP_LOGGER:90 (http-bio-8080-exec-14) - - [TEIID30019 Unexpected exception for request rBDBCRYcUyyM.0] > java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null > at org.teiid.core.util.Assertion.failed(Assertion.java:73) > at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) > at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) > at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:367) > at org.teiid.query.processor.relational.JoinNode.initialize(JoinNode.java:133) > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:96) > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) > at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:91) > at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226) > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138) > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) > at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:313) > at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:245) > at sun.reflect.GeneratedMethodAccessor423.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:177) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) > at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:175) > at com.sun.proxy.$Proxy34.executeRequest(Unknown Source) > at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:673) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:539) > at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:1060) > at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:323) > you find attached the show plan debug -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4299) Object translator null values correctly

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4299?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4299: --------------------------------- Fix Version/s: 8.12.6.6_3 > Object translator null values correctly > --------------------------------------- > > Key: TEIID-4299 > URL: https://issues.jboss.org/browse/TEIID-4299 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.x, 8.12.5 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Critical > Fix For: 9.1, 8.12.6.6_3 > > > The object translator wasn't handling the setting of null values when its tried to be set on a native attribute (i.e., long, int, boolean). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4291) Object translator does not take into account folders where determining table name

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4291?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4291: --------------------------------- Fix Version/s: 8.12.6.6_3 > Object translator does not take into account folders where determining table name > --------------------------------------------------------------------------------- > > Key: TEIID-4291 > URL: https://issues.jboss.org/browse/TEIID-4291 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.x, 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.1, 8.12.6.6_3 > > > When obtaining the table name and using it to match the registered class (configured in RA), the logic doesn't take into account when folders are used. The name is returned like: folder[.folder].tableName > Nee to change logic to strip folder(s) to get the tableName. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4288) Cancel method against a socket based jdbc query can wait for synch timeout

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4288?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4288: --------------------------------- Fix Version/s: 8.12.6.6_3 > Cancel method against a socket based jdbc query can wait for synch timeout > -------------------------------------------------------------------------- > > Key: TEIID-4288 > URL: https://issues.jboss.org/browse/TEIID-4288 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.1, 8.12.6.6_3 > > > If a JDBC socket query is cancelled using a separate thread, the cancel call may wait until the timeout due to being synchronized which prevents the main execution thread from processing it's response. > Details were also added to TEIID-3781 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4397) Allow $it to be used in expand

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4397: ------------------------------------- Summary: Allow $it to be used in expand Key: TEIID-4397 URL: https://issues.jboss.org/browse/TEIID-4397 Project: Teiid Issue Type: Sub-task Components: OData Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 It should be possible to use $it in expand for correlated references. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4396) Missing images in the Admin section of the documentation

by Patrick McElreavy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4396?page=com.atlassian.jira.plugin... ] Patrick McElreavy commented on TEIID-4396: ------------------------------------------ GitHub issue: https://github.com/teiid/teiid-documents/issues/65 > Missing images in the Admin section of the documentation > -------------------------------------------------------- > > Key: TEIID-4396 > URL: https://issues.jboss.org/browse/TEIID-4396 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 9.0.2 > Reporter: Patrick McElreavy > Assignee: Steven Hawkins > Priority: Minor > > Section "Profile View" links to image "images/author/download/attachments/18646076/webconsole2.png" > Section "Runtime View" links to image "images/author/download/attachments/18646076/webconsole1.png" > Both these images are missing. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 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 August 2016