Add a clarifying comment to the virtual table test module 'test8'.

FossilOrigin-Name: e92f97a6794440eb9d64e21218d39cb0e297a98e

1 files changed, 7 insertions, 0 deletions

diff --git a/src/test8.c b/src/test8.c
index 2107710a9..7d3756aec 100644
--- a/src/test8.c
+++ b/src/test8.c
@@ -848,6 +848,13 @@ static int echoBestIndex(sqlite3_vtab *tab, sqlite3_index_info *pIdxInfo){
         case SQLITE_INDEX_CONSTRAINT_GE:
           zOp = ">="; break;
         case SQLITE_INDEX_CONSTRAINT_MATCH:
+          /* Purposely translate the MATCH operator into a LIKE, which
+          ** will be used by the next block of code to construct a new
+          ** query.  It should also be noted here that the next block
+          ** of code requires the first letter of this operator to be
+          ** in upper-case to trigger the special MATCH handling (i.e.
+          ** wrapping the bound parameter with literal '%'s).
+          */
           zOp = "LIKE"; break;
       }
       if( zOp[0]=='L' ){