[DBIx-Class-Devel] [dbsrgits/sql-translator] Inconsistent behavior of MySQL producer with boolean columns (#81)

[Fabrice Gabolde]

@ribasushi I narrowed it down to SQL::Translator::Diff, when building an SQL::Translator object in [`produce_sql_diff`](https://github.com/dbsrgits/sql-translator/blob/master/lib/SQL/Translator/Diff.pm#L276).

It should be:

```perl
      my $translator = SQL::Translator->new(
        producer_type => $self->output_db,
        add_drop_table => 0,
        no_comments => 1,
        producer_args => $self->producer_args
      );
```

otherwise the SQL::Translator constructor gets `mysql_version` directly as an argument. Obviously it wouldn't know what to do with a MySQL-specific argument, so it just gets thrown away.

The MySQL producer's `produce` method is then called a few lines later with that translator instance.

With this fix I can get my boolean column. I still have backticks everywhere, which is aesthetically annoying but I can live with that. :)

---
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/dbsrgits/sql-translator/issues/81#issuecomment-203932591
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/20160331/0de884ac/attachment.htm>