How to handle MariaDB System-Versioned Tables with Doctrine ORM?

377 Views Asked by At

I have the following table:

CREATE TABLE accounts (
       id INT PRIMARY KEY AUTO_INCREMENT,
       name VARCHAR(255),
       amount INT
) WITH SYSTEM VERSIONING;

The WITH SYSTEM VERSIONING clause initializes hidden, system-managed row_start and row_end columns for tracking changes by row.

The corresponding entity does not have these fields (row_start, row_end) which are managed by MariaDB.

When I try to run any doctrine command, for example symfony console doctrine:schema:update, I get the following error:

In SchemaException.php line 85:
                                                                    
  There is no column with name 'row_end' on table 'accounts'.

MariaDB System-Versioned Tables

0

There are 0 best solutions below