1128
1128
DEALLOCATE PREPARE stmt;
1130
1130
DROP TABLE t1, t2;
1131
CREATE TABLE t1(a CHAR(9),b INT,KEY(b),KEY(a)) ENGINE=MYISAM;
1132
CREATE TABLE t2(a CHAR(9),b INT,KEY(b),KEY(a)) ENGINE=MYISAM;
1133
INSERT INTO t1 VALUES ('1',null),(null,null);
1134
INSERT INTO t2 VALUES ('1',null),(null,null);
1135
CREATE TABLE mm1(a CHAR(9),b INT,KEY(b),KEY(a))
1136
ENGINE=MERGE UNION=(t1,t2);
1137
SELECT t1.a FROM mm1,t1;
1147
DROP TABLE t1, t2, mm1;
1149
# Bug #50335: Assertion `!(order->used & map)' in eq_ref_table
1151
CREATE TABLE t1 (a INT NOT NULL, b INT NOT NULL, PRIMARY KEY (a,b));
1152
INSERT INTO t1 VALUES (0,0), (1,1);
1153
SELECT * FROM t1 STRAIGHT_JOIN t1 t2 ON t1.a=t2.a AND t1.a=t2.b ORDER BY t2.a, t1.a;