Debian Codegraph @

mysql-test/suite/ndb/t/ndb_api_buffer.test

raw
1 --source include/have_ndb.inc
2
3 --disable_query_log
4 set @old_ecpd = @@session.optimizer_switch;
5 set @@optimizer_switch = 'engine_condition_pushdown=off';
6 --enable_query_log
7
8 #
9 # Bug#30183466 MEMORY CORRUPTION ON QUERY
10 # Adapted test case from bug, added BLOB to get more complex scan
11 #
12
13 CREATE TABLE t1 (
14 a varchar(23) DEFAULT NULL,
15 b date DEFAULT NULL,
16 c varchar(45) DEFAULT NULL,
17 d varchar(1) DEFAULT NULL,
18 e varchar(4) DEFAULT NULL,
19 f varchar(2) DEFAULT NULL,
20 g varchar(6) DEFAULT NULL,
21 h varchar(1) DEFAULT NULL,
22 i varchar(5) DEFAULT NULL,
23 j varchar(5) DEFAULT NULL,
24 k varchar(5) DEFAULT NULL,
25 l datetime DEFAULT NULL,
26 m decimal(14,2) DEFAULT NULL,
27 n varchar(3) DEFAULT NULL,
28 o varchar(2) DEFAULT NULL,
29 p varchar(2) DEFAULT NULL,
30 q varchar(45) DEFAULT NULL,
31 r double DEFAULT NULL,
32 s varchar(3) DEFAULT NULL,
33 t varchar(2) DEFAULT NULL,
34 u varchar(1) DEFAULT NULL,
35 v varchar(1) DEFAULT NULL,
36 w varchar(1) DEFAULT NULL,
37 x varchar(45) DEFAULT NULL,
38 y varchar(1) DEFAULT 'n',
39 z varchar(1) DEFAULT 'n',
40 aa text DEFAULT NULL
41 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
42
43 INSERT INTO t1 VALUES ('1576682624',NULL,'1605487520','1','1552','16','158982','1','15387','15886','16188','2018-09-26 18:51:39',999999999999.99,'162','15','16','1634444551',999999999999.99,'163','15','1','1','1','1634408207','1','1','1609381753');
44 INSERT INTO t1 VALUES ('1588012034',NULL,'1631681072','1','1592','15','161613','1','15712','15925','15876','2020-06-04 09:59:53',999999999999.99,'159','16','16','1613000167',999999999999.99,'157','15','1','1','1','1578495351','1','1','1632299098');
45 INSERT INTO t1 VALUES ('1545050436',NULL,'1555775455','1','1636','15','157774','1','15629','15637','15761','2019-05-17 06:40:54',999999999999.99,'155','16','16','1624240510',999999999999.99,'159','16','1','1','1','1634504635','1','1','1620621098');
46 INSERT INTO t1 VALUES ('1623391295',NULL,'1605809461','1','1551','15','160075','1','15712','16122','16077','2019-07-12 16:56:23',999999999999.99,'158','16','15','1549448828',999999999999.99,'162','16','1','1','1','1547226527','1','1','1570671920');
47 INSERT INTO t1 VALUES ('1572358159',NULL,'1624820345','1','1591','15','160227','1','15629','16287','16211','2021-01-14 05:37:15',999999999999.99,'160','15','16','1566580028',999999999999.99,'154','15','1','1','1','1561251913','1','1','1607139174');
48 INSERT INTO t1 VALUES ('1626748560',NULL,'1591348995','1','1545','16','157676','1','15512','16023','16240','2019-02-12 17:00:49',999999999999.99,'159','16','15','1546032718',999999999999.99,'157','16','1','1','1','1595606221','1','1','1580319284');
49 INSERT INTO t1 VALUES ('1541916013',NULL,'1551562744','1','1583','15','158162','1','15771','16250','16359','2019-10-01 02:29:25',999999999999.99,'162','15','15','1633290825',999999999999.99,'157','15','1','1','1','1544366994','1','1','1602585185');
50 INSERT INTO t1 VALUES ('1608664255',NULL,'1629728295','1','1579','16','159590','1','16033','16060','15553','2019-05-04 05:24:28',999999999999.99,'155','16','15','1630993560',999999999999.99,'153','15','1','1','1','1597099327','1','1','1562961424');
51 INSERT INTO t1 VALUES ('1627753795',NULL,'1568465944','1','1626','15','161294','1','16271','16056','16214','2019-09-11 08:32:47',999999999999.99,'162','16','15','1545705098',999999999999.99,'155','15','1','1','1','1616701391','1','1','1616121442');
52 INSERT INTO t1 VALUES ('1591858288',NULL,'1600675688','1','1553','15','157144','1','15583','16068','15374','2020-08-11 21:28:03',999999999999.99,'157','16','16','1543201335',999999999999.99,'159','15','1','1','1','1589080452','1','1','1551860650');
53 INSERT INTO t1 VALUES ('1552164153',NULL,'1587168936','1','1560','16','157789','1','15527','15888','15921','2020-02-10 19:13:04',999999999999.99,'159','15','15','1636976369',999999999999.99,'158','15','1','1','1','1605677653','1','1','1604766328');
54 INSERT INTO t1 VALUES ('1591853616',NULL,'1556868887','1','1567','15','155055','1','15524','15529','15689','2020-07-25 14:21:13',999999999999.99,'163','16','16','1546080344',999999999999.99,'154','15','1','1','1','1560717904','1','1','1545381424');
55 INSERT INTO t1 VALUES ('1572490568',NULL,'1579492363','1','1616','15','158941','1','15675','15931','15835','2020-04-01 05:17:20',999999999999.99,'156','15','16','1571718239',999999999999.99,'161','15','1','1','1','1611355319','1','1','1619853886');
56 INSERT INTO t1 VALUES ('1549477484',NULL,'1576023563','1','1583','15','155636','1','15881','15783','15475','2020-10-25 13:06:17',999999999999.99,'157','15','16','1615556384',999999999999.99,'162','16','1','1','1','1573332458','1','1','1604352720');
57 INSERT INTO t1 VALUES ('1595085244',NULL,'1609431821','1','1573','16','160661','1','15969','16322','16101','2021-06-11 01:52:17',999999999999.99,'161','15','15','1552042114',999999999999.99,'163','15','1','1','1','1617207540','1','1','1619360186');
58 INSERT INTO t1 VALUES ('1604261310',NULL,'1583169318','1','1575','15','163669','1','16106','15571','15855','2020-01-21 23:21:25',999999999999.99,'163','16','15','1588320762',999999999999.99,'160','16','1','1','1','1597178009','1','1','1571268082');
59 INSERT INTO t1 VALUES ('1597960364',NULL,'1583334202','1','1550','15','162010','1','15692','16233','16332','2021-06-07 14:43:45',999999999999.99,'161','15','15','1550352495',999999999999.99,'159','15','1','1','1','1604285562','1','1','1555230368');
60 INSERT INTO t1 VALUES ('1558773294',NULL,'1614709883','1','1618','16','160929','1','15601','16099','16240','2019-07-15 05:00:30',999999999999.99,'154','16','15','1537264477',999999999999.99,'157','15','1','1','1','1626591137','1','1','1633834789');
61 INSERT INTO t1 VALUES ('1572661330',NULL,'1586569823','1','1615','15','161263','1','15960','15599','15511','2019-04-30 11:10:24',999999999999.99,'158','15','15','1611959856',999999999999.99,'159','15','1','1','1','1539710903','1','1','1620553626');
62 INSERT INTO t1 VALUES ('1546435566',NULL,'1573679027','1','1543','15','158902','1','16319','16127','16197','2018-10-18 04:25:08',999999999999.99,'156','16','16','1603877285',999999999999.99,'161','16','1','1','1','1598859595','1','1','1603584514');
63 INSERT INTO t1 VALUES ('1540713372',NULL,'1588309694','1','1546','15','155283','1','15918','15556','15869','2021-08-29 06:16:01',999999999999.99,'159','15','15','1561483774',999999999999.99,'162','15','1','1','1','1596180641','1','1','1596408561');
64 INSERT INTO t1 VALUES ('1573877545',NULL,'1587934623','1','1541','15','162172','1','15387','16021','15432','2019-01-03 12:15:24',999999999999.99,'155','15','15','1571522789',999999999999.99,'153','15','1','1','1','1620494484','1','1','1634413006');
65 INSERT INTO t1 VALUES ('1597153106',NULL,'1630690660','1','1611','16','159254','1','16167','16170','15858','2020-07-16 09:26:36',999999999999.99,'155','16','16','1613613803',999999999999.99,'157','15','1','1','1','1577390762','1','1','1555115269');
66 INSERT INTO t1 VALUES ('1628340742',NULL,'1614893277','1','1595','16','156242','1','15842','16147','15708','2020-05-11 04:28:23',999999999999.99,'160','15','16','1621142854',999999999999.99,'161','15','1','1','1','1615281274','1','1','1607840229');
67 INSERT INTO t1 VALUES ('1556140176',NULL,'1630081457','1','1611','15','158566','1','15951','16172','15928','2019-04-01 14:06:58',999999999999.99,'158','15','15','1619392668',999999999999.99,'161','15','1','1','1','1606374836','1','1','1613351423');
68 INSERT INTO t1 VALUES ('1590237501',NULL,'1546813874','1','1543','15','157180','1','15404','16291','15528','2020-02-13 19:10:17',999999999999.99,'160','15','15','1621077446',999999999999.99,'160','15','1','1','1','1602884630','1','1','1617235512');
69 INSERT INTO t1 VALUES ('1607766930',NULL,'1590988272','1','1542','15','154103','1','16245','16238','16198','2019-08-01 07:46:05',999999999999.99,'163','15','15','1599527504',999999999999.99,'161','16','1','1','1','1606293708','1','1','1601264461');
70 INSERT INTO t1 VALUES ('1598165454',NULL,'1627779458','1','1580','15','155911','1','16289','16006','16028','2020-11-16 14:14:21',999999999999.99,'156','15','16','1627994462',999999999999.99,'153','16','1','1','1','1597165928','1','1','1557398062');
71 INSERT INTO t1 VALUES ('1635496169',NULL,'1592716572','1','1569','15','153752','1','16073','16248','15589','2020-08-15 03:35:46',999999999999.99,'157','16','16','1546570219',999999999999.99,'156','15','1','1','1','1565016108','1','1','1549190519');
72 INSERT INTO t1 VALUES ('1567919142',NULL,'1599996110','1','1576','15','155621','1','15528','15382','16052','2021-05-30 14:23:28',999999999999.99,'160','15','15','1546922458',999999999999.99,'163','15','1','1','1','1543188940','1','1','1556527832');
73 INSERT INTO t1 VALUES ('1633302311',NULL,'1622840287','1','1545','15','155307','1','15889','15620','16360','2021-04-25 06:00:28',999999999999.99,'159','15','16','1611035057',999999999999.99,'155','16','1','1','1','1612914215','1','1','1584028179');
74 INSERT INTO t1 VALUES ('1623732159',NULL,'1581493955','1','1621','16','161581','1','16248','16030','16064','2019-07-04 07:01:37',999999999999.99,'163','15','15','1596719195',999999999999.99,'155','15','1','1','1','1617233025','1','1','1580509356');
75
76 # Add row to fulfill nonsensical query from bug test case
77 INSERT INTO t1 VALUES ('1623732159','2019-08-12 00:00:00','1581493955','1','1621','16','161581','1',NULL,'16030','16064','2019-07-04 07:01:37',999999999999.99,'163','15','cr','1596719195',999999999999.99,'155','15','1','1','1','1617233025','1','1','158050935600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000');
78
79 # Fill table enough to use whole scan batch
80 INSERT INTO t1 SELECT * FROM t1;
81 INSERT INTO t1 SELECT * FROM t1;
82 INSERT INTO t1 SELECT * FROM t1;
83 INSERT INTO t1 SELECT * FROM t1;
84 INSERT INTO t1 SELECT * FROM t1;
85 INSERT INTO t1 SELECT * FROM t1;
86
87 select i,r,s,b,p from t1 order by a,p;
88
89 select trxitems0_.i as col_0_0_, sum(trxitems0_.r) as col_1_0_, trxitems0_.s as col_2_0_
90 from t1 trxitems0_
91 where (trxitems0_.b between '2019-08-12 00:00:00' and '2019-08-12 00:00:00'
92 or '2019-08-12 00:00:00' is null
93 or '2019-08-12 00:00:00' is null
94 ) and trim(upper(trxitems0_.p))='cr'
95 and (trim(upper(trxitems0_.i))=null or null is null)
96 group by trxitems0_.i , trxitems0_.s
97 limit 1000;
98
99 drop table t1;
100
101 --disable_query_log
102 set @@session.optimizer_switch = @old_ecpd;
103 --enable_query_log