title: H2 and MySQL compatibility issues
body: <p>i am using H2 for my integration tests with Liquibase and it seems that there are compatibility issues.</p>
  
  <p>A simple change column function does not pass on H2 where it works perfectly on MySQL distribution.</p>
  
  <p>here is the query:</p>
  
  <blockquote>
  <pre><code>ALTER TABLE `designs`
  ALTER COLUMN `description` `description` TEXT NULL DEFAULT NULL AFTER `created`;
  </code></pre>
  </blockquote>
  
  <p>And the error:</p>
  
  <blockquote>
  <pre><code>2014-06-07 14:27:05,708 [DEBUG] [NewPooledConnection,handleThrowable(),430] - com.mchange.v2.c3p0.impl.NewPooledConnection@78af2ac3 handling a throwable.
  org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "ALTER TABLE DESIGNS 
  ALTER COLUMN DESCRIPTION TEXT NULL DEFAULT NULL AFTER[*] CREATED "; SQL statement:
  ALTER TABLE designs ALTER COLUMN description TEXT NULL DEFAULT NULL AFTER created [42000-178]
  at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
  </code></pre>
  </blockquote>
  
  <p>Some configuration:</p>
  
  <blockquote>
  <pre><code>repository.connectionString = jdbc:h2:mem:db;MODE=MySQL;DB_CLOSE_ON_EXIT=FALSE
  repository.driver = org.h2.Driver
  repository.username = sa
  repository.password = 
  </code></pre>
  </blockquote>
  
  <p>Any ideas how to tackle this? as far as i understand H2 should be compatible with Mysql</p>