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

ColumnStore MTR tests: FUNCTION mcs192_db.CORR does not exist

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.6.1, 6.1.1
    • 5.6.1
    • mtr
    • None

    Description

      When I run mtr without --extern, a number of tests fail with about this output:

      mysqltest: At line 17: query 'SELECT CORR(y, x) FROM t1' failed: 1305: FUNCTION mcs192_db.CORR does not exist

      When mtr is started without --extern, it installs only the storage engine plugin, but it does not install UDFs. UDFs must be installed manually inside the test file using CREATE FUNCTION and DROP FUNCTION statements.

      For the purpose of compatibility with --extern, the CREATE FUNCTION and DROP FUNCTION statements should be executed only if the function is not yet installed.

      The full list of affected tests:

      ./mtr --force --max-test-fail=0 \
      		 
      columnstore/basic.mcs192_corr_function \
      		 
      columnstore/basic.mcs193_covar_pop_function \
      		 
      columnstore/basic.mcs194_covar_samp_function \
      		 
      columnstore/basic.mcs195_regr_avgx_avgy_function \
      		 
      columnstore/basic.mcs196_regr_sxx_sxy_syy_functions \
      		 
      columnstore/basic.mcs197_regr_count_function \
      		 
      columnstore/basic.mcs198_regr_intercept_function \
      		 
      columnstore/basic.mcs199_regr_r2_function \
      		 
      columnstore/basic.mcs200_regr_slope_function

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4659 Server MTR failures on ColumnStore tests

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4736 Fix cross-engine mtr tests to run without --extern

          • Major - Major loss of function.
          • Closed

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              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.