maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxxx>]

Hi, Holyfoot!

On Feb 20, holyfoot@xxxxxxxxxxxx wrote:
> revno: 3663
> revision-id: holyfoot@xxxxxxxxxxxx-20130220195237-99gp9p29xemltqcm
> parent: vvaintroub@pcbsd-20130219224652-t84v8wepdqvhxfwb
> committer: Alexey Botchkov <holyfoot@xxxxxxxxxxxx>
> 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