my $integer = ($driver_name =~ /^mysql/) ? 'UNSIGNED INTEGER' : 'INTEGER';
- 'CAST('. $class->condition_sql_option($option). " AS $integer )";
+ 'CAST(
+ COALESCE('. $class->condition_sql_option($option).
+ " ,'0') ".
+ " AS $integer )";
}
=head1 NEW CONDITION CLASSES