commit 00bd55e1ae7c8e241492ca1ae94aad6ace6f1807
author dan <dan@noemail.net> Fri Mar 20 20:54:28 2020 +0000
committer dan <dan@noemail.net> Fri Mar 20 20:54:28 2020 +0000
tree 3915f935ab9ce2c76e036ab4d4d4a1df9984882d
parent ec8e689a205c429511b58be15161bf6b250bfa55

Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias.

FossilOrigin-Name: 75c85ca32f9ae4a28fd8f8ff2f7639599413d22af706e9799a0e76cc560d14eb

src/trigger.c

diff --git a/src/trigger.c b/src/trigger.c
index 458aa29..b9548a6 100644
--- a/src/trigger.c
+++ b/src/trigger.c
@@ -580,7 +580,10 @@
   assert( zDb!=0 || sqlite3BtreeHoldsAllMutexes(db) );
   for(i=OMIT_TEMPDB; i<db->nDb; i++){
     int j = (i<2) ? i^1 : i;  /* Search TEMP before MAIN */
-    if( zDb && sqlite3StrICmp(db->aDb[j].zDbSName, zDb) ) continue;
+    if( zDb 
+      && sqlite3StrICmp(db->aDb[j].zDbSName, zDb) 
+      && (j!=0 || sqlite3StrICmp("main", zDb))
+    ) continue;
     assert( sqlite3SchemaMutexHeld(db, j, 0) );
     pTrigger = sqlite3HashFind(&(db->aDb[j].pSchema->trigHash), zName);
     if( pTrigger ) break;