-- MySQL dump 10.13 Distrib 5.7.20, for osx10.12 (x86_64) -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 5.7.20 /*!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 `aa5` -- DROP TABLE IF EXISTS `aa5`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `aa5` ( `unformattedAddress` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL, `googleResponse` text COLLATE utf8mb4_unicode_ci, `parseGoogleResponseStatus` text COLLATE utf8mb4_unicode_ci, `numResults` int(11) DEFAULT NULL, `locality` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `areaLevel1` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `areaLevel2` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `areaLevel3` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `postalCode` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lat` float(10,6) DEFAULT NULL, `lng` float(10,6) DEFAULT NULL, `formattedAddress` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`unformattedAddress`), KEY `numResults` (`numResults`), KEY `googleResponse` (`googleResponse`(100)), KEY `parseGoogleResponseStatus` (`parseGoogleResponseStatus`(100)), KEY `locality` (`locality`), KEY `areaLevel1` (`areaLevel1`), KEY `areaLevel2` (`areaLevel2`), KEY `areaLevel3` (`areaLevel3`), KEY `postalCode` (`postalCode`), KEY `country` (`country`), KEY `lat` (`lat`), KEY `lng` (`lng`), KEY `formattedAddress` (`formattedAddress`), KEY `ts` (`ts`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `aa5` -- LOCK TABLES `aa5` WRITE; /*!40000 ALTER TABLE `aa5` DISABLE KEYS */; INSERT INTO `aa5` VALUES ('38-124 Wisniowa 115, PL','{\n \"results\" : [\n {\n \"address_components\" : [\n {\n \"long_name\" : \"115\",\n \"short_name\" : \"115\",\n \"types\" : [ \"premise\" ]\n },\n {\n \"long_name\" : \"Wiśniowa\",\n \"short_name\" : \"Wiśniowa\",\n \"types\" : [ \"locality\", \"political\" ]\n },\n {\n \"long_name\" : \"strzyżowski\",\n \"short_name\" : \"strzyżowski\",\n \"types\" : [ \"administrative_area_level_2\", \"political\" ]\n },\n {\n \"long_name\" : \"Województwo podkarpackie\",\n \"short_name\" : \"Województwo podkarpackie\",\n \"types\" : [ \"administrative_area_level_1\", \"political\" ]\n },\n {\n \"long_name\" : \"Poland\",\n \"short_name\" : \"PL\",\n \"types\" : [ \"country\", \"political\" ]\n },\n {\n \"long_name\" : \"38-124\",\n \"short_name\" : \"38-124\",\n \"types\" : [ \"postal_code\" ]\n }\n ],\n \"formatted_address\" : \"Wiśniowa 115, 38-124 Wiśniowa, Poland\",\n \"geometry\" : {\n \"location\" : {\n \"lat\" : 49.87012989999999,\n \"lng\" : 21.658254\n },\n \"location_type\" : \"ROOFTOP\",\n \"viewport\" : {\n \"northeast\" : {\n \"lat\" : 49.8714788802915,\n \"lng\" : 21.6596029802915\n },\n \"southwest\" : {\n \"lat\" : 49.8687809197085,\n \"lng\" : 21.6569050197085\n }\n }\n },\n \"place_id\" : \"ChIJI8j1HLGsPUcRZCduCkAlmR0\",\n \"types\" : [ \"street_address\" ]\n },\n {\n \"address_components\" : [\n {\n \"long_name\" : \"115\",\n \"short_name\" : \"115\",\n \"types\" : [ \"street_number\" ]\n },\n {\n \"long_name\" : \"Wiśniowa\",\n \"short_name\" : \"Wiśniowa\",\n \"types\" : [ \"route\" ]\n },\n {\n \"long_name\" : \"Jasło\",\n \"short_name\" : \"Jasło\",\n \"types\" : [ \"locality\", \"political\" ]\n },\n {\n \"long_name\" : \"jasielski\",\n \"short_name\" : \"jasielski\",\n \"types\" : [ \"administrative_area_level_2\", \"political\" ]\n },\n {\n \"long_name\" : \"Województwo podkarpackie\",\n \"short_name\" : \"Województwo podkarpackie\",\n \"types\" : [ \"administrative_area_level_1\", \"political\" ]\n },\n {\n \"long_name\" : \"Poland\",\n \"short_name\" : \"PL\",\n \"types\" : [ \"country\", \"political\" ]\n },\n {\n \"long_name\" : \"38\",\n \"short_name\" : \"38\",\n \"types\" : [ \"postal_code\", \"postal_code_prefix\" ]\n }\n ],\n \"formatted_address\" : \"Wiśniowa 115, Jasło, Poland\",\n \"geometry\" : {\n \"bounds\" : {\n \"northeast\" : {\n \"lat\" : 49.7390671,\n \"lng\" : 21.4787176\n },\n \"southwest\" : {\n \"lat\" : 49.7390553,\n \"lng\" : 21.478713\n }\n },\n \"location\" : {\n \"lat\" : 49.7390671,\n \"lng\" : 21.478713\n },\n \"location_type\" : \"RANGE_INTERPOLATED\",\n \"viewport\" : {\n \"northeast\" : {\n \"lat\" : 49.7404101802915,\n \"lng\" : 21.4800642802915\n },\n \"southwest\" : {\n \"lat\" : 49.7377122197085,\n \"lng\" : 21.4773663197085\n }\n }\n },\n \"partial_match\" : true,\n \"place_id\" : \"Eh1XacWbbmlvd2EgMTE1LCBKYXPFgm8sIFBvbHNrYQ\",\n \"types\" : [ \"street_address\" ]\n },\n {\n \"address_components\" : [\n {\n \"long_name\" : \"38\",\n \"short_name\" : \"38\",\n \"types\" : [ \"street_number\" ]\n },\n {\n \"long_name\" : \"Wiśniowa\",\n \"short_name\" : \"Wiśniowa\",\n \"types\" : [ \"route\" ]\n },\n {\n \"long_name\" : \"nowosolski\",\n \"short_name\" : \"nowosolski\",\n \"types\" : [ \"administrative_area_level_2\", \"political\" ]\n },\n {\n \"long_name\" : \"lubuskie\",\n \"short_name\" : \"lubuskie\",\n \"types\" : [ \"administrative_area_level_1\", \"political\" ]\n },\n {\n \"long_name\" : \"Poland\",\n \"short_name\" : \"PL\",\n \"types\" : [ \"country\", \"political\" ]\n },\n {\n \"long_name\" : \"67-115\",\n \"short_name\" : \"67-115\",\n \"types\" : [ \"postal_code\" ]\n }\n ],\n \"formatted_address\" : \"Wiśniowa 38, 67-115, Poland\",\n \"geometry\" : {\n \"bounds\" : {\n \"northeast\" : {\n \"lat\" : 51.72672679999999,\n \"lng\" : 15.7922509\n },\n \"southwest\" : {\n \"lat\" : 51.7267152,\n \"lng\" : 15.7922487\n }\n },\n \"location\" : {\n \"lat\" : 51.7267152,\n \"lng\" : 15.7922487\n },\n \"location_type\" : \"RANGE_INTERPOLATED\",\n \"viewport\" : {\n \"northeast\" : {\n \"lat\" : 51.7280699802915,\n \"lng\" : 15.7935987802915\n },\n \"southwest\" : {\n \"lat\" : 51.7253720197085,\n \"lng\" : 15.7909008197085\n }\n }\n },\n \"partial_match\" : true,\n \"place_id\" : \"EhxXacWbbmlvd2EgMzgsIDY3LTExNSwgUG9sc2th\",\n \"types\" : [ \"street_address\" ]\n },\n {\n \"address_components\" : [\n {\n \"long_name\" : \"38\",\n \"short_name\" : \"38\",\n \"types\" : [ \"street_number\" ]\n },\n {\n \"long_name\" : \"Wiśniowa\",\n \"short_name\" : \"Wiśniowa\",\n \"types\" : [ \"route\" ]\n },\n {\n \"long_name\" : \"Dolice\",\n \"short_name\" : \"Dolice\",\n \"types\" : [ \"locality\", \"political\" ]\n },\n {\n \"long_name\" : \"stargardzki\",\n \"short_name\" : \"stargardzki\",\n \"types\" : [ \"administrative_area_level_2\", \"political\" ]\n },\n {\n \"long_name\" : \"Województwo zachodniopomorskie\",\n \"short_name\" : \"Województwo zachodniopomorskie\",\n \"types\" : [ \"administrative_area_level_1\", \"political\" ]\n },\n {\n \"long_name\" : \"Poland\",\n \"short_name\" : \"PL\",\n \"types\" : [ \"country\", \"political\" ]\n },\n {\n \"long_name\" : \"73-115\",\n \"short_name\" : \"73-115\",\n \"types\" : [ \"postal_code\" ]\n }\n ],\n \"formatted_address\" : \"Wiśniowa 38, 73-115 Dolice, Poland\",\n \"geometry\" : {\n \"location\" : {\n \"lat\" : 53.1994351,\n \"lng\" : 15.2179847\n },\n \"location_type\" : \"RANGE_INTERPOLATED\",\n \"viewport\" : {\n \"northeast\" : {\n \"lat\" : 53.20078408029149,\n \"lng\" : 15.2193336802915\n },\n \"southwest\" : {\n \"lat\" : 53.1980861197085,\n \"lng\" : 15.2166357197085\n }\n }\n },\n \"partial_match\" : true,\n \"place_id\" : \"EiNXacWbbmlvd2EgMzgsIDczLTExNSBEb2xpY2UsIFBvbHNrYQ\",\n \"types\" : [ \"street_address\" ]\n }\n ],\n \"status\" : \"OK\"\n}\n',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-09-15 16:12:27'); /*!40000 ALTER TABLE `aa5` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2017-10-24 13:42:33 select 'it fails when updating the row'; update aa5 set googleResponse=null where unformattedAddress='38-124 Wisniowa 115, PL'; -- ERROR 1713 (HY000): Undo log record is too big. select 'it works if using row_format=redundant'; alter table aa5 row_format=redundant; update aa5 set googleResponse=null where unformattedAddress='38-124 Wisniowa 115, PL';