From: Alan Knowles Date: Tue, 24 Feb 2015 08:07:29 +0000 (+0800) Subject: mysql/core_cities_merge.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=c268982534277d7208f80b8742977c0b50567e73 mysql/core_cities_merge.sql --- 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;