mirror of
https://github.com/MariaDB/server.git
synced 2025-10-26 16:38:11 +01:00
328 lines
13 KiB
Text
328 lines
13 KiB
Text
#
|
|
# MDEV-10092: Server crashes in in ha_heap::rnd_pos / Table_read_cursor::get_next
|
|
#
|
|
CREATE TABLE `orders` (
|
|
`o_orderkey` int(11) NOT NULL,
|
|
`o_custkey` double 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,
|
|
KEY `i_o_orderdate` (`o_orderDATE`),
|
|
KEY `i_o_custkey` (`o_custkey`)
|
|
) DEFAULT CHARSET=latin1;
|
|
create procedure add_data()
|
|
begin
|
|
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');
|
|
end;
|
|
//
|
|
call add_data();
|
|
call add_data();
|
|
set sort_buffer_size = 1024;
|
|
flush status;
|
|
select o_custkey, Avg(o_custkey) OVER ( ORDER BY o_custkey ) as exp from orders;
|
|
o_custkey exp
|
|
593 593
|
|
593 593
|
|
892 742.5
|
|
892 742.5
|
|
1175 886.6666666666666
|
|
1175 886.6666666666666
|
|
1178 959.5
|
|
1178 959.5
|
|
1390 1045.6
|
|
1390 1045.6
|
|
1613 1140.1666666666667
|
|
1613 1140.1666666666667
|
|
1732 1224.7142857142858
|
|
1732 1224.7142857142858
|
|
1828 1300.125
|
|
1828 1300.125
|
|
1894 1366.111111111111
|
|
1894 1366.111111111111
|
|
1897 1419.2
|
|
1897 1419.2
|
|
2504 1517.8181818181818
|
|
2504 1517.8181818181818
|
|
2692 1615.6666666666667
|
|
2692 1615.6666666666667
|
|
2819 1708.2307692307693
|
|
2819 1708.2307692307693
|
|
3220 1816.2142857142858
|
|
3220 1816.2142857142858
|
|
3316 1916.2
|
|
3316 1916.2
|
|
3685 2026.75
|
|
3685 2026.75
|
|
4418 2167.4117647058824
|
|
4418 2167.4117647058824
|
|
4681 2307.0555555555557
|
|
4681 2307.0555555555557
|
|
4924 2444.7894736842104
|
|
4924 2444.7894736842104
|
|
4978 2571.45
|
|
4978 2571.45
|
|
5173 2695.3333333333335
|
|
5173 2695.3333333333335
|
|
5185 2808.5
|
|
5185 2808.5
|
|
5437 2922.782608695652
|
|
5437 2922.782608695652
|
|
5623 3035.2916666666665
|
|
5623 3035.2916666666665
|
|
5656 3140.12
|
|
5656 3140.12
|
|
5687 3238.076923076923
|
|
5687 3238.076923076923
|
|
5818 3333.6296296296296
|
|
5818 3333.6296296296296
|
|
6664 3452.5714285714284
|
|
6664 3452.5714285714284
|
|
6839 3569.344827586207
|
|
6839 3569.344827586207
|
|
6958 3682.3
|
|
6958 3682.3
|
|
7213 3796.1935483870966
|
|
7213 3796.1935483870966
|
|
7550 3913.5
|
|
7550 3913.5
|
|
7787 4030.878787878788
|
|
7787 4030.878787878788
|
|
8101 4150.588235294118
|
|
8101 4150.588235294118
|
|
8395 4271.857142857143
|
|
8395 4271.857142857143
|
|
8780 4397.083333333333
|
|
8780 4397.083333333333
|
|
8875 4518.108108108108
|
|
8875 4518.108108108108
|
|
9362 4645.578947368421
|
|
9362 4645.578947368421
|
|
10106 4785.589743589743
|
|
10106 4785.589743589743
|
|
10333 4924.275
|
|
10333 4924.275
|
|
10486 5059.926829268293
|
|
10486 5059.926829268293
|
|
11410 5211.119047619048
|
|
11410 5211.119047619048
|
|
12013 5369.302325581395
|
|
12013 5369.302325581395
|
|
12226 5525.136363636364
|
|
12226 5525.136363636364
|
|
12230 5674.133333333333
|
|
12230 5674.133333333333
|
|
12494 5822.391304347826
|
|
12494 5822.391304347826
|
|
12976 5974.595744680851
|
|
12976 5974.595744680851
|
|
13318 6127.583333333333
|
|
13318 6127.583333333333
|
|
13871 6285.6122448979595
|
|
13871 6285.6122448979595
|
|
14107 6442.04
|
|
14107 6442.04
|
|
14116 6592.509803921569
|
|
14116 6592.509803921569
|
|
14257 6739.903846153846
|
|
14257 6739.903846153846
|
|
14566 6887.566037735849
|
|
14566 6887.566037735849
|
|
14605 7030.481481481482
|
|
14605 7030.481481481482
|
|
14755 7170.927272727273
|
|
14755 7170.927272727273
|
|
14770 7306.625
|
|
14770 7306.625
|
|
14935 7440.456140350877
|
|
14935 7440.456140350877
|
|
select variable_name,
|
|
case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end as exp
|
|
from information_schema.session_status
|
|
where variable_name like 'Sort_merge_passes';
|
|
variable_name exp
|
|
SORT_MERGE_PASSES WITH PASSES
|
|
flush status;
|
|
select o_custkey, Avg(o_custkey) OVER ( ORDER BY o_custkey RANGE CURRENT ROW ) as exp from orders;
|
|
o_custkey exp
|
|
593 593
|
|
593 593
|
|
892 892
|
|
892 892
|
|
1175 1175
|
|
1175 1175
|
|
1178 1178
|
|
1178 1178
|
|
1390 1390
|
|
1390 1390
|
|
1613 1613
|
|
1613 1613
|
|
1732 1732
|
|
1732 1732
|
|
1828 1828
|
|
1828 1828
|
|
1894 1894
|
|
1894 1894
|
|
1897 1897
|
|
1897 1897
|
|
2504 2504
|
|
2504 2504
|
|
2692 2692
|
|
2692 2692
|
|
2819 2819
|
|
2819 2819
|
|
3220 3220
|
|
3220 3220
|
|
3316 3316
|
|
3316 3316
|
|
3685 3685
|
|
3685 3685
|
|
4418 4418
|
|
4418 4418
|
|
4681 4681
|
|
4681 4681
|
|
4924 4924
|
|
4924 4924
|
|
4978 4978
|
|
4978 4978
|
|
5173 5173
|
|
5173 5173
|
|
5185 5185
|
|
5185 5185
|
|
5437 5437
|
|
5437 5437
|
|
5623 5623
|
|
5623 5623
|
|
5656 5656
|
|
5656 5656
|
|
5687 5687
|
|
5687 5687
|
|
5818 5818
|
|
5818 5818
|
|
6664 6664
|
|
6664 6664
|
|
6839 6839
|
|
6839 6839
|
|
6958 6958
|
|
6958 6958
|
|
7213 7213
|
|
7213 7213
|
|
7550 7550
|
|
7550 7550
|
|
7787 7787
|
|
7787 7787
|
|
8101 8101
|
|
8101 8101
|
|
8395 8395
|
|
8395 8395
|
|
8780 8780
|
|
8780 8780
|
|
8875 8875
|
|
8875 8875
|
|
9362 9362
|
|
9362 9362
|
|
10106 10106
|
|
10106 10106
|
|
10333 10333
|
|
10333 10333
|
|
10486 10486
|
|
10486 10486
|
|
11410 11410
|
|
11410 11410
|
|
12013 12013
|
|
12013 12013
|
|
12226 12226
|
|
12226 12226
|
|
12230 12230
|
|
12230 12230
|
|
12494 12494
|
|
12494 12494
|
|
12976 12976
|
|
12976 12976
|
|
13318 13318
|
|
13318 13318
|
|
13871 13871
|
|
13871 13871
|
|
14107 14107
|
|
14107 14107
|
|
14116 14116
|
|
14116 14116
|
|
14257 14257
|
|
14257 14257
|
|
14566 14566
|
|
14566 14566
|
|
14605 14605
|
|
14605 14605
|
|
14755 14755
|
|
14755 14755
|
|
14770 14770
|
|
14770 14770
|
|
14935 14935
|
|
14935 14935
|
|
select variable_name,
|
|
case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end as exp
|
|
from information_schema.session_status
|
|
where variable_name like 'Sort_merge_passes';
|
|
variable_name exp
|
|
SORT_MERGE_PASSES WITH PASSES
|
|
drop table orders;
|
|
drop procedure add_data;
|