1#
2# MDEV-7585 Assertion `thd->is_error() || kill_errno || thd->killed == ABORT_QUERY' failed in ha_rows filesort
3#
4SET sql_mode=STRICT_TRANS_TABLES;
5
6CREATE TABLE t0 (i INT) ENGINE=MyISAM;
7CREATE VIEW v1 AS SELECT * FROM t0;
8CREATE VIEW v2 AS SELECT * FROM v1;
9DROP VIEW IF EXISTS v1;
10
11CREATE TABLE t1 (i INT) ENGINE=MyISAM;
12INSERT INTO t1 SELECT TABLE_ROWS FROM information_schema.tables ORDER BY TABLE_ROWS;
13DROP VIEW v2;
14DROP TABLE t1, t0;
15