I'm getting some odd error regarding with DAOs when writing tests

<http://dao.Companies.org|dao.Companies.org>_id is not in record set

. All tables are created in the same transaction as the test then everything is rolled back. I've tried using both H2 and SQLite, getting same error with both.. Not sure where to start looking. Most search hits seems to be related to renaming the id column, but this is a FK to another entity

That message sounds like the column isn't being selected from the database or an invalid value being assigned to the column. Do you have a link to or a snippet of the test code? Are you using select or slice to adjust the columns?

There's no slicing or stuff like that. In fact, the entity/table mentioned is not even involved in the query triggering the exception.. But I guess that's due to a flush happening as a result of the query taking place? I have an entity called

Organisation

with a 1-* relationship with

OrganisationFeature

that I'm querying as such:

fun isEnabled(organisation: Organisation) =
        organisation.features.any { it.feature == this }

The above call triggers the exception mentioning

Company

which is only involved at the call site, like this:

when (TEAM_LEAD_AS_PROJECT_MANAGER.isEnabled(project.company.organisation)) {
            true -> activeManagers(project)
            false -> emptyList()
        }