autoIncrement carries to referencing column

[brezinajn]

object Foo: IdTable<Long>(){
    override val id = long("id").autoIncrement().entityId().primaryKey()
}

object Bar: IdTable<Long>(){
    override val id = long("id").autoIncrement().entityId().primaryKey()
}

object Baz: Table(){
    val fooId = reference("fooId", Foo.id)
    val barId = reference("barId", Bar.id)
}

this creates SQL

CREATE TABLE IF NOT EXISTS Baz (
  fooId     BIGINT AUTO_INCREMENT NOT NULL,
  barId     BIGINT AUTO_INCREMENT NOT NULL
...

which cannot succeed. Without the autoIncrement in parent tables everything goes fine.

[brezinajn]

Ugly workaround

object Baz: Table(){
    val fooId = reference("fooId", Foo.id)
    val barId = reference("barId", Bar.id)

    override fun createStatement(): List<String> = super.createStatement()
            .map { it.replace("AUTO_INCREMENT", "") }
}

[Tapac]

Thank you for a report. Fixed in master.
BTW, you can replace your workaround with:

object Baz: Table(){
    val fooId = reference("fooId", Foo)
    val barId = reference("barId", Bar)
}