From 7d20c2e8a36e82e0388c7edaa615ba68b27a5d26 Mon Sep 17 00:00:00 2001
From: dan <Dan Kennedy>
Date: Tue, 15 Jul 2025 18:51:46 +0000
Subject: [PATCH] Add test case to between.test.

FossilOrigin-Name: ffebbb7ae977adc6c729d30b51f2ff29d416e018d82e450d87ccd973472819c8
---
 manifest          | 15 ++++++---------
 manifest.uuid     |  2 +-
 test/between.test |  5 +++++
 3 files changed, 12 insertions(+), 10 deletions(-)

diff --git a/manifest b/manifest
index 87abca403e..714f2b2afa 100644
--- a/manifest
+++ b/manifest
@@ -1,5 +1,5 @@
-C Avoid\sevaluating\sspecial\svtab\soperators\s(e.g.\sMATCH)\sthat\sare\spart\sof\sON\sclauses\sattached\sto\sleft\sjoins\sfrom\sbeing\sevaluated\stoo\searly.\sPossible\sfix\sfor\s[forum:/forumpost/428ef7c468\s|\sforum\spost\s428ef7c468].
-D 2025-07-12T18:14:41.159
+C Add\stest\scase\sto\sbetween.test.
+D 2025-07-15T18:51:46.505
 F .fossil-settings/binary-glob 61195414528fb3ea9693577e1980230d78a1f8b0a54c78cf1b9b24d0a409ed6a x
 F .fossil-settings/empty-dirs dbb81e8fc0401ac46a1491ab34a7f2c7c0452f2f06b54ebb845d024ca8283ef1
 F .fossil-settings/ignore-glob 35175cdfcf539b2318cb04a9901442804be81cd677d8b889fcc9149c21f239ea
@@ -964,7 +964,7 @@ F test/bestindexA.test e1b5def6b190797cacf008e6815ffb78fb30261999030d60a728d572e
 F test/bestindexB.test 328b97b69cd1a20928d5997f9ecb04d2e00f1d18e19ab27f9e9adb44d7bc51ce
 F test/bestindexC.test 95b4a527b1a5d07951d731604a6d4cf7e5a806b39cea0e7819d4c9667e11c3fc
 F test/bestindexD.test 6a8f6f84990bcf17dfa59652a1f935beddb7afd96f8302830fbc86b0a13df3c3
-F test/between.test b301ef0d822a26b31235e10a3b7f1130be1565a7ba080e80a3a1ae3ba5a35ff7
+F test/between.test e7587149796101cbe8d5f8abae8d2a7b87f04d8226610aa1091615005dcf4d54
 F test/bigfile.test aa74f4e5db51c8e54a1d9de9fa65d01d1eb20b59
 F test/bigfile2.test 1b489a3a39ae90c7f027b79110d6b4e1dbc71bfc
 F test/bigmmap.test 6021e205487347c6d7e5a541aa472a4b8efc4e9f4a3799a823b61a8e6616105d
@@ -2212,11 +2212,8 @@ F tool/version-info.c 3b36468a90faf1bbd59c65fd0eb66522d9f941eedd364fabccd7227350
 F tool/warnings-clang.sh bbf6a1e685e534c92ec2bfba5b1745f34fb6f0bc2a362850723a9ee87c1b31a7
 F tool/warnings.sh 1ad0169b022b280bcaaf94a7fa231591be96b514230ab5c98fbf15cd7df842dd
 F tool/win/sqlite.vsix deb315d026cc8400325c5863eef847784a219a2f
-P e5d079549594ca44852773b8919894866394e47ad725dadc7f65242413a219d3
-R eb99b7ab5a76b7191a98fe93227d2428
-T *branch * vtab-leftjoin-fix
-T *sym-vtab-leftjoin-fix *
-T -sym-trunk *
+P 18ba07c152294a96d510a7851a0860f982ff1e0725afeebed9a343f550f6925a
+R 666e43c52f95417d6d453e313782ce83
 U dan
-Z c80dd1f4987fe05a4ba000eae17152fd
+Z 2d017df1643869d27e1f37ae6b4030de
 # Remove this line to create a well-formed Fossil manifest.
diff --git a/manifest.uuid b/manifest.uuid
index 786e5c76d3..16487b86b3 100644
--- a/manifest.uuid
+++ b/manifest.uuid
@@ -1 +1 @@
-18ba07c152294a96d510a7851a0860f982ff1e0725afeebed9a343f550f6925a
+ffebbb7ae977adc6c729d30b51f2ff29d416e018d82e450d87ccd973472819c8
diff --git a/test/between.test b/test/between.test
index 4f09f1afec..5e02ef9b22 100644
--- a/test/between.test
+++ b/test/between.test
@@ -144,6 +144,7 @@ foreach {tn expr res} {
 reset_db
 do_execsql_test between-3.0 {
   CREATE TABLE t1(x, y);
+  CREATE INDEX i1 ON t1(x);
   INSERT INTO t1 VALUES(4, 4);
   CREATE TABLE t2(a, b);
 }
@@ -152,4 +153,8 @@ do_execsql_test between-3.1 {
   SELECT * FROM t1 LEFT JOIN t2 ON (x BETWEEN 1 AND 3);
 } {4 4 {} {}}
 
+do_execsql_test between-3.2 {
+  SELECT * FROM t1 LEFT JOIN t2 ON (x BETWEEN 5 AND 7);
+} {4 4 {} {}}
+
 finish_test
-- 
2.47.2