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

index d15e6eb..46353da 100644 (file)
@@ -114,7 +114,7 @@ CREATE FUNCTION core_cities_merge_division()  RETURNS INT DETERMINISTIC
             SET v_local_name_tmp = '';
             SET v_type_tmp = '';
 
-            IF v_in_location IS NOT NULL
+            IF v_in_location IS NOT NULL THEN
                 SELECT iso, local_name, type INTO v_iso_tmp, v_local_name_tmp, v_type_tmp FROM meta_location WHERE id = v_in_location;
 
                 SELECT id INTO v_country_id FROM core_geoip_country WHERE code = v_iso_tmp;