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. > _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
