| Subject: | sqlite_version => 3.3 has no effect on generating IF EXISTS |
I'm trying to deploy a schema to a SQLite database that may exist
already or not. To do that, I'm passing to deploy() these arguments:
{
add_drop_table => 1,
sqlite_version => 3.3 # for DROP TABLE *IF EXISTS*
}
With Producer::SQLite 1.59, passing that hashref to deploy() does not
generate "DROP TABLE IF EXISTS" statements. It only generates "DROP
TABLE". When generating the statements, in
SQLite::Producer::create_table, sqlite_version is 0.
I've traced the source of it becoming 0 to SQL::Translator::init, which
appears to do nothing with this parameter, so that the line
my $tr = SQL::Translator->new(%$sqltargs);
in DBIx::Class::Storage::deployment_statements() is where sqlite_version
is lost.