You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Alexander Belyak (Jira)" <ji...@apache.org> on 2023/07/24 08:35:00 UTC

[jira] [Updated] (IGNITE-20030) Delete from table with composite PK failed

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

Alexander Belyak updated IGNITE-20030:
--------------------------------------
    Summary: Delete from table with composite PK failed  (was: Delete from table failed if )

> 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)