aboutsummaryrefslogtreecommitdiff
path: root/src/func.c
diff options
context:
space:
mode:
authordrh <drh@noemail.net>2015-12-01 21:23:07 +0000
committerdrh <drh@noemail.net>2015-12-01 21:23:07 +0000
commit41d2e66ef3de25a0d78a79bfbb781f305842c77b (patch)
treeb55cca9e909ac260476b57faedd3e3e43fb48d88 /src/func.c
parent415afddaae95a60fea20b977b76eb6c86f902a40 (diff)
downloadsqlite-41d2e66ef3de25a0d78a79bfbb781f305842c77b.tar.gz
sqlite-41d2e66ef3de25a0d78a79bfbb781f305842c77b.zip
Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.
FossilOrigin-Name: 9e1d6d4c391ff90077f0d1cdeb567969fee9f747
Diffstat (limited to 'src/func.c')
-rw-r--r--src/func.c11
1 files changed, 11 insertions, 0 deletions
diff --git a/src/func.c b/src/func.c
index b134c1a7c..3fbd2b736 100644
--- a/src/func.c
+++ b/src/func.c
@@ -802,6 +802,17 @@ static void likeFunc(
int nPat;
sqlite3 *db = sqlite3_context_db_handle(context);
+#ifdef SQLITE_LIKE_DOESNT_MATCH_BLOBS
+ if( sqlite3_value_type(argv[0])==SQLITE_BLOB
+ || sqlite3_value_type(argv[1])==SQLITE_BLOB
+ ){
+#ifdef SQLITE_TEST
+ sqlite3_like_count++;
+#endif
+ sqlite3_result_int(context, 0);
+ return;
+ }
+#endif
zB = sqlite3_value_text(argv[0]);
zA = sqlite3_value_text(argv[1]);