Comments - Generated (Virtual and Persistent/Stored) Columns

5 years, 5 months ago p769RqVm9vIuZELGoGhrCQAWLHo

Are there plans to add support for using deterministic stored functions in the definition of a virtual column?

I could just make a new view that selects all the entries from the table and then applies the functions to the new columns, but I would prefer to keep the data in the same table rather than in a separate view. More importantly, the virtual columns allow me to refer to the value of previously-defined columns but defining a view for this derived data either requires me to use a doubly-nested subquery or to manually expand the column definitions until they no longer require reference to previous columns.

 
5 years, 5 months ago Sergei Golubchik

Not at the moment, sorry. But you can create a task at jira.mariadb.org to make sure your request isn't forgotten.

 
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.