mdocml: Pass the function flags SQLITE_UTF8 (because SQLITE_ANY is

mdocml: Pass the function flags SQLITE_UTF8 (because SQLITE_ANY is

[schwarze]

Log Message:
-----------
Pass the function flags SQLITE_UTF8 (because SQLITE_ANY is deprecated)
and SQLITE_DETERMINISTIC when creating deterministic functions;
best practice measure suggested by espie@ and jeremy@;
as expected by jeremy@, no measurable effect on performance.

Modified Files:
--------------
    mdocml:
        mansearch.c

Revision Data
-------------
Index: mansearch.c
===================================================================
RCS file: /usr/vhosts/mdocml.bsd.lv/cvs/mdocml/mansearch.c,v
retrieving revision 1.30
retrieving revision 1.31
diff -Lmansearch.c -Lmansearch.c -u -p -r1.30 -r1.31
--- mansearch.c
+++ mansearch.c
@@ -253,10 +253,12 @@ mansearch(const struct mansearch *search
 		 */
 
 		c = sqlite3_create_function(db, "match", 2,
-		    SQLITE_ANY, NULL, sql_match, NULL, NULL);
+		    SQLITE_UTF8 | SQLITE_DETERMINISTIC,
+		    NULL, sql_match, NULL, NULL);
 		assert(SQLITE_OK == c);
 		c = sqlite3_create_function(db, "regexp", 2,
-		    SQLITE_ANY, NULL, sql_regexp, NULL, NULL);
+		    SQLITE_UTF8 | SQLITE_DETERMINISTIC,
+		    NULL, sql_regexp, NULL, NULL);
 		assert(SQLITE_OK == c);
 
 		j = 1;
--
 To unsubscribe send an email to source+unsubscribe@mdocml.bsd.lv