From c838b707690bbf53578af13ed51129e97aba6dc3 Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Fri, 10 Mar 2023 02:15:07 -0600
Subject: innodb: auto_increment issues

---
 issues/systems/mariadb/move-to-innodb.gmi | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'issues/systems')

diff --git a/issues/systems/mariadb/move-to-innodb.gmi b/issues/systems/mariadb/move-to-innodb.gmi
index 315ffac..d521483 100644
--- a/issues/systems/mariadb/move-to-innodb.gmi
+++ b/issues/systems/mariadb/move-to-innodb.gmi
@@ -1093,6 +1093,13 @@ alter table TempData add primary key (Id);
 show create table TempData;
 ```
 
+Some tables showed problems with AUTO_INCREMENT. Simply redefine the column without the attribute:
+
+```
+ALTER TABLE Chr_Length CHANGE Id Id smallint(5) UNSIGNED NOT NULL;
+```
+
+
 ## Disk space
 
 I needed more disk space to move the largest tables note the new SSD disk is twice as slow as the old SSD:
-- 
cgit v1.2.3