38 lines
1.4 KiB
Plaintext
38 lines
1.4 KiB
Plaintext
#
|
|
# Bug#24709595 WL#8741: ASSERTION `SORTORDER->NEED_STRXNFRM == 0' FAILED
|
|
#
|
|
CREATE TABLE t1(
|
|
c VARCHAR(10) CHARACTER SET utf8 DEFAULT NULL
|
|
);
|
|
Warnings:
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
CREATE TABLE t2(
|
|
c1 VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
|
|
c2 VARCHAR(10) CHARACTER SET utf8 DEFAULT NULL
|
|
);
|
|
Warnings:
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
INSERT INTO t1 VALUES('x');
|
|
INSERT INTO t2 VALUES('g','if'), ('not','ojgygqcgqi');
|
|
SELECT * FROM t2 WHERE (c2) <> (SELECT MAX(c) FROM t1 GROUP BY c1);
|
|
c1 c2
|
|
g if
|
|
not ojgygqcgqi
|
|
DROP TABLE t1, t2;
|
|
#
|
|
# Bug#29660945: SIG 6 AT TEMPTABLE::HANDLER::POSITION | SRC/HANDLER.CC
|
|
#
|
|
SET optimizer_switch='block_nested_loop=off';
|
|
CREATE TABLE t1 (
|
|
f1 varchar(255),
|
|
f2 varchar(255)
|
|
);
|
|
INSERT INTO t1 VALUES (NULL,'A');
|
|
INSERT INTO t1 VALUES ('A',NULL);
|
|
SELECT * FROM t1 AS alias1 JOIN t1 AS alias2 ON alias1.f1=alias2.f2 ORDER BY alias2.f1 LIMIT 50;
|
|
f1 f2 f1 f2
|
|
A NULL NULL A
|
|
DROP TABLE t1;
|
|
SET optimizer_switch=DEFAULT;
|