The unsigned flag in Item was not propagated through the single value subqueries.
This caused the result to be treated as signed.