From c268982534277d7208f80b8742977c0b50567e73 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 24 Feb 2015 16:07:29 +0800 Subject: [PATCH] mysql/core_cities_merge.sql --- mysql/core_cities_merge.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/mysql/core_cities_merge.sql b/mysql/core_cities_merge.sql index 2ab88a66..0c520bfa 100644 --- a/mysql/core_cities_merge.sql +++ b/mysql/core_cities_merge.sql @@ -371,7 +371,9 @@ CREATE FUNCTION core_country_blocks() RETURNS INT DETERMINISTIC SET v_count = 0; OPEN csr; + read_loop: LOOP + FETCH csr INTO v_network_start_ip,v_network_mask_length,v_geoname_id,v_is_anonymous_proxy,v_is_satellite_provider; SET v_count = v_count + 1; -- 2.39.2