2nd execution of a prepared statement returns wrong results

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (i1 INT, j1 INT NOT NULL, PRIMARY KEY (i1));

INSERT INTO t1 VALUES (30,300),(40,400);

DROP TABLE IF EXISTS t2;

CREATE TABLE t2 (i2 INT);

INSERT INTO t2 VALUES (50),(60);

DROP TABLE IF EXISTS t3;

CREATE TABLE t3 (c3 VARCHAR(20), i3 INT);

INSERT INTO t3 VALUES ('a',10),('b',2);

DROP TABLE IF EXISTS t4;

CREATE TABLE t4 (i4 INT);

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

DROP VIEW IF EXISTS v1;

CREATE VIEW v1 AS select coalesce(j1,i3) AS v1_field1 from t2 join t3 left join t1 on ( i1 = i2 );

DROP VIEW IF EXISTS v2;

CREATE VIEW v2 AS select v1_field1 from t4 join v1;

prepare my_stmt from "select v1_field1 from v2";

execute my_stmt;

execute my_stmt;

deallocate prepare my_stmt;

DROP TABLE t1,t2,t3,t4;

DROP VIEW v1,v2;

1st run

+-----------+

| v1_field1 |

+-----------+

|        10 |

|        10 |

|        10 |

|        10 |

|         2 |

|         2 |

|         2 |

|         2 |

+-----------+

2nd run

MySQL 5.3

+-----------+

| v1_field1 |

+-----------+

|         0 |

|         0 |

|         0 |

|         0 |

|         0 |

|         0 |

|         0 |

|         0 |

+-----------+

MariaDB 10.0

+-------------+

| v1_field1   |

+-------------+

| -1886417009 |

| -1886417009 |

| -1886417009 |

| -1886417009 |

| -1886417009 |

| -1886417009 |

| -1886417009 |

| -1886417009 |

+-------------+