Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
12.1
-
None
-
Q2/2025 Development
Description
Testcase:
set SQL_MODE= oracle; |
select a.a |
from (select 1 as a) a, |
(select 2 as b) b |
where a.a=b.b(+); |
Stacktrace:
Thread pointer: 0x7f40a0000dc8
|
stack_bottom = 0x7f40d409d000 thread_stack 0x49000
|
mysys/stacktrace.c:215(my_print_stacktrace)[0x64f688db036e]
|
sql/signal_handler.cc:230(handle_fatal_signal)[0x64f68837ea6f]
|
libc_sigaction.c:0(__restore_rt)[0x7f40db642520]
|
nptl/pthread_kill.c:44(__pthread_kill_implementation)[0x7f40db6969fc]
|
posix/raise.c:27(__GI_raise)[0x7f40db642476]
|
stdlib/abort.c:81(__GI_abort)[0x7f40db6287f3]
|
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f40db62871b]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x39e96)[0x7f40db639e96]
|
sql/item.cc:10250(Item_field::ora_join_processor(void*))[0x64f6883c7eab]
|
/home/elena/work/MariaDB/main/bld/sql/mariadbd(+0xa63a8e)[0x64f687d73a8e] |
sql/item.h:2209(Item::walk(bool (Item::*)(void*), void*, unsigned char))[0x64f687db3ec7] |
sql/item.h:2903(Item_args::walk_args(bool (Item::*)(void*), void*, unsigned char))[0x64f687db4678] |
sql/item.h:5886(Item_func_or_sum::walk(bool (Item::*)(void*), void*, unsigned char))[0x64f687f23a12] |
sql/sql_oracle_outer_join.cc:308(ora_join_process_expression(THD*, Item*, table_pos*, unsigned int))[0x64f687f24f4a] |
sql/sql_oracle_outer_join.cc:764(setup_oracle_join(THD*, Item**, TABLE_LIST*, SQL_I_List<TABLE_LIST>&, List<TABLE_LIST>*))[0x64f687e6d209]
|
sql/sql_base.cc:8969(setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**))[0x64f687f9be4b]
|
sql/sql_select.cc:957(setup_without_group(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<TABLE_LIST>&, List<Item>&, List<Item>&, Item**, st_order*, st_order*, List<Window_spec>&, List<Item_window_func>&, bool*))[0x64f687f9f1e5]
|
sql/sql_select.cc:1590(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x64f687fad324] |
sql/sql_select.cc:5366(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*))[0x64f687f9b368] |
sql/sql_select.cc:634(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x64f687f3bb74]
|
sql/sql_parse.cc:6166(execute_sqlcom_select(THD*, TABLE_LIST*))[0x64f687f33770]
|
sql/sql_parse.cc:3954(mysql_execute_command(THD*, bool))[0x64f687f40c11]
|
sql/sql_parse.cc:7882(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x64f687f2cfda] |
sql/sql_parse.cc:1879(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x64f687f2b945] |
sql/sql_parse.cc:1416(do_command(THD*, bool))[0x64f68813ad3f]
|
sql/sql_connect.cc:1414(do_handle_one_connection(CONNECT*, bool))[0x64f68813aab4] |
sql/sql_connect.cc:1328(handle_one_connection)[0x64f68873a697]
|
nptl/pthread_create.c:442(start_thread)[0x7f40db694ac3]
|
x86_64/clone3.S:83(__clone3)[0x7f40db726850]
|
Attachments
Issue Links
- blocks
-
MDEV-13817 add support for oracle outer join syntax - the ( + )
-
- Closed
-
- is caused by
-
MDEV-13817 add support for oracle outer join syntax - the ( + )
-
- Closed
-