NO_AUTO_VALUE_ON_ZERO is ignored when a trigger before insert is defined

set session sql_mode ='NO_AUTO_VALUE_ON_ZERO';

drop table if exists test;

create table test (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,  PRIMARY KEY (`id`));

insert into test (id) values (0);

select id from test;

#+----+

# | id |

# +----+

# |  0 |

# +----+

drop table if exists test;

create table test (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,  PRIMARY KEY (`id`));

drop trigger if exists test_before_insert;

delimiter ;;

CREATE TRIGGER `test_before_insert` 

BEFORE INSERT ON `test` 

FOR EACH ROW 

BEGIN

END ;;

delimiter ;

insert into test (id) values (0);

select id from test;

# +----+

# | id |

# +----+

# |  1 |

# +----+