maria-developers team mailing list archive
Mailing list archive
Re: Renaming Virtual Columns to Computed Columns
1) As regards terminology, IMHO it would be logical if 'computed' is used
as the "upperlevel" term. "sublevel' terms would be 'virtual' and
'persistent' (ie. a 'computed' column may be either 'virtual' or
2) It is not clear to me if this also proposes a change to DDL syntax used
since MariaDB 5.2 or if it is only a discussion for docs. etc.??
3) Oracle has published a MySQL 5.7 'labs' build with a similar feature. It
would be nice if some coordination could happen! :-)
On Mon, Jan 19, 2015 at 2:28 PM, Martijn Tonies (Upscene Productions) <
> Hello Ian,
> IMO, makes perfect sense.
> With regards,
> Martijn Tonies
> Upscene Productions
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
> There was a suggestion on the docs mailing list that we rename Virtual
> Columns to Computed Columns. I think it makes sense, but before we
> implement I want to make sure everyone is happy with the change, so am
> repeating it here as not everyone follows docs.
> Currently, we use the term Virtual Columns (see
> Oracle uses this term, while MS SQL and Firebird use the term Computed
> Columns to describe similar functionality.
> MariaDB's virtual column implementation has both persistent and virtual
> attributes. Talking of "virtual virtual" and "persistent virtual" can be
> confusing. Oracle's implementation, to my knowledge, only has virtual
> virtual, while MS SQL's Computed Columns offers both persistent
> ("persisted" in their case) and virtual.
> I think "Computed" is a slightly more descriptive term, and avoids the
> ambiguity of "persistent virtual" and "virtual virtual". The MariaDB
> error messages already use the term computed, for example "Constant
> expression in computed column function is not allowed".
> Unless anyone has a good reason to prefer the term virtual, we're going
> to rather use the term "computed column" in the docs. The article will
> still mention virtual column as an alternative etc, but computed will be
> the preferred term.
> Mailing list: https://launchpad.net/~maria-developers
> Post to : maria-developers@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help : https://help.launchpad.net/ListHelp