SQLite Forum

COUNT statement returns inconsistent values when used with UNION ALL
Login
So the count(*) is not inconsistent when comparing the two versions, although if a select * returns four rows, one would think a select count(*) should, for consistency, return 4.