summaryrefslogtreecommitdiff
path: root/mysql-test/r/filesort_bad_i_s-7585.result
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2015-04-25 00:19:20 +0200
committerSergei Golubchik <serg@mariadb.org>2015-04-27 15:42:12 +0200
commit9fd65db329b7186faeab79e23ae3be356973fb4d (patch)
treecd7dc4043d762678a43ce824142dd3adc150ba42 /mysql-test/r/filesort_bad_i_s-7585.result
parent8e781601f46938cb4228bd9a966a9d6871c06859 (diff)
downloadmariadb-git-9fd65db329b7186faeab79e23ae3be356973fb4d.tar.gz
MDEV-7585 Assertion `thd->is_error() || kill_errno || thd->killed == ABORT_QUERY' failed in ha_rows filesort
if we clear the error status (in THD::clear_error()) make sure to clear the thd->killed == KILL_BAD_DATA too, because it was caused by the error that we're clearing.
Diffstat (limited to 'mysql-test/r/filesort_bad_i_s-7585.result')
-rw-r--r--mysql-test/r/filesort_bad_i_s-7585.result9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/filesort_bad_i_s-7585.result b/mysql-test/r/filesort_bad_i_s-7585.result
new file mode 100644
index 00000000000..edb1574288f
--- /dev/null
+++ b/mysql-test/r/filesort_bad_i_s-7585.result
@@ -0,0 +1,9 @@
+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;