[ 
https://issues.apache.org/jira/browse/IGNITE-20030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alexander Belyak updated IGNITE-20030:
--------------------------------------
    Attachment: IGNITE-20030.zip

> Delete from table with composite PK failed
> ------------------------------------------
>
>                 Key: IGNITE-20030
>                 URL: https://issues.apache.org/jira/browse/IGNITE-20030
>             Project: Ignite
>          Issue Type: Task
>            Reporter: Alexander Belyak
>            Priority: Major
>         Attachments: IGNITE-20030.zip
>
>
>  
> {noformat}
> drop table if exists testt;
> create table testt (id int, val int, id2 int not null, val2 varchar(255), 
> primary key(id,id2) );
> insert into testt(id, val, id2, val2) 
> values(1,1,1,'1'),(2,2,2,'2'),(3,3,3,'3');
> delete from testt where id = 2;
> delete from testt where id = 2 and id2 = 2;{noformat}
> Expected result: row deleted without errors
>  
> Actual result:
>  
> {noformat}
> [Code: 0, SQL State: 50000]  Exception while executing query [query=delete 
> from testt where id = 2]. Error message:Query remote fragment execution 
> failed: nodeName=SmokeOdbcTest_cluster_0, 
> queryId=d47ef0ae-65dd-4762-8e6b-0b40e0333d27, fragmentId=1793, 
> originalMessage=null{noformat}
> Logs in attachment.
>  
> AI3 commit id: f34beaed



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to