1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
--source include/force_myisam_default.inc
--source include/have_myisam.inc
--echo #
--echo # Bug #53450: Crash/assertion
--echo # "virtual int ha_myisam::index_first(uchar*)") at assert.c:81
--echo #
CREATE TABLE t1 (a INT, b INT, c INT,
INDEX(a), INDEX(b), INDEX(c)) engine=myisam;
INSERT INTO t1 VALUES (1,2,3), (4,5,6), (7,8,9);
DELETE FROM t1 WHERE a = 10 OR b = 20 ORDER BY c LIMIT 1;
DROP TABLE t1;
--echo #
--echo # Bug#17787664 : ASSERT `! IS_SET()` IN DIAGNOSTICS_AREA::SET_OK_STATUS
--echo # ON ER_SUBQUERY_NO_1_ROW
--echo #
CREATE TABLE t1 (a INT) ENGINE=MyISAM;
INSERT INTO t1 VALUES (1);
CREATE TABLE t2 (b INT) ENGINE=MyISAM;
INSERT INTO t2 VALUES (8);
INSERT INTO t2 VALUES (24);
CREATE TABLE t3 (c INT) ENGINE=MyISAM;
INSERT INTO t3 VALUES (43);
INSERT INTO t3 VALUES (1);
#This statement triggers an assert in DEBUG build without the patch.
--error ER_SUBQUERY_NO_1_ROW
DELETE FROM OUTR1.* USING t1 AS OUTR1
LEFT OUTER JOIN t2 AS OUTR2 ON ( OUTR1.a = OUTR2.b )
WHERE OUTR1.a < ( SELECT t3.c from t3 where 1 XOR OUTR2.b IS NOT NULL);
DROP TABLE t1,t2,t3;
|
