Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10094

Server crashes in Item_sum_ntile::val_int / Item_window_func::val_int

    XMLWordPrintable

    Details

      Description

      Note: might be related to MDEV-10092, or not. The dataset in the test case is the same as in MDEV-10092, only the query is different.

      #3  <signal handler called>
      #4  0x000055d337772f9d in Item_sum_ntile::val_int (this=0x7fb393667c88) at /src/10.2/sql/item_windowfunc.h:461
      #5  0x000055d33795d8df in Item_window_func::val_int (this=0x7fb393668360) at /src/10.2/sql/item_windowfunc.h:688
      #6  0x000055d3377d630d in Item::save_in_field (this=0x7fb393668360, field=0x7fb393790808, no_conversions=true) at /src/10.2/sql/item.cc:5899
      #7  0x000055d337718f24 in compute_window_func_with_frames (item_win=0x7fb393668360, tbl=0x7fb39376e888, info=0x7fb39f1c3340) at /src/10.2/sql/sql_window.cc:1752
      #8  0x000055d337719219 in Window_func_runner::exec (this=0x7fb39370dee0, tbl=0x7fb39376e888, filesort_result=0x7fb393501000) at /src/10.2/sql/sql_window.cc:1860
      #9  0x000055d337719305 in Window_funcs_sort::exec (this=0x7fb39370deb8, join=0x7fb39366ae68) at /src/10.2/sql/sql_window.cc:1887
      #10 0x000055d3377196b6 in Window_funcs_computation::exec (this=0x7fb39370de98, join=0x7fb39366ae68) at /src/10.2/sql/sql_window.cc:1969
      #11 0x000055d3375ea57c in AGGR_OP::end_send (this=0x7fb39366d910) at /src/10.2/sql/sql_select.cc:25992
      #12 0x000055d3375d6625 in sub_select_postjoin_aggr (join=0x7fb39366ae68, join_tab=0x7fb39370d018, end_of_records=true) at /src/10.2/sql/sql_select.cc:17973
      #13 0x000055d3375d6913 in sub_select (join=0x7fb39366ae68, join_tab=0x7fb39370cc70, end_of_records=true) at /src/10.2/sql/sql_select.cc:18209
      #14 0x000055d3375d61a5 in do_select (join=0x7fb39366ae68, procedure=0x0) at /src/10.2/sql/sql_select.cc:17803
      #15 0x000055d3375b21e6 in JOIN::exec_inner (this=0x7fb39366ae68) at /src/10.2/sql/sql_select.cc:3342
      #16 0x000055d3375b1766 in JOIN::exec (this=0x7fb39366ae68) at /src/10.2/sql/sql_select.cc:3154
      #17 0x000055d3375b2866 in mysql_select (thd=0x7fb39362df30, tables=0x7fb39366a778, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fb39366ae48, unit=0x7fb393631980, select_lex=0x7fb3936320a8) at /src/10.2/sql/sql_select.cc:3538
      #18 0x000055d3375a80b0 in handle_select (thd=0x7fb39362df30, lex=0x7fb3936318b8, result=0x7fb39366ae48, setup_tables_done_option=0) at /src/10.2/sql/sql_select.cc:377
      #19 0x000055d337577a47 in execute_sqlcom_select (thd=0x7fb39362df30, all_tables=0x7fb39366a778) at /src/10.2/sql/sql_parse.cc:6318
      #20 0x000055d33756d74c in mysql_execute_command (thd=0x7fb39362df30) at /src/10.2/sql/sql_parse.cc:3356
      #21 0x000055d33757b110 in mysql_parse (thd=0x7fb39362df30, rawbuf=0x7fb393667948 "select o_custkey, Ntile(17) OVER (PARTITION BY abs(o_custkey)+10 ORDER BY o_custkey ) from (select * from orders where o_custkey <= 20000) s", length=140, parser_state=0x7fb39f1c49e0, is_com_multi=false, is_next_command=false) at /src/10.2/sql/sql_parse.cc:7730
      #22 0x000055d337569561 in dispatch_command (command=COM_QUERY, thd=0x7fb39362df30, packet=0x7fb393661cb1 "", packet_length=140, is_com_multi=false, is_next_command=false) at /src/10.2/sql/sql_parse.cc:1794
      #23 0x000055d337567fa0 in do_command (thd=0x7fb39362df30) at /src/10.2/sql/sql_parse.cc:1355
      #24 0x000055d33769e43a in do_handle_one_connection (connect=0x7fb39ca84310) at /src/10.2/sql/sql_connect.cc:1358
      #25 0x000055d33769e1cc in handle_one_connection (arg=0x7fb39ca84310) at /src/10.2/sql/sql_connect.cc:1264
      #26 0x000055d337db35f6 in pfs_spawn_thread (arg=0x7fb397fc6ff0) at /src/10.2/storage/perfschema/pfs.cc:1862
      #27 0x00007fb39ee3f0a4 in start_thread () from /lib64/libpthread.so.0
      #28 0x00007fb39cfad04d in clone () from /lib64/libc.so.6
      

      # Data

      CREATE TABLE `orders` (
        `o_orderkey` int(11) NOT NULL,
        `o_custkey` int(11) DEFAULT NULL,
        `o_orderstatus` char(1) DEFAULT NULL,
        `o_totalprice` double DEFAULT NULL,
        `o_orderDATE` date DEFAULT NULL,
        `o_orderpriority` char(15) DEFAULT NULL,
        `o_clerk` char(15) DEFAULT NULL,
        `o_shippriority` int(11) DEFAULT NULL,
        `o_comment` varchar(79) DEFAULT NULL,
        PRIMARY KEY (`o_orderkey`),
        KEY `i_o_orderdate` (`o_orderDATE`),
        KEY `i_o_custkey` (`o_custkey`)
      ) DEFAULT CHARSET=latin1; 
       
      INSERT INTO `orders` VALUES (593793,3220,'O',181553.02,'1996-10-12','5-LOW','Clerk#000000921',0,'carefully unusual instructions are final pl');
      INSERT INTO `orders` VALUES (593794,4681,'F',32306.35,'1994-03-15','2-HIGH','Clerk#000000776',0,'slyly ironic depths are blithely. final excuses across the unusual instruction');
      INSERT INTO `orders` VALUES (593795,7213,'O',206579.47,'1998-03-04','2-HIGH','Clerk#000000746',0,'ruthlessly regular theodolites atop the blith');
      INSERT INTO `orders` VALUES (593796,10486,'F',181299.81,'1993-01-13','3-MEDIUM','Clerk#000000787',0,'special theodolites detect slyly. p');
      INSERT INTO `orders` VALUES (593797,3316,'O',208149.32,'1996-12-22','1-URGENT','Clerk#000000355',0,'carefully silent theodolites use blithely acco');
      INSERT INTO `orders` VALUES (593798,1613,'F',254625.5,'1995-01-26','2-HIGH','Clerk#000000504',0,'fluffily even requests ar');
      INSERT INTO `orders` VALUES (593799,4418,'F',45122.99,'1993-07-12','1-URGENT','Clerk#000000838',0,'blithely ironic ideas boost furiously above the ironic foxes. special pac');
      INSERT INTO `orders` VALUES (593824,12013,'F',216314.23,'1992-02-28','1-URGENT','Clerk#000000074',0,'quickly furious requests play above the fur');
      INSERT INTO `orders` VALUES (593825,8101,'O',123101.26,'1997-01-23','5-LOW','Clerk#000000649',0,'regular deposits haggle after the carefully i');
      INSERT INTO `orders` VALUES (593826,6958,'O',280097.59,'1995-12-14','2-HIGH','Clerk#000000080',0,'slyly even ideas about the slyly pending escapades cajole above th');
      INSERT INTO `orders` VALUES (593827,14116,'O',103011.78,'1995-12-16','3-MEDIUM','Clerk#000000567',0,'blithely bold decoys are furiously. fluffy deposits serve flu');
      INSERT INTO `orders` VALUES (593828,6839,'F',106697.51,'1993-12-11','4-NOT SPECIFIED','Clerk#000000065',0,'carefully final theodolites wake quickly final theodolites! unus');
      INSERT INTO `orders` VALUES (593829,14605,'O',44147.73,'1997-02-18','3-MEDIUM','Clerk#000000474',0,'ironic requests use carefully against the iro');
      INSERT INTO `orders` VALUES (593830,12976,'F',167393.6,'1994-06-21','1-URGENT','Clerk#000000424',0,'dolphins haggle careful');
      INSERT INTO `orders` VALUES (593831,14107,'O',208417.51,'1997-11-18','4-NOT SPECIFIED','Clerk#000000336',0,'furiously express pinto beans after the blithely pending requests need to ');
      INSERT INTO `orders` VALUES (593856,5623,'O',143236.09,'1998-03-24','5-LOW','Clerk#000000382',0,'carefully ironic accounts impress slyly according to the ironic');
      INSERT INTO `orders` VALUES (593857,1828,'O',217673.82,'1996-01-12','1-URGENT','Clerk#000000060',0,'special, special pinto beans haggle blithely. blithel');
      INSERT INTO `orders` VALUES (593858,14755,'O',8032.07,'1997-07-20','4-NOT SPECIFIED','Clerk#000000110',0,'regular excuses use ironic pinto ');
      INSERT INTO `orders` VALUES (593859,8780,'F',356852.14,'1992-10-09','2-HIGH','Clerk#000000510',0,'furiously regular accounts eat across the carefully ');
      INSERT INTO `orders` VALUES (593860,13318,'O',18413.14,'1998-01-10','2-HIGH','Clerk#000000673',0,'pending pains cajole furiously alo');
      INSERT INTO `orders` VALUES (593861,1175,'O',28859.21,'1996-09-10','4-NOT SPECIFIED','Clerk#000000680',0,'carefully silent instructi');
      INSERT INTO `orders` VALUES (593862,7787,'F',202891.72,'1992-02-27','5-LOW','Clerk#000000988',0,'slyly express requests sleep. express dependencies wake bli');
      INSERT INTO `orders` VALUES (593863,1897,'O',33062.05,'1998-06-29','1-URGENT','Clerk#000000117',0,'accounts integrate carefully across the fluffily even warhorses');
      INSERT INTO `orders` VALUES (593888,5656,'O',20952.26,'1997-02-04','3-MEDIUM','Clerk#000000735',0,'requests could have to cajole about the special, final ');
      INSERT INTO `orders` VALUES (593889,2692,'F',282718.42,'1992-08-02','4-NOT SPECIFIED','Clerk#000000669',0,'regular deposits haggle fluff');
      INSERT INTO `orders` VALUES (593890,3685,'O',34012.74,'1996-06-17','5-LOW','Clerk#000000993',0,'furiously even requests');
      INSERT INTO `orders` VALUES (593891,10333,'F',182791.4,'1993-01-23','4-NOT SPECIFIED','Clerk#000000098',0,'slyly final platelets doubt');
      INSERT INTO `orders` VALUES (593892,5687,'F',224381.48,'1994-09-18','2-HIGH','Clerk#000000294',0,'blithely bold epitaphs sleep after the carefully express in');
      INSERT INTO `orders` VALUES (593893,5437,'F',124300.91,'1993-08-04','4-NOT SPECIFIED','Clerk#000000302',0,'daring instructions alongside of the si');
      INSERT INTO `orders` VALUES (593894,1732,'F',150438.64,'1993-11-07','3-MEDIUM','Clerk#000000046',0,'quickly special accounts integrate by the even, dogged platelets? slowly ');
      INSERT INTO `orders` VALUES (593895,12230,'O',47380.97,'1997-03-23','2-HIGH','Clerk#000000168',0,'fluffily permanent instructions alongside of the furiously even pack');
      INSERT INTO `orders` VALUES (593920,13871,'F',2919.68,'1992-01-29','5-LOW','Clerk#000000597',0,'quickly regular foxes across the furiously bold accounts wake car');
      INSERT INTO `orders` VALUES (593921,6664,'F',139065.79,'1992-04-21','5-LOW','Clerk#000000017',0,'fluffily final deposits are carefully. quickly special pinto beans bel');
      INSERT INTO `orders` VALUES (593922,2504,'O',179041.45,'1997-04-05','2-HIGH','Clerk#000000902',0,'final pinto beans are furiously. ');
      INSERT INTO `orders` VALUES (593923,4978,'O',258843,'1998-02-27','1-URGENT','Clerk#000000654',0,'carefully final asymptotes according to the regular dependencie');
      INSERT INTO `orders` VALUES (593924,7550,'O',232280.81,'1995-10-28','3-MEDIUM','Clerk#000000063',0,'fluffily ironic packages haggle carefully pending platelets. q');
      INSERT INTO `orders` VALUES (593925,12226,'O',319755.48,'1995-09-01','3-MEDIUM','Clerk#000000308',0,'quickly pending packages throughout the quickly unusual requests');
      INSERT INTO `orders` VALUES (593926,2819,'F',204662.4,'1994-11-07','4-NOT SPECIFIED','Clerk#000000298',0,'blithely special grouches cajole ironic instructions. slyly pendin');
      INSERT INTO `orders` VALUES (593927,593,'F',188162.64,'1995-03-04','1-URGENT','Clerk#000000263',0,'express, unusual deposits boost furiously after the unusual dolphi');
      INSERT INTO `orders` VALUES (593952,9362,'P',318688.16,'1995-03-05','4-NOT SPECIFIED','Clerk#000000468',0,'ruthless requests must have to are carefully? special pa');
      INSERT INTO `orders` VALUES (593953,11410,'O',166717.28,'1998-07-29','5-LOW','Clerk#000000509',0,'even, regular instructions snooze. slyly ironic packages nag fluffily.');
      INSERT INTO `orders` VALUES (593954,8875,'O',132909.37,'1996-08-29','3-MEDIUM','Clerk#000000825',0,'special decoys integrate carefully. care');
      INSERT INTO `orders` VALUES (593955,12494,'O',73329.07,'1995-08-05','1-URGENT','Clerk#000000561',0,'quickly special request');
      INSERT INTO `orders` VALUES (593956,1390,'O',187837.11,'1995-10-17','5-LOW','Clerk#000000797',0,'silent, pending foxes');
      INSERT INTO `orders` VALUES (593957,10106,'F',196969.46,'1993-04-03','2-HIGH','Clerk#000000566',0,'blithely ruthless excuses boost slyly about the requests. careful');
      INSERT INTO `orders` VALUES (593958,14770,'F',103528.82,'1993-12-27','3-MEDIUM','Clerk#000000598',0,'carefully special deposits eat above the q');
      INSERT INTO `orders` VALUES (593959,14566,'O',156600.32,'1996-11-16','2-HIGH','Clerk#000000030',0,'accounts are quickly bold packages. carefully ironic depos');
      INSERT INTO `orders` VALUES (593984,4924,'O',47149.15,'1995-05-06','3-MEDIUM','Clerk#000000120',0,'regular asymptotes haggle slyly abo');
      INSERT INTO `orders` VALUES (593985,5185,'O',152533.91,'1997-08-04','3-MEDIUM','Clerk#000000575',0,'blithely special dolphins are even requests. carefully eve');
      INSERT INTO `orders` VALUES (593986,14257,'O',109734.28,'1998-06-05','3-MEDIUM','Clerk#000000930',0,'carefully final instructions against the slyly');
      INSERT INTO `orders` VALUES (593987,5818,'F',64541.52,'1994-04-13','3-MEDIUM','Clerk#000000259',0,'slyly pending deposits are furiously. regular requests h');
      INSERT INTO `orders` VALUES (593988,1178,'F',249608.42,'1994-10-01','2-HIGH','Clerk#000000266',0,'fluffily regular foxes toward the furiously bold accounts sleep furiously');
      INSERT INTO `orders` VALUES (593989,5173,'P',61508.55,'1995-03-02','2-HIGH','Clerk#000000374',0,'slyly express deposits wake between ');
      INSERT INTO `orders` VALUES (593990,8395,'O',129696.17,'1997-12-30','4-NOT SPECIFIED','Clerk#000000570',0,'carefully final requests haggle furiously fluffily final accou');
      INSERT INTO `orders` VALUES (593991,1894,'O',145691.27,'1998-04-09','5-LOW','Clerk#000000294',0,'slyly final notornis haggle carefull');
      INSERT INTO `orders` VALUES (594016,14935,'F',144592.29,'1992-10-20','3-MEDIUM','Clerk#000000602',0,'furiously express ideas cajole quickl');
      INSERT INTO `orders` VALUES (594017,892,'F',147267.55,'1994-12-10','1-URGENT','Clerk#000000419',0,'close, pending packages affix blithely. slyly regular reque');
      INSERT INTO `orders` VALUES (594018,8059,'F',124736.56,'1994-10-13','5-LOW','Clerk#000000235',0,'ideas run. bold frays wake along the furiously');
      INSERT INTO `orders` VALUES (594019,11632,'O',50017.33,'1997-03-23','5-LOW','Clerk#000000952',0,'quickly ironic realms');
      INSERT INTO `orders` VALUES (594020,10384,'O',144431.28,'1998-03-02','3-MEDIUM','Clerk#000000444',0,'fluffily regular pinto beans boost fluffily behind the bold, bold instruction');
      INSERT INTO `orders` VALUES (594021,6958,'O',29929.25,'1997-07-24','2-HIGH','Clerk#000000003',0,'blithely unusual accounts sleep blithely. f');
      INSERT INTO `orders` VALUES (594022,4972,'F',155850.33,'1992-07-09','5-LOW','Clerk#000000765',0,'instructions integrate sometimes above the pending packages-- ironic, r');
      INSERT INTO `orders` VALUES (594023,11906,'O',176704.86,'1995-09-21','2-HIGH','Clerk#000000389',0,'ironic deposits han');
      INSERT INTO `orders` VALUES (594048,1120,'F',155123.14,'1992-04-15','1-URGENT','Clerk#000000418',0,'slyly ironic accounts doze slyly along the carefu');
      INSERT INTO `orders` VALUES (594049,7177,'O',164707.56,'1998-04-18','5-LOW','Clerk#000000896',0,'blithely pending requests are foxes-- deposits cajole carefully. regular, spec');
      INSERT INTO `orders` VALUES (594050,13582,'O',31106.93,'1995-11-15','3-MEDIUM','Clerk#000000793',0,'carefully silent package');
      INSERT INTO `orders` VALUES (594051,10099,'F',211133.99,'1994-04-14','3-MEDIUM','Clerk#000000140',0,'special deposits wake slyly along the even foxes.');
      INSERT INTO `orders` VALUES (594052,5899,'F',222690.76,'1994-07-13','3-MEDIUM','Clerk#000000713',0,'regular, quick warthogs are carefully: regular fox');
      INSERT INTO `orders` VALUES (594053,1516,'O',79137.55,'1996-01-18','1-URGENT','Clerk#000000124',0,'slyly bold requests doze');
      INSERT INTO `orders` VALUES (594054,1120,'F',124814.24,'1992-09-10','1-URGENT','Clerk#000000874',0,'slyly final accounts serve slyly');
      INSERT INTO `orders` VALUES (594055,3691,'F',112198.32,'1994-12-08','2-HIGH','Clerk#000000109',0,'furiously regular foxes across the final ideas sleep f');
      INSERT INTO `orders` VALUES (594080,9751,'O',154620.06,'1996-01-31','3-MEDIUM','Clerk#000000405',0,'slyly pending pinto beans about the blithely express deposits detect b');
      INSERT INTO `orders` VALUES (594081,7547,'F',79899.56,'1992-12-02','5-LOW','Clerk#000000755',0,'carefully final pinto beans are fu');
      INSERT INTO `orders` VALUES (594082,11356,'O',220838.9,'1997-06-14','2-HIGH','Clerk#000000640',0,'quickly final packages are. quickly express instructions w');
      INSERT INTO `orders` VALUES (594083,3662,'F',87535.12,'1993-10-21','4-NOT SPECIFIED','Clerk#000000524',0,'slyly bold courts about the ironic excuses nag blithely at the quick');
      INSERT INTO `orders` VALUES (594084,8573,'O',219081.81,'1998-07-28','1-URGENT','Clerk#000000618',0,'requests mold. furiously b');
      INSERT INTO `orders` VALUES (594085,1954,'F',196796.6,'1994-04-08','1-URGENT','Clerk#000000777',0,'slyly special requests use carefully pending requests.');
      INSERT INTO `orders` VALUES (594086,12346,'F',72083.2,'1994-10-16','4-NOT SPECIFIED','Clerk#000000737',0,'regularly ironic deposits play carefully against t');
      INSERT INTO `orders` VALUES (594087,10472,'F',143125.74,'1992-12-26','2-HIGH','Clerk#000000551',0,'furiously bold warhorses haggle carefully. somet');
      INSERT INTO `orders` VALUES (594112,10000,'F',73748.63,'1993-07-27','3-MEDIUM','Clerk#000000901',0,'regular foxes use slyly. quickl');
      INSERT INTO `orders` VALUES (594113,2581,'O',47896.28,'1997-02-03','5-LOW','Clerk#000000940',0,'slyly ironic pinto be');
      INSERT INTO `orders` VALUES (594114,1132,'O',123294.54,'1997-11-07','3-MEDIUM','Clerk#000000911',0,'carefully final instructions');
      INSERT INTO `orders` VALUES (594115,259,'O',124756.1,'1998-05-28','3-MEDIUM','Clerk#000000946',0,'furiously unusual packages print fu');
      INSERT INTO `orders` VALUES (594116,11291,'P',74761,'1995-05-08','3-MEDIUM','Clerk#000000108',0,'furiously special pinto beans after the blit');
      INSERT INTO `orders` VALUES (594117,1417,'F',157603.9,'1994-02-23','2-HIGH','Clerk#000000494',0,'furiously ironic pinto beans use slyly unusual ideas. furiously bold request');
      INSERT INTO `orders` VALUES (594118,11659,'F',127596.71,'1994-11-05','2-HIGH','Clerk#000000815',0,'slyly final excuses according to the ');
      INSERT INTO `orders` VALUES (594119,4177,'O',107505.95,'1996-10-18','4-NOT SPECIFIED','Clerk#000000751',0,'final accounts affix dependencies. packages use quickly');
      INSERT INTO `orders` VALUES (594144,12631,'O',161634.66,'1997-10-02','5-LOW','Clerk#000000163',0,'regular packages sleep quic');
      INSERT INTO `orders` VALUES (594145,8320,'O',279390.96,'1996-08-30','4-NOT SPECIFIED','Clerk#000000114',0,'blithely final instructions ca');
      INSERT INTO `orders` VALUES (594146,1585,'O',80709.24,'1996-09-06','4-NOT SPECIFIED','Clerk#000000153',0,'blithely special accounts according to th');
      INSERT INTO `orders` VALUES (594147,8671,'F',197898.46,'1993-10-12','3-MEDIUM','Clerk#000000309',0,'pending, unusual ideas mold busy theodolites. deposits dazzle; qu');
      INSERT INTO `orders` VALUES (594148,10174,'F',249901.3,'1994-08-29','4-NOT SPECIFIED','Clerk#000000618',0,'carefully ironic requests are slyly slyly special accounts. carefully iro');
      INSERT INTO `orders` VALUES (594149,1898,'O',56077.27,'1997-03-27','5-LOW','Clerk#000000058',0,'unusual, even excuses try to nag. platelets about the slyly e');
      INSERT INTO `orders` VALUES (594150,109,'F',157373.48,'1994-08-28','5-LOW','Clerk#000000615',0,'pending accounts after the blithely bold epitaphs doubt accounts. ironic, pen');
      INSERT INTO `orders` VALUES (594151,9817,'O',109567.82,'1995-12-24','1-URGENT','Clerk#000000994',0,'furiously express deposi');
      INSERT INTO `orders` VALUES (594176,9466,'F',1374.6,'1993-12-07','3-MEDIUM','Clerk#000000564',0,'furiously unusual de');
      INSERT INTO `orders` VALUES (594177,13000,'O',38103.76,'1996-10-02','3-MEDIUM','Clerk#000000687',0,'slyly regular patterns across the busily regular asymptotes hagg');
      INSERT INTO `orders` VALUES (594178,889,'O',146839.7,'1996-02-24','5-LOW','Clerk#000000084',0,'regular instructions breach slyly carefully permanent theodolites; e');
      INSERT INTO `orders` VALUES (594179,10618,'F',138791.24,'1994-05-10','3-MEDIUM','Clerk#000000200',0,'foxes along the slyly regular instru');
      INSERT INTO `orders` VALUES (594180,7865,'P',243374.27,'1995-03-28','3-MEDIUM','Clerk#000000101',0,'blithely pending ideas above the p');
      INSERT INTO `orders` VALUES (594181,6499,'O',165111.68,'1997-04-14','4-NOT SPECIFIED','Clerk#000000577',0,'blithely silent dependencies boost pending de');
      INSERT INTO `orders` VALUES (594182,4586,'O',135239.38,'1997-10-13','3-MEDIUM','Clerk#000000007',0,'courts ought to cajole quickly across the furiously');
      INSERT INTO `orders` VALUES (594183,5908,'F',20819.24,'1994-09-23','3-MEDIUM','Clerk#000000022',0,'pending, pending foxes nag fluffily. furiously iro');
      INSERT INTO `orders` VALUES (594208,12334,'O',127676.64,'1996-04-28','1-URGENT','Clerk#000000519',0,'blithely even realms against the quickly even packages print slow');
      INSERT INTO `orders` VALUES (594209,13402,'F',10082.98,'1994-06-05','4-NOT SPECIFIED','Clerk#000000403',0,'slyly pending instructions detect after the final theodolites. re');
      INSERT INTO `orders` VALUES (594210,7211,'F',226710.71,'1994-05-16','3-MEDIUM','Clerk#000000875',0,'slyly regular theodolites cajole excuses. accounts would ');
      INSERT INTO `orders` VALUES (594211,12571,'F',121148.68,'1992-03-27','4-NOT SPECIFIED','Clerk#000000293',0,'regular requests along the regular ');
      INSERT INTO `orders` VALUES (594212,5197,'O',21183.3,'1996-03-28','1-URGENT','Clerk#000000337',0,'bold, special packages wake slyly. express acc');
      INSERT INTO `orders` VALUES (594213,11050,'O',61445.9,'1997-10-28','3-MEDIUM','Clerk#000000789',0,'blithely final theodolites boost');
      INSERT INTO `orders` VALUES (594214,14126,'F',78557.66,'1992-03-13','5-LOW','Clerk#000000353',0,'special, silent theodolites boost quickly');
      INSERT INTO `orders` VALUES (594215,10202,'O',223363.15,'1995-11-22','1-URGENT','Clerk#000000730',0,'carefully special requests after the express, ironic fo');
      INSERT INTO `orders` VALUES (594240,4307,'O',1727.32,'1996-04-24','1-URGENT','Clerk#000000003',0,'slyly ironic theodolites after the foxes boost above t');
      INSERT INTO `orders` VALUES (594241,7570,'O',294961.38,'1998-07-17','4-NOT SPECIFIED','Clerk#000000973',0,'furiously pending requests');
      INSERT INTO `orders` VALUES (594242,6047,'F',16909.13,'1994-01-27','1-URGENT','Clerk#000000431',0,'regular sentiments against the furi');
      INSERT INTO `orders` VALUES (594243,1601,'O',107068.25,'1997-05-11','5-LOW','Clerk#000000545',0,'quickly special ideas integr');
      INSERT INTO `orders` VALUES (594244,1438,'O',301544.12,'1996-12-21','5-LOW','Clerk#000000863',0,'pending pinto beans are. spe');
      INSERT INTO `orders` VALUES (594245,2416,'O',163741.39,'1996-06-16','4-NOT SPECIFIED','Clerk#000000405',0,'pending instructions sleep.');
      INSERT INTO `orders` VALUES (594246,6835,'O',278269.31,'1998-06-17','3-MEDIUM','Clerk#000000050',0,'even theodolites sleep blithely blithely unusual deposits. quickly stealthy Ti');
      INSERT INTO `orders` VALUES (594247,12994,'P',165996.14,'1995-03-17','1-URGENT','Clerk#000000885',0,'dolphins believe carefully about the regular packages. final, even pi');
      INSERT INTO `orders` VALUES (594272,10486,'O',66700.21,'1996-11-01','5-LOW','Clerk#000000472',0,'carefully final packages whithout the pains poach thin accounts. excuses ar');
      INSERT INTO `orders` VALUES (594273,2611,'O',238585.14,'1995-09-13','3-MEDIUM','Clerk#000000790',0,'idly bold accounts nag furiously. unusual, ironic deposits use ');
      INSERT INTO `orders` VALUES (594274,10121,'O',217157.28,'1995-10-18','1-URGENT','Clerk#000000302',0,'furiously express asymptotes p');
      INSERT INTO `orders` VALUES (594275,12316,'F',188355.81,'1993-02-15','5-LOW','Clerk#000000072',0,'even deposits sleep. regular deposits can slee');
      INSERT INTO `orders` VALUES (594276,13132,'F',252467.67,'1993-11-15','3-MEDIUM','Clerk#000000316',0,'never express theodolites poach fluff');
      INSERT INTO `orders` VALUES (594277,6149,'F',168144.4,'1992-02-23','1-URGENT','Clerk#000000689',0,'idly pending ideas cajole quickly enticing courts? carefully pending war');
      INSERT INTO `orders` VALUES (594278,12154,'O',54609.8,'1998-02-21','1-URGENT','Clerk#000000206',0,'theodolites cajole blithely. unu');
      INSERT INTO `orders` VALUES (594279,4226,'F',62899.68,'1994-04-30','3-MEDIUM','Clerk#000000170',0,'furiously bold requests wake slyly around the accounts. pending platelets a');
      INSERT INTO `orders` VALUES (594304,11089,'O',165568.05,'1998-03-17','2-HIGH','Clerk#000000550',0,'quickly silent foxes de');
      INSERT INTO `orders` VALUES (594305,12319,'F',132039.93,'1994-01-27','4-NOT SPECIFIED','Clerk#000000893',0,'slyly silent accounts wake acros');
      INSERT INTO `orders` VALUES (594306,12163,'F',102876.27,'1994-01-06','5-LOW','Clerk#000000579',0,'regular deposits wake furiously ironic accounts. bl');
      INSERT INTO `orders` VALUES (594307,10312,'O',22970.69,'1996-08-28','1-URGENT','Clerk#000000788',0,'regular, regular pinto beans nag carefully regular, i');
      INSERT INTO `orders` VALUES (594308,8851,'O',198379.62,'1997-03-31','2-HIGH','Clerk#000000738',0,'quickly ironic excuses use slyly. blithely even');
      INSERT INTO `orders` VALUES (594309,11794,'F',237587.21,'1994-04-05','1-URGENT','Clerk#000000531',0,'blithely regular pla');
      INSERT INTO `orders` VALUES (594310,9331,'F',219037.21,'1993-11-11','1-URGENT','Clerk#000000198',0,'special orbits would eat final, ironic dependencies. blithe packa');
      INSERT INTO `orders` VALUES (594311,4318,'O',179270.12,'1998-06-28','4-NOT SPECIFIED','Clerk#000000165',0,'pending requests thrash ');
      INSERT INTO `orders` VALUES (594336,4534,'O',96042.99,'1998-01-08','2-HIGH','Clerk#000000871',0,'final, regular pinto beans nag carefully final accounts; ');
      INSERT INTO `orders` VALUES (594337,13679,'O',265406.82,'1998-01-18','3-MEDIUM','Clerk#000000469',0,'enticingly ironic deposits use blithely? final,');
      INSERT INTO `orders` VALUES (594338,13216,'F',224502.49,'1993-03-22','3-MEDIUM','Clerk#000000258',0,'fluffily pending deposits shall ar');
      INSERT INTO `orders` VALUES (594339,5248,'O',155032,'1997-07-04','5-LOW','Clerk#000000283',0,'quickly even excuses to the quickly express requests haggle ');
      INSERT INTO `orders` VALUES (594340,5329,'F',251909.72,'1993-12-25','5-LOW','Clerk#000000605',0,'regular deposits haggle idly enticingly sp');
      INSERT INTO `orders` VALUES (594341,14125,'O',156729.84,'1997-03-06','5-LOW','Clerk#000000682',0,'slyly special theodolites above the instructions thrash ');
      INSERT INTO `orders` VALUES (594342,6574,'O',203324.39,'1996-03-07','2-HIGH','Clerk#000000922',0,'quickly regular ideas cajole furiou');
      INSERT INTO `orders` VALUES (594343,12613,'O',109422.3,'1997-11-28','1-URGENT','Clerk#000000568',0,'unusual packages integrate alongside of the ironic, regular pla');
      INSERT INTO `orders` VALUES (594368,727,'F',51177.23,'1994-12-01','5-LOW','Clerk#000000839',0,'ironic, ironic ideas cajole furio');
      INSERT INTO `orders` VALUES (594369,416,'O',66136.73,'1997-10-27','5-LOW','Clerk#000000753',0,'theodolites detect fluffily unusual requests. regular, un');
      INSERT INTO `orders` VALUES (594370,1067,'F',93385.95,'1993-12-14','5-LOW','Clerk#000000499',0,'bravely even package');
      INSERT INTO `orders` VALUES (594371,12425,'F',21635.97,'1992-04-14','5-LOW','Clerk#000000947',0,'dependencies sleep ');
      INSERT INTO `orders` VALUES (594372,10699,'F',212832.37,'1994-01-29','2-HIGH','Clerk#000000255',0,'carefully express patterns wake along the carefully ironic theodolites. b');
      INSERT INTO `orders` VALUES (594373,2849,'O',183910.17,'1997-06-05','1-URGENT','Clerk#000000064',0,'slyly final deposit');
      INSERT INTO `orders` VALUES (594374,14077,'O',57135.47,'1996-08-15','5-LOW','Clerk#000000175',0,'furiously regular accounts are carefully. fluffily r');
      INSERT INTO `orders` VALUES (594375,9562,'F',274047.78,'1993-10-20','2-HIGH','Clerk#000000206',0,'furiously final theodolites cajole carefully pending deposits? blit');
      INSERT INTO `orders` VALUES (594400,11782,'F',140965.47,'1994-05-30','4-NOT SPECIFIED','Clerk#000000321',0,'accounts haggle. quickly bold');
      INSERT INTO `orders` VALUES (594401,2122,'O',187968.83,'1996-02-20','3-MEDIUM','Clerk#000000813',0,'even accounts are carefully within the carefully ironic dolphins. flu');
      INSERT INTO `orders` VALUES (594402,9856,'F',7278.22,'1992-04-08','2-HIGH','Clerk#000000767',0,'regular ideas sleep. pinto bea');
      INSERT INTO `orders` VALUES (594403,4712,'O',73653.35,'1998-02-20','1-URGENT','Clerk#000000253',0,'blithely blithe accounts detect carefully even ');
      INSERT INTO `orders` VALUES (594404,11047,'F',264870.04,'1993-04-26','1-URGENT','Clerk#000000866',0,'accounts haggle. slyly final forges solve regularly alongsi');
      INSERT INTO `orders` VALUES (594405,5447,'F',299265.73,'1994-10-07','2-HIGH','Clerk#000000066',0,'instructions nag. regular platelets need to haggle ');
      INSERT INTO `orders` VALUES (594406,2371,'O',233393.91,'1998-06-04','2-HIGH','Clerk#000000382',0,'silent theodolites haggle quickly sometimes unusual foxes. exc');
      INSERT INTO `orders` VALUES (594407,7639,'O',306149.04,'1997-07-06','5-LOW','Clerk#000000832',0,'slyly even patterns sleep. blithe, final requests detect slyly unusual request');
      INSERT INTO `orders` VALUES (594432,2857,'F',51932.77,'1992-04-28','5-LOW','Clerk#000000288',0,'regular, final Tiresias sleep f');
      INSERT INTO `orders` VALUES (594433,1750,'O',92318.15,'1997-11-16','3-MEDIUM','Clerk#000000155',0,'platelets run furio');
      INSERT INTO `orders` VALUES (594434,3566,'F',61842.21,'1994-12-02','2-HIGH','Clerk#000000119',0,'fluffily express asymptotes haggle quickly. carefull');
      INSERT INTO `orders` VALUES (594435,14881,'F',103343.35,'1992-10-13','5-LOW','Clerk#000000823',0,'quickly regular asymptotes sleep');
      INSERT INTO `orders` VALUES (594436,14222,'O',142005.2,'1997-11-29','1-URGENT','Clerk#000000356',0,'foxes nag furiously. quick, even requests across the furiously e');
      INSERT INTO `orders` VALUES (594437,12800,'O',72759.74,'1996-02-10','4-NOT SPECIFIED','Clerk#000000125',0,'fluffily final packages ought to ');
      INSERT INTO `orders` VALUES (594438,7114,'O',302794.47,'1998-08-01','5-LOW','Clerk#000000285',0,'bold pinto beans wake bravely pending deposits. carefully final courts');
      INSERT INTO `orders` VALUES (594439,11365,'P',215565.53,'1995-03-12','5-LOW','Clerk#000000930',0,'blithely even accounts boost blithely. quickly ironic the');
      INSERT INTO `orders` VALUES (594464,8360,'O',192646.48,'1995-08-06','2-HIGH','Clerk#000000508',0,'slyly special theodolites wake sly');
      INSERT INTO `orders` VALUES (594465,9019,'F',130128.26,'1995-02-15','1-URGENT','Clerk#000000011',0,'unusual, final deposits after the express package');
      INSERT INTO `orders` VALUES (594466,11371,'F',33676.59,'1995-06-07','5-LOW','Clerk#000000693',0,'regular, ironic foxe');
      INSERT INTO `orders` VALUES (594467,8945,'O',197301.91,'1996-05-17','5-LOW','Clerk#000000987',0,'carefully pending accounts sleep about the carefully iron');
      INSERT INTO `orders` VALUES (594468,7894,'F',61486.08,'1993-03-08','4-NOT SPECIFIED','Clerk#000000609',0,'final platelets boost always slyly even packages.');
      INSERT INTO `orders` VALUES (594469,6383,'O',137177.3,'1997-12-17','1-URGENT','Clerk#000000918',0,'carefully special accounts haggle furiously according to the slyly ironi');
      INSERT INTO `orders` VALUES (594470,4408,'O',235700.9,'1997-03-04','5-LOW','Clerk#000000859',0,'packages sleep carefully after the carefully special instructions. request');
      INSERT INTO `orders` VALUES (594471,4747,'F',114424.47,'1992-08-13','5-LOW','Clerk#000000470',0,'regular deposits sleep. carefully ironic theodolites beyond the furiously bol');
      INSERT INTO `orders` VALUES (594496,4124,'F',78492.97,'1993-11-15','3-MEDIUM','Clerk#000000971',0,'quickly ironic deposits cajole fu');
      INSERT INTO `orders` VALUES (594497,11497,'F',133755.3,'1992-07-21','3-MEDIUM','Clerk#000000737',0,'carefully unusual requests impress always. blithely final pinto beans play c');
      INSERT INTO `orders` VALUES (594498,8273,'O',221541.72,'1997-07-29','3-MEDIUM','Clerk#000000089',0,'slyly ironic accounts across the foxes sleep among the caref');
      INSERT INTO `orders` VALUES (594499,9136,'F',40547.25,'1993-11-08','1-URGENT','Clerk#000000629',0,'carefully unusual warthogs haggle blithely special pinto bean');
      INSERT INTO `orders` VALUES (594500,9442,'F',183455.9,'1994-08-27','1-URGENT','Clerk#000000279',0,'bold, regular theodolites use s');
      INSERT INTO `orders` VALUES (594501,9863,'O',86237.34,'1998-06-08','1-URGENT','Clerk#000000967',0,'ironic requests haggle. ironic, express ac');
      INSERT INTO `orders` VALUES (594502,9469,'O',16743.15,'1996-09-03','2-HIGH','Clerk#000000951',0,'regular instructions above the foxes boost qui');
      INSERT INTO `orders` VALUES (594503,6718,'F',125161.76,'1994-02-14','3-MEDIUM','Clerk#000000848',0,'carefully final instructions sleep slyly bold f');
      INSERT INTO `orders` VALUES (594528,1805,'F',148253.98,'1992-10-14','4-NOT SPECIFIED','Clerk#000000794',0,'final dependencies sleep slyly slyly even packa');
      INSERT INTO `orders` VALUES (594529,8867,'F',217394.93,'1992-10-13','5-LOW','Clerk#000000894',0,'accounts about the ironic, final acc');
      INSERT INTO `orders` VALUES (594530,9775,'F',6576.33,'1994-11-24','5-LOW','Clerk#000000718',0,'special, unusual packages wake quickly silent, regular dinos. pin');
      INSERT INTO `orders` VALUES (594531,986,'P',142119.36,'1995-03-07','1-URGENT','Clerk#000000527',0,'deposits are. slyly');
      INSERT INTO `orders` VALUES (594532,9754,'O',139220.82,'1996-02-13','1-URGENT','Clerk#000000978',0,'express deposits along the perman');
      INSERT INTO `orders` VALUES (594533,1039,'O',251370.68,'1998-06-07','3-MEDIUM','Clerk#000000646',0,'carefully regular instructions nag. carefully express accounts wak');
      INSERT INTO `orders` VALUES (594534,11092,'F',166183.69,'1994-07-25','4-NOT SPECIFIED','Clerk#000000993',0,'express courts use slyly');
      INSERT INTO `orders` VALUES (594535,5143,'P',80694.24,'1995-04-17','4-NOT SPECIFIED','Clerk#000000643',0,'regular tithes can use');
      INSERT INTO `orders` VALUES (594560,3841,'F',164603.56,'1992-08-31','4-NOT SPECIFIED','Clerk#000000939',0,'fluffily express accounts are at');
      INSERT INTO `orders` VALUES (594561,10780,'F',54400.55,'1993-01-29','1-URGENT','Clerk#000000179',0,'pending, regular dolphins after the instructions serve blithely');
      INSERT INTO `orders` VALUES (594562,13351,'O',137231.27,'1995-11-19','5-LOW','Clerk#000000676',0,'carefully special packages serve among the deposits. c');
      INSERT INTO `orders` VALUES (594563,12896,'O',207008.44,'1998-05-27','1-URGENT','Clerk#000000735',0,'bold asymptotes haggle blithely reg');
      INSERT INTO `orders` VALUES (594564,6721,'O',82145.08,'1995-04-03','4-NOT SPECIFIED','Clerk#000000824',0,'furiously silent deposits breach slyly furiously ironic platel');
      INSERT INTO `orders` VALUES (594565,9826,'O',199421.86,'1997-11-25','2-HIGH','Clerk#000000522',0,'quickly regular instruc');
      INSERT INTO `orders` VALUES (594566,7525,'F',166746.97,'1994-07-03','2-HIGH','Clerk#000000436',0,'furiously ironic theodolites haggle according to the blithely spe');
      INSERT INTO `orders` VALUES (594567,598,'P',180669.18,'1995-03-05','2-HIGH','Clerk#000000736',0,'quickly final foxes sleep furiously caref');
      INSERT INTO `orders` VALUES (594592,14089,'F',113417.91,'1992-04-12','5-LOW','Clerk#000000925',0,'bravely silent requests detect ');
      INSERT INTO `orders` VALUES (594593,6604,'O',300690.29,'1996-01-28','5-LOW','Clerk#000000996',0,'accounts across the ironic requests wake slyly according to ');
      INSERT INTO `orders` VALUES (594594,11503,'F',94847.13,'1994-03-05','4-NOT SPECIFIED','Clerk#000000124',0,'even asymptotes haggle. blithely ironic packages are blit');
      

      # Query

      # Note: the crash also happens with the default sort_buffer_size, 
      # but then you need much more data in the table
       
      set sort_buffer_size = 4096;
       
      select o_custkey, Ntile(17) OVER (PARTITION BY abs(o_custkey)+10 ORDER BY o_custkey ) from (select * from orders where o_custkey <= 20000) s;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              cvicentiu Vicențiu Ciorbaru
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration