March 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3324) Boolean fields with null are evaluated to false

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3324?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3324. --------------------------------- Resolution: Done > Boolean fields with null are evaluated to false > ----------------------------------------------- > > Key: TEIID-3324 > URL: https://issues.jboss.org/browse/TEIID-3324 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 7.1 > Reporter: Salvatore R > Assignee: Steven Hawkins > Fix For: 6.2-8.7.2, 8.10 > > > I have a source table defined as follows (e.g. in PostgreSQL): > {code:sql} > CREATE TABLE public.test > ( > id integer, > iscustomer boolean > ) > {code} > and the table contains these rows: > {code:sql} > insert into public.test values(1, null); > insert into public.test values(2, true); > insert into public.test values(3, false); > {code} > > When I try to get data from this table in Teiid, the "null" value is evaluated as false: > ||id||iscustomer|| > |1|false| > |2|true| > |3|false| -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3399) Greenplum is not in the translator list

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3399?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3399: ---------------------------------- Fix Version/s: 6.2-8.7.2 > Greenplum is not in the translator list > --------------------------------------- > > Key: TEIID-3399 > URL: https://issues.jboss.org/browse/TEIID-3399 > Project: Teiid > Issue Type: Quality Risk > Components: Server > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 6.2-8.7.2, 8.11 > > > Greenplum is not in the standalone xml. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3113) Incorrect parent name for child to parent query

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3113?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3113. --------------------------------- Resolution: Done > Incorrect parent name for child to parent query > ----------------------------------------------- > > Key: TEIID-3113 > URL: https://issues.jboss.org/browse/TEIID-3113 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 6.2-8.7.2, 8.9 > > > The parent relationship is named based upon the foreign key column which typically is [Some Object]Id, but can be ParentId, etc. which need for example Parent rather than the object name in the source query. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3128) Issue while querying Salesforce.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3128?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-3128: ----------------------------------- > Issue while querying Salesforce. > --------------------------------- > > Key: TEIID-3128 > URL: https://issues.jboss.org/browse/TEIID-3128 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.4 > Reporter: Pranav K > Assignee: Steven Hawkins > Fix For: 8.9 > > > (I am using Teiid Embedded 8.8.0.Final) > Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796 > Steps to reproduce at my end: > 1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account. > 2) Execute the queries as shown in the steps below > 3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR) > -Changing the order of the From part makes it run fine -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3128) Issue while querying Salesforce.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3128?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3128: ---------------------------------- Fix Version/s: 6.2-8.7.2 > Issue while querying Salesforce. > --------------------------------- > > Key: TEIID-3128 > URL: https://issues.jboss.org/browse/TEIID-3128 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.4 > Reporter: Pranav K > Assignee: Steven Hawkins > Fix For: 8.9, 6.2-8.7.2 > > > (I am using Teiid Embedded 8.8.0.Final) > Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796 > Steps to reproduce at my end: > 1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account. > 2) Execute the queries as shown in the steps below > 3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR) > -Changing the order of the From part makes it run fine -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3128) Issue while querying Salesforce.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3128?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3128. --------------------------------- Resolution: Done > Issue while querying Salesforce. > --------------------------------- > > Key: TEIID-3128 > URL: https://issues.jboss.org/browse/TEIID-3128 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.4 > Reporter: Pranav K > Assignee: Steven Hawkins > Fix For: 6.2-8.7.2, 8.9 > > > (I am using Teiid Embedded 8.8.0.Final) > Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796 > Steps to reproduce at my end: > 1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account. > 2) Execute the queries as shown in the steps below > 3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR) > -Changing the order of the From part makes it run fine -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3112) Incorrect plural name with parent to child join

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3112?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3112: ---------------------------------- Fix Version/s: 6.2-8.7.2 > Incorrect plural name with parent to child join > ----------------------------------------------- > > Key: TEIID-3112 > URL: https://issues.jboss.org/browse/TEIID-3112 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9, 6.2-8.7.2 > > > The salesforce logic assumes the plural name can be created with just an 's' at the end, however objects such as Opportunity do not follow that pattern. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3112) Incorrect plural name with parent to child join

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3112?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3112. --------------------------------- Resolution: Done > Incorrect plural name with parent to child join > ----------------------------------------------- > > Key: TEIID-3112 > URL: https://issues.jboss.org/browse/TEIID-3112 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 6.2-8.7.2, 8.9 > > > The salesforce logic assumes the plural name can be created with just an 's' at the end, however objects such as Opportunity do not follow that pattern. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3113) Incorrect parent name for child to parent query

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3113?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-3113: ----------------------------------- > Incorrect parent name for child to parent query > ----------------------------------------------- > > Key: TEIID-3113 > URL: https://issues.jboss.org/browse/TEIID-3113 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > The parent relationship is named based upon the foreign key column which typically is [Some Object]Id, but can be ParentId, etc. which need for example Parent rather than the object name in the source query. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3113) Incorrect parent name for child to parent query

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3113?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3113: ---------------------------------- Fix Version/s: 6.2-8.7.2 > Incorrect parent name for child to parent query > ----------------------------------------------- > > Key: TEIID-3113 > URL: https://issues.jboss.org/browse/TEIID-3113 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9, 6.2-8.7.2 > > > The parent relationship is named based upon the foreign key column which typically is [Some Object]Id, but can be ParentId, etc. which need for example Parent rather than the object name in the source query. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 11 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2015