707
707
area(b) IS NULL, glength(b) IS NULL, srid(b) IS NULL, x(b) IS NULL,
710
geometryfromtext(b) IS NULL geometryfromwkb(b) IS NULL astext(b) IS NULL aswkb(b) IS NULL geometrytype(b) IS NULL centroid(b) IS NULL envelope(b) IS NULL startpoint(b) IS NULL endpoint(b) IS NULL exteriorring(b) IS NULL pointn(b, 1) IS NULL geometryn(b, 1) IS NULL interiorringn(b, 1) IS NULL multipoint(b) IS NULL isempty(b) IS NULL issimple(b) IS NULL isclosed(b) IS NULL dimension(b) IS NULL numgeometries(b) IS NULL numinteriorrings(b) IS NULL numpoints(b) IS NULL area(b) IS NULL glength(b) IS NULL srid(b) IS NULL x(b) IS NULL y(b) IS NULL
711
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
712
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
713
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
710
ERROR 22007: Illegal non geometric '`test`.`t1`.`b`' value found during parsing
715
712
within(b, b) IS NULL, contains(b, b) IS NULL, overlaps(b, b) IS NULL,
716
713
equals(b, b) IS NULL, disjoint(b, b) IS NULL, touches(b, b) IS NULL,
967
961
DROP TABLE t1, t2;
964
# Test for bug #58650 "Failing assertion: primary_key_no == -1 ||
965
# primary_key_no == 0".
967
drop table if exists t1;
968
# The minimal test case.
969
create table t1 (a int not null, b linestring not null, unique key b (b(12)), unique key a (a));
971
# The original test case.
972
create table t1 (a int not null, b linestring not null, unique key b (b(12)));
973
create unique index a on t1(a);
969
975
create table `t1` (`col002` point)engine=myisam;
970
976
insert into t1 values (),(),();
971
977
select min(`col002`) from t1 union select `col002` from t1;
1012
1018
SELECT MultiPoint(12345,'');
1013
MultiPoint(12345,'')
1015
SELECT MultiPoint(123451,'');
1016
MultiPoint(123451,'')
1018
SELECT MultiPoint(1234512,'');
1019
MultiPoint(1234512,'')
1021
SELECT MultiPoint(12345123,'');
1022
MultiPoint(12345123,'')
1024
SELECT MultiLineString(12345,'');
1025
MultiLineString(12345,'')
1027
SELECT MultiLineString(123451,'');
1028
MultiLineString(123451,'')
1030
SELECT MultiLineString(1234512,'');
1031
MultiLineString(1234512,'')
1033
SELECT MultiLineString(12345123,'');
1034
MultiLineString(12345123,'')
1036
SELECT LineString(12345,'');
1037
LineString(12345,'')
1039
SELECT LineString(123451,'');
1040
LineString(123451,'')
1042
SELECT LineString(1234512,'');
1043
LineString(1234512,'')
1045
SELECT LineString(12345123,'');
1046
LineString(12345123,'')
1048
SELECT Polygon(12345,'');
1051
SELECT Polygon(123451,'');
1054
SELECT Polygon(1234512,'');
1057
SELECT Polygon(12345123,'');
1058
Polygon(12345123,'')
1019
ERROR 22007: Illegal non geometric '12345' value found during parsing
1020
SELECT 1 FROM (SELECT GREATEST(1,GEOMETRYCOLLECTION('00000','00000')) b FROM DUAL) AS d WHERE (LINESTRING(d.b));
1021
ERROR 22007: Illegal non geometric ''00000'' value found during parsing
1023
# BUG#51875: crash when loading data into geometry function polyfromwkb
1025
SET @a=0x00000000030000000100000000000000000000000000144000000000000014400000000000001840000000000000184000000000000014400000000000001440;
1026
SET @a=POLYFROMWKB(@a);
1027
SET @a=0x00000000030000000000000000000000000000000000144000000000000014400000000000001840000000000000184000000000000014400000000000001440;
1028
SET @a=POLYFROMWKB(@a);
1029
create table t1(a polygon NOT NULL)engine=myisam;
1030
insert into t1 values (geomfromtext("point(0 1)"));
1031
insert into t1 values (geomfromtext("point(1 0)"));
1032
select * from (select polygon(t1.a) as p from t1 order by t1.a) d;
1038
# Test for bug #59888 "debug assertion when attempt to create spatial index
1039
# on char > 31 bytes".
1041
create table t1(a char(32) not null) engine=myisam;
1042
create spatial index i on t1 (a);
1043
ERROR HY000: Incorrect arguments to SPATIAL INDEX
1045
CREATE TABLE t0 (a BINARY(32) NOT NULL);
1046
CREATE SPATIAL INDEX i on t0 (a);
1047
ERROR HY000: Incorrect arguments to SPATIAL INDEX
1048
INSERT INTO t0 VALUES (1);
1050
col0 BINARY NOT NULL,
1052
SPATIAL INDEX i1 (col0)
1054
ERROR HY000: Incorrect arguments to SPATIAL INDEX
1056
col0 BINARY NOT NULL,
1059
CREATE SPATIAL INDEX idx0 ON t1(col0);
1060
ERROR HY000: Incorrect arguments to SPATIAL INDEX
1061
ALTER TABLE t1 ADD SPATIAL INDEX i1 (col0);
1062
ERROR HY000: Incorrect arguments to SPATIAL INDEX
1064
col0 INTEGER NOT NULL,
1068
CREATE SPATIAL INDEX idx0 ON t2 (col1, col2);
1069
ERROR HY000: Incorrect arguments to SPATIAL INDEX
1071
col0 INTEGER NOT NULL,
1074
SPATIAL INDEX i1 (col1, col2)
1076
ERROR HY000: Incorrect arguments to SPATIAL INDEX
1077
DROP TABLE t0, t1, t2;
1060
1078
End of 5.1 tests