SPATIAL 索引。 index_col_name 支持长度选项，最大长度限制为3072字节，该长度限制不根据建表时使用的存储引擎、字符 集而变。这是因为 TiDB 并非使用 Innodb 、 MyISAM 等存储引擎，因此，仅对建表时的存储引擎选项进 行了 MySQL 语法上的兼容。对于字符集，TiDB 使用的是 utf8mb4 字符集，对于建表时的字符集选项同样 仅有 MySQL 语法上的兼容。详见与

016 sec) 6.4.7.2.4 Storage engines MariaDB offers storage engines for local data such as InnoDB, MyISAM and Aria. While the data format is not directly supported by TiDB, migrating these works fine. However +--------------------+----------+ | NULL | 101 | | Aria | 38 | | CSV | 2 | | InnoDB | 6 | | MEMORY | 67 | | MyISAM | 1 | | PERFORMANCE_SCHEMA | 81 | +--------------------+----------+ 7 rows in set (0.009 sec) incompatible DDL A DDL statement that modifies the table storage engine, such as the ALTER �→ TABLE ENGINE = MyISAM statement reorganize �→ table �→ partition incompatible DDL A DDL statement that reorganizes partitions

016 sec) 6.4.6.2.4 Storage engines MariaDB offers storage engines for local data such as InnoDB, MyISAM and Aria. While the data format is not directly supported by TiDB, migrating these works fine. However +----------+ | NULL | 101 | | Aria | 38 | | CSV | 2 | 773 | InnoDB | 6 | | MEMORY | 67 | | MyISAM | 1 | | PERFORMANCE_SCHEMA | 81 | +--------------------+----------+ 7 rows in set (0.009 sec) incompatible DDL A DDL statement that modifies the table storage engine, such as the ALTER �→ TABLE ENGINE = MyISAM statement reorganize �→ table �→ partition incompatible DDL A DDL statement that reorganizes partitions

016 sec) 6.4.6.2.4 Storage engines MariaDB offers storage engines for local data such as InnoDB, MyISAM and Aria. While the data format is not directly supported by TiDB, migrating these works fine. However +----------+ | NULL | 101 | | Aria | 38 | | CSV | 2 | 776 | InnoDB | 6 | | MEMORY | 67 | | MyISAM | 1 | | PERFORMANCE_SCHEMA | 81 | +--------------------+----------+ 7 rows in set (0.009 sec) incompatible DDL A DDL statement that modifies the table storage engine, such as the ALTER �→ TABLE ENGINE = MyISAM statement reorganize �→ table �→ partition incompatible DDL A DDL statement that reorganizes partitions

016 sec) 6.4.6.2.4 Storage engines MariaDB offers storage engines for local data such as InnoDB, MyISAM and Aria. While the data format is not directly supported by TiDB, migrating these works fine. However +----------+ | NULL | 101 | | Aria | 38 | | CSV | 2 | 851 | InnoDB | 6 | | MEMORY | 67 | | MyISAM | 1 | | PERFORMANCE_SCHEMA | 81 | +--------------------+----------+ 7 rows in set (0.009 sec) incompatible DDL A DDL statement that modifies the table storage engine, such as the ALTER �→ TABLE ENGINE = MyISAM statement reorganize �→ table �→ partition incompatible DDL A DDL statement that reorganizes partitions

016 sec) 6.4.6.2.4 Storage engines MariaDB offers storage engines for local data such as InnoDB, MyISAM and Aria. While the data format is not directly supported by TiDB, migrating these works fine. However +----------+ | NULL | 101 | | Aria | 38 | | CSV | 2 | 771 | InnoDB | 6 | | MEMORY | 67 | | MyISAM | 1 | | PERFORMANCE_SCHEMA | 81 | +--------------------+----------+ 7 rows in set (0.009 sec) incompatible DDL A DDL statement that modifies the table storage engine, such as the ALTER �→ TABLE ENGINE = MyISAM statement reorganize �→ table �→ partition incompatible DDL A DDL statement that reorganizes partitions

+--------------+------------+ 1 row in set (0.016 sec) 6.4.6.2.4 存储引擎 MariaDB 为本地数据提供了存储引擎，例如 InnoDB、MyISAM 和 Aria。虽然 TiDB 不直接支持这些数据格式，但是 你仍可以迁移这些数据。但是，也有一些存储引擎将数据放在服务器之外，例如 CONNECT 存储引擎和 Spider。 虽然你可以将这些表迁移到 +--------------------+----------+ | NULL | 101 | | Aria | 38 | | CSV | 2 | | InnoDB | 6 | | MEMORY | 67 | | MyISAM | 1 | | PERFORMANCE_SCHEMA | 81 | +--------------------+----------+ 7 rows in set (0.009 sec) DDL 删除自增键的 DDL 语句 modify storage engine incompatible DDL 修改表存储引擎的 DDL 语句，如 ALTER TABLE ENGINE = MyISAM 语句 reorganize table partition incompatible DDL 重组分区的 DDL 语句，如 ALTER TABLE REORGANIZE PARTITION

+--------------+------------+ 1 row in set (0.016 sec) 6.4.6.2.4 存储引擎 MariaDB 为本地数据提供了存储引擎，例如 InnoDB、MyISAM 和 Aria。虽然 TiDB 不直接支持这些数据格式，但是 你仍可以迁移这些数据。但是，也有一些存储引擎将数据放在服务器之外，例如 CONNECT 存储引擎和 Spider。 虽然你可以将这些表迁移到 +--------------------+----------+ | NULL | 101 | | Aria | 38 | | CSV | 2 | | InnoDB | 6 | | MEMORY | 67 | | MyISAM | 1 | | PERFORMANCE_SCHEMA | 81 | +--------------------+----------+ 7 rows in set (0.009 sec) DDL 删除自增键的 DDL 语句 modify storage engine incompatible DDL 修改表存储引擎的 DDL 语句，如 ALTER TABLE ENGINE = MyISAM 语句 reorganize table partition incompatible DDL 重组分区的 DDL 语句，如 ALTER TABLE REORGANIZE PARTITION

+--------------+------------+ 1 row in set (0.016 sec) 661 6.4.7.2.4 存储引擎 MariaDB 为本地数据提供了存储引擎，例如 InnoDB、MyISAM 和 Aria。虽然 TiDB 不直接支持这些数据格式，但是 你仍可以迁移这些数据。但是，也有一些存储引擎将数据放在服务器之外，例如 CONNECT 存储引擎和 Spider。 虽然你可以将这些表迁移到 +--------------------+----------+ | NULL | 101 | | Aria | 38 | | CSV | 2 | | InnoDB | 6 | | MEMORY | 67 | | MyISAM | 1 | | PERFORMANCE_SCHEMA | 81 | +--------------------+----------+ 7 rows in set (0.009 sec) DDL 删除自增键的 DDL 语句 modify storage engine incompatible DDL 修改表存储引擎的 DDL 语句，如 ALTER TABLE ENGINE = MyISAM 语句 reorganize table partition incompatible DDL 重组分区的 DDL 语句，如 ALTER TABLE REORGANIZE PARTITION