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

index dfa89ec..6b44305 100644 (file)
@@ -482,6 +482,8 @@ CREATE FUNCTION core_city_blocks_mapping()  RETURNS INT DETERMINISTIC
         
         SELECT COUNT(DISTINCT(geoname_id)) INTO v_total FROM city_blocks WHERE geoname_id != 0  AND network_start_ip REGEXP '::ffff:[0-9]+.[0-9]+.[0-9]+.[0-9]+$';
 
+        SELECT v_total;
+
         SET v_count = 0;
 
         OPEN csr;