5 Feb
2010
5 Feb
'10
3:42 a.m.
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. Also, I have a question: will virtual columns be able to use UDF's? Cheers, Federico