1# 2# MDEV-6830 Server crashes in best_access_path after a sequence of SELECTs invollving a temptable view 3# 4--source include/have_debug.inc 5SET @saved_dbug = @@SESSION.debug_dbug; 6set @@debug_dbug= 'd,opt'; 7 8CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=MyISAM; 9 10CREATE TABLE t2 ( 11 f1 DATE, 12 f2 VARCHAR(1024), 13 f3 VARCHAR(10), 14 f4 DATE, 15 f5 VARCHAR(10), 16 f6 VARCHAR(10), 17 f7 VARCHAR(10), 18 f8 DATETIME, 19 f9 INT, 20 f10 VARCHAR(1024), 21 f11 VARCHAR(1024), 22 f12 INT, 23 f13 VARCHAR(1024) 24) ENGINE=MyISAM; 25 26CREATE OR REPLACE VIEW v2 AS SELECT * FROM t2; 27 28CREATE TABLE t3 ( 29 f1 VARCHAR(1024), 30 f2 VARCHAR(1024), 31 f3 DATETIME, 32 f4 VARCHAR(10), 33 f5 INT, 34 f6 VARCHAR(10), 35 f7 VARCHAR(1024), 36 f8 VARCHAR(10), 37 f9 INT, 38 f10 DATE, 39 f11 INT, 40 f12 VARCHAR(1024), 41 f13 VARCHAR(10), 42 f14 DATE, 43 f15 DATETIME 44) ENGINE=MyISAM; 45 46CREATE OR REPLACE ALGORITHM=TEMPTABLE VIEW v3 AS SELECT * FROM t3; 47 48INSERT INTO t3 VALUES 49 ('FOO','foo','2000-08-04 00:00:00','one',1,'1','FOO','foo',1,'2004-05-09',1,'one','one','2001-12-07','2001-10-17 08:25:04'), 50 ('BAR','bar','2001-01-01 04:52:37','two',2,'2','BAR','bar',2,'2008-01-01',2,'two','two','2006-06-19','2002-01-01 08:22:49'); 51 52CREATE TABLE t4 (f1 VARCHAR(10), f2 INT) ENGINE=MyISAM; 53 54SELECT * FROM t1; 55 56--error ER_BAD_FIELD_ERROR 57SELECT non_existing FROM v2; 58 59SELECT * FROM t1, v3, t4 WHERE v3.f1 = t4.f1 AND t4.f2 = 6 AND t1.pk = v3.f5; 60 61drop table t1,t2,t3,t4; 62drop view v2,v3; 63SET debug_dbug= @saved_dbug; 64