[Dbix-class] DBIC::Schema::Loader::DBI::SQLite unique constraint

[Hideo Kimura]

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.

hide