CentOS

This query has been known to not work for columnstore. I don't know why it was deemed acceptable to throw an error. But now it just returns an empty set, which is not what the query should return.

There was a valid reason for this, but I don't recall what it was. I'll look into it.

This is a bug. A case I didn't seem to anticipate in MCOL-677

Patch adds error back for the missed cases of joining a CHAR/VARCHAR with an INT as part of an expression step.

This changes 4 test results in the fnJoin, 1 was incorrect and 3 were working more by chance than anything else. There is a pull request for this too.

Longer term we need to look at supporting the joining of INT with non-INT columns. But that should be a feature request for another ticket if we don't have one already.

MCOL-695 is for tracking the CHAR/VARCHAR to INT join.

Build verified: 1.1.0-1

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 21
Server version: 10.2.8-MariaDB-log Columnstore 1.1.0-1

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [tpch1]> select ps_partkey, sum(ps_supplycost * ps_availqty) as value
-> from partsupp, supplier, nation
-> where replace(concat(ps_suppkey, 'A'), 'A', '') = s_suppkey
-> and 0-s_nationkey = 0-n_nationkey
-> and n_name = 'GERMANY'
-> group by ps_partkey
-> having sum(ps_supplycost * ps_availqty) > ( select sum(ps_supplycost * ps_availqty) * 0.0001 from partsupp, supplier, nation where ps_suppkey = s_suppkey and s_nationkey = n_nationkey and n_name = 'GERMANY' )
-> order by value desc;
ERROR 1815 (HY000): Internal error: IDB-1002: 'partsupp' and 'supplier' have incompatible column type specified for join condition.
M