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

Server crashes in Item_func_nextval::val_int after select from view

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
    • 10.4, 10.5, 10.6
    • Sequences

    Description

      --source include/have_sequence.inc
       
      CREATE SEQUENCE s;
      CREATE table t1 (a int NOT NULL DEFAULT NEXTVAL(s));
      INSERT into t1 values(),();
       
      create view v1 as select default(a) from t1;
      select * from v1;
       
      # Cleanup
      DROP VIEW v1;
      DROP TABLE t1;
      DROP SEQUENCE s;
      

      10.3 c2300d06f7845f51db6318c2fd

      220803 12:08:11 [ERROR] mysqld got signal 11 ;
       
      Server version: 10.3.36-MariaDB-debug-log
       
      sql/signal_handler.cc:231(handle_fatal_signal)[0x561e05d69598]
      sql/item_func.cc:6797(Item_func_nextval::val_int())[0x561e05ef908d]
      sql/item.cc:7002(Item::save_int_in_field(Field*, bool))[0x561e05dea66b]
      sql/sql_type.cc:2597(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x561e05b010ac]
      sql/item.cc:7012(Item::save_in_field(Field*, bool))[0x561e05dea84f]
      sql/field.cc:2425(Field::set_default())[0x561e05cc45d8]
      sql/item.cc:9544(Item_default_value::calculate())[0x561e05e0375a]
      sql/item.cc:9580(Item_default_value::send(Protocol*, st_value*))[0x561e05e03950]
      sql/item.cc:8389(Item_ref::send(Protocol*, st_value*))[0x561e05df6969]
      sql/item.cc:9115(Item_direct_view_ref::send(Protocol*, st_value*))[0x561e05dffe1d]
      sql/protocol.cc:1000(Protocol::send_result_set_row(List<Item>*))[0x561e0534ebf1]
      sql/sql_class.cc:3049(select_send::send_data(List<Item>&))[0x561e054eab69]
      sql/sql_select.cc:21093(end_send(JOIN*, st_join_table*, bool))[0x561e057316a2]
      sql/sql_select.cc:20134(evaluate_join_record(JOIN*, st_join_table*, int))[0x561e05729b41]
      sql/sql_select.cc:19907(sub_select(JOIN*, st_join_table*, bool))[0x561e05728459]
      sql/sql_select.cc:19445(do_select(JOIN*, Procedure*))[0x561e05726418]
      sql/sql_select.cc:4163(JOIN::exec_inner())[0x561e056b9027]
      sql/sql_select.cc:3958(JOIN::exec())[0x561e056b69a4]
      sql/sql_select.cc:4368(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x561e056ba4a2]
      sql/sql_select.cc:372(handle_select(THD*, LEX*, select_result*, unsigned long))[0x561e056909cd]
      sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x561e056016dd]
      sql/sql_parse.cc:3871(mysql_execute_command(THD*))[0x561e055ef718]
      sql/sql_parse.cc:7871(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x561e0560b43a]
      sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x561e055e2317]
      sql/sql_parse.cc:1398(do_command(THD*))[0x561e055dee5a]
      sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x561e059b2475]
      sql/sql_connect.cc:1309(handle_one_connection)[0x561e059b1d2f]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x561e06fe29c1]
      nptl/pthread_create.c:478(start_thread)[0x7f996b10d609]
       
      Query (0x62b000000290): select * from v1
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              alice Alice Sherepa
              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.