Many-to-many: NoSuchElementException: List is empty

[matthjes]

Hi,

I'm trying to get a many-to-many relationship working. Here are the relevant classes:

object Fragments : IdTable<Long>(name = "fragments") {
    override val id = long("id").primaryKey().entityId()
    val contentText = text("content_text")
    val contentBinary = blob("content_binary")
}

class Fragment(timestamp: EntityID<Long>) : LongEntity(timestamp) {
    companion object : LongEntityClass<Fragment>(Fragments)

    var contentText by Fragments.contentText
    var contentBinary by Fragments.contentBinary
    var contexts by ContextElement via FragmentToContexts
}

object ContextElements : LongIdTable(name = "context_elements") {
    val name = text("name")
}

class ContextElement(id: EntityID<Long>) : LongEntity(id) {
    companion object : LongEntityClass<ContextElement>(ContextElements)

    var name by ContextElements.name
    var parents by ContextElement.via(ContextToContexts.child, ContextToContexts.parent)
    var children by ContextElement.via(ContextToContexts.parent, ContextToContexts.child)
    var fragments by Fragment via FragmentToContexts
}

object ContextToContexts : Table("context_to_contexts") {
    val parent = reference("parent_id", ContextElements)
    val child = reference("child_id", ContextElements)
}

object FragmentToContexts : Table("fragment_to_contexts") {
    val fragment = reference("fragment_id", Fragments).primaryKey(0)
    val contextElement = reference("context_element_id", ContextElements).primaryKey(1)
}

When I try to create a new fragment:

transaction {
    val fragment = Fragment.new(System.currentTimeMillis()) {
        contentText = value
    }
}

then I get the following error message:

java.util.NoSuchElementException: List is empty.
	at kotlin.collections.CollectionsKt___CollectionsKt.last(_Collections.kt:362)
	at org.jetbrains.exposed.sql.statements.BatchInsertStatement.allColumnsInDataSet(BatchInsertStatement.kt:61)
	at org.jetbrains.exposed.sql.statements.BatchInsertStatement.getArguments(BatchInsertStatement.kt:65)
	at org.jetbrains.exposed.sql.statements.InsertStatement.arguments(InsertStatement.kt:148)
	at org.jetbrains.exposed.sql.QueriesKt.batchInsert(Queries.kt:100)
	at org.jetbrains.exposed.sql.QueriesKt.batchInsert$default(Queries.kt:61)
	at org.jetbrains.exposed.dao.EntityCache.flushInserts$exposed_dao(EntityCache.kt:96)
	at org.jetbrains.exposed.dao.EntityCache.flush(EntityCache.kt:53)
	at org.jetbrains.exposed.dao.EntityCache.flush(EntityCache.kt:47)
...

Did I miss anything?

[mpe85]

After upgrade from 0.17.7 to 0.19.1 I experience the same error when calling Entity::refresh() (flush=true or flush=false does not matter).

java.util.NoSuchElementException: List is empty.
	at kotlin.collections.CollectionsKt___CollectionsKt.last(_Collections.kt:362)
	at org.jetbrains.exposed.sql.statements.BatchInsertStatement.allColumnsInDataSet(BatchInsertStatement.kt:61)
	at org.jetbrains.exposed.sql.statements.BatchInsertStatement.getArguments(BatchInsertStatement.kt:65)
	at org.jetbrains.exposed.sql.statements.InsertStatement.arguments(InsertStatement.kt:148)
	at org.jetbrains.exposed.sql.QueriesKt.batchInsert(Queries.kt:128)
	at org.jetbrains.exposed.sql.QueriesKt.batchInsert$default(Queries.kt:89)
	at org.jetbrains.exposed.dao.EntityCache.flushInserts$exposed_dao(EntityCache.kt:98)
	at org.jetbrains.exposed.dao.DaoEntityID.invokeOnNoValue(DaoEntityID.kt:9)
	at org.jetbrains.exposed.dao.id.EntityID.getValue(EntityID.kt:8)
	at org.jetbrains.exposed.dao.EntityCache.remove(EntityCache.kt:41)
	at org.jetbrains.exposed.dao.EntityClass.removeFromCache(EntityClass.kt:73)
	at org.jetbrains.exposed.dao.Entity.refresh(Entity.kt:38)

It happens for all entities I call Entity::refresh() on regardless of whether there is a many-to-many relation or not.

[Tapac]

@matthjes, @mpe85 , could you please file a test with mapping and part where code fails?
I was trying to update ViaTest.kt without any success.

Patch to that test also will be great.

[Tapac]

It should be fixed in master and released in a few days.