[MDEV-14835] Server crashes in strlen / Field_iterator_table::create_item when IN list reaches in_predicate_conversion_threshold - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL)
Fix Version/s: 10.3.5
Component/s: Optimizer
Labels:
None

Description

With default in_predicate_conversion_threshold

CREATE TABLE t1 (f BIGINT);

SELECT * from t1 WHERE f IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','437','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','484','485','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','503','504','505','506','507','508','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','533','534','535','536','537','538','539','540','541','542','543','544','545','546','547','548','549','550','551','552','553','554','555','556','557','558','559','560','561','562','563','564','565','566','567','568','569','570','571','572','573','574','575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594','595','596','597','598','599','600','601','602','603','604','605','606','607','608','609','610','611','612','613','614','615','616','617','618','619','620','621','622','623','624','625','626','627','628','629','630','631','632','633','634','635','636','637','638','639','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668','669','670','671','672','673','674','675','676','677','678','679','680','681','682','683','684','685','686','687','688','689','690','691','692','693','694','695','696','697','698','699','700','701','702','703','704','705','706','707','708','709','710','711','712','713','714','715','716','717','718','719','720','721','722','723','724','725','726','727','728','729','730','731','732','733','734','735','736','737','738','739','740','741','742','743','744','745','746','747','748','749','750','751','752','753','754','755','756','757','758','759','760','761','762','763','764','765','766','767','768','769','770','771','772','773','774','775','776','777','778','779','780','781','782','783','784','785','786','787','788','789','790','791','792','793','794','795','796','797','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','817','818','819','820','821','822','823','824','825','826','827','828','829','830','831','832','833','834','835','836','837','838','839','840','841','842','843','844','845','846','847','848','849','850','851','852','853','854','855','856','857','858','859','860','861','862','863','864','865','866','867','868','869','870','871','872','873','874','875','876','877','878','879','880','881','882','883','884','885','886','887','888','889','890','891','892','893','894','895','896','897','898','899','900','901','902','903','904','905','906','907','908','909','910','911','912','913','914','915','916','917','918','919','920','921','922','923','924','925','926','927','928','929','930','931','932','933','934','935','936','937','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955','956','957','958','959','960','961','962','963','964','965','966','967','968','969','970','971','972','973','974','975','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992','993','994','995','996','997','998','999','1000');

Smaller test case with custom in_predicate_conversion_threshold
SET in_predicate_conversion_threshold= 5;

CREATE TABLE t1 (f BIGINT);
SELECT * from t1 WHERE f IN ('1','2','3','4','5');

10.3 2750a0206510456f9242ee1a7343a28de81159c0
#3 <signal handler called>
#4 0x00007f4ccd275496 in strlen () from /lib/x86_64-linux-gnu/libc.so.6
#5 0x000055e3e4a86f4f in Field_iterator_table::create_item (this=0x7f4cc8433510, thd=0x7f4cac000b00) at /data/src/10.3/sql/table.cc:5745
#6 0x000055e3e49046c2 in Field_iterator_table_ref::create_item (this=0x7f4cc84334f0, thd=0x7f4cac000b00) at /data/src/10.3/sql/table.h:2558
#7 0x000055e3e490090e in insert_fields (thd=0x7f4cac000b00, context=0x7f4cac016628, db_name=0x0, table_name=0x0, it=0x7f4cc84338e0, any_privileges=false) at /data/src/10.3/sql/sql_base.cc:7749
#8 0x000055e3e48ff060 in setup_wild (thd=0x7f4cac000b00, tables=0x7f4cac017f18, fields=..., sum_func_list=0x7f4cac018a98, wild_num=1) at /data/src/10.3/sql/sql_base.cc:7168
#9 0x000055e3e49b617c in JOIN::prepare (this=0x7f4cac018778, tables_init=0x7f4cac017f18, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f4cac0165e0, unit_arg=0x7f4cac0169f0) at /data/src/10.3/sql/sql_select.cc:798
#10 0x000055e3e4d1c95a in subselect_single_select_engine::prepare (this=0x7f4cac018738, thd=0x7f4cac000b00) at /data/src/10.3/sql/item_subselect.cc:3665
#11 0x000055e3e4d10ade in Item_subselect::fix_fields (this=0x7f4cac018538, thd_param=0x7f4cac000b00, ref=0x7f4cc8433c48) at /data/src/10.3/sql/item_subselect.cc:275
#12 0x000055e3e4d1b9b3 in Item_in_subselect::fix_fields (this=0x7f4cac018538, thd_arg=0x7f4cac000b00, ref=0x7f4cc8433c48) at /data/src/10.3/sql/item_subselect.cc:3318
#13 0x000055e3e4b6c26a in Item_func_in::in_predicate_to_in_subs_transformer (this=0x7f4cac015828, thd=0x7f4cac000b00, arg=0x0) at /data/src/10.3/sql/sql_tvc.cc:749
#14 0x000055e3e4cc1507 in Item_func::transform (this=0x7f4cac015828, thd=0x7f4cac000b00, transformer=&virtual table offset 1232, argument=0x0) at /data/src/10.3/sql/item_func.cc:508
#15 0x000055e3e4b6c595 in JOIN::transform_in_predicates_into_in_subq (this=0x7f4cac015b00, thd=0x7f4cac000b00) at /data/src/10.3/sql/sql_tvc.cc:825
#16 0x000055e3e49b7d79 in JOIN::optimize_inner (this=0x7f4cac015b00) at /data/src/10.3/sql/sql_select.cc:1226
#17 0x000055e3e49b794f in JOIN::optimize (this=0x7f4cac015b00) at /data/src/10.3/sql/sql_select.cc:1141
#18 0x000055e3e49c0ea8 in mysql_select (thd=0x7f4cac000b00, tables=0x7f4cac014d80, wild_num=1, fields=..., conds=0x7f4cac015828, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f4cac015ae0, unit=0x7f4cac004838, select_lex=0x7f4cac004f70) at /data/src/10.3/sql/sql_select.cc:3821
#19 0x000055e3e49b4f2e in handle_select (thd=0x7f4cac000b00, lex=0x7f4cac004770, result=0x7f4cac015ae0, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:375
#20 0x000055e3e4980713 in execute_sqlcom_select (thd=0x7f4cac000b00, all_tables=0x7f4cac014d80) at /data/src/10.3/sql/sql_parse.cc:6499
#21 0x000055e3e4976f4e in mysql_execute_command (thd=0x7f4cac000b00) at /data/src/10.3/sql/sql_parse.cc:3739
#22 0x000055e3e4984046 in mysql_parse (thd=0x7f4cac000b00, rawbuf=0x7f4cac014b58 "SELECT * from t1 WHERE f IN ('1','2','3','4','5')", length=49, parser_state=0x7f4cc8435610, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7956
#23 0x000055e3e4971a61 in dispatch_command (command=COM_QUERY, thd=0x7f4cac000b00, packet=0x7f4cac11ecd1 "SELECT * from t1 WHERE f IN ('1','2','3','4','5')", packet_length=49, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1825
#24 0x000055e3e4970495 in do_command (thd=0x7f4cac000b00) at /data/src/10.3/sql/sql_parse.cc:1369
#25 0x000055e3e4ac9418 in do_handle_one_connection (connect=0x55e3e8084100) at /data/src/10.3/sql/sql_connect.cc:1401
#26 0x000055e3e4ac91a5 in handle_one_connection (arg=0x55e3e8084100) at /data/src/10.3/sql/sql_connect.cc:1307
#27 0x000055e3e4f5955e in pfs_spawn_thread (arg=0x55e3e80a0ba0) at /data/src/10.3/storage/perfschema/pfs.cc:1863
#28 0x00007f4cceef7494 in start_thread (arg=0x7f4cc8436700) at pthread_create.c:333
#29 0x00007f4ccd2dd93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Attachments

Issue Links

relates to

MDEV-14281 Wrong result from query with NOT IN predicate in WHERE

Closed

MDEV-14947 Assertion `0' fails in Field_null::can_optimize_keypart_ref when number of NULLs in IN list reaches in_predicate_conversion_threshold

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2017-12-31 18:26

Elena Stepanova made changes - 2017-12-31 18:27

Field	Original Value	New Value
Description	{noformat:title=bb-10.3-temporal a3a15126f260e26b715ae9a790135df1822b74d8} #3 <signal handler called> #4 0x00007efe7d7b3f21 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 #5 0x00000000008c1c37 in Field_iterator_table::create_item (this=0x7efe7c0c3f00, thd=0x7efe3800b660) at /home/travis/src/sql/table.cc:5878 #6 0x0000000000737aa6 in Field_iterator_table_ref::create_item (this=0x7efe7c0c3ee0, thd=0x7efe3800b660) at /home/travis/src/sql/table.h:2705 #7 0x0000000000733858 in insert_fields (thd=0x7efe3800b660, context=0x7efe386a5e08, db_name=0x0, table_name=0x0, it=0x7efe7c0c4350, any_privileges=false) at /home/travis/src/sql/sql_base.cc:7659 #8 0x000000000073201e in setup_wild (thd=0x7efe3800b660, tables=0x7efe3875b920, fields=..., sum_func_list=0x7efe3875c4c8, wild_num=1) at /home/travis/src/sql/sql_base.cc:7048 #9 0x00000000007eda61 in JOIN::prepare (this=0x7efe3875c1a8, tables_init=0x7efe3875b920, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7efe386a5dc0, unit_arg=0x7efe386a61d0) at /home/travis/src/sql/sql_select.cc:1223 #10 0x0000000000b6d82a in subselect_single_select_engine::prepare (this=0x7efe3875c160, thd=0x7efe3800b660) at /home/travis/src/sql/item_subselect.cc:3665 #11 0x0000000000b61c3f in Item_subselect::fix_fields (this=0x7efe3875bf60, thd_param=0x7efe3800b660, ref=0x7efe7c0c4790) at /home/travis/src/sql/item_subselect.cc:275 #12 0x0000000000b6c863 in Item_in_subselect::fix_fields (this=0x7efe3875bf60, thd_arg=0x7efe3800b660, ref=0x7efe7c0c4790) at /home/travis/src/sql/item_subselect.cc:3318 #13 0x00000000009b54f5 in Item_func_in::in_predicate_to_in_subs_transformer (this=0x7efe384c4508, thd=0x7efe3800b660, arg=0x0) at /home/travis/src/sql/sql_tvc.cc:749 #14 0x0000000000b13802 in Item_func::transform (this=0x7efe384c4508, thd=0x7efe3800b660, transformer=&virtual table offset 1256, argument=0x0) at /home/travis/src/sql/item_func.cc:508 #15 0x00000000009b5836 in JOIN::transform_in_predicates_into_in_subq (this=0x7efe384c4708, thd=0x7efe3800b660) at /home/travis/src/sql/sql_tvc.cc:825 #16 0x00000000007ef612 in JOIN::optimize_inner (this=0x7efe384c4708) at /home/travis/src/sql/sql_select.cc:1641 #17 0x00000000007ef1e2 in JOIN::optimize (this=0x7efe384c4708) at /home/travis/src/sql/sql_select.cc:1556 #18 0x00000000007f87fe in mysql_select (thd=0x7efe3800b660, tables=0x7efe3801e498, wild_num=1, fields=..., conds=0x7efe384c4508, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7efe384c46e8, unit=0x7efe3800f3f8, select_lex=0x7efe3800fb50) at /home/travis/src/sql/sql_select.cc:4244 #19 0x00000000007eaa4a in handle_select (thd=0x7efe3800b660, lex=0x7efe3800f330, result=0x7efe384c46e8, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382 #20 0x00000000007b5dd3 in execute_sqlcom_select (thd=0x7efe3800b660, all_tables=0x7efe3801e498) at /home/travis/src/sql/sql_parse.cc:6535 #21 0x00000000007ac1ef in mysql_execute_command (thd=0x7efe3800b660) at /home/travis/src/sql/sql_parse.cc:3749 #22 0x00000000007b9737 in mysql_parse (thd=0x7efe3800b660, rawbuf=0x7efe381b6408 "SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '201"..., length=307328, parser_state=0x7efe7c0c6470, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7991 #23 0x00000000007a6c36 in dispatch_command (command=COM_QUERY, thd=0x7efe3800b660, packet=0x7efe3816a361 "SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '201"..., packet_length=307329, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1825 #24 0x00000000007a565d in do_command (thd=0x7efe3800b660) at /home/travis/src/sql/sql_parse.cc:1370 #25 0x000000000090b7cf in do_handle_one_connection (connect=0x50e1530) at /home/travis/src/sql/sql_connect.cc:1420 #26 0x000000000090b551 in handle_one_connection (arg=0x50e1530) at /home/travis/src/sql/sql_connect.cc:1326 #27 0x00007efe7e229e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #28 0x00007efe7d7452ed in clone () from /lib/x86_64-linux-gnu/libc.so.6 #29 0x0000000000000000 in ?? () {noformat} {noformat:title=experimental 8d1aafbbe8a1290c4930b0ac98ebd556b18be001} perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1514737791 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --grammar=conf/mariadb/oltp.yy --gendata=conf/mariadb/oltp.zz --engine=Aria --mysqld=--default-storage-engine=Aria --vardir=/home/travis/logs/vardir1_4 {noformat}	https://api.travis-ci.org/v3/job/323555920/log.txt {noformat:title=bb-10.3-temporal a3a15126f260e26b715ae9a790135df1822b74d8} #3 <signal handler called> #4 0x00007efe7d7b3f21 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 #5 0x00000000008c1c37 in Field_iterator_table::create_item (this=0x7efe7c0c3f00, thd=0x7efe3800b660) at /home/travis/src/sql/table.cc:5878 #6 0x0000000000737aa6 in Field_iterator_table_ref::create_item (this=0x7efe7c0c3ee0, thd=0x7efe3800b660) at /home/travis/src/sql/table.h:2705 #7 0x0000000000733858 in insert_fields (thd=0x7efe3800b660, context=0x7efe386a5e08, db_name=0x0, table_name=0x0, it=0x7efe7c0c4350, any_privileges=false) at /home/travis/src/sql/sql_base.cc:7659 #8 0x000000000073201e in setup_wild (thd=0x7efe3800b660, tables=0x7efe3875b920, fields=..., sum_func_list=0x7efe3875c4c8, wild_num=1) at /home/travis/src/sql/sql_base.cc:7048 #9 0x00000000007eda61 in JOIN::prepare (this=0x7efe3875c1a8, tables_init=0x7efe3875b920, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7efe386a5dc0, unit_arg=0x7efe386a61d0) at /home/travis/src/sql/sql_select.cc:1223 #10 0x0000000000b6d82a in subselect_single_select_engine::prepare (this=0x7efe3875c160, thd=0x7efe3800b660) at /home/travis/src/sql/item_subselect.cc:3665 #11 0x0000000000b61c3f in Item_subselect::fix_fields (this=0x7efe3875bf60, thd_param=0x7efe3800b660, ref=0x7efe7c0c4790) at /home/travis/src/sql/item_subselect.cc:275 #12 0x0000000000b6c863 in Item_in_subselect::fix_fields (this=0x7efe3875bf60, thd_arg=0x7efe3800b660, ref=0x7efe7c0c4790) at /home/travis/src/sql/item_subselect.cc:3318 #13 0x00000000009b54f5 in Item_func_in::in_predicate_to_in_subs_transformer (this=0x7efe384c4508, thd=0x7efe3800b660, arg=0x0) at /home/travis/src/sql/sql_tvc.cc:749 #14 0x0000000000b13802 in Item_func::transform (this=0x7efe384c4508, thd=0x7efe3800b660, transformer=&virtual table offset 1256, argument=0x0) at /home/travis/src/sql/item_func.cc:508 #15 0x00000000009b5836 in JOIN::transform_in_predicates_into_in_subq (this=0x7efe384c4708, thd=0x7efe3800b660) at /home/travis/src/sql/sql_tvc.cc:825 #16 0x00000000007ef612 in JOIN::optimize_inner (this=0x7efe384c4708) at /home/travis/src/sql/sql_select.cc:1641 #17 0x00000000007ef1e2 in JOIN::optimize (this=0x7efe384c4708) at /home/travis/src/sql/sql_select.cc:1556 #18 0x00000000007f87fe in mysql_select (thd=0x7efe3800b660, tables=0x7efe3801e498, wild_num=1, fields=..., conds=0x7efe384c4508, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7efe384c46e8, unit=0x7efe3800f3f8, select_lex=0x7efe3800fb50) at /home/travis/src/sql/sql_select.cc:4244 #19 0x00000000007eaa4a in handle_select (thd=0x7efe3800b660, lex=0x7efe3800f330, result=0x7efe384c46e8, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382 #20 0x00000000007b5dd3 in execute_sqlcom_select (thd=0x7efe3800b660, all_tables=0x7efe3801e498) at /home/travis/src/sql/sql_parse.cc:6535 #21 0x00000000007ac1ef in mysql_execute_command (thd=0x7efe3800b660) at /home/travis/src/sql/sql_parse.cc:3749 #22 0x00000000007b9737 in mysql_parse (thd=0x7efe3800b660, rawbuf=0x7efe381b6408 "SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '201"..., length=307328, parser_state=0x7efe7c0c6470, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7991 #23 0x00000000007a6c36 in dispatch_command (command=COM_QUERY, thd=0x7efe3800b660, packet=0x7efe3816a361 "SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '201"..., packet_length=307329, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1825 #24 0x00000000007a565d in do_command (thd=0x7efe3800b660) at /home/travis/src/sql/sql_parse.cc:1370 #25 0x000000000090b7cf in do_handle_one_connection (connect=0x50e1530) at /home/travis/src/sql/sql_connect.cc:1420 #26 0x000000000090b551 in handle_one_connection (arg=0x50e1530) at /home/travis/src/sql/sql_connect.cc:1326 #27 0x00007efe7e229e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #28 0x00007efe7d7452ed in clone () from /lib/x86_64-linux-gnu/libc.so.6 #29 0x0000000000000000 in ?? () {noformat} {noformat:title=experimental 8d1aafbbe8a1290c4930b0ac98ebd556b18be001} perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1514737791 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --grammar=conf/mariadb/oltp.yy --gendata=conf/mariadb/oltp.zz --engine=Aria --mysqld=--default-storage-engine=Aria --vardir=/home/travis/logs/vardir1_4 {noformat}

Elena Stepanova made changes - 2017-12-31 18:31

Description

https://api.travis-ci.org/v3/job/323555920/log.txt
{noformat:title=bb-10.3-temporal a3a15126f260e26b715ae9a790135df1822b74d8}
#3 <signal handler called>
#4 0x00007efe7d7b3f21 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#5 0x00000000008c1c37 in Field_iterator_table::create_item (this=0x7efe7c0c3f00, thd=0x7efe3800b660) at /home/travis/src/sql/table.cc:5878
#6 0x0000000000737aa6 in Field_iterator_table_ref::create_item (this=0x7efe7c0c3ee0, thd=0x7efe3800b660) at /home/travis/src/sql/table.h:2705
#7 0x0000000000733858 in insert_fields (thd=0x7efe3800b660, context=0x7efe386a5e08, db_name=0x0, table_name=0x0, it=0x7efe7c0c4350, any_privileges=false) at /home/travis/src/sql/sql_base.cc:7659
#8 0x000000000073201e in setup_wild (thd=0x7efe3800b660, tables=0x7efe3875b920, fields=..., sum_func_list=0x7efe3875c4c8, wild_num=1) at /home/travis/src/sql/sql_base.cc:7048
#9 0x00000000007eda61 in JOIN::prepare (this=0x7efe3875c1a8, tables_init=0x7efe3875b920, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7efe386a5dc0, unit_arg=0x7efe386a61d0) at /home/travis/src/sql/sql_select.cc:1223
#10 0x0000000000b6d82a in subselect_single_select_engine::prepare (this=0x7efe3875c160, thd=0x7efe3800b660) at /home/travis/src/sql/item_subselect.cc:3665
#11 0x0000000000b61c3f in Item_subselect::fix_fields (this=0x7efe3875bf60, thd_param=0x7efe3800b660, ref=0x7efe7c0c4790) at /home/travis/src/sql/item_subselect.cc:275
#12 0x0000000000b6c863 in Item_in_subselect::fix_fields (this=0x7efe3875bf60, thd_arg=0x7efe3800b660, ref=0x7efe7c0c4790) at /home/travis/src/sql/item_subselect.cc:3318
#13 0x00000000009b54f5 in Item_func_in::in_predicate_to_in_subs_transformer (this=0x7efe384c4508, thd=0x7efe3800b660, arg=0x0) at /home/travis/src/sql/sql_tvc.cc:749
#14 0x0000000000b13802 in Item_func::transform (this=0x7efe384c4508, thd=0x7efe3800b660, transformer=&virtual table offset 1256, argument=0x0) at /home/travis/src/sql/item_func.cc:508
#15 0x00000000009b5836 in JOIN::transform_in_predicates_into_in_subq (this=0x7efe384c4708, thd=0x7efe3800b660) at /home/travis/src/sql/sql_tvc.cc:825
#16 0x00000000007ef612 in JOIN::optimize_inner (this=0x7efe384c4708) at /home/travis/src/sql/sql_select.cc:1641
#17 0x00000000007ef1e2 in JOIN::optimize (this=0x7efe384c4708) at /home/travis/src/sql/sql_select.cc:1556
#18 0x00000000007f87fe in mysql_select (thd=0x7efe3800b660, tables=0x7efe3801e498, wild_num=1, fields=..., conds=0x7efe384c4508, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7efe384c46e8, unit=0x7efe3800f3f8, select_lex=0x7efe3800fb50) at /home/travis/src/sql/sql_select.cc:4244
#19 0x00000000007eaa4a in handle_select (thd=0x7efe3800b660, lex=0x7efe3800f330, result=0x7efe384c46e8, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382
#20 0x00000000007b5dd3 in execute_sqlcom_select (thd=0x7efe3800b660, all_tables=0x7efe3801e498) at /home/travis/src/sql/sql_parse.cc:6535
#21 0x00000000007ac1ef in mysql_execute_command (thd=0x7efe3800b660) at /home/travis/src/sql/sql_parse.cc:3749
#22 0x00000000007b9737 in mysql_parse (thd=0x7efe3800b660, rawbuf=0x7efe381b6408 "SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '201"..., length=307328, parser_state=0x7efe7c0c6470, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7991
#23 0x00000000007a6c36 in dispatch_command (command=COM_QUERY, thd=0x7efe3800b660, packet=0x7efe3816a361 "SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '201"..., packet_length=307329, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1825
#24 0x00000000007a565d in do_command (thd=0x7efe3800b660) at /home/travis/src/sql/sql_parse.cc:1370
#25 0x000000000090b7cf in do_handle_one_connection (connect=0x50e1530) at /home/travis/src/sql/sql_connect.cc:1420
#26 0x000000000090b551 in handle_one_connection (arg=0x50e1530) at /home/travis/src/sql/sql_connect.cc:1326
#27 0x00007efe7e229e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#28 0x00007efe7d7452ed in clone () from /lib/x86_64-linux-gnu/libc.so.6
#29 0x0000000000000000 in ?? ()
{noformat}
{noformat:title=experimental 8d1aafbbe8a1290c4930b0ac98ebd556b18be001}
perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1514737791 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --grammar=conf/mariadb/oltp.yy --gendata=conf/mariadb/oltp.zz --engine=Aria --mysqld=--default-storage-engine=Aria --vardir=/home/travis/logs/vardir1_4
{noformat}

https://api.travis-ci.org/v3/job/323555920/log.txt
{noformat:title=bb-10.3-temporal a3a15126f260e26b715ae9a790135df1822b74d8}
Query (0x7efe381b6408): SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-
Connection ID (thread ID): 19
Status: NOT_KILLED

#3 <signal handler called>
#4 0x00007efe7d7b3f21 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#5 0x00000000008c1c37 in Field_iterator_table::create_item (this=0x7efe7c0c3f00, thd=0x7efe3800b660) at /home/travis/src/sql/table.cc:5878
#6 0x0000000000737aa6 in Field_iterator_table_ref::create_item (this=0x7efe7c0c3ee0, thd=0x7efe3800b660) at /home/travis/src/sql/table.h:2705
#7 0x0000000000733858 in insert_fields (thd=0x7efe3800b660, context=0x7efe386a5e08, db_name=0x0, table_name=0x0, it=0x7efe7c0c4350, any_privileges=false) at /home/travis/src/sql/sql_base.cc:7659
#8 0x000000000073201e in setup_wild (thd=0x7efe3800b660, tables=0x7efe3875b920, fields=..., sum_func_list=0x7efe3875c4c8, wild_num=1) at /home/travis/src/sql/sql_base.cc:7048
#9 0x00000000007eda61 in JOIN::prepare (this=0x7efe3875c1a8, tables_init=0x7efe3875b920, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7efe386a5dc0, unit_arg=0x7efe386a61d0) at /home/travis/src/sql/sql_select.cc:1223
#10 0x0000000000b6d82a in subselect_single_select_engine::prepare (this=0x7efe3875c160, thd=0x7efe3800b660) at /home/travis/src/sql/item_subselect.cc:3665
#11 0x0000000000b61c3f in Item_subselect::fix_fields (this=0x7efe3875bf60, thd_param=0x7efe3800b660, ref=0x7efe7c0c4790) at /home/travis/src/sql/item_subselect.cc:275
#12 0x0000000000b6c863 in Item_in_subselect::fix_fields (this=0x7efe3875bf60, thd_arg=0x7efe3800b660, ref=0x7efe7c0c4790) at /home/travis/src/sql/item_subselect.cc:3318
#13 0x00000000009b54f5 in Item_func_in::in_predicate_to_in_subs_transformer (this=0x7efe384c4508, thd=0x7efe3800b660, arg=0x0) at /home/travis/src/sql/sql_tvc.cc:749
#14 0x0000000000b13802 in Item_func::transform (this=0x7efe384c4508, thd=0x7efe3800b660, transformer=&virtual table offset 1256, argument=0x0) at /home/travis/src/sql/item_func.cc:508
#15 0x00000000009b5836 in JOIN::transform_in_predicates_into_in_subq (this=0x7efe384c4708, thd=0x7efe3800b660) at /home/travis/src/sql/sql_tvc.cc:825
#16 0x00000000007ef612 in JOIN::optimize_inner (this=0x7efe384c4708) at /home/travis/src/sql/sql_select.cc:1641
#17 0x00000000007ef1e2 in JOIN::optimize (this=0x7efe384c4708) at /home/travis/src/sql/sql_select.cc:1556
#18 0x00000000007f87fe in mysql_select (thd=0x7efe3800b660, tables=0x7efe3801e498, wild_num=1, fields=..., conds=0x7efe384c4508, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7efe384c46e8, unit=0x7efe3800f3f8, select_lex=0x7efe3800fb50) at /home/travis/src/sql/sql_select.cc:4244
#19 0x00000000007eaa4a in handle_select (thd=0x7efe3800b660, lex=0x7efe3800f330, result=0x7efe384c46e8, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382
#20 0x00000000007b5dd3 in execute_sqlcom_select (thd=0x7efe3800b660, all_tables=0x7efe3801e498) at /home/travis/src/sql/sql_parse.cc:6535
#21 0x00000000007ac1ef in mysql_execute_command (thd=0x7efe3800b660) at /home/travis/src/sql/sql_parse.cc:3749
#22 0x00000000007b9737 in mysql_parse (thd=0x7efe3800b660, rawbuf=0x7efe381b6408 "SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '201"..., length=307328, parser_state=0x7efe7c0c6470, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7991
#23 0x00000000007a6c36 in dispatch_command (command=COM_QUERY, thd=0x7efe3800b660, packet=0x7efe3816a361 "SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '201"..., packet_length=307329, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1825
#24 0x00000000007a565d in do_command (thd=0x7efe3800b660) at /home/travis/src/sql/sql_parse.cc:1370
#25 0x000000000090b7cf in do_handle_one_connection (connect=0x50e1530) at /home/travis/src/sql/sql_connect.cc:1420
#26 0x000000000090b551 in handle_one_connection (arg=0x50e1530) at /home/travis/src/sql/sql_connect.cc:1326
#27 0x00007efe7e229e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#28 0x00007efe7d7452ed in clone () from /lib/x86_64-linux-gnu/libc.so.6
#29 0x0000000000000000 in ?? ()
{noformat}
{noformat:title=experimental 8d1aafbbe8a1290c4930b0ac98ebd556b18be001}
perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1514737791 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --grammar=conf/mariadb/oltp.yy --gendata=conf/mariadb/oltp.zz --engine=Aria --mysqld=--default-storage-engine=Aria --vardir=/home/travis/logs/vardir1_4
{noformat}

Elena Stepanova made changes - 2018-01-14 16:13

Component/s		Optimizer [ 10200 ]
Fix Version/s		10.3 [ 22126 ]
Affects Version/s		10.3 [ 22126 ]
Affects Version/s	N/A [ 14700 ]
Assignee	Elena Stepanova [ elenst ]	Alice Sherepa [ alice ]
Description	https://api.travis-ci.org/v3/job/323555920/log.txt {noformat:title=bb-10.3-temporal a3a15126f260e26b715ae9a790135df1822b74d8} Query (0x7efe381b6408): SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017- Connection ID (thread ID): 19 Status: NOT_KILLED #3 <signal handler called> #4 0x00007efe7d7b3f21 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 #5 0x00000000008c1c37 in Field_iterator_table::create_item (this=0x7efe7c0c3f00, thd=0x7efe3800b660) at /home/travis/src/sql/table.cc:5878 #6 0x0000000000737aa6 in Field_iterator_table_ref::create_item (this=0x7efe7c0c3ee0, thd=0x7efe3800b660) at /home/travis/src/sql/table.h:2705 #7 0x0000000000733858 in insert_fields (thd=0x7efe3800b660, context=0x7efe386a5e08, db_name=0x0, table_name=0x0, it=0x7efe7c0c4350, any_privileges=false) at /home/travis/src/sql/sql_base.cc:7659 #8 0x000000000073201e in setup_wild (thd=0x7efe3800b660, tables=0x7efe3875b920, fields=..., sum_func_list=0x7efe3875c4c8, wild_num=1) at /home/travis/src/sql/sql_base.cc:7048 #9 0x00000000007eda61 in JOIN::prepare (this=0x7efe3875c1a8, tables_init=0x7efe3875b920, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7efe386a5dc0, unit_arg=0x7efe386a61d0) at /home/travis/src/sql/sql_select.cc:1223 #10 0x0000000000b6d82a in subselect_single_select_engine::prepare (this=0x7efe3875c160, thd=0x7efe3800b660) at /home/travis/src/sql/item_subselect.cc:3665 #11 0x0000000000b61c3f in Item_subselect::fix_fields (this=0x7efe3875bf60, thd_param=0x7efe3800b660, ref=0x7efe7c0c4790) at /home/travis/src/sql/item_subselect.cc:275 #12 0x0000000000b6c863 in Item_in_subselect::fix_fields (this=0x7efe3875bf60, thd_arg=0x7efe3800b660, ref=0x7efe7c0c4790) at /home/travis/src/sql/item_subselect.cc:3318 #13 0x00000000009b54f5 in Item_func_in::in_predicate_to_in_subs_transformer (this=0x7efe384c4508, thd=0x7efe3800b660, arg=0x0) at /home/travis/src/sql/sql_tvc.cc:749 #14 0x0000000000b13802 in Item_func::transform (this=0x7efe384c4508, thd=0x7efe3800b660, transformer=&virtual table offset 1256, argument=0x0) at /home/travis/src/sql/item_func.cc:508 #15 0x00000000009b5836 in JOIN::transform_in_predicates_into_in_subq (this=0x7efe384c4708, thd=0x7efe3800b660) at /home/travis/src/sql/sql_tvc.cc:825 #16 0x00000000007ef612 in JOIN::optimize_inner (this=0x7efe384c4708) at /home/travis/src/sql/sql_select.cc:1641 #17 0x00000000007ef1e2 in JOIN::optimize (this=0x7efe384c4708) at /home/travis/src/sql/sql_select.cc:1556 #18 0x00000000007f87fe in mysql_select (thd=0x7efe3800b660, tables=0x7efe3801e498, wild_num=1, fields=..., conds=0x7efe384c4508, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7efe384c46e8, unit=0x7efe3800f3f8, select_lex=0x7efe3800fb50) at /home/travis/src/sql/sql_select.cc:4244 #19 0x00000000007eaa4a in handle_select (thd=0x7efe3800b660, lex=0x7efe3800f330, result=0x7efe384c46e8, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382 #20 0x00000000007b5dd3 in execute_sqlcom_select (thd=0x7efe3800b660, all_tables=0x7efe3801e498) at /home/travis/src/sql/sql_parse.cc:6535 #21 0x00000000007ac1ef in mysql_execute_command (thd=0x7efe3800b660) at /home/travis/src/sql/sql_parse.cc:3749 #22 0x00000000007b9737 in mysql_parse (thd=0x7efe3800b660, rawbuf=0x7efe381b6408 "SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '201"..., length=307328, parser_state=0x7efe7c0c6470, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7991 #23 0x00000000007a6c36 in dispatch_command (command=COM_QUERY, thd=0x7efe3800b660, packet=0x7efe3816a361 "SELECT * from `oltp3` WHERE sys_trx_end IN ( '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '2017-12-31 16:31:04.699003', '201"..., packet_length=307329, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1825 #24 0x00000000007a565d in do_command (thd=0x7efe3800b660) at /home/travis/src/sql/sql_parse.cc:1370 #25 0x000000000090b7cf in do_handle_one_connection (connect=0x50e1530) at /home/travis/src/sql/sql_connect.cc:1420 #26 0x000000000090b551 in handle_one_connection (arg=0x50e1530) at /home/travis/src/sql/sql_connect.cc:1326 #27 0x00007efe7e229e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #28 0x00007efe7d7452ed in clone () from /lib/x86_64-linux-gnu/libc.so.6 #29 0x0000000000000000 in ?? () {noformat} {noformat:title=experimental 8d1aafbbe8a1290c4930b0ac98ebd556b18be001} perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1514737791 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --grammar=conf/mariadb/oltp.yy --gendata=conf/mariadb/oltp.zz --engine=Aria --mysqld=--default-storage-engine=Aria --vardir=/home/travis/logs/vardir1_4 {noformat}	{code:sql\|title=With default in_predicate_conversion_threshold} CREATE TABLE t1 (f BIGINT); SELECT * from t1 WHERE f IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','437','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','484','485','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','503','504','505','506','507','508','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','533','534','535','536','537','538','539','540','541','542','543','544','545','546','547','548','549','550','551','552','553','554','555','556','557','558','559','560','561','562','563','564','565','566','567','568','569','570','571','572','573','574','575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594','595','596','597','598','599','600','601','602','603','604','605','606','607','608','609','610','611','612','613','614','615','616','617','618','619','620','621','622','623','624','625','626','627','628','629','630','631','632','633','634','635','636','637','638','639','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668','669','670','671','672','673','674','675','676','677','678','679','680','681','682','683','684','685','686','687','688','689','690','691','692','693','694','695','696','697','698','699','700','701','702','703','704','705','706','707','708','709','710','711','712','713','714','715','716','717','718','719','720','721','722','723','724','725','726','727','728','729','730','731','732','733','734','735','736','737','738','739','740','741','742','743','744','745','746','747','748','749','750','751','752','753','754','755','756','757','758','759','760','761','762','763','764','765','766','767','768','769','770','771','772','773','774','775','776','777','778','779','780','781','782','783','784','785','786','787','788','789','790','791','792','793','794','795','796','797','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','817','818','819','820','821','822','823','824','825','826','827','828','829','830','831','832','833','834','835','836','837','838','839','840','841','842','843','844','845','846','847','848','849','850','851','852','853','854','855','856','857','858','859','860','861','862','863','864','865','866','867','868','869','870','871','872','873','874','875','876','877','878','879','880','881','882','883','884','885','886','887','888','889','890','891','892','893','894','895','896','897','898','899','900','901','902','903','904','905','906','907','908','909','910','911','912','913','914','915','916','917','918','919','920','921','922','923','924','925','926','927','928','929','930','931','932','933','934','935','936','937','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955','956','957','958','959','960','961','962','963','964','965','966','967','968','969','970','971','972','973','974','975','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992','993','994','995','996','997','998','999','1000'); {code} {code:sql\|title=Smaller test case with custom in_predicate_conversion_threshold} SET in_predicate_conversion_threshold= 5; CREATE TABLE t1 (f BIGINT); SELECT * from t1 WHERE f IN ('1','2','3','4','5'); {code} {noformat:title=10.3 2750a0206510456f9242ee1a7343a28de81159c0} #3 <signal handler called> #4 0x00007f4ccd275496 in strlen () from /lib/x86_64-linux-gnu/libc.so.6 #5 0x000055e3e4a86f4f in Field_iterator_table::create_item (this=0x7f4cc8433510, thd=0x7f4cac000b00) at /data/src/10.3/sql/table.cc:5745 #6 0x000055e3e49046c2 in Field_iterator_table_ref::create_item (this=0x7f4cc84334f0, thd=0x7f4cac000b00) at /data/src/10.3/sql/table.h:2558 #7 0x000055e3e490090e in insert_fields (thd=0x7f4cac000b00, context=0x7f4cac016628, db_name=0x0, table_name=0x0, it=0x7f4cc84338e0, any_privileges=false) at /data/src/10.3/sql/sql_base.cc:7749 #8 0x000055e3e48ff060 in setup_wild (thd=0x7f4cac000b00, tables=0x7f4cac017f18, fields=..., sum_func_list=0x7f4cac018a98, wild_num=1) at /data/src/10.3/sql/sql_base.cc:7168 #9 0x000055e3e49b617c in JOIN::prepare (this=0x7f4cac018778, tables_init=0x7f4cac017f18, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f4cac0165e0, unit_arg=0x7f4cac0169f0) at /data/src/10.3/sql/sql_select.cc:798 #10 0x000055e3e4d1c95a in subselect_single_select_engine::prepare (this=0x7f4cac018738, thd=0x7f4cac000b00) at /data/src/10.3/sql/item_subselect.cc:3665 #11 0x000055e3e4d10ade in Item_subselect::fix_fields (this=0x7f4cac018538, thd_param=0x7f4cac000b00, ref=0x7f4cc8433c48) at /data/src/10.3/sql/item_subselect.cc:275 #12 0x000055e3e4d1b9b3 in Item_in_subselect::fix_fields (this=0x7f4cac018538, thd_arg=0x7f4cac000b00, ref=0x7f4cc8433c48) at /data/src/10.3/sql/item_subselect.cc:3318 #13 0x000055e3e4b6c26a in Item_func_in::in_predicate_to_in_subs_transformer (this=0x7f4cac015828, thd=0x7f4cac000b00, arg=0x0) at /data/src/10.3/sql/sql_tvc.cc:749 #14 0x000055e3e4cc1507 in Item_func::transform (this=0x7f4cac015828, thd=0x7f4cac000b00, transformer=&virtual table offset 1232, argument=0x0) at /data/src/10.3/sql/item_func.cc:508 #15 0x000055e3e4b6c595 in JOIN::transform_in_predicates_into_in_subq (this=0x7f4cac015b00, thd=0x7f4cac000b00) at /data/src/10.3/sql/sql_tvc.cc:825 #16 0x000055e3e49b7d79 in JOIN::optimize_inner (this=0x7f4cac015b00) at /data/src/10.3/sql/sql_select.cc:1226 #17 0x000055e3e49b794f in JOIN::optimize (this=0x7f4cac015b00) at /data/src/10.3/sql/sql_select.cc:1141 #18 0x000055e3e49c0ea8 in mysql_select (thd=0x7f4cac000b00, tables=0x7f4cac014d80, wild_num=1, fields=..., conds=0x7f4cac015828, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f4cac015ae0, unit=0x7f4cac004838, select_lex=0x7f4cac004f70) at /data/src/10.3/sql/sql_select.cc:3821 #19 0x000055e3e49b4f2e in handle_select (thd=0x7f4cac000b00, lex=0x7f4cac004770, result=0x7f4cac015ae0, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:375 #20 0x000055e3e4980713 in execute_sqlcom_select (thd=0x7f4cac000b00, all_tables=0x7f4cac014d80) at /data/src/10.3/sql/sql_parse.cc:6499 #21 0x000055e3e4976f4e in mysql_execute_command (thd=0x7f4cac000b00) at /data/src/10.3/sql/sql_parse.cc:3739 #22 0x000055e3e4984046 in mysql_parse (thd=0x7f4cac000b00, rawbuf=0x7f4cac014b58 "SELECT * from t1 WHERE f IN ('1','2','3','4','5')", length=49, parser_state=0x7f4cc8435610, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7956 #23 0x000055e3e4971a61 in dispatch_command (command=COM_QUERY, thd=0x7f4cac000b00, packet=0x7f4cac11ecd1 "SELECT * from t1 WHERE f IN ('1','2','3','4','5')", packet_length=49, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1825 #24 0x000055e3e4970495 in do_command (thd=0x7f4cac000b00) at /data/src/10.3/sql/sql_parse.cc:1369 #25 0x000055e3e4ac9418 in do_handle_one_connection (connect=0x55e3e8084100) at /data/src/10.3/sql/sql_connect.cc:1401 #26 0x000055e3e4ac91a5 in handle_one_connection (arg=0x55e3e8084100) at /data/src/10.3/sql/sql_connect.cc:1307 #27 0x000055e3e4f5955e in pfs_spawn_thread (arg=0x55e3e80a0ba0) at /data/src/10.3/storage/perfschema/pfs.cc:1863 #28 0x00007f4cceef7494 in start_thread (arg=0x7f4cc8436700) at pthread_create.c:333 #29 0x00007f4ccd2dd93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat}
Summary	[Draft] Server crashes in Field_iterator_table::create_item	Server crashes in strlen / Field_iterator_table::create_item when IN list reaches in_predicate_conversion_threshold

Elena Stepanova made changes - 2018-01-14 16:13

Attachment

threads [ 44821 ]

Elena Stepanova made changes - 2018-01-14 21:32

Link

This issue relates to ~~MDEV-14947~~ [ ~~MDEV-14947~~ ]

Alice Sherepa made changes - 2018-01-15 11:10

Status

Open [ 1 ]

Confirmed [ 10101 ]

Alice Sherepa made changes - 2018-01-15 11:11

Assignee

Alice Sherepa [ alice ]

Igor Babaev [ igor ]

Alice Sherepa made changes - 2018-01-15 11:15

Link

This issue relates to ~~MDEV-14281~~ [ ~~MDEV-14281~~ ]

Igor Babaev (Inactive) made changes - 2018-01-19 05:19

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Igor Babaev (Inactive) added a comment - 2018-01-19 07:02

Galina,
The manual transformation works fine:

MariaDB [test]> insert into t1 values (2),(3),(6);

Query OK, 3 rows affected

Records: 3  Duplicates: 0  Warnings: 0

MariaDB [test]> SELECT * from t1 WHERE f IN (select * from (values ('1'),('2'),('3'),('4'),('5')) tvc_0);

+------+

| f    |

+------+

|    2 |

|    3 |

+------+

Please find out what your transformation lacks and fix the problem.

Igor Babaev (Inactive) added a comment - 2018-01-19 07:02 Galina, The manual transformation works fine: MariaDB [test]> insert into t1 values (2),(3),(6); Query OK, 3 rows affected Records: 3 Duplicates: 0 Warnings: 0 MariaDB [test]> SELECT * from t1 WHERE f IN (select * from (values ('1'),('2'),('3'),('4'),('5')) tvc_0); +------+ | f | +------+ | 2 | | 3 | +------+ Please find out what your transformation lacks and fix the problem.

Igor Babaev (Inactive) made changes - 2018-01-19 07:06

Assignee

Igor Babaev [ igor ]

Galina Shalygina [ shagalla ]

Sergei Golubchik made changes - 2018-02-07 12:27

Sprint

10.3.5-1 [ 229 ]

Galina Shalygina (Inactive) made changes - 2018-02-10 11:55

Assignee	Galina Shalygina [ shagalla ]	Igor Babaev [ igor ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2018-03-06 08:29

Sprint

10.3.5-1 [ 229 ]

Igor Babaev (Inactive) made changes - 2018-03-12 05:07

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Igor Babaev (Inactive) made changes - 2018-03-12 05:07

Assignee

Igor Babaev [ igor ]

Galina Shalygina [ shagalla ]

Galina Shalygina (Inactive) added a comment - 2018-03-27 11:04

Pushed in 10.3

Galina Shalygina (Inactive) added a comment - 2018-03-27 11:04 Pushed in 10.3

Galina Shalygina (Inactive) made changes - 2018-03-27 11:04

Fix Version/s		10.3.5 [ 22905 ]
Fix Version/s	10.3 [ 22126 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:46

Workflow

MariaDB v3 [ 84685 ]

MariaDB v4 [ 153486 ]

People

Assignee:: Galina Shalygina (Inactive)

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2017-12-31 18:26

Updated:: 2018-03-27 11:04

Resolved:: 2018-03-27 11:04

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration