[MDEV-32153] INSERT cannot get row_start/row_end values Created: 2023-09-12  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: 10.4
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1

Type: Bug Priority: Minor
Reporter: Aleksey Midenkov Assignee: Aleksey Midenkov
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Reproduce

create table t0 (c0 int, c1 timestamp(6), c2 timestamp(6)) with system versioning;
insert into t0 values (0, '2000-01-01 00:00:00', c1);
insert into t0 values (1, '2001-01-01 00:00:00', row_start);
insert into t0 values (2, '2002-01-01 00:00:00', row_end);
select * from t0;
drop table t0;

Result

select * from t0;
c0      c1      c2
0       2000-01-01 00:00:00.000000      2000-01-01 00:00:00.000000
1       2001-01-01 00:00:00.000000      0000-00-00 00:00:00.000000
2       2002-01-01 00:00:00.000000      0000-00-00 00:00:00.000000

Expected

Field c2 is filled with correct values for rows 1 and 2.



 Comments   
Comment by Sergei Golubchik [ 2023-09-14 ]

I'm not sure it's a bug. Better to check the standard to see how it defines when row_start/row_end get their values.

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