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.