oceanbase / oceanbase/oceanbase

INSERT reports error

Open
#2,376 1 comment 0 reactions 0 assignees View on GitHub

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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.