On 19-6-2014 16:58, [email protected] [firebird-support] wrote: > I was expecting to see one row for > > "melvin comms directors 30.04.13" and also for "DCFTG210513". > > QUERY > > select '['|| TRIM(SUBSTRING(COMMENTS FROM 1 FOR 100)) || ']', count(*) > from target > group by 1 > having count(*)>5 > order by 1 > > RESULTS > > [null]2289 > [melvin comms directors 30.04.13]17 > [melvin comms directors 30.04.13]52 > [melvin comms directors 30.04.13]18 > [melvin comms directors 30.04.13]8 > [melvin comms directors 30.04.13]6 > [DCFTG210513]14 > [Rackable/SGI]10 > [microsoft james 15.03]15 > [microsoft james 15.03]8 > [NWSEI060613]6 > [DCFTG210513]19 > [DCFTG210513]19 > [lifesiences]7 > [DCFTG210513]37 > [DCFTG210513]17 > ....
Your expectation is right (if this is the actual data, and there is no difference in - for example - whitespace). I'd suggest you try with the latest Firebird version (you didn't mention a version), and file a bug with a database and a script that allows this problem to be reproduced. Don't forget to include the Firebird version in the bug report. Mark -- Mark Rotteveel
