summaryrefslogtreecommitdiff
path: root/ext/pdo_sqlite/tests
diff options
context:
space:
mode:
authorNikita Popov <nikita.ppv@gmail.com>2017-03-12 17:04:02 +0100
committerNikita Popov <nikita.ppv@gmail.com>2017-03-12 17:04:02 +0100
commite31342ef843f98523722b2d37ea23190bf2781af (patch)
tree90012a557646b3a69617c1579b4ef0c4463269b4 /ext/pdo_sqlite/tests
parent22e6b5ef220345bb187c93a293ee436a80f897d1 (diff)
parentfbf0e0587f8455525466e6d4ab2c1f0fc24bfe26 (diff)
downloadphp-git-e31342ef843f98523722b2d37ea23190bf2781af.tar.gz
Merge branch 'PHP-7.1'
Diffstat (limited to 'ext/pdo_sqlite/tests')
-rw-r--r--ext/pdo_sqlite/tests/pdo_sqlite_createfunction_with_flags.phpt38
1 files changed, 38 insertions, 0 deletions
diff --git a/ext/pdo_sqlite/tests/pdo_sqlite_createfunction_with_flags.phpt b/ext/pdo_sqlite/tests/pdo_sqlite_createfunction_with_flags.phpt
new file mode 100644
index 0000000000..4f0b6754a1
--- /dev/null
+++ b/ext/pdo_sqlite/tests/pdo_sqlite_createfunction_with_flags.phpt
@@ -0,0 +1,38 @@
+--TEST--
+PDO_sqlite: Testing sqliteCreateFunction() with flags
+--SKIPIF--
+<?php if (!extension_loaded('pdo_sqlite')) print 'skip not loaded'; ?>
+--FILE--
+<?php
+
+$db = new pdo('sqlite::memory:');
+
+$db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
+
+$db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
+$db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
+
+
+$db->sqliteCreateFunction('testing', function($v) { return strtolower($v); }, 1, PDO::SQLITE_DETERMINISTIC);
+
+
+foreach ($db->query('SELECT testing(name) FROM foobar') as $row) {
+ var_dump($row);
+}
+
+$db->query('DROP TABLE foobar');
+
+?>
+--EXPECTF--
+array(2) {
+ ["testing(name)"]=>
+ string(3) "php"
+ [0]=>
+ string(3) "php"
+}
+array(2) {
+ ["testing(name)"]=>
+ string(4) "php6"
+ [0]=>
+ string(4) "php6"
+}