[MDEV-32625] CREATE TABLE ... ENGINE=SEQUENCE has confusing db_type Created: 2023-10-30  Updated: 2023-10-30

Status: Open
Project: MariaDB Server
Component/s: Sequences
Affects Version/s: 10.5
Fix Version/s: 10.5

Type: Bug Priority: Critical
Reporter: Jan Lindström Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: 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 ??


Generated at Thu Feb 08 10:32:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.