Table #sql- is full when doing CREATE TEMPOARY TABLE ... SELECT into Aria table

The following sequence can sometimes cause a table is full error when adding index:

CREATE TEMPORARY TABLE tmp engine=aria SELECT ....
CREATE INDEX (..) on t1 (...);

In theory on should be able to drop "temporary" table above, add 'transactional=0" and just check max key length with 'aria_check'.

Unfortunately we don't show max index length in 'show table status' and also we don't show
temporary tables either.