On 4/9/07, Hideo Kimura <[EMAIL PROTECTED]> wrote:
Hi,
Current version of DBIC::Schema::Loader::DBI::SQLite search UNIQUE
constraint case sesitive without 'i' option in regex.
which means,
create table users (
username text not null UNIQUE,
...
is ok, add_unique_constraint works automatically.
however,
create table users (
username text not null unique,
...
doesn't work.
Is there any reason?
I'm just curious, because other constraint (ex. FOREIGN) is not case
sensitive.
It's just a bug, I'll fix it. The SQLite.pm in Loader is some of the
oldest code in there, it dates back to DBIx::Class::Loader and hasn't
ever really been properly refactored. It's very fragile :)
-- Brandon
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
