[MCOL-4731] MDB crashes if query has functional filter working with I_S.columnstore_columns table Created: 2021-05-22  Updated: 2023-07-02

Status: Open
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 6.1.1
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Roman Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

The query:

select width from information_schema.columnstore_extents e, information_schema.columnstore_columns c where e.object_id = c.object_id and lower(table_name) = 'mcol1347' and column_name in ('mcol1347c1','mcol1347c2', 'mcol1347c3', 'mcol1347v1', 'mcol1347v2', 'mcol1347v3');

that contains lower(table_name) expression crashes reWithDebInfo build of MDB with this stack trace:

#0  __strcasecmp_l_avx () at ../sysdeps/x86_64/multiarch/strcmp-sse42.S:199
#1  0x00007fabcd1bec33 in get_cond_item (item=0x7fab54014988, table=0x7fabb01ac740, db=0x7fabb01ac748) at /data/mdb-server/storage/columnstore/columnstore/dbcon/mysql/is_columnstore_columns.cpp:64
#2  0x00007fabcd1beead in get_cond_items (cond=<optimized out>, table=0x7fabb01ac740, db=0x7fabb01ac748) at /data/mdb-server/storage/columnstore/columnstore/dbcon/mysql/is_columnstore_columns.cpp:99
#3  0x00007fabcd1bf014 in is_columnstore_columns_fill (thd=0x7fab54000c58, tables=<optimized out>, cond=0x7fab5432d768) at /data/mdb-server/storage/columnstore/columnstore/dbcon/mysql/is_columnstore_columns.cpp:126
#4  0x0000560f1481c12e in get_schema_tables_result (join=join@entry=0x7fab54016ea8, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /data/mdb-server/sql/sql_show.cc:8727
#5  0x0000560f14801aaf in JOIN::exec_inner (this=0x7fab54016ea8) at /data/mdb-server/sql/sql_select.cc:4565
#6  0x0000560f148021f9 in JOIN::exec (this=this@entry=0x7fab54016ea8) at /data/mdb-server/sql/sql_select.cc:4389
#7  0x0000560f1480012a in mysql_select (thd=0x7fab54000c58, tables=0x7fab54013328, fields=..., conds=0x7fab54014bd0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x7fab54016e80, 
    unit=0x7fab54004de0, select_lex=0x7fab54012cc8) at /data/mdb-server/sql/sql_select.cc:4865
#8  0x0000560f14800b67 in handle_select (thd=thd@entry=0x7fab54000c58, lex=lex@entry=0x7fab54004d18, result=result@entry=0x7fab54016e80, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/mdb-server/sql/sql_select.cc:446
#9  0x0000560f147933f1 in execute_sqlcom_select (thd=0x7fab54000c58, all_tables=0x7fab54013328) at /data/mdb-server/sql/sql_parse.cc:6244
#10 0x0000560f1479cb88 in mysql_execute_command (thd=0x7fab54000c58) at /data/mdb-server/sql/sql_parse.cc:3940
#11 0x0000560f1478e365 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x7fab54000c58) at /data/mdb-server/sql/sql_parse.cc:8018
#12 mysql_parse (thd=0x7fab54000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/mdb-server/sql/sql_parse.cc:7940
#13 0x0000560f1479a5f8 in dispatch_command (command=COM_QUERY, thd=0x7fab54000c58, 
    packet=0x7fab54007ee9 "select width from information_schema.columnstore_extents e, information_schema.columnstore_columns c where e.object_id = c.object_id and lower(table_name) = 'MCOL1347' and column_name in ('mcol1347c1','mcol1347c2', 'mcol1347c3', 'mcol1347v1', 'mcol1347v2', 'mcol1347v3')", packet_length=<optimized out>, blocking=<optimized out>) at /data/mdb-server/sql/sql_class.h:1333
#14 0x0000560f1479b5d2 in do_command (thd=0x7fab54000c58, blocking=blocking@entry=true) at /data/mdb-server/sql/sql_parse.cc:1406
#15 0x0000560f1489c4b7 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /data/mdb-server/sql/sql_connect.cc:1410
#16 0x0000560f1489c80d in handle_one_connection (arg=arg@entry=0x560f182ed0c8) at /data/mdb-server/sql/sql_connect.cc:1312
#17 0x0000560f14beea7d in pfs_spawn_thread (arg=0x560f1818ea68) at /data/mdb-server/storage/perfschema/pfs.cc:2201
#18 0x00007fabceec4609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#19 0x00007fabcedeb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95


Generated at Thu Feb 08 02:52:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.