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

main.analyze_format_json, main.analyze_stmt_orderby can fail with a mismatch

Details

    • 10.1.29

    Description

      Reported in the email thread.
      I'm not getting it on my machine, but the reason is obvious:

      main.analyze_format_json                 w4 [ fail ]
              Test ended at 2017-01-21 16:23:31
       
      CURRENT_TEST: main.analyze_format_json
      --- /usr/share/mysql-test/r/analyze_format_json.result  2017-01-17 20:38:20.000000000 +0100
      +++ /usr/share/mysql-test/r/analyze_format_json.reject  2017-01-21 16:23:31.740853974 +0100
      @@ -455,7 +455,7 @@
                     "r_loops": 1,
                     "rows": 10,
                     "r_rows": 10,
      -              "r_total_time_ms": "REPLACED",
      +              "r_total_time_ms": "REPLACED"e-4,
                     "filtered": 100,
                     "r_filtered": 20,
                     "attached_condition": "(tbl2.a in (2,3))"
       
      mysqltest: Result length mismatch
      

      main.analyze_stmt_orderby 'xtradb'       w4 [ fail ]
              Test ended at 2017-01-21 18:43:58
       
      CURRENT_TEST: main.analyze_stmt_orderby
      --- /usr/share/mysql-test/r/analyze_stmt_orderby.result 2017-01-17 20:38:20.000000000 +0100
      +++ /usr/share/mysql-test/r/analyze_stmt_orderby.reject 2017-01-21 18:43:58.130938437 +0100
      @@ -417,7 +417,7 @@
                   "r_loops": 1,
                   "rows": 10,
                   "r_rows": 10,
      -            "r_total_time_ms": "REPLACED",
      +            "r_total_time_ms": "REPLACED"e-3,
                   "filtered": 100,
                   "r_filtered": 100
                 },
      @@ -486,7 +486,7 @@
                       "r_loops": 1,
                       "rows": 7,
                       "r_rows": 7,
      -                "r_total_time_ms": "REPLACED",
      +                "r_total_time_ms": "REPLACED"e-4,
                       "filtered": 100,
                       "r_filtered": 100
                     },
       
      mysqltest: Result length mismatch
      

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Description Reported in the email thread.
            I'm not getting it on my machine, but the reason is obvious:
            {noformat}
            main.analyze_format_json w4 [ fail ]
                    Test ended at 2017-01-21 16:23:31

            CURRENT_TEST: main.analyze_format_json
            --- /usr/share/mysql-test/r/analyze_format_json.result 2017-01-17 20:38:20.000000000 +0100
            +++ /usr/share/mysql-test/r/analyze_format_json.reject 2017-01-21 16:23:31.740853974 +0100
            @@ -455,7 +455,7 @@
                           "r_loops": 1,
                           "rows": 10,
                           "r_rows": 10,
            - "r_total_time_ms": "REPLACED",
            + "r_total_time_ms": "REPLACED"e-4,
                           "filtered": 100,
                           "r_filtered": 20,
                           "attached_condition": "(tbl2.a in (2,3))"

            mysqltest: Result length mismatch
            {noformat}
            Reported in the email thread.
            I'm not getting it on my machine, but the reason is obvious:
            {noformat}
            main.analyze_format_json w4 [ fail ]
                    Test ended at 2017-01-21 16:23:31

            CURRENT_TEST: main.analyze_format_json
            --- /usr/share/mysql-test/r/analyze_format_json.result 2017-01-17 20:38:20.000000000 +0100
            +++ /usr/share/mysql-test/r/analyze_format_json.reject 2017-01-21 16:23:31.740853974 +0100
            @@ -455,7 +455,7 @@
                           "r_loops": 1,
                           "rows": 10,
                           "r_rows": 10,
            - "r_total_time_ms": "REPLACED",
            + "r_total_time_ms": "REPLACED"e-4,
                           "filtered": 100,
                           "r_filtered": 20,
                           "attached_condition": "(tbl2.a in (2,3))"

            mysqltest: Result length mismatch
            {noformat}
            {noformat}
            main.analyze_stmt_orderby 'xtradb' w4 [ fail ]
                    Test ended at 2017-01-21 18:43:58

            CURRENT_TEST: main.analyze_stmt_orderby
            --- /usr/share/mysql-test/r/analyze_stmt_orderby.result 2017-01-17 20:38:20.000000000 +0100
            +++ /usr/share/mysql-test/r/analyze_stmt_orderby.reject 2017-01-21 18:43:58.130938437 +0100
            @@ -417,7 +417,7 @@
                         "r_loops": 1,
                         "rows": 10,
                         "r_rows": 10,
            - "r_total_time_ms": "REPLACED",
            + "r_total_time_ms": "REPLACED"e-3,
                         "filtered": 100,
                         "r_filtered": 100
                       },
            @@ -486,7 +486,7 @@
                             "r_loops": 1,
                             "rows": 7,
                             "r_rows": 7,
            - "r_total_time_ms": "REPLACED",
            + "r_total_time_ms": "REPLACED"e-4,
                             "filtered": 100,
                             "r_filtered": 100
                           },

            mysqltest: Result length mismatch
            {noformat}
            elenst Elena Stepanova made changes -
            Summary main.analyze_format_json can fail with a mismatch main.analyze_format_json, main.analyze_stmt_orderby can fail with a mismatch
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            Labels contribution patch
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Sergei Petrunia [ psergey ]
            elenst Elena Stepanova made changes -
            Comment [ Same happens in main.cte_recursive:
            http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-quantal-amd64/builds/4582/steps/test/logs/stdio
            {noformat}
            main.cte_recursive w3 [ fail ]
                    Test ended at 2017-01-29 20:16:34

            CURRENT_TEST: main.cte_recursive
            --- /usr/local/mariadb-10.2.4-linux-x86_64/mysql-test/r/cte_recursive.result 2017-01-29 19:32:09.000000000 +0200
            +++ /usr/local/mariadb-10.2.4-linux-x86_64/mysql-test/r/cte_recursive.reject 2017-01-29 20:16:34.377172490 +0200
            @@ -2364,7 +2364,7 @@
                   "r_loops": 1,
                   "rows": 2,
                   "r_rows": 10,
            - "r_total_time_ms": "REPLACED",
            + "r_total_time_ms": "REPLACED"e-4,
                   "filtered": 100,
                   "r_filtered": 100,
                   "materialized": {

            mysqltest: Result length mismatch
            {noformat} ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.2 [ 14601 ]
            elenst Elena Stepanova made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            elenst Elena Stepanova made changes -
            Affects Version/s 10.2 [ 14601 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Petrunia [ psergey ] Varun Gupta [ varun ]
            serg Sergei Golubchik made changes -
            Sprint 10.1.29 [ 202 ]
            varun Varun Gupta (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            varun Varun Gupta (Inactive) made changes -
            issue.field.resolutiondate 2017-11-02 07:21:17.0 2017-11-02 07:21:17.657
            varun Varun Gupta (Inactive) made changes -
            Fix Version/s 10.1.22 [ 22502 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 79311 ] MariaDB v4 [ 151576 ]

            People

              varun Varun Gupta (Inactive)
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.