You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-30 19:23:07 +03:00
ccd6b83be5
Also fixing the problem with missing UDFs for the affected tests. (see MCOL-4659 for details): When mtr runs without --remote, the UDFs must be installed inside the test using CREATE FUNCTION. Note, there are still more tests left with missing UDFs. They'll be fixed separately.
40 lines
1.0 KiB
Plaintext
40 lines
1.0 KiB
Plaintext
#
|
|
# Test idbExtentRelativeRid() function
|
|
# Author: Bharath, bharath.bokka@mariadb.com
|
|
#
|
|
-- source ../include/have_columnstore.inc
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcs214_db;
|
|
--enable_warnings
|
|
|
|
CREATE DATABASE mcs214_db;
|
|
USE mcs214_db;
|
|
|
|
CREATE TABLE t1(col1 INT, col2 INT, col3 CHAR(8)) ENGINE=Columnstore;
|
|
--replace_result $MTR_SUITE_DIR MTR_SUITE_DIR
|
|
--eval LOAD DATA LOCAL infile '$MTR_SUITE_DIR/../std_data/100Krows.dat' INTO TABLE t1 FIELDS TERMINATED BY '|';
|
|
SELECT COUNT(*) FROM t1;
|
|
|
|
let $func_exists=`SELECT COUNT(*) FROM mysql.func WHERE name='idbextentrelativerid'`;
|
|
--disable_query_log
|
|
if (!$func_exists)
|
|
{
|
|
CREATE FUNCTION idbextentrelativerid RETURNS INTEGER SONAME "ha_columnstore.so";
|
|
}
|
|
--enable_query_log
|
|
|
|
SELECT idbExtentRelativeRid(col1) FROM t1 WHERE col1=2 LIMIT 1;
|
|
SELECT idbExtentRelativeRid(col2) FROM t1 WHERE col1=2 LIMIT 1;
|
|
SELECT idbExtentRelativeRid(col3) FROM t1 WHERE col1=2 LIMIT 1;
|
|
|
|
--disable_query_log
|
|
if (!$func_exists)
|
|
{
|
|
DROP FUNCTION idbextentrelativerid;
|
|
}
|
|
--enable_query_log
|
|
|
|
# Clean UP
|
|
DROP DATABASE mcs214_db;
|