[teiid-issues] [JBoss JIRA] (TEIID-5519) Update and Delete with WHERE clause not working for delimited flat file(header true)
[
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)