--source include/have_innodb.inc

CREATE TABLE lineitem (

  l_orderkey int(11) NOT NULL DEFAULT '0',

  l_partkey int(11) DEFAULT NULL,

  l_suppkey int(11) DEFAULT NULL,

  l_linenumber int(11) NOT NULL DEFAULT '0',

  l_quantity double DEFAULT NULL,

  l_extendedprice double DEFAULT NULL,

  l_discount double DEFAULT NULL,

  l_tax double DEFAULT NULL,

  l_returnflag char(1) DEFAULT NULL,

  l_linestatus char(1) DEFAULT NULL,

  l_shipDATE date DEFAULT NULL,

  l_commitDATE date DEFAULT NULL,

  l_receiptDATE date DEFAULT NULL,

  l_shipinstruct char(25) DEFAULT NULL,

  l_shipmode char(10) DEFAULT NULL,

  PRIMARY KEY (l_orderkey,l_linenumber),

  KEY (l_partkey),

  KEY i_l_receiptdate (l_receiptDATE)

) ENGINE=InnoDB;

INSERT INTO lineitem VALUES

(128,107,10,1,38,38269.8,0.06,0.01,'A','F','1992-09-01','1992-08-27','1992-10-01','TAKE BACK RETURN','FOB'),

(129,3,6,1,46,41538,0.08,0.02,'R','F','1993-02-15','1993-01-24','1993-03-05','COLLECT COD','TRUCK'),

(129,186,7,2,36,39102.48,0.01,0.02,'A','F','1992-11-25','1992-12-25','1992-12-09','TAKE BACK RETURN','REG AIR'),

(129,40,6,3,33,31021.32,0.04,0.06,'A','F','1993-01-08','1993-02-14','1993-01-29','COLLECT COD','SHIP'),

(129,136,7,4,34,35228.42,0,0.01,'R','F','1993-01-29','1993-02-14','1993-02-10','COLLECT COD','MAIL'),

(129,32,8,5,24,22368.72,0.06,0,'A','F','1992-12-07','1993-01-02','1992-12-11','TAKE BACK RETURN','FOB'),

(129,78,6,6,22,21517.54,0.06,0.01,'R','F','1993-02-15','1993-01-31','1993-02-24','COLLECT COD','SHIP'),

(129,169,6,7,1,1069.16,0.05,0.04,'R','F','1993-01-26','1993-01-08','1993-02-24','DELIVER IN PERSON','FOB'),

(130,129,10,1,14,14407.68,0.08,0.05,'A','F','1992-08-15','1992-07-25','1992-09-13','COLLECT COD','RAIL'),

(130,2,5,2,48,43296,0.03,0.02,'R','F','1992-07-01','1992-07-12','1992-07-24','NONE','AIR'),

(130,12,3,3,18,16416.18,0.04,0.08,'A','F','1992-07-04','1992-06-14','1992-07-29','DELIVER IN PERSON','MAIL'),

(130,116,6,4,13,13209.43,0.09,0.02,'R','F','1992-06-26','1992-07-29','1992-07-05','NONE','FOB'),

(130,70,7,5,31,30072.17,0.06,0.05,'R','F','1992-09-01','1992-07-18','1992-09-02','TAKE BACK RETURN','RAIL'),

(131,168,7,1,45,48067.2,0.1,0.02,'R','F','1994-09-14','1994-09-02','1994-10-04','NONE','FOB'),

(131,45,8,2,50,47252,0.02,0.04,'A','F','1994-09-17','1994-08-10','1994-09-21','NONE','SHIP'),

(131,190,1,3,4,4360.76,0.04,0.03,'A','F','1994-09-20','1994-08-30','1994-09-23','COLLECT COD','REG AIR'),

(132,141,8,1,18,18740.52,0,0.08,'R','F','1993-07-10','1993-08-05','1993-07-13','NONE','TRUCK'),

(132,120,1,2,43,43865.16,0.01,0.08,'R','F','1993-09-01','1993-08-16','1993-09-22','NONE','TRUCK'),

(132,115,6,3,32,32483.52,0.04,0.04,'A','F','1993-07-12','1993-08-05','1993-08-05','COLLECT COD','TRUCK'),

(132,29,2,4,23,21367.46,0.1,0,'A','F','1993-06-16','1993-08-27','1993-06-23','DELIVER IN PERSON','AIR'),

(133,104,7,1,27,27110.7,0,0.02,'N','O','1997-12-21','1998-02-23','1997-12-27','TAKE BACK RETURN','MAIL'),

(133,177,5,2,12,12926.04,0.02,0.06,'N','O','1997-12-02','1998-01-15','1997-12-29','DELIVER IN PERSON','REG AIR'),

(133,118,8,3,29,29525.19,0.09,0.08,'N','O','1998-02-28','1998-01-30','1998-03-09','DELIVER IN PERSON','RAIL'),

(133,90,1,4,11,10890.99,0.06,0.01,'N','O','1998-03-21','1998-01-15','1998-04-04','DELIVER IN PERSON','REG AIR'),

(134,1,2,1,21,18921,0,0.03,'A','F','1992-07-17','1992-07-08','1992-07-26','COLLECT COD','SHIP'),

(134,165,2,2,35,37280.6,0.06,0.07,'A','F','1992-08-23','1992-06-01','1992-08-24','NONE','MAIL'),

(134,189,10,3,26,28318.68,0.09,0.06,'A','F','1992-06-20','1992-07-12','1992-07-16','NONE','RAIL'),

(134,145,6,4,47,49121.58,0.05,0,'A','F','1992-08-16','1992-07-06','1992-08-28','NONE','REG AIR'),

(134,36,7,5,12,11232.36,0.05,0.02,'A','F','1992-07-03','1992-06-01','1992-07-11','COLLECT COD','TRUCK'),

(134,134,10,6,12,12409.56,0,0,'A','F','1992-08-08','1992-07-07','1992-08-20','TAKE BACK RETURN','FOB'),

(227,166,1,1,19,20257.04,0.05,0.06,'N','O','1995-12-10','1996-01-30','1995-12-26','NONE','RAIL'),

(227,175,3,2,24,25804.08,0.07,0.07,'N','O','1996-02-03','1995-12-24','1996-02-12','COLLECT COD','SHIP'),

(228,5,8,1,3,2715,0.1,0.08,'A','F','1993-05-20','1993-04-08','1993-05-26','DELIVER IN PERSON','SHIP'),

(229,84,5,1,20,19681.6,0.02,0.03,'R','F','1994-01-11','1994-01-31','1994-01-26','DELIVER IN PERSON','REG AIR'),

(229,129,10,2,29,29844.48,0.07,0,'A','F','1994-03-15','1994-03-02','1994-03-26','COLLECT COD','SHIP'),

(229,79,10,3,28,27413.96,0.02,0.02,'R','F','1994-02-10','1994-02-02','1994-03-10','DELIVER IN PERSON','FOB'),

(229,177,6,4,3,3231.51,0.02,0.08,'R','F','1994-03-22','1994-03-24','1994-04-04','DELIVER IN PERSON','REG AIR'),

(229,156,1,5,33,34852.95,0.03,0.06,'R','F','1994-03-25','1994-02-11','1994-04-13','NONE','FOB'),

(229,106,9,6,29,29176.9,0.04,0,'R','F','1994-01-14','1994-02-16','1994-01-22','NONE','FOB'),

(230,186,7,1,46,49964.28,0.09,0,'R','F','1994-02-03','1994-01-15','1994-02-23','TAKE BACK RETURN','SHIP'),

(230,195,7,2,6,6571.14,0.03,0.08,'A','F','1994-01-26','1994-01-25','1994-02-13','NONE','REG AIR'),

(230,8,5,3,1,908,0.07,0.06,'R','F','1994-01-22','1994-01-03','1994-02-05','TAKE BACK RETURN','RAIL'),

(230,10,3,4,44,40040.44,0.08,0.06,'R','F','1994-02-09','1994-01-18','1994-03-11','NONE','MAIL'),

(230,19,9,5,8,7352.08,0.09,0.06,'R','F','1993-11-03','1994-01-20','1993-11-11','TAKE BACK RETURN','TRUCK'),

(230,34,10,6,8,7472.24,0,0.05,'R','F','1993-11-21','1994-01-05','1993-12-19','TAKE BACK RETURN','FOB'),

(231,159,10,1,16,16946.4,0.04,0.08,'R','F','1994-11-20','1994-10-29','1994-12-17','TAKE BACK RETURN','AIR'),

(231,84,5,2,46,45267.68,0.04,0.05,'R','F','1994-12-13','1994-12-02','1994-12-14','DELIVER IN PERSON','SHIP'),

(231,199,1,3,50,54959.5,0.09,0.01,'A','F','1994-12-11','1994-12-14','1994-12-13','NONE','RAIL'),

(231,57,8,4,31,29668.55,0.08,0.02,'A','F','1994-11-05','1994-12-27','1994-11-30','TAKE BACK RETURN','SHIP'),

(256,89,10,1,22,21759.76,0.09,0.02,'R','F','1994-01-12','1993-12-28','1994-01-26','COLLECT COD','FOB'),

(256,119,6,2,40,40764.4,0.1,0.01,'A','F','1993-11-30','1993-12-13','1993-12-02','NONE','FOB'),

(256,130,9,3,45,46355.85,0.02,0.08,'R','F','1994-01-14','1994-01-17','1994-02-10','COLLECT COD','SHIP'),

(257,147,8,1,7,7329.98,0.05,0.02,'N','O','1998-06-18','1998-05-15','1998-06-27','COLLECT COD','FOB'),

(258,107,4,1,8,8056.8,0,0.07,'R','F','1994-01-20','1994-03-21','1994-02-09','NONE','REG AIR'),

(258,197,1,2,40,43887.6,0.1,0.01,'A','F','1994-03-13','1994-02-23','1994-04-05','DELIVER IN PERSON','FOB'),

(258,162,3,3,45,47797.2,0.07,0.07,'R','F','1994-03-04','1994-02-13','1994-03-30','DELIVER IN PERSON','TRUCK'),

(258,133,9,4,31,32027.03,0.02,0.05,'A','F','1994-04-20','1994-03-20','1994-04-28','COLLECT COD','REG AIR'),

(258,36,2,5,25,23400.75,0.08,0.02,'A','F','1994-04-13','1994-02-26','1994-04-29','TAKE BACK RETURN','TRUCK'),

(258,147,4,6,36,37697.04,0.09,0.04,'A','F','1994-01-11','1994-03-04','1994-01-18','DELIVER IN PERSON','AIR'),

(259,99,10,1,14,13987.26,0,0.08,'A','F','1993-12-17','1993-12-09','1993-12-31','COLLECT COD','SHIP'),

(259,162,1,2,14,14870.24,0.03,0.05,'R','F','1993-11-10','1993-11-20','1993-11-17','DELIVER IN PERSON','FOB'),

(259,24,5,3,42,38808.84,0.09,0,'R','F','1993-10-20','1993-11-18','1993-11-12','NONE','TRUCK'),

(259,196,10,4,3,3288.57,0.08,0.06,'R','F','1993-10-04','1993-11-07','1993-10-14','TAKE BACK RETURN','SHIP'),

(259,193,6,5,6,6559.14,0,0.05,'R','F','1993-12-05','1993-12-22','1993-12-21','COLLECT COD','TRUCK'),

(260,156,7,1,50,52807.5,0.07,0.08,'N','O','1997-03-24','1997-02-09','1997-04-20','TAKE BACK RETURN','REG AIR'),

(260,183,4,2,26,28162.68,0.02,0.07,'N','O','1996-12-12','1997-02-06','1996-12-15','NONE','TRUCK'),

(260,42,1,3,27,25435.08,0.05,0.08,'N','O','1997-03-23','1997-02-15','1997-04-22','TAKE BACK RETURN','RAIL'),

(260,6,1,4,29,26274,0.1,0.06,'N','O','1997-03-15','1997-01-14','1997-04-13','NONE','MAIL'),

(260,96,9,5,44,43827.96,0.01,0.05,'N','O','1997-03-26','1997-02-03','1997-04-19','DELIVER IN PERSON','MAIL'),

(261,2,7,1,34,30668,0.05,0.08,'R','F','1993-08-18','1993-09-24','1993-08-20','COLLECT COD','REG AIR'),

(261,66,7,2,20,19321.2,0,0.06,'R','F','1993-10-21','1993-08-02','1993-11-04','DELIVER IN PERSON','RAIL'),

(261,174,3,3,28,30076.76,0.08,0.03,'R','F','1993-07-24','1993-08-20','1993-08-05','COLLECT COD','AIR'),

(261,119,3,4,49,49936.39,0.04,0.05,'R','F','1993-09-12','1993-08-31','1993-10-07','COLLECT COD','SHIP'),

(261,61,6,5,49,47091.94,0.01,0.08,'A','F','1993-09-29','1993-09-08','1993-10-01','COLLECT COD','SHIP'),

(261,97,9,6,20,19941.8,0.06,0.06,'A','F','1993-10-15','1993-09-05','1993-11-07','NONE','AIR'),

(262,192,3,1,39,42595.41,0.01,0.05,'N','O','1996-01-15','1996-02-18','1996-01-28','COLLECT COD','RAIL'),

(262,61,6,2,33,31714.98,0.09,0.03,'N','O','1996-03-10','1996-01-31','1996-03-27','TAKE BACK RETURN','AIR'),

(262,59,1,3,35,33566.75,0.05,0.08,'N','O','1996-03-12','1996-02-14','1996-04-11','COLLECT COD','MAIL'),

(263,24,9,1,22,20328.44,0.06,0.08,'R','F','1994-08-24','1994-06-20','1994-09-09','NONE','FOB'),

(263,85,6,2,9,8865.72,0.08,0,'A','F','1994-07-21','1994-07-16','1994-08-08','TAKE BACK RETURN','TRUCK'),

(263,143,2,3,50,52157,0.06,0.04,'R','F','1994-08-18','1994-07-31','1994-08-22','NONE','TRUCK'),

(288,51,3,1,31,29482.55,0,0.03,'N','O','1997-03-17','1997-04-28','1997-04-06','TAKE BACK RETURN','AIR'),

(288,117,1,2,49,49838.39,0.08,0.05,'N','O','1997-04-19','1997-05-19','1997-05-18','TAKE BACK RETURN','TRUCK'),

(288,99,10,3,36,35967.24,0.02,0.02,'N','O','1997-02-22','1997-05-07','1997-03-07','TAKE BACK RETURN','TRUCK'),

(288,79,10,4,19,18602.33,0.07,0.07,'N','O','1997-03-14','1997-04-04','1997-03-26','NONE','MAIL'),

(288,162,9,5,31,32926.96,0.1,0.04,'N','O','1997-05-29','1997-04-24','1997-06-20','TAKE BACK RETURN','RAIL'),

(289,174,2,1,25,26854.25,0.07,0.05,'N','O','1997-03-18','1997-05-05','1997-04-15','DELIVER IN PERSON','FOB'),

(289,112,2,2,6,6072.66,0.06,0.05,'N','O','1997-02-18','1997-05-08','1997-03-19','DELIVER IN PERSON','SHIP'),

(289,17,4,3,44,40348.44,0.1,0.08,'N','O','1997-06-05','1997-04-20','1997-07-02','COLLECT COD','MAIL'),

(641,71,10,4,25,24276.75,0.03,0.02,'A','F','1993-12-04','1993-11-18','1993-12-18','TAKE BACK RETURN','FOB'),

(641,4,9,5,41,37064,0.07,0.04,'R','F','1993-11-29','1993-10-27','1993-12-04','TAKE BACK RETURN','FOB'),

(642,54,5,1,26,24805.3,0.1,0.03,'A','F','1994-04-16','1994-02-01','1994-04-27','COLLECT COD','REG AIR'),

(643,13,3,1,28,25564.28,0,0.08,'A','F','1995-04-13','1995-05-12','1995-04-14','TAKE BACK RETURN','TRUCK'),

(643,51,2,2,48,45650.4,0.01,0.02,'N','O','1995-07-10','1995-06-07','1995-08-01','NONE','FOB'),

(643,163,2,3,23,24452.68,0.05,0.03,'N','O','1995-07-09','1995-05-18','1995-07-31','COLLECT COD','RAIL'),

(643,45,4,4,39,36856.56,0.08,0.04,'A','F','1995-06-08','1995-06-16','1995-06-13','COLLECT COD','RAIL'),

(643,190,1,5,47,51238.93,0.1,0.03,'R','F','1995-04-05','1995-06-14','1995-04-26','DELIVER IN PERSON','RAIL'),

(644,134,10,1,46,47569.98,0.02,0.01,'A','F','1992-05-20','1992-06-14','1992-06-14','DELIVER IN PERSON','RAIL'),

(644,130,3,2,11,11331.43,0.05,0.02,'A','F','1992-08-20','1992-07-21','1992-09-11','TAKE BACK RETURN','TRUCK'),

(644,101,6,3,44,44048.4,0.04,0.04,'R','F','1992-08-17','1992-07-26','1992-08-20','COLLECT COD','REG AIR'),

(644,80,8,4,7,6860.56,0.01,0.02,'A','F','1992-05-18','1992-07-01','1992-06-07','COLLECT COD','RAIL'),

(644,50,1,5,23,21851.15,0.02,0.04,'R','F','1992-07-31','1992-07-28','1992-08-13','DELIVER IN PERSON','TRUCK'),

(644,85,6,6,33,32507.64,0,0.07,'R','F','1992-08-26','1992-07-27','1992-08-28','NONE','AIR'),

(644,51,9,7,38,36139.9,0.08,0.06,'R','F','1992-05-17','1992-07-10','1992-06-06','TAKE BACK RETURN','MAIL'),

(645,160,8,1,33,34985.28,0.01,0.02,'A','F','1994-12-09','1995-02-21','1995-01-03','NONE','TRUCK'),

(645,170,1,2,47,50297.99,0.07,0.05,'R','F','1995-02-16','1995-02-15','1995-02-25','COLLECT COD','TRUCK'),

(645,70,7,3,46,44623.22,0.1,0.01,'A','F','1995-01-04','1995-02-21','1995-01-21','COLLECT COD','REG AIR'),

(645,96,9,4,49,48808.41,0.05,0.03,'R','F','1995-01-24','1995-01-06','1995-02-17','NONE','TRUCK'),

(645,5,8,5,43,38915,0.06,0.02,'A','F','1995-02-12','1995-02-27','1995-03-06','TAKE BACK RETURN','REG AIR'),

(645,34,5,6,18,16812.54,0.1,0.08,'A','F','1995-03-02','1995-02-08','1995-03-03','COLLECT COD','RAIL'),

(645,28,9,7,9,8352.18,0.03,0.03,'A','F','1994-12-25','1995-01-04','1995-01-15','COLLECT COD','REG AIR'),

(646,109,6,1,31,31282.1,0,0.05,'R','F','1994-12-17','1995-02-16','1995-01-04','COLLECT COD','MAIL'),

(646,127,8,2,1,1027.12,0.07,0.01,'A','F','1994-12-05','1995-01-07','1994-12-31','TAKE BACK RETURN','MAIL'),

(646,30,9,3,24,22320.72,0.06,0.02,'A','F','1995-02-20','1994-12-30','1995-03-16','TAKE BACK RETURN','TRUCK'),

(646,99,2,4,34,33969.06,0.01,0,'R','F','1994-12-28','1994-12-27','1994-12-31','COLLECT COD','SHIP'),

(646,90,1,5,17,16831.53,0.04,0.01,'A','F','1994-12-31','1994-12-26','1995-01-01','DELIVER IN PERSON','REG AIR'),

(646,115,2,6,40,40604.4,0.1,0.01,'R','F','1995-01-01','1995-01-13','1995-01-11','COLLECT COD','TRUCK'),

(647,17,1,1,41,37597.41,0.08,0.08,'N','O','1997-11-19','1997-09-24','1997-12-15','COLLECT COD','REG AIR'),

(647,113,10,2,5,5065.55,0.1,0,'N','O','1997-09-25','1997-09-22','1997-10-25','TAKE BACK RETURN','AIR'),

(5956,55,7,2,23,21966.15,0.08,0.03,'N','O','1998-06-06','1998-07-10','1998-06-15','DELIVER IN PERSON','RAIL'),

(5956,175,5,3,47,50532.99,0.04,0.06,'N','O','1998-09-06','1998-06-29','1998-09-18','TAKE BACK RETURN','MAIL'),

(5956,20,10,4,40,36800.8,0.09,0.05,'N','O','1998-06-11','1998-07-19','1998-06-21','NONE','MAIL'),

(5957,15,9,1,37,33855.37,0.07,0,'A','F','1994-04-18','1994-02-19','1994-05-11','NONE','AIR'),

(5957,59,4,2,46,44116.3,0.04,0.08,'A','F','1994-01-23','1994-01-30','1994-02-07','NONE','SHIP'),

(5957,2,7,3,17,15334,0.01,0.01,'A','F','1994-01-24','1994-02-16','1994-02-08','TAKE BACK RETURN','SHIP'),

(5957,132,3,4,29,29931.77,0.01,0.03,'R','F','1994-02-24','1994-03-04','1994-03-08','COLLECT COD','REG AIR'),

(5957,88,9,5,40,39523.2,0.04,0.04,'R','F','1994-01-07','1994-02-05','1994-01-26','DELIVER IN PERSON','SHIP'),

(5957,6,1,6,41,37146,0.1,0.07,'R','F','1994-03-25','1994-02-20','1994-03-31','DELIVER IN PERSON','MAIL'),

(5957,159,1,7,32,33892.8,0.1,0.07,'A','F','1994-03-05','1994-02-20','1994-03-09','NONE','TRUCK'),

(5958,149,8,1,33,34621.62,0.02,0.04,'N','O','1995-09-24','1995-12-12','1995-10-05','COLLECT COD','MAIL'),

(5958,43,6,2,23,21689.92,0.03,0.04,'N','O','1995-09-26','1995-10-19','1995-09-27','COLLECT COD','SHIP'),

(5958,153,8,3,42,44232.3,0.1,0,'N','O','1995-12-12','1995-10-19','1996-01-09','NONE','AIR'),

(5958,39,10,4,18,16902.54,0.04,0.05,'N','O','1995-12-02','1995-10-17','1995-12-22','COLLECT COD','FOB'),

(5958,132,8,5,32,33028.16,0.06,0,'N','O','1995-09-20','1995-12-10','1995-10-14','COLLECT COD','REG AIR'),

(5959,135,1,1,49,50721.37,0.07,0.03,'R','F','1992-07-16','1992-08-09','1992-08-14','DELIVER IN PERSON','SHIP'),

(5959,147,8,2,17,17801.38,0.09,0.07,'R','F','1992-06-10','1992-07-06','1992-06-23','COLLECT COD','MAIL'),

(5959,5,6,3,4,3620,0.04,0.03,'R','F','1992-06-14','1992-07-05','1992-07-01','NONE','MAIL'),

(5959,196,7,4,13,14250.47,0.03,0,'A','F','1992-07-29','1992-07-13','1992-08-20','COLLECT COD','SHIP'),

(5959,40,6,5,37,34781.48,0.04,0.01,'R','F','1992-06-05','1992-07-18','1992-06-29','NONE','TRUCK'),

(5959,119,3,6,35,35668.85,0.03,0,'A','F','1992-05-27','1992-06-19','1992-06-23','NONE','TRUCK'),

(5959,43,10,7,47,44322.88,0.02,0.01,'R','F','1992-08-28','1992-07-24','1992-09-09','TAKE BACK RETURN','RAIL'),

(5984,70,5,1,13,12610.91,0.06,0.07,'R','F','1994-10-16','1994-09-06','1994-11-11','NONE','MAIL'),

(5984,102,3,2,25,25052.5,0.05,0.08,'R','F','1994-10-06','1994-07-21','1994-10-28','COLLECT COD','RAIL'),

(5984,1,4,3,8,7208,0.1,0,'R','F','1994-09-17','1994-08-28','1994-09-25','COLLECT COD','RAIL'),

(5984,190,1,4,35,38156.65,0,0.01,'A','F','1994-08-25','1994-08-05','1994-08-31','DELIVER IN PERSON','SHIP'),

(5985,86,7,1,4,3944.32,0.02,0.02,'A','F','1995-05-04','1995-04-01','1995-05-17','DELIVER IN PERSON','MAIL'),

(5986,79,7,1,26,25455.82,0,0,'R','F','1992-08-10','1992-05-23','1992-08-24','TAKE BACK RETURN','SHIP'),

(5986,196,8,2,25,27404.75,0.03,0.06,'A','F','1992-06-16','1992-07-17','1992-06-29','TAKE BACK RETURN','MAIL'),

(5986,30,5,3,1,930.03,0.07,0.06,'A','F','1992-05-21','1992-06-21','1992-05-24','DELIVER IN PERSON','REG AIR');

ANALYZE TABLE lineitem PERSISTENT FOR ALL;

SET optimizer_switch = 'index_merge_sort_intersection=on';

SELECT * FROM lineitem WHERE l_receiptDATE = '1992-08-20' AND (l_partkey = 119 OR l_partkey = 132 AND l_suppkey = 7);

==3046613==WARNING: MemorySanitizer: use-of-uninitialized-value

    #0 0x56224f9332b0 in key_cmp(st_key_part_info*, unsigned char const*, unsigned int) /data/bld/11.0-msan/sql/key.cc:511:16

    #1 0x56224f4141ad in handler::compare_key(st_key_range*) /data/bld/11.0-msan/sql/handler.cc:6930:8

    #2 0x56224f4141ad in handler::read_range_first(st_key_range const*, st_key_range const*, bool, bool) /data/bld/11.0-msan/sql/handler.cc:6835:7

    #3 0x56224edc99ea in handler::multi_range_read_next(void**) /data/bld/11.0-msan/sql/multi_range_read.cc:590:15

    #4 0x56224edca078 in Mrr_simple_index_reader::get_next(void**) /data/bld/11.0-msan/sql/multi_range_read.cc:627:32

    #5 0x56224edd57c2 in DsMrr_impl::dsmrr_next(void**) /data/bld/11.0-msan/sql/multi_range_read.cc:1727:26

    #6 0x56224e111cc6 in QUICK_RANGE_SELECT::get_next() /data/bld/11.0-msan/sql/opt_range.cc:13188:5

    #7 0x56224e10c2bb in read_keys_and_merge_scans(THD*, TABLE*, List<QUICK_RANGE_SELECT>, QUICK_RANGE_SELECT*, READ_RECORD*, bool, Bitmap<64u>*, Unique**) /data/bld/11.0-msan/sql/opt_range.cc:12736:32

    #8 0x56224e10ea40 in QUICK_INDEX_INTERSECT_SELECT::read_keys_and_merge() /data/bld/11.0-msan/sql/opt_range.cc:12853:11

    #9 0x56224e07e7b4 in QUICK_INDEX_SORT_SELECT::reset() /data/bld/11.0-msan/sql/opt_range.cc:1404:21

    #10 0x56224e7eb628 in join_init_read_record(st_join_table*) /data/bld/11.0-msan/sql/sql_select.cc:24512:64

    #11 0x56224e74fa1a in sub_select(JOIN*, st_join_table*, bool) /data/bld/11.0-msan/sql/sql_select.cc:23499:12

    #12 0x56224e7f78ba in do_select(JOIN*, Procedure*) /data/bld/11.0-msan/sql/sql_select.cc:23013:14

    #13 0x56224e7f78ba in JOIN::exec_inner() /data/bld/11.0-msan/sql/sql_select.cc:4955:50

    #14 0x56224e7f260d in JOIN::exec() /data/bld/11.0-msan/sql/sql_select.cc:4732:8

    #15 0x56224e752dad in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /data/bld/11.0-msan/sql/sql_select.cc:5213:21

    #16 0x56224e751af6 in handle_select(THD*, LEX*, select_result*, unsigned long long) /data/bld/11.0-msan/sql/sql_select.cc:628:10

    #17 0x56224e62522d in execute_sqlcom_select(THD*, TABLE_LIST*) /data/bld/11.0-msan/sql/sql_parse.cc:6290:12

    #18 0x56224e5feabc in mysql_execute_command(THD*, bool) /data/bld/11.0-msan/sql/sql_parse.cc:3961:12

    #19 0x56224e5e637a in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/bld/11.0-msan/sql/sql_parse.cc:8028:18

    #20 0x56224e5da87f in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/bld/11.0-msan/sql/sql_parse.cc:1894:7

    #21 0x56224e5e8770 in do_command(THD*, bool) /data/bld/11.0-msan/sql/sql_parse.cc:1407:17

    #22 0x56224ecafaff in do_handle_one_connection(CONNECT*, bool) /data/bld/11.0-msan/sql/sql_connect.cc:1416:11

    #23 0x56224ecaf0d5 in handle_one_connection /data/bld/11.0-msan/sql/sql_connect.cc:1318:5

    #24 0x56225005275a in pfs_spawn_thread /data/bld/11.0-msan/storage/perfschema/pfs.cc:2201:3

    #25 0x7f6e4dce8043 in start_thread nptl/./nptl/pthread_create.c:442:8

    #26 0x7f6e4dd6861b in clone3 misc/../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

  Uninitialized value was stored to memory at

    #0 0x56224dfa9d69 in __msan_memcpy (/mnt8t/bld/11.0-msan/sql/mariadbd+0x7a4d69)

    #1 0x5622509c070a in row_sel_dequeue_cached_row_for_mysql(unsigned char*, row_prebuilt_t*) /data/bld/11.0-msan/storage/innobase/row/row0sel.cc:3844:3

  Uninitialized value was stored to memory at

    #0 0x56224dfa9d69 in __msan_memcpy (/mnt8t/bld/11.0-msan/sql/mariadbd+0x7a4d69)

    #1 0x5622509b724e in row_sel_enqueue_cache_row_for_mysql(unsigned char*, row_prebuilt_t*) /data/bld/11.0-msan/storage/innobase/row/row0sel.cc:3927:3

    #2 0x5622509b724e in row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) /data/bld/11.0-msan/storage/innobase/row/row0sel.cc:5673:4

  Uninitialized value was stored to memory at

    #0 0x56224dfa9d69 in __msan_memcpy (/mnt8t/bld/11.0-msan/sql/mariadbd+0x7a4d69)

    #1 0x5622509c070a in row_sel_dequeue_cached_row_for_mysql(unsigned char*, row_prebuilt_t*) /data/bld/11.0-msan/storage/innobase/row/row0sel.cc:3844:3

  Uninitialized value was stored to memory at

    #0 0x5622509e51cc in row_sel_store_mysql_field(unsigned char*, row_prebuilt_t*, unsigned char const*, dict_index_t const*, unsigned short const*, unsigned long, mysql_row_templ_t const*) /data/bld/11.0-msan/storage/innobase/row/row0sel.cc:3103:4

  Memory was marked as uninitialized

    #0 0x56224dfb050e in __msan_allocated_memory (/mnt8t/bld/11.0-msan/sql/mariadbd+0x7ab50e)

    #1 0x56225099d81e in row_sel_field_store_in_mysql_format_func(unsigned char*, mysql_row_templ_t const*, dict_index_t const*, unsigned long, unsigned char const*, unsigned long) /data/bld/11.0-msan/storage/innobase/row/row0sel.cc:2801:2

SUMMARY: MemorySanitizer: use-of-uninitialized-value /data/bld/11.0-msan/sql/key.cc:511:16 in key_cmp(st_key_part_info*, unsigned char const*, unsigned int)

Exiting