Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.2.2
-
Ubuntu 18.04 64-bit
Description
Server version: 10.3.11-MariaDB-log Columnstore 1.2.2-1
Steps to replicate:
CREATE TABLE ip_addresses
|
(
|
id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
|
ip_addr VARBINARY(16),
|
UNIQUE KEY (ip_addr)
|
) ENGINE = InnoDB;
|
|
CREATE TABLE join_inno
|
(
|
id INT PRIMARY KEY,
|
ip_addr_id BIGINT UNSIGNED,
|
KEY (ip_addr_id)
|
) ENGINE = InnoDB;
|
|
CREATE TABLE join_columnstore
|
(
|
id INT,
|
ip_addr_id BIGINT UNSIGNED
|
) ENGINE = Columnstore;
|
|
INSERT INTO ip_addresses VALUES (0, inet6_aton('32.209.0.71'));
|
INSERT INTO join_inno VALUES (0, 1);
|
INSERT INTO join_columnstore VALUES (0, 1);
|
SELECT ip_addr, inet6_ntoa(ip.ip_addr)
|
FROM join_inno AS inno
|
JOIN ip_addresses AS ip
|
ON inno.ip_addr_id = ip.id;
|
ip_addr | inet6_ntoa(ip.ip_addr) |
---|---|
0x20D10047 | 32.209.0.71 |
SELECT ip_addr, inet6_ntoa(ip.ip_addr)
|
FROM join_columnstore AS cs
|
JOIN ip_addresses AS ip
|
ON cs.ip_addr_id = ip.id;
|
ip_addr | inet6_ntoa(ip.ip_addr) |
---|---|
0x20D1 | <null> |
MariaDB [tor]> show warnings;
|
+---------+------+----------------------------------------------------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+----------------------------------------------------------------------------------------------------------------------------+
|
| Note | 1051 | Unknown table 'infinidb_vtable.$vtable_348' |
|
| Warning | 9999 | Columnstore Query Stats - fatal error running mysql_use_result() or empty result set in libmysql_client lib (-1) (unknown) |
|
+---------+------+----------------------------------------------------------------------------------------------------------------------------+
|
2 rows in set (0.000 sec)
|