|
Build tested: Github source
[root@localhost columnstore]# cd mariadb-columnstore-server/
[root@localhost mariadb-columnstore-server]# git show
commit 3da188e5c8a2630019ea810fb8c1bd3ece5e058b
Merge: 5d9686c 53c1df7
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Fri Feb 10 15:07:31 2017 +0000
Merge pull request #31 from jbfavre/fix_deb_package_dependency
MCOL-562 Fix Debian package dependencies
[root@localhost mariadb-columnstore-server]# cd mariadb-columnstore-engine/
[root@localhost mariadb-columnstore-engine]# git show
commit 16cef50caedd9ec7585b04c096996a9441bdf2d5
Author: David Hill <david.hill@mariadb.com>
Date: Wed Mar 1 10:39:11 2017 -0600
change the check for prompt back to the previous code
Performed cross engine join test using localhost as the host.
MariaDB [mytest]> show create table t1;
------
------
| t1 |
CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
------
1 row in set (0.00 sec)
MariaDB [mytest]> quit
Bye
[root@localhost ~]# cd /usr/local/mariadb/columnstore/etc
[root@localhost etc]# nano Columnstore.xml
[root@localhost etc]# mcsmysql mytest
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 22
Server version: 10.1.21-MariaDB Columnstore 1.1.0-1
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [mytest]> insert into t1 values (1);
Query OK, 1 row affected (0.00 sec)
MariaDB [mytest]> select * from lineitem, t1 where c1=l_orderkey;
-----------
| l_orderkey |
l_partkey |
l_suppkey |
l_linenumber |
l_quantity |
l_extendedprice |
l_discount |
l_tax |
l_returnflag |
l_linestatus |
l_shipdate |
l_commitdate |
l_receiptdate |
l_shipinstruct |
l_shipmode |
l_comment |
c1 |
-----------
| 1 |
155190 |
7706 |
1 |
17.00 |
21168.23 |
0.04 |
0.02 |
N |
O |
1996-03-13 |
1996-02-12 |
1996-03-22 |
DELIVER IN PERSON |
TRUCK |
egular courts above the |
1 |
| 1 |
67310 |
7311 |
2 |
36.00 |
45983.16 |
0.09 |
0.06 |
N |
O |
1996-04-12 |
1996-02-28 |
1996-04-20 |
TAKE BACK RETURN |
MAIL |
ly final dependencies: slyly bold |
1 |
| 1 |
63700 |
3701 |
3 |
8.00 |
13309.60 |
0.10 |
0.02 |
N |
O |
1996-01-29 |
1996-03-05 |
1996-01-31 |
TAKE BACK RETURN |
REG AIR |
riously. regular, express dep |
1 |
| 1 |
2132 |
4633 |
4 |
28.00 |
28955.64 |
0.09 |
0.06 |
N |
O |
1996-04-21 |
1996-03-30 |
1996-05-16 |
NONE |
AIR |
lites. fluffily even de |
1 |
| 1 |
24027 |
1534 |
5 |
24.00 |
22824.48 |
0.10 |
0.04 |
N |
O |
1996-03-30 |
1996-03-14 |
1996-04-01 |
NONE |
FOB |
pending foxes. slyly re |
1 |
| 1 |
15635 |
638 |
6 |
32.00 |
49620.16 |
0.07 |
0.02 |
N |
O |
1996-01-30 |
1996-02-07 |
1996-02-03 |
DELIVER IN PERSON |
MAIL |
arefully slyly ex |
1 |
-----------
6 rows in set (0.41 sec)
|