summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2014-12-16 15:31:25 +0400
committerAlexander Barkov <bar@mariadb.org>2014-12-16 15:31:25 +0400
commitea01fff5053acc6526bc995c2a3c85474c844508 (patch)
treea08dc68403291f0fd5d386e31e0baf2d6d880e3f /mysql-test/t
parent2dbd26932d0c22cb333a73262db8135779c6f098 (diff)
downloadmariadb-git-ea01fff5053acc6526bc995c2a3c85474c844508.tar.gz
Fixing test failures caused by the previous commits.
Adding "--source include/have_udf.inc" and a few "--replace" commands.
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/create_drop_binlog.test1
-rw-r--r--mysql-test/t/create_drop_udf.test6
-rw-r--r--mysql-test/t/create_or_replace_permission.test4
3 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/t/create_drop_binlog.test b/mysql-test/t/create_drop_binlog.test
index 357cf8893fc..655a54308d6 100644
--- a/mysql-test/t/create_drop_binlog.test
+++ b/mysql-test/t/create_drop_binlog.test
@@ -1,3 +1,4 @@
+--source include/have_udf.inc
--source include/have_log_bin.inc
--let $binlog_file=query_get_value(SHOW MASTER STATUS, File, 1)
diff --git a/mysql-test/t/create_drop_udf.test b/mysql-test/t/create_drop_udf.test
index cc1b0a2c51e..5908bf04e90 100644
--- a/mysql-test/t/create_drop_udf.test
+++ b/mysql-test/t/create_drop_udf.test
@@ -1,12 +1,16 @@
+--source include/have_udf.inc
+
--replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
eval CREATE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
SELECT ret FROM mysql.func WHERE name like 'metaphon';
+--replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
--error ER_UDF_EXISTS
CREATE FUNCTION metaphon RETURNS INT SONAME "$UDF_EXAMPLE_SO";
SELECT ret FROM mysql.func WHERE name like 'metaphon';
--replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
+--replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
eval CREATE FUNCTION IF NOT EXISTS metaphon RETURNS REAL SONAME "$UDF_EXAMPLE_SO";
SELECT ret FROM mysql.func WHERE name like 'metaphon';
@@ -15,6 +19,7 @@ DROP FUNCTION IF EXISTS metaphon;
eval CREATE FUNCTION IF NOT EXISTS metaphon RETURNS REAL SONAME "$UDF_EXAMPLE_SO";
SELECT ret FROM mysql.func WHERE name like 'metaphon';
+--replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
--error ER_WRONG_USAGE
eval CREATE OR REPLACE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
SELECT ret FROM mysql.func WHERE name like 'metaphon';
@@ -23,6 +28,7 @@ SELECT ret FROM mysql.func WHERE name like 'metaphon';
eval CREATE OR REPLACE FUNCTION metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
SELECT ret FROM mysql.func WHERE name like 'metaphon';
+--replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
--error ER_UDF_EXISTS
eval CREATE FUNCTION metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
SELECT metaphon('mariadb');
diff --git a/mysql-test/t/create_or_replace_permission.test b/mysql-test/t/create_or_replace_permission.test
index 32a721e9d68..22ba40f43f9 100644
--- a/mysql-test/t/create_or_replace_permission.test
+++ b/mysql-test/t/create_or_replace_permission.test
@@ -1,3 +1,4 @@
+--source include/have_udf.inc
# Grant tests not performed with embedded server
-- source include/not_embedded.inc
@@ -44,8 +45,9 @@ CREATE OR REPLACE TABLE t1(id INT);
--error ER_PROCACCESS_DENIED_ERROR
CREATE OR REPLACE PROCEDURE proc1 (OUT cnt INT) BEGIN END;
+--replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
--error ER_DBACCESS_DENIED_ERROR
-CREATE OR REPLACE FUNCTION lookup RETURNS STRING SONAME "udf_example.so";
+eval CREATE OR REPLACE FUNCTION lookup RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
--error ER_PROCACCESS_DENIED_ERROR
CREATE OR REPLACE FUNCTION hello(str char(20)) RETURNS TEXT RETURN CONCAT('Hello, ', str, '!');