Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32713

Assertion Failed at /mariadb-11.3.0/sql/item_func.cc:2075

    XMLWordPrintable

Details

    Description

      Run these queries in debug build:

      CREATE TABLE t0 ( c57 DOUBLE ( 170 , 28 ) ) ;
      INSERT INTO t0 ( c57 ) SELECT -121 AS c38 WHERE -32 NOT REGEXP RAND ( ) IS NOT NULL = -78 ;
      CREATE INDEX i0 ON t0 ( c57 ) ;
      INSERT INTO t0 VALUES ( -101 ) , ( -73 ) ;
      SELECT t0 . c57 AS c59 FROM ( SELECT LAST_VALUE ( 99 ) OVER ( PARTITION BY c57 , c57 , BIT_AND( EXP ( 6319111429908606278 ) IS TRUE ) OVER ( ) IN ( ( SELECT t1 . c54 AS c31 FROM ( SELECT ~ SIN ( 74 ) LIKE LENGTH ( 128 ) AS c54 FROM t0 ) AS t1 LIMIT 1 ) % RTRIM ( CONVERT ( -2 , UNSIGNED ) SOUNDS LIKE INSERT ( t0 . c57 , 'JQlgi7hi [*&(-Po Llzic]"m/s9H=y7G.&C-mxkT)K~(@XD?ItNemjIJoab' , 'Q' , '
      SvJ#n /ec% ;VGOTpBjju]3p;6sf-f^|z%' ) ) ) , t0 . c57 , c57 , t0 . c57 , t0 . c57 , c57 ) % HEX ( -45 ) IN ( 2 , 13 = ( CONVERT ( 20 , UNSIGNED ) ) ) OR - SUM( 84 ) OVER ( PARTITION BY -80 , -41 , -108 ) AS c20 FROM t0 GROUP BY c57 ) AS t2 JOIN t0 ON t0 . c57 = t2 . c20 WHERE RAND ( t2 . c20 ) ;

      Will trigger Assertion Failed.
      GDB info:
      #0 0x00007ffff6c0c00b in raise () from /lib/x86_64-linux-gnu/libc.so.6
      #1 0x00007ffff6beb859 in abort () from /lib/x86_64-linux-gnu/libc.so.6
      #2 0x00007ffff6beb729 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
      #3 0x00007ffff6bfcfd6 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #4 0x0000555557c7fd58 in Item_func_exp::val_real (this=0x6290000f69e0) at /home/wx/mariadb-11.3.0/sql/item_func.cc:2075
      #5 0x00005555578b4ae2 in Type_handler_real_result::Item_val_bool (this=0x55555b7b6c00 <type_handler_double>, item=0x6290000f69e0) at /home/wx/mariadb-11.3.0/sql/sql_type.cc:5077
      #6 0x0000555556e147f6 in Item::val_bool (this=0x6290000f69e0) at /home/wx/mariadb-11.3.0/sql/item.h:1701
      #7 0x0000555557bef4c8 in Item_func_truth::val_bool (this=0x6290000f6a98) at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1179
      #8 0x0000555557bef6e8 in Item_func_truth::val_int (this=0x6290000f6a98) at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1202
      #9 0x0000555557e034e6 in Item_sum_and::add (this=0x6290000f6b60) at /home/wx/mariadb-11.3.0/sql/item_sum.cc:2747
      #10 0x00005555579135a9 in Frame_cursor::add_value_to_items (this=0x62d00003f7a0) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:1166
      #11 0x0000555557915cdd in Frame_range_current_row_bottom::pre_next_partition (this=0x62d00003f7a0, rownum=0) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:1576
      #12 0x0000555557913cfb in Cursor_manager::notify_cursors_partition_changed (this=0x60300023e3c0, rownum=0) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:1225
      #13 0x000055555790ed44 in compute_window_func (thd=0x62c0001e0288, window_functions=..., cursor_managers=..., tbl=0x62100016bda8, filesort_result=0x6150001c4b00) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:2907
      #14 0x000055555790f54d in Window_func_runner::exec (this=0x6290001c3710, thd=0x62c0001e0288, tbl=0x62100016bda8, filesort_result=0x6150001c4b00) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:3039
      #15 0x000055555790f79c in Window_funcs_sort::exec (this=0x6290001c3708, join=0x6290001bd4b0, keep_filesort_result=true) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:3067
      #16 0x00005555579105c8 in Window_funcs_computation::exec (this=0x6290001c36e0, join=0x6290001bd4b0, keep_last_filesort_result=true) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:3196
      #17 0x00005555573a1ea2 in AGGR_OP::end_send (this=0x6290001c1088) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:32300
      #18 0x000055555735ebd8 in sub_select_postjoin_aggr (join=0x6290001bd4b0, join_tab=0x6290001c2720, end_of_records=true) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23128
      #19 0x000055555735f713 in sub_select (join=0x6290001bd4b0, join_tab=0x6290001c22a8, end_of_records=true) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23378
      #20 0x000055555735dbe3 in do_select (join=0x6290001bd4b0, procedure=0x0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22963
      #21 0x00005555572dbfe9 in JOIN::exec_inner (this=0x6290001bd4b0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
      #22 0x00005555572d93a0 in JOIN::exec (this=0x6290001bd4b0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
      #23 0x00005555572ddbab in mysql_select (thd=0x62c0001e0288, tables=0x6290001862a8, fields=..., conds=0x0, og_num=3, order=0x0, group=0x6290000f66a0, having=0x0, proc_param=0x0, select_options=2201188305408, result=0x6290001bd3b8, unit=0x629000186b00, select_lex=0x6290000f5ed8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:5249
      #24 0x00005555570d9bea in mysql_derived_fill (thd=0x62c0001e0288, lex=0x62c0001e45f8, derived=0x629000187398) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1266
      #25 0x00005555570d27b6 in mysql_handle_single_derived (lex=0x62c0001e45f8, derived=0x629000187398, phases=96) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
      #26 0x000055555732a50c in st_join_table::preread_init (this=0x62d00003d008) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
      #27 0x000055555735f8c8 in sub_select (join=0x629000189b70, join_tab=0x62d00003d008, end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
      #28 0x000055555736194d in evaluate_join_record (join=0x629000189b70, join_tab=0x62d00003cb90, error=0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23677
      #29 0x00005555573601c2 in sub_select (join=0x629000189b70, join_tab=0x62d00003cb90, end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23444
      #30 0x000055555735dadd in do_select (join=0x629000189b70, procedure=0x0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
      #31 0x00005555572dbfe9 in JOIN::exec_inner (this=0x629000189b70) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
      #32 0x00005555572d93a0 in JOIN::exec (this=0x629000189b70) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
      #33 0x00005555572ddbab in mysql_select (thd=0x62c0001e0288, tables=0x629000187398, fields=..., conds=0x629000189120, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2165049856, result=0x629000189b40, unit=0x62c0001e46d8, select_lex=0x6290000f5878) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:5249
      #34 0x00005555572ad18a in handle_select (thd=0x62c0001e0288, lex=0x62c0001e45f8, result=0x629000189b40, setup_tables_done_option=0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:628
      #35 0x00005555571ce583 in execute_sqlcom_select (thd=0x62c0001e0288, all_tables=0x629000187398) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:6013
      #36 0x00005555571becf6 in mysql_execute_command (thd=0x62c0001e0288, is_called_from_prepared_stmt=false) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:3912
      #37 0x00005555571d95e2 in mysql_parse (thd=0x62c0001e0288, rawbuf=0x6290000f52a8 "SELECT t0 . c57 AS c59 FROM ( SELECT LAST_VALUE ( 99 ) OVER ( PARTITION BY c57 , c57 , BIT_AND( EXP ( 6319111429908606278 ) IS TRUE ) OVER ( ) IN ( ( SELECT t1 . c54 AS c31 FROM ( SELECT ~ SIN ( 74 ) "..., length=688, parser_state=0x7fffe33b0870) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:7734
      #38 0x00005555571b1237 in dispatch_command (command=COM_QUERY, thd=0x62c0001e0288, packet=0x6290000fa289 "", packet_length=691, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1893
      #39 0x00005555571adf7c in do_command (thd=0x62c0001e0288, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1406
      #40 0x000055555768e557 in do_handle_one_connection (connect=0x611000090088, put_in_cache=true) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1445
      #41 0x000055555768deb4 in handle_one_connection (arg=0x611000079ec8) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1347
      #42 0x00005555582fa350 in pfs_spawn_thread (arg=0x618000005108) at /home/wx/mariadb-11.3.0/storage/perfschema/pfs.cc:2201
      #43 0x00007ffff7115609 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #44 0x00007ffff6ce8133 in clone () from /lib/x86_64-linux-gnu/libc.so.6

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            Xin Wen Xin Wen
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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