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

CREATE TABLE ... ENGINE=SEQUENCE has confusing db_type

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.5
    • 10.5
    • Sequences
    • None

    Description

      Thread 19 hit Breakpoint 1, mysql_create_table (thd=0x7ff77401b688, 
          create_table=0x7ff774030988, create_info=0x7ff75c5f8800, 
          alter_info=0x7ff75c5f8710)
          at /home/jan/work/mariadb/10.5/sql/sql_table.cc:5597
      5597	  if (thd->lex->sql_command == SQLCOM_CREATE_TABLE &&
      (rr) where
      #0  mysql_create_table (thd=0x7ff77401b688, create_table=0x7ff774030988, 
          create_info=0x7ff75c5f8800, alter_info=0x7ff75c5f8710)
          at /home/jan/work/mariadb/10.5/sql/sql_table.cc:5597
      #1  0x0000563db3472c32 in Sql_cmd_create_table_like::execute (
          this=0x7ff774030928, thd=0x7ff77401b688)
          at /home/jan/work/mariadb/10.5/sql/sql_table.cc:12397
      #2  0x0000563db3359bef in mysql_execute_command (thd=0x7ff77401b688)
          at /home/jan/work/mariadb/10.5/sql/sql_parse.cc:6085
      #3  0x0000563db33600f5 in mysql_parse (thd=0x7ff77401b688, 
          rawbuf=0x7ff774030850 "CREATE TABLE t0 (id GEOMETRY,parent_id GEOMETRY)ENGINE=SEQUENCE", length=63, parser_state=0x7ff75c5f92c0, is_com_multi=false, 
          is_next_command=false) at /home/jan/work/mariadb/10.5/sql/sql_parse.cc:8120
      #4  0x0000563db335f768 in wsrep_mysql_parse (thd=0x7ff77401b688, 
          rawbuf=0x7ff774030850 "CREATE TABLE t0 (id GEOMETRY,parent_id GEOMETRY)ENGINE=SEQUENCE", length=63, parser_state=0x7ff75c5f92c0, is_com_multi=false, 
          is_next_command=false) at /home/jan/work/mariadb/10.5/sql/sql_parse.cc:7921
      #5  0x0000563db334b242 in dispatch_command (command=COM_QUERY, 
          thd=0x7ff77401b688, 
          packet=0x7ff774027ea9 "CREATE TABLE t0 (id GEOMETRY,parent_id GEOMETRY)ENGINE=SEQUENCE", packet_length=63, is_com_multi=false, is_next_command=false)
          at /home/jan/work/mariadb/10.5/sql/sql_parse.cc:1877
      #6  0x0000563db3349adf in do_command (thd=0x7ff77401b688)
          at /home/jan/work/mariadb/10.5/sql/sql_parse.cc:1375
      --Type <RET> for more, q to quit, c to continue without paging--
      #7  0x0000563db35136ed in do_handle_one_connection (connect=0x563db71da7c8, 
          put_in_cache=true) at /home/jan/work/mariadb/10.5/sql/sql_connect.cc:1416
      #8  0x0000563db351345d in handle_one_connection (arg=0x563db71da7c8)
          at /home/jan/work/mariadb/10.5/sql/sql_connect.cc:1318
      #9  0x0000563db3a6f1d0 in pfs_spawn_thread (arg=0x563db6a22678)
          at /home/jan/work/mariadb/10.5/storage/perfschema/pfs.cc:2201
      #10 0x00007ff789497ada in start_thread (arg=<optimized out>)
          at ./nptl/pthread_create.c:444
      #11 0x00007ff7895282e4 in clone ()
          at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      (rr) next
      5598	      create_info->used_fields & HA_CREATE_USED_ENGINE &&
      (rr) 
      5597	  if (thd->lex->sql_command == SQLCOM_CREATE_TABLE &&
      (rr) 
      5599	      create_info->db_type->db_type == DB_TYPE_SEQUENCE &&
      (rr) p create_info->seq_create_info
      $1 = (sequence_definition *) 0x0
      (rr) p create_info->db_type
      $2 = (handlerton *) 0x563db6af97b8
      (rr) p *create_info->db_type
      $3 = {db_type = 46, slot = 6, savepoint_offset = 8, close_connection = 0x0, 
      

      Note the create_info->db_type->db_type == 46 whereas DB_TYPE_SEQUENCE == 44 ??

      Attachments

        Activity

          People

            monty Michael Widenius
            janlindstrom Jan Lindström
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.