MariaDB [test]> SELECT VERSION();

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

| VERSION()      |

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

| 10.2.5-MariaDB |

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

1 row in set (0.00 sec)

MariaDB [test]> SELECT @@sql_mode;

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

| @@sql_mode                                                                                |

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

| STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

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

1 row in set (0.00 sec)

MariaDB [test]> SELECT CONCAT('FOO','BAR');

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

| CONCAT('FOO','BAR') |

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

| FOOBAR              |

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

1 row in set (0.00 sec)

MariaDB [test]> CREATE OR REPLACE VIEW t AS SELECT CONCAT('FOO','BAR');

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> SELECT * FROM t;

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

| CONCAT('FOO','BAR') |

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

| FOOBAR              |

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

1 row in set (0.00 sec)

MariaDB [test]> SET sql_mode='Oracle';

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> SELECT CONCAT('FOO','BAR');

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

| CONCAT('FOO','BAR') |

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

| FOOBAR              |

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

1 row in set (0.00 sec)

MariaDB [test]> CREATE OR REPLACE VIEW t AS SELECT CONCAT('FOO','BAR');

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> SELECT * FROM t;

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

| CONCAT('FOO','BAR') |

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

|                   0 |

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

1 row in set, 4 warnings (0.00 sec)

MariaDB [test]> SHOW WARNINGS;

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

| Level   | Code | Message                                  |

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

| Warning | 1292 | Truncated incorrect INTEGER value: 'FOO' |

| Warning | 1292 | Truncated incorrect INTEGER value: 'BAR' |

| Warning | 1292 | Truncated incorrect DOUBLE value: 'FOO'  |

| Warning | 1292 | Truncated incorrect DOUBLE value: 'BAR'  |

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

4 rows in set (0.00 sec)

MariaDB [test]>