summaryrefslogtreecommitdiff
path: root/mysql-test/main/filesort_bad_i_s-7585.test
blob: daf70acdd5297dee9d4a083c95be9802b4306336 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
#
# MDEV-7585 Assertion `thd->is_error() || kill_errno || thd->killed == ABORT_QUERY' failed in ha_rows filesort
#
SET sql_mode=STRICT_TRANS_TABLES;

CREATE TABLE t0 (i INT) ENGINE=MyISAM;
CREATE VIEW v1 AS SELECT * FROM t0;
CREATE VIEW v2 AS SELECT * FROM v1;
DROP VIEW IF EXISTS v1;

CREATE TABLE t1 (i INT) ENGINE=MyISAM;
INSERT INTO t1 SELECT TABLE_ROWS FROM information_schema.tables ORDER BY TABLE_ROWS;
DROP VIEW v2;
DROP TABLE t1, t0;