I'm getting some odd error regarding with DAOs whe...

# exposed

[Emil Kantis]

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

[Marcus Ilgner]

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?

[Emil Kantis]

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()
        }

[Emil Kantis]

Found the issue..

class OrganisationFeature(id: EntityID<Int>) : IntEntity(id) {
    companion object : IntEntityClass<OrganisationFeature>(OrganisationFeatures)

    var organisation by Organisation referencedOn Companies.organisationId
    var feature by OrganisationFeatures.feature
}