diff options
| author | Ingo Schwarze <schwarze@cvs.openbsd.org> | 2014-04-16 00:33:25 +0000 |
|---|---|---|
| committer | Ingo Schwarze <schwarze@cvs.openbsd.org> | 2014-04-16 00:33:25 +0000 |
| commit | 619a5d821016af71a6143349efa3b6f6a5a51814 (patch) | |
| tree | 6d50988c60f2f9415df79bb37c29ca3a004384e5 /usr.bin | |
| parent | 6c1876ab0a19fd8d65086cb8860c3a25784cc8d2 (diff) | |
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.
Diffstat (limited to 'usr.bin')
| -rw-r--r-- | usr.bin/mandoc/mansearch.c | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/usr.bin/mandoc/mansearch.c b/usr.bin/mandoc/mansearch.c index a419542524f..5447bf35ef4 100644 --- a/usr.bin/mandoc/mansearch.c +++ b/usr.bin/mandoc/mansearch.c @@ -1,4 +1,4 @@ -/* $Id: mansearch.c,v 1.20 2014/04/15 23:47:57 schwarze Exp $ */ +/* $Id: mansearch.c,v 1.21 2014/04/16 00:33:24 schwarze Exp $ */ /* * Copyright (c) 2012 Kristaps Dzonsons <kristaps@bsd.lv> * Copyright (c) 2013, 2014 Ingo Schwarze <schwarze@openbsd.org> @@ -245,10 +245,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; |