[MDEV-34038] A division in an indexed virtual column corrupts the table on @@dev_precision_increment change - Jira

XML

Word

Printable

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4, 11.5(EOL)
Fix Version/s: 10.5
Component/s: Data types, Virtual Columns
Labels:
None

These scripts demonstrate the problem:

SET @@div_precision_increment=4;

CREATE OR REPLACE TABLE t1 (

  a INT,

  v INT GENERATED ALWAYS AS (LENGTH(a/3)),

  KEY(v)

) ENGINE=MyISAM;

INSERT INTO t1 (a) VALUES (1);

SELECT * FROM t1;

FLUSH TABLES;

SET @@div_precision_increment=8;

SELECT * FROM t1;

CHECK TABLE t1;

+---------+-------+----------+---------------------------------------------------------+

| Table   | Op    | Msg_type | Msg_text                                                |

+---------+-------+----------+---------------------------------------------------------+

| test.t1 | check | error    | Checksum for key:  1 doesn't match checksum for records |

| test.t1 | check | error    | Corrupt                                                 |

+---------+-------+----------+---------------------------------------------------------+

SET @@div_precision_increment=4;

CREATE OR REPLACE TABLE t1 (

  a INT,

  v VARCHAR(100) GENERATED ALWAYS AS (a/3.000),

  KEY(v)

) ENGINE=MyISAM;

INSERT INTO t1 (a) VALUES (1);

SELECT * FROM t1;

FLUSH TABLES;

SET @@div_precision_increment=8;

SELECT * FROM t1;

CHECK TABLE t1;

+---------+-------+----------+---------------------------------------------------------+

| Table   | Op    | Msg_type | Msg_text                                                |

+---------+-------+----------+---------------------------------------------------------+

| test.t1 | check | error    | Checksum for key:  1 doesn't match checksum for records |

| test.t1 | check | error    | Corrupt                                                 |

+---------+-------+----------+---------------------------------------------------------+

SET @@div_precision_increment=4;

CREATE OR REPLACE TABLE t1 (

  a INT,

  v DECIMAL(48,30) GENERATED ALWAYS AS (a/3.000),

  KEY(v)

) ENGINE=MyISAM;

INSERT INTO t1 (a) VALUES (1);

SELECT * FROM t1;

FLUSH TABLES;

SET @@div_precision_increment=8;

SELECT * FROM t1;

CHECK TABLE t1;

+---------+-------+----------+---------------------------------------------------------+

| Table   | Op    | Msg_type | Msg_text                                                |

+---------+-------+----------+---------------------------------------------------------+

| test.t1 | check | error    | Checksum for key:  1 doesn't match checksum for records |

| test.t1 | check | error    | Corrupt                                                 |

+---------+-------+----------+---------------------------------------------------------+

relates to

MDEV-20610 Assertion failed or btr_validate_index(..) in row_upd_sec_index_entry on a time_zone change

MDEV-34037 DATETIME <-> TIMESTAMP conversion in a virtual column corrups the table on @@time_zone change

MDEV-34039 Some string functions in a virtual column lead the table corruption on @@max_allowed_packet change

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