summaryrefslogtreecommitdiff
path: root/tests/phpunit/data/db/mysql/functions.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tests/phpunit/data/db/mysql/functions.sql')
-rw-r--r--tests/phpunit/data/db/mysql/functions.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/tests/phpunit/data/db/mysql/functions.sql b/tests/phpunit/data/db/mysql/functions.sql
new file mode 100644
index 00000000..9e5e470f
--- /dev/null
+++ b/tests/phpunit/data/db/mysql/functions.sql
@@ -0,0 +1,12 @@
+-- MySQL test file for DatabaseTest::testStoredFunctions()
+
+DELIMITER //
+
+CREATE FUNCTION mw_test_function()
+RETURNS int DETERMINISTIC
+BEGIN
+ SET @foo = 21;
+ RETURN @foo * 2;
+END//
+
+DELIMITER //