Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
CREATE TABLE t1 (b1 BIT, b2 BIT, b3 BIT, b4 BIT , b5 BIT, b6 BIT); |
INSERT INTO t1 VALUES (1,0,0,1,0,1),(0,1,0,0,1,0); |
|
SELECT b1 |
from t1 |
order by row_number() over (ORDER BY b6) + 1; |
|
# Cleanup
|
DROP TABLE t1; |
#0 0x0000555555a5124a in Field::set_notnull (this=0x0, row_offset=0)
|
at /home/vicentiu/Workspace/MariaDB/sql/field.h:1137
|
#1 0x0000555555d9cfb5 in Item::save_in_field (this=0x7fffd4013348, field=0x0, no_conversions=true)
|
at /home/vicentiu/Workspace/MariaDB/sql/item.cc:6441
|
#2 0x0000555555ccba48 in save_window_function_values (window_functions=..., tbl=0x7fffd402d168,
|
rowid_buf=0x7fffd4006c50 "P7\003\324\377\177") at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2517
|
#3 0x0000555555ccbe7f in compute_window_func (thd=0x7fffd4000d60, window_functions=..., cursor_managers=...,
|
tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2636
|
#4 0x0000555555ccc238 in Window_func_runner::exec (this=0x7fffd4015be0, thd=0x7fffd4000d60, tbl=0x7fffd402d168,
|
filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2742
|
#5 0x0000555555ccc351 in Window_funcs_sort::exec (this=0x7fffd4015bd8, join=0x7fffd40136d0)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2767
|
#6 0x0000555555ccc817 in Window_funcs_computation::exec (this=0x7fffd4015bb8, join=0x7fffd40136d0)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2886
|
#7 0x0000555555b8c8e0 in AGGR_OP::end_send (this=0x7fffd4015860)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:26530
|
#8 0x0000555555b77b65 in sub_select_postjoin_aggr (join=0x7fffd40136d0, join_tab=0x7fffd4014b38, end_of_records=true)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18369
|
#9 0x0000555555b77e94 in sub_select (join=0x7fffd40136d0, join_tab=0x7fffd4014788, end_of_records=true)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18605
|
#10 0x0000555555b7769d in do_select (join=0x7fffd40136d0, procedure=0x0)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18200
|
#11 0x0000555555b5226a in JOIN::exec_inner (this=0x7fffd40136d0)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3530
|
#12 0x0000555555b51718 in JOIN::exec (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3325
|
#13 0x0000555555b528dc in mysql_select (thd=0x7fffd4000d60, tables=0x7fffd4012a20, wild_num=0, fields=..., conds=0x0,
|
og_num=1, order=0x7fffd4013590, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608,
|
result=0x7fffd40136b0, unit=0x7fffd4004900, select_lex=0x7fffd4005038)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3725
|
#14 0x0000555555b47110 in handle_select (thd=0x7fffd4000d60, lex=0x7fffd4004838, result=0x7fffd40136b0,
|
setup_tables_done_option=0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:361
|
#15 0x0000555555b13221 in execute_sqlcom_select (thd=0x7fffd4000d60, all_tables=0x7fffd4012a20)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:6459
|
#16 0x0000555555b08ee9 in mysql_execute_command (thd=0x7fffd4000d60)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:3463
|
#17 0x0000555555b16bd1 in mysql_parse (thd=0x7fffd4000d60,
|
rawbuf=0x7fffd40127e8 "SELECT b1\nfrom t1\norder by row_number() over (ORDER BY b6) + 1", length=62,
|
parser_state=0x7fffeb582170, is_com_multi=false, is_next_command=false)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:7900
|
#18 0x0000555555b04819 in dispatch_command (command=COM_QUERY, thd=0x7fffd4000d60, packet=0x7fffd4008ba1 "",
|
packet_length=62, is_com_multi=false, is_next_command=false)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1804
|
#19 0x0000555555b031b2 in do_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1359
|
#20 0x0000555555c4fbd8 in do_handle_one_connection (connect=0x555557bea3f0)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1335
|
#21 0x0000555555c4f958 in handle_one_connection (arg=0x555557bea3f0)
|
at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1241
|
#22 0x000055555648a035 in pfs_spawn_thread (arg=0x555557bf2e60)
|
at /home/vicentiu/Workspace/MariaDB/storage/perfschema/pfs.cc:1863
|
#23 0x00007ffff7bc108a in start_thread () from /usr/lib/libpthread.so.0
|
#24 0x00007ffff5ac542f in clone () from /usr/lib/libc.so.6
|
|
Attachments
Issue Links
- duplicates
-
MDEV-16736 crash on lag() over() and order not working
-
- Closed
-
-
MDEV-17242 Wrong result from distinct and arithmetic expression using window function
-
- Closed
-
- is duplicated by
-
MDEV-15212 server crashed, query using ORDER BY (expression with window function)
-
- Closed
-
-
MDEV-16835 Server crash in Item_sum_hybrid::clear()
-
- Closed
-
-
MDEV-19072 Wrong results from query, using expression with aggregated function and window function
-
- Closed
-
-
MDEV-24191 A bug occurs when an operation is put in the OVER query. Mysqld will be restart
-
- Closed
-
- relates to
-
MDEV-16835 Server crash in Item_sum_hybrid::clear()
-
- Closed
-
-
MDEV-24374 Crash with order by expression containing window functions
-
- Closed
-
-
MDEV-25630 Crash with window function in left expr of IN subquery
-
- Closed
-
-
MDEV-26416 A SEGV in Field::set_notnull/Item::save_real_in_field
-
- Confirmed
-
Activity
Field | Original Value | New Value |
---|---|---|
Description |
{code:sql}
CREATE TABLE t1 (b1 BIT, b2 BIT, b3 BIT, b4 BIT , b5 BIT, b6 BIT); INSERT INTO t1 VALUES (1,0,0,1,0,1),(0,1,0,0,1,0); #SELECT DISTINCT * FROM t1; SELECT b1 from t1 order by row_number() over (ORDER BY b6) + 1; # Cleanup DROP TABLE t1; {code} {noformat} #0 0x0000555555a5124a in Field::set_notnull (this=0x0, row_offset=0) at /home/vicentiu/Workspace/MariaDB/sql/field.h:1137 #1 0x0000555555d9cfb5 in Item::save_in_field (this=0x7fffd4013348, field=0x0, no_conversions=true) at /home/vicentiu/Workspace/MariaDB/sql/item.cc:6441 #2 0x0000555555ccba48 in save_window_function_values (window_functions=..., tbl=0x7fffd402d168, rowid_buf=0x7fffd4006c50 "P7\003\324\377\177") at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2517 #3 0x0000555555ccbe7f in compute_window_func (thd=0x7fffd4000d60, window_functions=..., cursor_managers=..., tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2636 #4 0x0000555555ccc238 in Window_func_runner::exec (this=0x7fffd4015be0, thd=0x7fffd4000d60, tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2742 #5 0x0000555555ccc351 in Window_funcs_sort::exec (this=0x7fffd4015bd8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2767 #6 0x0000555555ccc817 in Window_funcs_computation::exec (this=0x7fffd4015bb8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2886 #7 0x0000555555b8c8e0 in AGGR_OP::end_send (this=0x7fffd4015860) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:26530 #8 0x0000555555b77b65 in sub_select_postjoin_aggr (join=0x7fffd40136d0, join_tab=0x7fffd4014b38, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18369 #9 0x0000555555b77e94 in sub_select (join=0x7fffd40136d0, join_tab=0x7fffd4014788, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18605 #10 0x0000555555b7769d in do_select (join=0x7fffd40136d0, procedure=0x0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18200 #11 0x0000555555b5226a in JOIN::exec_inner (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3530 #12 0x0000555555b51718 in JOIN::exec (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3325 #13 0x0000555555b528dc in mysql_select (thd=0x7fffd4000d60, tables=0x7fffd4012a20, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7fffd4013590, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fffd40136b0, unit=0x7fffd4004900, select_lex=0x7fffd4005038) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3725 #14 0x0000555555b47110 in handle_select (thd=0x7fffd4000d60, lex=0x7fffd4004838, result=0x7fffd40136b0, setup_tables_done_option=0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:361 #15 0x0000555555b13221 in execute_sqlcom_select (thd=0x7fffd4000d60, all_tables=0x7fffd4012a20) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:6459 #16 0x0000555555b08ee9 in mysql_execute_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:3463 #17 0x0000555555b16bd1 in mysql_parse (thd=0x7fffd4000d60, rawbuf=0x7fffd40127e8 "SELECT b1\nfrom t1\norder by row_number() over (ORDER BY b6) + 1", length=62, parser_state=0x7fffeb582170, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:7900 #18 0x0000555555b04819 in dispatch_command (command=COM_QUERY, thd=0x7fffd4000d60, packet=0x7fffd4008ba1 "", packet_length=62, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1804 #19 0x0000555555b031b2 in do_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1359 #20 0x0000555555c4fbd8 in do_handle_one_connection (connect=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1335 #21 0x0000555555c4f958 in handle_one_connection (arg=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1241 #22 0x000055555648a035 in pfs_spawn_thread (arg=0x555557bf2e60) at /home/vicentiu/Workspace/MariaDB/storage/perfschema/pfs.cc:1863 #23 0x00007ffff7bc108a in start_thread () from /usr/lib/libpthread.so.0 #24 0x00007ffff5ac542f in clone () from /usr/lib/libc.so.6 {noformat} |
{code:sql}
CREATE TABLE t1 (b1 BIT, b2 BIT, b3 BIT, b4 BIT , b5 BIT, b6 BIT); INSERT INTO t1 VALUES (1,0,0,1,0,1),(0,1,0,0,1,0); SELECT b1 from t1 order by row_number() over (ORDER BY b6) + 1; # Cleanup DROP TABLE t1; {code} {noformat} #0 0x0000555555a5124a in Field::set_notnull (this=0x0, row_offset=0) at /home/vicentiu/Workspace/MariaDB/sql/field.h:1137 #1 0x0000555555d9cfb5 in Item::save_in_field (this=0x7fffd4013348, field=0x0, no_conversions=true) at /home/vicentiu/Workspace/MariaDB/sql/item.cc:6441 #2 0x0000555555ccba48 in save_window_function_values (window_functions=..., tbl=0x7fffd402d168, rowid_buf=0x7fffd4006c50 "P7\003\324\377\177") at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2517 #3 0x0000555555ccbe7f in compute_window_func (thd=0x7fffd4000d60, window_functions=..., cursor_managers=..., tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2636 #4 0x0000555555ccc238 in Window_func_runner::exec (this=0x7fffd4015be0, thd=0x7fffd4000d60, tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2742 #5 0x0000555555ccc351 in Window_funcs_sort::exec (this=0x7fffd4015bd8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2767 #6 0x0000555555ccc817 in Window_funcs_computation::exec (this=0x7fffd4015bb8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2886 #7 0x0000555555b8c8e0 in AGGR_OP::end_send (this=0x7fffd4015860) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:26530 #8 0x0000555555b77b65 in sub_select_postjoin_aggr (join=0x7fffd40136d0, join_tab=0x7fffd4014b38, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18369 #9 0x0000555555b77e94 in sub_select (join=0x7fffd40136d0, join_tab=0x7fffd4014788, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18605 #10 0x0000555555b7769d in do_select (join=0x7fffd40136d0, procedure=0x0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18200 #11 0x0000555555b5226a in JOIN::exec_inner (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3530 #12 0x0000555555b51718 in JOIN::exec (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3325 #13 0x0000555555b528dc in mysql_select (thd=0x7fffd4000d60, tables=0x7fffd4012a20, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7fffd4013590, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fffd40136b0, unit=0x7fffd4004900, select_lex=0x7fffd4005038) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3725 #14 0x0000555555b47110 in handle_select (thd=0x7fffd4000d60, lex=0x7fffd4004838, result=0x7fffd40136b0, setup_tables_done_option=0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:361 #15 0x0000555555b13221 in execute_sqlcom_select (thd=0x7fffd4000d60, all_tables=0x7fffd4012a20) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:6459 #16 0x0000555555b08ee9 in mysql_execute_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:3463 #17 0x0000555555b16bd1 in mysql_parse (thd=0x7fffd4000d60, rawbuf=0x7fffd40127e8 "SELECT b1\nfrom t1\norder by row_number() over (ORDER BY b6) + 1", length=62, parser_state=0x7fffeb582170, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:7900 #18 0x0000555555b04819 in dispatch_command (command=COM_QUERY, thd=0x7fffd4000d60, packet=0x7fffd4008ba1 "", packet_length=62, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1804 #19 0x0000555555b031b2 in do_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1359 #20 0x0000555555c4fbd8 in do_handle_one_connection (connect=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1335 #21 0x0000555555c4f958 in handle_one_connection (arg=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1241 #22 0x000055555648a035 in pfs_spawn_thread (arg=0x555557bf2e60) at /home/vicentiu/Workspace/MariaDB/storage/perfschema/pfs.cc:1863 #23 0x00007ffff7bc108a in start_thread () from /usr/lib/libpthread.so.0 #24 0x00007ffff5ac542f in clone () from /usr/lib/libc.so.6 {noformat} |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Link |
This issue relates to |
Description |
{code:sql}
CREATE TABLE t1 (b1 BIT, b2 BIT, b3 BIT, b4 BIT , b5 BIT, b6 BIT); INSERT INTO t1 VALUES (1,0,0,1,0,1),(0,1,0,0,1,0); SELECT b1 from t1 order by row_number() over (ORDER BY b6) + 1; # Cleanup DROP TABLE t1; {code} {noformat} #0 0x0000555555a5124a in Field::set_notnull (this=0x0, row_offset=0) at /home/vicentiu/Workspace/MariaDB/sql/field.h:1137 #1 0x0000555555d9cfb5 in Item::save_in_field (this=0x7fffd4013348, field=0x0, no_conversions=true) at /home/vicentiu/Workspace/MariaDB/sql/item.cc:6441 #2 0x0000555555ccba48 in save_window_function_values (window_functions=..., tbl=0x7fffd402d168, rowid_buf=0x7fffd4006c50 "P7\003\324\377\177") at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2517 #3 0x0000555555ccbe7f in compute_window_func (thd=0x7fffd4000d60, window_functions=..., cursor_managers=..., tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2636 #4 0x0000555555ccc238 in Window_func_runner::exec (this=0x7fffd4015be0, thd=0x7fffd4000d60, tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2742 #5 0x0000555555ccc351 in Window_funcs_sort::exec (this=0x7fffd4015bd8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2767 #6 0x0000555555ccc817 in Window_funcs_computation::exec (this=0x7fffd4015bb8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2886 #7 0x0000555555b8c8e0 in AGGR_OP::end_send (this=0x7fffd4015860) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:26530 #8 0x0000555555b77b65 in sub_select_postjoin_aggr (join=0x7fffd40136d0, join_tab=0x7fffd4014b38, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18369 #9 0x0000555555b77e94 in sub_select (join=0x7fffd40136d0, join_tab=0x7fffd4014788, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18605 #10 0x0000555555b7769d in do_select (join=0x7fffd40136d0, procedure=0x0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18200 #11 0x0000555555b5226a in JOIN::exec_inner (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3530 #12 0x0000555555b51718 in JOIN::exec (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3325 #13 0x0000555555b528dc in mysql_select (thd=0x7fffd4000d60, tables=0x7fffd4012a20, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7fffd4013590, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fffd40136b0, unit=0x7fffd4004900, select_lex=0x7fffd4005038) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3725 #14 0x0000555555b47110 in handle_select (thd=0x7fffd4000d60, lex=0x7fffd4004838, result=0x7fffd40136b0, setup_tables_done_option=0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:361 #15 0x0000555555b13221 in execute_sqlcom_select (thd=0x7fffd4000d60, all_tables=0x7fffd4012a20) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:6459 #16 0x0000555555b08ee9 in mysql_execute_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:3463 #17 0x0000555555b16bd1 in mysql_parse (thd=0x7fffd4000d60, rawbuf=0x7fffd40127e8 "SELECT b1\nfrom t1\norder by row_number() over (ORDER BY b6) + 1", length=62, parser_state=0x7fffeb582170, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:7900 #18 0x0000555555b04819 in dispatch_command (command=COM_QUERY, thd=0x7fffd4000d60, packet=0x7fffd4008ba1 "", packet_length=62, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1804 #19 0x0000555555b031b2 in do_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1359 #20 0x0000555555c4fbd8 in do_handle_one_connection (connect=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1335 #21 0x0000555555c4f958 in handle_one_connection (arg=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1241 #22 0x000055555648a035 in pfs_spawn_thread (arg=0x555557bf2e60) at /home/vicentiu/Workspace/MariaDB/storage/perfschema/pfs.cc:1863 #23 0x00007ffff7bc108a in start_thread () from /usr/lib/libpthread.so.0 #24 0x00007ffff5ac542f in clone () from /usr/lib/libc.so.6 {noformat} |
{code:sql}
CREATE TABLE t1 (b1 BIT, b2 BIT, b3 BIT, b4 BIT , b5 BIT, b6 BIT); INSERT INTO t1 VALUES (1,0,0,1,0,1),(0https://jira.mariadb.org/browse/MDEV-14791#,1,0,0,1,0); SELECT b1 from t1 order by row_number() over (ORDER BY b6) + 1; # Cleanup DROP TABLE t1; {code} {noformat} #0 0x0000555555a5124a in Field::set_notnull (this=0x0, row_offset=0) at /home/vicentiu/Workspace/MariaDB/sql/field.h:1137 #1 0x0000555555d9cfb5 in Item::save_in_field (this=0x7fffd4013348, field=0x0, no_conversions=true) at /home/vicentiu/Workspace/MariaDB/sql/item.cc:6441 #2 0x0000555555ccba48 in save_window_function_values (window_functions=..., tbl=0x7fffd402d168, rowid_buf=0x7fffd4006c50 "P7\003\324\377\177") at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2517 #3 0x0000555555ccbe7f in compute_window_func (thd=0x7fffd4000d60, window_functions=..., cursor_managers=..., tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2636 #4 0x0000555555ccc238 in Window_func_runner::exec (this=0x7fffd4015be0, thd=0x7fffd4000d60, tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2742 #5 0x0000555555ccc351 in Window_funcs_sort::exec (this=0x7fffd4015bd8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2767 #6 0x0000555555ccc817 in Window_funcs_computation::exec (this=0x7fffd4015bb8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2886 #7 0x0000555555b8c8e0 in AGGR_OP::end_send (this=0x7fffd4015860) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:26530 #8 0x0000555555b77b65 in sub_select_postjoin_aggr (join=0x7fffd40136d0, join_tab=0x7fffd4014b38, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18369 #9 0x0000555555b77e94 in sub_select (join=0x7fffd40136d0, join_tab=0x7fffd4014788, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18605 #10 0x0000555555b7769d in do_select (join=0x7fffd40136d0, procedure=0x0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18200 #11 0x0000555555b5226a in JOIN::exec_inner (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3530 #12 0x0000555555b51718 in JOIN::exec (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3325 #13 0x0000555555b528dc in mysql_select (thd=0x7fffd4000d60, tables=0x7fffd4012a20, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7fffd4013590, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fffd40136b0, unit=0x7fffd4004900, select_lex=0x7fffd4005038) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3725 #14 0x0000555555b47110 in handle_select (thd=0x7fffd4000d60, lex=0x7fffd4004838, result=0x7fffd40136b0, setup_tables_done_option=0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:361 #15 0x0000555555b13221 in execute_sqlcom_select (thd=0x7fffd4000d60, all_tables=0x7fffd4012a20) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:6459 #16 0x0000555555b08ee9 in mysql_execute_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:3463 #17 0x0000555555b16bd1 in mysql_parse (thd=0x7fffd4000d60, rawbuf=0x7fffd40127e8 "SELECT b1\nfrom t1\norder by row_number() over (ORDER BY b6) + 1", length=62, parser_state=0x7fffeb582170, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:7900 #18 0x0000555555b04819 in dispatch_command (command=COM_QUERY, thd=0x7fffd4000d60, packet=0x7fffd4008ba1 "", packet_length=62, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1804 #19 0x0000555555b031b2 in do_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1359 #20 0x0000555555c4fbd8 in do_handle_one_connection (connect=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1335 #21 0x0000555555c4f958 in handle_one_connection (arg=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1241 #22 0x000055555648a035 in pfs_spawn_thread (arg=0x555557bf2e60) at /home/vicentiu/Workspace/MariaDB/storage/perfschema/pfs.cc:1863 #23 0x00007ffff7bc108a in start_thread () from /usr/lib/libpthread.so.0 #24 0x00007ffff5ac542f in clone () from /usr/lib/libc.so.6 {noformat} |
Description |
{code:sql}
CREATE TABLE t1 (b1 BIT, b2 BIT, b3 BIT, b4 BIT , b5 BIT, b6 BIT); INSERT INTO t1 VALUES (1,0,0,1,0,1),(0https://jira.mariadb.org/browse/MDEV-14791#,1,0,0,1,0); SELECT b1 from t1 order by row_number() over (ORDER BY b6) + 1; # Cleanup DROP TABLE t1; {code} {noformat} #0 0x0000555555a5124a in Field::set_notnull (this=0x0, row_offset=0) at /home/vicentiu/Workspace/MariaDB/sql/field.h:1137 #1 0x0000555555d9cfb5 in Item::save_in_field (this=0x7fffd4013348, field=0x0, no_conversions=true) at /home/vicentiu/Workspace/MariaDB/sql/item.cc:6441 #2 0x0000555555ccba48 in save_window_function_values (window_functions=..., tbl=0x7fffd402d168, rowid_buf=0x7fffd4006c50 "P7\003\324\377\177") at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2517 #3 0x0000555555ccbe7f in compute_window_func (thd=0x7fffd4000d60, window_functions=..., cursor_managers=..., tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2636 #4 0x0000555555ccc238 in Window_func_runner::exec (this=0x7fffd4015be0, thd=0x7fffd4000d60, tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2742 #5 0x0000555555ccc351 in Window_funcs_sort::exec (this=0x7fffd4015bd8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2767 #6 0x0000555555ccc817 in Window_funcs_computation::exec (this=0x7fffd4015bb8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2886 #7 0x0000555555b8c8e0 in AGGR_OP::end_send (this=0x7fffd4015860) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:26530 #8 0x0000555555b77b65 in sub_select_postjoin_aggr (join=0x7fffd40136d0, join_tab=0x7fffd4014b38, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18369 #9 0x0000555555b77e94 in sub_select (join=0x7fffd40136d0, join_tab=0x7fffd4014788, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18605 #10 0x0000555555b7769d in do_select (join=0x7fffd40136d0, procedure=0x0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18200 #11 0x0000555555b5226a in JOIN::exec_inner (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3530 #12 0x0000555555b51718 in JOIN::exec (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3325 #13 0x0000555555b528dc in mysql_select (thd=0x7fffd4000d60, tables=0x7fffd4012a20, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7fffd4013590, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fffd40136b0, unit=0x7fffd4004900, select_lex=0x7fffd4005038) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3725 #14 0x0000555555b47110 in handle_select (thd=0x7fffd4000d60, lex=0x7fffd4004838, result=0x7fffd40136b0, setup_tables_done_option=0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:361 #15 0x0000555555b13221 in execute_sqlcom_select (thd=0x7fffd4000d60, all_tables=0x7fffd4012a20) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:6459 #16 0x0000555555b08ee9 in mysql_execute_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:3463 #17 0x0000555555b16bd1 in mysql_parse (thd=0x7fffd4000d60, rawbuf=0x7fffd40127e8 "SELECT b1\nfrom t1\norder by row_number() over (ORDER BY b6) + 1", length=62, parser_state=0x7fffeb582170, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:7900 #18 0x0000555555b04819 in dispatch_command (command=COM_QUERY, thd=0x7fffd4000d60, packet=0x7fffd4008ba1 "", packet_length=62, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1804 #19 0x0000555555b031b2 in do_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1359 #20 0x0000555555c4fbd8 in do_handle_one_connection (connect=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1335 #21 0x0000555555c4f958 in handle_one_connection (arg=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1241 #22 0x000055555648a035 in pfs_spawn_thread (arg=0x555557bf2e60) at /home/vicentiu/Workspace/MariaDB/storage/perfschema/pfs.cc:1863 #23 0x00007ffff7bc108a in start_thread () from /usr/lib/libpthread.so.0 #24 0x00007ffff5ac542f in clone () from /usr/lib/libc.so.6 {noformat} |
{code:sql}
CREATE TABLE t1 (b1 BIT, b2 BIT, b3 BIT, b4 BIT , b5 BIT, b6 BIT); INSERT INTO t1 VALUES (1,0,0,1,0,1),(0,1,0,0,1,0); SELECT b1 from t1 order by row_number() over (ORDER BY b6) + 1; # Cleanup DROP TABLE t1; {code} {noformat} #0 0x0000555555a5124a in Field::set_notnull (this=0x0, row_offset=0) at /home/vicentiu/Workspace/MariaDB/sql/field.h:1137 #1 0x0000555555d9cfb5 in Item::save_in_field (this=0x7fffd4013348, field=0x0, no_conversions=true) at /home/vicentiu/Workspace/MariaDB/sql/item.cc:6441 #2 0x0000555555ccba48 in save_window_function_values (window_functions=..., tbl=0x7fffd402d168, rowid_buf=0x7fffd4006c50 "P7\003\324\377\177") at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2517 #3 0x0000555555ccbe7f in compute_window_func (thd=0x7fffd4000d60, window_functions=..., cursor_managers=..., tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2636 #4 0x0000555555ccc238 in Window_func_runner::exec (this=0x7fffd4015be0, thd=0x7fffd4000d60, tbl=0x7fffd402d168, filesort_result=0x7fffd404d0e0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2742 #5 0x0000555555ccc351 in Window_funcs_sort::exec (this=0x7fffd4015bd8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2767 #6 0x0000555555ccc817 in Window_funcs_computation::exec (this=0x7fffd4015bb8, join=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_window.cc:2886 #7 0x0000555555b8c8e0 in AGGR_OP::end_send (this=0x7fffd4015860) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:26530 #8 0x0000555555b77b65 in sub_select_postjoin_aggr (join=0x7fffd40136d0, join_tab=0x7fffd4014b38, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18369 #9 0x0000555555b77e94 in sub_select (join=0x7fffd40136d0, join_tab=0x7fffd4014788, end_of_records=true) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18605 #10 0x0000555555b7769d in do_select (join=0x7fffd40136d0, procedure=0x0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:18200 #11 0x0000555555b5226a in JOIN::exec_inner (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3530 #12 0x0000555555b51718 in JOIN::exec (this=0x7fffd40136d0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3325 #13 0x0000555555b528dc in mysql_select (thd=0x7fffd4000d60, tables=0x7fffd4012a20, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7fffd4013590, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fffd40136b0, unit=0x7fffd4004900, select_lex=0x7fffd4005038) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:3725 #14 0x0000555555b47110 in handle_select (thd=0x7fffd4000d60, lex=0x7fffd4004838, result=0x7fffd40136b0, setup_tables_done_option=0) at /home/vicentiu/Workspace/MariaDB/sql/sql_select.cc:361 #15 0x0000555555b13221 in execute_sqlcom_select (thd=0x7fffd4000d60, all_tables=0x7fffd4012a20) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:6459 #16 0x0000555555b08ee9 in mysql_execute_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:3463 #17 0x0000555555b16bd1 in mysql_parse (thd=0x7fffd4000d60, rawbuf=0x7fffd40127e8 "SELECT b1\nfrom t1\norder by row_number() over (ORDER BY b6) + 1", length=62, parser_state=0x7fffeb582170, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:7900 #18 0x0000555555b04819 in dispatch_command (command=COM_QUERY, thd=0x7fffd4000d60, packet=0x7fffd4008ba1 "", packet_length=62, is_com_multi=false, is_next_command=false) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1804 #19 0x0000555555b031b2 in do_command (thd=0x7fffd4000d60) at /home/vicentiu/Workspace/MariaDB/sql/sql_parse.cc:1359 #20 0x0000555555c4fbd8 in do_handle_one_connection (connect=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1335 #21 0x0000555555c4f958 in handle_one_connection (arg=0x555557bea3f0) at /home/vicentiu/Workspace/MariaDB/sql/sql_connect.cc:1241 #22 0x000055555648a035 in pfs_spawn_thread (arg=0x555557bf2e60) at /home/vicentiu/Workspace/MariaDB/storage/perfschema/pfs.cc:1863 #23 0x00007ffff7bc108a in start_thread () from /usr/lib/libpthread.so.0 #24 0x00007ffff5ac542f in clone () from /usr/lib/libc.so.6 {noformat} |
Assignee | Vicentiu Ciorbaru [ cvicentiu ] | Varun Gupta [ varun ] |
Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
Assignee | Varun Gupta [ varun ] | Vicentiu Ciorbaru [ cvicentiu ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Assignee | Vicentiu Ciorbaru [ cvicentiu ] | Varun Gupta [ varun ] |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
Assignee | Varun Gupta [ varun ] | Vicentiu Ciorbaru [ cvicentiu ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Assignee | Vicentiu Ciorbaru [ cvicentiu ] | Sergei Petrunia [ psergey ] |
Link |
This issue relates to |
Link |
This issue relates to |
Affects Version/s | 10.4 [ 22408 ] |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] |
Link |
This issue relates to |
Link |
This issue is duplicated by |
Link |
This issue relates to |
Assignee | Sergei Petrunia [ psergey ] | Igor Babaev [ igor ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Assignee | Igor Babaev [ igor ] | Varun Gupta [ varun ] |
Fix Version/s | 10.2.24 [ 23308 ] | |
Fix Version/s | 10.3.15 [ 23309 ] | |
Fix Version/s | 10.4.5 [ 23311 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Link |
This issue duplicates |
Link |
This issue duplicates |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue is duplicated by |
Link |
This issue is duplicated by |
Link |
This issue is duplicated by |
Link |
This issue relates to |
Link |
This issue relates to |
Link | This issue relates to MDEV-26416 [ MDEV-26416 ] |
Workflow | MariaDB v3 [ 84627 ] | MariaDB v4 [ 153455 ] |