maria-discuss team mailing list archive

[Oleksandr Byelkin <sanja@xxxxxxxxxxxx>]

Hi!

5 февр. 2010, в 04:42, Federico Razzoli написал(а):

> I've read that MariaDB 5.2 will support virtual columns and I've  
> read the virtual columns' specifications:
>
> http://forge.mysql.com/wiki/MySQL_virtual_columns_ref_manual
>
> I think there is a problem in that document. In CREATE TABLE and in  
> ALTER TABLE commands you can create a virtual column. The syntax  
> allows to specify that the column is STORED, if you wish. But it  
> does not allow to specify that it's NOT STORED. This causes a little  
> problem: one can not switch a STORED column to NOT STORED - one must  
> to DROP and re-ADD the column.

Our syntax is
 <type>  [GENERATED ALWAYS]  AS   ( <expression> )  [VIRTUAL |  
PERSISENT]

default is persistent. Syntax changed to be more compatible with MS  
SQL and Oracle

> Also, I have a question: will virtual columns be able to use UDF's?

Any legal expression which can be calculated should be allowed.