MariaDB [test]> create table c1(a int)engine=columnstore;
|
Query OK, 0 rows affected (0.389 sec)
|
|
MariaDB [test]> create table i1(b int);
|
Query OK, 0 rows affected (0.012 sec)
|
|
MariaDB [test]> show variables like 'autocommit';
|
+---------------+-------+
|
| Variable_name | Value |
|
+---------------+-------+
|
| autocommit | ON |
|
+---------------+-------+
|
1 row in set (0.001 sec)
|
|
MariaDB [test]> insert into c1 values (1);
|
Query OK, 1 row affected (0.167 sec)
|
|
MariaDB [test]> select * from c1;
|
+------+
|
| a |
|
+------+
|
| 1 |
|
+------+
|
1 row in set (0.064 sec)
|
|
MariaDB [test]> set autocommit=0;
|
Query OK, 0 rows affected (0.000 sec)
|
|
MariaDB [test]> insert into i1 values (1);
|
Query OK, 1 row affected (0.001 sec)
|
|
MariaDB [test]> select * from i1;
|
+------+
|
| b |
|
+------+
|
| 1 |
|
+------+
|
1 row in set (0.000 sec)
|
|
MariaDB [test]> select * from c1, i1 where c1.a=i1.b;
|
Empty set (0.013 sec)
|
|
MariaDB [test]> set autocommit=1;
|
Query OK, 0 rows affected (0.002 sec)
|
|
MariaDB [test]> select * from i1;
|
+------+
|
| b |
|
+------+
|
| 1 |
|
+------+
|
1 row in set (0.001 sec)
|
|
MariaDB [test]> select * from c1, i1 where c1.a=i1.b;
|
+------+------+
|
| a | b |
|
+------+------+
|
| 1 | 1 |
|
+------+------+
|
1 row in set (0.013 sec)
|