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