Wrong result upon JOIN with constant CSV table

create table t1 (a int not null) engine=CSV;

create table t2 (b int) engine=MyISAM;

insert into t2 values (1);

select count(*), b from t2 join t1; 

# Cleanup

drop table t1, t2;

MariaDB [test]> select count(*), b from t2 join t1; 

+----------+------+

| count(*) | b    |

+----------+------+

|        0 |    1 |

+----------+------+

1 row in set (0.002 sec)

{code:sql}

The expected result is (0,NULL), as without the aggregate function the result set is naturally empty:

{code:sql}

MariaDB [test]> select * from t2 join t1; 

Empty set (0.001 sec)