Got it!

The column is a boolean type and the SQL select command returns "true" or "false" on terminal but, the BDI only accept "1" or "0" for the boolean type.

Solution: my $ref =  $dbh->selectall_arrayref($sql,undef,'1');