INT to SERIAL in-place alter
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE My question is, why MODIFY INT to SERIAL does not use in-place alter? ------------------------------ Sincerely, Dennis ------------------------------
↪ replying to Dennis Melnikov
It does, these alters are performed in-place since 12.10.xC13: INT -> SERIAL INT -> BIGSERIAL INT -> SERIAL8 BIGINT -> BIGSERIAL BIGINT -> SERIAL8 INT8 -> BIGSERIAL INT8 -> SERIAL8 BR, Andreas ------------------------------ Andreas Legner ------------------------------
↪ replying to Andreas Legner
Andreas, Wonder why this is still not mentioned in the docs, https://www.ibm.com/docs/en/informix-servers/12.10?topic=alter-conditions-in-place-operations ------------------------------ Sincerely, Dennis ------------------------------