Comments - Generated (Virtual and Persistent/Stored) Columns
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
It should be noted that some string functions (e.g. UCASE, REVERSE) with CHAR argument are surprisingly not considered deterministic, and therefore could not be simply used in indexed generated columns -- index creation emits error 1901 ("Function or expression '`a`' cannot be used in the GENERATED ALWAYS AS clause of `b`"). This has been errorneously reported as a bug (not by me) two years ago here: https://jira.mariadb.org/browse/MDEV-29777. See that URL for more information and a workaround.