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

Crash after UPDATE view with ORDER BY + ROWNUM()

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.6, 10.7, 10.8, 10.9, 10.10, 10.11
    • N/A
    • N/A
    • None

    Description

      CREATE TABLE t1 ( a int, d int)engine=innodb;
      INSERT INTO t1 VALUES (1,2),(3,4); #not important
       
      CREATE VIEW v1 AS select d from t1  order by a ;
      UPDATE v1 SET d= d + 1 WHERE rownum() > 1 ;
      

      Version: '10.6.13-MariaDB-debug-log' 
      230502 13:16:58 [ERROR] mysqld got signal 11 ;
       
      Server version: 10.6.13-MariaDB-debug-log source revision: 5f3a4beb9dabbb6e531f48661907b73100bc4ef3
       
      sql/signal_handler.cc:241(handle_fatal_signal)[0x55b9257e770e]
      sigaction.c:0(__restore_rt)[0x7fcf38c78420]
      heap/hp_info.c:34(heap_info)[0x55b92622ce33]
      heap/ha_heap.cc:372(ha_heap::info(unsigned int))[0x55b92621e295]
      sql/sql_update.cc:573(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x55b925291125]
      sql/sql_parse.cc:4413(mysql_execute_command(THD*, bool))[0x55b924f60666]
      sql/sql_parse.cc:8036(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55b924f7a1b9]
      sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55b924f5003a]
      sql/sql_parse.cc:1409(do_command(THD*, bool))[0x55b924f4cd85]
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55b9253c9df1]
      sql/sql_connect.cc:1320(handle_one_connection)[0x55b9253c974e]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55b926061d3c]
      nptl/pthread_create.c:478(start_thread)[0x7fcf38c6c609]
       
      Query (0x62b0000c42a8): UPDATE v1 SET d= d + 1 WHERE rownum() > 1
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.