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