Index: third_party/sqlite/src/test/collate1.test |
diff --git a/third_party/sqlite/src/test/collate1.test b/third_party/sqlite/src/test/collate1.test |
index 0716ac743fd4dcf3732bedac801db6389bb17897..7cf5698454804c577699569b6dcec1cf72e8c333 100644 |
--- a/third_party/sqlite/src/test/collate1.test |
+++ b/third_party/sqlite/src/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 |