From 6785911619ed4395efefa4412d7ef9938dbf698b Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Fri, 8 May 2009 08:10:28 +0000 Subject: [PATCH] Fix bogus casts - lat/lon are signed. --- db/migrate/006_tile_nodes.rb | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/db/migrate/006_tile_nodes.rb b/db/migrate/006_tile_nodes.rb index dc4755ac3..51b2502d7 100644 --- a/db/migrate/006_tile_nodes.rb +++ b/db/migrate/006_tile_nodes.rb @@ -1,3 +1,5 @@ +require 'lib/migrate' + class TileNodes < ActiveRecord::Migration def self.upgrade_table(from_table, to_table, model) begin @@ -5,8 +7,8 @@ class TileNodes < ActiveRecord::Migration INSERT INTO #{to_table} (id, latitude, longitude, user_id, visible, tags, timestamp, tile) SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000), user_id, visible, tags, timestamp, - tile_for_point(CAST(ROUND(latitude * 10000000) AS UNSIGNED), - CAST(ROUND(longitude * 10000000) AS UNSIGNED)) + tile_for_point(CAST(ROUND(latitude * 10000000) AS INTEGER), + CAST(ROUND(longitude * 10000000) AS INTEGER)) FROM #{from_table} END_SQL rescue ActiveRecord::StatementInvalid => ex -- 2.43.2