[MDEV-23187] Assorted assertion failures in json_find_path with certain collations - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Fix Version/s: 10.4.31, 10.5.22, 10.6.15, 10.9.8, 10.10.6, 10.11.5
Component/s: Character Sets, JSON
Labels:

Description

SET COLLATION_CONNECTION= ucs2_unicode_ci;

SELECT JSON_VALUE('["foo"]', '$**[0]') AS f;

10.2 debug a1e52e7f
mysqld: /data/src/10.2/strings/json_lib.c:1360: json_find_path: Assertion `0' failed.
200717 14:17:44 [ERROR] mysqld got signal 6 ;

#7 0x00007f1875a73f12 in __GI___assert_fail (assertion=0x5574f4d78879 "0", file=0x5574f4d787f8 "/data/src/10.2/strings/json_lib.c", line=1360, function=0x5574f4d78900 <__PRETTY_FUNCTION__.9403> "json_find_path") at assert.c:101
#8 0x00005574f490b38e in json_find_path (je=0x7f18705a6dc0, p=0x7f1854012808, p_cur_step=0x7f1854012c50, array_counters=0x7f18705a6d40) at /data/src/10.2/strings/json_lib.c:1360
#9 0x00005574f432f294 in Item_func_json_value::val_str (this=0x7f1854012748, str=0x7f18705a6fb0) at /data/src/10.2/sql/item_jsonfunc.cc:486
#10 0x00005574f418823b in Item::send (this=0x7f1854012748, protocol=0x7f18540010a8, buffer=0x7f18705a6fb0) at /data/src/10.2/sql/item.cc:6921
#11 0x00005574f3e0cc4b in Protocol::send_result_set_row (this=0x7f18540010a8, row_items=0x7f1854004f50) at /data/src/10.2/sql/protocol.cc:990
#12 0x00005574f3ea0db2 in select_send::send_data (this=0x7f1854012d48, items=...) at /data/src/10.2/sql/sql_class.cc:2731
#13 0x00005574f3f30833 in JOIN::exec_inner (this=0x7f1854012d68) at /data/src/10.2/sql/sql_select.cc:3514
#14 0x00005574f3f302b2 in JOIN::exec (this=0x7f1854012d68) at /data/src/10.2/sql/sql_select.cc:3433
#15 0x00005574f3f31468 in mysql_select (thd=0x7f1854000af0, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f1854012d48, unit=0x7f18540046e8, select_lex=0x7f1854004e28) at /data/src/10.2/sql/sql_select.cc:3833
#16 0x00005574f3f25626 in handle_select (thd=0x7f1854000af0, lex=0x7f1854004628, result=0x7f1854012d48, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:361
#17 0x00005574f3ef1070 in execute_sqlcom_select (thd=0x7f1854000af0, all_tables=0x0) at /data/src/10.2/sql/sql_parse.cc:6218
#18 0x00005574f3ee78f1 in mysql_execute_command (thd=0x7f1854000af0) at /data/src/10.2/sql/sql_parse.cc:3524
#19 0x00005574f3ef4da7 in mysql_parse (thd=0x7f1854000af0, rawbuf=0x7f1854012458 "SELECT JSON_VALUE('[\"foo\"]', '$**[0]') AS f", length=43, parser_state=0x7f18705a8610, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7733
#20 0x00005574f3ee30d3 in dispatch_command (command=COM_QUERY, thd=0x7f1854000af0, packet=0x7f185408d421 "", packet_length=43, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824
#21 0x00005574f3ee1b4e in do_command (thd=0x7f1854000af0) at /data/src/10.2/sql/sql_parse.cc:1377
#22 0x00005574f4037b29 in do_handle_one_connection (connect=0x5574f7d44d00) at /data/src/10.2/sql/sql_connect.cc:1336
#23 0x00005574f4037894 in handle_one_connection (arg=0x5574f7d44d00) at /data/src/10.2/sql/sql_connect.cc:1241
#24 0x00005574f484e352 in pfs_spawn_thread (arg=0x5574f7d4faf0) at /data/src/10.2/storage/perfschema/pfs.cc:1869
#25 0x00007f18779fc4a4 in start_thread (arg=0x7f18705a9700) at pthread_create.c:456
#26 0x00007f1875b30d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Non-debug build returns NULL, I can't tell whether it's correct or not (with a standard collation it returns foo):

10.2 non-debug a1e52e7f
SET COLLATION_CONNECTION= ucs2_unicode_ci;
SELECT JSON_VALUE('["foo"]', '$**[0]') AS f;
f
NULL
SET COLLATION_CONNECTION= DEFAULT;
SELECT JSON_VALUE('["foo"]', '$**[0]') AS f;
f
foo

Attachments

Issue Links

is duplicated by

MDEV-25375 Assertion `0' failed in json_find_path

Closed

relates to

MDEV-28480 Assertion `0' failed in Item_row::illegal_method_call on SELECT FROM JSON_TABLE

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2020-07-15 21:36

Elena Stepanova made changes - 2020-07-17 10:51

Field	Original Value	New Value
Assignee		Elena Stepanova [ elenst ]

Elena Stepanova made changes - 2020-07-17 11:22

Component/s		Character Sets [ 10801 ]
Component/s		JSON [ 13908 ]
Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Affects Version/s		10.2 [ 14601 ]
Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Assignee	Elena Stepanova [ elenst ]	Alexey Botchkov [ holyfoot ]
Description		{code:sql} SET COLLATION_CONNECTION= ucs2_unicode_ci; SELECT JSON_VALUE('["foo"]', '$[0]') AS f; {code} {noformat:title=10.2 debug a1e52e7f} mysqld: /data/src/10.2/strings/json_lib.c:1360: json_find_path: Assertion `0' failed. 200717 14:17:44 [ERROR] mysqld got signal 6 ; #7 0x00007f1875a73f12 in __GI___assert_fail (assertion=0x5574f4d78879 "0", file=0x5574f4d787f8 "/data/src/10.2/strings/json_lib.c", line=1360, function=0x5574f4d78900 <__PRETTY_FUNCTION__.9403> "json_find_path") at assert.c:101 #8 0x00005574f490b38e in json_find_path (je=0x7f18705a6dc0, p=0x7f1854012808, p_cur_step=0x7f1854012c50, array_counters=0x7f18705a6d40) at /data/src/10.2/strings/json_lib.c:1360 #9 0x00005574f432f294 in Item_func_json_value::val_str (this=0x7f1854012748, str=0x7f18705a6fb0) at /data/src/10.2/sql/item_jsonfunc.cc:486 #10 0x00005574f418823b in Item::send (this=0x7f1854012748, protocol=0x7f18540010a8, buffer=0x7f18705a6fb0) at /data/src/10.2/sql/item.cc:6921 #11 0x00005574f3e0cc4b in Protocol::send_result_set_row (this=0x7f18540010a8, row_items=0x7f1854004f50) at /data/src/10.2/sql/protocol.cc:990 #12 0x00005574f3ea0db2 in select_send::send_data (this=0x7f1854012d48, items=...) at /data/src/10.2/sql/sql_class.cc:2731 #13 0x00005574f3f30833 in JOIN::exec_inner (this=0x7f1854012d68) at /data/src/10.2/sql/sql_select.cc:3514 #14 0x00005574f3f302b2 in JOIN::exec (this=0x7f1854012d68) at /data/src/10.2/sql/sql_select.cc:3433 #15 0x00005574f3f31468 in mysql_select (thd=0x7f1854000af0, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f1854012d48, unit=0x7f18540046e8, select_lex=0x7f1854004e28) at /data/src/10.2/sql/sql_select.cc:3833 #16 0x00005574f3f25626 in handle_select (thd=0x7f1854000af0, lex=0x7f1854004628, result=0x7f1854012d48, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:361 #17 0x00005574f3ef1070 in execute_sqlcom_select (thd=0x7f1854000af0, all_tables=0x0) at /data/src/10.2/sql/sql_parse.cc:6218 #18 0x00005574f3ee78f1 in mysql_execute_command (thd=0x7f1854000af0) at /data/src/10.2/sql/sql_parse.cc:3524 #19 0x00005574f3ef4da7 in mysql_parse (thd=0x7f1854000af0, rawbuf=0x7f1854012458 "SELECT JSON_VALUE('[\"foo\"]', '$[0]') AS f", length=43, parser_state=0x7f18705a8610, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7733 #20 0x00005574f3ee30d3 in dispatch_command (command=COM_QUERY, thd=0x7f1854000af0, packet=0x7f185408d421 "", packet_length=43, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824 #21 0x00005574f3ee1b4e in do_command (thd=0x7f1854000af0) at /data/src/10.2/sql/sql_parse.cc:1377 #22 0x00005574f4037b29 in do_handle_one_connection (connect=0x5574f7d44d00) at /data/src/10.2/sql/sql_connect.cc:1336 #23 0x00005574f4037894 in handle_one_connection (arg=0x5574f7d44d00) at /data/src/10.2/sql/sql_connect.cc:1241 #24 0x00005574f484e352 in pfs_spawn_thread (arg=0x5574f7d4faf0) at /data/src/10.2/storage/perfschema/pfs.cc:1869 #25 0x00007f18779fc4a4 in start_thread (arg=0x7f18705a9700) at pthread_create.c:456 #26 0x00007f1875b30d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 {noformat} Non-debug build returns NULL, I can't tell whether it's correct or not (with a standard collation it returns {{foo}}): {code:sql\|title=10.2 non-debug a1e52e7f} SET COLLATION_CONNECTION= ucs2_unicode_ci; SELECT JSON_VALUE('["foo"]', '$[0]') AS f; f NULL SET COLLATION_CONNECTION= DEFAULT; SELECT JSON_VALUE('["foo"]', '$[0]') AS f; f foo {code}
Summary	Assertion `!new_field->field_name.str \|\| strlen(new_field->field_name.str) == new_field->field_name.length' failed in create_tmp_table or alike hl	Assertion `0' failed in json_find_path with certain collations

Ramesh Sivaraman made changes - 2021-04-09 09:27

Link

This issue is duplicated by ~~MDEV-25375~~ [ ~~MDEV-25375~~ ]

Ramesh Sivaraman made changes - 2021-04-09 09:45

Link

This issue is duplicated by ~~MDEV-25375~~ [ ~~MDEV-25375~~ ]

Ramesh Sivaraman made changes - 2021-04-09 09:47

Link

This issue is duplicated by ~~MDEV-25375~~ [ ~~MDEV-25375~~ ]

Sergei Golubchik made changes - 2021-12-06 21:34

Workflow

MariaDB v3 [ 111278 ]

MariaDB v4 [ 142095 ]

Roel Van de Paar made changes - 2022-05-05 22:59

Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.7 [ 24805 ]
Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]

Roel Van de Paar made changes - 2022-05-05 22:59

Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.7 [ 24805 ]

Roel Van de Paar made changes - 2022-05-06 00:07

Status

Open [ 1 ]

Confirmed [ 10101 ]

Roel Van de Paar made changes - 2022-05-06 00:34

Link

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

Roel Van de Paar made changes - 2022-05-06 00:34

Labels

affects-tests

Nayuta Yanagisawa (Inactive) made changes - 2022-06-01 08:07

Assignee

Alexey Botchkov [ holyfoot ]

Rucha Deodhar [ rucha174 ]

Roel Van de Paar made changes - 2022-06-08 09:02

Labels

affects-tests

affects-tests regression-10.4

Roel Van de Paar made changes - 2022-06-08 09:02

Affects Version/s

10.10 [ 27530 ]

Roel Van de Paar made changes - 2022-06-08 09:03

Fix Version/s		10.8 [ 26121 ]
Fix Version/s	10.2 [ 14601 ]

Roel Van de Paar made changes - 2022-06-08 09:03

Affects Version/s

10.2 [ 14601 ]

Roel Van de Paar made changes - 2022-08-24 08:36

Affects Version/s

10.11 [ 27614 ]

Roel Van de Paar made changes - 2022-08-24 08:36

Fix Version/s

10.9 [ 26905 ]

Roel Van de Paar made changes - 2022-08-24 08:37

Fix Version/s

10.10 [ 27530 ]

Roel Van de Paar made changes - 2022-09-01 21:57

Labels

affects-tests regression-10.4

affects-tests regression-10.4 regression-10.9

Roel Van de Paar made changes - 2022-09-01 21:57

Priority

Major [ 3 ]

Critical [ 2 ]

Roel Van de Paar made changes - 2022-09-01 22:00

Summary

Assertion `0' failed in json_find_path with certain collations

Assertion `0' failed in json_find_path with certain collations, SIGSEGV in my_mb_wc_utf8mb3_quick when using JSON_VALUE

Roel Van de Paar made changes - 2022-09-01 22:01

Summary

Assertion `0' failed in json_find_path with certain collations, SIGSEGV in my_mb_wc_utf8mb3_quick when using JSON_VALUE

Assertion `0' failed in json_find_path with certain collations and SIGSEGV in my_mb_wc_utf8mb3_quick when using JSON_VALUE

Roel Van de Paar made changes - 2022-12-17 03:01

Summary

Assertion `0' failed in json_find_path with certain collations and SIGSEGV in my_mb_wc_utf8mb3_quick when using JSON_VALUE

Assertion `0' failed in json_find_path with certain collations, Assertion `cur_step->type & JSON_PATH_ARRAY' failed, and SIGSEGV in my_mb_wc_utf8mb3_quick when using JSON_VALUE

Roel Van de Paar made changes - 2023-01-10 00:47

Affects Version/s

11.0 [ 28320 ]

Roel Van de Paar made changes - 2023-01-10 00:47

Fix Version/s

10.11 [ 27614 ]

Roel Van de Paar made changes - 2023-01-14 00:58

Summary

Assertion `0' failed in json_find_path with certain collations, Assertion `cur_step->type & JSON_PATH_ARRAY' failed, and SIGSEGV in my_mb_wc_utf8mb3_quick when using JSON_VALUE

Assertion `0' failed in json_find_path with certain collations, Assertion `cur_step->type & JSON_PATH_ARRAY' failed, and SIGSEGV in my_mb_wc_utf8mb3_quick when using JSON_VALUE, SIGSEV's in my_mb_wc_utf32_quick and my_mb_wc_utf32_quick

Roel Van de Paar made changes - 2023-01-14 02:01

Summary

Elena Stepanova made changes - 2023-01-14 10:58

Summary

Assorted assertion failures in json_find_path with certain collations

Julien Fritsch made changes - 2023-03-03 17:26

Fix Version/s

10.7 [ 24805 ]

Rucha Deodhar made changes - 2023-04-03 13:05

Assignee	Rucha Deodhar [ rucha174 ]	Alexey Botchkov [ holyfoot ]
Status	Confirmed [ 10101 ]	In Review [ 10002 ]

Alexey Botchkov made changes - 2023-04-14 06:51

Assignee	Alexey Botchkov [ holyfoot ]	Rucha Deodhar [ rucha174 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Rucha Deodhar made changes - 2023-04-17 08:52

Assignee	Rucha Deodhar [ rucha174 ]	Alexey Botchkov [ holyfoot ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Alexey Botchkov made changes - 2023-04-22 11:46

Assignee	Alexey Botchkov [ holyfoot ]	Rucha Deodhar [ rucha174 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Julien Fritsch made changes - 2023-04-27 13:54

Fix Version/s

10.3 [ 22126 ]

Julien Fritsch made changes - 2023-04-27 14:45

Fix Version/s

10.8 [ 26121 ]

Rucha Deodhar made changes - 2023-05-16 05:37

Fix Version/s		10.4.30 [ 28912 ]
Fix Version/s		10.5.21 [ 28913 ]
Fix Version/s		10.6.14 [ 28914 ]
Fix Version/s		10.9.7 [ 28916 ]
Fix Version/s		10.10.5 [ 28917 ]
Fix Version/s		10.11.4 [ 28918 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.9 [ 26905 ]
Fix Version/s	10.10 [ 27530 ]
Fix Version/s	10.11 [ 27614 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Daniel Bartholomew made changes - 2023-06-07 12:46

Fix Version/s		10.4.31 [ 29010 ]
Fix Version/s		10.5.22 [ 29011 ]
Fix Version/s		10.6.15 [ 29013 ]
Fix Version/s		10.9.8 [ 29015 ]
Fix Version/s		10.10.6 [ 29017 ]
Fix Version/s		10.11.5 [ 29019 ]
Fix Version/s	10.4.30 [ 28912 ]
Fix Version/s	10.5.21 [ 28913 ]
Fix Version/s	10.6.14 [ 28914 ]
Fix Version/s	10.9.7 [ 28916 ]
Fix Version/s	10.10.5 [ 28917 ]
Fix Version/s	10.11.4 [ 28918 ]

People

Assignee:: Rucha Deodhar

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2020-07-15 21:36

Updated:: 2023-07-05 11:05

Resolved:: 2023-05-16 05:37

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