[MDEV-6303] MyISAM/Aria: Adding/removing non-materialized virtual column triggers table recreation Created: 2014-06-04  Updated: 2014-06-30

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.37, 10.0.11, 10.1.0
Fix Version/s: 10.1

Type: Bug Priority: Minor
Reporter: Sergey Vojtovich Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-6103 Adding/removing non-materialized virt... Closed

 Description   

This is a split from MDEV-6103:
MyISAM (and most probably Aria) reserves extra bits for virtual columns (NULL flag) in a physical record (the one that is written to disk). There should be no good reason to do so.

E.g.:
create table t1 (b int, d int); # Uses 2nd and 3rd bits for NULL flags
create table t2 (a int as (-b), b int, c int as (-b), d int); # Uses 3rd and 5th bits for NULL flags

All in all it means physical record format changes when adding/dropping virtual columns and just relaxing table comparison function is not enough to fix this bug.

See test case for MDEV-6103 in vcol.vcol_non_stored_columns_myisam which confirms reported behavior.


Generated at Thu Feb 08 07:10:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.