| 1 |
-- source include/have_ndb.inc |
| 2 |
|
| 3 |
--disable_warnings |
| 4 |
DROP TABLE IF EXISTS t1; |
| 5 |
--enable_warnings |
| 6 |
|
| 7 |
# |
| 8 |
# Basic test of INSERT in NDB |
| 9 |
# |
| 10 |
|
| 11 |
# |
| 12 |
# Create a normal table with primary key |
| 13 |
# |
| 14 |
CREATE TABLE t1 ( |
| 15 |
pk1 INT NOT NULL PRIMARY KEY, |
| 16 |
b INT NOT NULL, |
| 17 |
c INT NOT NULL |
| 18 |
) ENGINE=ndbcluster; |
| 19 |
|
| 20 |
# |
| 21 |
# Bug 31320: Ensure statement error leads to transaction rollback |
| 22 |
# |
| 23 |
INSERT INTO t1 VALUES (0, 0, 0); |
| 24 |
BEGIN; |
| 25 |
INSERT INTO t1 VALUES (1, 1, 1); |
| 26 |
--error 1022 |
| 27 |
INSERT INTO t1 VALUES (0, 0, 0),(2,2,2); |
| 28 |
# already rolled back |
| 29 |
SELECT COUNT(*) FROM t1; |
| 30 |
COMMIT; |
| 31 |
DELETE FROM t1; |
| 32 |
|
| 33 |
INSERT INTO t1 VALUES (0, 0, 0); |
| 34 |
SELECT * FROM t1; |
| 35 |
|
| 36 |
INSERT INTO t1 VALUES |
| 37 |
(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5), |
| 38 |
(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10), |
| 39 |
(11,11,11),(12,12,12),(13,13,13),(14,14,14),(15,15,15), |
| 40 |
(16,16,16),(17,17,17),(18,18,18),(19,19,19),(20,20,20), |
| 41 |
(21,21,21),(22,22,22),(23,23,23),(24,24,24),(25,25,25), |
| 42 |
(26,26,26),(27,27,27),(28,28,28),(29,29,29),(30,30,30), |
| 43 |
(31,31,31),(32,32,32),(33,33,33),(34,34,34),(35,35,35), |
| 44 |
(36,36,36),(37,37,37),(38,38,38),(39,39,39),(40,40,40), |
| 45 |
(41,41,41),(42,42,42),(43,43,43),(44,44,44),(45,45,45), |
| 46 |
(46,46,46),(47,47,47),(48,48,48),(49,49,49),(50,50,50), |
| 47 |
(51,51,51),(52,52,52),(53,53,53),(54,54,54),(55,55,55), |
| 48 |
(56,56,56),(57,57,57),(58,58,58),(59,59,59),(60,60,60), |
| 49 |
(61,61,61),(62,62,62),(63,63,63),(64,64,64),(65,65,65), |
| 50 |
(66,66,66),(67,67,67),(68,68,68),(69,69,69),(70,70,70), |
| 51 |
(71,71,71),(72,72,72),(73,73,73),(74,74,74),(75,75,75), |
| 52 |
(76,76,76),(77,77,77),(78,78,78),(79,79,79),(80,80,80), |
| 53 |
(81,81,81),(82,82,82),(83,83,83),(84,84,84),(85,85,85), |
| 54 |
(86,86,86),(87,87,87),(88,88,88),(89,89,89),(90,90,90), |
| 55 |
(91,91,91),(92,92,92),(93,93,93),(94,94,94),(95,95,95), |
| 56 |
(96,96,96),(97,97,97),(98,98,98),(99,99,99),(100,100,100), |
| 57 |
(101,101,101),(102,102,102),(103,103,103),(104,104,104),(105,105,105), |
| 58 |
(106,106,106),(107,107,107),(108,108,108),(109,109,109),(110,110,110), |
| 59 |
(111,111,111),(112,112,112),(113,113,113),(114,114,114),(115,115,115), |
| 60 |
(116,116,116),(117,117,117),(118,118,118),(119,119,119),(120,120,120), |
| 61 |
(121,121,121),(122,122,122),(123,123,123),(124,124,124),(125,125,125), |
| 62 |
(126,126,126),(127,127,127),(128,128,128),(129,129,129),(130,130,130), |
| 63 |
(131,131,131),(132,132,132),(133,133,133),(134,134,134),(135,135,135), |
| 64 |
(136,136,136),(137,137,137),(138,138,138),(139,139,139),(140,140,140), |
| 65 |
(141,141,141),(142,142,142),(143,143,143),(144,144,144),(145,145,145), |
| 66 |
(146,146,146),(147,147,147),(148,148,148),(149,149,149),(150,150,150), |
| 67 |
(151,151,151),(152,152,152),(153,153,153),(154,154,154),(155,155,155), |
| 68 |
(156,156,156),(157,157,157),(158,158,158),(159,159,159),(160,160,160), |
| 69 |
(161,161,161),(162,162,162),(163,163,163),(164,164,164),(165,165,165), |
| 70 |
(166,166,166),(167,167,167),(168,168,168),(169,169,169),(170,170,170), |
| 71 |
(171,171,171),(172,172,172),(173,173,173),(174,174,174),(175,175,175), |
| 72 |
(176,176,176),(177,177,177),(178,178,178),(179,179,179),(180,180,180), |
| 73 |
(181,181,181),(182,182,182),(183,183,183),(184,184,184),(185,185,185), |
| 74 |
(186,186,186),(187,187,187),(188,188,188),(189,189,189),(190,190,190), |
| 75 |
(191,191,191),(192,192,192),(193,193,193),(194,194,194),(195,195,195), |
| 76 |
(196,196,196),(197,197,197),(198,198,198),(199,199,199),(200,200,200), |
| 77 |
(201,201,201),(202,202,202),(203,203,203),(204,204,204),(205,205,205), |
| 78 |
(206,206,206),(207,207,207),(208,208,208),(209,209,209),(210,210,210), |
| 79 |
(211,211,211),(212,212,212),(213,213,213),(214,214,214),(215,215,215), |
| 80 |
(216,216,216),(217,217,217),(218,218,218),(219,219,219),(220,220,220), |
| 81 |
(221,221,221),(222,222,222),(223,223,223),(224,224,224),(225,225,225), |
| 82 |
(226,226,226),(227,227,227),(228,228,228),(229,229,229),(230,230,230), |
| 83 |
(231,231,231),(232,232,232),(233,233,233),(234,234,234),(235,235,235), |
| 84 |
(236,236,236),(237,237,237),(238,238,238),(239,239,239),(240,240,240), |
| 85 |
(241,241,241),(242,242,242),(243,243,243),(244,244,244),(245,245,245), |
| 86 |
(246,246,246),(247,247,247),(248,248,248),(249,249,249),(250,250,250), |
| 87 |
(251,251,251),(252,252,252),(253,253,253),(254,254,254),(255,255,255), |
| 88 |
(256,256,256),(257,257,257),(258,258,258),(259,259,259),(260,260,260), |
| 89 |
(261,261,261),(262,262,262),(263,263,263),(264,264,264),(265,265,265), |
| 90 |
(266,266,266),(267,267,267),(268,268,268),(269,269,269),(270,270,270), |
| 91 |
(271,271,271),(272,272,272),(273,273,273),(274,274,274),(275,275,275), |
| 92 |
(276,276,276),(277,277,277),(278,278,278),(279,279,279),(280,280,280), |
| 93 |
(281,281,281),(282,282,282),(283,283,283),(284,284,284),(285,285,285), |
| 94 |
(286,286,286),(287,287,287),(288,288,288),(289,289,289),(290,290,290), |
| 95 |
(291,291,291),(292,292,292),(293,293,293),(294,294,294),(295,295,295), |
| 96 |
(296,296,296),(297,297,297),(298,298,298),(299,299,299),(300,300,300), |
| 97 |
(301,301,301),(302,302,302),(303,303,303),(304,304,304),(305,305,305), |
| 98 |
(306,306,306),(307,307,307),(308,308,308),(309,309,309),(310,310,310), |
| 99 |
(311,311,311),(312,312,312),(313,313,313),(314,314,314),(315,315,315), |
| 100 |
(316,316,316),(317,317,317),(318,318,318),(319,319,319),(320,320,320), |
| 101 |
(321,321,321),(322,322,322),(323,323,323),(324,324,324),(325,325,325), |
| 102 |
(326,326,326),(327,327,327),(328,328,328),(329,329,329),(330,330,330), |
| 103 |
(331,331,331),(332,332,332),(333,333,333),(334,334,334),(335,335,335), |
| 104 |
(336,336,336),(337,337,337),(338,338,338),(339,339,339),(340,340,340), |
| 105 |
(341,341,341),(342,342,342),(343,343,343),(344,344,344),(345,345,345), |
| 106 |
(346,346,346),(347,347,347),(348,348,348),(349,349,349),(350,350,350), |
| 107 |
(351,351,351),(352,352,352),(353,353,353),(354,354,354),(355,355,355), |
| 108 |
(356,356,356),(357,357,357),(358,358,358),(359,359,359),(360,360,360), |
| 109 |
(361,361,361),(362,362,362),(363,363,363),(364,364,364),(365,365,365), |
| 110 |
(366,366,366),(367,367,367),(368,368,368),(369,369,369),(370,370,370), |
| 111 |
(371,371,371),(372,372,372),(373,373,373),(374,374,374),(375,375,375), |
| 112 |
(376,376,376),(377,377,377),(378,378,378),(379,379,379),(380,380,380), |
| 113 |
(381,381,381),(382,382,382),(383,383,383),(384,384,384),(385,385,385), |
| 114 |
(386,386,386),(387,387,387),(388,388,388),(389,389,389),(390,390,390), |
| 115 |
(391,391,391),(392,392,392),(393,393,393),(394,394,394),(395,395,395), |
| 116 |
(396,396,396),(397,397,397),(398,398,398),(399,399,399),(400,400,400), |
| 117 |
(401,401,401),(402,402,402),(403,403,403),(404,404,404),(405,405,405), |
| 118 |
(406,406,406),(407,407,407),(408,408,408),(409,409,409),(410,410,410), |
| 119 |
(411,411,411),(412,412,412),(413,413,413),(414,414,414),(415,415,415), |
| 120 |
(416,416,416),(417,417,417),(418,418,418),(419,419,419),(420,420,420), |
| 121 |
(421,421,421),(422,422,422),(423,423,423),(424,424,424),(425,425,425), |
| 122 |
(426,426,426),(427,427,427),(428,428,428),(429,429,429),(430,430,430), |
| 123 |
(431,431,431),(432,432,432),(433,433,433),(434,434,434),(435,435,435), |
| 124 |
(436,436,436),(437,437,437),(438,438,438),(439,439,439),(440,440,440), |
| 125 |
(441,441,441),(442,442,442),(443,443,443),(444,444,444),(445,445,445), |
| 126 |
(446,446,446),(447,447,447),(448,448,448),(449,449,449),(450,450,450), |
| 127 |
(451,451,451),(452,452,452),(453,453,453),(454,454,454),(455,455,455), |
| 128 |
(456,456,456),(457,457,457),(458,458,458),(459,459,459),(460,460,460), |
| 129 |
(461,461,461),(462,462,462),(463,463,463),(464,464,464),(465,465,465), |
| 130 |
(466,466,466),(467,467,467),(468,468,468),(469,469,469),(470,470,470), |
| 131 |
(471,471,471),(472,472,472),(473,473,473),(474,474,474),(475,475,475), |
| 132 |
(476,476,476),(477,477,477),(478,478,478),(479,479,479),(480,480,480), |
| 133 |
(481,481,481),(482,482,482),(483,483,483),(484,484,484),(485,485,485), |
| 134 |
(486,486,486),(487,487,487),(488,488,488),(489,489,489),(490,490,490), |
| 135 |
(491,491,491),(492,492,492),(493,493,493),(494,494,494),(495,495,495), |
| 136 |
(496,496,496),(497,497,497),(498,498,498),(499,499,499),(500, 500, 500); |
| 137 |
|
| 138 |
SELECT COUNT(*) FROM t1; |
| 139 |
|
| 140 |
INSERT INTO t1 VALUES |
| 141 |
(501,501,501),(502,502,502),(503,503,503),(504,504,504),(505,505,505), |
| 142 |
(506,506,506),(507,507,507),(508,508,508),(509,509,509),(510,510,510), |
| 143 |
(511,511,511),(512,512,512),(513,513,513),(514,514,514),(515,515,515), |
| 144 |
(516,516,516),(517,517,517),(518,518,518),(519,519,519),(520,520,520), |
| 145 |
(521,521,521),(522,522,522),(523,523,523),(524,524,524),(525,525,525), |
| 146 |
(526,526,526),(527,527,527),(528,528,528),(529,529,529),(530,530,530), |
| 147 |
(531,531,531),(532,532,532),(533,533,533),(534,534,534),(535,535,535), |
| 148 |
(536,536,536),(537,537,537),(538,538,538),(539,539,539),(540,540,540), |
| 149 |
(541,541,541),(542,542,542),(543,543,543),(544,544,544),(545,545,545), |
| 150 |
(546,546,546),(547,547,547),(548,548,548),(549,549,549),(550,550,550), |
| 151 |
(551,551,551),(552,552,552),(553,553,553),(554,554,554),(555,555,555), |
| 152 |
(556,556,556),(557,557,557),(558,558,558),(559,559,559),(560,560,560), |
| 153 |
(561,561,561),(562,562,562),(563,563,563),(564,564,564),(565,565,565), |
| 154 |
(566,566,566),(567,567,567),(568,568,568),(569,569,569),(570,570,570), |
| 155 |
(571,571,571),(572,572,572),(573,573,573),(574,574,574),(575,575,575), |
| 156 |
(576,576,576),(577,577,577),(578,578,578),(579,579,579),(580,580,580), |
| 157 |
(581,581,581),(582,582,582),(583,583,583),(584,584,584),(585,585,585), |
| 158 |
(586,586,586),(587,587,587),(588,588,588),(589,589,589),(590,590,590), |
| 159 |
(591,591,591),(592,592,592),(593,593,593),(594,594,594),(595,595,595), |
| 160 |
(596,596,596),(597,597,597),(598,598,598),(599,599,599),(600,600,600), |
| 161 |
(601,601,601),(602,602,602),(603,603,603),(604,604,604),(605,605,605), |
| 162 |
(606,606,606),(607,607,607),(608,608,608),(609,609,609),(610,610,610), |
| 163 |
(611,611,611),(612,612,612),(613,613,613),(614,614,614),(615,615,615), |
| 164 |
(616,616,616),(617,617,617),(618,618,618),(619,619,619),(620,620,620), |
| 165 |
(621,621,621),(622,622,622),(623,623,623),(624,624,624),(625,625,625), |
| 166 |
(626,626,626),(627,627,627),(628,628,628),(629,629,629),(630,630,630), |
| 167 |
(631,631,631),(632,632,632),(633,633,633),(634,634,634),(635,635,635), |
| 168 |
(636,636,636),(637,637,637),(638,638,638),(639,639,639),(640,640,640), |
| 169 |
(641,641,641),(642,642,642),(643,643,643),(644,644,644),(645,645,645), |
| 170 |
(646,646,646),(647,647,647),(648,648,648),(649,649,649),(650,650,650), |
| 171 |
(651,651,651),(652,652,652),(653,653,653),(654,654,654),(655,655,655), |
| 172 |
(656,656,656),(657,657,657),(658,658,658),(659,659,659),(660,660,660), |
| 173 |
(661,661,661),(662,662,662),(663,663,663),(664,664,664),(665,665,665), |
| 174 |
(666,666,666),(667,667,667),(668,668,668),(669,669,669),(670,670,670), |
| 175 |
(671,671,671),(672,672,672),(673,673,673),(674,674,674),(675,675,675), |
| 176 |
(676,676,676),(677,677,677),(678,678,678),(679,679,679),(680,680,680), |
| 177 |
(681,681,681),(682,682,682),(683,683,683),(684,684,684),(685,685,685), |
| 178 |
(686,686,686),(687,687,687),(688,688,688),(689,689,689),(690,690,690), |
| 179 |
(691,691,691),(692,692,692),(693,693,693),(694,694,694),(695,695,695), |
| 180 |
(696,696,696),(697,697,697),(698,698,698),(699,699,699),(700,700,700), |
| 181 |
(701,701,701),(702,702,702),(703,703,703),(704,704,704),(705,705,705), |
| 182 |
(706,706,706),(707,707,707),(708,708,708),(709,709,709),(710,710,710), |
| 183 |
(711,711,711),(712,712,712),(713,713,713),(714,714,714),(715,715,715), |
| 184 |
(716,716,716),(717,717,717),(718,718,718),(719,719,719),(720,720,720), |
| 185 |
(721,721,721),(722,722,722),(723,723,723),(724,724,724),(725,725,725), |
| 186 |
(726,726,726),(727,727,727),(728,728,728),(729,729,729),(730,730,730), |
| 187 |
(731,731,731),(732,732,732),(733,733,733),(734,734,734),(735,735,735), |
| 188 |
(736,736,736),(737,737,737),(738,738,738),(739,739,739),(740,740,740), |
| 189 |
(741,741,741),(742,742,742),(743,743,743),(744,744,744),(745,745,745), |
| 190 |
(746,746,746),(747,747,747),(748,748,748),(749,749,749),(750,750,750), |
| 191 |
(751,751,751),(752,752,752),(753,753,753),(754,754,754),(755,755,755), |
| 192 |
(756,756,756),(757,757,757),(758,758,758),(759,759,759),(760,760,760), |
| 193 |
(761,761,761),(762,762,762),(763,763,763),(764,764,764),(765,765,765), |
| 194 |
(766,766,766),(767,767,767),(768,768,768),(769,769,769),(770,770,770), |
| 195 |
(771,771,771),(772,772,772),(773,773,773),(774,774,774),(775,775,775), |
| 196 |
(776,776,776),(777,777,777),(778,778,778),(779,779,779),(780,780,780), |
| 197 |
(781,781,781),(782,782,782),(783,783,783),(784,784,784),(785,785,785), |
| 198 |
(786,786,786),(787,787,787),(788,788,788),(789,789,789),(790,790,790), |
| 199 |
(791,791,791),(792,792,792),(793,793,793),(794,794,794),(795,795,795), |
| 200 |
(796,796,796),(797,797,797),(798,798,798),(799,799,799),(800,800,800), |
| 201 |
(801,801,801),(802,802,802),(803,803,803),(804,804,804),(805,805,805), |
| 202 |
(806,806,806),(807,807,807),(808,808,808),(809,809,809),(810,810,810), |
| 203 |
(811,811,811),(812,812,812),(813,813,813),(814,814,814),(815,815,815), |
| 204 |
(816,816,816),(817,817,817),(818,818,818),(819,819,819),(820,820,820), |
| 205 |
(821,821,821),(822,822,822),(823,823,823),(824,824,824),(825,825,825), |
| 206 |
(826,826,826),(827,827,827),(828,828,828),(829,829,829),(830,830,830), |
| 207 |
(831,831,831),(832,832,832),(833,833,833),(834,834,834),(835,835,835), |
| 208 |
(836,836,836),(837,837,837),(838,838,838),(839,839,839),(840,840,840), |
| 209 |
(841,841,841),(842,842,842),(843,843,843),(844,844,844),(845,845,845), |
| 210 |
(846,846,846),(847,847,847),(848,848,848),(849,849,849),(850,850,850), |
| 211 |
(851,851,851),(852,852,852),(853,853,853),(854,854,854),(855,855,855), |
| 212 |
(856,856,856),(857,857,857),(858,858,858),(859,859,859),(860,860,860), |
| 213 |
(861,861,861),(862,862,862),(863,863,863),(864,864,864),(865,865,865), |
| 214 |
(866,866,866),(867,867,867),(868,868,868),(869,869,869),(870,870,870), |
| 215 |
(871,871,871),(872,872,872),(873,873,873),(874,874,874),(875,875,875), |
| 216 |
(876,876,876),(877,877,877),(878,878,878),(879,879,879),(880,880,880), |
| 217 |
(881,881,881),(882,882,882),(883,883,883),(884,884,884),(885,885,885), |
| 218 |
(886,886,886),(887,887,887),(888,888,888),(889,889,889),(890,890,890), |
| 219 |
(891,891,891),(892,892,892),(893,893,893),(894,894,894),(895,895,895), |
| 220 |
(896,896,896),(897,897,897),(898,898,898),(899,899,899),(900,900,900), |
| 221 |
(901,901,901),(902,902,902),(903,903,903),(904,904,904),(905,905,905), |
| 222 |
(906,906,906),(907,907,907),(908,908,908),(909,909,909),(910,910,910), |
| 223 |
(911,911,911),(912,912,912),(913,913,913),(914,914,914),(915,915,915), |
| 224 |
(916,916,916),(917,917,917),(918,918,918),(919,919,919),(920,920,920), |
| 225 |
(921,921,921),(922,922,922),(923,923,923),(924,924,924),(925,925,925), |
| 226 |
(926,926,926),(927,927,927),(928,928,928),(929,929,929),(930,930,930), |
| 227 |
(931,931,931),(932,932,932),(933,933,933),(934,934,934),(935,935,935), |
| 228 |
(936,936,936),(937,937,937),(938,938,938),(939,939,939),(940,940,940), |
| 229 |
(941,941,941),(942,942,942),(943,943,943),(944,944,944),(945,945,945), |
| 230 |
(946,946,946),(947,947,947),(948,948,948),(949,949,949),(950,950,950), |
| 231 |
(951,951,951),(952,952,952),(953,953,953),(954,954,954),(955,955,955), |
| 232 |
(956,956,956),(957,957,957),(958,958,958),(959,959,959),(960,960,960), |
| 233 |
(961,961,961),(962,962,962),(963,963,963),(964,964,964),(965,965,965), |
| 234 |
(966,966,966),(967,967,967),(968,968,968),(969,969,969),(970,970,970), |
| 235 |
(971,971,971),(972,972,972),(973,973,973),(974,974,974),(975,975,975), |
| 236 |
(976,976,976),(977,977,977),(978,978,978),(979,979,979),(980,980,980), |
| 237 |
(981,981,981),(982,982,982),(983,983,983),(984,984,984),(985,985,985), |
| 238 |
(986,986,986),(987,987,987),(988,988,988),(989,989,989),(990,990,990), |
| 239 |
(991,991,991),(992,992,992),(993,993,993),(994,994,994),(995,995,995), |
| 240 |
(996,996,996),(997,997,997),(998,998,998),(999,999,999),(1000,1000,1000), |
| 241 |
(1001,1001,1001),(1002,1002,1002),(1003,1003,1003),(1004,1004,1004),(1005,1005,1005), |
| 242 |
(1006,1006,1006),(1007,1007,1007),(1008,1008,1008),(1009,1009,1009),(1010,1010,1010), |
| 243 |
(1011,1011,1011),(1012,1012,1012),(1013,1013,1013),(1014,1014,1014),(1015,1015,1015), |
| 244 |
(1016,1016,1016),(1017,1017,1017),(1018,1018,1018),(1019,1019,1019),(1020,1020,1020), |
| 245 |
(1021,1021,1021),(1022,1022,1022),(1023,1023,1023),(1024,1024,1024),(1025,1025,1025), |
| 246 |
(1026,1026,1026),(1027,1027,1027),(1028,1028,1028),(1029,1029,1029),(1030,1030,1030), |
| 247 |
(1031,1031,1031),(1032,1032,1032),(1033,1033,1033),(1034,1034,1034),(1035,1035,1035), |
| 248 |
(1036,1036,1036),(1037,1037,1037),(1038,1038,1038),(1039,1039,1039),(1040,1040,1040), |
| 249 |
(1041,1041,1041),(1042,1042,1042),(1043,1043,1043),(1044,1044,1044),(1045,1045,1045), |
| 250 |
(1046,1046,1046),(1047,1047,1047),(1048,1048,1048),(1049,1049,1049),(1050,1050,1050), |
| 251 |
(1051,1051,1051),(1052,1052,1052),(1053,1053,1053),(1054,1054,1054),(1055,1055,1055), |
| 252 |
(1056,1056,1056),(1057,1057,1057),(1058,1058,1058),(1059,1059,1059),(1060,1060,1060), |
| 253 |
(1061,1061,1061),(1062,1062,1062),(1063,1063,1063),(1064,1064,1064),(1065,1065,1065), |
| 254 |
(1066,1066,1066),(1067,1067,1067),(1068,1068,1068),(1069,1069,1069),(1070,1070,1070), |
| 255 |
(1071,1071,1071),(1072,1072,1072),(1073,1073,1073),(1074,1074,1074),(1075,1075,1075), |
| 256 |
(1076,1076,1076),(1077,1077,1077),(1078,1078,1078),(1079,1079,1079),(1080,1080,1080), |
| 257 |
(1081,1081,1081),(1082,1082,1082),(1083,1083,1083),(1084,1084,1084),(1085,1085,1085), |
| 258 |
(1086,1086,1086),(1087,1087,1087),(1088,1088,1088),(1089,1089,1089),(1090,1090,1090), |
| 259 |
(1091,1091,1091),(1092,1092,1092),(1093,1093,1093),(1094,1094,1094),(1095,1095,1095), |
| 260 |
(1096,1096,1096),(1097,1097,1097),(1098,1098,1098),(1099,1099,1099),(1100,1100,1100), |
| 261 |
(1101,1101,1101),(1102,1102,1102),(1103,1103,1103),(1104,1104,1104),(1105,1105,1105), |
| 262 |
(1106,1106,1106),(1107,1107,1107),(1108,1108,1108),(1109,1109,1109),(1110,1110,1110), |
| 263 |
(1111,1111,1111),(1112,1112,1112),(1113,1113,1113),(1114,1114,1114),(1115,1115,1115), |
| 264 |
(1116,1116,1116),(1117,1117,1117),(1118,1118,1118),(1119,1119,1119),(1120,1120,1120), |
| 265 |
(1121,1121,1121),(1122,1122,1122),(1123,1123,1123),(1124,1124,1124),(1125,1125,1125), |
| 266 |
(1126,1126,1126),(1127,1127,1127),(1128,1128,1128),(1129,1129,1129),(1130,1130,1130), |
| 267 |
(1131,1131,1131),(1132,1132,1132),(1133,1133,1133),(1134,1134,1134),(1135,1135,1135), |
| 268 |
(1136,1136,1136),(1137,1137,1137),(1138,1138,1138),(1139,1139,1139),(1140,1140,1140), |
| 269 |
(1141,1141,1141),(1142,1142,1142),(1143,1143,1143),(1144,1144,1144),(1145,1145,1145), |
| 270 |
(1146,1146,1146),(1147,1147,1147),(1148,1148,1148),(1149,1149,1149),(1150,1150,1150), |
| 271 |
(1151,1151,1151),(1152,1152,1152),(1153,1153,1153),(1154,1154,1154),(1155,1155,1155), |
| 272 |
(1156,1156,1156),(1157,1157,1157),(1158,1158,1158),(1159,1159,1159),(1160,1160,1160), |
| 273 |
(1161,1161,1161),(1162,1162,1162),(1163,1163,1163),(1164,1164,1164),(1165,1165,1165), |
| 274 |
(1166,1166,1166),(1167,1167,1167),(1168,1168,1168),(1169,1169,1169),(1170,1170,1170), |
| 275 |
(1171,1171,1171),(1172,1172,1172),(1173,1173,1173),(1174,1174,1174),(1175,1175,1175), |
| 276 |
(1176,1176,1176),(1177,1177,1177),(1178,1178,1178),(1179,1179,1179),(1180,1180,1180), |
| 277 |
(1181,1181,1181),(1182,1182,1182),(1183,1183,1183),(1184,1184,1184),(1185,1185,1185), |
| 278 |
(1186,1186,1186),(1187,1187,1187),(1188,1188,1188),(1189,1189,1189),(1190,1190,1190), |
| 279 |
(1191,1191,1191),(1192,1192,1192),(1193,1193,1193),(1194,1194,1194),(1195,1195,1195), |
| 280 |
(1196,1196,1196),(1197,1197,1197),(1198,1198,1198),(1199,1199,1199),(1200,1200,1200), |
| 281 |
(1201,1201,1201),(1202,1202,1202),(1203,1203,1203),(1204,1204,1204),(1205,1205,1205), |
| 282 |
(1206,1206,1206),(1207,1207,1207),(1208,1208,1208),(1209,1209,1209),(1210,1210,1210), |
| 283 |
(1211,1211,1211),(1212,1212,1212),(1213,1213,1213),(1214,1214,1214),(1215,1215,1215), |
| 284 |
(1216,1216,1216),(1217,1217,1217),(1218,1218,1218),(1219,1219,1219),(1220,1220,1220), |
| 285 |
(1221,1221,1221),(1222,1222,1222),(1223,1223,1223),(1224,1224,1224),(1225,1225,1225), |
| 286 |
(1226,1226,1226),(1227,1227,1227),(1228,1228,1228),(1229,1229,1229),(1230,1230,1230), |
| 287 |
(1231,1231,1231),(1232,1232,1232),(1233,1233,1233),(1234,1234,1234),(1235,1235,1235), |
| 288 |
(1236,1236,1236),(1237,1237,1237),(1238,1238,1238),(1239,1239,1239),(1240,1240,1240), |
| 289 |
(1241,1241,1241),(1242,1242,1242),(1243,1243,1243),(1244,1244,1244),(1245,1245,1245), |
| 290 |
(1246,1246,1246),(1247,1247,1247),(1248,1248,1248),(1249,1249,1249),(1250,1250,1250), |
| 291 |
(1251,1251,1251),(1252,1252,1252),(1253,1253,1253),(1254,1254,1254),(1255,1255,1255), |
| 292 |
(1256,1256,1256),(1257,1257,1257),(1258,1258,1258),(1259,1259,1259),(1260,1260,1260), |
| 293 |
(1261,1261,1261),(1262,1262,1262),(1263,1263,1263),(1264,1264,1264),(1265,1265,1265), |
| 294 |
(1266,1266,1266),(1267,1267,1267),(1268,1268,1268),(1269,1269,1269),(1270,1270,1270), |
| 295 |
(1271,1271,1271),(1272,1272,1272),(1273,1273,1273),(1274,1274,1274),(1275,1275,1275), |
| 296 |
(1276,1276,1276),(1277,1277,1277),(1278,1278,1278),(1279,1279,1279),(1280,1280,1280), |
| 297 |
(1281,1281,1281),(1282,1282,1282),(1283,1283,1283),(1284,1284,1284),(1285,1285,1285), |
| 298 |
(1286,1286,1286),(1287,1287,1287),(1288,1288,1288),(1289,1289,1289),(1290,1290,1290), |
| 299 |
(1291,1291,1291),(1292,1292,1292),(1293,1293,1293),(1294,1294,1294),(1295,1295,1295), |
| 300 |
(1296,1296,1296),(1297,1297,1297),(1298,1298,1298),(1299,1299,1299),(1300,1300,1300), |
| 301 |
(1301,1301,1301),(1302,1302,1302),(1303,1303,1303),(1304,1304,1304),(1305,1305,1305), |
| 302 |
(1306,1306,1306),(1307,1307,1307),(1308,1308,1308),(1309,1309,1309),(1310,1310,1310), |
| 303 |
(1311,1311,1311),(1312,1312,1312),(1313,1313,1313),(1314,1314,1314),(1315,1315,1315), |
| 304 |
(1316,1316,1316),(1317,1317,1317),(1318,1318,1318),(1319,1319,1319),(1320,1320,1320), |
| 305 |
(1321,1321,1321),(1322,1322,1322),(1323,1323,1323),(1324,1324,1324),(1325,1325,1325), |
| 306 |
(1326,1326,1326),(1327,1327,1327),(1328,1328,1328),(1329,1329,1329),(1330,1330,1330), |
| 307 |
(1331,1331,1331),(1332,1332,1332),(1333,1333,1333),(1334,1334,1334),(1335,1335,1335), |
| 308 |
(1336,1336,1336),(1337,1337,1337),(1338,1338,1338),(1339,1339,1339),(1340,1340,1340), |
| 309 |
(1341,1341,1341),(1342,1342,1342),(1343,1343,1343),(1344,1344,1344),(1345,1345,1345), |
| 310 |
(1346,1346,1346),(1347,1347,1347),(1348,1348,1348),(1349,1349,1349),(1350,1350,1350), |
| 311 |
(1351,1351,1351),(1352,1352,1352),(1353,1353,1353),(1354,1354,1354),(1355,1355,1355), |
| 312 |
(1356,1356,1356),(1357,1357,1357),(1358,1358,1358),(1359,1359,1359),(1360,1360,1360), |
| 313 |
(1361,1361,1361),(1362,1362,1362),(1363,1363,1363),(1364,1364,1364),(1365,1365,1365), |
| 314 |
(1366,1366,1366),(1367,1367,1367),(1368,1368,1368),(1369,1369,1369),(1370,1370,1370), |
| 315 |
(1371,1371,1371),(1372,1372,1372),(1373,1373,1373),(1374,1374,1374),(1375,1375,1375), |
| 316 |
(1376,1376,1376),(1377,1377,1377),(1378,1378,1378),(1379,1379,1379),(1380,1380,1380), |
| 317 |
(1381,1381,1381),(1382,1382,1382),(1383,1383,1383),(1384,1384,1384),(1385,1385,1385), |
| 318 |
(1386,1386,1386),(1387,1387,1387),(1388,1388,1388),(1389,1389,1389),(1390,1390,1390), |
| 319 |
(1391,1391,1391),(1392,1392,1392),(1393,1393,1393),(1394,1394,1394),(1395,1395,1395), |
| 320 |
(1396,1396,1396),(1397,1397,1397),(1398,1398,1398),(1399,1399,1399),(1400,1400,1400), |
| 321 |
(1401,1401,1401),(1402,1402,1402),(1403,1403,1403),(1404,1404,1404),(1405,1405,1405), |
| 322 |
(1406,1406,1406),(1407,1407,1407),(1408,1408,1408),(1409,1409,1409),(1410,1410,1410), |
| 323 |
(1411,1411,1411),(1412,1412,1412),(1413,1413,1413),(1414,1414,1414),(1415,1415,1415), |
| 324 |
(1416,1416,1416),(1417,1417,1417),(1418,1418,1418),(1419,1419,1419),(1420,1420,1420), |
| 325 |
(1421,1421,1421),(1422,1422,1422),(1423,1423,1423),(1424,1424,1424),(1425,1425,1425), |
| 326 |
(1426,1426,1426),(1427,1427,1427),(1428,1428,1428),(1429,1429,1429),(1430,1430,1430), |
| 327 |
(1431,1431,1431),(1432,1432,1432),(1433,1433,1433),(1434,1434,1434),(1435,1435,1435), |
| 328 |
(1436,1436,1436),(1437,1437,1437),(1438,1438,1438),(1439,1439,1439),(1440,1440,1440), |
| 329 |
(1441,1441,1441),(1442,1442,1442),(1443,1443,1443),(1444,1444,1444),(1445,1445,1445), |
| 330 |
(1446,1446,1446),(1447,1447,1447),(1448,1448,1448),(1449,1449,1449),(1450,1450,1450), |
| 331 |
(1451,1451,1451),(1452,1452,1452),(1453,1453,1453),(1454,1454,1454),(1455,1455,1455), |
| 332 |
(1456,1456,1456),(1457,1457,1457),(1458,1458,1458),(1459,1459,1459),(1460,1460,1460), |
| 333 |
(1461,1461,1461),(1462,1462,1462),(1463,1463,1463),(1464,1464,1464),(1465,1465,1465), |
| 334 |
(1466,1466,1466),(1467,1467,1467),(1468,1468,1468),(1469,1469,1469),(1470,1470,1470), |
| 335 |
(1471,1471,1471),(1472,1472,1472),(1473,1473,1473),(1474,1474,1474),(1475,1475,1475), |
| 336 |
(1476,1476,1476),(1477,1477,1477),(1478,1478,1478),(1479,1479,1479),(1480,1480,1480), |
| 337 |
(1481,1481,1481),(1482,1482,1482),(1483,1483,1483),(1484,1484,1484),(1485,1485,1485), |
| 338 |
(1486,1486,1486),(1487,1487,1487),(1488,1488,1488),(1489,1489,1489),(1490,1490,1490), |
| 339 |
(1491,1491,1491),(1492,1492,1492),(1493,1493,1493),(1494,1494,1494),(1495,1495,1495), |
| 340 |
(1496,1496,1496),(1497,1497,1497),(1498,1498,1498),(1499,1499,1499),(1500,1500,1500), |
| 341 |
(1501,1501,1501),(1502,1502,1502),(1503,1503,1503),(1504,1504,1504),(1505,1505,1505), |
| 342 |
(1506,1506,1506),(1507,1507,1507),(1508,1508,1508),(1509,1509,1509),(1510,1510,1510), |
| 343 |
(1511,1511,1511),(1512,1512,1512),(1513,1513,1513),(1514,1514,1514),(1515,1515,1515), |
| 344 |
(1516,1516,1516),(1517,1517,1517),(1518,1518,1518),(1519,1519,1519),(1520,1520,1520), |
| 345 |
(1521,1521,1521),(1522,1522,1522),(1523,1523,1523),(1524,1524,1524),(1525,1525,1525), |
| 346 |
(1526,1526,1526),(1527,1527,1527),(1528,1528,1528),(1529,1529,1529),(1530,1530,1530), |
| 347 |
(1531,1531,1531),(1532,1532,1532),(1533,1533,1533),(1534,1534,1534),(1535,1535,1535), |
| 348 |
(1536,1536,1536),(1537,1537,1537),(1538,1538,1538),(1539,1539,1539),(1540,1540,1540), |
| 349 |
(1541,1541,1541),(1542,1542,1542),(1543,1543,1543),(1544,1544,1544),(1545,1545,1545), |
| 350 |
(1546,1546,1546),(1547,1547,1547),(1548,1548,1548),(1549,1549,1549),(1550,1550,1550), |
| 351 |
(1551,1551,1551),(1552,1552,1552),(1553,1553,1553),(1554,1554,1554),(1555,1555,1555), |
| 352 |
(1556,1556,1556),(1557,1557,1557),(1558,1558,1558),(1559,1559,1559),(1560,1560,1560), |
| 353 |
(1561,1561,1561),(1562,1562,1562),(1563,1563,1563),(1564,1564,1564),(1565,1565,1565), |
| 354 |
(1566,1566,1566),(1567,1567,1567),(1568,1568,1568),(1569,1569,1569),(1570,1570,1570), |
| 355 |
(1571,1571,1571),(1572,1572,1572),(1573,1573,1573),(1574,1574,1574),(1575,1575,1575), |
| 356 |
(1576,1576,1576),(1577,1577,1577),(1578,1578,1578),(1579,1579,1579),(1580,1580,1580), |
| 357 |
(1581,1581,1581),(1582,1582,1582),(1583,1583,1583),(1584,1584,1584),(1585,1585,1585), |
| 358 |
(1586,1586,1586),(1587,1587,1587),(1588,1588,1588),(1589,1589,1589),(1590,1590,1590), |
| 359 |
(1591,1591,1591),(1592,1592,1592),(1593,1593,1593),(1594,1594,1594),(1595,1595,1595), |
| 360 |
(1596,1596,1596),(1597,1597,1597),(1598,1598,1598),(1599,1599,1599),(1600,1600,1600), |
| 361 |
(1601,1601,1601),(1602,1602,1602),(1603,1603,1603),(1604,1604,1604),(1605,1605,1605), |
| 362 |
(1606,1606,1606),(1607,1607,1607),(1608,1608,1608),(1609,1609,1609),(1610,1610,1610), |
| 363 |
(1611,1611,1611),(1612,1612,1612),(1613,1613,1613),(1614,1614,1614),(1615,1615,1615), |
| 364 |
(1616,1616,1616),(1617,1617,1617),(1618,1618,1618),(1619,1619,1619),(1620,1620,1620), |
| 365 |
(1621,1621,1621),(1622,1622,1622),(1623,1623,1623),(1624,1624,1624),(1625,1625,1625), |
| 366 |
(1626,1626,1626),(1627,1627,1627),(1628,1628,1628),(1629,1629,1629),(1630,1630,1630), |
| 367 |
(1631,1631,1631),(1632,1632,1632),(1633,1633,1633),(1634,1634,1634),(1635,1635,1635), |
| 368 |
(1636,1636,1636),(1637,1637,1637),(1638,1638,1638),(1639,1639,1639),(1640,1640,1640), |
| 369 |
(1641,1641,1641),(1642,1642,1642),(1643,1643,1643),(1644,1644,1644),(1645,1645,1645), |
| 370 |
(1646,1646,1646),(1647,1647,1647),(1648,1648,1648),(1649,1649,1649),(1650,1650,1650), |
| 371 |
(1651,1651,1651),(1652,1652,1652),(1653,1653,1653),(1654,1654,1654),(1655,1655,1655), |
| 372 |
(1656,1656,1656),(1657,1657,1657),(1658,1658,1658),(1659,1659,1659),(1660,1660,1660), |
| 373 |
(1661,1661,1661),(1662,1662,1662),(1663,1663,1663),(1664,1664,1664),(1665,1665,1665), |
| 374 |
(1666,1666,1666),(1667,1667,1667),(1668,1668,1668),(1669,1669,1669),(1670,1670,1670), |
| 375 |
(1671,1671,1671),(1672,1672,1672),(1673,1673,1673),(1674,1674,1674),(1675,1675,1675), |
| 376 |
(1676,1676,1676),(1677,1677,1677),(1678,1678,1678),(1679,1679,1679),(1680,1680,1680), |
| 377 |
(1681,1681,1681),(1682,1682,1682),(1683,1683,1683),(1684,1684,1684),(1685,1685,1685), |
| 378 |
(1686,1686,1686),(1687,1687,1687),(1688,1688,1688),(1689,1689,1689),(1690,1690,1690), |
| 379 |
(1691,1691,1691),(1692,1692,1692),(1693,1693,1693),(1694,1694,1694),(1695,1695,1695), |
| 380 |
(1696,1696,1696),(1697,1697,1697),(1698,1698,1698),(1699,1699,1699),(1700,1700,1700), |
| 381 |
(1701,1701,1701),(1702,1702,1702),(1703,1703,1703),(1704,1704,1704),(1705,1705,1705), |
| 382 |
(1706,1706,1706),(1707,1707,1707),(1708,1708,1708),(1709,1709,1709),(1710,1710,1710), |
| 383 |
(1711,1711,1711),(1712,1712,1712),(1713,1713,1713),(1714,1714,1714),(1715,1715,1715), |
| 384 |
(1716,1716,1716),(1717,1717,1717),(1718,1718,1718),(1719,1719,1719),(1720,1720,1720), |
| 385 |
(1721,1721,1721),(1722,1722,1722),(1723,1723,1723),(1724,1724,1724),(1725,1725,1725), |
| 386 |
(1726,1726,1726),(1727,1727,1727),(1728,1728,1728),(1729,1729,1729),(1730,1730,1730), |
| 387 |
(1731,1731,1731),(1732,1732,1732),(1733,1733,1733),(1734,1734,1734),(1735,1735,1735), |
| 388 |
(1736,1736,1736),(1737,1737,1737),(1738,1738,1738),(1739,1739,1739),(1740,1740,1740), |
| 389 |
(1741,1741,1741),(1742,1742,1742),(1743,1743,1743),(1744,1744,1744),(1745,1745,1745), |
| 390 |
(1746,1746,1746),(1747,1747,1747),(1748,1748,1748),(1749,1749,1749),(1750,1750,1750), |
| 391 |
(1751,1751,1751),(1752,1752,1752),(1753,1753,1753),(1754,1754,1754),(1755,1755,1755), |
| 392 |
(1756,1756,1756),(1757,1757,1757),(1758,1758,1758),(1759,1759,1759),(1760,1760,1760), |
| 393 |
(1761,1761,1761),(1762,1762,1762),(1763,1763,1763),(1764,1764,1764),(1765,1765,1765), |
| 394 |
(1766,1766,1766),(1767,1767,1767),(1768,1768,1768),(1769,1769,1769),(1770,1770,1770), |
| 395 |
(1771,1771,1771),(1772,1772,1772),(1773,1773,1773),(1774,1774,1774),(1775,1775,1775), |
| 396 |
(1776,1776,1776),(1777,1777,1777),(1778,1778,1778),(1779,1779,1779),(1780,1780,1780), |
| 397 |
(1781,1781,1781),(1782,1782,1782),(1783,1783,1783),(1784,1784,1784),(1785,1785,1785), |
| 398 |
(1786,1786,1786),(1787,1787,1787),(1788,1788,1788),(1789,1789,1789),(1790,1790,1790), |
| 399 |
(1791,1791,1791),(1792,1792,1792),(1793,1793,1793),(1794,1794,1794),(1795,1795,1795), |
| 400 |
(1796,1796,1796),(1797,1797,1797),(1798,1798,1798),(1799,1799,1799),(1800,1800,1800), |
| 401 |
(1801,1801,1801),(1802,1802,1802),(1803,1803,1803),(1804,1804,1804),(1805,1805,1805), |
| 402 |
(1806,1806,1806),(1807,1807,1807),(1808,1808,1808),(1809,1809,1809),(1810,1810,1810), |
| 403 |
(1811,1811,1811),(1812,1812,1812),(1813,1813,1813),(1814,1814,1814),(1815,1815,1815), |
| 404 |
(1816,1816,1816),(1817,1817,1817),(1818,1818,1818),(1819,1819,1819),(1820,1820,1820), |
| 405 |
(1821,1821,1821),(1822,1822,1822),(1823,1823,1823),(1824,1824,1824),(1825,1825,1825), |
| 406 |
(1826,1826,1826),(1827,1827,1827),(1828,1828,1828),(1829,1829,1829),(1830,1830,1830), |
| 407 |
(1831,1831,1831),(1832,1832,1832),(1833,1833,1833),(1834,1834,1834),(1835,1835,1835), |
| 408 |
(1836,1836,1836),(1837,1837,1837),(1838,1838,1838),(1839,1839,1839),(1840,1840,1840), |
| 409 |
(1841,1841,1841),(1842,1842,1842),(1843,1843,1843),(1844,1844,1844),(1845,1845,1845), |
| 410 |
(1846,1846,1846),(1847,1847,1847),(1848,1848,1848),(1849,1849,1849),(1850,1850,1850), |
| 411 |
(1851,1851,1851),(1852,1852,1852),(1853,1853,1853),(1854,1854,1854),(1855,1855,1855), |
| 412 |
(1856,1856,1856),(1857,1857,1857),(1858,1858,1858),(1859,1859,1859),(1860,1860,1860), |
| 413 |
(1861,1861,1861),(1862,1862,1862),(1863,1863,1863),(1864,1864,1864),(1865,1865,1865), |
| 414 |
(1866,1866,1866),(1867,1867,1867),(1868,1868,1868),(1869,1869,1869),(1870,1870,1870), |
| 415 |
(1871,1871,1871),(1872,1872,1872),(1873,1873,1873),(1874,1874,1874),(1875,1875,1875), |
| 416 |
(1876,1876,1876),(1877,1877,1877),(1878,1878,1878),(1879,1879,1879),(1880,1880,1880), |
| 417 |
(1881,1881,1881),(1882,1882,1882),(1883,1883,1883),(1884,1884,1884),(1885,1885,1885), |
| 418 |
(1886,1886,1886),(1887,1887,1887),(1888,1888,1888),(1889,1889,1889),(1890,1890,1890), |
| 419 |
(1891,1891,1891),(1892,1892,1892),(1893,1893,1893),(1894,1894,1894),(1895,1895,1895), |
| 420 |
(1896,1896,1896),(1897,1897,1897),(1898,1898,1898),(1899,1899,1899),(1900,1900,1900), |
| 421 |
(1901,1901,1901),(1902,1902,1902),(1903,1903,1903),(1904,1904,1904),(1905,1905,1905), |
| 422 |
(1906,1906,1906),(1907,1907,1907),(1908,1908,1908),(1909,1909,1909),(1910,1910,1910), |
| 423 |
(1911,1911,1911),(1912,1912,1912),(1913,1913,1913),(1914,1914,1914),(1915,1915,1915), |
| 424 |
(1916,1916,1916),(1917,1917,1917),(1918,1918,1918),(1919,1919,1919),(1920,1920,1920), |
| 425 |
(1921,1921,1921),(1922,1922,1922),(1923,1923,1923),(1924,1924,1924),(1925,1925,1925), |
| 426 |
(1926,1926,1926),(1927,1927,1927),(1928,1928,1928),(1929,1929,1929),(1930,1930,1930), |
| 427 |
(1931,1931,1931),(1932,1932,1932),(1933,1933,1933),(1934,1934,1934),(1935,1935,1935), |
| 428 |
(1936,1936,1936),(1937,1937,1937),(1938,1938,1938),(1939,1939,1939),(1940,1940,1940), |
| 429 |
(1941,1941,1941),(1942,1942,1942),(1943,1943,1943),(1944,1944,1944),(1945,1945,1945), |
| 430 |
(1946,1946,1946),(1947,1947,1947),(1948,1948,1948),(1949,1949,1949),(1950,1950,1950), |
| 431 |
(1951,1951,1951),(1952,1952,1952),(1953,1953,1953),(1954,1954,1954),(1955,1955,1955), |
| 432 |
(1956,1956,1956),(1957,1957,1957),(1958,1958,1958),(1959,1959,1959),(1960,1960,1960), |
| 433 |
(1961,1961,1961),(1962,1962,1962),(1963,1963,1963),(1964,1964,1964),(1965,1965,1965), |
| 434 |
(1966,1966,1966),(1967,1967,1967),(1968,1968,1968),(1969,1969,1969),(1970,1970,1970), |
| 435 |
(1971,1971,1971),(1972,1972,1972),(1973,1973,1973),(1974,1974,1974),(1975,1975,1975), |
| 436 |
(1976,1976,1976),(1977,1977,1977),(1978,1978,1978),(1979,1979,1979),(1980,1980,1980), |
| 437 |
(1981,1981,1981),(1982,1982,1982),(1983,1983,1983),(1984,1984,1984),(1985,1985,1985), |
| 438 |
(1986,1986,1986),(1987,1987,1987),(1988,1988,1988),(1989,1989,1989),(1990,1990,1990), |
| 439 |
(1991,1991,1991),(1992,1992,1992),(1993,1993,1993),(1994,1994,1994),(1995,1995,1995), |
| 440 |
(1996,1996,1996),(1997,1997,1997),(1998,1998,1998),(1999,1999,1999); |
| 441 |
|
| 442 |
SELECT COUNT(*) FROM t1; |
| 443 |
|
| 444 |
|
| 445 |
# |
| 446 |
# Insert duplicate rows |
| 447 |
# |
| 448 |
--error ER_DUP_ENTRY |
| 449 |
INSERT INTO t1 VALUES (1,1,1); |
| 450 |
|
| 451 |
--error 1022 |
| 452 |
INSERT INTO t1 VALUES |
| 453 |
(-1,-1,-1),(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5), |
| 454 |
(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10),(9999,9999,9999); |
| 455 |
|
| 456 |
select count(*) from t1; |
| 457 |
|
| 458 |
|
| 459 |
# |
| 460 |
# Test that select count(*) can see inserts made in the same transaction |
| 461 |
# |
| 462 |
begin; |
| 463 |
SELECT COUNT(*) FROM t1; |
| 464 |
INSERT INTO t1 VALUES |
| 465 |
(2001,2001,2001),(2002,2002,2002),(2003,2003,2003),(2004,2004,2004),(2005,2005,2005); |
| 466 |
SELECT COUNT(*) FROM t1; |
| 467 |
rollback; |
| 468 |
|
| 469 |
# |
| 470 |
# Insert duplicate rows, inside transaction |
| 471 |
# try to commit |
| 472 |
# |
| 473 |
begin; |
| 474 |
|
| 475 |
--error 1022 |
| 476 |
INSERT INTO t1 VALUES |
| 477 |
(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5), |
| 478 |
(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10); |
| 479 |
|
| 480 |
rollback; |
| 481 |
|
| 482 |
select * from t1 where pk1=1; |
| 483 |
select * from t1 where pk1=10; |
| 484 |
select count(*) from t1 where pk1 <= 10 order by pk1; |
| 485 |
select count(*) from t1; |
| 486 |
|
| 487 |
|
| 488 |
# |
| 489 |
# Insert duplicate rows, inside transaction |
| 490 |
# rollback |
| 491 |
# |
| 492 |
begin; |
| 493 |
|
| 494 |
--error 1022 |
| 495 |
INSERT INTO t1 VALUES |
| 496 |
(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5), |
| 497 |
(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10); |
| 498 |
|
| 499 |
rollback; |
| 500 |
|
| 501 |
select * from t1 where pk1=1; |
| 502 |
select * from t1 where pk1=10; |
| 503 |
select count(*) from t1 where pk1 <= 10 order by pk1; |
| 504 |
select count(*) from t1; |
| 505 |
|
| 506 |
|
| 507 |
# |
| 508 |
# Insert duplicate rows, inside transaction |
| 509 |
# then try to select, finally rollback |
| 510 |
# |
| 511 |
begin; |
| 512 |
|
| 513 |
--error 1022 |
| 514 |
INSERT INTO t1 VALUES |
| 515 |
(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5), |
| 516 |
(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10); |
| 517 |
# check that we get a warning that transaction has rolled back |
| 518 |
SHOW WARNINGS; |
| 519 |
|
| 520 |
# transaction has rolled back, no error |
| 521 |
SELECT * FROM t1 WHERE pk1=10; |
| 522 |
|
| 523 |
# transaction has rolled back, no error |
| 524 |
rollback; |
| 525 |
|
| 526 |
select * from t1 where pk1=1; |
| 527 |
select * from t1 where pk1=10; |
| 528 |
select count(*) from t1 where pk1 <= 10 order by pk1; |
| 529 |
select count(*) from t1; |
| 530 |
|
| 531 |
|
| 532 |
# |
| 533 |
# Insert duplicate rows, inside transaction |
| 534 |
# then try to select, finally commit |
| 535 |
# |
| 536 |
begin; |
| 537 |
|
| 538 |
--error 1022 |
| 539 |
INSERT INTO t1 VALUES |
| 540 |
(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5), |
| 541 |
(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10); |
| 542 |
|
| 543 |
# transaction has rolled back, no error |
| 544 |
SELECT * FROM t1 WHERE pk1=10; |
| 545 |
|
| 546 |
# transaction has rolled back, no error |
| 547 |
SELECT * FROM t1 WHERE pk1=10; |
| 548 |
|
| 549 |
# transaction has rolled back, no error |
| 550 |
commit; |
| 551 |
|
| 552 |
select * from t1 where pk1=1; |
| 553 |
select * from t1 where pk1=10; |
| 554 |
select count(*) from t1 where pk1 <= 10 order by pk1; |
| 555 |
select count(*) from t1; |
| 556 |
|
| 557 |
|
| 558 |
# |
| 559 |
# Insert duplicate rows, inside transaction |
| 560 |
# then try to do another insert |
| 561 |
# |
| 562 |
begin; |
| 563 |
|
| 564 |
--error 1022 |
| 565 |
INSERT INTO t1 VALUES |
| 566 |
(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5), |
| 567 |
(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10); |
| 568 |
|
| 569 |
# transaction has rolled back, no error |
| 570 |
INSERT INTO t1 values (4000, 40, 44); |
| 571 |
|
| 572 |
# transaction has rolled back, no error |
| 573 |
rollback; |
| 574 |
|
| 575 |
select * from t1 where pk1=1; |
| 576 |
select * from t1 where pk1=10; |
| 577 |
select count(*) from t1 where pk1 <= 10 order by pk1; |
| 578 |
select count(*) from t1; |
| 579 |
|
| 580 |
# |
| 581 |
# Insert duplicate rows using "insert .. select" |
| 582 |
|
| 583 |
# |
| 584 |
--error 1022 |
| 585 |
insert into t1 select * from t1 where b < 10 order by pk1; |
| 586 |
|
| 587 |
DELETE FROM t1 WHERE pk1=2; |
| 588 |
|
| 589 |
begin; |
| 590 |
INSERT IGNORE INTO t1 VALUES(1,2,3),(2,3,4); |
| 591 |
select * from t1 where pk1 < 3 order by pk1; |
| 592 |
rollback; |
| 593 |
|
| 594 |
INSERT IGNORE INTO t1 VALUES(1,2,3),(2,3,4); |
| 595 |
select * from t1 where pk1 < 3 order by pk1; |
| 596 |
|
| 597 |
REPLACE INTO t1 values(1, 78, 3); |
| 598 |
select * from t1 where pk1=1; |
| 599 |
|
| 600 |
INSERT INTO t1 VALUES(1,1,1),(3,4,5) ON DUPLICATE KEY UPDATE b=79; |
| 601 |
select * from t1 where pk1 < 4 order by pk1; |
| 602 |
|
| 603 |
INSERT INTO t1 VALUES(1,1,1),(3,4,5) ON DUPLICATE KEY UPDATE b=pk1+c; |
| 604 |
select * from t1 where pk1 < 4 order by pk1; |
| 605 |
|
| 606 |
DELETE FROM t1 WHERE pk1 = 2 OR pk1 = 4 OR pk1 = 6; |
| 607 |
INSERT INTO t1 VALUES(1,1,1),(2,2,17),(3,4,5) ON DUPLICATE KEY UPDATE pk1=b; |
| 608 |
select * from t1 where pk1 = b and b != c order by pk1; |
| 609 |
|
| 610 |
# Test handling of duplicate unique |
| 611 |
DELETE FROM t1; |
| 612 |
CREATE UNIQUE INDEX bi ON t1(b); |
| 613 |
INSERT INTO t1 VALUES |
| 614 |
(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5), |
| 615 |
(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10); |
| 616 |
INSERT INTO t1 VALUES(0,1,0),(21,21,21) ON DUPLICATE KEY UPDATE pk1=b+10,b=b+10; |
| 617 |
select * from t1 order by pk1; |
| 618 |
|
| 619 |
DROP TABLE t1; |
| 620 |
|
| 621 |
# |
| 622 |
# Bug #6331: problem with 'insert ignore' |
| 623 |
# |
| 624 |
|
| 625 |
CREATE TABLE t1(a INT) ENGINE=ndb; |
| 626 |
INSERT IGNORE INTO t1 VALUES (1); |
| 627 |
INSERT IGNORE INTO t1 VALUES (1); |
| 628 |
INSERT IGNORE INTO t1 SELECT a FROM t1; |
| 629 |
INSERT IGNORE INTO t1 SELECT a FROM t1; |
| 630 |
INSERT IGNORE INTO t1 SELECT a FROM t1; |
| 631 |
INSERT IGNORE INTO t1 VALUES (1); |
| 632 |
INSERT IGNORE INTO t1 VALUES (1); |
| 633 |
SELECT * FROM t1 ORDER BY a; |
| 634 |
DELETE FROM t1; |
| 635 |
CREATE UNIQUE INDEX ai ON t1(a); |
| 636 |
INSERT IGNORE INTO t1 VALUES (1); |
| 637 |
INSERT IGNORE INTO t1 VALUES (1); |
| 638 |
INSERT IGNORE INTO t1 VALUES (NULL),(2); |
| 639 |
SELECT * FROM t1 ORDER BY a; |
| 640 |
DROP TABLE t1; |
| 641 |
|
| 642 |
# Ignore and NULL values |
| 643 |
CREATE TABLE t1(pk INT NOT NULL PRIMARY KEY, a INT, UNIQUE (a)) ENGINE=ndb; |
| 644 |
INSERT IGNORE INTO t1 VALUES (1,1),(2,2),(3,3); |
| 645 |
INSERT IGNORE INTO t1 VALUES (4,NULL),(5,NULL),(6,NULL),(7,4); |
| 646 |
SELECT * FROM t1 ORDER BY pk; |
| 647 |
DROP TABLE t1; |
| 648 |
|
| 649 |
# |
| 650 |
# Bug #27980 INSERT IGNORE wrongly ignores NULLs in unique index |
| 651 |
# |
| 652 |
|
| 653 |
create table t1(a int primary key, b int, unique key(b)) engine=ndb; |
| 654 |
insert ignore into t1 values (1,0), (2,0), (2,null), (3,null); |
| 655 |
select * from t1 order by a; |
| 656 |
drop table t1; |
| 657 |
# End of 4.1 tests |
| 658 |
|
| 659 |
# |
| 660 |
# Bug #35990 Error code 1062 to 1296 (unknown) after setting sql_mode to STRICT_TRANS_TABLES |
| 661 |
# |
| 662 |
|
| 663 |
create table t1(code varchar(64) not null, PRIMARY KEY (code)) ENGINE=NDBCluster; |
| 664 |
|
| 665 |
insert into t1 values ('code'); |
| 666 |
--error ER_DUP_ENTRY |
| 667 |
insert into t1 values ('code'); |
| 668 |
|
| 669 |
set sql_mode='STRICT_TRANS_TABLES'; |
| 670 |
--error ER_DUP_ENTRY |
| 671 |
insert into t1 values ('code'); |
| 672 |
drop table t1; |
| 673 |
|
| 674 |
# |
| 675 |
# Bug#14065831 "TRANSACTION ALREADY ABORTED" HIDES REAL ERROR MSG ON INSERT ... ONE DUP U |
| 676 |
# |
| 677 |
connect(con1, localhost, root,,); |
| 678 |
connect(con2, localhost, root,,); |
| 679 |
|
| 680 |
connection con1; |
| 681 |
|
| 682 |
create table t1(id int primary key, val int) engine=ndb; |
| 683 |
|
| 684 |
insert into t1 set id=1, val=23; |
| 685 |
|
| 686 |
begin; |
| 687 |
select * from t1 where id=1 for update; |
| 688 |
|
| 689 |
connection con2; |
| 690 |
begin; |
| 691 |
--error ER_LOCK_WAIT_TIMEOUT |
| 692 |
insert into t1 set id=1, val=42 on duplicate key update val=42; |
| 693 |
rollback; |
| 694 |
|
| 695 |
connection con1; |
| 696 |
rollback; |
| 697 |
|
| 698 |
drop table t1; |