MariaDB [bcfactory]> select * from job_SEQ;

+-----------------------+---------------+---------------------+-------------+-----------+------------+--------------+-------------+

| next_not_cached_value | minimum_value | maximum_value       | start_value | increment | cache_size | cycle_option | cycle_count |

+-----------------------+---------------+---------------------+-------------+-----------+------------+--------------+-------------+

|                     1 |             1 | 9223372036854775806 |           1 |        50 |       1000 |            0 |           0 |

+-----------------------+---------------+---------------------+-------------+-----------+------------+--------------+-------------+

1 row in set (0.000 sec)

MariaDB [bcfactory]> alter sequence job_SEQ RESTART WITH (select MAX(id) + 1 from job);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(select MAX(id) + 1 from job)' at line 1

MariaDB [bcfactory]> select version();

+---------------------------------------+

| version()                             |

+---------------------------------------+

| 11.2.2-MariaDB-1:11.2.2+maria~ubu2204 |

+---------------------------------------+

1 row in set (0.000 sec)

```