Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-2234

VARBINARY in InnoDB is truncated on 0x00 byte when joining with ColumnStore

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.2
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      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)
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            mchomo Michal Chomo
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: