create table t1(a geometrycollection not null,spatial key(a))engine=innodb;
insert into t1(a) values( geometrycollection(multipolygon(polygon(linestring(point(-14 ,98 ), point(-14 ,98 )), linestring(point(-97 ,64 ), point(-70 ,99 ), point(-97 ,64 )), linestring(point(143851215403059150000000000000000000000 .000000 ,13040009882500140000000000000000000000 .000000 ), point(-73 ,85 ), point(-88 ,-29 )))), multipolygon(polygon(linestring(point(41 ,95 ), point(4294967298 ,2050 )), linestring(point(-61 ,85 ), point(-75 ,93 ), point(14 ,-2 ), point(1 ,84 ), point(-61 ,85 )), linestring(point(-62 ,52 ), point(39 ,5 ), point(-18 ,12 ), point(-62 ,52 ))), polygon(linestring(point(-77 ,1 ), point(66 ,61 ), point(-77 ,1 )), linestring(point(18446744073709551615 ,1125899906842622 ), point(-72 ,49 ), point(24 ,-66 ), point(82 ,73 ), point(68 ,22 ))), polygon(linestring(point(1048576 ,17179869181 ), point(-18 ,95 ), point(-90 ,-3 ), point(-33 ,82 ), point(20 ,-85 )), linestring(point(-43 ,-97 ), point(-7 ,-3 ), point(39 ,-82 ), point(-65 ,-58 ), point(-43 ,-97 )), linestring(point(44 ,-34 ), point(-69 ,58 ), point(44 ,-34 )), linestring(point(57 ,-13 ), point(-17 ,74 ), point(57 ,-13 )), linestring(point(3 ,71 ), point(-58 ,81 ), point(3 ,71 )), linestring(point(9 ,25 ), point(77 ,-71 ), point(8388607 ,67108864 ), point(46 ,46 ), point(9 ,25 )), linestring(point(98 ,-82 ), point(98 ,-82 ))))) ) ;
Got one of the listed errors
insert into t1(a) values( geometrycollection(multilinestring(linestring(point(39 ,-60 ), point(-62 ,-11 ), point(-24 ,35 ), point(54 ,1 )), linestring(point(-4 ,69 ), point(-22 ,-64 ), point(1 .694824 e+308 ,5 .688896 e+307 ), point(-33 ,-58 ), point(-64 ,-80 ), point(-15 ,-44 ), point(40 ,54 )), linestring(point(-86 ,-54 ), point(11 ,41 ), point(-46 ,-38 ), point(-21 ,-8 ), point(10 ,70 ), point(-81 ,22 ), point(-46 ,-100 )), linestring(point(-30 ,-48 ), point(50 ,58 ), point(-53 ,92 ), point(10 ,41 ), point(-46 ,-8 )), linestring(point(-65 ,34 ), point(-92 ,93 ), point(-33 ,-74 ), point(75 ,-28 )), linestring(point(25 ,-55 ), point(22 ,-10 ), point(-42 ,0 ), point(-86 ,-59 ), point(2 ,-37 ), point(63 ,-44 ), point(-55 ,-22 )), linestring(point(28 ,0 ), point(-94 ,99 ), point(-32 ,-86 )), linestring(point(9 ,-12 ), point(16 ,9 ), point(80 ,-73 )), linestring(point(6 ,-55 ), point(83 ,-4 )), linestring(point(-15 ,21 ), point(144115188075855876 ,16777212 ), point(-85 ,-31 ), point(-90 ,-50 )), linestring(point(-33 ,33 ), point(21 ,90 ), point(-89 ,32 )), linestring(point(16 ,24 ), point(73 ,-13 ), point(25 ,-48 ), point(71 ,52 ), point(-54 ,-78 ), point(-84 ,59 ), point(53 ,29 )), linestring(point(-15 ,-81 ), point(83 ,43 ), point(-71 ,33 ), point(-8 ,0 ), point(84 ,-54 ), point(-35 ,38 ), point(-10 ,-50 )), linestring(point(38 ,-50 ), point(20 ,-2 ), point(-57 ,-92 )), linestring(point(5 ,-93 ), point(231601833467477080000000000000000000000 .000000 ,51914987457169239000000000000000000000 .000000 ), point(-94 ,62 ))), point(2 ,0 )) ) ;
insert into t1(a) values( geometrycollection(multilinestring(linestring(point(80 ,-15 ), point(65 ,-57 ), point(-59 ,16 ), point(22 ,-67 )), linestring(point(20 ,-55 ), point(-38 ,-64 ), point(19 ,-53 ), point(-63 ,-36 ), point(56 ,-37 )), linestring(point(27 ,-8 ), point(-85 ,-75 ), point(4398046511106 ,2251799813685245 )), linestring(point(45 ,32 ), point(-79 ,46 ))), multilinestring(linestring(point(8 ,-4 ), point(40 ,-38 ), point(100 ,95 ), point(5 ,-80 ), point(82 ,88 )), linestring(point(-14 ,30 ), point(-94 ,51 ), point(-16 ,-29 ), point(37 ,-97 ), point(-26 ,92 )), linestring(point(32 ,34 ), point(83 ,-23 ), point(-55 ,57 ), point(-15 ,90 ), point(32 ,-50 ), point(-20 ,-73 ), point(77 ,28 )), linestring(point(4 ,88 ), point(87 ,74 ), point(-67 ,-58 )), linestring(point(5 .660747 e+307 ,6 .385657 e+307 ), point(-58 ,-15 ), point(1 .172095 e+308 ,1 .448533 e+308 )), linestring(point(-21 ,-37 ), point(-52 ,79 ), point(-16 ,-76 ), point(-65 ,-94 ), point(36 ,7 ), point(37 ,74 ), point(100 ,-57 )), linestring(point(-23 ,-82 ), point(-73 ,23 ), point(18 ,-34 )), linestring(point(20 ,-51 ), point(93 ,62 ), point(-65 ,84 )), linestring(point(-48 ,31 ), point(-69 ,-96 )), linestring(point(-5 ,78 ), point(10 ,-99 ), point(36 ,-33 )), linestring(point(-84 ,55 ), point(96 ,1 ), point(-98 ,-29 ), point(-15 ,81 ), point(-27 ,-6 ), point(58 ,-32 ), point(54 ,-16 )), linestring(point(2 ,5 ), point(2199023255553 ,8192 )), linestring(point(12 ,-78 ), point(-97 ,-83 )), linestring(point(-74 ,79 ), point(35 ,-56 ), point(50 ,95 )), linestring(point(28 ,16 ), point(-39 ,-40 ), point(48 ,-3 )), linestring(point(2199023255550 ,-65539 ), point(62 ,-25 ), point(94 ,-62 )), linestring(point(-74 ,83 ), point(-18 ,75 ), point(91 ,17 ), point(-11 ,-48 ), point(30 ,100 )), linestring(point(57 ,-13 ), point(88 ,-45 )), linestring(point(20 ,-64 ), point(-37 ,13 ), point(20 ,35 ))), point(-3 ,-4 )) ) ;
insert into t1(a) values( geometrycollection(multipolygon(polygon(linestring(point(-34 ,19 ), point(-25 ,92 ), point(61921390294166805000000000000000000000 .000000 ,319674749161701840000000000000000000000 .000000 ), point(56 ,50 ), point(-34 ,19 )), linestring(point(-26 ,-58 ), point(99 ,-50 ), point(34 ,-20 ), point(-26 ,-58 )), linestring(point(-42 ,45 ), point(-63 ,-7 ), point(5 ,-89 ), point(-97 ,36 ), point(-42 ,45 )), linestring(point(94 ,11 ), point(-71 ,4 ), point(94 ,11 )), linestring(point(16 ,25 ), point(4 ,-33 ), point(-45 ,-33 ), point(-64 ,-77 ), point(16 ,25 )), linestring(point(19 ,45 ), point(36 ,45 ), point(-83 ,-96 ), point(19 ,45 )), linestring(point(85 ,-31 ), point(-87 ,52 ), point(85 ,-31 ))), polygon(linestring(point(55 ,-88 ), point(63 ,-12 ), point(55 ,-88 )), linestring(point(-49 ,10 ), point(-49 ,10 )), linestring(point(-51 ,-32 ), point(-51 ,-32 )))), multipolygon(polygon(linestring(point(-21 ,-8 ), point(66 ,-58 ), point(100 ,-27 ), point(-21 ,-8 )), linestring(point(-29 ,-13 ), point(-29 ,-13 ))), polygon(linestring(point(91307574660224730000000000000000000000 .000000 ,101214152547755520000000000000000000000 .000000 ), point(89 ,64 ), point(77 ,87 ), point(66 ,29 ), point(-71 ,-53 )), linestring(point(38 ,-78 ), point(-43 ,-90 ), point(37 ,20 ), point(81 ,65 ), point(38 ,-78 ))), polygon(linestring(point(51 ,0 ), point(-62 ,8 ), point(-11 ,22 ), point(51 ,0 )), linestring(point(-4 ,-44 ), point(6 ,82 ), point(-19 ,-90 ), point(131 ,32 )))), point(-4 ,-7 )) ) ;
Got one of the listed errors
insert into t1(a) values( geometrycollection(point(10 ,9 ), linestring(point(2305843009213693955 ,-1125899906842621 ), point(78 ,15 )), multipoint(point(-1 ,3 ), point(4 ,-6 ))) ) ;
insert into t1(a) values( geometrycollection(polygon(linestring(point(0 ,13 ), point(-12 ,5 ), point(0 ,13 )), linestring(point(11 ,-2 ), point(6 ,6 ), point(20 ,-14 ), point(-3 ,-10 ), point(1 .330588 e+308 ,2 .666476 e+307 )), linestring(point(16382 ,67 ), point(7 ,4 )), linestring(point(2 ,7 ), point(-14 ,15 ), point(2 ,7 )), linestring(point(-14 ,12 ), point(-8 ,-8 ), point(-17 ,-2 ), point(-14 ,12 )), linestring(point(-20 ,-10 ), point(-8 ,-13 ), point(-19 ,-17 ), point(13 ,-3 ), point(-20 ,-10 )), linestring(point(-5 ,13 ), point(7 ,-9 ), point(6 ,8 ), point(-5 ,13 ))), linestring(point(-87 ,19 ), point(-64 ,51 ), point(-16 ,12 )), multipoint(point(-1 ,-10 ), point(2 ,-10 ), point(3 .670354 e+307 ,2 .501459 e+307 ))) ) ;
Got one of the listed errors
insert into t1(a) values( geometrycollection(linestring(point(85 ,-29 ), point(15 ,84 ), point(39 ,-92 ), point(-99 ,19 )), multilinestring(linestring(point(63 ,10 ), point(-47 ,95 ), point(10 ,-49 ), point(16 ,-65 ), point(-98 ,40 ), point(25 ,44 ), point(-55 ,-92 )), linestring(point(5 .266810 e+307 ,6 .648813 e+307 ), point(47 ,33 ), point(-15 ,-13 ), point(-92 ,-58 ), point(36 ,73 )), linestring(point(77 ,-56 ), point(-53 ,-10 ), point(-28 ,76 ), point(-51 ,6 ), point(51 ,-31 ), point(-95 ,81 ), point(92 ,26 )), linestring(point(-91 ,7 ), point(58 ,53 )), linestring(point(18 ,5 ), point(18 ,40 ), point(71 ,89 ), point(7 .898707 e+307 ,1 .202585 e+308 ), point(53 ,100 )), linestring(point(-60 ,-18 ), point(-10 ,-31 ), point(-6 ,-25 ), point(-57 ,-95 ), point(16 ,77 )))) ) ;
insert into t1(a) values( geometrycollection(polygon(linestring(point(-9 ,0 ), point(-17 ,-15 ), point(-9 ,0 )), linestring(point(-11 ,1 ), point(18 ,12 ), point(15 ,3 ), point(7 ,0 ), point(-11 ,1 )), linestring(point(19 ,5 ), point(19 ,5 )), linestring(point(17 ,-11 ), point(8 ,4 ), point(17 ,-11 )), linestring(point(14914539334033432000000000000000000000 .000000 ,127247994336690690000000000000000000000 .000000 ), point(-14 ,-7 ), point(13 ,-2 ))), point(-4 ,-7 ), polygon(linestring(point(-18 ,9 ), point(11 ,-1 ), point(-18 ,9 )), linestring(point(9 ,-3 ), point(9 ,-3 )), linestring(point(-7 ,-9 ), point(9 ,-11 ), point(11 ,14 ), point(1 .663324 e+308 ,1 .572127 e+308 )), linestring(point(-15 ,4 ), point(18 ,12 ), point(7 ,2 ), point(-15 ,4 )), linestring(point(-15 ,-18 ), point(-20 ,-15 ), point(1152921504606846972 ,34359738370 ))), polygon(linestring(point(-5 ,-19 ), point(-11 ,11 ), point(10 ,5 ), point(-7 ,13 ), point(-5 ,-19 )), linestring(point(-8 ,-6 ), point(-4 ,16 ), point(-8 ,-6 )), linestring(point(-6 ,-10 ), point(3 ,-12 ), point(-6 ,-10 )), linestring(point(-16 ,1 ), point(20 ,-12 ), point(-16 ,1 )), linestring(point(-8 ,5 ), point(-20 ,-4 ), point(4 ,1 ), point(-6 ,-6 ), point(-8 ,5 )), linestring(point(-8 ,-11 ), point(-5 ,-14 ), point(-8 ,-11 )), linestring(point(3 ,-16 ), point(-15 ,-13 ), point(1 .166708 e+308 ,1 .901147 e+307 ), point(-8 ,6 ), point(3 ,-16 ))), point(0 ,-5 )) ) ;
Got one of the listed errors
insert into t1(a) values( geometrycollection(linestring(point(-33 ,99 ), point(99 ,-87 ), point(38 ,-79 ), point(33 ,-39 ), point(-91 ,-8 ), point(46 ,-87 ))) ) ;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
drop table t1;
Messung V0.5 in Prozent C=20 H=100 G=72