[tarantool-patches] [PATCH 0/2] Make LIKE predicate dependent on collation

Roman Khabibov roman.habibov at tarantool.org
Sun Jul 14 01:51:06 MSK 2019


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)





More information about the Tarantool-patches mailing list