title: FULLTEXT indexes in MariaDB 10
body: <p>MariaDB documentation says that FULLTEXT indexes for InnoDB are supported since version 10.0.5 (<a href="https://mariadb.com/kb/en/mariadb/documentation/optimization-and-tuning/optimization-and-indexes/full-text-indexes/fulltext-index-overview/" rel="nofollow">https://mariadb.com/kb/en/mariadb/documentation/optimization-and-tuning/optimization-and-indexes/full-text-indexes/fulltext-index-overview/</a>)</p>
  
  <p>I recently installed MariaDB 10.0.13 and tried to convert a MyISAM table to InnoDB, like so:</p>
  
  <pre><code>MariaDB [(test)]&gt; ALTER TABLE field_values ENGINE=InnoDB;
  </code></pre>
  
  <p>But ran into this error:</p>
  
  <pre><code>ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes
  </code></pre>
  
  <p>Here's the <code>SHOW INDEXES</code> query for my table:</p>
  
  <pre><code>MariaDB [(test)]&gt; show indexes in  field_values;
  +--------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
  | Table                    | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
  +--------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
  | field_values |          0 | PRIMARY  |            1 | productid   | A         |        NULL |     NULL | NULL   |      | BTREE      |         |               |
  | field_values |          0 | PRIMARY  |            2 | fieldid     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
  | field_values |          1 | value    |            1 | value       | NULL      |        NULL |     NULL | NULL   |      | FULLTEXT   |         |               |
  +--------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
  3 rows in set (0.00 sec)
  </code></pre>
  
  <p>MariaDB documentation states these indexes that can be created only for CHAR, VARCHAR, or TEXT columns. So here's a <code>DESCRIBE TABLE</code> for my table:</p>
  
  <pre><code>MariaDB [(test)]&gt; describe  field_values ;
  +-----------+-----------+------+-----+---------+-------+
  | Field     | Type      | Null | Key | Default | Extra |
  +-----------+-----------+------+-----+---------+-------+
  | productid | int(11)   | NO   | PRI | 0       |       |
  | fieldid   | int(11)   | NO   | PRI | 0       |       |
  | value     | char(255) | NO   | MUL |         |       |
  +-----------+-----------+------+-----+---------+-------+
  3 rows in set (0.00 sec)
  </code></pre>
  
  <p>The field in question (<code>value</code>) is supported, being of type <code>CHAR</code>.</p>
  
  <p>Finally, here's my MariaDB version:</p>
  
  <pre><code>mysql  Ver 15.1 Distrib 10.0.13-MariaDB, for Linux (x86_64) using readline 5.1
  </code></pre>
  
  <p>So, according to MariaDB documentation at least, this operation should be supported and yet I'm seeing an error. Do I have to do anything else to enable FULLTEXT indexes in MariaDB 10.0.13?</p>