[Maria-developers] Virtual columns in sql_mode=ORACLE

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.

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.
participants (2)
-
Alexander Barkov
-
jerome brauge