2656767 - Implicit subquery producing wrong results

The following query does not produce the correct results, it should return the max value of ID 12345 but returns nothing

select *
from TestTable
where IDColumn = "12345" and ValueColumn =
(select max(ValueColumn)
from TestTable b
where IDColumn = b.IDColumn)

Adaptive Server Enterprise

implicit, explicit, subquery, subqueries , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem