[MDEV-33010] Crash when pushing condition with CHARSET()/COERCIBILITY() into derived table - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 11.1.2, 11.2.2, 10.4(EOL), 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL)
Fix Version/s: 10.5.26, 10.6.19, 10.11.9, 11.1.6, 11.2.5, 11.4.3
Component/s: Optimizer, Server
Labels:
None
Environment:
Server version: 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 source revision: 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=1
max_threads=153
thread_count=1

Description

I first run the following statements to create tables.

create table t1 (`c1` bigint, key (`c1`));

insert into t1 values (-2);

create table t2 ( `c2` double unsigned );

insert into t2 values (12.991);

After creating tables, I repeat executing the following statement through the MariaDB CLI.

SELECT f6 FROM (SELECT DISTINCT `c1` AS `f6` FROM `t1`) AS `t1`

         JOIN (SELECT CHARSET(`c2`) AS `f5` FROM `t2`) AS `t3`

              ON (EXISTS (SELECT `c2` FROM `t2`)) AND

                 (NOT ((CHARSET(`f5`)) NOT BETWEEN `f6` AND `f6`));

After repeating several times (maybe 20 times), I lost the connection to the server.

Or try to run the following EXPLAIN query twice, I can get the same error.

EXPLAIN SELECT f6 FROM (SELECT DISTINCT `c1` AS `f6` FROM `t1`) AS `t1`

         JOIN (SELECT CHARSET(`c2`) AS `f5` FROM `t2`) AS `t3`

              ON (EXISTS (SELECT `c2` FROM `t2`)) AND

                 (NOT ((CHARSET(`f5`)) NOT BETWEEN `f6` AND `f6`));

The following trace is gotten from the log.

stack_bottom = 0x7f4c90082c38 thread_stack 0x49000

Printing to addr2line failed

mariadbd(my_print_stacktrace+0x32)[0x563dd110a7c2]

mariadbd(handle_fatal_signal+0x488)[0x563dd0be3cf8]

/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7f4ca74bd520]

mariadbd(_Z15optimize_keyuseP4JOINP16st_dynamic_array+0x148)[0x563dd09b5088]

mariadbd(+0x8ad551)[0x563dd09eb551]

mariadbd(_ZN4JOIN14optimize_innerEv+0x1322)[0x563dd09f07e2]

mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]

mariadbd(+0x7ec60c)[0x563dd092a60c]

mariadbd(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x95)[0x563dd0929e35]

mariadbd(_ZN4JOIN14optimize_innerEv+0xb27)[0x563dd09effe7]

mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]

mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xd1)[0x563dd09f0f21]

mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x154)[0x563dd09f1774]

mariadbd(+0x826f55)[0x563dd0964f55]

mariadbd(_Z21mysql_execute_commandP3THDb+0x419e)[0x563dd0973f0e]

mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x563dd0975237]

mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x14bd)[0x563dd0977a1d]

mariadbd(_Z10do_commandP3THDb+0x138)[0x563dd0979818]

mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x563dd0aa13af]

mariadbd(handle_one_connection+0x5d)[0x563dd0aa16fd]

mariadbd(+0xcd1906)[0x563dd0e0f906]

/lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7f4ca750fac3]

/lib/x86_64-linux-gnu/libc.so.6(+0x126a40)[0x7f4ca75a1a40]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Attachments

Issue Links

relates to

MDEV-14574 Assertion `!join->select_lex->master_unit()->derived || join->select_lex->master_unit()->derived->is_materialized_derived()' failed upon EXPLAIN INSERT .. SELECT into join view

Closed

Activity

Ascending order - Click to sort in descending order

John Jove created issue - 2023-12-13 15:56

John Jove made changes - 2023-12-13 16:24

Field	Original Value	New Value
Affects Version/s		11.2.2 [ 29035 ]

John Jove made changes - 2023-12-13 16:26

Description

I first run the following statements to create tables.
{code:sql}
create table t1 (`c1` bigint, key (`c1`));
insert into t1 values (-2);
create table t2 ( `c2` double unsigned );
insert into t2 values (12.991);
{code}
After creating tables, I repeat executing the following statement through the MariaDB CLI.
{code:sql}
SELECT f6 FROM (SELECT DISTINCT `c1` AS `f6` FROM `t1`) AS `t1`
         JOIN (SELECT CHARSET(`c2`) AS `f5` FROM `t2`) AS `t3`
              ON (EXISTS (SELECT `c2` FROM `t2`)) AND
                 (NOT ((CHARSET(`f5`)) NOT BETWEEN `f6` AND `f6`));
{code}
After repeating several times (maybe 20 times), I lost the connection to the server.

The following trace is gotten from the log.
{code}
stack_bottom = 0x7f4c90082c38 thread_stack 0x49000
Printing to addr2line failed
mariadbd(my_print_stacktrace+0x32)[0x563dd110a7c2]
mariadbd(handle_fatal_signal+0x488)[0x563dd0be3cf8]
/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7f4ca74bd520]
mariadbd(_Z15optimize_keyuseP4JOINP16st_dynamic_array+0x148)[0x563dd09b5088]
mariadbd(+0x8ad551)[0x563dd09eb551]
mariadbd(_ZN4JOIN14optimize_innerEv+0x1322)[0x563dd09f07e2]
mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]
mariadbd(+0x7ec60c)[0x563dd092a60c]
mariadbd(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x95)[0x563dd0929e35]
mariadbd(_ZN4JOIN14optimize_innerEv+0xb27)[0x563dd09effe7]
mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]
mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xd1)[0x563dd09f0f21]
mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x154)[0x563dd09f1774]
mariadbd(+0x826f55)[0x563dd0964f55]
mariadbd(_Z21mysql_execute_commandP3THDb+0x419e)[0x563dd0973f0e]
mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x563dd0975237]
mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x14bd)[0x563dd0977a1d]
mariadbd(_Z10do_commandP3THDb+0x138)[0x563dd0979818]
mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x563dd0aa13af]
mariadbd(handle_one_connection+0x5d)[0x563dd0aa16fd]
mariadbd(+0xcd1906)[0x563dd0e0f906]
/lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7f4ca750fac3]
/lib/x86_64-linux-gnu/libc.so.6(+0x126a40)[0x7f4ca75a1a40]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
{code}

I first run the following statements to create tables.
{code:sql}
create table t1 (`c1` bigint, key (`c1`));
insert into t1 values (-2);
create table t2 ( `c2` double unsigned );
insert into t2 values (12.991);
{code}
After creating tables, I repeat executing the following statement through the MariaDB CLI.
{code:sql}
SELECT f6 FROM (SELECT DISTINCT `c1` AS `f6` FROM `t1`) AS `t1`
         JOIN (SELECT CHARSET(`c2`) AS `f5` FROM `t2`) AS `t3`
              ON (EXISTS (SELECT `c2` FROM `t2`)) AND
                 (NOT ((CHARSET(`f5`)) NOT BETWEEN `f6` AND `f6`));
{code}
After repeating several times (maybe 20 times), I lost the connection to the server.

Or try to EXPLAIN the query twice, I can get the same error.
{code:sql}
EXPLAIN SELECT f6 FROM (SELECT DISTINCT `c1` AS `f6` FROM `t1`) AS `t1`
         JOIN (SELECT CHARSET(`c2`) AS `f5` FROM `t2`) AS `t3`
              ON (EXISTS (SELECT `c2` FROM `t2`)) AND
                 (NOT ((CHARSET(`f5`)) NOT BETWEEN `f6` AND `f6`));
{code}

The following trace is gotten from the log.
{code}
stack_bottom = 0x7f4c90082c38 thread_stack 0x49000
Printing to addr2line failed
mariadbd(my_print_stacktrace+0x32)[0x563dd110a7c2]
mariadbd(handle_fatal_signal+0x488)[0x563dd0be3cf8]
/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7f4ca74bd520]
mariadbd(_Z15optimize_keyuseP4JOINP16st_dynamic_array+0x148)[0x563dd09b5088]
mariadbd(+0x8ad551)[0x563dd09eb551]
mariadbd(_ZN4JOIN14optimize_innerEv+0x1322)[0x563dd09f07e2]
mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]
mariadbd(+0x7ec60c)[0x563dd092a60c]
mariadbd(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x95)[0x563dd0929e35]
mariadbd(_ZN4JOIN14optimize_innerEv+0xb27)[0x563dd09effe7]
mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]
mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xd1)[0x563dd09f0f21]
mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x154)[0x563dd09f1774]
mariadbd(+0x826f55)[0x563dd0964f55]
mariadbd(_Z21mysql_execute_commandP3THDb+0x419e)[0x563dd0973f0e]
mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x563dd0975237]
mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x14bd)[0x563dd0977a1d]
mariadbd(_Z10do_commandP3THDb+0x138)[0x563dd0979818]
mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x563dd0aa13af]
mariadbd(handle_one_connection+0x5d)[0x563dd0aa16fd]
mariadbd(+0xcd1906)[0x563dd0e0f906]
/lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7f4ca750fac3]
/lib/x86_64-linux-gnu/libc.so.6(+0x126a40)[0x7f4ca75a1a40]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
{code}

John Jove made changes - 2023-12-13 16:27

Description

I first run the following statements to create tables.
{code:sql}
create table t1 (`c1` bigint, key (`c1`));
insert into t1 values (-2);
create table t2 ( `c2` double unsigned );
insert into t2 values (12.991);
{code}
After creating tables, I repeat executing the following statement through the MariaDB CLI.
{code:sql}
SELECT f6 FROM (SELECT DISTINCT `c1` AS `f6` FROM `t1`) AS `t1`
         JOIN (SELECT CHARSET(`c2`) AS `f5` FROM `t2`) AS `t3`
              ON (EXISTS (SELECT `c2` FROM `t2`)) AND
                 (NOT ((CHARSET(`f5`)) NOT BETWEEN `f6` AND `f6`));
{code}
After repeating several times (maybe 20 times), I lost the connection to the server.

Or try to EXPLAIN the query twice, I can get the same error.
{code:sql}
EXPLAIN SELECT f6 FROM (SELECT DISTINCT `c1` AS `f6` FROM `t1`) AS `t1`
         JOIN (SELECT CHARSET(`c2`) AS `f5` FROM `t2`) AS `t3`
              ON (EXISTS (SELECT `c2` FROM `t2`)) AND
                 (NOT ((CHARSET(`f5`)) NOT BETWEEN `f6` AND `f6`));
{code}

The following trace is gotten from the log.
{code}
stack_bottom = 0x7f4c90082c38 thread_stack 0x49000
Printing to addr2line failed
mariadbd(my_print_stacktrace+0x32)[0x563dd110a7c2]
mariadbd(handle_fatal_signal+0x488)[0x563dd0be3cf8]
/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7f4ca74bd520]
mariadbd(_Z15optimize_keyuseP4JOINP16st_dynamic_array+0x148)[0x563dd09b5088]
mariadbd(+0x8ad551)[0x563dd09eb551]
mariadbd(_ZN4JOIN14optimize_innerEv+0x1322)[0x563dd09f07e2]
mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]
mariadbd(+0x7ec60c)[0x563dd092a60c]
mariadbd(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x95)[0x563dd0929e35]
mariadbd(_ZN4JOIN14optimize_innerEv+0xb27)[0x563dd09effe7]
mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]
mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xd1)[0x563dd09f0f21]
mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x154)[0x563dd09f1774]
mariadbd(+0x826f55)[0x563dd0964f55]
mariadbd(_Z21mysql_execute_commandP3THDb+0x419e)[0x563dd0973f0e]
mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x563dd0975237]
mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x14bd)[0x563dd0977a1d]
mariadbd(_Z10do_commandP3THDb+0x138)[0x563dd0979818]
mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x563dd0aa13af]
mariadbd(handle_one_connection+0x5d)[0x563dd0aa16fd]
mariadbd(+0xcd1906)[0x563dd0e0f906]
/lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7f4ca750fac3]
/lib/x86_64-linux-gnu/libc.so.6(+0x126a40)[0x7f4ca75a1a40]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
{code}

I first run the following statements to create tables.
{code:sql}
create table t1 (`c1` bigint, key (`c1`));
insert into t1 values (-2);
create table t2 ( `c2` double unsigned );
insert into t2 values (12.991);
{code}
After creating tables, I repeat executing the following statement through the MariaDB CLI.
{code:sql}
SELECT f6 FROM (SELECT DISTINCT `c1` AS `f6` FROM `t1`) AS `t1`
         JOIN (SELECT CHARSET(`c2`) AS `f5` FROM `t2`) AS `t3`
              ON (EXISTS (SELECT `c2` FROM `t2`)) AND
                 (NOT ((CHARSET(`f5`)) NOT BETWEEN `f6` AND `f6`));
{code}
After repeating several times (maybe 20 times), I lost the connection to the server.

Or try to run the following EXPLAIN query twice, I can get the same error.
{code:sql}
EXPLAIN SELECT f6 FROM (SELECT DISTINCT `c1` AS `f6` FROM `t1`) AS `t1`
         JOIN (SELECT CHARSET(`c2`) AS `f5` FROM `t2`) AS `t3`
              ON (EXISTS (SELECT `c2` FROM `t2`)) AND
                 (NOT ((CHARSET(`f5`)) NOT BETWEEN `f6` AND `f6`));
{code}

The following trace is gotten from the log.
{code}
stack_bottom = 0x7f4c90082c38 thread_stack 0x49000
Printing to addr2line failed
mariadbd(my_print_stacktrace+0x32)[0x563dd110a7c2]
mariadbd(handle_fatal_signal+0x488)[0x563dd0be3cf8]
/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7f4ca74bd520]
mariadbd(_Z15optimize_keyuseP4JOINP16st_dynamic_array+0x148)[0x563dd09b5088]
mariadbd(+0x8ad551)[0x563dd09eb551]
mariadbd(_ZN4JOIN14optimize_innerEv+0x1322)[0x563dd09f07e2]
mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]
mariadbd(+0x7ec60c)[0x563dd092a60c]
mariadbd(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x95)[0x563dd0929e35]
mariadbd(_ZN4JOIN14optimize_innerEv+0xb27)[0x563dd09effe7]
mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]
mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xd1)[0x563dd09f0f21]
mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x154)[0x563dd09f1774]
mariadbd(+0x826f55)[0x563dd0964f55]
mariadbd(_Z21mysql_execute_commandP3THDb+0x419e)[0x563dd0973f0e]
mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x563dd0975237]
mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x14bd)[0x563dd0977a1d]
mariadbd(_Z10do_commandP3THDb+0x138)[0x563dd0979818]
mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x563dd0aa13af]
mariadbd(handle_one_connection+0x5d)[0x563dd0aa16fd]
mariadbd(+0xcd1906)[0x563dd0e0f906]
/lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7f4ca750fac3]
/lib/x86_64-linux-gnu/libc.so.6(+0x126a40)[0x7f4ca75a1a40]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
{code}

Alice Sherepa made changes - 2023-12-14 10:20

Link

This issue relates to ~~MDEV-14574~~ [ ~~MDEV-14574~~ ]

Alice Sherepa made changes - 2023-12-14 10:21

Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.11 [ 27614 ]
Affects Version/s		11.0 [ 28320 ]
Affects Version/s		11.1 [ 28549 ]
Affects Version/s		11.2 [ 28603 ]
Affects Version/s		11.3 [ 28565 ]

Alice Sherepa made changes - 2023-12-14 10:21

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.11 [ 27614 ]
Fix Version/s		11.0 [ 28320 ]
Fix Version/s		11.1 [ 28549 ]
Fix Version/s		11.2 [ 28603 ]
Fix Version/s		11.3 [ 28565 ]

Alice Sherepa made changes - 2023-12-14 10:28

Status

Open [ 1 ]

Confirmed [ 10101 ]

Alice Sherepa made changes - 2023-12-14 10:28

Assignee

Sergei Petrunia [ psergey ]

Alice Sherepa made changes - 2023-12-14 10:28

Component/s

Optimizer [ 10200 ]

Sergei Petrunia made changes - 2023-12-14 11:49

Assignee

Sergei Petrunia [ psergey ]

Oleg Smirnov [ JIRAUSER50405 ]

Oleg Smirnov made changes - 2024-03-27 13:53

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Oleg Smirnov made changes - 2024-03-31 12:34

Comment

[ Simplified test case (crashes consistently, no need to run a cycle):
{code}
EXPLAIN EXTENDED
     SELECT dt1_c1 FROM
       (SELECT c1 AS dt1_c1 FROM t1) AS dt1
       JOIN
       (SELECT 1 AS dt2_c2 FROM t2) AS dt2
          ON CHARSET(dt2_c2) BETWEEN dt1_c1 AND dt1_c1;

Warnings:
Note 1003
/* select#1 */ select `dt1`.`dt1_c1` AS `dt1_c1`
   from
   (/* select#2 */ select `test`.`t1`.`c1` AS `dt1_c1` from `test`.`t1`
     where <cache>(charset(1)) between `test`.`t1`.`c1` and `test`.`t1`.`c1`) `dt1`
   where <cache>(charset(1)) between `dt1`.`dt1_c1` and `dt1`.`dt1_c1`
{code}
* Note: rewritten query text in the warning is obtained by disabling the {{optimize_keyuse()}} call.

{{<cache>(charset(1)) between `test`.`t1`.`c1` and `test`.`t1`.`c1`}} is shown twice in the output, doesn't it look strange?

Observation: replacing {{CHARSET()}} with {{LENGTH()}} eliminates the crash, and the execution doesn't have duplicate call of the function:
{code}
EXPLAIN EXTENDED
SELECT dt1_c1 FROM
(SELECT c1 AS dt1_c1 FROM t1) AS dt1
JOIN
(SELECT 1 AS dt2_c2 FROM t2) AS dt2
ON LENGTH(dt2_c2) BETWEEN dt1_c1 AND dt1_c1;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 PRIMARY <derived3> system NULL NULL NULL NULL 1 100.00
1 PRIMARY <derived2> ref key0 key0 9 const 0 0.00 Using where
3 DERIVED t2 system NULL NULL NULL NULL 1 100.00
2 DERIVED t1 index NULL c1 9 NULL 1 100.00 Using index
Warnings:
Note 1003
/* select#1 */ select `dt1`.`dt1_c1` AS `dt1_c1`
  from
  (/* select#2 */ select `test`.`t1`.`c1` AS `dt1_c1` from `test`.`t1`) `dt1`
     where <cache>(octet_length(1)) between `dt1`.`dt1_c1` and `dt1`.`dt1_c1`
{code} ]

Oleg Smirnov made changes - 2024-04-01 05:47

Summary

Crash MariaDB Server after repeating executing queries.

Condition with CHARSET() erroneously pushed into derived table

Oleg Smirnov made changes - 2024-04-01 06:51

Summary

Condition with CHARSET() erroneously pushed into derived table

Condition with CHARSET()/COERCIBILITY() erroneously pushed into derived table

Oleg Smirnov made changes - 2024-04-01 09:37

Assignee	Oleg Smirnov [ JIRAUSER50405 ]	Alexander Barkov [ bar ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Alexander Barkov made changes - 2024-04-01 10:05

Assignee	Alexander Barkov [ bar ]	Oleg Smirnov [ JIRAUSER50405 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Oleg Smirnov made changes - 2024-04-02 07:27

Link

This issue relates to ~~MDEV-33805~~ [ ~~MDEV-33805~~ ]

Julien Fritsch made changes - 2024-05-03 14:32

Fix Version/s	11.0 [ 28320 ]
Fix Version/s	11.3 [ 28565 ]

Oleg Smirnov made changes - 2024-07-09 12:50

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Oleg Smirnov made changes - 2024-07-09 12:53

Summary

Condition with CHARSET()/COERCIBILITY() erroneously pushed into derived table

Crash when pushing condition with CHARSET()/COERCIBILITY() into derived table

Oleg Smirnov made changes - 2024-07-10 05:02

Assignee	Oleg Smirnov [ JIRAUSER50405 ]	Oleksandr Byelkin [ sanja ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Alexander Barkov made changes - 2024-07-15 10:38

Assignee

Oleksandr Byelkin [ sanja ]

Alexander Barkov [ bar ]

Alexander Barkov made changes - 2024-07-15 10:43

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Alexander Barkov made changes - 2024-07-15 14:31

Assignee

Alexander Barkov [ bar ]

Oleg Smirnov [ JIRAUSER50405 ]

Oleg Smirnov made changes - 2024-07-16 11:00

Fix Version/s		10.5.26 [ 29832 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.11 [ 27614 ]
Fix Version/s	11.1 [ 28549 ]
Fix Version/s	11.2 [ 28603 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

JiraAutomate made changes - 2024-07-16 11:00

Fix Version/s		10.6.19 [ 29833 ]
Fix Version/s		10.11.9 [ 29834 ]
Fix Version/s		11.1.6 [ 29835 ]
Fix Version/s		11.2.5 [ 29836 ]
Fix Version/s		11.4.3 [ 29837 ]

Oleg Smirnov made changes - 2024-09-25 06:32

Link

This issue relates to ~~MDEV-33805~~ [ ~~MDEV-33805~~ ]

People

Assignee:: Oleg Smirnov

Reporter:: John Jove

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2023-12-13 15:56

Updated:: 2024-09-25 06:32

Resolved:: 2024-07-16 11:00

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.