Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
Unexpected results
-
Q3/2026 Server Maintenance
Description
innodb_gis.geometry fails on replay
EXPLAIN SELECT ST_ASText(c1),ST_AsText(c2),ST_AsText(c8) FROM tab3 |
WHERE c2=ST_LineFromText('LINESTRING(10 10,20 20,30 30)'); |
-id select_type table type possible_keys key key_len ref rows Extra |
-1 SIMPLE tab3 ALL NULL NULL NULL NULL 1 Using where |
+ReplayTest: Query error: CREATE TABLE `tab3` ( |
+ `c1` point DEFAULT NULL, |
+ `c2` linestring DEFAULT NULL, |
+ `c3` polygon DEFAULT NULL, |
+ `C4` multipoint DEFAULT NULL, |
+ `c5` multilinestring DEFAULT NULL, |
+ `c6` multipolygon DEFAULT NULL, |
+ `c7` geometrycollection DEFAULT NULL, |
+ `c8` geometry DEFAULT NULL |
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=16: Can't create table `test`.`tab3` (errno: 140 "Wrong create options") |
drop table tab3; |
|
|
Result length mismatch
|
MTR testcase to repro issue: (Say example.test)
--source include/have_geometry.inc
|
--source include/have_innodb.inc
|
--source include/have_partition.inc
|
|
|
SET default_storage_engine=InnoDB; |
SET innodb_strict_mode=OFF; |
SET @save_innodb_stats_persistent=@@GLOBAL.innodb_stats_persistent; |
|
|
CREATE TABLE tab3(c1 POINT,c2 LINESTRING,c3 POLYGON,C4 MULTIPOINT,c5 MULTILINESTRING , |
c6 MULTIPOLYGON,c7 GEOMETRYCOLLECTION ,c8 GEOMETRY) ENGINE=InnoDB
|
KEY_BLOCK_SIZE=8 ROW_FORMAT=COMPRESSED;
|
|
|
ALTER TABLE tab3 KEY_BLOCK_SIZE=16 ROW_FORMAT=Dynamic; |
|
|
SET @c1=ST_PointFromText('POINT(10 10)'); |
SET @c2=ST_LineFromText('LINESTRING(10 10,20 20,30 30)'); |
SET @c3=ST_PolyFromText('POLYGON((0 0,5 5,10 10,15 15,0 0),(10 10,20 20,30 30,40 40,10 10))'); |
SET @c4=ST_MPointFromText('MULTIPOINT(0 0,5 5,10 10,20 20)'); |
SET @c5=ST_MLineFromText('MULTILINESTRING((1 1,2 2,3 3),(10 10,20 20,30 30))'); |
SET @c6=ST_MPolyFromText('MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))'); |
SET @c7=ST_GeomCollFromText('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))'); |
SET @c8=ST_GeomCollFromText('GeometryCollection(Point(1 1),LineString(2 2, 3 3))'); |
|
|
INSERT INTO tab3 VALUES(@c1,@c2,@c3,@c4,@c5,@c6,@c7,@c8); |
|
|
EXPLAIN SELECT ST_ASText(c1),ST_AsText(c2),ST_AsText(c8) FROM tab3 |
WHERE c2=ST_LineFromText('LINESTRING(10 10,20 20,30 30)'); |
drop table tab3; |
How to repro
./mtr example.test --record |
./mtr example.test --replay-server |
Attachments
Issue Links
- relates to
-
MDEV-39368 Add mtr --replay-server option to test Optimizer Context Replay
-
- In Progress
-