UPDATE table_name SET column1 = value1 and column2 = value2 does not throw error

In MariaDB, the following statement does not throw an error, but it is executed successfully

• intended query

  UPDATE table_name SET column1 = value1 and column2 = value2;

• should return an error

  UPDATE table_name SET column1 = value1 and column2 = value2;

Here is the example:

CREATE TABLE tbl(a INT, b INT);

INSERT INTO tbl VALUES(1,1),(2,2);

SELECT * FROM tbl;

----------------------

     a       b  

------  --------

     1         1

     2         2

UPDATE tbl SET a = 3 AND b = 3;

SELECT * FROM tbl;

-------------------------

     a       b  

------  --------

     0         1

     0         2

Above, a was updated with 0, which is incompatible with other databases such as SQL server or Oracle.