Deleting entity after it is created does not delete it from cache

[kiliangrashoff]

If an entity is deleted after creation, but before the EntityCache is flushed, it is not deleted from the cache and will be returned by findById(id: ID) in the same transaction block. The behaviour I would expect is that the entity is deleted from the cache, and that findById(id: ID) would return null. Flushing the cache before delete, or opening a new transaction block before deleting the entity fixes the issue.

Reproduction case:

import org.jetbrains.exposed.dao.UUIDEntity
import org.jetbrains.exposed.dao.UUIDEntityClass
import org.jetbrains.exposed.dao.id.EntityID
import org.jetbrains.exposed.dao.id.UUIDTable
import org.jetbrains.exposed.sql.Database
import org.jetbrains.exposed.sql.SchemaUtils
import org.jetbrains.exposed.sql.transactions.transaction
import java.util.*

object Tests : UUIDTable("tests")

class Test(id: EntityID<UUID>) : UUIDEntity(id) {
	companion object : UUIDEntityClass<Test>(Tests)
}

fun main() {
	Database.connect(
		url = "db url",
		driver = "db driver",,
		user = "db user",
		password = "db password",
	)
	transaction {
		SchemaUtils.create(Tests)
		val testEntity = Test.new { }
		val testEntityId = testEntity.id.value
		testEntity.delete()
		println(Test.findById(testEntityId) == null) // actual: false, expected: true
		SchemaUtils.drop(Tests)
	}
}

Affected versions: 0.22.1 and 0.29.1 (others not tested)
Database: PostgreSQL 42.2.6