midenok
commented
4 years ago Good: col->ord_part set
#0 0x00000000011b6944 in dict_index_add_to_cache (index=@0x7f05540259b0: 0x7f05540254f8, page_no=4294967295, add_v=0x0) at /home/midenok/src/mariadb/10.3/src/storage/innobase/dict/dict0dict.cc:2180
#1 0x00000000011a110b in dict_create_index_step (thr=0x7f0554042088) at /home/midenok/src/mariadb/10.3/src/storage/innobase/dict/dict0crea.cc:1359
#2 0x0000000000f3282b in que_thr_step (thr=0x7f0554042088) at /home/midenok/src/mariadb/10.3/src/storage/innobase/que/que0que.cc:1047
#3 0x0000000000f31764 in que_run_threads_low (thr=0x7f0554042088) at /home/midenok/src/mariadb/10.3/src/storage/innobase/que/que0que.cc:1099
#4 0x0000000000f31489 in que_run_threads (thr=0x7f0554042088) at /home/midenok/src/mariadb/10.3/src/storage/innobase/que/que0que.cc:1139
#5 0x0000000000e2c6c4 in create_index_dict (trx=0x7f05b79011b8, index=0x7f05540254f8, add_v=0x0) at /home/midenok/src/mariadb/10.3/src/storage/innobase/handler/handler0alter.cc:4798
#6 0x0000000000e1c4d8 in prepare_inplace_alter_table_dict (ha_alter_info=0x7f05b40993c8, altered_table=0x7f05540404f8, old_table=0x7f0554039c98, table_name=0x7f055403c535 "bug53592", flags=1, flags2=80, fts_doc_id_col=18446744073709551615, add_fts_doc_id=false, add_fts_doc_id_idx=false) at /home/midenok/src/mariadb/10.3/src/storage/innobase/handler/handler0alter.cc:5638
#7 0x0000000000e12fdd in ha_innobase::prepare_inplace_alter_table (this=0x7f055402b3a0, altered_table=0x7f05540404f8, ha_alter_info=0x7f05b40993c8) at /home/midenok/src/mariadb/10.3/src/storage/innobase/handler/handler0alter.cc:6808
#8 0x0000000000b39cf1 in handler::ha_prepare_inplace_alter_table (this=0x7f055402b3a0, altered_table=0x7f05540404f8, ha_alter_info=0x7f05b40993c8) at /home/midenok/src/mariadb/10.3/src/sql/handler.cc:4556
#9 0x00000000008cc94d in mysql_inplace_alter_table (thd=0x7f0554000ce8, table_list=0x7f0554013d00, table=0x7f0554039c98, altered_table=0x7f05540404f8, ha_alter_info=0x7f05b40993c8, inplace_supported=HA_ALTER_INPLACE_NOCOPY_NO_LOCK, target_mdl_request=0x7f05b4099b18, alter_ctx=0x7f05b4099cc8) at /home/midenok/src/mariadb/10.3/src/sql/sql_table.cc:7594
#10 0x00000000008c6090 in mysql_alter_table (thd=0x7f0554000ce8, new_db=0x7f0554013d18, new_name=0x7f0554013d28, create_info=0x7f05b409c338, table_list=0x7f0554013d00, alter_info=0x7f05b409c280, order_num=0, order=0x0, ignore=false) at /home/midenok/src/mariadb/10.3/src/sql/sql_table.cc:9918
#11 0x00000000007c0e0f in mysql_execute_command (thd=0x7f0554000ce8) at /home/midenok/src/mariadb/10.3/src/sql/sql_parse.cc:4098
#12 0x00000000007ba4b0 in mysql_parse (thd=0x7f0554000ce8, rawbuf=0x7f0554013bd0 "create unique index bug53592_c on bug53592(c(1))", length=48, parser_state=0x7f05b409d5e8, is_com_multi=false, is_next_command=false) at /home/midenok/src/mariadb/10.3/src/sql/sql_parse.cc:78182169 n_ord = new_index->n_uniq;
2170 /* Flag the ordering columns and also set column max_prefix */
2171
2172 for (i = 0; i < n_ord; i++) {
2173 const dict_field_t* field
2174 = dict_index_get_nth_field(new_index, i);
2175
2176 /* Check the column being added in the index for
2177 the first time and flag the ordering column. */
2178 if (field->col->ord_part == 0 ) {
2179 field->col->max_prefix = field->prefix_len;
2180 field->col->ord_part = 1;Bad: f2 added to cache
#0 dict_index_add_to_cache (index=@0x7f1fec01e180: 0x7f1fec01dcc8, page_no=4294967295, add_v=0x0) at /home/midenok/src/mariadb/10.3/src/storage/innobase/dict/dict0dict.cc:2127
#1 0x00000000011a10cb in dict_create_index_step (thr=0x7f1fec02c3f8) at /home/midenok/src/mariadb/10.3/src/storage/innobase/dict/dict0crea.cc:1359
#2 0x0000000000f3282b in que_thr_step (thr=0x7f1fec02c3f8) at /home/midenok/src/mariadb/10.3/src/storage/innobase/que/que0que.cc:1047
#3 0x0000000000f31764 in que_run_threads_low (thr=0x7f1fec02c3f8) at /home/midenok/src/mariadb/10.3/src/storage/innobase/que/que0que.cc:1099
#4 0x0000000000f31489 in que_run_threads (thr=0x7f1fec02c3f8) at /home/midenok/src/mariadb/10.3/src/storage/innobase/que/que0que.cc:1139
#5 0x0000000000fa9fb7 in row_create_index_for_mysql (index=0x7f1fec01dcc8, trx=0x7f205a4641b8, field_lengths=0x0) at /home/midenok/src/mariadb/10.3/src/storage/innobase/row/row0mysql.cc:2567
#6 0x0000000000df9382 in create_index (trx=0x7f205a4641b8, form=0x7f20480571c0, table=0x7f1fec01bf98, key_num=2) at /home/midenok/src/mariadb/10.3/src/storage/innobase/handler/ha_innodb.cc:11195
#7 0x0000000000dda360 in create_table_info_t::create_table (this=0x7f2048056490, create_fk=true) at /home/midenok/src/mariadb/10.3/src/storage/innobase/handler/ha_innodb.cc:12421
#8 0x0000000000dfaa2c in ha_innobase::create (this=0x7f1fec01af10, name=0x7f2048059fc0 "./test/t1", form=0x7f20480571c0, create_info=0x7f204805a5c8, file_per_table=true, trx=0x7f205a4641b8) at /home/midenok/src/mariadb/10.3/src/storage/innobase/handler/ha_innodb.cc:12890
#9 0x0000000000ddb84f in ha_innobase::create (this=0x7f1fec01af10, name=0x7f2048059fc0 "./test/t1", form=0x7f20480571c0, create_info=0x7f204805a5c8) at /home/midenok/src/mariadb/10.3/src/storage/innobase/handler/ha_innodb.cc:12943
#10 0x0000000000b3a361 in handler::ha_create (this=0x7f1fec01af10, name=0x7f2048059fc0 "./test/t1", form=0x7f20480571c0, info_arg=0x7f204805a5c8) at /home/midenok/src/mariadb/10.3/src/sql/handler.cc:4714
#11 0x0000000000b3bf27 in ha_create_table (thd=0x7f1fec000ce8, path=0x7f2048059fc0 "./test/t1", db=0x7f1fec014440 "test", table_name=0x7f1fec013d98 "t1", create_info=0x7f204805a5c8, frm=0x7f2048059fb0) at /home/midenok/src/mariadb/10.3/src/sql/handler.cc:5177
#12 0x00000000009340eb in rea_create_table (thd=0x7f1fec000ce8, frm=0x7f2048059fb0, path=0x7f2048059fc0 "./test/t1", db=0x7f1fec014440 "test", table_name=0x7f1fec013d98 "t1", create_info=0x7f204805a5c8, file=0x7f1fec015760, no_ha_create_table=false) at /home/midenok/src/mariadb/10.3/src/sql/unireg.cc:514
#13 0x00000000008bcf53 in create_table_impl (thd=0x7f1fec000ce8, orig_db=0x7f1fec013e00, orig_table_name=0x7f1fec013e10, db=0x7f1fec013e00, table_name=0x7f1fec013e10, path=0x7f2048059fc0 "./test/t1", options=..., create_info=0x7f204805a5c8, alter_info=0x7f204805a510, create_table_mode=0, is_trans=0x7f204805a307, key_info=0x7f204805a1d0, key_count=0x7f204805a1cc, frm=0x7f2048059fb0) at /home/midenok/src/mariadb/10.3/src/sql/sql_table.cc:4999
#14 0x00000000008bc0e8 in mysql_create_table_no_lock (thd=0x7f1fec000ce8, db=0x7f1fec013e00, table_name=0x7f1fec013e10, create_info=0x7f204805a5c8, alter_info=0x7f204805a510, is_trans=0x7f204805a307, create_table_mode=0, table_list=0x7f1fec013de8) at /home/midenok/src/mariadb/10.3/src/sql/sql_table.cc:5118
#15 0x00000000008bd770 in mysql_create_table (thd=0x7f1fec000ce8, create_table=0x7f1fec013de8, create_info=0x7f204805a5c8, alter_info=0x7f204805a510) at /home/midenok/src/mariadb/10.3/src/sql/sql_table.cc:5210
#16 0x00000000008d20bd in Sql_cmd_create_table_like::execute (this=0x7f1fec013dc8, thd=0x7f1fec000ce8) at /home/midenok/src/mariadb/10.3/src/sql/sql_table.cc:11250
#17 0x00000000007c85cd in mysql_execute_command (thd=0x7f1fec000ce8) at /home/midenok/src/mariadb/10.3/src/sql/sql_parse.cc:6031
#18 0x00000000007ba4b0 in mysql_parse (thd=0x7f1fec000ce8, rawbuf=0x7f1fec013bd0 "CREATE TABLE t1 (f1 INT, f2 TEXT, f3 INT, FULLTEXT (f2), KEY(f1), KEY(f3), FOREIGN KEY r (f3) REFERENCES t1 (f1) ON DELETE SET NULL) WITH SYSTEM VERSIONING ENGINE=InnoDB", length=169, parser_state=0x7f204805d5e8, is_com_multi=false, is_next_command=false) at /home/midenok/src/mariadb/10.3/src/sql/sql_parse.cc:7818(rr) p index->n_uniq
$87 = 0Info
unsigned n_uniq:10;/*!< number of fields from the beginning
which are enough to determine an index
entry uniquely */n_uniq is set in dict_index_build_internal_non_clust() but it's not called for FTS index.
FTS indexes are treated differently:
3645 if (node->index->type != DICT_FTS) {
3646 dberr_t err = row_ins_index_entry_step(node, thr);
3647
3648 if (err != DB_SUCCESS) {
3649 DBUG_RETURN(err);
3650 }
3651 }
MDEV-21138 Assertion
col->ord_part' orf.col->ord_part' failed in row_build_index_entry_lowReproduce
Result
Related tests