Menu

#1209 GEOMETRY (mysql) column type support in editor

Snapshot
open
nobody
5
2015-07-03
2015-07-03
G.Dimitrov
No

I try to edit table (mysql) that contains column/s of Geometry types, but I received error.

  1. create test table:

    CREATE TABLE geo_test (
    id int(11) NOT NULL AUTO_INCREMENT,
    test VARCHAR(10) DEFAULT NULL,
    geo_point point DEFAULT NULL,
    PRIMARY KEY (id)
    ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ;

  2. insert row from GUI, enter value only in column test

  3. 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(*) from test.geo_test WHERE 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>

Discussion


Log in to post a comment.

Monday.com Logo