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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.2.2
    • Icebox
    • N/A
    • 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

            Unassigned Unassigned
            mchomo Michal Chomo
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.