Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Merge the LIKE-operator bug fix from trunk. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | sessions |
| Files: | files | file ages | folders |
| SHA1: |
36cb3d6e274a06a78693ca506feaad0b |
| User & Date: | drh 2016-01-20 16:02:48 |
Context
|
2016-02-02
| ||
| 02:22 | Merge all recent enhancements from trunk. check-in: f3f92001 user: drh tags: sessions | |
|
2016-01-21
| ||
| 17:25 | Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set. Closed-Leaf check-in: 82470d1c user: dan tags: disable-restrict | |
|
2016-01-20
| ||
| 16:02 | Merge the LIKE-operator bug fix from trunk. check-in: 36cb3d6e user: drh tags: sessions | |
| 15:19 | Fix a problem in autoconf/configure.ac causing --enable-readline to fail if libedit was not present. check-in: e8adeb64 user: dan tags: trunk | |
| 11:33 | Merge recent enhancements from trunk. check-in: 327af5f6 user: drh tags: sessions | |
Changes
Changes to autoconf/configure.ac.
45 46 47 48 49 50 51 52 53 54 55 56 57 58 |
if test x"$enable_editline" != xno ; then
sLIBS=$LIBS
LIBS=""
AC_SEARCH_LIBS([readline],[edit],[enable_readline=no],[enable_editline=no])
READLINE_LIBS=$LIBS
if test x"$LIBS" != "x"; then
AC_DEFINE([HAVE_EDITLINE],1,Define to use BSD editline)
fi
LIBS=$sLIBS
fi
if test x"$enable_readline" != xno ; then
sLIBS=$LIBS
LIBS=""
AC_SEARCH_LIBS(tgetent, curses ncurses ncursesw, [], [])
|
> > |
45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 |
if test x"$enable_editline" != xno ; then
sLIBS=$LIBS
LIBS=""
AC_SEARCH_LIBS([readline],[edit],[enable_readline=no],[enable_editline=no])
READLINE_LIBS=$LIBS
if test x"$LIBS" != "x"; then
AC_DEFINE([HAVE_EDITLINE],1,Define to use BSD editline)
else
unset ac_cv_search_readline
fi
LIBS=$sLIBS
fi
if test x"$enable_readline" != xno ; then
sLIBS=$LIBS
LIBS=""
AC_SEARCH_LIBS(tgetent, curses ncurses ncursesw, [], [])
|
Changes to src/func.c.
735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 |
return 0;
}
continue;
}
}
c2 = Utf8Read(zString);
if( c==c2 ) continue;
if( noCase && sqlite3Tolower(c)==sqlite3Tolower(c2) ){
continue;
}
if( c==matchOne && zPattern!=zEscaped && c2!=0 ) continue;
return 0;
}
return *zString==0;
}
|
| |
735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 |
return 0;
}
continue;
}
}
c2 = Utf8Read(zString);
if( c==c2 ) continue;
if( noCase && c<0x80 && c2<0x80 && sqlite3Tolower(c)==sqlite3Tolower(c2) ){
continue;
}
if( c==matchOne && zPattern!=zEscaped && c2!=0 ) continue;
return 0;
}
return *zString==0;
}
|
Changes to test/like.test.
959 960 961 962 963 964 965 966 967 968 |
EXPLAIN QUERY PLAN
SELECT id FROM t12nc WHERE x LIKE 'abc%' COLLATE binary ORDER BY +id;
} {/SEARCH/}
do_execsql_test like-12.16 {
EXPLAIN QUERY PLAN
SELECT id FROM t12b WHERE x LIKE 'abc%' COLLATE binary ORDER BY +id;
} {/SCAN/}
finish_test
|
> > > > > > > > > > > > > > > > > |
959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 |
EXPLAIN QUERY PLAN
SELECT id FROM t12nc WHERE x LIKE 'abc%' COLLATE binary ORDER BY +id;
} {/SEARCH/}
do_execsql_test like-12.16 {
EXPLAIN QUERY PLAN
SELECT id FROM t12b WHERE x LIKE 'abc%' COLLATE binary ORDER BY +id;
} {/SCAN/}
# Ticket [https://www.sqlite.org/src/tktview/80369eddd5c94d49f7fbbcf5]
# 2016-01-20
#
do_execsql_test like-13.1 {
SELECT char(0x304d) LIKE char(0x306d);
} {0}
do_execsql_test like-13.2 {
SELECT char(0x4d) LIKE char(0x306d);
} {0}
do_execsql_test like-13.3 {
SELECT char(0x304d) LIKE char(0x6d);
} {0}
do_execsql_test like-13.4 {
SELECT char(0x4d) LIKE char(0x6d);
} {1}
finish_test
|