COPY ALTER causes a dependent expression default to evaluate as NULL on later inserts

CREATE DATABASE defaults_test;

USE defaults_test;

CREATE TEMPORARY TABLE altered (a INT, b INT DEFAULT (a + 1)) ENGINE=Aria;

INSERT INTO altered(a) VALUES (1);

ALTER TABLE altered ADD c INT DEFAULT (b + 1), ALGORITHM=COPY;

CREATE TEMPORARY TABLE control (a INT, b INT DEFAULT (a + 1), c INT DEFAULT (b + 1)) ENGINE=Aria;

INSERT INTO altered(a) VALUES (10);

INSERT INTO control(a) VALUES (10);

SELECT 'altered' AS variant,a,b,c FROM altered ORDER BY a;

SELECT 'control' AS variant,a,b,c FROM control;

SELECT 'oracle' AS check_name,

       (SELECT COUNT(*) FROM altered WHERE a=1 AND b=2 AND c=3)=1 AS copy_ok,

       (SELECT COUNT(*) FROM altered WHERE a=10 AND b=11 AND c=12)=1 AS insert_ok,

       (SELECT COUNT(*) FROM control WHERE a=10 AND b=11 AND c=12)=1 AS control_ok;

DROP TEMPORARY TABLE altered,control;

DROP DATABASE defaults_test;

variant  a   b   c

altered  1   2   3

altered  10  11  NULL

variant  a   b   c

control  10  11  12

check_name  copy_ok  insert_ok  control_ok

oracle      1        0          1