22 Jul
2010
22 Jul
'10
9:59 a.m.
When one sees this pair of codes ER_CONST_EXPR_IN_VCOL and ER_ROW_EXPR_FOR_VCOL, one can't help asking himself whether that's the only disallowed expressions, and if not, do we have error codes for vcol expressions with - user variables - subqueries - SP calls - etc, etc. Do we handle such cases at all?
Hello, I checked our implementation and the Oracle and MS SQL Server documentation . We disallow subqueries, stored procedures and functions, but we allow user variables. The other database products are mostly stricter than we are, and I opened a new bug regarding the more relaxed rules in MariaDB and the issues this can cause. https://bugs.launchpad.net/maria/+bug/608641