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 |
+-------------+