Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-6348

Columnstore basic MTRs mcs*_win_* fail

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 23.02.19
    • 23.02.19
    • Tests
    • None

    Description

      example of the failure https://server-test.mariadb.net/?product_ids=2&show_skipped_results=false&only_last_commits=false&time_interval=-1&test_name=&commit_id=&columnstore_commit_id=&target_name=lower_table_name-combined&runs_with_additional_tools=false&currentTestResultId=407708490&currentTestCaseId=20617&currentTargetBuildId=15645

      mysqltest: At line 39: query 'SELECT a, b, AVG(b) OVER(PARTITION BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) avg FROM t1' failed: ER_RANGE_FRAME_NEEDS_SIMPLE_ORDERBY (4019): RANGE-type frame requires ORDER BY clause with single sort key
      
      

      List of failed tests:

      columnstore/basic.mcs152_win_frame_avg	
      columnstore/basic.mcs153_win_frame_bit_and	
      columnstore/basic.mcs154_win_frame_bit_or	
      columnstore/basic.mcs155_win_frame_bit_xor	
      columnstore/basic.mcs156_win_frame_count	
      columnstore/basic.mcs157_win_frame_lead	
      columnstore/basic.mcs158_win_frame_max	
      columnstore/basic.mcs159_win_frame_min	
      columnstore/basic.mcs161_win_frame_std	
      columnstore/basic.mcs162_win_frame_stddev	
      columnstore/basic.mcs163_win_frame_stddev_pop	
      columnstore/basic.mcs164_win_frame_stddev_samp	
      columnstore/basic.mcs165_win_frame_sum	
      columnstore/basic.mcs166_win_frame_var_pop	
      columnstore/basic.mcs167_win_frame_var_samp	
      columnstore/basic.mcs168_win_frame_variance	
      
      

      Attachments

        Issue Links

          Activity

            People

              tturenko Timofey Turenko
              tturenko Timofey Turenko
              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.