Derived table handler loses data on conversion from HEAP to Aria

--source have_federatedx.inc

--source include/federated.inc

connection default;

set global federated_pushdown=1;

connection slave;

CREATE TABLE federated.t1 (

  a varchar(100) NOT NULL default '123'

)

DEFAULT CHARSET=latin1;

CREATE TABLE federated.t2 LIKE federated.t1;

DELIMITER $$;

BEGIN NOT ATOMIC

  DECLARE i INT DEFAULT 0;

  START TRANSACTION;

  WHILE i < 70000 DO

    INSERT INTO federated.t1 VALUES (i);

    SET i = i + 1;

  END WHILE;

  COMMIT;

END

$$

DELIMITER ;$$

connection master;

--replace_result $SLAVE_MYPORT SLAVE_PORT

eval

CREATE TABLE federated.t1 (

  a varchar(100) NOT NULL default '123'

)

ENGINE="FEDERATED" DEFAULT CHARSET=latin1

CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1';

--replace_result $SLAVE_MYPORT SLAVE_PORT

eval

CREATE TABLE federated.t2 (

  a varchar(100) NOT NULL default '123'

)

ENGINE="FEDERATED" DEFAULT CHARSET=latin1

CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t2';

--echo #

--echo # This correctly returns 70000

--echo #

SELECT COUNT(DISTINCT a) FROM federated.t1;

--echo #

--echo # This correctly returns 100

--echo #

INSERT INTO federated.t2 SELECT * FROM (SELECT * FROM federated.t1 LIMIT 100) derived;

SELECT COUNT(DISTINCT a) FROM federated.t2;

--echo #

--echo # This erroneously returns 1

--echo #

TRUNCATE TABLE federated.t2;

INSERT INTO federated.t2 SELECT * FROM (SELECT * FROM federated.t1 LIMIT 70000) derived;

SELECT COUNT(DISTINCT a) FROM federated.t2;

--echo #

--echo # This correctly returns 70000  

--echo #

SET global federated_pushdown=0;

TRUNCATE TABLE federated.t2;

INSERT INTO federated.t2 SELECT * FROM (SELECT * FROM federated.t1 LIMIT 70000) derived;

SELECT COUNT(DISTINCT a) FROM federated.t2;

source include/federated_cleanup.inc;

Thread 30 "mariadbd" hit Breakpoint 10, create_internal_tmp_table_from_heap (thd=0x7fff9800d268, table=0x7fff980cac40, 

    start_recinfo=0xa5a5a5a5a5a5a5a5, recinfo=0x7fff980e95b0, error=135, ignore_last_dupp_key_error=true, 

    is_duplicate=0x7fffdcaed83f) at /home/bar/maria-git/server.10.5.cs2/sql/sql_select.cc:19794

19794	  TABLE new_table;

void derived_handler::set_derived(TABLE_LIST *tbl)

{

  derived= tbl;

  table= tbl->table;

  unit= tbl->derived;

  select= unit->first_select();

  tmp_table_param= select->next_select() ?

                   ((select_unit *)(unit->result))->get_tmp_table_param() :

                   &select->join->tmp_table_param;

}