In your case you should use `insertAndGetId` When you write `insert[id]` you try to get value relate...

# exposed

[tapac]

In your case you should use insertAndGetId
When you write insert[id] you try to get value related to "expression" from resultSet. It can be null if, for example, it wasn't inserted, that's why column type (not-nullable) doesn't make sense.

[ziad]

Hi, I’m getting the same error after updating, can you share an example of using insertAndGetId?

[ziad]

@oshai maybe you can help? 🙂

[ziad]

I think I found an example in the wiki! So good to see some documentation ^^

[ziad]

Okay, I think I just noticed a minor thing (perhaps intended).

object StarWarsFilms : Table() {
  val id: Column<Int> = integer("id").autoIncrement().primaryKey()
}

this doesn’t support insertAndGetId

object StarWarsFilms : IntIdTable() {
  
}

this does