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

crash in Window_spec::print_partition() with decimals

    XMLWordPrintable

Details

    Description

      Version: '10.3.13-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
      [ERROR] mysqld got exception 0xc0000005 ;
      mysqld.exe!Window_spec::print_partition()[sql_window.cc:96]
      mysqld.exe!Window_spec::print()[sql_window.cc:86]
      mysqld.exe!item_name()[sql_type.cc:5487]
      mysqld.exe!wrong_precision_error()[sql_type.cc:5495]
      mysqld.exe!get_length_and_scale()[sql_type.cc:5520]
      mysqld.exe!Type_handler_decimal_result::create_typecast_item()[sql_type.cc:5592]
      mysqld.exe!Lex_cast_type_st::create_typecast_item()[item_func.h:2811]
      mysqld.exe!MYSQLparse()[sql_yacc.yy:10249]
      mysqld.exe!parse_sql()[sql_parse.cc:10125]
      mysqld.exe!mysql_parse()[sql_parse.cc:8050]
      mysqld.exe!dispatch_command()[sql_parse.cc:1856]
      mysqld.exe!do_command()[sql_parse.cc:1395]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:358]
      mysqld.exe!tp_callback()[threadpool_common.cc:186]
      

      Some testcases....

      do cast((cast((lead(7 ,141)  over w2 )as decimal (38,64))  )as time );
      do cast((cume_dist()over w1 )as decimal (32,56));
      do cast((cume_dist()over w2 )as decimal (34,41));
      do cast((cume_dist()over w2 )as decimal (45,42));
      do cast((rank()over w1 )as decimal (53,56));
      

      Attachments

        Activity

          People

            varun Varun Gupta (Inactive)
            sbester1 sbester1
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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