Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 83282
Status: open
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: RPORRES [...] cpan.org
Cc: rbo [...] cpan.org
rporres [...] qindel.com
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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: http://www.sqlite.org/autoinc.html There's a pull request in GitHub: https://github.com/dbsrgits/sql-translator/pull/26 Best Regards, Rafael Porres PS. Thanks a lot for the __AWESOME__ work in SQL::Translator. It's been extremely helpful.
Created branch, wait of review: git.shadowcat.co.uk:SQL-Translator.git:people/rbo/Bug#83282 There are some problems with primary key: - doesn't support multi primary key - doesn't support non integer/number primary keys
On Tue Sep 03 12:06:03 2013, rbo wrote: Show quoted text
> Created branch, wait of review: git.shadowcat.co.uk:SQL- > Translator.git:people/rbo/Bug#83282 > > There are some problems with primary key: > - doesn't support multi primary key > - doesn't support non integer/number primary keys
Fixed wait of review.