Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.1.2
-
None
-
docker run -it -p 3307:3306 -e MARIADB_ROOT_PASSWORD=root mariadb:latest
Description
The same query returns different results under different configurations of optimize_join_buffer_size.
CREATE TABLE t0(c0 CHAR(100)); |
CREATE TABLE t1(c0 CHAR(100)); |
|
INSERT INTO t1 VALUES ('\r'); |
INSERT INTO t0 VALUES (''); |
INSERT INTO t1 VALUES (''); |
SET SESSION join_buffer_size = 6503032224856747123; |
INSERT INTO t0 VALUES ('a'); |
|
SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'} |
SET STATEMENT optimizer_switch = 'optimize_join_buffer_size=off' FOR SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'}, {'a'} |
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Description |
The same query returns different results under different configurations of optimize_join_buffer_size.
CREATE TABLE t0(c0 CHAR(100)); CREATE TABLE t1(c0 CHAR(100)); INSERT INTO t1 VALUES ('\r'); INSERT INTO t0 VALUES (''); INSERT INTO t1 VALUES (''); SET SESSION join_buffer_size = 6503032224856747123; INSERT INTO t0 VALUES ('a'); SET SESSION optimizer_switch = 'optimize_join_buffer_size=on'; SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'} SET SESSION optimizer_switch = 'optimize_join_buffer_size=off'; SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'}, {'a'} |
The same query returns different results under different configurations of optimize_join_buffer_size.
{code:sql| CREATE TABLE t0(c0 CHAR(100)); CREATE TABLE t1(c0 CHAR(100)); INSERT INTO t1 VALUES ('\r'); INSERT INTO t0 VALUES (''); INSERT INTO t1 VALUES (''); SET SESSION join_buffer_size = 6503032224856747123; INSERT INTO t0 VALUES ('a'); SET SESSION optimizer_switch = 'optimize_join_buffer_size=on'; SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'} SET SESSION optimizer_switch = 'optimize_join_buffer_size=off'; SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'}, {'a'} {code} |
Description |
The same query returns different results under different configurations of optimize_join_buffer_size.
{code:sql| CREATE TABLE t0(c0 CHAR(100)); CREATE TABLE t1(c0 CHAR(100)); INSERT INTO t1 VALUES ('\r'); INSERT INTO t0 VALUES (''); INSERT INTO t1 VALUES (''); SET SESSION join_buffer_size = 6503032224856747123; INSERT INTO t0 VALUES ('a'); SET SESSION optimizer_switch = 'optimize_join_buffer_size=on'; SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'} SET SESSION optimizer_switch = 'optimize_join_buffer_size=off'; SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'}, {'a'} {code} |
The same query returns different results under different configurations of optimize_join_buffer_size.
{code:sql} CREATE TABLE t0(c0 CHAR(100)); CREATE TABLE t1(c0 CHAR(100)); INSERT INTO t1 VALUES ('\r'); INSERT INTO t0 VALUES (''); INSERT INTO t1 VALUES (''); SET SESSION join_buffer_size = 6503032224856747123; INSERT INTO t0 VALUES ('a'); SET SESSION optimizer_switch = 'optimize_join_buffer_size=on'; SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'} SET SESSION optimizer_switch = 'optimize_join_buffer_size=off'; SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'}, {'a'} {code} |
Fix Version/s | 11.1 [ 28549 ] |
Assignee | Sergei Petrunia [ psergey ] |
Description |
The same query returns different results under different configurations of optimize_join_buffer_size.
{code:sql} CREATE TABLE t0(c0 CHAR(100)); CREATE TABLE t1(c0 CHAR(100)); INSERT INTO t1 VALUES ('\r'); INSERT INTO t0 VALUES (''); INSERT INTO t1 VALUES (''); SET SESSION join_buffer_size = 6503032224856747123; INSERT INTO t0 VALUES ('a'); SET SESSION optimizer_switch = 'optimize_join_buffer_size=on'; SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'} SET SESSION optimizer_switch = 'optimize_join_buffer_size=off'; SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'}, {'a'} {code} |
The same query returns different results under different configurations of optimize_join_buffer_size.
{code:sql} CREATE TABLE t0(c0 CHAR(100)); CREATE TABLE t1(c0 CHAR(100)); INSERT INTO t1 VALUES ('\r'); INSERT INTO t0 VALUES (''); INSERT INTO t1 VALUES (''); SET SESSION join_buffer_size = 6503032224856747123; INSERT INTO t0 VALUES ('a'); SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'} SET STATEMENT optimizer_switch = 'optimize_join_buffer_size=off' FOR SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t1.c0 REGEXP t1.c0); -- {}, {'a'}, {'a'} {code} |
May I check whether there is any update about this report? Thanks!