| Subject: | SQLite producer error with default varchar |
running perl 5.10.0, OS 10.6
using the following
create table test (test varchar(8) default TEST)
translating to DBIx:Class
generates the following
...
"test",
{
data_type => "varchar",
default_value => "TEST",
is_nullable => 1,
size => 8,
},
...
translating back to SQLite makes the table
create table test (test varchar(8) default 'TEST')
once more to DBIx::Class gives
...
"test",
{
data_type => "varchar",
default_value => "'TEST'",
is_nullable => 1,
size => 8,
},
...
n.b. the extra single quotes. Further attempts to translate back to SQLite fail.