<p>In <a href="https://github.com/dbsrgits/sql-translator/pull/47#discussion-diff-22586062">t/56-sqlite-producer.t</a>:</p>
<pre style='color:#555'>> @@ -165,6 +165,24 @@ $SQL::Translator::Producer::SQLite::NO_QUOTES = 0;
> }
>
> {
> + my $table = SQL::Translator::Schema::Table->new(
> + name => 'some_table',
> + );
> + $table->add_field(
> + name => 'id',
> + data_type => 'integer',
> + is_auto_increment => 1,
> + is_nullable => 0,
> + extra => {
> + auto_increment_method => 'sequence',
> + },
> + );
> + my $expected = [ qq<CREATE TABLE "some_table" (\n "id" integer AUTOINCREMENT NOT NULL\n)>];
</pre>
<p>This is not actually valid in SQLite, <code>AUTOINCREMENT</code> can only be used immediately after <code>INTEGER PRIMARY KEY</code>, so <code>field_autoinc()</code> should be checking <code>$self->_ipk($field)</code> as well as <code>$field->is_auto_increment</code> and <code>auto_increment_method</code>.</p>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br>Reply to this email directly or <a href="https://github.com/dbsrgits/sql-translator/pull/47/files#r22586062">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeApDa5G0JLIgG3lfWZOOtHQx5zq_4ks5nfS_0gaJpZM4DFbLf.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/pull/47/files#r22586062"></link>
<meta itemprop="name" content="View Pull Request"></meta>
</div>
<meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>