|CC:||rporres [...] qindel.com|
|Subject:||SQLite Generator does not correctly handle AUTOINCREMENT in primary keys|
SQLite generator doesn't do anything with autoincrement in primary keys. Trying to generate a table with this code: my $table = SQL::Translator::Schema::Table->new( name => 'foo_auto_increment', ); $table->add_field( name => 'id', data_type => 'integer', is_nullable => 0, is_auto_increment => 1, ); $table->primary_key('id'); would create an "id" row such as "id" INTEGER PRIMARY KEY NOT NULL instead of "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL as expected. The difference of each is well explained in SQLite docs:There's a pull request in GitHub: Best Regards, Rafael Porres PS. Thanks a lot for the __AWESOME__ work in SQL::Translator. It's been extremely helpful.