Tarantool development patches archive
 help / color / mirror / Atom feed
From: Alexander Turenko <alexander.turenko@tarantool.org>
To: Nikita Tatunov <n.tatunov@tarantool.org>
Cc: tarantool-patches@freelists.org, korablev@tarantool.org
Subject: [tarantool-patches] Re: [PATCH 2/2] sql: remove GLOB from Tarantool
Date: Fri, 9 Nov 2018 15:18:28 +0300	[thread overview]
Message-ID: <20181109121828.mjdoouycwvonimms@tkn_work_nb> (raw)
In-Reply-To: <6F5AC823-3016-4918-A588-6BB6B621B777@tarantool.org>

Hi!

See comments below.

WBR, Alexander Turenko.

On Thu, Nov 08, 2018 at 06:09:23PM +0300, Nikita Tatunov wrote:
> Hello! thank you for the review.
> 
> Issues:
> https://github.com/tarantool/tarantool/issues/3251 <https://github.com/tarantool/tarantool/issues/3251>
> https://github.com/tarantool/tarantool/issues/3334 <https://github.com/tarantool/tarantool/issues/3334>
> 
> Branch:
> https://github.com/tarantool/tarantool/tree/N_Tatunov/gh-3251-where-like-hangs <https://github.com/tarantool/tarantool/tree/N_Tatunov/gh-3251-where-like-hangs>
> 

It seems you forgot to push the new changes.

> @@ -913,7 +899,7 @@ likeFunc(sqlite3_context *context, int argc, sqlite3_value **argv)
>  	sqlite3_like_count++;
>  #endif
>  	int res;
> -	res = sql_utf8_pattern_compare(zB, zA, *is_like_ci, escape);
> +	res = sql_utf8_pattern_compare(zB, zA, is_like_ci, escape);
>  	if (res == SQL_INVALID_PATTERN) {
>  		const char *const err_msg =
>  			"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 = (void *)&case_sensitive_like;
> -	else
> -		is_like_ci = (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 = 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);
>  }

I think sqlite3RegisterLikeFunctions should accept int as the second
parameter.

BTW, it seems that we add SQLITE_FUNC_CASE into flags, so maybe we can
read it in likeFunc and don't pass additional parameter at all? It is
just raw idea, I don't know the mechanics of sql functions much.

> 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 =
>          {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<?)"}}},

What is this hunk about?

  reply	other threads:[~2018-11-09 12:18 UTC|newest]

Thread overview: 46+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2018-08-16 17:00 [tarantool-patches] [PATCH v2 0/2] sql: pattern comparison fixes & GLOB removal N.Tatunov
2018-08-16 17:00 ` [tarantool-patches] [PATCH 1/2] sql: LIKE & GLOB pattern comparison issue N.Tatunov
2018-08-17  9:23   ` [tarantool-patches] " Alex Khatskevich
2018-08-17 11:17     ` Alexander Turenko
2018-08-17 11:42       ` Alex Khatskevich
2018-09-09 13:33         ` Nikita Tatunov
2018-09-10 22:20           ` Alex Khatskevich
2018-09-11  6:06             ` Nikita Tatunov
2018-09-11 10:06               ` Alex Khatskevich
2018-09-11 13:31                 ` Nikita Tatunov
2018-10-18 18:02                   ` Nikita Tatunov
2018-10-21  3:51                     ` Alexander Turenko
2018-10-26 15:19                       ` Nikita Tatunov
2018-10-29 13:01                         ` Alexander Turenko
2018-10-31  5:25                           ` Nikita Tatunov
2018-11-01 10:30                             ` Alexander Turenko
2018-11-14 14:16                               ` n.pettik
2018-11-14 17:06                                 ` Alexander Turenko
2018-08-16 17:00 ` [tarantool-patches] [PATCH 2/2] sql: remove GLOB from Tarantool N.Tatunov
2018-08-17  8:25   ` [tarantool-patches] " Alex Khatskevich
2018-08-17  8:49     ` n.pettik
2018-08-17  9:01       ` Alex Khatskevich
2018-08-17  9:20         ` n.pettik
2018-08-17  9:28           ` Alex Khatskevich
     [not found]     ` <04D02794-07A5-4146-9144-84EE720C8656@corp.mail.ru>
2018-08-17  8:53       ` Alex Khatskevich
2018-08-17 11:26     ` Alexander Turenko
2018-08-17 11:34       ` Alexander Turenko
2018-08-17 13:46     ` Nikita Tatunov
2018-09-09 14:57     ` Nikita Tatunov
2018-09-10 22:06       ` Alex Khatskevich
2018-09-11  7:38         ` Nikita Tatunov
2018-09-11 10:11           ` Alexander Turenko
2018-09-11 10:22             ` Alex Khatskevich
2018-09-11 12:03           ` Alex Khatskevich
2018-10-18 20:28             ` Nikita Tatunov
2018-10-21  3:48               ` Alexander Turenko
2018-10-26 15:21                 ` Nikita Tatunov
2018-10-29 12:15                   ` Alexander Turenko
2018-11-08 15:09                     ` Nikita Tatunov
2018-11-09 12:18                       ` Alexander Turenko [this message]
2018-11-10  3:38                         ` Nikita Tatunov
2018-11-13 19:23                           ` Alexander Turenko
2018-11-14 14:16                             ` n.pettik
2018-11-14 17:41                               ` Alexander Turenko
2018-11-14 21:48                                 ` n.pettik
2018-11-15  4:57 ` [tarantool-patches] Re: [PATCH v2 0/2] sql: pattern comparison fixes & GLOB removal Kirill Yukhin

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=20181109121828.mjdoouycwvonimms@tkn_work_nb \
    --to=alexander.turenko@tarantool.org \
    --cc=korablev@tarantool.org \
    --cc=n.tatunov@tarantool.org \
    --cc=tarantool-patches@freelists.org \
    --subject='[tarantool-patches] Re: [PATCH 2/2] sql: remove GLOB from Tarantool' \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox