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

ctype tests are non-deterministic due to missing sorting

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.2
    • 10.2.4
    • Tests
    • None

    Description

      $ perl ./mtr main.ctype_utf8 --mysqld=--log-bin --mysqld=--binlog-format=row
       
      CURRENT_TEST: main.ctype_utf8
      --- /data/bld/10.2/mysql-test/r/ctype_utf8.result	2016-12-29 16:54:17.000000000 +0200
      +++ /data/bld/10.2/mysql-test/r/ctype_utf8.reject	2017-02-08 02:26:51.523197917 +0200
      @@ -10496,8 +10496,8 @@
       Warning	1638	Non-ASCII separator arguments are not fully supported
       SELECT c1 FROM t1;
       c1
      -b
       c
      +b
       DROP TABLE t1;
      

      $ perl ./mtr main.ctype_utf8mb4 --mysqld=--log-bin --mysqld=--binlog-format=row
       
      CURRENT_TEST: main.ctype_utf8mb4
      --- /data/bld/10.2/mysql-test/r/ctype_utf8mb4.result	2016-12-29 16:54:17.000000000 +0200
      +++ /data/bld/10.2/mysql-test/r/ctype_utf8mb4.reject	2017-02-08 02:28:21.503197480 +0200
      @@ -2334,8 +2334,8 @@
       insert into t1 values (0xF2BFBFBF);
       select hex(utf8mb4) from t1;
       hex(utf8mb4)
      -F2808080
       F2BFBFBF
      +F2808080
       delete from t1;
       Testing [F4][80..8F][80..BF][80..BF]
       insert into t1 values (0xF4808080);
      @@ -2345,9 +2345,9 @@
       Warning	1366	Incorrect string value: '\xF4\x90\x80\x80' for column 'utf8mb4' at row 1
       select hex(utf8mb4) from t1;
       hex(utf8mb4)
      -F4808080
      -F48F8080
       3F
      +F48F8080
      +F4808080
       drop table t1;
       #
       # Check strnxfrm() with odd length
      

      I'm not sure why SELECT started returning rows in a different order with row binlog in 10.2 – it does not seem to happen in earlier versions – but there is no sorting for the queries, so no guarantee anyway.

      Attachments

        Activity

          People

            bar Alexander Barkov
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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