Support for POINT GIS datatype about go-mysql

[siddontang]

@eLco

Could you give me your table scheme and some test data? Like how to insert, update?

[eLco]

@siddontang the scheme is like this:

CREATE TABLE `testtable` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `tag` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `userid` bigint(11) NOT NULL,
  `location` point NOT NULL,
  `disabled` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `testtable_tag_idx1` (`tag`),
  KEY `testtable_userid_idx1` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=120032 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Example of insert query:

insert into `testtable` (`tag`, `userid`, `location`) values (?,?, point(?,?))
insert into `testtable` (`tag`, `userid`, `location`) values ('party',220, point(12.0563965,55.712296))
insert into `testtable` (`tag`, `userid`, `location`) values ('fashion',221, point(30.738602,46.463898))
insert into `testtable` (`tag`, `userid`, `location`) values ('pop',422, point(35.933304,31.949997))

Example of update query:

update `testtable` set `location` = point(?,?) where userid=?
update `testtable` set `location` = point(11.339798,46.490707) where userid=134
update `testtable` set `location` = point(9.251099,45.404694) where userid=135

hope this helps.