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

cross-engine join + is null filter on time column

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.2.5
    • Icebox
    • ?
    • None
    • debian 9

    Description

      error with innodb-columnstore cross engine join with a IS NULL / IS NOT NULL filter on an innodb time-column. The error does not occur on a datetime column

      select from (innodb)
      left join (mcs)
      where (innodb time column is null)

      drop table if exists `idb`;
      CREATE TABLE `idb` (
       `ID` int unsigned NOT NULL,
       `T` time DEFAULT NULL,
       PRIMARY KEY (`ID`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
       
      drop table if exists `mcs`;
      CREATE TABLE `mcs` (
       `ID` int unsigned NOT NULL,
       `Y` smallint unsigned DEFAULT NULL
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8;
       
      SELECT 
      count(*)
      FROM `idb` t1
      LEFT JOIN `mcs` t2 ON t1.`ID` = t2.`ID`
      WHERE (t1.`T` IS NOT NULL);
      

      => Error Code: 1815. Internal error: boost::bad_any_cast: failed conversion using boost::any_cast

      the error comes specifically from the where on the time column. If X is made INT or DATE or DATETIME then the query works

      the error comes from the IS NULL / is NOT NULL filter. a where X>='12:34:56' works

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              alebacq antoine
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.