[MDEV-21471] ER_CRASHED_ON_USAGE upon UPDATE FOR PORTION on Aria table Created: 2020-01-13  Updated: 2020-04-03  Resolved: 2020-04-03

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Aria, Versioned Tables
Affects Version/s: 10.4
Fix Version/s: 10.4.13, 10.5.3

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Aleksey Midenkov
Resolution: Fixed Votes: 0
Labels: affects-tests

Issue Links:
Relates
relates to MDEV-20441 ER_CRASHED_ON_USAGE (Table is marked ... Closed

 Description   

Note: Bugfix for MDEV-20441 is already in the trees.

CREATE TABLE t1 (s DATE, e DATE, PERIOD FOR app(s,e), f VARCHAR(8)) ENGINE=Aria ROW_FORMAT=FIXED;
 
INSERT INTO t1 VALUES ('2024-05-13','2026-03-25','foo');
 
UPDATE t1 FOR PORTION OF app FROM '2024-04-02' TO '2026-03-15' SET f = 'bar';
 
 
 
# Cleanup
 
DROP TABLE t1;

10.4 98316320

 
mysqltest: At line 3: query 'UPDATE t1 FOR PORTION OF app FROM '2024-04-02' TO '2026-03-15' SET f = 'bar'' failed: 1194: Table 't1' is marked as crashed and should be repaired



 Comments   
Comment by Oleksandr Byelkin [ 2020-03-20 ]

OK to push

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