maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Monty!

On Apr 13, Michael Widenius wrote:
> revision-id: a1440737662 (mariadb-10.5.2-553-ga1440737662)
> parent(s): 04a13e6ab8f
> author: Michael Widenius <michael.widenius@xxxxxxxxx>
> committer: Michael Widenius <michael.widenius@xxxxxxxxx>
> timestamp: 2021-03-24 19:51:22 +0200
> message:
> 
> MDEV-20021 sql_mode="oracle" does not support MINUS set operator
> 
> MINUS is mapped to EXCEPT
> 
> diff --git a/sql/sql_yacc.yy b/sql/sql_yacc.yy
> index 57ba9df42c0..edd2f353dd0 100644
> --- a/sql/sql_yacc.yy
> +++ b/sql/sql_yacc.yy
> @@ -16037,6 +16038,7 @@ reserved_keyword_udt_not_param_type:
>          | MINUTE_MICROSECOND_SYM
>          | MINUTE_SECOND_SYM
>          | MIN_SYM
> +        | MINUS_ORACLE_SYM
>          | MODIFIES_SYM
>          | MOD_SYM
>          | NATURAL

this is not good. MINUS should be in reserved_keyword_udt_not_param_type
only in oracle mode, and otherwise it should be in
keyword_sp_var_and_label (or not a keyword at all, but I don't think
it's possible).

Regards,
Sergei
VP of MariaDB Server Engineering
and security@xxxxxxxxxxx