| Index: third_party/sqlite/sqlite-src-3100200/test/collate1.test
|
| diff --git a/third_party/sqlite/src/test/collate1.test b/third_party/sqlite/sqlite-src-3100200/test/collate1.test
|
| similarity index 95%
|
| copy from third_party/sqlite/src/test/collate1.test
|
| copy to third_party/sqlite/sqlite-src-3100200/test/collate1.test
|
| index 0716ac743fd4dcf3732bedac801db6389bb17897..7cf5698454804c577699569b6dcec1cf72e8c333 100644
|
| --- a/third_party/sqlite/src/test/collate1.test
|
| +++ b/third_party/sqlite/sqlite-src-3100200/test/collate1.test
|
| @@ -385,6 +385,20 @@ do_execsql_test 6.8 {
|
| SELECT x, y FROM c1 ORDER BY y COLLATE """""""";
|
| } {2 abb 1 ABC 4 WXY 3 wxz}
|
|
|
| -finish_test
|
| +# 2015-04-15: Nested COLLATE operators
|
| +#
|
| +do_execsql_test 7.0 {
|
| + SELECT 'abc' UNION ALL SELECT 'DEF'
|
| + ORDER BY 1 COLLATE nocase COLLATE nocase COLLATE nocase COLLATE nocase;
|
| +} {abc DEF}
|
| +do_execsql_test 7.1 {
|
| + SELECT 'abc' UNION ALL SELECT 'DEF'
|
| + ORDER BY 1 COLLATE nocase COLLATE nocase COLLATE nocase COLLATE binary;
|
| +} {DEF abc}
|
| +do_execsql_test 7.2 {
|
| + SELECT 'abc' UNION ALL SELECT 'DEF'
|
| + ORDER BY 1 COLLATE binary COLLATE binary COLLATE binary COLLATE nocase;
|
| +} {abc DEF}
|
|
|
|
|
| +finish_test
|
|
|