oceanbase / oceanbase/oceanbase
INSERT reports error
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 10.3k
- Forks
- 1.9k
- PR merge metrics
- No merged PRs in 30d
Description
Self Checks
- I have read the Contributing Guide.
- This is only for bug report, if you would like to ask a question, please head to Discussions.
- I have searched for existing issues search for existing issues, including closed ones.
- I confirm that I am using English to submit this report, otherwise it will be closed.
- 【中文用户 & Non English User】请使用英语提交,否则会被关闭 :)
- Please do not modify this template :) and fill in all the required fields.
OceanBase version
5.7.25-OceanBase_CE-v4.5.1.0
Self Hosted
Self Hosted (Source)
Environment
5.7.25-OceanBase_CE-v4.5.1.0
Ubuntu 22.04.3
Linux 4.18.0-553.el8_10.x86_64
Steps to reproduce
DROP TABLE IF EXISTS t0;
CREATE TABLE t0 (
c0 DECIMAL(20,0) UNSIGNED,
c1 CHAR(10) DEFAULT '{',
c2 FLOAT UNSIGNED GENERATED ALWAYS AS (c0) VIRTUAL NOT NULL UNIQUE
);
INSERT IGNORE INTO t0(c1, c0) VALUES ('3', NULL), ('&', -679917749);
INSERT IGNORE INTO t0(c1, c0) VALUES ('2', -1665002185) ON DUPLICATE KEY UPDATE c0=t0.c1;
✔️ Expected Behavior
Statements execute successfully.
❌ Actual Behavior
ERROR 4016 (HY000): Internal error
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the three SQL statements on OceanBase 5.7.25-OceanBase_CE-v4.5.1.0 under the reported Ubuntu environment, focusing on the generated column, unsigned values, and ON DUPLICATE KEY UPDATE. Done means the statements execute successfully without ERROR 4016 (HY000): Internal error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100