miguel@tikal:~/dbs $ ./55c
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.55 Source distribution PULL: 2016-NOV-05 

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.5 > use test
Database changed
mysql 5.5 > CREATE table test_table(a INT NOT NULL);
Query OK, 0 rows affected (0.19 sec)

mysql 5.5 > INSERT INTO test_table(a) values(1);
Query OK, 1 row affected (0.09 sec)

mysql 5.5 > 
mysql 5.5 > CREATE 
    ->     ALGORITHM = MERGE 
    -> VIEW `test_view` AS
    ->     SELECT 
    ->         IFNULL(`test_table`.`a`, 'why is it here') AS `b`
    ->     FROM
    ->         `test_table`
    ->     WHERE
    ->         FALSE;
Query OK, 0 rows affected (0.10 sec)

mysql 5.5 > 
mysql 5.5 > SELECT * FROM test_table a LEFT JOIN test_view b ON FALSE;
+---+----------------+
| a | b              |
+---+----------------+
| 1 | why is it here |
+---+----------------+
1 row in set (0.00 sec)

mysql 5.5 > 

miguel@tikal:~/dbs $ ./56c
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.36 Source distribution PULL: 2016-NOV-05

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.6 > USE test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql 5.6 > SELECT * FROM test_table a LEFT JOIN test_view b ON FALSE;                                                                 +---+----------------+
| a | b              |
+---+----------------+
| 1 | why is it here |
+---+----------------+
1 row in set (0.00 sec)

mysql 5.6 > 


miguel@tikal:~/dbs $ ./57c
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.18-log Source distribution PULL: 2016-NOV-05

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.7 > use test
Database changed
mysql 5.7 > CREATE table test_table(a INT NOT NULL);
Query OK, 0 rows affected (0.93 sec)

mysql 5.7 > INSERT INTO test_table(a) values(1);
Query OK, 1 row affected (0.00 sec)

mysql 5.7 > 
mysql 5.7 > CREATE 
    ->     ALGORITHM = MERGE 
    -> VIEW `test_view` AS
    ->     SELECT 
    ->         IFNULL(`test_table`.`a`, 'why is it here') AS `b`
    ->     FROM
    ->         `test_table`
    ->     WHERE
    ->         FALSE;
Query OK, 0 rows affected (0.10 sec)

mysql 5.7 > 
mysql 5.7 > SELECT * FROM test_table a LEFT JOIN test_view b ON FALSE;
+---+------+
| a | b    |
+---+------+
| 1 | NULL |
+---+------+
1 row in set (0.00 sec)

mysql 5.7 > 

miguel@tikal:~/dbs $ ./80c
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 8.0.1-dmr Source distribution PULL: 2016-NOV-05

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 8.0 > use test
Database changed
mysql 8.0 > CREATE table test_table(a INT NOT NULL);
Query OK, 0 rows affected (0.80 sec)

mysql 8.0 > INSERT INTO test_table(a) values(1);
Query OK, 1 row affected (0.08 sec)

mysql 8.0 > 
mysql 8.0 > CREATE 
    ->     ALGORITHM = MERGE 
    -> VIEW `test_view` AS
    ->     SELECT 
    ->         IFNULL(`test_table`.`a`, 'why is it here') AS `b`
    ->     FROM
    ->         `test_table`
    ->     WHERE
    ->         FALSE;
Query OK, 0 rows affected (0.09 sec)

mysql 8.0 > 
mysql 8.0 > SELECT * FROM test_table a LEFT JOIN test_view b ON FALSE;
+---+------+
| a | b    |
+---+------+
| 1 | NULL |
+---+------+
1 row in set (0.00 sec)

mysql 8.0 >