maria-discuss team mailing list archive

[Henrik Ingo <henrik.ingo@xxxxxxxxxxxxx>]

On Tue, Nov 9, 2010 at 5:03 AM, Federico Razzoli <federico_raz@xxxxxxxx> wrote:
> Hello
>
> I've read in the documentation that any legal SQL expression SHOULD be allowed
> in the Virtual Columns definition.

That opening statement (on http://kb.askmonty.org/v/virtual-columns)
is misleading in many ways and I've commented on the article but it is
not yet fixed.
 - subqueries or anything that depends on data outside the row is not possible
 - only deterministic functions are possible
 - UDF and stored functions are not possible


henrik

-- 
henrik.ingo@xxxxxxxxxxxxx
+358-40-5697354
www.openlife.cc