Built In SQL Functions not working with sql_mode=ORACLE

MariaDB [(none)]> create database tests;

Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> use tests;

Database changed

MariaDB [tests]> create table foo (id INT, myname varchar(30))engine = innodb;

Query OK, 0 rows affected (0.012 sec)

MariaDB [tests]> create table bar (id INT, myname varchar(30))engine = columnstore;

Query OK, 0 rows affected (0.285 sec)

MariaDB [tests]> INSERT INTO foo VALUES (1,'Monty Widenius');

Query OK, 1 row affected (0.003 sec)

MariaDB [tests]> INSERT INTO bar VALUES (1,'Monty Widenius');

Query OK, 1 row affected (15.549 sec)

MariaDB [tests]> SET SESSION sql_mode=ORACLE;

Query OK, 0 rows affected (0.000 sec)

MariaDB [tests]> SELECT CONCAT(id,myname) FROM foo;

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

| CONCAT(id,myname) |

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

| 1Monty Widenius     |

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

1 row in set (0.001 sec)

MariaDB [tests]> SELECT CONCAT(id,myname) FROM bar;

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

| CONCAT(id,myname) |

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

| 1                 |

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

1 row in set (0.073 sec)