April 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5296) With MongoDB, timestamp operations throw exceptions when called on null or missing values

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5296?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5296: --------------------------------------- greater than null, and ifNull false also seem to work across supported versions so I'll update this to ifNull false. > With MongoDB, timestamp operations throw exceptions when called on null or missing values > ----------------------------------------------------------------------------------------- > > Key: TEIID-5296 > URL: https://issues.jboss.org/browse/TEIID-5296 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.11.6_4 > Reporter: Jan Martiska > Assignee: Steven Hawkins > Fix For: 10.3, 10.1.3, 10.0.5, 10.2.1 > > > When a query contains timestamp operations like {{DAYOFMONTH}}, {{DAYOFWEEK}},.. and these are executed when some cells contain null (or missing field), MongoDB throws an exception. This exception is not handled by Teiid in any way and will fail the whole VDB query: > {noformat} > Remote com.mongodb.CommandFailureException: > { "serverUsed" : "localhost:27017" , > "ok" : 0.0 , "errmsg" : "can't convert from BSON type null to Date" , > "code" : 16006 , " > codeName" : "Location16006"} > {noformat} > Perhaps Teiid could work around this somehow so that the VDB query will not fail and affected cells will contain null in the result? > For example, this Mongo aggregation pipeline which extracts hours from timestamps: > {noformat} > db.collection.aggregate([ > { > $project : { > hour: {$hour: "$DATEVALUE"} > } > } > ]) > {noformat} > could be transformed to this: > {noformat} > db.collection.aggregate([ > { > $project : { > hour: { $cond: > [ { $or: [ > { $eq: [ "$DATEVALUE", null ] }, > { $eq: [ { $type: "$DATEVALUE" }, "missing" ] } > ] > }, > null, > { $hour: "$DATEVALUE" } > ] > } > } > } > ]) > {noformat} > after this transformation, the {{hour}} field will be null as expected for documents where {{DATEVALUE}} is null or missing completely -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5328) regression of org.teiid.padSpace does not affect to the "IN" operator behavior

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5328?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5328: ---------------------------------- Description: There is a regression from TEIID-4129 reintroducing issue TEIID-3685. (was: There is a regression reintroducing issue TEIID-3685.) > regression of org.teiid.padSpace does not affect to the "IN" operator behavior > ------------------------------------------------------------------------------ > > Key: TEIID-5328 > URL: https://issues.jboss.org/browse/TEIID-5328 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.12.6_4 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > > There is a regression from TEIID-4129 reintroducing issue TEIID-3685. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5328) regression of org.teiid.padSpace does not affect to the "IN" operator behavior

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5328?page=com.atlassian.jira.plugin... ] Work on TEIID-5328 started by Steven Hawkins. --------------------------------------------- > regression of org.teiid.padSpace does not affect to the "IN" operator behavior > ------------------------------------------------------------------------------ > > Key: TEIID-5328 > URL: https://issues.jboss.org/browse/TEIID-5328 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.12.6_4 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > > There is a regression reintroducing issue TEIID-3685. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5210) GitBook integration is broken

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5210?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5210: --------------------------------------- May have spoken too soon. I'd like to still have the different versions on different branches, but that doesn't seem to be workable when creating an orphan branch as the content of the other publishing will disappear. > GitBook integration is broken > ----------------------------- > > Key: TEIID-5210 > URL: https://issues.jboss.org/browse/TEIID-5210 > Project: Teiid > Issue Type: Bug > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 10.3 > > > GitBooks are no longer syncing to our github. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5328) regression of org.teiid.padSpace does not affect to the "IN" operator behavior

by Johnathon Lee (JIRA)

Johnathon Lee created TEIID-5328: ------------------------------------ Summary: regression of org.teiid.padSpace does not affect to the "IN" operator behavior Key: TEIID-5328 URL: https://issues.jboss.org/browse/TEIID-5328 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.12.12.6_4 Reporter: Johnathon Lee Assignee: Steven Hawkins There is a regression reintroducing issue TEIID-3685. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5210) GitBook integration is broken

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5210?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5210: --------------------------------------- Yes their comments ended up being a one off. I'll start by converting over 10.x for now and updating the community site. > GitBook integration is broken > ----------------------------- > > Key: TEIID-5210 > URL: https://issues.jboss.org/browse/TEIID-5210 > Project: Teiid > Issue Type: Bug > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 10.3 > > > GitBooks are no longer syncing to our github. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5210) GitBook integration is broken

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5210?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-5210: ------------------------------------- That looks good (y) I don't like comments on documents anyway. > GitBook integration is broken > ----------------------------- > > Key: TEIID-5210 > URL: https://issues.jboss.org/browse/TEIID-5210 > Project: Teiid > Issue Type: Bug > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 10.3 > > > GitBooks are no longer syncing to our github. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5327) Add support to push timestampadd to oracle

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5327?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5327: --------------------------------------- see interval types supported https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements001.htm > Add support to push timestampadd to oracle > ------------------------------------------ > > Key: TEIID-5327 > URL: https://issues.jboss.org/browse/TEIID-5327 > Project: Teiid > Issue Type: Enhancement > Components: Server > Affects Versions: 8.12.12.6_4 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 10.3 > > > Add pushdown support for timestampadd function to Oracle. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5327) Add support to push timestampadd to oracle

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5327?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5327: ---------------------------------- Fix Version/s: 10.3 > Add support to push timestampadd to oracle > ------------------------------------------ > > Key: TEIID-5327 > URL: https://issues.jboss.org/browse/TEIID-5327 > Project: Teiid > Issue Type: Enhancement > Components: Server > Affects Versions: 8.12.12.6_4 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 10.3 > > > Add pushdown support for timestampadd function to Oracle. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5324) MongoDB: SecurityType "None" is not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5324?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5324: ---------------------------------- Fix Version/s: 10.2.2 10.1.4 > MongoDB: SecurityType "None" is not working > ------------------------------------------- > > Key: TEIID-5324 > URL: https://issues.jboss.org/browse/TEIID-5324 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 10.3, 10.1.4, 10.2.2 > > > MongoDB resource adapter with "None" security type is not recognized, and ends with error. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2018