October 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5521) Add build plugins used by basepom to help with dependency handling

by Van Halbert (Jira)

[ https://issues.jboss.org/browse/TEIID-5521?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-5521: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) > Add build plugins used by basepom to help with dependency handling > ------------------------------------------------------------------ > > Key: TEIID-5521 > URL: https://issues.jboss.org/browse/TEIID-5521 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Affects Versions: 12.x > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Major > > Utilize plugins that basebom uses, which will help reduce half the headaches you go though during the productization with versions. > plugins: > * duplicate-finder-maven-plugin > * maven-dependency-plugin > * maven-dependency-versions-check-plugin -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5520) Setting longRanks to true fails to resolve views appropriately

by Steven Hawkins (Jira)

Steven Hawkins created TEIID-5520: ------------------------------------- Summary: Setting longRanks to true fails to resolve views appropriately Key: TEIID-5520 URL: https://issues.jboss.org/browse/TEIID-5520 Project: Teiid Issue Type: Sub-task Components: Query Engine Affects Versions: 11.2 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 12.0, 11.2.1 When setting longRanks to true views projecting a ranking function will fail to resolve appropriately as the TransformationMetadata state is not copied appropriately. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5516) Exclude hidden schemas in metadata

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5516?page=com.atlassian.jira.plugin... ] Work on TEIID-5516 started by Steven Hawkins. --------------------------------------------- > Exclude hidden schemas in metadata > ---------------------------------- > > Key: TEIID-5516 > URL: https://issues.jboss.org/browse/TEIID-5516 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver, Query Engine > Affects Versions: 8.12.15.6_4 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.0 > > Attachments: Screen_Shot_2018-10-25_at_14.36.23.png > > > See https://issues.jboss.org/browse/TEIID-2476, now that hidden tables/columns are excluded, customer is requesting that the schemas also be excluded. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5516) Exclude hidden schemas in metadata

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5516?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5516: ---------------------------------- Fix Version/s: 12.0 > Exclude hidden schemas in metadata > ---------------------------------- > > Key: TEIID-5516 > URL: https://issues.jboss.org/browse/TEIID-5516 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver, Query Engine > Affects Versions: 8.12.15.6_4 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.0 > > Attachments: Screen_Shot_2018-10-25_at_14.36.23.png > > > See https://issues.jboss.org/browse/TEIID-2476, now that hidden tables/columns are excluded, customer is requesting that the schemas also be excluded. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5516) Exclude hidden schemas in metadata

by Debbie Steigner (Jira)

[ https://issues.jboss.org/browse/TEIID-5516?page=com.atlassian.jira.plugin... ] Debbie Steigner updated TEIID-5516: ----------------------------------- Attachment: Screen_Shot_2018-10-25_at_14.36.23.png > Exclude hidden schemas in metadata > ---------------------------------- > > Key: TEIID-5516 > URL: https://issues.jboss.org/browse/TEIID-5516 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver, Query Engine > Affects Versions: 8.12.15.6_4 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > Attachments: Screen_Shot_2018-10-25_at_14.36.23.png > > > See https://issues.jboss.org/browse/TEIID-2476, now that hidden tables/columns are excluded, customer is requesting that the schemas also be excluded. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5516) Exclude hidden schemas in metadata

by Debbie Steigner (Jira)

[ https://issues.jboss.org/browse/TEIID-5516?page=com.atlassian.jira.plugin... ] Debbie Steigner commented on TEIID-5516: ---------------------------------------- [~shawkins] Response from the customer: >From my point of view the answer is Known. See Attachment > Exclude hidden schemas in metadata > ---------------------------------- > > Key: TEIID-5516 > URL: https://issues.jboss.org/browse/TEIID-5516 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver, Query Engine > Affects Versions: 8.12.15.6_4 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > Attachments: Screen_Shot_2018-10-25_at_14.36.23.png > > > See https://issues.jboss.org/browse/TEIID-2476, now that hidden tables/columns are excluded, customer is requesting that the schemas also be excluded. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5519) Update and Delete with WHERE clause not working for delimited flat file(header true)

by Rujuta Samant (Jira)

[ https://issues.jboss.org/browse/TEIID-5519?page=com.atlassian.jira.plugin... ] Rujuta Samant updated TEIID-5519: --------------------------------- Steps to Reproduce: 1.create header true file on ftp say TRANSACTION_DTL_new.txt 2.File contain data given below: acct_number,product_type,prod_desc 123,Sports,sports related prod 124,Beauty,beauty related prod 3.Now execute {code:sql} UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.acct_number='123'; {code} where 'flatfileDeli' is connection name. *It throws error:* TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. 4.But if execute query - {code:sql} UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' {code} It works fine and update records as expected was: 1.create header true file on ftp say TRANSACTION_DTL_new.txt 2.File contain data given below: acct_number,product_type,prod_desc 123,Sports,sports related prod 124,Beauty,beauty related prod 3.Now execute {code:sql} UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.acct_number='123'; {code} where 'flatfileDeli' is connection name. *It throws error:* TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET Acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. 4.But if execute query - {code:sql} UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' {code} It works fine and update records as expected > Update and Delete with WHERE clause not working for delimited flat file(header true) > ------------------------------------------------------------------------------------ > > Key: TEIID-5519 > URL: https://issues.jboss.org/browse/TEIID-5519 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.1.3 > Environment: teiid-9.1.3 WildFly running on Windows Server 2012 R2 > Reporter: Rujuta Samant > Assignee: Steven Hawkins > Priority: Major > > Hi Team, > I have observed that in case of header true delimited flatfiles for FTP/SFTP, we are unable to execute update/delete query with where clause. We are able to execute simple queries(without where clause) on Header True files succesfully. Adding to the same, we are able to execute queries succesfully in case of Delimited Header false flat files and Fixed width Flat files. > Given below is the query along with error message. > *Query* - > {code:sql} > UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.acct_number='123'; > {code} > *Error Message* - > TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5519) Update and Delete with WHERE clause not working for delimited flat file(header true)

by Rujuta Samant (Jira)

[ https://issues.jboss.org/browse/TEIID-5519?page=com.atlassian.jira.plugin... ] Rujuta Samant updated TEIID-5519: --------------------------------- Description: Hi Team, I have observed that in case of header true delimited flatfiles for FTP/SFTP, we are unable to execute update/delete query with where clause. We are able to execute simple queries(without where clause) on Header True files succesfully. Adding to the same, we are able to execute queries succesfully in case of Delimited Header false flat files and Fixed width Flat files. Given below is the query along with error message. *Query* - {code:sql} UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.acct_number='123'; {code} *Error Message* - TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. was: Hi Team, I have observed that in case of header true delimited flatfiles for FTP/SFTP, we are unable to execute update/delete query with where clause. We are able to execute simple queries(without where clause) on Header True files succesfully. Adding to the same, we are able to execute queries succesfully in case of Delimited Header false flat files and Fixed width Flat files. Given below is the query along with error message. *Query* - {code:sql} UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.Acct_number='123'; {code} *Error Message* - TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET Acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. > Update and Delete with WHERE clause not working for delimited flat file(header true) > ------------------------------------------------------------------------------------ > > Key: TEIID-5519 > URL: https://issues.jboss.org/browse/TEIID-5519 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.1.3 > Environment: teiid-9.1.3 WildFly running on Windows Server 2012 R2 > Reporter: Rujuta Samant > Assignee: Steven Hawkins > Priority: Major > > Hi Team, > I have observed that in case of header true delimited flatfiles for FTP/SFTP, we are unable to execute update/delete query with where clause. We are able to execute simple queries(without where clause) on Header True files succesfully. Adding to the same, we are able to execute queries succesfully in case of Delimited Header false flat files and Fixed width Flat files. > Given below is the query along with error message. > *Query* - > {code:sql} > UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.acct_number='123'; > {code} > *Error Message* - > TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5519) Update and Delete with WHERE clause not working for delimited flat file(header true)

by Rujuta Samant (Jira)

[ https://issues.jboss.org/browse/TEIID-5519?page=com.atlassian.jira.plugin... ] Rujuta Samant updated TEIID-5519: --------------------------------- Steps to Reproduce: 1.create header true file on ftp say TRANSACTION_DTL_new.txt 2.File contain data given below: acct_number,product_type,prod_desc 123,Sports,sports related prod 124,Beauty,beauty related prod 3.Now execute {code:sql} UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.acct_number='123'; {code} where 'flatfileDeli' is connection name. *It throws error:* TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET Acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. 4.But if execute query - {code:sql} UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' {code} It works fine and update records as expected was: 1.create header true file on ftp say TRANSACTION_DTL_new.txt 2.File contain data given below: acct_number,product_type,prod_desc 123,Sports,sports related prod 124,Beauty,beauty related prod 3.Now execute {code:sql} update flatfileDeli.TRANSACTION_DTL_new set TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.Acct_number='123'; {code} where 'flatfileDeli' is connection name. *It throws error:* TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET Acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. 4.But if execute query - {code:sql} update flatfileDeli.TRANSACTION_DTL_new set TRANSACTION_DTL_new.product_type='sports' {code} It works fine and update records as expected > Update and Delete with WHERE clause not working for delimited flat file(header true) > ------------------------------------------------------------------------------------ > > Key: TEIID-5519 > URL: https://issues.jboss.org/browse/TEIID-5519 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.1.3 > Environment: teiid-9.1.3 WildFly running on Windows Server 2012 R2 > Reporter: Rujuta Samant > Assignee: Steven Hawkins > Priority: Major > > Hi Team, > I have observed that in case of header true delimited flatfiles for FTP/SFTP, we are unable to execute update/delete query with where clause. We are able to execute simple queries(without where clause) on Header True files succesfully. Adding to the same, we are able to execute queries succesfully in case of Delimited Header false flat files and Fixed width Flat files. > Given below is the query along with error message. > *Query* - > {code:sql} > UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.Acct_number='123'; > {code} > *Error Message* - > TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET Acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5519) Update and Delete with WHERE clause not working for delimited flat file(header true)

by Rujuta Samant (Jira)

[ https://issues.jboss.org/browse/TEIID-5519?page=com.atlassian.jira.plugin... ] Rujuta Samant updated TEIID-5519: --------------------------------- Steps to Reproduce: 1.create header true file on ftp say TRANSACTION_DTL_new.txt 2.File contain data given below: acct_number,product_type,prod_desc 123,Sports,sports related prod 124,Beauty,beauty related prod 3.Now execute {code:sql} update flatfileDeli.TRANSACTION_DTL_new set TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.Acct_number='123'; {code} where 'flatfileDeli' is connection name. *It throws error:* TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET Acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. 4.But if execute query - {code:sql} update flatfileDeli.TRANSACTION_DTL_new set TRANSACTION_DTL_new.product_type='sports' {code} It works fine and update records as expected was: 1.create header true file on ftp say TRANSACTION_DTL_new.txt 2.File contain data given below: acct_number,product_type,prod_desc 123,Sports,sports related prod 124,Beauty,beauty related prod 3.Now execute {code:java} update flatfileDeli.TRANSACTION_DTL_new set TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.Acct_number='123'; {code} where 'flatfileDeli' is connection name. *It throws error:* TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET Acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. 4.But if execute query - {code:java} update flatfileDeli.TRANSACTION_DTL_new set TRANSACTION_DTL_new.product_type='sports' {code} It works fine and update records as expected > Update and Delete with WHERE clause not working for delimited flat file(header true) > ------------------------------------------------------------------------------------ > > Key: TEIID-5519 > URL: https://issues.jboss.org/browse/TEIID-5519 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.1.3 > Environment: teiid-9.1.3 WildFly running on Windows Server 2012 R2 > Reporter: Rujuta Samant > Assignee: Steven Hawkins > Priority: Major > > Hi Team, > I have observed that in case of header true delimited flatfiles for FTP/SFTP, we are unable to execute update/delete query with where clause. We are able to execute simple queries(without where clause) on Header True files succesfully. Adding to the same, we are able to execute queries succesfully in case of Delimited Header false flat files and Fixed width Flat files. > Given below is the query along with error message. > *Query* - > {code:sql} > UPDATE flatfileDeli.TRANSACTION_DTL_new SET TRANSACTION_DTL_new.product_type='sports' where TRANSACTION_DTL_new.Acct_number='123'; > {code} > *Error Message* - > TEIID30253 Source UPDATE or DELETE command "UPDATE flatfileDeli.TRANSACTION_DTL_new SET Acct_number = ? WHERE flatfileDeli.TRANSACTION_DTL_new.product_type = ?" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2018