[MCOL-4693] ColumnStore MTR tests: FUNCTION mcs192_db.CORR does not exist Created: 2021-04-22  Updated: 2021-05-27  Resolved: 2021-04-22

Status: Closed
Project: MariaDB ColumnStore
Component/s: mtr
Affects Version/s: 5.6.1, 6.1.1
Fix Version/s: 5.6.1

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MCOL-4659 Server MTR failures on ColumnStore tests Open
Relates
relates to MCOL-4736 Fix cross-engine mtr tests to run wit... Closed

 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


Generated at Thu Feb 08 02:52:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.