This behavior seems correct to me. And PostgreSQL, MySQL, SQL Server, and Oracle all work the same way.