the negative number and zero will be converted to "0" and positive number will be converted to "1" when converting bool type to smallint type.