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 793B525787 for ; Sat, 13 Jul 2019 18:51:11 -0400 (EDT) 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 prrGGkDHtMv9 for ; Sat, 13 Jul 2019 18:51:11 -0400 (EDT) Received: from smtp50.i.mail.ru (smtp50.i.mail.ru [94.100.177.110]) (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 349D82577D for ; Sat, 13 Jul 2019 18:51:11 -0400 (EDT) From: Roman Khabibov Subject: [tarantool-patches] [PATCH 0/2] Make LIKE predicate dependent on collation Date: Sun, 14 Jul 2019 01:51:06 +0300 Message-Id: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit 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 The first patch removes "PRAGMA case_sensitive_like". The second patch adds collation comparison to the pattern match function and makes changes to WHERE x LIKE 'aBc%' optimization. Roman Khabibov (2): sql: remove "PRAGMA case_sensitive_like" sql: make LIKE predicate dependent on collation src/box/sql/func.c | 131 ++++++++---------- src/box/sql/pragma.c | 7 - src/box/sql/pragma.h | 104 +++++++------- src/box/sql/sqlInt.h | 9 +- src/box/sql/whereexpr.c | 70 +++------- test/sql-tap/collation.test.lua | 35 +++-- ...gh-3251-string-pattern-comparison.test.lua | 90 +++++++++++- test/sql-tap/like3.test.lua | 4 +- test/sql-tap/pragma.test.lua | 19 +-- test/sql-tap/whereG.test.lua | 8 +- test/sql/sql-debug.result | 1 - 11 files changed, 246 insertions(+), 232 deletions(-) -- Branch: https://github.com/tarantool/tarantool/tree/romanhabibov/gh-3589-like Issue: https://github.com/tarantool/tarantool/issues/3589 2.20.1 (Apple Git-117)