Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
6.1.1
-
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
|