I try to edit table (mysql) that contains column/s of Geometry types, but I received error.
create test table:
CREATE TABLE
geo_test(
idint(11) NOT NULL AUTO_INCREMENT,
testVARCHAR(10) DEFAULT NULL,
geo_pointpoint DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ;
insert row from GUI, enter value only in column test
try to edit (from GUI) inserted value in column test - received error in console:
Editing led to a warning message because the number of rows that would be updated was found to be 0 instead of 1.
Here's some information about the query that was used to predict the number of rows that would be affected:
select count(*) fromtest.geo_testWHERE id = ? AND test = ? AND geo_point = ?id = ? with parameter value: "1" of type: java.lang.Integer
test = ? with parameter value: "44" of type: java.lang.String
geo_point = ? with parameter value: "<other>" of type: java.lang.String</other>