11 Aug
2017
11 Aug
'17
1:33 p.m.
Hello Jerome, I filed a bug report: MDEV-13500 sql_mode=ORACLE: can't create a virtual column with function MOD It should be enough to fix Item_func_mode::print() to print expressions as: arg1 MOD arg2 instead of arg1 % arg2 I'll try to do it soon. On 08/02/2017 11:03 AM, jerome brauge wrote:
Hello Alexander, Something seems to be wrong in sql_yacc_ora.yy. (10.2-ext branch) We can't create a table with a virtual column because the grammar try to reduce the rule sp_cursor_name_and_offset.
CREATE TABLE t1 (c1 INTEGER, c2 INTEGER AS (c1 MOD 10) VIRTUAL) ENGINE=InnoDb; ERROR 1324 (42000): Undefined CURSOR: c1
Regards, Jérôme.