Details
-
Bug
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
10.11
-
None
Description
Reproducible on 10.6-11.4 (including older releases), needs cleaning. Could not reproduce on 11.8+.
Set to trivial, because we currently have ~13 open bugs for protocol assertion failures which nobody is fixing, and on top of that DELETE from a sequence is not a normal real-life scenario.
The above-mentioned open bugs don't immediately resemble this one (assuming they would have "Sequences" among components if they did), but still needs double-checking for duplicates.
# Remaining options: --mysqld=--loose-plugin-partition |
# Search pattern(s): (?^s:Protocol::end_statement)
|
 |
--disable_abort_on_error
|
GRANT ALL ON *.* TO rqg@localhost; |
CREATE DATABASE IF NOT EXISTS simple_db; |
CREATE TABLE simple_db.D (pk INTEGER AUTO_INCREMENT, |
col_int_key INTEGER, |
col_varchar_key VARCHAR(1), |
PRIMARY KEY (pk DESC), |
KEY (col_varchar_key ASC, col_int_key DESC) |
);
|
CREATE DATABASE IF NOT EXISTS innodb_partition_db; |
USE innodb_partition_db; |
CREATE TABLE tp004 (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, |
c03 VARCHAR(1024) NOT NULL DEFAULT '', |
PRIMARY KEY (id)) row_format=compact /*!50100 PARTITION BY hash(id) partitions 2 */; |
CREATE TABLE tp017 (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, |
c03 VARCHAR(1024) NOT NULL DEFAULT '', |
c02 CHAR(3) NOT NULL DEFAULT '', |
PRIMARY KEY (id)) row_format=compressed key_block_size=2 /*!50100 PARTITION BY hash(id) partitions 2 */; |
--connect (con24_0,localhost,root,,)
|
CREATE SEQUENCE seq99 NO MAXVALUE; |
DELETE IGNORE alias1 FROM (test.seq9 AS alias1 LEFT JOIN simple_db.D AS alias2 ON ((alias2.col_int_key = alias1.next_not_cached_value) OR ((alias2.pk < alias1.maximum_value) AND (alias2.pk >= alias1.minimum_value)))) WHERE (alias2.col_varchar_key = ANY (SELECT SQ1_alias1.c03 AS SQ1_cfield1 FROM (innodb_partition_db.tp017 AS SQ1_alias1 INNER JOIN innodb_partition_db.tp004 AS SQ1_alias2 ON (SQ1_alias2.c03 = SQ1_alias1.c02)))) OR (alias1.maximum_value BETWEEN 223 AND (223 + 156) OR (alias1.start_value BETWEEN 223 AND (223 + 148) OR (alias1.cache_size > 'r' OR alias1.cache_size BETWEEN 223 AND (223 + 110)))) OR (alias1.cache_size > alias1.cycle_option AND alias1.start_value = alias1.cycle_count); |
{c