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)