Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-40384

innodb_gis.geometry fails on replay

    XMLWordPrintable

Details

    • 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

          Activity

            People

              bsrikanth Srikanth Bondalapati
              mariadb-pavithrapandith Pavithra Pandith
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 2d
                  2d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1d 1h Time Not Required
                  1d 1h

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.