A subselect with long parameter is wrongly cast to bigint for MySQL. With a query like:
select rsrc,
(select count(mrk.key) from bookmark as mrk where mrk.key=:identityKey) as bookmarks
from resource as rsrc
The parameter identityKey is cast to bigint for MySQL which is incorrect, MySQL only accepts here cast as signed or unsigned. The example is oversimplified and match the test case attached. |