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