October 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4385) Nested subquery in an aggregate fails to evaluate

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4385?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4385: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1506565|https://bugzilla.redhat.com/show_bug.cgi?id=1506565] from NEW to ON_QA > Nested subquery in an aggregate fails to evaluate > ------------------------------------------------- > > Key: TEIID-4385 > URL: https://issues.jboss.org/browse/TEIID-4385 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.3, 8.12.x-6.4, 8.12.12.6_3 > > > A correlated subquery that appears in an aggregate value inside of a subquery, will not have the correlated values available and fail with a TEIID30328 exception. > For example: > SELECT g0.a, g0.b, (SELECT max((SELECT g2.a FROM m.z AS g2 WHERE g2.b = g1.a)) FROM m.y AS g1 WHERE g0.a = g1.b) FROM m.x AS g0 > will fail on the g0.a reference. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4382) array_agg does not properly handle array values

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4382?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4382: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1506564|https://bugzilla.redhat.com/show_bug.cgi?id=1506564] from NEW to ON_QA > array_agg does not properly handle array values > ----------------------------------------------- > > Key: TEIID-4382 > URL: https://issues.jboss.org/browse/TEIID-4382 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.12.x-6.4 > > > array_agg(array value) - will fail to create the expected multi-dimensional array value as the ArrayAgg logic does not properly unnest the ArrayImpl values. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5131) Create ansible playbooks for the ansible service broker

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5131?page=com.atlassian.jira.plugin... ] Work on TEIID-5131 started by Steven Hawkins. --------------------------------------------- > Create ansible playbooks for the ansible service broker > ------------------------------------------------------- > > Key: TEIID-5131 > URL: https://issues.jboss.org/browse/TEIID-5131 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.x > > > For some of the most common usage patterns, we should create playbooks that contribute service brokers via the ansible service broker. This could be: > salesforce as db > couchbase as db/odata > mongodb as db/odata > other openshift databases as odata -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5131) Create ansible playbooks for the ansible service broker

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5131?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5131: --------------------------------------- This should at least be able to bind to provisioned instances. We also need to define security expectations. > Create ansible playbooks for the ansible service broker > ------------------------------------------------------- > > Key: TEIID-5131 > URL: https://issues.jboss.org/browse/TEIID-5131 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.x > > > For some of the most common usage patterns, we should create playbooks that contribute service brokers via the ansible service broker. This could be: > salesforce as db > couchbase as db/odata > mongodb as db/odata > other openshift databases as odata -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4842) testAnonSSLConnect taking too long to complete

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4842?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4842: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1506579|https://bugzilla.redhat.com/show_bug.cgi?id=1506579] from NEW to ON_QA > testAnonSSLConnect taking too long to complete > ---------------------------------------------- > > Key: TEIID-4842 > URL: https://issues.jboss.org/browse/TEIID-4842 > Project: Teiid > Issue Type: Quality Risk > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.x-6.4 > > > The netty version for 6.4 doesn't behave the same as older or newer branches. When a non-ssl connection attempt is made against an ssl jdbc server, it will wait for all handshake attempts to expire. It should give up after the first based upon the server response. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5131) Create ansible playbooks for the ansible service broker

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5131: ------------------------------------- Summary: Create ansible playbooks for the ansible service broker Key: TEIID-5131 URL: https://issues.jboss.org/browse/TEIID-5131 Project: Teiid Issue Type: Enhancement Components: Build/Kits Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 10.x For some of the most common usage patterns, we should create playbooks that contribute service brokers via the ansible service broker. This could be: salesforce as db couchbase as db/odata mongodb as db/odata other openshift databases as odata -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4892) oData v4 error using $expand

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4892?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4892: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1506985|https://bugzilla.redhat.com/show_bug.cgi?id=1506985] from NEW to ON_QA > oData v4 error using $expand > ---------------------------- > > Key: TEIID-4892 > URL: https://issues.jboss.org/browse/TEIID-4892 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 9.1.4 > Environment: Teiid 9.1.4 with WildFly 10.0.0.Final running on Windows server 2012 R2 Datacenter Edition. > Reporter: Marco Monti > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.x-6.4, 9.1.5, 9.2.3 > > Attachments: server.log > > > Hello, > > we are querying Teiid 9.1.4 using the following oData v4 syntax: > > {{http://host:port/odata4/<vdbname>/<model-name>/<table-name>?$expand=<navigation>}} > > It doesn't matter what navigation property we choose; we always get following error message: > > {{{"error":{"code":null,"message":"String index out of range: -1"}}}} > > Please find the attached logfile. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4838) View with a union that projects nulls fails to resolve properly

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4838?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4838: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1506576|https://bugzilla.redhat.com/show_bug.cgi?id=1506576] from NEW to ON_QA > View with a union that projects nulls fails to resolve properly > --------------------------------------------------------------- > > Key: TEIID-4838 > URL: https://issues.jboss.org/browse/TEIID-4838 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.x-6.4, 9.2.4 > > > Accessing a view defined as: > create view v (col string[]) as select null union all select null > Results in an exception: > org.teiid.core.TeiidRuntimeException: TEIID30447 org.teiid.api.exception.query.QueryResolverException: TEIID30082 Expected value of type 'null' but 'null' is of type 'string[]' and no implicit conversion is available. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4876) Salesforce connector not working properly in 9.2.2 release

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4876?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4876: ------------------------------- Fix Version/s: 8.12.x-6.4 > Salesforce connector not working properly in 9.2.2 release > ---------------------------------------------------------- > > Key: TEIID-4876 > URL: https://issues.jboss.org/browse/TEIID-4876 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 9.2.2 > Environment: MacOS{{monospaced text}} > Reporter: Jeff Davis > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.x-6.4, 9.2.3 > > > The Salesforce connector does not appear to work in the 9.2.2 release (using resource adpater salesforce-34). Here's the relevant entry in the standalone-teiid.xml file: > {{<resource-adapter id="sf34"> > <module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-34"/> > <transaction-support>NoTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS" enabled="true" use-java-context="true" pool-name="teiid-sf-ds"> > <config-property name="URL"> > https://www.salesforce.com/services/Soap/u/34.0 > </config-property> > <config-property name="password"> > [[not shown]] > </config-property> > <config-property name="username"> > lightning(a)zazarie.com > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter>}} > And here is my dynamic VDB xml (SFDCVdb-vdb.xml): > {{<vdb name="SFDCVdb" version="1"> > <description/> > <property name="validationDateTime" value="Fri Apr 21 14:41:27 MDT 2017"/> > <property name="validationVersion" value="9.2.2"/> > <model name="SFSourceModel"> > <source connection-jndi-name="java:/sfDS" name="SFSourceModel" > translator-name="salesforce-34"/> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE Account ( > Id string(18) NOT NULL DEFAULT 'Generated upon creation' OPTIONS(NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:Defaulted on Create" 'TRUE'), > IsDeleted boolean OPTIONS(NAMEINSOURCE 'IsDeleted', NATIVE_TYPE 'boolean', "teiid_sf:Defaulted on Create" 'TRUE'), > MasterRecordId string(18) OPTIONS(NAMEINSOURCE 'MasterRecordId', NATIVE_TYPE 'id'), > Name string(255) OPTIONS(NAMEINSOURCE 'Name', NATIVE_TYPE 'string'), > Type string(40) OPTIONS(NAMEINSOURCE 'Type', NATIVE_TYPE 'picklist', "teiid_sf:Picklist Values" 'Prospect,Customer - Direct,Customer - Channel,Channel Partner / Reseller,Installation Partner,Technology Partner,Other'), > ParentId string(18) OPTIONS(NAMEINSOURCE 'ParentId', NATIVE_TYPE 'id'), > BillingStreet string(255) OPTIONS(NAMEINSOURCE 'BillingStreet', NATIVE_TYPE 'textarea', SEARCHABLE 'UNSEARCHABLE'), > BillingCity string(40) OPTIONS(NAMEINSOURCE 'BillingCity', NATIVE_TYPE 'string'), > BillingState string(80) OPTIONS(NAMEINSOURCE 'BillingState', NATIVE_TYPE 'string'), > BillingPostalCode string(20) OPTIONS(NAMEINSOURCE 'BillingPostalCode', NATIVE_TYPE 'string'), > BillingCountry string(80) OPTIONS(NAMEINSOURCE 'BillingCountry', NATIVE_TYPE 'string'), > ShippingStreet string(255) OPTIONS(NAMEINSOURCE 'ShippingStreet', NATIVE_TYPE 'textarea', SEARCHABLE 'UNSEARCHABLE'), > ShippingCity string(40) OPTIONS(NAMEINSOURCE 'ShippingCity', NATIVE_TYPE 'string'), > ShippingState string(80) OPTIONS(NAMEINSOURCE 'ShippingState', NATIVE_TYPE 'string'), > ShippingPostalCode string(20) OPTIONS(NAMEINSOURCE 'ShippingPostalCode', NATIVE_TYPE 'string'), > ShippingCountry string(80) OPTIONS(NAMEINSOURCE 'ShippingCountry', NATIVE_TYPE 'string'), > Phone string(40) OPTIONS(NAMEINSOURCE 'Phone', NATIVE_TYPE 'phone'), > Fax string(40) OPTIONS(NAMEINSOURCE 'Fax', NATIVE_TYPE 'phone'), > AccountNumber string(40) OPTIONS(NAMEINSOURCE 'AccountNumber', NATIVE_TYPE 'string'), > Website string(255) OPTIONS(NAMEINSOURCE 'Website', NATIVE_TYPE 'url'), > Sic string(20) OPTIONS(NAMEINSOURCE 'Sic', NATIVE_TYPE 'string'), > Industry string(40) OPTIONS(NAMEINSOURCE 'Industry', NATIVE_TYPE 'picklist', "teiid_sf:Picklist Values" 'Agriculture,Apparel,Banking,Biotechnology,Chemicals,Communications,Construction,Consulting,Education,Electronics,Energy,Engineering,Entertainment,Environmental,Finance,Food & Beverage,Government,Healthcare,Hospitality,Insurance,Machinery,Manufacturing,Media,Not For Profit,Recreation,Retail,Shipping,Technology,Telecommunications,Transportation,Utilities,Other'), > AnnualRevenue double OPTIONS(NAMEINSOURCE 'AnnualRevenue', NATIVE_TYPE 'currency', CURRENCY 'TRUE'), > NumberOfEmployees integer OPTIONS(NAMEINSOURCE 'NumberOfEmployees', NATIVE_TYPE 'int'), > Ownership string(40) OPTIONS(NAMEINSOURCE 'Ownership', NATIVE_TYPE 'picklist', "teiid_sf:Picklist Values" 'Public,Private,Subsidiary,Other'), > TickerSymbol string(20) OPTIONS(NAMEINSOURCE 'TickerSymbol', NATIVE_TYPE 'string'), > Description string(32000) OPTIONS(NAMEINSOURCE 'Description', NATIVE_TYPE 'textarea', SEARCHABLE 'UNSEARCHABLE'), > Rating string(40) OPTIONS(NAMEINSOURCE 'Rating', NATIVE_TYPE 'picklist', "teiid_sf:Picklist Values" 'Hot,Warm,Cold'), > Site string(80) OPTIONS(NAMEINSOURCE 'Site', NATIVE_TYPE 'string'), > OwnerId string(18) OPTIONS(NAMEINSOURCE 'OwnerId', NATIVE_TYPE 'id', "teiid_sf:Defaulted on Create" 'TRUE'), > LastActivityDate date OPTIONS(NAMEINSOURCE 'LastActivityDate', NATIVE_TYPE 'date'), > Jigsaw string(20) OPTIONS(NAMEINSOURCE 'Jigsaw', NATIVE_TYPE 'string'), > pnccanvaspck__CustomerPriority__c string(255) OPTIONS(NAMEINSOURCE 'pnccanvaspck__CustomerPriority__c', NATIVE_TYPE 'picklist', "teiid_sf:Picklist Values" 'High,Low,Medium', "teiid_sf:Custom" 'TRUE'), > pnccanvaspck__SLA__c string(255) OPTIONS(NAMEINSOURCE 'pnccanvaspck__SLA__c', NATIVE_TYPE 'picklist', "teiid_sf:Picklist Values" 'Gold,Silver,Platinum,Bronze', "teiid_sf:Custom" 'TRUE'), > pnccanvaspck__Active__c string(255) OPTIONS(NAMEINSOURCE 'pnccanvaspck__Active__c', NATIVE_TYPE 'picklist', "teiid_sf:Picklist Values" 'No,Yes', "teiid_sf:Custom" 'TRUE'), > pnccanvaspck__NumberofLocations__c double OPTIONS(NAMEINSOURCE 'pnccanvaspck__NumberofLocations__c', NATIVE_TYPE 'double', "teiid_sf:Custom" 'TRUE'), > pnccanvaspck__UpsellOpportunity__c string(255) OPTIONS(NAMEINSOURCE 'pnccanvaspck__UpsellOpportunity__c', NATIVE_TYPE 'picklist', "teiid_sf:Picklist Values" 'Maybe,No,Yes', "teiid_sf:Custom" 'TRUE'), > pnccanvaspck__SLASerialNumber__c string(10) OPTIONS(NAMEINSOURCE 'pnccanvaspck__SLASerialNumber__c', NATIVE_TYPE 'string', "teiid_sf:Custom" 'TRUE'), > pnccanvaspck__SLAExpirationDate__c date OPTIONS(NAMEINSOURCE 'pnccanvaspck__SLAExpirationDate__c', NATIVE_TYPE 'date', "teiid_sf:Custom" 'TRUE'), > pnccanvaspck__Business_Hours__c string(100) OPTIONS(NAMEINSOURCE 'pnccanvaspck__Business_Hours__c', NATIVE_TYPE 'string', "teiid_sf:Custom" 'TRUE'), > pnccanvaspck__Location__Latitude__s double OPTIONS(NAMEINSOURCE 'pnccanvaspck__Location__Latitude__s', NATIVE_TYPE 'double', "teiid_sf:Custom" 'TRUE'), > pnccanvaspck__Location__Longitude__s double OPTIONS(NAMEINSOURCE 'pnccanvaspck__Location__Longitude__s', NATIVE_TYPE 'double', "teiid_sf:Custom" 'TRUE'), > pnccanvaspck__Time_Zone__c string(10) OPTIONS(NAMEINSOURCE 'pnccanvaspck__Time_Zone__c', NATIVE_TYPE 'string', "teiid_sf:Custom" 'TRUE'), > CONSTRAINT Id_PK PRIMARY KEY(Id), > CONSTRAINT FK_Account_ParentId FOREIGN KEY(ParentId) REFERENCES Account(Id) > ) OPTIONS(NAMEINSOURCE 'Account', UPDATABLE 'TRUE', "teiid_sf:Supports Search" 'TRUE', "teiid_sf:Supports Replicate" 'TRUE', "teiid_sf:Supports Merge" 'TRUE', "teiid_sf:Supports Create" 'TRUE', "teiid_sf:Supports Delete" 'TRUE', "teiid_sf:Supports Query" 'TRUE', "teiid_sf:Supports Retrieve" 'TRUE') > ]]></metadata> > </model> > <model name="SFViewModel" type="VIRTUAL"> > <property name="imports" value="SFSourceModel"/> > <metadata type="DDL"><![CDATA[ > CREATE VIEW Account ( > Name string(255) > ) OPTIONS(UPDATABLE 'TRUE') > AS > SELECT > SFSourceModel.Account.Name > FROM > SFSourceModel.Account; > ]]></metadata> > </model> > </vdb>}} > I tried this same exact configuration in the 8.13.7 release and it worked. > Steven remarked the following: > "It looks like the change to build using the feature-packs broke the dependencies for the salesforce-34 resource adapter." -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4380) ODatat 4 deep insert works for only a single expand level

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4380?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4380: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1506562|https://bugzilla.redhat.com/show_bug.cgi?id=1506562] from NEW to ON_QA > ODatat 4 deep insert works for only a single expand level > --------------------------------------------------------- > > Key: TEIID-4380 > URL: https://issues.jboss.org/browse/TEIID-4380 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.12.x-6.4 > > > Inserting an entity with a graph more complicated than a single expand won't work as expected - in most cases an exception will be thrown after the inserts are performed / committed. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2017