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

ColumnStore fails to make inner join if using CASE in predicate.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.4, 1.1.5
    • 1.1.6
    • MDB Plugin
    • None
    • 2018-14, 2018-15, 2018-16

    Description

      The feature worked back in 1.3 and git bisect points to aa581b5dc3d88b4d0d07a224de4da5c96cf23aa3 (MCOL-1234)

      Here are the steps to reproduce the issue:

      MariaDB [test]> describe cs1
          -> ;
      +-------+------------+------+-----+---------+-------+
      | Field | Type       | Null | Key | Default | Extra |
      +-------+------------+------+-----+---------+-------+
      | t     | varchar(2) | YES  |     | NULL    |       |
      | i     | int(11)    | YES  |     | NULL    |       |
      +-------+------------+------+-----+---------+-------+
      2 rows in set (0.01 sec)
       
      MariaDB [test]> describe cs2
          -> ;
      +-------+------------+------+-----+---------+-------+
      | Field | Type       | Null | Key | Default | Extra |
      +-------+------------+------+-----+---------+-------+
      | t     | varchar(2) | YES  |     | NULL    |       |
      | i     | int(11)    | YES  |     | NULL    |       |
      +-------+------------+------+-----+---------+-------+
      2 rows in set (0.00 sec)
       
      MariaDB [test]> select * from cs1 inner join cs2 on (cs1.t = case cs2.t when NULL then 'MO' else cs2.t end);
      ERROR 1815 (HY000): Internal error: IDB-1000: 'cs1' and 'cs2' are not joined.
      

      WIth the commit previous to the above mentioned CS process the query just fine.

      MariaDB [test]> select * from cs1 inner join cs2 on (cs1.t = case cs2.t when NULL then 'MO' else cs2.t end);
      +------+------+------+------+
      | t    | i    | t    | i    |
      +------+------+------+------+
      | SA   | NULL | SA   | NULL |
      +------+------+------+------+
      1 row in set (0.09 sec)
      
      

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              drrtuy Roman
              Votes:
              1 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.