Norbert Tretkowski wrote:
Am Montag, den 18.08.2008, 09:22 -0700 schrieb tabris:This bug has been sitting around since July w/o a resolution.I tracked it down to a difference between i386 builds and AMD64. The crash only occurs on AMD64. I think this is an important bug to be fixed as it results in a minor reproducible DoS/data-loss (of temporary tables and heap tables). At this point I am unclear on what to do about it, especially as I contacted the maintainer directly 3 weeks ago and still have yet to receive a response.I am still unable to reproduce this crash, even on amd64. I get a bunch of syntax errors when sourcing country.sql, but no crash when sourcing mysql-crash.sql. Norbert
Find attached a clean copy of both files, and a tarball of them.I'm guessing that the country.sql may have been corrupted somehow, thus the syntax errors.
Also, just updated to 5.0.51a-12, and it still happens.
-- MySQL dump 10.11 -- -- Host: localhost Database: svsdev -- ------------------------------------------------------ -- Server version 5.0.51-3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `country` -- DROP TABLE IF EXISTS `country`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `country` ( `low` int(10) unsigned NOT NULL default '0', `high` int(10) unsigned NOT NULL default '0', `country` char(2) NOT NULL default '-', PRIMARY KEY (`low`,`high`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `country` -- LOCK TABLES `country` WRITE; /*!40000 ALTER TABLE `country` DISABLE KEYS */; INSERT INTO `country` VALUES (1432264704,1432272896,'ad'),(1538998272,1539006464,'ad'),(3262479282,3262479282,'ad'),(3265150976,3265159168,'ad'),(3278943684,3278943684,'ad'),(3278943735,3278943735,'ad'),(1040983568,1040983576,'ae'),(1049759984,1049760000,'ae'),(1049764448,1049764464,'ae'),(1049766512,1049766528,'ae'),(1049767936,1049767952,'ae'),(1049768768,1049768800,'ae'),(1049769120,1049769152,'ae'),(1049770112,1049770128,'ae'),(1049772896,1049772928,'ae'),(1049775088,1049775104,'ae'),(1049776448,1049776480,'ae'),(1049778336,1049778352,'ae'),(1049779136,1049779168,'ae'),(1049782304,1049782336,'ae'),(1049783744,1049783760,'ae'),(1049817288,1049817296,'ae'),(1307898048,1307898080,'ae'),(1307898576,1307898592,'ae'),(1315897344,1315901440,'ae'),(1317113856,1317114112,'ae'),(1331853312,1331855360,'ae'),(1347979752,1347979760,'ae'),(1347982208,1347982224,'ae'),(1350215784,1350215788,'ae'),(1350217348,1350217352,'ae'),(1350217408,1350217424,'ae'),(1350217696,1350217712,'ae'),(1354674944,1354675200,'ae'),(1354676480,1354676736,'ae'),(1354676736,1354676768,'ae'),(1354676992,1354677024,'ae'),(1354677248,1354677280,'ae'),(1354678016,1354678032,'ae'),(1354678560,1354678576,'ae'),(1354679296,1354679808,'ae'),(1354680064,1354680080,'ae'),(1354681472,1354681488,'ae'),(1354682288,1354682304,'ae'),(1354682896,1354682912,'ae'),(1354684416,1354684432,'ae'),(1354684672,1354684928,'ae'),(1357053952,1357119488,'ae'),(1358899304,1358899312,'ae'),(1389199360,1389232128,'ae'),(1389272368,1389272384,'ae'),(1389273344,1389273600,'ae'),(1389274880,1389275136,'ae'),(1399717888,1399848960,'ae'),(1401423872,1401425920,'ae'),(1403661216,1403661248,'ae'),(1403661248,1403661280,'ae'),(1403662176,1403662208,'ae'),(1403662272,1403662304,'ae'),(1403662944,1403662976,'ae'),(1403663136,1403663168,'ae'),(1403663168,1403663200,'ae'),(1403663568,1403663576,'ae'),(1410008576,1410008608,'ae'),(1410013472,1410013504,'ae'),(1410013504,1410013536,'ae'),(1410013568,1410013632,'ae'),(1410013664,1410013696,'ae'),(1410013728,1410013760,'ae'),(1410013952,1410013984,'ae'),(1410014048,1410014080,'ae'),(1410014208,1410014240,'ae'),(1410014336,1410014400,'ae'),(1410014944,1410014952,'ae'),(1410014973,1410014973,'ae'),(1410014974,1410014974,'ae'),(1410015424,1410015488,'ae'),(1410015872,1410015936,'ae'),(1410016256,1410016320,'ae'),(1410016576,1410016608,'ae'),(1410016832,1410016864,'ae'),(1410016896,1410017024,'ae'),(1410018304,1410018560,'ae'),(1410022528,1410022592,'ae'),(1410024192,1410024224,'ae'),(1410025280,1410025312,'ae'),(1410025408,1410025440,'ae'),(1410025504,1410025520,'ae'),(1410025728,1410025760,'ae'),(1410025792,1410025824,'ae'),(1410026016,1410026048,'ae'),(1410026176,1410026208,'ae'),(1410026240,1410026368,'ae'),(1410036224,1410036352,'ae'),(1410036480,1410036512,'ae'),(1410039808,1410041856,'ae'),(1410072320,1410072576,'ae'),(1410745224,1410745232,'ae'),(1412415488,1412431872,'ae'),(1424612608,1424612672,'ae'),(1425971712,1425971728,'ae'),(1425979653,1425979653,'ae'),(1425979654,1425979656,'ae'),(1425979656,1425979656,'ae'),(1425979661,1425979661,'ae'),(1425979662,1425979664,'ae'),(1425979664,1425979680,'ae'),(1425979680,1425979688,'ae'),(1425979688,1425979692,'ae'),(1425979692,1425979692,'ae'),(1425979705,1425979705,'ae'),(1425979706,1425979708,'ae'),(1425979708,1425979708,'ae'),(1425979905,1425979905,'ae'),(1425979906,1425979908,'ae'),(1425979908,1425979912,'ae'),(1425979912,1425979920,'ae'),(1425979920,1425979936,'ae'),(1425979936,1425979968,'ae'),(1425979968,1425979968,'ae'),(1425980096,1425980160,'ae'),(1432346880,1432347136,'ae'),(1432352768,1432353280,'ae'),(1433616384,1433624576,'ae'),(1441562624,1441570816,'ae'),(1446903808,1446920192,'ae'),(1449132032,1449394176,'ae'),(1472724992,1472856064,'ae'),(1475207168,1475209216,'ae'),(1475952640,1475953152,'ae'),(1484038244,1484038248,'ae'),(1496178944,1496179200,'ae'),(1506455808,1506456064,'ae'),(1531445248,1531707392,'ae'),(1533420288,1533420544,'ae'); INSERT INTO `country` VALUES (1533442048,1533444096,'ae'),(1534129152,1534129408,'ae'),(1536048128,1536048256,'ae'),(1549795328,1550057472,'ae'),(3227979264,3227979520,'ae'),(3250324992,3250325248,'ae'),(3252429616,3252429632,'ae'),(3259302144,3259302400,'ae'),(3262472432,3262472436,'ae'),(3262475792,3262475808,'ae'),(3262478109,3262478109,'ae'),(3262478382,3262478382,'ae'),(3262478384,3262478384,'ae'),(3264408576,3264409600,'ae'),(3265569280,3265569792,'ae'),(3265921024,3265986560,'ae'),(3277882112,3277882368,'ae'),(3278943567,3278943567,'ae'),(3286564864,3286630400,'ae'),(3288548096,3288548352,'ae'),(3288548352,3288549376,'ae'),(3557173696,3557173704,'ae'),(3557174784,3557175040,'ae'),(3557960976,3557960984,'ae'),(3557961376,3557961408,'ae'),(3560942940,3560942944,'ae'),(3564862864,3564862872,'ae'),(3576299520,3576365056,'ae'),(3582205952,3582214144,'ae'),(3587288576,3587288704,'ae'),(3590156960,3590156992,'ae'),(3590319104,3590319136,'ae'),(3590319136,3590319152,'ae'),(3590319152,3590319160,'ae'),(3590319160,3590319164,'ae'),(3590319164,3590319166,'ae'),(3590319168,3590319232,'ae'),(3590319232,3590319360,'ae'),(3590319376,3590319392,'ae'),(3590319424,3590319488,'ae'),(3590319488,3590319616,'ae'),(3590319616,3590319872,'ae'),(3590319872,3590320000,'ae'),(3590320000,3590320064,'ae'),(3590320064,3590320096,'ae'),(3590320096,3590320112,'ae'),(3590320112,3590320112,'ae'),(3642265600,3642269696,'ae'),(3645764045,3645764045,'ae'),(3651403776,3651534848,'ae'),(3651952640,3651960832,'ae'),(3653744896,3653744960,'ae'),(982745088,982753280,'af'),(1049547296,1049547328,'af'),(1347293584,1347293592,'af'),(1347295056,1347295064,'af'),(1358400256,1358400512,'af'),(1389215232,1389215744,'af'),(1389215744,1389217792,'af'),(1389218304,1389218816,'af'),(1389218816,1389219840,'af'),(1389229568,1389229696,'af'),(1410013824,1410013888,'af'),(1410015488,1410015744,'af'),(1410027264,1410027520,'af'),(1475957760,1475958016,'af'),(1546091520,1546091648,'af'),(1966587904,1966592000,'af'),(1969807360,1969809408,'af'),(2000375808,2000377856,'af'),(2033885184,2033887232,'af'),(2036609024,2036611072,'af'),(2038374400,2038382592,'af'),(2111160320,2111168512,'af'),(3392712704,3392716800,'af'),(3394637824,3394641920,'af'),(3417185024,3417185280,'af'),(3419873280,3419877376,'af'),(3528458240,3528474624,'af'),(3564431568,3564431584,'af'),(3641353984,3641354240,'af'),(3653472280,3653472288,'af'),(3653472288,3653472292,'af'),(1160921088,1160925184,'ag'),(1161420800,1161428992,'ag'),(1280090112,1280098304,'ag'),(3495120896,3495122944,'ag'),(3510321152,3510337536,'ag'),(3649709296,3649709312,'ag'),(3423533056,3423535104,'ai'),(3493998592,3494000640,'ai'),(1045119232,1045119488,'al'),(1045119488,1045119744,'al'),(1307709440,1307713536,'al'),(1331851264,1331853312,'al'),(1332346880,1332412416,'al'),(1336619008,1336621056,'al'),(1347305472,1347309568,'al'),(1348096000,1348100096,'al'),(1348169728,1348173824,'al'),(1361037876,1361037880,'al'),(1410613248,1410621440,'al'),(1432255488,1432256512,'al'),(1547440128,1547444224,'al'),(1566195712,1566199808,'al'),(3252439552,3252439584,'al'),(3254649088,3254649344,'al'),(3254649344,3254649856,'al'),(3254883584,3254883840,'al'),(3583337728,3583337984,'al'),(3583338816,3583338832,'al'),(3583339520,3583340032,'al'),(3583340032,3583340288,'al'),(3583341040,3583341056,'al'),(3583341056,3583341312,'al'),(3587121152,3587129344,'al'),(3587290368,3587290432,'al'),(3587291968,3587292032,'al'),(3642290176,3642294272,'al'),(1042300224,1042300256,'am'),(1046020096,1046028288,'am'),(1298118656,1298120704,'am'),(1315782656,1315786752,'am'),(1336592384,1336594432,'am'),(1347870720,1347874816,'am'),(1357372928,1357373184,'am'),(1364840448,1364844544,'am'),(1401618432,1401634816,'am'),(1406787584,1406795776,'am'),(1407547912,1407547920,'am'),(1438876160,1438876416,'am'),(1438880256,1438880512,'am'),(1438883584,1438883840,'am'),(1438884864,1438885888,'am'),(1475444736,1475461120,'am'); INSERT INTO `country` VALUES (1509539840,1509543936,'am'),(1533483008,1533485056,'am'),(1533491200,1533493248,'am'),(1539580928,1539581952,'am'),(1539766016,1539766272,'am'),(1539778048,1539778304,'am'),(1539826176,1539826432,'am'),(1546356736,1546358784,'am'),(1566496768,1566498816,'am'),(3251143168,3251143424,'am'),(3253265408,3253265920,'am'),(3259226624,3259227136,'am'),(3275509888,3275509920,'am'),(3282749184,3282749440,'am'),(3287957504,3287965696,'am'),(3559571456,3559579648,'am'),(3561570304,3561578496,'am'),(3584412160,3584412416,'am'),(3587186944,3587187200,'am'),(3590309544,3590309552,'am'),(3590321920,3590321928,'am'),(3648061440,3648069632,'am'),(3653404136,3653404144,'am'),(3653404752,3653404760,'am'),(3653404984,3653404992,'am'),(3653405120,3653405136,'am'),(1426855808,1426855936,'an'),(3187834880,3187851264,'an'),(3187949568,3187953664,'an'),(3187965952,3187974144,'an'),(3193438208,3193454592,'an'),(3193503744,3193569280,'an'),(3194355712,3194359808,'an'),(3199795200,3199811584,'an'),(3262478632,3262478632,'an'),(3272086976,3272087040,'an'),(3278945028,3278945032,'an'),(3278945532,3278945536,'an'),(3281359072,3281359104,'an'),(3288535040,3288539136,'an'),(3355850752,3355852800,'an'),(3355873280,3355875328,'an'),(3355910144,3355918336,'an'),(3355949056,3355951104,'an'),(3357196288,3357212672,'an'),(3360159744,3360161792,'an'),(3363602432,3363610624,'an'),(3386392576,3386408960,'an'),(3386638336,3386642432,'an'),(3386777600,3386781696,'an'),(3560947356,3560947360,'an'),(3633881088,3633885184,'an'),(701308928,701317120,'ao'),(701677568,701693952,'ao'),(702410752,702414848,'ao'),(702475264,702476288,'ao'),(702478336,702480384,'ao'),(702480384,702481408,'ao'),(702490624,702491648,'ao'),(702505984,702507008,'ao'),(702520320,702521344,'ao'),(702522368,702523392,'ao'),(1043895984,1043896000,'ao'),(1317668344,1317668352,'ao'),(1347979328,1347979336,'ao'),(1347980072,1347980080,'ao'),(1407519016,1407519024,'ao'),(1407519032,1407519040,'ao'),(1407519040,1407519048,'ao'),(1407520728,1407520736,'ao'),(1407534392,1407534400,'ao'),(1407536920,1407536928,'ao'),(1407536928,1407536936,'ao'),(1407536944,1407536952,'ao'),(1407539088,1407539096,'ao'),(1407542608,1407542616,'ao'),(1407547184,1407547192,'ao'),(1407547208,1407547216,'ao'),(1546090880,1546091008,'ao'),(3252425472,3252425536,'ao'),(3252425536,3252425544,'ao'),(3253469184,3253471232,'ao'),(3262478121,3262478121,'ao'),(3262478347,3262478347,'ao'),(3272085504,3272086016,'ao'),(3272086528,3272086656,'ao'),(3272086832,3272086848,'ao'),(3272086848,3272086880,'ao'),(3272087296,3272087552,'ao'),(3278939592,3278939596,'ao'),(3278939756,3278939760,'ao'),(3290284032,3290288128,'ao'),(3290480640,3290482688,'ao'),(3291324416,3291325440,'ao'),(3291367424,3291369472,'ao'),(3301637120,3301638144,'ao'),(3302949120,3302949376,'ao'),(3585837568,3585838080,'ao'),(3585838080,3585838144,'ao'),(3585838248,3585838256,'ao'),(3585838272,3585838280,'ao'),(3585838296,3585838304,'ao'),(3590309512,3590309520,'ao'),(3590309576,3590309584,'ao'),(3590316096,3590316128,'ao'),(3590322024,3590322032,'ao'),(3590322400,3590322416,'ao'),(3641355264,3641355520,'ao'),(3642028320,3642028328,'ao'),(3651696640,3651698688,'ao'),(1438892032,1438908416,'aq'),(417857536,417923072,'ar'),(1111228416,1111244800,'ar'),(1310247088,1310247104,'ar'),(1310248664,1310248672,'ar'),(1383239296,1383239424,'ar'),(2361327616,2361393152,'ar'),(2640052224,2640117760,'ar'),(2713583616,2713649152,'ar'),(2735341568,2735407104,'ar'),(2818310144,2818375680,'ar'),(2824011776,2824077312,'ar'),(2824863744,2824929280,'ar'),(2825191424,2825256960,'ar'),(2833383424,2833448960,'ar'),(2855469056,2855534592,'ar'),(2862284800,2862350336,'ar'),(2865889280,2865954816,'ar'),(3187736576,3187752960,'ar'),(3187802112,3187818496,'ar'),(3187826688,3187830784,'ar'),(3187867648,3187900416,'ar'),(3187900416,3187908608,'ar'),(3187998720,3188006912,'ar'),(3188088832,3188092928,'ar'),(3188129792,3188146176,'ar'); INSERT INTO `country` VALUES (3188187136,3188191232,'ar'),(3188195328,3188199424,'ar'),(3188260864,3188264960,'ar'),(3188400128,3188404224,'ar'),(3188416512,3188420608,'ar'),(3188424704,3188432896,'ar'),(3188441088,3188445184,'ar'),(3188482048,3188490240,'ar'),(3188506624,3188523008,'ar'),(3188580352,3188584448,'ar'),(3188588544,3188596736,'ar'),(3188604928,3188621312,'ar'),(3188629504,3188633600,'ar'),(3188678656,3188682752,'ar'),(3188703232,3188711424,'ar'),(3188719616,3188981760,'ar'),(3189637120,3189768192,'ar'),(3190816768,3191078912,'ar'),(3191275520,3191308288,'ar'),(3191308288,3191324672,'ar'),(3193733120,3193749504,'ar'),(3194028032,3194036224,'ar'),(3194126336,3194134528,'ar'),(3196583936,3196846080,'ar'),(3198943232,3199205376,'ar'),(3199205376,3199336448,'ar'),(3199467520,3199500288,'ar'),(3199500288,3199516672,'ar'),(3199664128,3199696896,'ar'),(3199991808,3200253952,'ar'),(3201433600,3201449984,'ar'),(3201826816,3201892352,'ar'),(3202088960,3202121728,'ar'),(3202351104,3202613248,'ar'),(3203661824,3203792896,'ar'),(3238239712,3238239744,'ar'),(3262473016,3262473020,'ar'),(3262473690,3262473692,'ar'),(3262475308,3262475312,'ar'),(3262476132,3262476136,'ar'),(3262476352,3262476356,'ar'),(3262476548,3262476552,'ar'),(3262477248,3262477252,'ar'),(3262477448,3262477452,'ar'),(3273055232,3273055488,'ar'),(3278939148,3278939152,'ar'),(3278939264,3278939272,'ar'),(3278939292,3278939296,'ar'),(3278939316,3278939320,'ar'),(3278941284,3278941288,'ar'),(3278941344,3278941348,'ar'),(3278941440,3278941444,'ar'),(3278941848,3278941856,'ar'),(3278944347,3278944347,'ar'),(3278944361,3278944361,'ar'),(3278944390,3278944390,'ar'),(3278944538,3278944538,'ar'),(3278944560,3278944560,'ar'),(3278944580,3278944580,'ar'),(3278944655,3278944655,'ar'),(3278944656,3278944658,'ar'),(3278944660,3278944660,'ar'),(3278944664,3278944666,'ar'),(3278944668,3278944668,'ar'),(3278944688,3278944688,'ar'),(3278944736,3278944736,'ar'),(3278944755,3278944755,'ar'),(3278944764,3278944764,'ar'),(3278944820,3278944824,'ar'),(3278945128,3278945132,'ar'),(3278945172,3278945176,'ar'),(3278945204,3278945208,'ar'),(3278945268,3278945272,'ar'),(3278945324,3278945328,'ar'),(3278945396,3278945400,'ar'),(3278945432,3278945436,'ar'),(3278945508,3278945512,'ar'),(3278945512,3278945516,'ar'),(3278945536,3278945540,'ar'),(3278945580,3278945584,'ar'),(3278945660,3278945664,'ar'),(3278945700,3278945704,'ar'),(3278945724,3278945728,'ar'),(3290447872,3290456064,'ar'),(3325142016,3325142272,'ar'),(3354955776,3354956032,'ar'),(3355447552,3355447808,'ar'),(3355463424,3355463680,'ar'),(3355463680,3355463936,'ar'),(3355467776,3355468800,'ar'),(3355488000,3355488256,'ar'),(3355489536,3355489792,'ar'),(3355489792,3355490304,'ar'),(3355490304,3355492352,'ar'),(3355492352,3355494400,'ar'),(3355494400,3355494656,'ar'),(3355496448,3355498496,'ar'),(3355500544,3355508736,'ar'),(3355516928,3355525120,'ar'),(3355538432,3355538944,'ar'),(3355538944,3355539200,'ar'),(3355566080,3355574272,'ar'),(3355604992,3355607040,'ar'),(3355648000,3355656192,'ar'),(3355656192,3355664384,'ar'),(3355664384,3355668480,'ar'),(3355668480,3355668992,'ar'),(3355669248,3355669504,'ar'),(3355669504,3355670528,'ar'),(3355670528,3355672576,'ar'),(3355682816,3355684864,'ar'),(3355686912,3355688960,'ar'),(3355695104,3355697152,'ar'),(3355720448,3355720704,'ar'),(3355779072,3355781120,'ar'),(3355783168,3355785216,'ar'),(3355787264,3355803648,'ar'),(3355820032,3355836416,'ar'),(3355871232,3355873280,'ar'),(3355934720,3355938816,'ar'),(3355947008,3355949056,'ar'),(3356052224,3356052480,'ar'),(3356070656,3356070912,'ar'),(3356082688,3356082944,'ar'),(3356086272,3356086528,'ar'),(3356087296,3356087808,'ar'),(3356089088,3356089344,'ar'),(3356091136,3356091392,'ar'),(3356093184,3356093440,'ar'),(3356093440,3356093952,'ar'),(3356094976,3356095488,'ar'),(3356095488,3356096000,'ar'),(3356096000,3356096256,'ar'),(3356097792,3356098048,'ar'),(3356098048,3356098304,'ar'); INSERT INTO `country` VALUES (3356123136,3356131328,'ar'),(3356131328,3356131840,'ar'),(3356134144,3356134400,'ar'),(3356134400,3356134656,'ar'),(3356139776,3356140032,'ar'),(3356146176,3356146432,'ar'),(3356148736,3356148992,'ar'),(3356149504,3356149760,'ar'),(3356150016,3356150272,'ar'),(3356150272,3356150528,'ar'),(3356150784,3356151040,'ar'),(3356151552,3356151808,'ar'),(3356154624,3356154880,'ar'),(3356192768,3356194816,'ar'),(3356263680,3356263936,'ar'),(3356263936,3356264448,'ar'),(3356264448,3356264960,'ar'),(3356264960,3356265216,'ar'),(3356269056,3356269312,'ar'),(3356280832,3356282880,'ar'),(3356284928,3356286976,'ar'),(3356305664,3356305920,'ar'),(3356495872,3356499968,'ar'),(3356508160,3356508672,'ar'),(3356510208,3356511232,'ar'),(3356511232,3356511744,'ar'),(3356511744,3356512000,'ar'),(3356512256,3356514304,'ar'),(3356516352,3356520448,'ar'),(3356521472,3356521728,'ar'),(3356522496,3356524544,'ar'),(3356524544,3356557312,'ar'),(3357077504,3357081600,'ar'),(3357147136,3357179904,'ar'),(3357194240,3357196288,'ar'),(3357407232,3357409280,'ar'),(3357474816,3357483008,'ar'),(3357532160,3357536256,'ar'),(3357540352,3357573120,'ar'),(3357573120,3357581312,'ar'),(3358130176,3358195712,'ar'),(3358195712,3358228480,'ar'),(3358228480,3358236672,'ar'),(3358261248,3358326784,'ar'),(3358392320,3358457856,'ar'),(3358523392,3358588928,'ar'),(3358654464,3358658560,'ar'),(3358660608,3358662656,'ar'),(3358666752,3358670848,'ar'),(3358670848,3358687232,'ar'),(3358687232,3358695424,'ar'),(3358703616,3358711808,'ar'),(3358711808,3358715904,'ar'),(3358717952,3358720000,'ar'),(3358760960,3358769152,'ar'),(3358781440,3358785536,'ar'),(3358785536,3358851072,'ar'),(3359047680,3359080448,'ar'),(3359272960,3359277056,'ar'),(3359309824,3359313920,'ar'),(3359318016,3359326208,'ar'),(3359326208,3359342592,'ar'),(3359342592,3359350784,'ar'),(3359350784,3359354880,'ar'),(3359358976,3359363072,'ar'),(3359367168,3359371264,'ar'),(3359440896,3359473664,'ar'),(3359481856,3359490048,'ar'),(3359490048,3359498240,'ar'),(3359571968,3359580160,'ar'),(3359580160,3359582208,'ar'),(3359584256,3359586304,'ar'),(3359588352,3359596544,'ar'),(3359604736,3359621120,'ar'),(3359916032,3359932416,'ar'),(3359948800,3359965184,'ar'),(3359965184,3359981568,'ar'),(3359981568,3359989760,'ar'),(3359997952,3360006144,'ar'),(3360014336,3360030720,'ar'),(3360030720,3360096256,'ar'),(3360153600,3360157696,'ar'),(3360256000,3360258048,'ar'),(3360260096,3360276480,'ar'),(3360702464,3360710656,'ar'),(3360718848,3360751616,'ar'),(3360751616,3360759808,'ar'),(3360759808,3360763904,'ar'),(3360768000,3360776192,'ar'),(3360776192,3360780288,'ar'),(3360784384,3360788480,'ar'),(3360792576,3360796672,'ar'),(3360800768,3360817152,'ar'),(3360817152,3360849920,'ar'),(3361038336,3361046528,'ar'),(3361308672,3361325056,'ar'),(3362324480,3362340864,'ar'),(3362340864,3362349056,'ar'),(3362484224,3362486272,'ar'),(3362506752,3362508800,'ar'),(3362512896,3362514944,'ar'),(3362537472,3362545664,'ar'),(3362693120,3362695168,'ar'),(3362697216,3362701312,'ar'),(3362701312,3362703360,'ar'),(3362705408,3362709504,'ar'),(3362709504,3362711552,'ar'),(3362816000,3362832384,'ar'),(3362947072,3362979840,'ar'),(3362979840,3362983936,'ar'),(3363028992,3363045376,'ar'),(3363110912,3363176448,'ar'),(3363438592,3363471360,'ar'),(3363520512,3363536896,'ar'),(3363536896,3363553280,'ar'),(3363553280,3363557376,'ar'),(3363651584,3363667968,'ar'),(3363733504,3363766272,'ar'),(3363766272,3363831808,'ar'),(3386114048,3386245120,'ar'),(3386425344,3386441728,'ar'),(3386589184,3386597376,'ar'),(3386679296,3386683392,'ar'),(3386728448,3386732544,'ar'),(3387359232,3387424768,'ar'),(3387555840,3387686912,'ar'),(3388604416,3388735488,'ar'),(3388735488,3388997632,'ar'),(3507290112,3507355648,'ar'),(3512983552,3512987648,'ar'),(3558368016,3558368032,'ar'),(3558368240,3558368256,'ar'),(3558368320,3558368384,'ar'),(3560944164,3560944168,'ar'),(3560944316,3560944320,'ar'); INSERT INTO `country` VALUES (3560944320,3560944324,'ar'),(3560944364,3560944368,'ar'),(3560944376,3560944380,'ar'),(3560944460,3560944460,'ar'),(3560944476,3560944480,'ar'),(3560945728,3560945732,'ar'),(3560945748,3560945752,'ar'),(3560945764,3560945768,'ar'),(3560945792,3560945796,'ar'),(3560945816,3560945820,'ar'),(3560946190,3560946190,'ar'),(3560946199,3560946199,'ar'),(3560946230,3560946230,'ar'),(3560946238,3560946238,'ar'),(3560946260,3560946260,'ar'),(3560946263,3560946263,'ar'),(3560946344,3560946344,'ar'),(3560946500,3560946504,'ar'),(3560946588,3560946592,'ar'),(3560946604,3560946608,'ar'),(3560946644,3560946648,'ar'),(3560946717,3560946717,'ar'),(3560946964,3560946968,'ar'),(3560947016,3560947020,'ar'),(3560947068,3560947072,'ar'),(3560947276,3560947280,'ar'),(3560947400,3560947408,'ar'),(3560947412,3560947416,'ar'),(3639918592,3639934976,'ar'),(3393613824,3393617920,'as'),(3557597712,3557597720,'as'),(1041088512,1041096704,'at'),(1041945088,1041945152,'at'),(1042841600,1042874368,'at'),(1043202048,1043333120,'at'),(1043350588,1043350592,'at'),(1043609280,1043609344,'at'),(1045138432,1045138464,'at'),(1046298624,1046315008,'at'),(1046708224,1046740992,'at'),(1047560764,1047560768,'at'),(1047566848,1047566852,'at'),(1047566868,1047566872,'at'),(1047567040,1047567044,'at'),(1047567164,1047567168,'at'),(1047567316,1047567320,'at'),(1047567452,1047567456,'at'),(1047567876,1047567880,'at'),(1047789568,1047822336,'at'),(1048844352,1048844384,'at'),(1049370624,1049378816,'at'),(1049405632,1049405696,'at'),(1049768176,1049768192,'at'),(1049771904,1049771968,'at'),(1049776696,1049776704,'at'),(1049778536,1049778544,'at'),(1049785000,1049785008,'at'),(1050625960,1050625968,'at'),(1051852800,1051918336,'at'),(1051949312,1051949568,'at'),(1052257792,1052258304,'at'),(1052260632,1052260640,'at'),(1052272544,1052272576,'at'),(1052275200,1052275712,'at'),(1052278832,1052278848,'at'),(1052288304,1052288320,'at'),(1052288512,1052289024,'at'),(1052310784,1052311040,'at'),(1052315104,1052315136,'at'),(1052325200,1052325216,'at'),(1052331616,1052331648,'at'),(1052335552,1052335616,'at'),(1052340224,1052340480,'at'),(1052340480,1052340512,'at'),(1052340512,1052340528,'at'),(1052340736,1052340768,'at'),(1052340864,1052340992,'at'),(1052340992,1052341248,'at'),(1052341504,1052341760,'at'),(1052341760,1052342272,'at'),(1052345536,1052345552,'at'),(1052345728,1052345856,'at'),(1052358496,1052358512,'at'),(1052401312,1052401344,'at'),(1052405760,1052406784,'at'),(1052406784,1052407296,'at'),(1052407296,1052407424,'at'),(1052407424,1052407488,'at'),(1052407488,1052407520,'at'),(1052407552,1052407808,'at'),(1052407808,1052407840,'at'),(1052407936,1052408064,'at'),(1052408064,1052408128,'at'),(1052408128,1052408160,'at'),(1052408576,1052408832,'at'),(1052417088,1052417120,'at'),(1052427872,1052427904,'at'),(1052438528,1052439040,'at'),(1052439040,1052439296,'at'),(1052439296,1052439424,'at'),(1052439424,1052439488,'at'),(1052439488,1052439504,'at'),(1052439520,1052439552,'at'),(1052453376,1052453888,'at'),(1052457984,1052458240,'at'),(1052458240,1052458368,'at'),(1052458432,1052458496,'at'),(1052487424,1052487680,'at'),(1052490752,1052491264,'at'),(1052491264,1052491520,'at'),(1052491520,1052491648,'at'),(1052491648,1052491680,'at'),(1052491688,1052491696,'at'),(1052491696,1052491712,'at'),(1052491712,1052491776,'at'),(1053294848,1053295104,'at'),(1053295392,1053295424,'at'),(1053295424,1053295456,'at'),(1053295456,1053295472,'at'),(1053295616,1053296640,'at'),(1053339648,1053340160,'at'),(1054121984,1054130176,'at'),(1054474240,1054539776,'at'),(1054969032,1054969040,'at'),(1056522240,1056538624,'at'),(1296605184,1296607232,'at'),(1296715776,1296717824,'at'),(1296723968,1296726016,'at'),(1296764928,1296766976,'at'),(1297608704,1297610752,'at'),(1299447808,1299709952,'at'),(1306288128,1306296320,'at'),(1307262976,1307271168,'at'),(1307385856,1307394048,'at'),(1307721728,1307725824,'at'); /*!40000 ALTER TABLE `country` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40111 SET [EMAIL PROTECTED] */; -- Dump completed on 2008-04-20 5:31:09
drop table if exists tmpcountry; CREATE TABLE `tmpcountry` ( `id` int unsigned NOT NULL auto_increment, `ip_line` linestring NOT NULL, `low` int unsigned NOT NULL, `high` int unsigned NOT NULL, `country` char(2) NOT NULL default '-', PRIMARY KEY (`id`), SPATIAL INDEX (`ip_line`) ); INSERT INTO tmpcountry (low,high,country,ip_line) SELECT low, high, country, LineString(POINT(low,0), POINT(high,0)) FROM country;
477072.tar.bz2
Description: Binary data
