[MDEV-31143] Crash for query using ROWNUM() over view with ORDER BY - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.6, 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 10.11.3, 11.0.2, 10.6.13, 10.8.8, 10.9.6, 10.10.4
Component/s: Views
Labels:
- regression

Description

regression after 5bada1246de48ef4a18fa30388f, repeatable after ~~MDEV-31073~~ fix:

CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);

SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1;

Version: '10.6.13-MariaDB-debug-log'

230428 11:26:28 [ERROR] mysqld got signal 11 ;

Server version: 10.6.13-MariaDB-debug-log source revision: 2eb7bf1ec301d43a7e72b8720f6ee153dc52b6c9

sql/signal_handler.cc:241(handle_fatal_signal)[0x564018b2e716]

sigaction.c:0(__restore_rt)[0x7fef4eb59420]

maria/ha_maria.cc:1106(ha_maria::scan_time())[0x564019102df4]

sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x564018f39b67]

sql/sql_select.cc:5113(get_quick_record_count(THD*, SQL_SELECT*, TABLE*, Bitmap<64u> const*, unsigned long long))[0x56401838665b]

sql/sql_select.cc:5840(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x56401838d400]

sql/sql_select.cc:2509(JOIN::optimize_inner())[0x56401836b171]

sql/sql_select.cc:1848(JOIN::optimize())[0x5640183641cf]

sql/sql_select.cc:5055(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x564018385d68]

sql/sql_select.cc:559(handle_select(THD*, LEX*, select_result*, unsigned long))[0x564018355b9f]

sql/sql_parse.cc:6273(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5640182b6e8e]

sql/sql_parse.cc:3949(mysql_execute_command(THD*, bool))[0x5640182a57fb]

sql/sql_parse.cc:8036(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5640182c21b9]

sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x56401829803a]

sql/sql_parse.cc:1409(do_command(THD*, bool))[0x564018294d85]

sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x564018710df9]

sql/sql_connect.cc:1320(handle_one_connection)[0x564018710756]

perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5640193a8d44]

nptl/pthread_create.c:478(start_thread)[0x7fef4eb4d609]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fef4e71e133]

Query (0x62b0000c42a8): SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1

CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);

CREATE  VIEW  v1 AS SELECT  sys.format_time(tb.sum_timer_fetch) FROM performance_schema.table_io_waits_summary_by_index_usage tb ORDER BY tb.sum_timer_wait;

SELECT t1.id AS fld1 FROM v1, t1 WHERE rownum() = 1 GROUP BY fld1;

Attachments

Issue Links

relates to

MDEV-31073 Server crash, assertion `table != 0 && view->field_translation != 0' failure with ROWNUM and view

Closed

Activity

Ascending order - Click to sort in descending order

Alice Sherepa created issue - 2023-04-27 15:25

Alice Sherepa made changes - 2023-04-28 09:29

Field	Original Value	New Value
Description	{noformat} [ERROR] mysqld got signal 11 ; Server version: 10.6.13-MariaDB-debug-log source revision: 4a668c18926eca055a45b4153467bc6a5c50ff19 sql/signal_handler.cc:241(handle_fatal_signal)[0x55faba2f852d] /lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7f016ee33730] maria/ha_maria.cc:1106(ha_maria::scan_time())[0x55faba9604fc] sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x55faba6ea36c] sql/sql_select.cc:5113(get_quick_record_count(THD, SQL_SELECT, TABLE, Bitmap<64u> const, unsigned long long))[0x55fab9b7454c] sql/sql_select.cc:5840(make_join_statistics(JOIN, List<TABLE_LIST>&, st_dynamic_array))[0x55fab9b7b35a] sql/sql_select.cc:2509(JOIN::optimize_inner())[0x55fab9b59467] sql/sql_select.cc:1848(JOIN::optimize())[0x55fab9b52499] sql/sql_derived.cc:1045(mysql_derived_optimize(THD, LEX, TABLE_LIST))[0x55fab99b5629] sql/sql_derived.cc:200(mysql_handle_single_derived(LEX, TABLE_LIST, unsigned int))[0x55fab99afdf7] sql/sql_select.cc:2327(JOIN::optimize_inner())[0x55fab9b57904] sql/sql_select.cc:1848(JOIN::optimize())[0x55fab9b52499] sql/sql_select.cc:5055(mysql_select(THD, TABLE_LIST, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x55fab9b73c9e] sql/sql_select.cc:559(handle_select(THD, LEX, select_result, unsigned long))[0x55fab9b44191] sql/sql_parse.cc:6273(execute_sqlcom_select(THD, TABLE_LIST))[0x55fab9aa9521] sql/sql_parse.cc:3949(mysql_execute_command(THD, bool))[0x55fab9a97e04] sql/sql_parse.cc:8036(mysql_parse(THD, char, unsigned int, Parser_state))[0x55fab9ab435a] sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD, char, unsigned int, bool))[0x55fab9a8a8a1] sql/sql_parse.cc:1409(do_command(THD, bool))[0x55fab9a875a1] sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55fab9eee104] sql/sql_connect.cc:1320(handle_one_connection)[0x55fab9eeda5a] perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55fababf684f] nptl/pthread_create.c:487(start_thread)[0x7f016ee28fa3] {noformat} {noformat}	{code:sql} CREATE TABLE t1 (id int NOT NULL PRIMARY KEY); SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1; {code} {noformat} Version: '10.6.13-MariaDB-debug-log' 230428 11:26:28 [ERROR] mysqld got signal 11 ; Server version: 10.6.13-MariaDB-debug-log source revision: 2eb7bf1ec301d43a7e72b8720f6ee153dc52b6c9 sql/signal_handler.cc:241(handle_fatal_signal)[0x564018b2e716] sigaction.c:0(__restore_rt)[0x7fef4eb59420] maria/ha_maria.cc:1106(ha_maria::scan_time())[0x564019102df4] sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x564018f39b67] sql/sql_select.cc:5113(get_quick_record_count(THD, SQL_SELECT, TABLE, Bitmap<64u> const, unsigned long long))[0x56401838665b] sql/sql_select.cc:5840(make_join_statistics(JOIN, List<TABLE_LIST>&, st_dynamic_array))[0x56401838d400] sql/sql_select.cc:2509(JOIN::optimize_inner())[0x56401836b171] sql/sql_select.cc:1848(JOIN::optimize())[0x5640183641cf] sql/sql_select.cc:5055(mysql_select(THD, TABLE_LIST, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x564018385d68] sql/sql_select.cc:559(handle_select(THD, LEX, select_result, unsigned long))[0x564018355b9f] sql/sql_parse.cc:6273(execute_sqlcom_select(THD, TABLE_LIST))[0x5640182b6e8e] sql/sql_parse.cc:3949(mysql_execute_command(THD, bool))[0x5640182a57fb] sql/sql_parse.cc:8036(mysql_parse(THD, char, unsigned int, Parser_state))[0x5640182c21b9] sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD, char, unsigned int, bool))[0x56401829803a] sql/sql_parse.cc:1409(do_command(THD, bool))[0x564018294d85] sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT, bool))[0x564018710df9] sql/sql_connect.cc:1320(handle_one_connection)[0x564018710756] perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5640193a8d44] nptl/pthread_create.c:478(start_thread)[0x7fef4eb4d609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fef4e71e133] Query (0x62b0000c42a8): SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1 {noformat} {code:sql} CREATE TABLE t1 (id int NOT NULL PRIMARY KEY); CREATE VIEW v1 AS SELECT sys.format_time(tb.sum_timer_fetch) FROM performance_schema.table_io_waits_summary_by_index_usage tb ORDER BY tb.sum_timer_wait; SELECT t1.id AS fld1 FROM v1, t1 WHERE rownum() = 1 GROUP BY fld1; {code}

Alice Sherepa made changes - 2023-04-28 09:29

Summary

[draft] Server crashes in ha_maria::scan_time/QL_SELECT::test_quick_selec

Server crashes in ha_maria::scan_time/QL_SELECT::test_quick_select

Alice Sherepa made changes - 2023-04-28 09:29

Assignee

Alice Sherepa [ alice ]

Oleksandr Byelkin [ sanja ]

Alice Sherepa made changes - 2023-04-28 09:30

Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.10 [ 27530 ]

Alice Sherepa made changes - 2023-04-28 09:30

Fix Version/s

10.6 [ 24028 ]

Alice Sherepa made changes - 2023-04-28 09:30

Status

Open [ 1 ]

Confirmed [ 10101 ]

Alice Sherepa made changes - 2023-04-28 09:57

Labels

regression

Alice Sherepa made changes - 2023-04-28 09:59

Description

{code:sql}
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);
SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1;
{code}

{noformat}
Version: '10.6.13-MariaDB-debug-log'
230428 11:26:28 [ERROR] mysqld got signal 11 ;

Server version: 10.6.13-MariaDB-debug-log source revision: 2eb7bf1ec301d43a7e72b8720f6ee153dc52b6c9

sql/signal_handler.cc:241(handle_fatal_signal)[0x564018b2e716]
sigaction.c:0(__restore_rt)[0x7fef4eb59420]
maria/ha_maria.cc:1106(ha_maria::scan_time())[0x564019102df4]
sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x564018f39b67]
sql/sql_select.cc:5113(get_quick_record_count(THD*, SQL_SELECT*, TABLE*, Bitmap<64u> const*, unsigned long long))[0x56401838665b]
sql/sql_select.cc:5840(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x56401838d400]
sql/sql_select.cc:2509(JOIN::optimize_inner())[0x56401836b171]
sql/sql_select.cc:1848(JOIN::optimize())[0x5640183641cf]
sql/sql_select.cc:5055(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x564018385d68]
sql/sql_select.cc:559(handle_select(THD*, LEX*, select_result*, unsigned long))[0x564018355b9f]
sql/sql_parse.cc:6273(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5640182b6e8e]
sql/sql_parse.cc:3949(mysql_execute_command(THD*, bool))[0x5640182a57fb]
sql/sql_parse.cc:8036(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5640182c21b9]
sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x56401829803a]
sql/sql_parse.cc:1409(do_command(THD*, bool))[0x564018294d85]
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x564018710df9]
sql/sql_connect.cc:1320(handle_one_connection)[0x564018710756]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5640193a8d44]
nptl/pthread_create.c:478(start_thread)[0x7fef4eb4d609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fef4e71e133]

Query (0x62b0000c42a8): SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1
{noformat}
{code:sql}
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);
CREATE VIEW v1 AS SELECT sys.format_time(tb.sum_timer_fetch) FROM performance_schema.table_io_waits_summary_by_index_usage tb ORDER BY tb.sum_timer_wait;

SELECT t1.id AS fld1 FROM v1, t1 WHERE rownum() = 1 GROUP BY fld1;
{code}

regression after 5bada1246de48ef4a18fa30388f, repeatable after ~~MDEV-31073~~ fix:
{code:sql}
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);
SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1;
{code}

{noformat}
Version: '10.6.13-MariaDB-debug-log'
230428 11:26:28 [ERROR] mysqld got signal 11 ;

Server version: 10.6.13-MariaDB-debug-log source revision: 2eb7bf1ec301d43a7e72b8720f6ee153dc52b6c9

sql/signal_handler.cc:241(handle_fatal_signal)[0x564018b2e716]
sigaction.c:0(__restore_rt)[0x7fef4eb59420]
maria/ha_maria.cc:1106(ha_maria::scan_time())[0x564019102df4]
sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x564018f39b67]
sql/sql_select.cc:5113(get_quick_record_count(THD*, SQL_SELECT*, TABLE*, Bitmap<64u> const*, unsigned long long))[0x56401838665b]
sql/sql_select.cc:5840(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x56401838d400]
sql/sql_select.cc:2509(JOIN::optimize_inner())[0x56401836b171]
sql/sql_select.cc:1848(JOIN::optimize())[0x5640183641cf]
sql/sql_select.cc:5055(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x564018385d68]
sql/sql_select.cc:559(handle_select(THD*, LEX*, select_result*, unsigned long))[0x564018355b9f]
sql/sql_parse.cc:6273(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5640182b6e8e]
sql/sql_parse.cc:3949(mysql_execute_command(THD*, bool))[0x5640182a57fb]
sql/sql_parse.cc:8036(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5640182c21b9]
sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x56401829803a]
sql/sql_parse.cc:1409(do_command(THD*, bool))[0x564018294d85]
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x564018710df9]
sql/sql_connect.cc:1320(handle_one_connection)[0x564018710756]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5640193a8d44]
nptl/pthread_create.c:478(start_thread)[0x7fef4eb4d609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fef4e71e133]

Query (0x62b0000c42a8): SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1
{noformat}
{code:sql}
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);
CREATE VIEW v1 AS SELECT sys.format_time(tb.sum_timer_fetch) FROM performance_schema.table_io_waits_summary_by_index_usage tb ORDER BY tb.sum_timer_wait;

SELECT t1.id AS fld1 FROM v1, t1 WHERE rownum() = 1 GROUP BY fld1;
{code}

Alice Sherepa made changes - 2023-04-28 09:59

Priority

Major [ 3 ]

Blocker [ 1 ]

Alice Sherepa made changes - 2023-04-28 09:59

Link

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

Oleksandr Byelkin added a comment - 2023-04-28 12:29

It is temporary table of derived table (made from sys.schema_index_statistics?) has myisam handler but have no file reference (as vell as many other uninitialized fields)

Oleksandr Byelkin added a comment - 2023-04-28 12:29 It is temporary table of derived table (made from sys.schema_index_statistics?) has myisam handler but have no file reference (as vell as many other uninitialized fields)

Oleksandr Byelkin added a comment - 2023-04-28 12:45

Fix applied to ~~MDEV-31073~~ does not work here bacause it is not special case for materialization for rownum as it was there (several tables and actually ORDE BY in the outer most statement) but some part of the code definetly does not expect that sys.schema_index_statistics can be merged (can it really?)

Oleksandr Byelkin added a comment - 2023-04-28 12:45 Fix applied to MDEV-31073 does not work here bacause it is not special case for materialization for rownum as it was there (several tables and actually ORDE BY in the outer most statement) but some part of the code definetly does not expect that sys.schema_index_statistics can be merged (can it really?)

Oleksandr Byelkin added a comment - 2023-04-28 12:48

actually information schema AFAIK always shoud be matherialyzed derved

Oleksandr Byelkin added a comment - 2023-04-28 12:48 actually information schema AFAIK always shoud be matherialyzed derved

Oleksandr Byelkin made changes - 2023-04-28 17:26

Assignee

Oleksandr Byelkin [ sanja ]

Igor Babaev [ igor ]

Igor Babaev (Inactive) made changes - 2023-04-29 07:01

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Igor Babaev (Inactive) made changes - 2023-04-30 04:39

Summary

Server crashes in ha_maria::scan_time/QL_SELECT::test_quick_select

Crash for query using ROWNUM() over view with ORDER BY

Igor Babaev (Inactive) added a comment - 2023-04-30 05:00 - edited

The following test case causes a crash of the same kind as reported one.

create table t1 (id int primary key);

insert into t1 values (3), (7), (1);

create table t2 (a int);

insert into t2 values (2), (4);

create view v as select a from t2 order by a;

set big_tables= 1;

select t1.id from v, t1 where rownum() = 1 group by t1.id;

set big_tables=default;

drop view

drop table t1, t2

sql/signal_handler.cc:241(handle_fatal_signal)[0x557794bd49b1]

/lib64/libpthread.so.0(+0xf890)[0x7f6280744890]

maria/ha_maria.cc:1106(ha_maria::scan_time())[0x557794e78aaf]

sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x557794d85b17]

sql/sql_select.cc:5113(get_quick_record_count(THD*, SQL_SELECT*, TABLE*, Bitmap<64u> const*, unsigned long long))[0x5577948853bc]

sql/sql_select.cc:5841(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x557794887cd3]

sql/sql_select.cc:2509(JOIN::optimize_inner())[0x55779487ba5b]

sql/sql_select.cc:1848(JOIN::optimize())[0x5577948792a2]

sql/sql_select.cc:5055(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x557794885085]

sql/sql_select.cc:571(handle_select(THD*, LEX*, select_result*, unsigned long))[0x557794873d82]

sql/sql_parse.cc:6273(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5577948331e0]

sql/sql_parse.cc:3949(mysql_execute_command(THD*, bool))[0x55779482a58b]

sql/sql_parse.cc:8036(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x557794837f5b]

sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5577948245ce]

sql/sql_parse.cc:1410(do_command(THD*, bool))[0x557794822e74]

sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x5577949eabc7]

sql/sql_connect.cc:1320(handle_one_connection)[0x5577949ea931]

Igor Babaev (Inactive) added a comment - 2023-04-30 05:00 - edited The following test case causes a crash of the same kind as reported one. create table t1 (id int primary key ); insert into t1 values (3), (7), (1); create table t2 (a int ); insert into t2 values (2), (4); create view v as select a from t2 order by a; set big_tables= 1; select t1.id from v, t1 where rownum() = 1 group by t1.id; set big_tables= default ; drop view drop table t1, t2 sql/signal_handler.cc:241(handle_fatal_signal)[0x557794bd49b1] /lib64/libpthread.so.0(+0xf890)[0x7f6280744890] maria/ha_maria.cc:1106(ha_maria::scan_time())[0x557794e78aaf] sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x557794d85b17] sql/sql_select.cc:5113(get_quick_record_count(THD*, SQL_SELECT*, TABLE*, Bitmap<64u> const*, unsigned long long))[0x5577948853bc] sql/sql_select.cc:5841(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x557794887cd3] sql/sql_select.cc:2509(JOIN::optimize_inner())[0x55779487ba5b] sql/sql_select.cc:1848(JOIN::optimize())[0x5577948792a2] sql/sql_select.cc:5055(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x557794885085] sql/sql_select.cc:571(handle_select(THD*, LEX*, select_result*, unsigned long))[0x557794873d82] sql/sql_parse.cc:6273(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5577948331e0] sql/sql_parse.cc:3949(mysql_execute_command(THD*, bool))[0x55779482a58b] sql/sql_parse.cc:8036(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x557794837f5b] sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5577948245ce] sql/sql_parse.cc:1410(do_command(THD*, bool))[0x557794822e74] sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x5577949eabc7] sql/sql_connect.cc:1320(handle_one_connection)[0x5577949ea931]

Igor Babaev (Inactive) made changes - 2023-04-30 07:20

Status

In Progress [ 3 ]

In Review [ 10002 ]

Igor Babaev (Inactive) made changes - 2023-04-30 07:22

Assignee

Igor Babaev [ igor ]

Oleksandr Byelkin [ sanja ]

Oleksandr Byelkin made changes - 2023-04-30 15:30

Assignee	Oleksandr Byelkin [ sanja ]	Igor Babaev [ igor ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Oleksandr Byelkin added a comment - 2023-04-30 15:31

ok to push

Oleksandr Byelkin added a comment - 2023-04-30 15:31 ok to push

Igor Babaev (Inactive) added a comment - 2023-05-01 06:24

A fix for this bug was pushed into 10.6. It should be merged upstream as it is.

Igor Babaev (Inactive) added a comment - 2023-05-01 06:24 A fix for this bug was pushed into 10.6. It should be merged upstream as it is.

Igor Babaev (Inactive) made changes - 2023-05-01 06:24

Component/s		Views [ 10111 ]
Fix Version/s		10.6.13 [ 28514 ]
Fix Version/s		10.9.6 [ 28520 ]
Fix Version/s		10.10.4 [ 28522 ]
Fix Version/s		10.11.3 [ 28524 ]
Fix Version/s		10.8.8 [ 28518 ]
Fix Version/s		11.0.2 [ 28706 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

People

Assignee:: Igor Babaev (Inactive)

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2023-04-27 15:25

Updated:: 2023-05-02 07:58

Resolved:: 2023-05-01 06:24

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration