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

CEJ with autocommit disabled does not give expected result.

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 1.4.3-5, 1.5.3
    • Icebox
    • N/A
    • None

    Description

      When autocommit=0 and an insert is performed on a table, a query with a cross-engine join involving this table does not give expected results. Here are steps to reproduce:

      MariaDB [test]> create table c1(a int)engine=columnstore;
      Query OK, 0 rows affected (0.389 sec)
       
      MariaDB [test]> create table i1(b int);
      Query OK, 0 rows affected (0.012 sec)
       
      MariaDB [test]> show variables like 'autocommit';
      +---------------+-------+
      | Variable_name | Value |
      +---------------+-------+
      | autocommit    | ON    |
      +---------------+-------+
      1 row in set (0.001 sec)
       
      MariaDB [test]> insert into c1 values (1);
      Query OK, 1 row affected (0.167 sec)
       
      MariaDB [test]> select * from c1;
      +------+
      | a    |
      +------+
      |    1 |
      +------+
      1 row in set (0.064 sec)
       
      MariaDB [test]> set autocommit=0;
      Query OK, 0 rows affected (0.000 sec)
       
      MariaDB [test]> insert into i1 values (1);
      Query OK, 1 row affected (0.001 sec)
       
      MariaDB [test]> select * from i1;
      +------+
      | b    |
      +------+
      |    1 |
      +------+
      1 row in set (0.000 sec)
       
      MariaDB [test]> select * from c1, i1 where c1.a=i1.b;
      Empty set (0.013 sec)
       
      MariaDB [test]> set autocommit=1;
      Query OK, 0 rows affected (0.002 sec)
       
      MariaDB [test]> select * from i1;
      +------+
      | b    |
      +------+
      |    1 |
      +------+
      1 row in set (0.001 sec)
       
      MariaDB [test]> select * from c1, i1 where c1.a=i1.b;
      +------+------+
      | a    | b    |
      +------+------+
      |    1 |    1 |
      +------+------+
      1 row in set (0.013 sec)
      

      Attachments

        Issue Links

          Activity

            People

              toddstoffel Todd Stoffel (Inactive)
              tntnatbry Gagan Goel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.