Hi, Holyfoot! On Feb 20, holyfoot@askmonty.org wrote:

revno: 3663 revision-id: holyfoot@askmonty.org-20130220195237-99gp9p29xemltqcm parent: vvaintroub@pcbsd-20130219224652-t84v8wepdqvhxfwb committer: Alexey Botchkov <holyfoot@askmonty.org> branch nick: mdev-3819 timestamp: Wed 2013-02-20 23:52:37 +0400 message: MDEV-3819 missing constraints for spatial column types. Checks added to return and error when inappropriate geometry type is stored in a field.

=== modified file 'mysql-test/r/gis.result' --- a/mysql-test/r/gis.result 2012-09-05 21:14:33 +0000 +++ b/mysql-test/r/gis.result 2013-02-20 19:52:37 +0000 @@ -1491,4 +1491,11 @@ SELECT 1 FROM g1 WHERE a >= ANY (SELECT 1 FROM g1 WHERE a = geomfromtext('') OR a) ; 1 DROP TABLE g1; +# +# MDEV-3819 missing constraints for spatial column types +# +create table t1 (pt point); +insert into t1 values(Geomfromtext('POLYGON((1 1, 2 2, 2 1, 1 1))')); +ERROR HY000: Incorrect POLYGON value: 'POINT'

I'm sorry, but you got it backwards :) The value above is POLYGON. The type is POINT. The error message should be ERROR HY000: Incorrect POINT value: 'POLYGON' Regards, Sergei