Details
Critical Description
SET sql_mode=''; |
CREATE TABLE t (f SET('1','2','3','4','5','6','7','8','9','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1')); |
INSERT INTO t VALUES ('0'); |
Leads to
|
11.3.0 fa64a7a10cb23475c3008ff3d935d12659d2a81f (Optimized, UBASAN) |
/test/mtest/MDEV-31606/11.3_opt_san/sql/field.cc:9459:35: runtime error: shift exponent 65 is too large for 64-bit type 'long long int'
|
#0 0x558f877fd78d in Field_set::store(char const*, unsigned long, charset_info_st const*) /test/mtest/MDEV-31606/11.3_opt_san/sql/field.cc:9459
|
#1 0x558f85f17f7d in fill_record(THD*, TABLE*, Field**, List<Item>&, bool, bool) /test/mtest/MDEV-31606/11.3_opt_san/sql/sql_base.cc:9320
|
#2 0x558f85f196af in fill_record_n_invoke_before_triggers(THD*, TABLE*, Field**, List<Item>&, bool, trg_event_type) /test/mtest/MDEV-31606/11.3_opt_san/sql/sql_base.cc:9375
|
#3 0x558f86107784 in mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*) /test/mtest/MDEV-31606/11.3_opt_san/sql/sql_insert.cc:1097
|
#4 0x558f862f9771 in mysql_execute_command(THD*, bool) /test/mtest/MDEV-31606/11.3_opt_san/sql/sql_parse.cc:4416
|
#5 0x558f86285fb0 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /test/mtest/MDEV-31606/11.3_opt_san/sql/sql_parse.cc:7732
|
#6 0x558f862dcd28 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /test/mtest/MDEV-31606/11.3_opt_san/sql/sql_parse.cc:1893
|
#7 0x558f862e842d in do_command(THD*, bool) /test/mtest/MDEV-31606/11.3_opt_san/sql/sql_parse.cc:1406
|
#8 0x558f86c2871d in do_handle_one_connection(CONNECT*, bool) /test/mtest/MDEV-31606/11.3_opt_san/sql/sql_connect.cc:1445
|
#9 0x558f86c2ad8c in handle_one_connection /test/mtest/MDEV-31606/11.3_opt_san/sql/sql_connect.cc:1347
|
#10 0x14d39fc5a608 in start_thread /build/glibc-SzIz7B/glibc-2.31/nptl/pthread_create.c:477
|
#11 0x14d39eecf132 in __clone (/lib/x86_64-linux-gnu/libc.so.6+0x11f132)
|
Attachments
Issue Links
- relates to
-
MDEV-36013 UBSAN: runtime error: X is outside the range of representable values of type 'long long' on INSERT to SET()
-
- Confirmed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
{code:sql}
SET sql_mode=''; CREATE TABLE t (f SET('1','2','3','4','5','6','7','8','9','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1')); INSERT INTO t VALUES ('0'); {code} Leads to {noformat:title=11.0.3 5fb2c031f7c624dfdd49bb35faad58ea35d238af (Optimized, UBASAN)} /test/11.0_opt_san/sql/field.cc:9459:35: runtime error: shift exponent 65 is too large for 64-bit type 'long long int' #0 0x5638f5af29ad in Field_set::store(char const*, unsigned long, charset_info_st const*) /test/11.0_opt_san/sql/field.cc:9459 #1 0x5638f42f4a1d in fill_record(THD*, TABLE*, Field**, List<Item>&, bool, bool) /test/11.0_opt_san/sql/sql_base.cc:9259 #2 0x5638f42f614f in fill_record_n_invoke_before_triggers(THD*, TABLE*, Field**, List<Item>&, bool, trg_event_type) /test/11.0_opt_san/sql/sql_base.cc:9314 #3 0x5638f44dcc72 in mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*) /test/11.0_opt_san/sql/sql_insert.cc:1097 #4 0x5638f46cc963 in mysql_execute_command(THD*, bool) /test/11.0_opt_san/sql/sql_parse.cc:4569 #5 0x5638f4654620 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /test/11.0_opt_san/sql/sql_parse.cc:8014 #6 0x5638f46a9ea8 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /test/11.0_opt_san/sql/sql_parse.cc:1894 #7 0x5638f46b561d in do_command(THD*, bool) /test/11.0_opt_san/sql/sql_parse.cc:1407 #8 0x5638f4fdbc5d in do_handle_one_connection(CONNECT*, bool) /test/11.0_opt_san/sql/sql_connect.cc:1416 #9 0x5638f4fde2cc in handle_one_connection /test/11.0_opt_san/sql/sql_connect.cc:1318 #10 0x14be0d24b608 in start_thread /build/glibc-SzIz7B/glibc-2.31/nptl/pthread_create.c:477 #11 0x14be0c4c0132 in __clone (/lib/x86_64-linux-gnu/libc.so.6+0x11f132) {noformat} |
{code:sql}
SET sql_mode=''; CREATE TABLE t (f SET('1','2','3','4','5','6','7','8','9','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1')); INSERT INTO t VALUES ('0'); {code} Leads to {noformat:title=11.3.0 fa64a7a10cb23475c3008ff3d935d12659d2a81f (Optimized, UBASAN)} /test/mtest/ #0 0x558f877fd78d in Field_set::store(char const*, unsigned long, charset_info_st const*) /test/mtest/ #1 0x558f85f17f7d in fill_record(THD*, TABLE*, Field**, List<Item>&, bool, bool) /test/mtest/ #2 0x558f85f196af in fill_record_n_invoke_before_triggers(THD*, TABLE*, Field**, List<Item>&, bool, trg_event_type) /test/mtest/ #3 0x558f86107784 in mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*) /test/mtest/ #4 0x558f862f9771 in mysql_execute_command(THD*, bool) /test/mtest/ #5 0x558f86285fb0 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /test/mtest/ #6 0x558f862dcd28 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /test/mtest/ #7 0x558f862e842d in do_command(THD*, bool) /test/mtest/ #8 0x558f86c2871d in do_handle_one_connection(CONNECT*, bool) /test/mtest/ #9 0x558f86c2ad8c in handle_one_connection /test/mtest/ #10 0x14d39fc5a608 in start_thread /build/glibc-SzIz7B/glibc-2.31/nptl/pthread_create.c:477 #11 0x14d39eecf132 in __clone (/lib/x86_64-linux-gnu/libc.so.6+0x11f132) {noformat} |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Alexander Barkov [ bar ] |
| issue.field.resolutiondate | 2023-10-05 06:36:38.0 | 2023-10-05 06:36:38.196 |
| Component/s | Data types [ 13906 ] | |
| Fix Version/s | 10.4.32 [ 29300 ] | |
| Fix Version/s | 10.5.23 [ 29012 ] | |
| Fix Version/s | 10.6.16 [ 29014 ] | |
| Fix Version/s | 10.10.7 [ 29018 ] | |
| Fix Version/s | 10.11.6 [ 29020 ] | |
| Fix Version/s | 11.0.4 [ 29021 ] | |
| Fix Version/s | 11.1.3 [ 29023 ] | |
| Fix Version/s | 11.2.2 [ 29035 ] | |
| Fix Version/s | 11.3.1 [ 29416 ] | |
| Fix Version/s | 10.9.8 [ 29015 ] | |
| Fix Version/s | 10.8.8 [ 28518 ] | |
| 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 ] | |
| Fix Version/s | 11.0 [ 28320 ] | |
| Fix Version/s | 11.1 [ 28549 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Link | This issue relates to MDEV-36013 [ MDEV-36013 ] |