$ docker build -t sampleteam/sampledb:0.1 .
|
$ docker run --privileged -d --name sampledb -p 2222:22 -p 3306:3306 sampleteam/sampledb:0.1 /sbin/init
|
$ vim ~/.ssh/known_hosts # To remove [127.0.0.1]:2222 if any
|
$ ssh -p 2222 sample@127.0.0.1
|
sample@127.0.0.1's password: sample
|
[sample@66c1bb2d3743 ~]$ mcsmysql -uroot
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 12
|
Server version: 10.3.16-MariaDB-log Columnstore 1.2.5-1
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> use test;
|
Database changed
|
MariaDB [test]> CREATE TABLE column_test (id INT(11), value VARCHAR(100)) ENGINE=Columnstore DEFAULT CHARSET=utf8;
|
Query OK, 0 rows affected (2.002 sec)
|
|
MariaDB [test]> show tables;
|
+----------------+
|
| Tables_in_test |
|
+----------------+
|
| column_test |
|
+----------------+
|
1 row in set (0.001 sec)
|
|
MariaDB [test]> show create table column_test\G
|
*************************** 1. row ***************************
|
Table: column_test
|
Create Table: CREATE TABLE `column_test` (
|
`id` int(11) DEFAULT NULL,
|
`value` varchar(100) DEFAULT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=utf8
|
1 row in set (0.001 sec)
|
|
MariaDB [test]> INSERT INTO column_test VALUES (1, 'test');
|
ERROR 1815 (HY000): Internal error: CAL0001: dmlprocessor.cpp PackageHandler::run() package type 0 IDB-2006: 'test.column_test' does not exist in Columnstore.
|
MariaDB [test]> CREATE DATABASE mytest;
|
Query OK, 1 row affected (0.003 sec)
|
|
MariaDB [test]> use mytest;
|
Database changed
|
MariaDB [mytest]> CREATE TABLE column_test (id INT(11), value VARCHAR(100)) ENGINE=Columnstore DEFAULT CHARSET=utf8;
|
Query OK, 0 rows affected (0.384 sec)
|
|
MariaDB [mytest]> INSERT INTO column_test VALUES (1, 'test');
|
ERROR 1815 (HY000): Internal error: CAL0001: dmlprocessor.cpp PackageHandler::run() package type 0 IDB-2006: 'mytest.column_test' does not exist in Columnstore.
|
MariaDB [mytest]> SELECT * FROM column_test;
|
ERROR 1815 (HY000): Internal error: IDB-2006: 'mytest.column_test' does not exist in Columnstore.
|
MariaDB [mytest]> DROP TABLE column_test;
|
Query OK, 0 rows affected, 1 warning (0.046 sec)
|
|
MariaDB [mytest]> SELECT * FROM column_test;
|
ERROR 1146 (42S02): Table 'mytest.column_test' doesn't exist
|
MariaDB [mytest]>
|