I get this error: `... don't have client default values. DB defaults don't support in batch inserts`...

# exposed

[oshai]

I get this error: ... don't have client default values. DB defaults don't support in batch inserts why is that not supported?

[tapac]

Could you provide full sample to test it?

[oshai]

@tapac look at the example on this gist: https://gist.github.com/oshai/99f5c907d27db923490b02027a55b295

[oshai]

in my case create_date is timestamp (mysql db) with default of current_timestamp

[tapac]

with default of current_timestamp

this default is available only in database nor code?

[oshai]

There is a default in the database, if I put default in the code it caused it to have my service startup time as default

[oshai]

so I have to omit that

[tapac]

You can use defaultExpression(CurrentDateTime) function on column

[oshai]

so in such case in any update to the row it will update the create_date? if that is the case it is not a good solution because I want the row to have the initial value when it was inserted.

[tapac]

I wrote simple test and looks like update ignores defaultExpression if that column is absent from update:
https://gist.github.com/Tapac/2518c19cbeefc6be6e56cfa850ed18db

[oshai]

Thanks, is there any rule when exactly is it added so I can see in the code and document it?

[tapac]

Looks like defaultExpression never used in updates. In inserts it used when defaultExpression placed on non nullable column which absent from insert statement.