dm-geokit blows up with dm-mysql-adapter

[ghost]

Hi,

dm-geokit tries to push through some raw SQL to calculate the *_distance column. The dm-mysql-adapter quotes and truncates what it believes to be a column name, meaning the query fails. This is a monkey patch to fix it:

DataMapper::Adapters::MysqlAdapter::SQL.module_eval do
  def quote_name(name)
    if name.include? '('
      name
    else
      "`#{name[0, self.class::IDENTIFIER_MAX_LENGTH].gsub('`', '``')}`"
    end
  end
end

You may want to check for the existence of dm-mysql-adapter and add this if found.

[dodeja]

I have the same issue while using Postgres. Any pointers?