SQL inside an anonymous block is executed with wrong SQL_MODE

create table t1 (a int);

# Query OK, 0 rows affected (0.98 sec)

set sql_mode='';

# Query OK, 0 rows affected (0.00 sec)

select a from t1 having a > 1;

# Empty set (0.01 sec)

delimiter |

begin not atomic select a from t1 having a > 1; end |

# ERROR 1463 (42000): Non-grouping field 'a' is used in HAVING clause

bb-MDEV-5317

commit 6502f42f679e605fcdbd6c8b49d2813f553001b0

Author: Sergei Golubchik <serg@mariadb.org>

Date:   Mon Aug 18 14:28:48 2014 +0200