Skip to content

[Bug] delete from table where key=xxx hangs #36775

@dataroaring

Description

@dataroaring

Search before asking

  • I had searched in the issues and found no similar issues.

Version

master

What's Wrong?

-9999782574499444.2 is legal but doris handles it as illegal.
when an illegal decimal happens on delete, fe retries it until timeout.

What You Expected?

Handle -9999782574499444.2 successfully.
Fail immediately for illegal data.

How to Reproduce?

CREATE TABLE table1
(
col1 BOOLEAN NOT NULL, col2 DECIMAL(17, 1) NOT NULL, col3 INT NOT NULL,
)
DUPLICATE KEY(col1,col2,col3)
DISTRIBUTED BY HASH(col1,col2,col3) BUCKETS 4
PROPERTIES (
"disable_auto_compaction"="false",
"replication_num" = "3"
);

delete from table1 where col1 = "false" and col2 = "-9999782574499444.2" and col3 = "-25"

Anything Else?

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions