<p><a href="https://github.com/ribasushi" class="user-mention">@ribasushi</a> I narrowed it down to SQL::Translator::Diff, when building an SQL::Translator object in <a href="https://github.com/dbsrgits/sql-translator/blob/master/lib/SQL/Translator/Diff.pm#L276"><code>produce_sql_diff</code></a>.</p>
<p>It should be:</p>
<div class="highlight highlight-source-perl"><pre> <span class="pl-k">my</span> <span class="pl-smi">$translator</span> = SQL::Translator<span class="pl-k">-></span>new(
<span class="pl-c1">producer_type</span> <span class="pl-k">=></span> <span class="pl-smi">$self</span><span class="pl-k">-></span>output_db,
<span class="pl-c1">add_drop_table</span> <span class="pl-k">=></span> 0,
<span class="pl-c1">no_comments</span> <span class="pl-k">=></span> 1,
<span class="pl-c1">producer_args</span> <span class="pl-k">=></span> <span class="pl-smi">$self</span><span class="pl-k">-></span>producer_args
);</pre></div>
<p>otherwise the SQL::Translator constructor gets <code>mysql_version</code> directly as an argument. Obviously it wouldn't know what to do with a MySQL-specific argument, so it just gets thrown away.</p>
<p>The MySQL producer's <code>produce</code> method is then called a few lines later with that translator instance.</p>
<p>With this fix I can get my boolean column. I still have backticks everywhere, which is aesthetically annoying but I can live with that. :)</p>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly or <a href="https://github.com/dbsrgits/sql-translator/issues/81#issuecomment-203932591">view it on GitHub</a><img alt="" height="1" src="https://github.com/notifications/beacon/AASeAgzWLRDWCXeN14ctobLiKWq4XBKWks5py8lhgaJpZM4H74_s.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/dbsrgits/sql-translator/issues/81#issuecomment-203932591"></link>
<meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>