702
704
# Bug#44684: valgrind reports invalid reads in
703
705
# Item_func_spatial_collection::val_str
707
--error ER_ILLEGAL_VALUE_FOR_TYPE
705
708
SELECT MultiPoint(12345,'');
706
SELECT MultiPoint(123451,'');
707
SELECT MultiPoint(1234512,'');
708
SELECT MultiPoint(12345123,'');
710
SELECT MultiLineString(12345,'');
711
SELECT MultiLineString(123451,'');
712
SELECT MultiLineString(1234512,'');
713
SELECT MultiLineString(12345123,'');
715
SELECT LineString(12345,'');
716
SELECT LineString(123451,'');
717
SELECT LineString(1234512,'');
718
SELECT LineString(12345123,'');
720
SELECT Polygon(12345,'');
721
SELECT Polygon(123451,'');
722
SELECT Polygon(1234512,'');
723
SELECT Polygon(12345123,'');
709
#SELECT MultiPoint(123451,'');
710
#SELECT MultiPoint(1234512,'');
711
#SELECT MultiPoint(12345123,'');
713
--error ER_ILLEGAL_VALUE_FOR_TYPE
714
#SELECT MultiLineString(12345,'');
715
#SELECT MultiLineString(123451,'');
716
#SELECT MultiLineString(1234512,'');
717
#SELECT MultiLineString(12345123,'');
719
--error ER_ILLEGAL_VALUE_FOR_TYPE
720
#SELECT LineString(12345,'');
721
#SELECT LineString(123451,'');
722
#SELECT LineString(1234512,'');
723
#SELECT LineString(12345123,'');
725
--error ER_ILLEGAL_VALUE_FOR_TYPE
726
#SELECT Polygon(12345,'');
727
#SELECT Polygon(123451,'');
728
#SELECT Polygon(1234512,'');
729
#SELECT Polygon(12345123,'');
732
# Bug55531 crash with conversions of geometry types / strings
734
--error ER_ILLEGAL_VALUE_FOR_TYPE
735
SELECT 1 FROM (SELECT GREATEST(1,GEOMETRYCOLLECTION('00000','00000')) b FROM DUAL) AS d WHERE (LINESTRING(d.b));
739
--echo # BUG#51875: crash when loading data into geometry function polyfromwkb
741
SET @a=0x00000000030000000100000000000000000000000000144000000000000014400000000000001840000000000000184000000000000014400000000000001440;
742
SET @a=POLYFROMWKB(@a);
743
SET @a=0x00000000030000000000000000000000000000000000144000000000000014400000000000001840000000000000184000000000000014400000000000001440;
744
SET @a=POLYFROMWKB(@a);
748
# Bug #57321 crashes and valgrind errors from spatial types
751
create table t1(a polygon NOT NULL)engine=myisam;
752
insert into t1 values (geomfromtext("point(0 1)"));
753
insert into t1 values (geomfromtext("point(1 0)"));
754
select * from (select polygon(t1.a) as p from t1 order by t1.a) d;
759
--echo # Test for bug #59888 "debug assertion when attempt to create spatial index
760
--echo # on char > 31 bytes".
762
create table t1(a char(32) not null) engine=myisam;
763
--error ER_WRONG_ARGUMENTS
764
create spatial index i on t1 (a);
769
# Bug#11767480 - SPATIAL INDEXES ON NON-SPATIAL COLUMNS CAUSE CRASHES.
771
CREATE TABLE t0 (a BINARY(32) NOT NULL);
772
--error ER_WRONG_ARGUMENTS
773
CREATE SPATIAL INDEX i on t0 (a);
774
INSERT INTO t0 VALUES (1);
776
--error ER_WRONG_ARGUMENTS
778
col0 BINARY NOT NULL,
780
SPATIAL INDEX i1 (col0)
783
# Test other ways to add indices
785
col0 BINARY NOT NULL,
789
--error ER_WRONG_ARGUMENTS
790
CREATE SPATIAL INDEX idx0 ON t1(col0);
792
--error ER_WRONG_ARGUMENTS
793
ALTER TABLE t1 ADD SPATIAL INDEX i1 (col0);
796
col0 INTEGER NOT NULL,
801
--error ER_WRONG_ARGUMENTS
802
CREATE SPATIAL INDEX idx0 ON t2 (col1, col2);
804
--error ER_WRONG_ARGUMENTS
806
col0 INTEGER NOT NULL,
809
SPATIAL INDEX i1 (col1, col2)
813
DROP TABLE t0, t1, t2;
725
815
--echo End of 5.1 tests