I'm trying to modify an existing value in my updat...

# exposed

[zt]

I'm trying to modify an existing value in my update statement as follows

Guild.update({ Guild.id eq guild.id.toString() }) {
    it[data] = data + "abc"
}

For some reason, it always sets the value to "0"
The table is defined like this

object Guild : Table() {
    val id = varchar("id", 18)
    val data = text("data").default("")

    override val primaryKey = PrimaryKey(id)
}

If I use it[data] = "whatever" then it actually sets to the proper value

[dave08]

There's probably a concat function... I don't think you can append a field's value like that... How would exposed know how to generate the sql for that?

[zt]

https://github.com/JetBrains/Exposed/wiki/DSL#update

[spand]

From the looks of it you are not wrapping it in with(SqlExpressionBuilder) { as the example is

[zt]

I tried that too but nothing changed

[Bogdan]

Feature not supported: "CLOB +"; SQL statement:
UPDATE GUILD SET "DATA"=(GUILD."DATA" + '1') WHERE GUILD.ID = '1'

[Bogdan]

Guild.update({ Guild.id eq guildId }) {
    it[value] = value + 1 //  work, import org.jetbrains.exposed.sql.SqlExpressionBuilder.plus
    with(SqlExpressionBuilder) {
         it[value] = value + 1 // work
        // it[data] = data + "1" not work, error
        it[data] = concat(data, stringLiteral("123"))
    }
}

value = integer
log:

SQL: UPDATE GUILD SET "VALUE"=(GUILD."VALUE" + 1), "DATA"=CONCAT(GUILD."DATA", '123') WHERE GUILD.ID = '1'
com.example.Guild.id=1, com.example.Guild.data=clob1: 'data123', com.example.Guild.value=1

[Bogdan]

import org.jetbrains.exposed.sql.*
import org.jetbrains.exposed.sql.SqlExpressionBuilder.concat
import org.jetbrains.exposed.sql.SqlExpressionBuilder.plus // +
import org.jetbrains.exposed.sql.transactions.transaction

fun main() {
// transaction 
Guild.update({ Guild.id eq guildId }) {
    it[value] = value + 1 
    it[data] = concat(data, stringLiteral("123"))
}

object Guild : Table() {
    val id = varchar("id", 18)
    val data = text("data").default("")
    val value = integer("value").default(0)

    override val primaryKey = PrimaryKey(id)
}

[zt]

This worked, thank you so much!