From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B5C042F481 for ; Thu, 8 Nov 2018 10:09:33 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id jDJwM9PXA9F7 for ; Thu, 8 Nov 2018 10:09:33 -0500 (EST) Received: from smtp41.i.mail.ru (smtp41.i.mail.ru [94.100.177.101]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id D3F742F47E for ; Thu, 8 Nov 2018 10:09:32 -0500 (EST) From: Nikita Tatunov Message-Id: <6F5AC823-3016-4918-A588-6BB6B621B777@tarantool.org> Content-Type: multipart/alternative; boundary="Apple-Mail=_41F4AC4A-0EB2-469F-822B-109B35798A76" Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.1\)) Subject: [tarantool-patches] Re: [PATCH 2/2] sql: remove GLOB from Tarantool Date: Thu, 8 Nov 2018 18:09:23 +0300 In-Reply-To: <20181029121529.2d6ccnh5qayiz7ld@tkn_work_nb> References: <4607dc428909e96915e9f0984a7733a0890a3185.1534436836.git.n.tatunov@tarantool.org> <76466086-2a5f-8f12-cbc3-4ddf26e30fd9@tarantool.org> <32D1E5EA-EA21-4E4B-B5F5-80B6578BFBED@tarantool.org> <3f8354cb-4a47-c3de-164b-c776c792b991@tarantool.org> <090683CD-6F88-492D-AF48-631220A24E36@tarantool.org> <20181021034805.alwhmkpz3fbopqjz@tkn_work_nb> <20181029121529.2d6ccnh5qayiz7ld@tkn_work_nb> Sender: tarantool-patches-bounce@freelists.org Errors-to: tarantool-patches-bounce@freelists.org Reply-To: tarantool-patches@freelists.org List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: tarantool-patches List-subscribe: List-owner: List-post: List-archive: To: tarantool-patches@freelists.org Cc: korablev@tarantool.org, Alexander Turenko --Apple-Mail=_41F4AC4A-0EB2-469F-822B-109B35798A76 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hello! thank you for the review. Issues: https://github.com/tarantool/tarantool/issues/3251 = https://github.com/tarantool/tarantool/issues/3334 = Branch: = https://github.com/tarantool/tarantool/tree/N_Tatunov/gh-3251-where-like-h= angs = Please consider following changes: 1. I rebased the whole branch on fresh 2.1. > On Oct 29, 2018, at 15:15, Alexander Turenko = wrote: >=20 > Hi! >=20 > See remaining comments below. >=20 > WBR, Alexander Turenko. >=20 >>>> +static const int case_insensitive_like =3D 1; >>>> +static const int case_sensitive_like =3D 0; >>>=20 >>> Are not they are mutually exclusive? Can we leave just one? >>>=20 >>> Why they are not defines? >>=20 >> I guess it=E2=80=99s a bad idea since we need pointers to them in = some functions. >> e.g: >>=20 >> int *is_like_ci; >> if (is_case_sensitive) >> is_like_ci =3D (void *)&case_sensitive_like; >> else >> is_like_ci =3D (void *)&case_insensitive_like; >> sqlite3CreateFunc(db, "LIKE", 2, 0, is_like_ci, likeFunc, 0, 0, = 0); >> sqlite3CreateFunc(db, "LIKE", 3, 0, is_like_ci, likeFunc, 0, 0, = 0); >=20 > I think we can use SQLITE_INT_TO_PTR and SQLITE_PTR_TO_INT to pass an > integer value as a pointer and then cast it back. Maybe we also should > change LIKEFUNC macro. >=20 >>>> + int *is_like_ci; >>>> + if (is_case_sensitive) >>>> + is_like_ci =3D (int *)&case_sensitive_like; >>>> + else >>>> + is_like_ci =3D (int *)&case_insensitive_like; >>>=20 >>> Discarding const qualifier? It seems not being right thing to do. It = is >>> better to define is_like_ci pointer as const. >>=20 >> It=E2=80=99s not possible due to so-called =E2=80=9Cdown = qualification=E2=80=9D and will cause >> compiler warnings. >=20 > We'll anyway discard it here or there, so nevermind. I proposed to > change it to SQLITE_INT_TO_PTR. >=20 2. Changed manipulations with =E2=80=9Csensitiveness=E2=80=9D of LIKE = using your advice thus there=E2=80=99s no static consts in func.c anymore. diff with the previous version of the patch: diff --git a/src/box/sql/func.c b/src/box/sql/func.c index b1983e594..5feab52f6 100644 --- a/src/box/sql/func.c +++ b/src/box/sql/func.c @@ -627,18 +627,6 @@ total_changes(sqlite3_context * context, int = NotUsed, sqlite3_value ** NotUsed2) #define SQL_END_OF_STRING 0xffff #define SQL_INVALID_UTF8_SYMBOL 0xfffd =20 -/** - * If SQLITE_CASE_SENSITIVE_LIKE is not defined, then the LIKE - * operator is not case sensitive. - */ -static const int case_insensitive_like =3D 1; - -/** - * If SQLITE_CASE_SENSITIVE_LIKE is defined, then the LIKE - * operator is case sensitive causing 'a' LIKE 'A' to be false. - */ -static const int case_sensitive_like =3D 0; - /** * Possible error returns from sql_utf8_pattern_compare(). */ @@ -819,8 +807,7 @@ sql_utf8_pattern_compare(const char *pattern, int sql_strlike_cs(const char *zPattern, const char *zStr, unsigned int = esc) { - return sql_utf8_pattern_compare(zPattern, zStr, = case_sensitive_like, - esc); + return sql_utf8_pattern_compare(zPattern, zStr, 0, esc); } =20 /** @@ -830,8 +817,7 @@ sql_strlike_cs(const char *zPattern, const char = *zStr, unsigned int esc) int sql_strlike_ci(const char *zPattern, const char *zStr, unsigned int = esc) { - return sql_utf8_pattern_compare(zPattern, zStr, = case_insensitive_like, - esc); + return sql_utf8_pattern_compare(zPattern, zStr, 1, esc); } =20 /** @@ -859,7 +845,7 @@ likeFunc(sqlite3_context *context, int argc, = sqlite3_value **argv) u32 escape =3D SQL_END_OF_STRING; int nPat; sqlite3 *db =3D sqlite3_context_db_handle(context); - int *is_like_ci =3D sqlite3_user_data(context); + int is_like_ci =3D = SQLITE_PTR_TO_INT(sqlite3_user_data(context)); =20 #ifdef SQLITE_LIKE_DOESNT_MATCH_BLOBS if (sqlite3_value_type(argv[0]) =3D=3D SQLITE_BLOB @@ -913,7 +899,7 @@ likeFunc(sqlite3_context *context, int argc, = sqlite3_value **argv) sqlite3_like_count++; #endif int res; - res =3D sql_utf8_pattern_compare(zB, zA, *is_like_ci, escape); + res =3D sql_utf8_pattern_compare(zB, zA, is_like_ci, escape); if (res =3D=3D SQL_INVALID_PATTERN) { const char *const err_msg =3D "LIKE pattern can only contain UTF-8 = characters"; @@ -1698,24 +1684,20 @@ setLikeOptFlag(sqlite3 * db, const char *zName, = u8 flagVal) * @retval none. */ void -sqlite3RegisterLikeFunctions(sqlite3 *db, int is_case_sensitive) +sqlite3RegisterLikeFunctions(sqlite3 *db, int *is_case_insensitive) { /* * FIXME: after introducing type LIKE must * return that type: TRUE if the string matches the * supplied pattern and FALSE otherwise. */ - int *is_like_ci; - if (is_case_sensitive) - is_like_ci =3D (void *)&case_sensitive_like; - else - is_like_ci =3D (void *)&case_insensitive_like; - sqlite3CreateFunc(db, "LIKE", AFFINITY_INTEGER, 2, 0, = is_like_ci, - likeFunc, 0, 0, 0); - sqlite3CreateFunc(db, "LIKE", AFFINITY_INTEGER, 3, 0, = is_like_ci, - likeFunc, 0, 0, 0); + int is_like_ci =3D SQLITE_PTR_TO_INT(is_case_insensitive); + sqlite3CreateFunc(db, "LIKE", AFFINITY_INTEGER, 2, 0, + is_case_insensitive, likeFunc, 0, 0, 0); + sqlite3CreateFunc(db, "LIKE", AFFINITY_INTEGER, 3, 0, + is_case_insensitive, likeFunc, 0, 0, 0); setLikeOptFlag(db, "LIKE", - is_case_sensitive ? (SQLITE_FUNC_LIKE | + !(is_like_ci) ? (SQLITE_FUNC_LIKE | SQLITE_FUNC_CASE) : SQLITE_FUNC_LIKE); } =20 @@ -1841,14 +1823,14 @@ sqlite3RegisterBuiltinFunctions(void) groupConcatFinalize, AFFINITY_TEXT), =20 #ifdef SQLITE_CASE_SENSITIVE_LIKE - LIKEFUNC(like, 2, &case_sensitive_like, - SQLITE_FUNC_LIKE | SQLITE_FUNC_CASE, = AFFINITY_INTEGER), - LIKEFUNC(like, 3, &case_sensitive_like, - SQLITE_FUNC_LIKE | SQLITE_FUNC_CASE, = AFFINITY_INTEGER), + LIKEFUNC(like, 2, 0,SQLITE_FUNC_LIKE | SQLITE_FUNC_CASE, + AFFINITY_INTEGER), + LIKEFUNC(like, 3, 0,SQLITE_FUNC_LIKE | SQLITE_FUNC_CASE, + AFFINITY_INTEGER), #else - LIKEFUNC(like, 2, &case_insensitive_like, = SQLITE_FUNC_LIKE, + LIKEFUNC(like, 2, 1, SQLITE_FUNC_LIKE, AFFINITY_INTEGER), - LIKEFUNC(like, 3, &case_insensitive_like, = SQLITE_FUNC_LIKE, + LIKEFUNC(like, 3, 1, SQLITE_FUNC_LIKE, AFFINITY_INTEGER), #endif #ifdef SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION diff --git a/src/box/sql/pragma.c b/src/box/sql/pragma.c index cd6db2b34..546b18ae2 100644 --- a/src/box/sql/pragma.c +++ b/src/box/sql/pragma.c @@ -586,9 +586,10 @@ sqlite3Pragma(Parse * pParse, Token * pId, /* First = part of [schema.]id field */ */ case PragTyp_CASE_SENSITIVE_LIKE:{ if (zRight) { + int *is_like_ci =3D + = SQLITE_INT_TO_PTR(!(sqlite3GetBoolean(zRight, 0))); sqlite3RegisterLikeFunctions(db, - = sqlite3GetBoolean - (zRight, = 0)); + = is_like_ci); } break; } diff --git a/src/box/sql/sqliteInt.h b/src/box/sql/sqliteInt.h index f92d4e6b8..dd819622b 100644 --- a/src/box/sql/sqliteInt.h +++ b/src/box/sql/sqliteInt.h @@ -1759,7 +1759,7 @@ struct FuncDestructor { pArg, 0, xFunc, 0, #zName, {SQLITE_AFF_STRING, {0}}} #define LIKEFUNC(zName, nArg, arg, flags, type) \ {nArg, SQLITE_FUNC_CONSTANT|flags, \ - (void *)arg, 0, likeFunc, 0, #zName, {0}, type } + (void *)(SQLITE_INT_TO_PTR(arg)), 0, likeFunc, 0, #zName, {0}, type = } #define AGGREGATE(zName, nArg, arg, nc, xStep, xFinal, type) \ {nArg, (nc*SQLITE_FUNC_NEEDCOLL), \ SQLITE_INT_TO_PTR(arg), 0, xStep,xFinal,#zName, {0}, type} @@ -4551,7 +4551,7 @@ sql_key_info_unref(struct sql_key_info *key_info); struct key_def * sql_key_info_to_key_def(struct sql_key_info *key_info); =20 -void sqlite3RegisterLikeFunctions(sqlite3 *, int); +void sqlite3RegisterLikeFunctions(sqlite3 *, int *); int sql_is_like_func(sqlite3 *, Expr *, int *); int sqlite3CreateFunc(sqlite3 *, const char *, enum affinity_type, int, int, void *, diff --git a/test/sql-tap/collation.test.lua = b/test/sql-tap/collation.test.lua index eb4f43a90..dbbe1c0fe 100755 --- a/test/sql-tap/collation.test.lua +++ b/test/sql-tap/collation.test.lua @@ -219,7 +219,7 @@ local like_testcases =3D {0, {"Aab", "aaa"}} }, {"2.1.2", "EXPLAIN QUERY PLAN SELECT * FROM tx1 WHERE s1 LIKE 'A%';", - {0, {0, 0, 0, "/USING COVERING INDEX I1/"}} }, + {0, {0, 0, 0, "SEARCH TABLE TX1 USING COVERING INDEX I1 (S1>? = AND S1Hello! thank you for the review.

Issues:
https://github.com/tarantool/tarantool/issues/3251
https://github.com/tarantool/tarantool/issues/3334

Branch:
https://github.com/tarantool/tarantool/tree/N_Tatunov/gh-3251-w= here-like-hangs

Please consider following changes:

1. I rebased the whole branch on fresh = 2.1.

On Oct 29, 2018, at 15:15, Alexander Turenko = <alexander.turenko@tarantool.org> wrote:

Hi!
See remaining comments below.
WBR, Alexander Turenko.

+static const int = case_insensitive_like =3D 1;
+static const int = case_sensitive_like =3D 0;

Are = not they are mutually exclusive? Can we leave just one?

Why they are not defines?

I guess it=E2=80=99s a bad idea since we need pointers to = them in some functions.
e.g:

= int *is_like_ci;
if (is_case_sensitive)
= = is_like_ci =3D (void *)&case_sensitive_like;
= else
is_like_ci =3D (void = *)&case_insensitive_like;
sqlite3CreateFunc(db, "LIKE", 2, = 0, is_like_ci, likeFunc, 0, 0, 0);
= sqlite3CreateFunc(db, "LIKE", 3, 0, is_like_ci, likeFunc, 0, 0, = 0);

I think we can use = SQLITE_INT_TO_PTR and SQLITE_PTR_TO_INT to pass an
integer = value as a pointer and then cast it back. Maybe we also should
change LIKEFUNC macro.

+       int = *is_like_ci;
+       if = (is_case_sensitive)
+ =             &n= bsp; is_like_ci =3D (int *)&case_sensitive_like;
+ =       else
+ =             &n= bsp; is_like_ci =3D (int *)&case_insensitive_like;

Discarding const qualifier? It = seems not being right thing to do. It is
better to define = is_like_ci pointer as const.

It=E2=80=99s not possible due to so-called =E2=80=9Cdown = qualification=E2=80=9D and will cause
compiler = warnings.

We'll anyway discard = it here or there, so nevermind. I proposed to
change it to = SQLITE_INT_TO_PTR.


2. Changed manipulations with = =E2=80=9Csensitiveness=E2=80=9D of LIKE using your advice
thus there=E2=80=99s no static consts in func.c = anymore.


diff with the previous version of the = patch:

diff --git a/src/box/sql/func.c = b/src/box/sql/func.c
index b1983e594..5feab52f6 = 100644
--- a/src/box/sql/func.c
+++ b/src/box/sql/func.c
@@ -627,18 = +627,6 @@ total_changes(sqlite3_context * context, int NotUsed, = sqlite3_value ** NotUsed2)
 #define = SQL_END_OF_STRING        0xffff
 #define SQL_INVALID_UTF8_SYMBOL  0xfffd
 
-/**
- * If = SQLITE_CASE_SENSITIVE_LIKE is not defined, then the LIKE
- * operator is not case sensitive.
- = */
-static const int case_insensitive_like =3D = 1;
-
-/**
-= * If SQLITE_CASE_SENSITIVE_LIKE is defined, then the LIKE
- * operator is case sensitive causing 'a' LIKE 'A' to be = false.
- */
-static const int = case_sensitive_like =3D 0;
-
 /**
  * Possible error = returns from sql_utf8_pattern_compare().
  = */
@@ -819,8 +807,7 @@ = sql_utf8_pattern_compare(const char *pattern,
 int
 sql_strlike_cs(const = char *zPattern, const char *zStr, unsigned int esc)
 {
- return = sql_utf8_pattern_compare(zPattern, zStr, case_sensitive_like,
- = esc);
+ return = sql_utf8_pattern_compare(zPattern, zStr, 0, esc);
 }
 
 /**
@@ -830,8 +817,7 @@ = sql_strlike_cs(const char *zPattern, const char *zStr, unsigned int = esc)
 int
 sql_strlike_ci(const char *zPattern, const char *zStr, = unsigned int esc)
 {
- return = sql_utf8_pattern_compare(zPattern, zStr, = case_insensitive_like,
- = esc);
+ return = sql_utf8_pattern_compare(zPattern, zStr, 1, esc);
 }
 
 /**
@@ -859,7 +845,7 @@ = likeFunc(sqlite3_context *context, int argc, sqlite3_value = **argv)
  u32 escape =3D = SQL_END_OF_STRING;
  int = nPat;
  sqlite3 *db =3D = sqlite3_context_db_handle(context);
- int = *is_like_ci =3D sqlite3_user_data(context);
+ int = is_like_ci =3D SQLITE_PTR_TO_INT(sqlite3_user_data(context));
 
 #ifdef = SQLITE_LIKE_DOESNT_MATCH_BLOBS
  if = (sqlite3_value_type(argv[0]) =3D=3D SQLITE_BLOB
@@ = -913,7 +899,7 @@ likeFunc(sqlite3_context *context, int argc, = sqlite3_value **argv)
  = sqlite3_like_count++;
 #endif
 = int res;
- res =3D = sql_utf8_pattern_compare(zB, zA, *is_like_ci, escape);
+ = res =3D sql_utf8_pattern_compare(zB, zA, is_like_ci, = escape);
  if (res =3D=3D = SQL_INVALID_PATTERN) {
  = const char *const err_msg =3D
  = "LIKE pattern can only contain UTF-8 characters";
@@ -1698,24 +1684,20 @@ setLikeOptFlag(sqlite3 * db, const = char *zName, u8 flagVal)
  * @retval = none.
  */
 void
-sqlite3RegisterLikeFunctions(sqlite3 *db, int = is_case_sensitive)
+sqlite3RegisterLikeFunctions(sqlite3 *db, int = *is_case_insensitive)
 {
 = /*
  * FIXME: = after introducing type <BOOLEAN> LIKE must
 = * return that type: TRUE if the string matches = the
  * supplied pattern and FALSE = otherwise.
  */
- int = *is_like_ci;
- if (is_case_sensitive)
- = is_like_ci =3D (void *)&case_sensitive_like;
- = else
- is_like_ci =3D (void = *)&case_insensitive_like;
- = sqlite3CreateFunc(db, "LIKE", AFFINITY_INTEGER, 2, 0, = is_like_ci,
-  likeFunc, = 0, 0, 0);
- sqlite3CreateFunc(db, "LIKE", = AFFINITY_INTEGER, 3, 0, is_like_ci,
- =  likeFunc, 0, 0, 0);
+ int = is_like_ci =3D SQLITE_PTR_TO_INT(is_case_insensitive);
+ = sqlite3CreateFunc(db, "LIKE", AFFINITY_INTEGER, 2, 0,
+ =  is_case_insensitive, likeFunc, 0, 0, 0);
+ = sqlite3CreateFunc(db, "LIKE", AFFINITY_INTEGER, 3, 0,
+ =  is_case_insensitive, likeFunc, 0, 0, 0);
 = setLikeOptFlag(db, "LIKE",
- =       is_case_sensitive ? (SQLITE_FUNC_LIKE |
+ =       !(is_like_ci) ? (SQLITE_FUNC_LIKE = |
        = SQLITE_FUNC_CASE) : SQLITE_FUNC_LIKE);
 }
 
@@ = -1841,14 +1823,14 @@ sqlite3RegisterBuiltinFunctions(void)
 =  groupConcatFinalize, = AFFINITY_TEXT),
 
 #ifdef SQLITE_CASE_SENSITIVE_LIKE
- = LIKEFUNC(like, 2, &case_sensitive_like,
- = SQLITE_FUNC_LIKE | SQLITE_FUNC_CASE, = AFFINITY_INTEGER),
- LIKEFUNC(like, 3, = &case_sensitive_like,
- = SQLITE_FUNC_LIKE | SQLITE_FUNC_CASE, = AFFINITY_INTEGER),
+ LIKEFUNC(like, 2, = 0,SQLITE_FUNC_LIKE | SQLITE_FUNC_CASE,
+ = AFFINITY_INTEGER),
+ = LIKEFUNC(like, 3, 0,SQLITE_FUNC_LIKE | = SQLITE_FUNC_CASE,
+ = AFFINITY_INTEGER),
 #else
- = LIKEFUNC(like, 2, &case_insensitive_like, = SQLITE_FUNC_LIKE,
+ LIKEFUNC(like, 2, 1, = SQLITE_FUNC_LIKE,
  = AFFINITY_INTEGER),
- = LIKEFUNC(like, 3, &case_insensitive_like, = SQLITE_FUNC_LIKE,
+ LIKEFUNC(like, 3, 1, = SQLITE_FUNC_LIKE,
  = AFFINITY_INTEGER),
 #endif
 #ifdef SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION
diff --git a/src/box/sql/pragma.c = b/src/box/sql/pragma.c
index cd6db2b34..546b18ae2 = 100644
--- a/src/box/sql/pragma.c
+++ b/src/box/sql/pragma.c
@@ -586,9 = +586,10 @@ sqlite3Pragma(Parse * pParse, Token * pId, /* First = part of [schema.]id field */
  = */
  case = PragTyp_CASE_SENSITIVE_LIKE:{
  = if (zRight) {
+ int = *is_like_ci =3D
+ = SQLITE_INT_TO_PTR(!(sqlite3GetBoolean(zRight, 0)));
 = = sqlite3RegisterLikeFunctions(db,
- =     = sqlite3GetBoolean
- =     (zRight, 0));
+ =     is_like_ci);
 = }
  = break;
  }
diff= --git a/src/box/sql/sqliteInt.h b/src/box/sql/sqliteInt.h
index f92d4e6b8..dd819622b 100644
--- = a/src/box/sql/sqliteInt.h
+++ = b/src/box/sql/sqliteInt.h
@@ -1759,7 +1759,7 @@ = struct FuncDestructor {
    pArg, 0, = xFunc, 0, #zName, {SQLITE_AFF_STRING, {0}}}
 #define LIKEFUNC(zName, nArg, arg, flags, type) = \
   {nArg, SQLITE_FUNC_CONSTANT|flags, = \
-   (void *)arg, 0, likeFunc, 0, #zName, = {0}, type }
+   (void = *)(SQLITE_INT_TO_PTR(arg)), 0, likeFunc, 0, #zName, {0}, type = }
 #define AGGREGATE(zName, nArg, arg, nc, = xStep, xFinal, type) \
   {nArg, = (nc*SQLITE_FUNC_NEEDCOLL), \
    = SQLITE_INT_TO_PTR(arg), 0, xStep,xFinal,#zName, {0}, type}
@@ -4551,7 +4551,7 @@ sql_key_info_unref(struct sql_key_info = *key_info);
 struct key_def *
 sql_key_info_to_key_def(struct sql_key_info = *key_info);
 
-void = sqlite3RegisterLikeFunctions(sqlite3 *, int);
+void = sqlite3RegisterLikeFunctions(sqlite3 *, int *);
 int sql_is_like_func(sqlite3 *, Expr *, int = *);
 int sqlite3CreateFunc(sqlite3 *, const = char *, enum affinity_type,
  =      int, int, void *,
diff --git = a/test/sql-tap/collation.test.lua = b/test/sql-tap/collation.test.lua
index = eb4f43a90..dbbe1c0fe 100755
--- = a/test/sql-tap/collation.test.lua
+++ = b/test/sql-tap/collation.test.lua
@@ -219,7 +219,7 = @@ local like_testcases =3D
      =    {0, {"Aab", "aaa"}} },
    =  {"2.1.2",
        =  "EXPLAIN QUERY PLAN SELECT * FROM tx1 WHERE s1 LIKE = 'A%';",
-        {0, {0, 0, 0, = "/USING COVERING INDEX I1/"}} },
+     =    {0, {0, 0, 0, "SEARCH TABLE TX1 USING COVERING INDEX I1 = (S1>? AND S1<?)"}}},
    =  {"2.2.0",
        =  "PRAGMA case_sensitive_like =3D true;",
  =        {0}},

= --Apple-Mail=_41F4AC4A-0EB2-469F-822B-109B35798A76--