<p>In lib/SQL/Translator/Producer/SQLite.pm:</p>
<pre style='color:#555'>> @@ -471,13 +481,62 @@ sub batch_alter_table {
> %temp_table_fields = map { $_ => 1} $table->get_fields;
> };
>
> - push @sql, "INSERT INTO @{[_generator()->quote($table_name.'_temp_alter')]}( @{[ join(', ', map _generator()->quote($_), grep { $temp_table_fields{$_} } $old_table->get_fields)]}) SELECT @{[ join(', ', map _generator()->quote($_), grep { $temp_table_fields{$_} } $old_table->get_fields)]} FROM @{[_generator()->quote($old_table)]}",
> - "DROP TABLE @{[_generator()->quote($old_table)]}",
> - create_table($table, { no_comments => 1 }),
> - "INSERT INTO @{[_generator()->quote($table_name)]} SELECT @{[ join(', ', map _generator()->quote($_), $table->get_fields)]} FROM @{[_generator()->quote($table_name.'_temp_alter')]}",
> - "DROP TABLE @{[_generator()->quote($table_name.'_temp_alter')]}";
> - return @sql;
> -# return join("", @sql, "");
> + # record renamed fields for later
> + my %rename_field;
> + if ( @{$diffs->{rename_field}} ) {
> + foreach my $rf_diff ( @{$diffs->{rename_field}} ) {
</pre>
<p>No need for the if here, the for loop will just execute zero times if the array is empty.</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/39/files#r16471950">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/302594__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcyNDE1NjQ5MiwiZGF0YSI6eyJpZCI6MzQ5NTcwMjB9fQ==--d36bfe008362c76f04d3aa4dfcf60ffaa1ee50a0.gif" width="1" /></p>