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