Wrong result on second execution of prepare statement from view create with left join (merged derived table)

create table t1 (

  Election int(10) unsigned NOT NULL

);

insert into t1 (Election) values (1);

create table t2 (

  VoteID int(10),

  ElectionID int(10),

  UserID int(10)

);

insert into t2 (ElectionID, UserID) values (2,  30), (3, 30);

create view v1 as select * from t1

  left join ( select 'Y' AS Voted, ElectionID from t2 ) AS T 

    on T.ElectionID = t1.Election

limit 9;

prepare stmt1 from "select * from v1";

execute stmt1;

execute stmt1;

deallocate prepare stmt1;

drop view v1;

drop table t1, t2;

execute stmt1;

Election	Voted	ElectionID

1	NULL	NULL

execute stmt1;

Election	Voted	ElectionID

1		NULL

execute stmt1;

Election	Voted	ElectionID

1	NULL	NULL

execute stmt1;

Election	Voted	ElectionID

1	NULL	NULL