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

Assertion Failed at /mariadb-11.3.0/sql/item_cmpfunc.cc:5674

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.3.0, 10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
    • 10.5, 10.6, 10.11
    • None
    • Ubuntu 20.04

    Description

      Run these queries in debug build:

      CREATE TABLE t0 ( c28 INT , c8 INT ) ;
      INSERT INTO t0 VALUES ( 35 , 96 ) , ( 7 , 91 ) ;
      ALTER TABLE t0 ADD COLUMN c15 INT AFTER c28 ;
      INSERT INTO t0 VALUES ( DEFAULT , DEFAULT , DEFAULT ) , ( DEFAULT , DEFAULT , DEFAULT ) ;
      SELECT SQRT ( 77 ) NOT REGEXP MOD ( TRIM( LEADING FROM 199006839349504362 < 118 ) - COUNT( * ) OVER ( PARTITION BY c8 , c8 , c8 , c15 , c15 , c15 , c28 , BIT_AND( CASE 41 WHEN -55 THEN 44 ELSE -127 END IS NOT NULL ) OVER ( PARTITION BY - GROUP_CONCAT( CHAR_LENGTH ( 5587684486210155208 ) , 'FUMp}o,E1_p?5t>(S3-H84\'^(8,\\\\cW7' , 'c4d#7YXD2_<=:/vepn?}m]wj <hcB?2KYV=,SO7kyxTj&k=(RzB&NY*hN|K|' ORDER BY COS ( t0 . c15 ) - RAND ( t0 . c8 ) = t0 . c15 SEPARATOR 'HG|h(L_qP
      J{!TG>Z8K{WNKl:^F=0^x%8*yNsc&^Cg5dS`z`%O^VQ' ) XOR t0 . c28 = REVERSE ( ( NOT EXPORT_SET ( 4 , '=YzuLW>U75b*F3/%F$$2@Zu
      ' , 'K*U&mp|V8_,8hqX8+j' , 'kXB+/tV' ) SOUNDS LIKE TRUNCATE ( 93 , 11 ) = 10 ) & - BIT_LENGTH ( -13 ) & NULLIF ( 90 , -105 ) IN ( 17 , 108 , 4513583902236675204 ) ) ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) * MIN( 56 ) ORDER BY t0 . c15 NOT REGEXP ROUND ( 123 , -98 ) DESC ) , 110 ) = ALL ( SELECT c15 AS c20 FROM t0 ) AS c56 FROM t0 GROUP BY c8 , c15 , c28 ;

      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 0x0000555557c19463 in Item_func_isnotnull::val_int (this=0x6290000f7720) at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:5674
      #5 0x0000555557e034e6 in Item_sum_and::add (this=0x6290000f77e0) at /home/wx/mariadb-11.3.0/sql/item_sum.cc:2747
      #6 0x00005555579135a9 in Frame_cursor::add_value_to_items (this=0x62d0000d4138) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:1166
      #7 0x0000555557916484 in Frame_unbounded_following::next_partition (this=0x62d0000d4138, rownum=0) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:1791
      #8 0x0000555557913d9e in Cursor_manager::notify_cursors_partition_changed (this=0x603000233530, rownum=0) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:1229
      #9 0x000055555790ed44 in compute_window_func (thd=0x62c0001d0288, window_functions=..., cursor_managers=..., tbl=0x623000016da8, filesort_result=0x6150001e5580) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:2907
      #10 0x000055555790f54d in Window_func_runner::exec (this=0x62d0000d3158, thd=0x62c0001d0288, tbl=0x623000016da8, filesort_result=0x6150001e5580) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:3039
      #11 0x000055555790f79c in Window_funcs_sort::exec (this=0x62d0000d3150, join=0x629000183398, keep_filesort_result=false) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:3067
      #12 0x00005555579105c8 in Window_funcs_computation::exec (this=0x62d0000d3128, join=0x629000183398, keep_last_filesort_result=true) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:3196
      #13 0x00005555573a1ea2 in AGGR_OP::end_send (this=0x629000193c00) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:32300
      #14 0x000055555735ebd8 in sub_select_postjoin_aggr (join=0x629000183398, join_tab=0x629000188458, end_of_records=true) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23128
      #15 0x000055555735f713 in sub_select (join=0x629000183398, join_tab=0x629000187fe0, end_of_records=true) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23378
      #16 0x000055555735dbe3 in do_select (join=0x629000183398, procedure=0x0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22963
      #17 0x00005555572dbfe9 in JOIN::exec_inner (this=0x629000183398) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
      #18 0x00005555572d93a0 in JOIN::exec (this=0x629000183398) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
      #19 0x00005555572ddbab in mysql_select (thd=0x62c0001d0288, tables=0x629000181e08, fields=..., conds=0x0, og_num=10, order=0x0, group=0x6290000f6870, having=0x0, proc_param=0x0, select_options=2165049856, result=0x629000183368, unit=0x62c0001d46d8, select_lex=0x6290000f5aa0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:5249
      #20 0x00005555572ad18a in handle_select (thd=0x62c0001d0288, lex=0x62c0001d45f8, result=0x629000183368, setup_tables_done_option=0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:628
      #21 0x00005555571ce583 in execute_sqlcom_select (thd=0x62c0001d0288, all_tables=0x629000181e08) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:6013
      #22 0x00005555571becf6 in mysql_execute_command (thd=0x62c0001d0288, is_called_from_prepared_stmt=false) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:3912
      #23 0x00005555571d95e2 in mysql_parse (thd=0x62c0001d0288, rawbuf=0x6290000f52a8 "SELECT SQRT ( 77 ) NOT REGEXP MOD ( TRIM( LEADING FROM 199006839349504362 < 118 ) - COUNT( * ) OVER ( PARTITION BY c8 , c8 , c8 , c15 , c15 , c15 , c28 , BIT_AND( CASE -41 WHEN -55 THEN 44 ELSE -127 E"..., length=967, parser_state=0x7fffd163c870) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:7734
      #24 0x00005555571b1237 in dispatch_command (command=COM_QUERY, thd=0x62c0001d0288, packet=0x6290000fa289 "", packet_length=970, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1893
      #25 0x00005555571adf7c in do_command (thd=0x62c0001d0288, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1406
      #26 0x000055555768e557 in do_handle_one_connection (connect=0x6110000447c8, put_in_cache=true) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1445
      #27 0x000055555768deb4 in handle_one_connection (arg=0x611000044688) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1347
      #28 0x00005555582fa350 in pfs_spawn_thread (arg=0x618000007d08) at /home/wx/mariadb-11.3.0/storage/perfschema/pfs.cc:2201
      #29 0x00007ffff7115609 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #30 0x00007ffff6ce8133 in clone () from /lib/x86_64-linux-gnu/libc.so.6

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              Xin Wen Xin Wen
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.