Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The last statement, execution error, is a false positive? #7425

Closed
Nliver opened this issue Dec 28, 2023 · 3 comments
Closed

The last statement, execution error, is a false positive? #7425

Nliver opened this issue Dec 28, 2023 · 3 comments
Assignees
Labels
bug Something isn't working SQL
Milestone

Comments

@Nliver
Copy link

Nliver commented Dec 28, 2023

Describe the bug
A clear and concise description of what the bug is.

drop table ttt;
create table ttt(id int primary key,k int NOT NULL DEFAULT '0');
insert into ttt values(1,3),(2,3),(3,3),(4,3),(5,3);
update ttt set k=k+1 where id=3;
delete from ttt where id=2;
update ttt set id = 3 where id = 3;

The last statement, execution error, is a false positive?

Expected behavior
An error was reported executing the last statement.

Software versions

  • MonetDB version number [a milestone label]
  • OS and version: Ubuntu 20.04
  • Self-installed and compiled
@mvdvm mvdvm added bug Something isn't working SQL labels Jan 4, 2024
@mvdvm
Copy link
Contributor

mvdvm commented Jan 4, 2024

The last statement causes error: UPDATE: PRIMARY KEY constraint 'ttt.ttt_id_pkey' violated
while it should be allowed.
Potentially the primary key hash index is not correctly updated after the statement: delete from ttt where id=2;

From which branch did you compile the sources? Dec2023 or default or ???

@Nliver
Copy link
Author

Nliver commented Jan 8, 2024

The last statement causes error: UPDATE: PRIMARY KEY constraint 'ttt.ttt_id_pkey' violated while it should be allowed. Potentially the primary key hash index is not correctly updated after the statement: delete from ttt where id=2;

From which branch did you compile the sources? Dec2023 or default or ???

@mvdvm MonetDB version number [Jun2023 Feature Release (11.47.3)]

@njnes njnes added this to the NEXTRELEASE milestone Jan 10, 2024
@njnes njnes self-assigned this Jan 10, 2024
@njnes
Copy link
Contributor

njnes commented Jan 10, 2024

pushed a fix to the dec 2023 branch

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working SQL
Projects
None yet
Development

No branches or pull requests

4 participants