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

Window functions tests are non-deterministic (prone to sporadic failures)

    XMLWordPrintable

Details

    Description

      All SELECTs which don't have explicit (and deterministic) ORDER BY clause should be preceded by --sorted_result. Otherwise they will produce sporadic failures, e.g.

      CURRENT_TEST: main.win
      --- /data/bld/10.2/mysql-test/r/win.result	2016-09-21 18:52:27.000000000 +0300
      +++ /data/bld/10.2/mysql-test/r/win.reject	2016-09-22 00:01:47.668443074 +0300
      @@ -86,10 +86,10 @@
       2	0	1
       3	1	3
       4	1	3
      -8	2	5
       5	2	5
       6	2	5
       7	2	5
      +8	2	5
       9	4	9
       10	4	9
       select pk, a, rank() over (order by a desc) from t2;
      @@ -98,10 +98,10 @@
       2	0	9
       3	1	7
       4	1	7
      -8	2	3
       5	2	3
       6	2	3
       7	2	3
      +8	2	3
       9	4	1
       10	4	1
       drop table t2;
      

      etc.

      Attachments

        Issue Links

          Activity

            People

              cvicentiu Vicențiu Ciorbaru
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.