| Subject: | Fix for bug in mysql.pm |
Hi Ivan
I notice that Table::new_native wraps calls to DBD::mysql->columns in
an
eval()
mysql->column contains a die() which gets silently caught by the eval,
which is confusing.
The offending line which causes the die() is:
$_->{'Type'} =~ /^(\w+)\(?([\d\,]+)?\)?( unsigned)?$/
or die "Illegal type: ". $_->{'Type'}. "\n";
I have a type in my schema
char(64) binary
which does not match your regexp.
My hack is to change the regex to
$_->{'Type'} =~ /^(\w+)\(?([\d\,]+)?\)?/
or die "Illegal type: ". $_->{'Type'}. "\n";
This matches, but loses qualifiers such as 'unsigned' and 'binary',
but
this wasn't being stored anyway.
If you could incorporate this into the next release that would be
great
Many thanks for your work in developing this fantastic module!
Chris