[MDEV-26928] Column-inclusive WITH SYSTEM VERSIONING doesn't work with explicit system fields Created: 2021-10-27  Updated: 2022-01-09  Resolved: 2021-11-02

Status: Closed
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: 10.3, 10.4, 10.5, 10.6
Fix Version/s: 10.3.33, 10.4.23, 10.5.14, 10.6.6

Type: Bug Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Aleksey Midenkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes MDEV-27430 Assertion `field.is_sane()' failed in... Closed
causes MDEV-27452 TIMESTAMP(0) system field is allowed ... Closed
is caused by MDEV-12894 System-versioned tables Closed

 Description   

Reproduce

create or replace table t1 (
 
    x int, y int with system versioning,
 
    row_start timestamp(6) as row start,
 
    row_end timestamp(6) as row end,
 
    period for system_time(row_start, row_end));

Result

ERROR 4125 (HY000): Wrong parameters for `t1`: missing 'WITH SYSTEM VERSIONING'

Expected

Command succeeds.

 Comments   
Comment by Aleksey Midenkov [ 2021-11-02 ]

Please review bb-10.3-midenok

Comment by Nikita Malyavin [ 2021-11-02 ]

Posted some demands to the test: https://github.com/MariaDB/server/commit/746ca3d9f7c3fa50615488203e994dc76381f783

Ok to push after fulfillment

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