Fix for bug #10893 (myisamchk fails on packed spatial)

need to be fixed in 4.1

1 files changed, 4 insertions, 2 deletions

diff --git a/myisam/mi_create.c b/myisam/mi_create.c
index 890ee61fd7f..41c965c7c80 100644
--- a/myisam/mi_create.c
+++ b/myisam/mi_create.c
@@ -254,9 +254,11 @@ int mi_create(const char *name,uint keys,MI_KEYDEF *keydefs,
         /*
            called by myisamchk - i.e. table structure was taken from
            MYI file and SPATIAL key *does have* additional sp_segs keysegs.
-           We'd better delete them now
+           keydef->seg here points right at the GEOMETRY segment,
+           so we only need to decrease keydef->keysegs.
+           (see recreate_table() in mi_check.c)
         */
-        keydef->keysegs-=sp_segs;
+        keydef->keysegs-=sp_segs-1;
       }
 
       for (j=0, keyseg=keydef->seg ; (int) j < keydef->keysegs ;