Re: [Maria-discuss] virtual columns

2010-11-08 Thread Sergei Golubchik
Hi, Federico! On Nov 09, Federico Razzoli wrote: > Hello > > I've read in the documentation that any legal SQL expression SHOULD be > allowed > in the Virtual Columns definition. I'm trying to use a (deterministic) stored > function, but I get an error: > ERROR 1642 (HY000): Function or expres

Re: [Maria-discuss] virtual columns

2010-11-08 Thread Justin Swanhart
Hi, I don't believe that UDF or stored functions are compatible with virtual columns. This makes sense, since these functions could be dropped after the table is created. --Justin On Mon, Nov 8, 2010 at 7:03 PM, Federico Razzoli wrote: > Hello > > I've read in the documentation that any legal

[Maria-discuss] virtual columns

2010-11-08 Thread Federico Razzoli
Hello I've read in the documentation that any legal SQL expression SHOULD be allowed in the Virtual Columns definition. I'm trying to use a (deterministic) stored function, but I get an error: ERROR 1642 (HY000): Function or expression is not allowed for column 'vc1' Here's my create table: CRE