From 82295da1cbb8b8780637173094f99de1b14bb2e9 Mon Sep 17 00:00:00 2001 From: Ingo Schwarze Date: Wed, 16 Apr 2014 00:33:47 +0000 Subject: 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. --- mansearch.c | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'mansearch.c') diff --git a/mansearch.c b/mansearch.c index 197fddd9..957c56ec 100644 --- a/mansearch.c +++ b/mansearch.c @@ -1,4 +1,4 @@ -/* $Id: mansearch.c,v 1.30 2014/04/15 23:51:39 schwarze Exp $ */ +/* $Id: mansearch.c,v 1.31 2014/04/16 00:33:47 schwarze Exp $ */ /* * Copyright (c) 2012 Kristaps Dzonsons * Copyright (c) 2013, 2014 Ingo Schwarze @@ -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; -- cgit v1.2.3