Invalid default value when using defaultNow()

Receiving error:

Invalid default value for 'updated_at' (errno 1067) (sqlstate 42000) (CallerID: 2ga5bxx7mhtso265npy7): Sql: "alter table menus add UNIQUE INDEX menus_public_id_idx (public_id)", BindVars: {REDACTED}`

Seems to happen where there is uniqueindex on table

is it PlanetScale?

Yes

Any updates on this?

Yeah, sorry
Could you please explain steps to reproduce?
Does this error happen in insert/select?
Or do you see it while running migrations?

It happens on drizzle-push. If I have defaultNow() on one of the columns, it starts to complain when I am trying to add indexes or push another update

Not sure if this is somethikng on Planetscales side?

Intersseing someone having similar issue here without Drizzle

This seems to solve it

So it seems like it was some sort of PlanetScale issue

Yeah, so the case is that PlanetScale have some issues with using default (now())

I would suggest using

default(sql`CURRENT_TIMESTAMP`)

For “default now” with PlanetScale

Try to regenerate table with this default and then it should work properly

We will add .defaultCurrentTimestamp() for PlanetScale cases