Add missing calls to sqlite3exprSkipCollateAndLikely() to the enchancement on this branch.

FossilOrigin-Name: 078537d057d638389e3ab3bc04bcac53f342c7bf1d8d75222296ef42d09e9ee7

1 files changed, 29 insertions, 0 deletions

diff --git a/test/existsexpr.test b/test/existsexpr.test
index 836560f2d..a5f60b944 100644
--- a/test/existsexpr.test
+++ b/test/existsexpr.test
@@ -241,6 +241,35 @@ do_subquery_test 4.1 0 {
   D d
 }
 
+do_subquery_test 4.1.1 0 {
+  SELECT * FROM tx2 WHERE EXISTS (
+    SELECT 1 FROM tx1 WHERE (a COLLATE nocase)=x AND b=y
+  )
+} {
+  A a   b b   C c   D d
+}
+do_subquery_test 4.1.2 0 {
+  SELECT * FROM tx2 WHERE EXISTS (
+    SELECT 1 FROM tx1 WHERE a=x AND (b COLLATE binary)=y
+  )
+} {
+  A a   b b   C c   D d
+}
+do_subquery_test 4.1.1 0 {
+  SELECT * FROM tx2 WHERE EXISTS (
+    SELECT 1 FROM tx1 WHERE x=(a COLLATE nocase) AND b=y
+  )
+} {
+  A a   b b   C c   D d
+}
+do_subquery_test 4.1.2 0 {
+  SELECT * FROM tx2 WHERE EXISTS (
+    SELECT 1 FROM tx1 WHERE a=x AND y=(b COLLATE binary)
+  )
+} {
+  A a   b b   C c   D d
+}
+
 do_subquery_test 4.2 1 {
   SELECT * FROM tx2 WHERE EXISTS (
     SELECT 1 FROM tx1 WHERE a=x AND b=y COLLATE nocase