From 1503a4724e9bd65826cf7547240c4e03f773d2a0 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 17 May 2002 16:45:00 +0300 Subject: Optimize LIKE with turbo-boyer-more algoritm Docs/manual.texi: Added info about LIKE optimization mysql-test/r/func_like.result: Test of new LIKE optimization mysql-test/t/func_like.test: Test of new LIKE optimization --- sql/unireg.h | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'sql/unireg.h') diff --git a/sql/unireg.h b/sql/unireg.h index c4d2052d1da..5a61f4a6c12 100644 --- a/sql/unireg.h +++ b/sql/unireg.h @@ -122,6 +122,13 @@ bfill((A)->null_flags,(A)->null_bytes,255);\ #define TE_INFO_LENGTH 3 #define MTYP_NOEMPTY_BIT 128 +/* + * Minimum length pattern before Turbo Boyer-Moore is used + * for SELECT "text" LIKE "%pattern%", excluding the two + * wildcards in class Item_func_like. + */ +#define MIN_TURBOBM_PATTERN_LEN 3 + /* Include prototypes for unireg */ #include "mysqld_error.h" -- cgit v1.2.1