mysql/core_cities_merge.sql
authorEdward <edward@roojs.com>
Fri, 27 Jun 2014 07:27:35 +0000 (15:27 +0800)
committerEdward <edward@roojs.com>
Fri, 27 Jun 2014 07:27:35 +0000 (15:27 +0800)
mysql/core_cities_merge.sql

index 98d40a5..1698d3d 100644 (file)
@@ -218,7 +218,7 @@ CREATE FUNCTION core_cities_merge_city()  RETURNS INT DETERMINISTIC
                 IF v_type_tmp = 'RE' THEN
                     IF v_in_location_tmp != 0 THEN
 
-                        SELECT iso INTO v_iso_tmp FROM meta_location WHERE id = v_in_location;
+                        SELECT iso INTO v_iso_tmp FROM meta_location WHERE id = v_in_location_tmp;
 
                         SELECT id INTO v_country_id FROM core_geoip_country WHERE code = v_iso_tmp;