[MDEV-35122] Incorrect NULL value handling for instantly dropped BLOB columns - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 11.4.3, 10.4(EOL), 10.5(EOL), 10.6, 10.11, 11.4
Fix Version/s: 10.5.27, 10.6.20, 10.11.10, 11.2.6, 11.4.4
Component/s: Data Definition - Alter Table, Data Manipulation - Insert, Storage Engine - InnoDB
Labels:
None

Description

I run the following test case, in which the INSERT statement should populate the value. However, it failed and returns an error, indicating the dropped column seems to still exist.

CREATE TABLE t0 (c1 INT, c2 BLOB) ROW_FORMAT=REDUNDANT;

ALTER TABLE t0 DROP c2;

INSERT INTO t0 (c1) VALUES (0); -- [42000][1118] (conn=10) Row size too large (> 8123). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

Attachments

Issue Links

is caused by

MDEV-15562 Instant DROP COLUMN or changing the order of columns

Closed

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: John Jove

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2024-10-11 04:06

Updated:: 2024-10-15 07:56

Resolved:: 2024-10-15 07:56

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

4.75h

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.