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

Some storage_engine tests fail on 10.1

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1
    • Fix Version/s: 10.1.7
    • Component/s: Tests
    • Labels:
      None

      Description

      Both InnoDB plugin and XtraDB

      storage_engine-innobase.foreign_keys     [ fail ]
              Test ended at 2015-08-24 15:27:02
       
      CURRENT_TEST: storage_engine-innobase.foreign_keys
      --- c:/buildbot/bbwin2/win-rqg-se/build-debug/mysql-test/suite/storage_engine/foreign_keys.result	2015-08-24 15:07:02.223385300 -0700
      +++ c:\buildbot\bbwin2\win-rqg-se\build-debug\mysql-test\suite\storage_engine\foreign_keys.reject	2015-08-24 15:27:02.155382300 -0700
      @@ -35,6 +35,14 @@
       1	a
       DROP TABLE t1;
       ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails
      +# ERROR: Statement ended with errno 1451, errname ER_ROW_IS_REFERENCED_2 (expected results: ER_ROW_IS_REFERENCED)
      +# ------------ UNEXPECTED RESULT ------------
      +# The statement|command finished with ER_ROW_IS_REFERENCED_2.
      +# Foreign keys or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors. 
      +# You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def.
      +# Further in this test, the message might sometimes be suppressed; a part of the test might be skipped.
      +# Also, this problem may cause a chain effect (more errors of different kinds in the test).
      +# -------------------------------------------
       DROP TABLE t2;
       CREATE TABLE t2 (a <INT_COLUMN>, 
       b <CHAR_COLUMN>,
       
      mysqltest: Result length mismatch

      InnoDB, XtraDB, MyISAM

      storage_engine-innobase.type_spatial     [ fail ]
              Test ended at 2015-08-24 15:31:38
       
      CURRENT_TEST: storage_engine-innobase.type_spatial
      --- c:/buildbot/bbwin2/win-rqg-se/build-debug/mysql-test/suite/storage_engine/type_spatial.result	2015-08-24 15:07:03.299795400 -0700
      +++ c:\buildbot\bbwin2\win-rqg-se\build-debug\mysql-test\suite\storage_engine\type_spatial.reject	2015-08-24 15:31:37.700754100 -0700
      @@ -412,12 +412,12 @@
       Intersects(g1.g, g2.g) as i, Crosses(g1.g, g2.g) as r
       FROM gis_geometrycollection g1, gis_geometrycollection g2 ORDER BY first, second;
       first	second	w	c	o	e	d	t	i	r
      -120	120	1	1	0	1	0	1	1	0
      +120	120	1	1	0	1	0	0	1	0
       120	121	0	0	1	0	0	0	1	0
       120	122	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
       120	123	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
       121	120	0	0	1	0	0	0	1	0
      -121	121	1	1	0	1	0	1	1	0
      +121	121	1	1	0	1	0	0	1	0
       121	122	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
       121	123	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
       122	120	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
       
      mysqltest: Result content mismatch

      MyISAM

      storage_engine-myisam.type_spatial_indexes [ fail ]
              Test ended at 2015-08-24 15:51:10
       
      CURRENT_TEST: storage_engine-myisam.type_spatial_indexes
      --- c:/buildbot/bbwin2/win-rqg-se/build-debug/mysql-test/suite/storage_engine/type_spatial_indexes.result	2015-08-24 15:07:03.299795400 -0700
      +++ c:\buildbot\bbwin2\win-rqg-se\build-debug\mysql-test\suite\storage_engine\type_spatial_indexes.reject	2015-08-24 15:51:10.207694900 -0700
      @@ -412,12 +412,12 @@
       Intersects(g1.g, g2.g) as i, Crosses(g1.g, g2.g) as r
       FROM gis_geometrycollection g1, gis_geometrycollection g2 ORDER BY first, second;
       first	second	w	c	o	e	d	t	i	r
      -120	120	1	1	0	1	0	1	1	0
      +120	120	1	1	0	1	0	0	1	0
       120	121	0	0	1	0	0	0	1	0
       120	122	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
       120	123	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
       121	120	0	0	1	0	0	0	1	0
      -121	121	1	1	0	1	0	1	1	0
      +121	121	1	1	0	1	0	0	1	0
       121	122	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
       121	123	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
       122	120	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      @@ -1112,22 +1112,22 @@
       Intersects(g1.g, g2.g) as i, Crosses(g1.g, g2.g) as r
       FROM gis_geometrycollection g1, gis_geometrycollection g2 ORDER BY first, second;
       first	second	w	c	o	e	d	t	i	r
      -120	120	1	1	0	1	0	1	1	0
      +120	120	1	1	0	1	0	0	1	0
       120	121	0	0	1	0	0	0	1	0
      -120	122	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      -120	123	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      +120	122	1	1	0	1	0	0	1	0
      +120	123	1	1	0	1	0	0	1	0
       121	120	0	0	1	0	0	0	1	0
      -121	121	1	1	0	1	0	1	1	0
      -121	122	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      -121	123	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      -122	120	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      -122	121	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      -122	122	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      -122	123	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      -123	120	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      -123	121	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      -123	122	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      -123	123	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
      +121	121	1	1	0	1	0	0	1	0
      +121	122	1	1	0	1	0	0	1	0
      +121	123	1	1	0	1	0	0	1	0
      +122	120	0	0	1	0	0	0	1	0
      +122	121	1	1	0	1	0	0	1	0
      +122	122	1	1	0	1	0	0	1	0
      +122	123	1	1	0	1	0	0	1	0
      +123	120	0	0	1	0	0	0	1	0
      +123	121	1	1	0	1	0	0	1	0
      +123	122	1	1	0	1	0	0	1	0
      +123	123	1	1	0	1	0	0	1	0
       DROP TABLE gis_point, gis_line, gis_polygon, gis_multi_point, gis_multi_line, gis_multi_polygon, gis_geometrycollection, gis_geometry;
       USE gis_ogs;
       # Lakes
       
      mysqltest: Result length mismatch

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                elenst Elena Stepanova
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: