Description:
2017-11-20T23:58:33.219089Z 0 [Note] /data/bld/mysql-8.0/bin/mysqld: ready for connections. Version: '8.0.3-rc-debug-log' socket: '/data/bld/mysql-8.0/mysql-test/var/tmp/mysqld.1.sock' port: 13000 Source distribution
mysqld: /data/src/mysql-8.0/sql/sql_executor.cc:4161: bool read_frame_buffer_row(int64, Window*, bool): Assertion `w->frame_buffer()->s->db_type()->db_type == DB_TYPE_INNODB || cnt <= 1 || (w->last_row_output() == 0 && w->frame() != nullptr && w->frame()->m_from->m_border_type == WBT_VALUE_FOLLOWING) || for_nth_value' failed.
23:58:34 UTC - mysqld got signal 6 ;
#7 0x00007fe877031ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x00000000025b63b6 in read_frame_buffer_row (rowno=89, w=0x7fe7e8116540, for_nth_value=false) at /data/src/mysql-8.0/sql/sql_executor.cc:4149
#9 0x00000000025b6690 in bring_back_frame_row (thd=0x7fe7e8014560, w=..., rowno=89, reason=Window::REA_FIRST_IN_FRAME, fno=0) at /data/src/mysql-8.0/sql/sql_executor.cc:4271
#10 0x00000000025b8336 in process_buffered_windowing_record (thd=0x7fe7e8014560, param=0x7fe7e81d0880, out_table=0x7fe7e8356ac0, new_partition_or_eof=true, output_row_ready=0x7fe870d00e22) at /data/src/mysql-8.0/sql/sql_executor.cc:5240
#11 0x00000000025b9a51 in end_write_wf (join=0x7fe7e81cf768, qep_tab=0x7fe7e81d0368, end_of_records=true) at /data/src/mysql-8.0/sql/sql_executor.cc:5774
#12 0x00000000025bd535 in QEP_tmp_table::put_record (this=0x7fe7e8360940, end_of_records=true) at /data/src/mysql-8.0/sql/sql_executor.cc:7127
#13 0x00000000025bd59a in QEP_tmp_table::end_send (this=0x7fe7e8360940) at /data/src/mysql-8.0/sql/sql_executor.cc:7148
#14 0x00000000025aff44 in sub_select_op (join=0x7fe7e81cf768, qep_tab=0x7fe7e81d0368, end_of_records=true) at /data/src/mysql-8.0/sql/sql_executor.cc:1418
#15 0x00000000025b00b3 in sub_select (join=0x7fe7e81cf768, qep_tab=0x7fe7e81d01e8, end_of_records=true) at /data/src/mysql-8.0/sql/sql_executor.cc:1576
#16 0x00000000025afbb5 in do_select (join=0x7fe7e81cf768) at /data/src/mysql-8.0/sql/sql_executor.cc:1297
#17 0x00000000025acf88 in JOIN::exec (this=0x7fe7e81cf768) at /data/src/mysql-8.0/sql/sql_executor.cc:285
#18 0x000000000265f392 in Sql_cmd_dml::execute_inner (this=0x7fe7e8117030, thd=0x7fe7e8014560) at /data/src/mysql-8.0/sql/sql_select.cc:725
#19 0x000000000265ee43 in Sql_cmd_dml::execute (this=0x7fe7e8117030, thd=0x7fe7e8014560) at /data/src/mysql-8.0/sql/sql_select.cc:605
#20 0x0000000002609d36 in mysql_execute_command (thd=0x7fe7e8014560, first_level=true) at /data/src/mysql-8.0/sql/sql_parse.cc:4628
#21 0x000000000260bf7c in mysql_parse (thd=0x7fe7e8014560, parser_state=0x7fe870d02430) at /data/src/mysql-8.0/sql/sql_parse.cc:5414
#22 0x00000000026023eb in dispatch_command (thd=0x7fe7e8014560, com_data=0x7fe870d02cc0, command=COM_QUERY) at /data/src/mysql-8.0/sql/sql_parse.cc:1708
#23 0x0000000002600ee6 in do_command (thd=0x7fe7e8014560) at /data/src/mysql-8.0/sql/sql_parse.cc:1291
#24 0x00000000029ab582 in handle_connection (arg=0x8120b20) at /data/src/mysql-8.0/sql/conn_handler/connection_handler_per_thread.cc:328
#25 0x000000000381b9e8 in pfs_spawn_thread (arg=0x817e140) at /data/src/mysql-8.0/storage/perfschema/pfs.cc:2985
#26 0x00007fe878698494 in start_thread (arg=0x7fe870d03700) at pthread_create.c:333
#27 0x00007fe8770ee93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
How to repeat:
CREATE TABLE IF NOT EXISTS orders (
o_orderkey INT NOT NULL,
o_custkey INT DEFAULT NULL,
o_orderstatus CHAR(1) DEFAULT NULL,
o_totalprice FLOAT DEFAULT NULL,
o_orderDATE DATE DEFAULT NULL,
o_orderpriority CHAR(15) DEFAULT NULL,
o_clerk CHAR(15) DEFAULT NULL,
o_shippriority INT DEFAULT NULL,
o_comment VARCHAR(79) DEFAULT NULL,
PRIMARY KEY (o_orderkey)
);
BEGIN;
INSERT INTO `orders` VALUES (1,370,'O',172799.49,'1996-01-02','5-LOW','Clerk_000000951',0,'blithely final dolphins solve-- blithely blithe packages nag blith');
INSERT INTO `orders` VALUES (2,781,'O',38426.09,'1996-12-01','1-URGENT','Clerk_000000880',0,'quickly regular depend');
INSERT INTO `orders` VALUES (3,1234,'F',205654.3,'1993-10-14','5-LOW','Clerk_000000955',0,'deposits alongside of the dependencies are slowly about ');
INSERT INTO `orders` VALUES (4,1369,'O',56000.91,'1995-10-11','5-LOW','Clerk_000000124',0,'final requests detect slyly across the blithely bold pinto beans. eve');
INSERT INTO `orders` VALUES (5,445,'F',105367.67,'1994-07-30','5-LOW','Clerk_000000925',0,'even deposits cajole furiously. quickly spe');
INSERT INTO `orders` VALUES (6,557,'F',45523.1,'1992-02-21','4-NOT SPECIFIED','Clerk_000000058',0,'ironically bold asymptotes sleep blithely beyond the regular, clos');
INSERT INTO `orders` VALUES (7,392,'O',271885.66,'1996-01-10','2-HIGH','Clerk_000000470',0,'ironic, regular deposits are. ironic foxes sl');
INSERT INTO `orders` VALUES (32,1301,'O',198665.57,'1995-07-16','2-HIGH','Clerk_000000616',0,'slyly final foxes are slyly. packag');
INSERT INTO `orders` VALUES (33,670,'F',146567.24,'1993-10-27','3-MEDIUM','Clerk_000000409',0,'packages maintain about the deposits foxes hang after ');
INSERT INTO `orders` VALUES (34,611,'O',73315.48,'1998-07-21','3-MEDIUM','Clerk_000000223',0,'quickly express asymptotes use. carefully final packages sleep f');
INSERT INTO `orders` VALUES (35,1276,'O',194641.93,'1995-10-23','4-NOT SPECIFIED','Clerk_000000259',0,'fluffily regular pinto beans ');
INSERT INTO `orders` VALUES (36,1153,'O',42011.04,'1995-11-03','1-URGENT','Clerk_000000358',0,'carefully ironic accounts nag');
INSERT INTO `orders` VALUES (37,862,'F',131896.49,'1992-06-03','3-MEDIUM','Clerk_000000456',0,'express requests ar');
INSERT INTO `orders` VALUES (38,1249,'O',71553.08,'1996-08-21','4-NOT SPECIFIED','Clerk_000000604',0,'slyly quick pinto beans detect flu');
INSERT INTO `orders` VALUES (39,818,'O',326565.37,'1996-09-20','3-MEDIUM','Clerk_000000659',0,'furiously unusual pinto beans above the furiously ironic asymptot');
INSERT INTO `orders` VALUES (64,322,'F',35831.73,'1994-07-16','3-MEDIUM','Clerk_000000661',0,'final deposits nag. blithely special deposits a');
INSERT INTO `orders` VALUES (65,163,'P',95469.44,'1995-03-18','1-URGENT','Clerk_000000632',0,'furiously even platelets boost ironic theodolites. even ');
INSERT INTO `orders` VALUES (66,1292,'F',104190.66,'1994-01-20','5-LOW','Clerk_000000743',0,'ironic requests are quickly about the carefully unusual a');
INSERT INTO `orders` VALUES (67,568,'O',182481.16,'1996-12-19','4-NOT SPECIFIED','Clerk_000000547',0,'regular, bold foxes across the even requests detect a');
INSERT INTO `orders` VALUES (68,286,'O',301968.79,'1998-04-18','3-MEDIUM','Clerk_000000440',0,'stealthy decoys nag furiously');
INSERT INTO `orders` VALUES (69,845,'F',204110.73,'1994-06-04','4-NOT SPECIFIED','Clerk_000000330',0,'carefully regular theodolites exce');
INSERT INTO `orders` VALUES (70,644,'F',125705.32,'1993-12-18','5-LOW','Clerk_000000322',0,'blithely unusual pack');
INSERT INTO `orders` VALUES (71,34,'O',260603.38,'1998-01-24','4-NOT SPECIFIED','Clerk_000000271',0,'furiously ironic dolphins sleep slyly. carefully special notornis cajole c');
INSERT INTO `orders` VALUES (96,1078,'F',64364.3,'1994-04-17','2-HIGH','Clerk_000000395',0,'carefully regular accounts ');
INSERT INTO `orders` VALUES (97,211,'F',100572.55,'1993-01-29','3-MEDIUM','Clerk_000000547',0,'carefully even packages believe sly');
INSERT INTO `orders` VALUES (98,1045,'F',71721.4,'1994-09-25','1-URGENT','Clerk_000000448',0,'carefully even dinos sleep blithely. regular, bold deposits');
INSERT INTO `orders` VALUES (99,890,'F',108594.87,'1994-03-13','4-NOT SPECIFIED','Clerk_000000973',0,'carefully regular theodolites may believe unu');
INSERT INTO `orders` VALUES (100,1471,'O',198978.27,'1998-02-28','4-NOT SPECIFIED','Clerk_000000577',0,'regular deposits sleep closely regular, regular packages. carefully si');
INSERT INTO `orders` VALUES (101,280,'O',118448.39,'1996-03-17','3-MEDIUM','Clerk_000000419',0,'blithely ironic accounts lose slyly about the pending, regular accounts');
INSERT INTO `orders` VALUES (102,8,'O',184806.58,'1997-05-09','2-HIGH','Clerk_000000596',0,'unusual deposits dazzle furiously blithely regular pinto beans. pending foxes');
INSERT INTO `orders` VALUES (103,292,'O',118745.16,'1996-06-20','4-NOT SPECIFIED','Clerk_000000090',0,'carefully ironic deposits are quickly blithely even');
INSERT INTO `orders` VALUES (128,740,'F',34997.04,'1992-06-15','1-URGENT','Clerk_000000385',0,'carefully special e');
INSERT INTO `orders` VALUES (129,712,'F',254281.41,'1992-11-19','5-LOW','Clerk_000000859',0,'slyly bold dolphins cajole c');
INSERT INTO `orders` VALUES (130,370,'F',140213.54,'1992-05-08','2-HIGH','Clerk_000000036',0,'slyly final accounts among');
INSERT INTO `orders` VALUES (131,928,'F',140726.47,'1994-06-08','3-MEDIUM','Clerk_000000625',0,'special courts wake blithely accordin');
INSERT INTO `orders` VALUES (132,265,'F',133485.89,'1993-06-11','3-MEDIUM','Clerk_000000488',0,'ironic platelets according to the evenly regula');
INSERT INTO `orders` VALUES (133,440,'O',95971.06,'1997-11-29','1-URGENT','Clerk_000000738',0,'slyly silent deposits haggle carefully fluffi');
INSERT INTO `orders` VALUES (134,62,'F',208201.46,'1992-05-01','4-NOT SPECIFIED','Clerk_000000711',0,'silently even deposits wake about the fluff');
INSERT INTO `orders` VALUES (135,605,'O',230472.84,'1995-10-21','4-NOT SPECIFIED','Clerk_000000804',0,'accounts cajole. final, pending dependencies a');
INSERT INTO `orders` VALUES (160,826,'O',114742.32,'1996-12-19','4-NOT SPECIFIED','Clerk_000000342',0,'unusual dependencie');
INSERT INTO `orders` VALUES (161,167,'F',17668.6,'1994-08-31','2-HIGH','Clerk_000000322',0,'ironic, even attainments cajole closely');
INSERT INTO `orders` VALUES (162,142,'O',3553.15,'1995-05-08','3-MEDIUM','Clerk_000000378',0,'instructions nag slyly. fluffily ironic sau');
INSERT INTO `orders` VALUES (163,878,'O',177809.13,'1997-09-05','3-MEDIUM','Clerk_000000379',0,'carefully express pinto beans serve carefully final as');
INSERT INTO `orders` VALUES (164,8,'F',250417.2,'1992-10-21','5-LOW','Clerk_000000209',0,'fluffily unusual requests al');
INSERT INTO `orders` VALUES (165,274,'F',193302.35,'1993-01-30','4-NOT SPECIFIED','Clerk_000000292',0,'furiously enticing accounts cajole sometimes. slyly express plat');
INSERT INTO `orders` VALUES (166,1079,'O',158207.39,'1995-09-12','2-HIGH','Clerk_000000440',0,'bold dependencies wake furiously regula');
INSERT INTO `orders` VALUES (167,1195,'F',64017.85,'1993-01-04','4-NOT SPECIFIED','Clerk_000000731',0,'express warhorses wake carefully furiously ironic deposits. c');
INSERT INTO `orders` VALUES (192,826,'O',194637.57,'1997-11-25','5-LOW','Clerk_000000483',0,'silent requests above the furiously even pinto beans sleep bl');
INSERT INTO `orders` VALUES (193,791,'F',80834.26,'1993-08-08','1-URGENT','Clerk_000000025',0,'slyly blithe instructions cajole carefully ironic, fina');
INSERT INTO `orders` VALUES (194,619,'F',154284.73,'1992-04-05','3-MEDIUM','Clerk_000000352',0,'carefully dogged excuses use abou');
INSERT INTO `orders` VALUES (195,1355,'F',216638.92,'1993-12-28','3-MEDIUM','Clerk_000000216',0,'ironic, final notornis are fluffily across the carefull');
INSERT INTO `orders` VALUES (196,649,'F',38660.64,'1993-03-17','2-HIGH','Clerk_000000988',0,'even deposits wake ');
INSERT INTO `orders` VALUES (197,326,'P',155247.48,'1995-04-07','2-HIGH','Clerk_000000969',0,'theodolites above the furiously regular deposits sleep blithely abo');
INSERT INTO `orders` VALUES (198,1103,'O',149551.63,'1998-01-02','4-NOT SPECIFIED','Clerk_000000331',0,'deposits haggle carefully after the furiously fi');
INSERT INTO `orders` VALUES (199,530,'O',95867.7,'1996-03-07','2-HIGH','Clerk_000000489',0,'unusual, regular requests c');
INSERT INTO `orders` VALUES (224,25,'F',234050.44,'1994-06-18','4-NOT SPECIFIED','Clerk_000000642',0,'quickly final accounts use even requests. ironic ac');
INSERT INTO `orders` VALUES (225,331,'P',226028.98,'1995-05-25','1-URGENT','Clerk_000000177',0,'blithely express cou');
INSERT INTO `orders` VALUES (226,1276,'F',256459.4,'1993-03-10','2-HIGH','Clerk_000000756',0,'even, ironic theodolites detect fluffily final instructions-- fi');
INSERT INTO `orders` VALUES (227,100,'O',69020.68,'1995-11-10','5-LOW','Clerk_000000919',0,'asymptotes are special, special requests. spec');
INSERT INTO `orders` VALUES (228,442,'F',2744.06,'1993-02-25','1-URGENT','Clerk_000000562',0,'blithely ironic requests boost pending theodolites. even deposits affix fluf');
INSERT INTO `orders` VALUES (229,1118,'F',195619.74,'1993-12-29','1-URGENT','Clerk_000000628',0,'blithely thin requests along the fluffily regular packages e');
INSERT INTO `orders` VALUES (230,1027,'F',147711.01,'1993-10-27','1-URGENT','Clerk_000000520',0,'ironic, silent tithes wake carefully until the even theodolites. special');
INSERT INTO `orders` VALUES (231,910,'F',234383.86,'1994-09-29','2-HIGH','Clerk_000000446',0,'express requests use always at the unusual deposits. silently final acc');
INSERT INTO `orders` VALUES (256,1249,'F',132718.67,'1993-10-19','4-NOT SPECIFIED','Clerk_000000834',0,'special dependencies boost furiously. pendin');
INSERT INTO `orders` VALUES (257,1228,'O',9255.12,'1998-03-28','3-MEDIUM','Clerk_000000680',0,'final, regular packages nag furiously fluffily f');
INSERT INTO `orders` VALUES (258,419,'F',259466.78,'1993-12-29','1-URGENT','Clerk_000000167',0,'regularly ironic grouches against the quickly express p');
INSERT INTO `orders` VALUES (259,433,'F',110611.59,'1993-09-29','4-NOT SPECIFIED','Clerk_000000601',0,'ironic packages haggle among the furiously brave deposits. final, final d');
INSERT INTO `orders` VALUES (260,1048,'O',268084.69,'1996-12-10','3-MEDIUM','Clerk_000000960',0,'quickly special ideas against the furiously final accounts affix deposits. sl');
INSERT INTO `orders` VALUES (261,461,'F',278279.3,'1993-06-29','3-MEDIUM','Clerk_000000310',0,'final accounts nag fluffily about');
INSERT INTO `orders` VALUES (262,304,'O',173401.63,'1995-11-25','4-NOT SPECIFIED','Clerk_000000551',0,'express, regular theodolites wake special instructions. slyly express ');
INSERT INTO `orders` VALUES (263,1162,'F',104961.32,'1994-05-17','2-HIGH','Clerk_000000088',0,'fluffily final ideas use quickly slyly final foxes? fluffily express dolphi');
INSERT INTO `orders` VALUES (288,71,'O',239366.68,'1997-02-21','1-URGENT','Clerk_000000109',0,'quickly ruthless instructions cajole ');
INSERT INTO `orders` VALUES (289,1039,'O',174624.55,'1997-02-10','3-MEDIUM','Clerk_000000103',0,'slyly express excuses d');
INSERT INTO `orders` VALUES (290,1180,'F',67636.54,'1994-01-01','4-NOT SPECIFIED','Clerk_000000735',0,'pending instructions against the furiously express d');
INSERT INTO `orders` VALUES (291,1411,'F',88375.89,'1994-03-13','1-URGENT','Clerk_000000923',0,'express requests according to the carefully regular deposits run');
INSERT INTO `orders` VALUES (292,223,'F',54152.77,'1992-01-13','2-HIGH','Clerk_000000193',0,'furiously special theodolites wake blith');
INSERT INTO `orders` VALUES (293,301,'F',46128.56,'1992-10-02','2-HIGH','Clerk_000000629',0,'regular instructions grow bold, u');
INSERT INTO `orders` VALUES (294,505,'F',46889.54,'1993-07-16','3-MEDIUM','Clerk_000000499',0,'idly ironic deposits must have to haggle deposits. blithel');
INSERT INTO `orders` VALUES (295,190,'F',148569.49,'1994-09-29','2-HIGH','Clerk_000000155',0,'doggedly final requests nag carefull');
INSERT INTO `orders` VALUES (320,4,'O',50202.6,'1997-11-21','2-HIGH','Clerk_000000573',0,'carefully silent ideas do solve final, express instructions. quickly final p');
INSERT INTO `orders` VALUES (321,1226,'F',73024.5,'1993-03-21','3-MEDIUM','Clerk_000000289',0,'quickly silent requests affix sl');
INSERT INTO `orders` VALUES (322,1336,'F',165992.05,'1992-03-19','1-URGENT','Clerk_000000158',0,'carefully unusual pinto beans lose carefully. even instructions ac');
INSERT INTO `orders` VALUES (323,392,'F',121127.17,'1994-03-26','1-URGENT','Clerk_000000959',0,'even, regular instructions');
INSERT INTO `orders` VALUES (324,1052,'F',46327.9,'1992-03-20','1-URGENT','Clerk_000000352',0,'regular theodolites boost quickly along the ironic, quick realms.');
INSERT INTO `orders` VALUES (325,401,'F',94638.59,'1993-10-17','5-LOW','Clerk_000000844',0,'carefully fluffy forges about the express, ir');
INSERT INTO `orders` VALUES (326,760,'O',325448.68,'1995-06-04','2-HIGH','Clerk_000000466',0,'regular theodolites was car');
INSERT INTO `orders` VALUES (327,1447,'P',32302.12,'1995-04-17','5-LOW','Clerk_000000992',0,'fluffily ironic deposits across the ironically regular ideas are ');
INSERT INTO `orders` VALUES (352,1066,'F',25542.02,'1994-03-08','2-HIGH','Clerk_000000932',0,'regular, regular pinto beans haggle sly');
INSERT INTO `orders` VALUES (353,19,'F',224983.69,'1993-12-31','5-LOW','Clerk_000000449',0,'even ideas haggle excuses? slyly ironic packages wake alongside of the qu');
INSERT INTO `orders` VALUES (354,1384,'O',231311.22,'1996-03-14','2-HIGH','Clerk_000000511',0,'quickly special packages inside the slyly unusual pain');
INSERT INTO `orders` VALUES (355,701,'F',103949.82,'1994-06-14','5-LOW','Clerk_000000532',0,'carefully even instructio');
INSERT INTO `orders` VALUES (356,1469,'F',189160.02,'1994-06-30','4-NOT SPECIFIED','Clerk_000000944',0,'fluffily pending theo');
INSERT INTO `orders` VALUES (357,604,'O',138936.83,'1996-10-09','2-HIGH','Clerk_000000301',0,'carefully bold theodolites cajole f');
INSERT INTO `orders` VALUES (358,23,'F',362024.17,'1993-09-20','2-HIGH','Clerk_000000392',0,'deposits sublate carefully at t');
INSERT INTO `orders` VALUES (359,776,'F',214770.97,'1994-12-19','3-MEDIUM','Clerk_000000934',0,'furiously final foxes are. regular,');
INSERT INTO `orders` VALUES (384,1132,'F',191275.12,'1992-03-03','5-LOW','Clerk_000000206',0,'regular packages haggle furiously idle requests wake carefu');
INSERT INTO `orders` VALUES (385,331,'O',75866.47,'1996-03-22','5-LOW','Clerk_000000600',0,'asymptotes wake silent, silent');
INSERT INTO `orders` VALUES (386,602,'F',119718.02,'1995-01-25','2-HIGH','Clerk_000000648',0,'quickly pending instructions unwind furiously theodolites. final package');
INSERT INTO `orders` VALUES (387,34,'O',197839.44,'1997-01-26','4-NOT SPECIFIED','Clerk_000000768',0,'blithely even accounts according to the even packag');
INSERT INTO `orders` VALUES (388,448,'F',161560.04,'1992-12-16','4-NOT SPECIFIED','Clerk_000000356',0,'accounts wake against the braids. silent accounts snooze slyly blithely ironi');
INSERT INTO `orders` VALUES (389,1270,'F',3266.69,'1994-02-17','2-HIGH','Clerk_000000062',0,'pending, bold packages boost blithely final package');
INSERT INTO `orders` VALUES (390,1027,'O',232256.36,'1998-04-07','5-LOW','Clerk_000000404',0,'blithely even pinto beans against the ironic packages boost qu');
INSERT INTO `orders` VALUES (391,1103,'F',14517.91,'1994-11-17','2-HIGH','Clerk_000000256',0,'furiously special deposits wake blithely. qu');
INSERT INTO `orders` VALUES (416,403,'F',106818.5,'1993-09-27','5-LOW','Clerk_000000294',0,'excuses boost permanently around the carefully pe');
INSERT INTO `orders` VALUES (417,547,'F',132531.73,'1994-02-06','3-MEDIUM','Clerk_000000468',0,'pending, regular pinto beans after the final, express accounts boost');
INSERT INTO `orders` VALUES (418,949,'P',39431.46,'1995-04-13','4-NOT SPECIFIED','Clerk_000000643',0,'quiet, bold ideas a');
INSERT INTO `orders` VALUES (419,1163,'O',159079.22,'1996-10-01','3-MEDIUM','Clerk_000000376',0,'accounts sleep quickly slyly bo');
INSERT INTO `orders` VALUES (420,902,'O',269064.47,'1995-10-31','4-NOT SPECIFIED','Clerk_000000756',0,'slyly final deposits sublate after the quickly pending deposits');
INSERT INTO `orders` VALUES (421,392,'F',1292.21,'1992-02-22','5-LOW','Clerk_000000405',0,'ironic, even account');
INSERT INTO `orders` VALUES (422,731,'O',155533.71,'1997-05-31','4-NOT SPECIFIED','Clerk_000000049',0,'carefully even packages use');
INSERT INTO `orders` VALUES (423,1034,'O',31900.6,'1996-06-01','1-URGENT','Clerk_000000674',0,'blithely unusual dugouts play quickly along the blithely regular theo');
INSERT INTO `orders` VALUES (448,1498,'O',157247.56,'1995-08-21','3-MEDIUM','Clerk_000000597',0,'furiously even requests nag carefully. ');
INSERT INTO `orders` VALUES (449,958,'O',55082.33,'1995-07-20','2-HIGH','Clerk_000000841',0,'final, express requests sleep permanent requests. spe');
INSERT INTO `orders` VALUES (450,475,'P',213638.07,'1995-03-05','4-NOT SPECIFIED','Clerk_000000293',0,'deposits wake regular, ironic instructions. bli');
INSERT INTO `orders` VALUES (451,988,'O',142756.81,'1998-05-25','5-LOW','Clerk_000000048',0,'final foxes nag. regul');
INSERT INTO `orders` VALUES (452,596,'O',2072.79,'1997-10-14','1-URGENT','Clerk_000000498',0,'theodolites should n');
COMMIT;
select o_custkey, Nth_value(o_custkey,2) OVER ( ORDER BY o_custkey RANGE BETWEEN 15 PRECEDING AND 15 PRECEDING) from orders;
DROP TABLE orders;
