Error when updating a model with a POINT type in MySQL

[camcima]

When you create a table with the POINT data type in MySQL, Phalcon model manager throws an error when you update an instance of the model saying that the POINT field is required.

Steps to reproduce:

SQL Script

CREATE TABLE `robots` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `location` point NOT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `robots` (`name`, `location`) VALUES ('Robot 1', GeomFromText('POINT(10 10)'));

PHP Code

<?php

use Phalcon\DI,
    Phalcon\Db\Adapter\Pdo\Mysql as Connection,
    Phalcon\Mvc\Model\Manager as ModelsManager,
    Phalcon\Mvc\Model\Metadata\Memory as MetaData,
    Phalcon\Mvc\Model;

$di = new DI();

//Setup a connection
$di->set('db', new Connection(array(
    "host" => "localhost",
    "username" => "root",
    "password" => "admin",
    "dbname" => "testdb"
)));

//Set a models manager
$di->set('modelsManager', new ModelsManager());

//Use the memory meta-data adapter or other
$di->set('modelsMetadata', new MetaData());

class Robots extends Model
{

}
//Use the model
$robot = Robots::findFirst(1);
$robot->name = 'New Name';
if ($robot->update() == false) {
    foreach ($robot->getMessages() as $message) {
        echo $message;
    }
}

Result

location is required

Note: If you change the data type to GEOMETRY, it works flawlessly.

[dreamsxin]

        if (phalcon_memnstr_str(column_type, SL("int"))) {
                phalcon_array_update_string_long(&definition, SL("type"), 0, PH_SEPARATE);
                phalcon_array_update_string(&definition, SL("isNumeric"), &PHALCON_GLOBAL(z_true), PH_COPY | PH_SEPARATE);
                phalcon_array_update_string_long(&definition, SL("bindType"), 1, PH_SEPARATE);
                break;
            }

$robot = Robots::findFirst(1);      
$robot->name = 'New Name2';
$robot->point = new \Phalcon\Db\RawValue("GeomFromText('POINT(10 10)')");

I will fix it.

[ghost]

Can this be closed?