CEJ with autocommit disabled does not give expected result.

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)