last_insert_id gives 0 when 0 is explicitly specified for an auto_increment primary key in an insertion

last_insert_id gives 0 when 0 is explicitly specified for an auto_increment primary key in an insertion #8879