Hi, Roberto! On Jun 19, Roberto Spadim wrote:

hi guys i'm trying to implement MDEV-4579<https://mariadb.atlassian.net/browse/MDEV-4579>, could anyone help me with parser + warning generation?

MDEV-4579 title: SQL PARSER - Add Ignore to SET SQL command

example:

SET @@some_global_variable_that_dont_exists=1 *this cause an error*

SET @@some_global_variable_that_dont_exists=1,@@some_variable_that_exists_and_should_be_changed=3 *this cause an error and don't change the second variable*

*could we implement:* SET *IGNORE * @@some_global_variable_that_dont_exists=1,@@some_variable_that_exists_and_should_be_changed=3 *this cause an warning (first variable don't exists) and change the second variable*

Okay. Look for find_sys_var function in the sql_yacc.yy. Whenever it fails, the parsing is aborted. That's what you want to change. Regards, Sergei