October 2018 - teiid-issues - Jboss List Archives

[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:java} 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:java} 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:java} > 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, 7 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:java} 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, 7 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)

Rujuta Samant created TEIID-5519: ------------------------------------ Summary: 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 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:java} 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, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5517) Validation error with procedure call that has no result set

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5517?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5517. ----------------------------------- Resolution: Done Updated the metadatavalidator to also check for procedures that have no result set. > Validation error with procedure call that has no result set > ----------------------------------------------------------- > > Key: TEIID-5517 > URL: https://issues.jboss.org/browse/TEIID-5517 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.0 > > > This is a regression with TEIID-5257 - in a procedure that has a result set if a another procedure that is called which doesn't have a result set, an index out of bounds exception is thrown. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5518) xmlschema-core dependency missing from ws connector

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5518?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5518. ----------------------------------- Resolution: Done Added the missing dependency to the pom. > xmlschema-core dependency missing from ws connector > --------------------------------------------------- > > Key: TEIID-5518 > URL: https://issues.jboss.org/browse/TEIID-5518 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.0, 11.2.1 > > > To ease use with embedded we should already include xmlschema-core, rather than requiring the user to declare it as well. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5518) xmlschema-core dependency missing from ws connector

by Steven Hawkins (Jira)

Steven Hawkins created TEIID-5518: ------------------------------------- Summary: xmlschema-core dependency missing from ws connector Key: TEIID-5518 URL: https://issues.jboss.org/browse/TEIID-5518 Project: Teiid Issue Type: Bug Components: Misc. Connectors Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 11.2.1, 12.0 To ease use with embedded we should already include xmlschema-core, rather than requiring the user to declare it as well. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5517) Validation error with procedure call that has no result set

by Steven Hawkins (Jira)

Steven Hawkins created TEIID-5517: ------------------------------------- Summary: Validation error with procedure call that has no result set Key: TEIID-5517 URL: https://issues.jboss.org/browse/TEIID-5517 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 12.0 This is a regression with TEIID-5257 - in a procedure that has a result set if a another procedure that is called which doesn't have a result set, an index out of bounds exception is thrown. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 7 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 commented on TEIID-5516: --------------------------------------- The ambiguous situation is a schema marked as having no read access, but a table under it having read access. Are they requesting that the name of the containing schema be unknown or known in that circumstance? > 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 > > 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, 7 months

1
0
0 / 0

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

by RH Bugzilla Integration (Jira)

[ https://issues.jboss.org/browse/TEIID-5516?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-5516: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1642602 Bugzilla Update: Perform > 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 > > 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, 7 months

1
0
0 / 0

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

by Debbie Steigner (Jira)

Debbie Steigner created TEIID-5516: -------------------------------------- Summary: 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 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, 7 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