Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
Description
#3 <signal handler called>
|
#4 0x000055d14ae08fa8 in ha_heap::rnd_pos (this=0x7fc9b1f8fc88, buf=0x7fc9b1f8e5d0 "\375\374\003\001", pos=0x8 <error: Cannot access memory at address 0x8>) at /src/10.2/storage/heap/ha_heap.cc:357
|
#5 0x000055d14a851deb in handler::ha_rnd_pos (this=0x7fc9b1f8fc88, buf=0x7fc9b1f8e5d0 "\375\374\003\001", pos=0x8 <error: Cannot access memory at address 0x8>) at /src/10.2/sql/handler.cc:2599
|
#6 0x000055d14a7b2142 in Table_read_cursor::get_next (this=0x7fc9b1e6b948) at /src/10.2/sql/sql_window.cc:654
|
#7 0x000055d14a7b2f3c in Frame_range_current_row_top::next_row (this=0x7fc9b1e6b920, item=0x7fc9b1e67c90) at /src/10.2/sql/sql_window.cc:1195
|
#8 0x000055d14a7b0e75 in compute_window_func_with_frames (item_win=0x7fc9b1e680a0, tbl=0x7fc9b1f6d088, info=0x7fc9bda21340) at /src/10.2/sql/sql_window.cc:1741
|
#9 0x000055d14a7b1219 in Window_func_runner::exec (this=0x7fc9b1e6aee8, tbl=0x7fc9b1f6d088, filesort_result=0x7fc9b1d01000) at /src/10.2/sql/sql_window.cc:1860
|
#10 0x000055d14a7b1305 in Window_funcs_sort::exec (this=0x7fc9b1e6aec0, join=0x7fc9b1e68998) at /src/10.2/sql/sql_window.cc:1887
|
#11 0x000055d14a7b16b6 in Window_funcs_computation::exec (this=0x7fc9b1e6aea0, join=0x7fc9b1e68998) at /src/10.2/sql/sql_window.cc:1969
|
#12 0x000055d14a68257c in AGGR_OP::end_send (this=0x7fc9b1e6ac70) at /src/10.2/sql/sql_select.cc:25992
|
#13 0x000055d14a66e625 in sub_select_postjoin_aggr (join=0x7fc9b1e68998, join_tab=0x7fc9b1e69f48, end_of_records=true) at /src/10.2/sql/sql_select.cc:17973
|
#14 0x000055d14a66e913 in sub_select (join=0x7fc9b1e68998, join_tab=0x7fc9b1e69ba0, end_of_records=true) at /src/10.2/sql/sql_select.cc:18209
|
#15 0x000055d14a66e1a5 in do_select (join=0x7fc9b1e68998, procedure=0x0) at /src/10.2/sql/sql_select.cc:17803
|
#16 0x000055d14a64a1e6 in JOIN::exec_inner (this=0x7fc9b1e68998) at /src/10.2/sql/sql_select.cc:3342
|
#17 0x000055d14a649766 in JOIN::exec (this=0x7fc9b1e68998) at /src/10.2/sql/sql_select.cc:3154
|
#18 0x000055d14a64a866 in mysql_select (thd=0x7fc9b1e2d370, tables=0x7fc9b1e682a0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fc9b1e68978, unit=0x7fc9b1e30dc0, select_lex=0x7fc9b1e314e8) at /src/10.2/sql/sql_select.cc:3538
|
#19 0x000055d14a6400b0 in handle_select (thd=0x7fc9b1e2d370, lex=0x7fc9b1e30cf8, result=0x7fc9b1e68978, setup_tables_done_option=0) at /src/10.2/sql/sql_select.cc:377
|
#20 0x000055d14a60fa47 in execute_sqlcom_select (thd=0x7fc9b1e2d370, all_tables=0x7fc9b1e682a0) at /src/10.2/sql/sql_parse.cc:6318
|
#21 0x000055d14a60574c in mysql_execute_command (thd=0x7fc9b1e2d370) at /src/10.2/sql/sql_parse.cc:3356
|
#22 0x000055d14a613110 in mysql_parse (thd=0x7fc9b1e2d370, rawbuf=0x7fc9b1e67948 "select o_custkey, Avg(o_custkey) OVER ( ORDER BY o_custkey RANGE CURRENT ROW) from orders", length=89, parser_state=0x7fc9bda229e0, is_com_multi=false, is_next_command=false) at /src/10.2/sql/sql_parse.cc:7730
|
#23 0x000055d14a601561 in dispatch_command (command=COM_QUERY, thd=0x7fc9b1e2d370, packet=0x7fc9b1e617b1 "", packet_length=89, is_com_multi=false, is_next_command=false) at /src/10.2/sql/sql_parse.cc:1794
|
#24 0x000055d14a5fffa0 in do_command (thd=0x7fc9b1e2d370) at /src/10.2/sql/sql_parse.cc:1355
|
#25 0x000055d14a73643a in do_handle_one_connection (connect=0x7fc9bb284310) at /src/10.2/sql/sql_connect.cc:1358
|
#26 0x000055d14a7361cc in handle_one_connection (arg=0x7fc9bb284310) at /src/10.2/sql/sql_connect.cc:1264
|
#27 0x000055d14ae4b5f6 in pfs_spawn_thread (arg=0x7fc9b67c6ff0) at /src/10.2/storage/perfschema/pfs.cc:1862
|
#28 0x00007fc9bd69d0a4 in start_thread () from /lib64/libpthread.so.0
|
#29 0x00007fc9bb80b04d 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, Avg(o_custkey) OVER ( ORDER BY o_custkey RANGE CURRENT ROW) from orders; |
Attachments
Issue Links
- relates to
-
MDEV-10094 Server crashes in Item_sum_ntile::val_int / Item_window_func::val_int
- Closed