drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 1 | /* |
| 2 | ** 2006 June 10 |
| 3 | ** |
| 4 | ** The author disclaims copyright to this source code. In place of |
| 5 | ** a legal notice, here is a blessing: |
| 6 | ** |
| 7 | ** May you do good and not evil. |
| 8 | ** May you find forgiveness for yourself and forgive others. |
| 9 | ** May you share freely, never taking more than you give. |
| 10 | ** |
| 11 | ************************************************************************* |
| 12 | ** This file contains code used to help implement virtual tables. |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 13 | */ |
| 14 | #ifndef SQLITE_OMIT_VIRTUALTABLE |
| 15 | #include "sqliteInt.h" |
| 16 | |
drh | 6384241 | 2009-04-11 16:27:19 +0000 | [diff] [blame] | 17 | /* |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 18 | ** Before a virtual table xCreate() or xConnect() method is invoked, the |
| 19 | ** sqlite3.pVtabCtx member variable is set to point to an instance of |
| 20 | ** this struct allocated on the stack. It is used by the implementation of |
| 21 | ** the sqlite3_declare_vtab() and sqlite3_vtab_config() APIs, both of which |
| 22 | ** are invoked only from within xCreate and xConnect methods. |
| 23 | */ |
| 24 | struct VtabCtx { |
drh | 81028a4 | 2012-05-15 18:28:27 +0000 | [diff] [blame] | 25 | VTable *pVTable; /* The virtual table being constructed */ |
| 26 | Table *pTab; /* The Table object to which the virtual table belongs */ |
dan | 75395cc | 2015-04-10 07:55:07 +0000 | [diff] [blame] | 27 | VtabCtx *pPrior; /* Parent context (if any) */ |
| 28 | int bDeclared; /* True after sqlite3_declare_vtab() is called */ |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 29 | }; |
| 30 | |
| 31 | /* |
drh | 2fcc159 | 2016-12-15 20:59:03 +0000 | [diff] [blame] | 32 | ** Construct and install a Module object for a virtual table. When this |
| 33 | ** routine is called, it is guaranteed that all appropriate locks are held |
| 34 | ** and the module is not already part of the connection. |
drh | cc5979d | 2019-08-16 22:58:29 +0000 | [diff] [blame] | 35 | ** |
| 36 | ** If there already exists a module with zName, replace it with the new one. |
| 37 | ** If pModule==0, then delete the module zName if it exists. |
drh | 2fcc159 | 2016-12-15 20:59:03 +0000 | [diff] [blame] | 38 | */ |
| 39 | Module *sqlite3VtabCreateModule( |
| 40 | sqlite3 *db, /* Database in which module is registered */ |
| 41 | const char *zName, /* Name assigned to this module */ |
| 42 | const sqlite3_module *pModule, /* The definition of the module */ |
| 43 | void *pAux, /* Context pointer for xCreate/xConnect */ |
| 44 | void (*xDestroy)(void *) /* Module destructor function */ |
| 45 | ){ |
| 46 | Module *pMod; |
drh | cc5979d | 2019-08-16 22:58:29 +0000 | [diff] [blame] | 47 | Module *pDel; |
| 48 | char *zCopy; |
| 49 | if( pModule==0 ){ |
| 50 | zCopy = (char*)zName; |
| 51 | pMod = 0; |
drh | 3ee1416 | 2017-10-02 13:20:43 +0000 | [diff] [blame] | 52 | }else{ |
drh | cc5979d | 2019-08-16 22:58:29 +0000 | [diff] [blame] | 53 | int nName = sqlite3Strlen30(zName); |
| 54 | pMod = (Module *)sqlite3Malloc(sizeof(Module) + nName + 1); |
| 55 | if( pMod==0 ){ |
| 56 | sqlite3OomFault(db); |
| 57 | return 0; |
| 58 | } |
| 59 | zCopy = (char *)(&pMod[1]); |
drh | 2fcc159 | 2016-12-15 20:59:03 +0000 | [diff] [blame] | 60 | memcpy(zCopy, zName, nName+1); |
| 61 | pMod->zName = zCopy; |
| 62 | pMod->pModule = pModule; |
| 63 | pMod->pAux = pAux; |
| 64 | pMod->xDestroy = xDestroy; |
| 65 | pMod->pEpoTab = 0; |
drh | cc5979d | 2019-08-16 22:58:29 +0000 | [diff] [blame] | 66 | pMod->nRefModule = 1; |
| 67 | } |
| 68 | pDel = (Module *)sqlite3HashInsert(&db->aModule,zCopy,(void*)pMod); |
| 69 | if( pDel ){ |
| 70 | if( pDel==pMod ){ |
drh | 2fcc159 | 2016-12-15 20:59:03 +0000 | [diff] [blame] | 71 | sqlite3OomFault(db); |
| 72 | sqlite3DbFree(db, pDel); |
drh | 9a63f09 | 2016-12-16 02:14:15 +0000 | [diff] [blame] | 73 | pMod = 0; |
drh | cc5979d | 2019-08-16 22:58:29 +0000 | [diff] [blame] | 74 | }else{ |
drh | 87ca806 | 2019-08-17 19:31:09 +0000 | [diff] [blame] | 75 | sqlite3VtabEponymousTableClear(db, pDel); |
drh | cc5979d | 2019-08-16 22:58:29 +0000 | [diff] [blame] | 76 | sqlite3VtabModuleUnref(db, pDel); |
drh | 2fcc159 | 2016-12-15 20:59:03 +0000 | [diff] [blame] | 77 | } |
| 78 | } |
| 79 | return pMod; |
| 80 | } |
| 81 | |
| 82 | /* |
drh | 6384241 | 2009-04-11 16:27:19 +0000 | [diff] [blame] | 83 | ** The actual function that does the work of creating a new module. |
| 84 | ** This function implements the sqlite3_create_module() and |
| 85 | ** sqlite3_create_module_v2() interfaces. |
| 86 | */ |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 87 | static int createModule( |
| 88 | sqlite3 *db, /* Database in which module is registered */ |
| 89 | const char *zName, /* Name assigned to this module */ |
| 90 | const sqlite3_module *pModule, /* The definition of the module */ |
| 91 | void *pAux, /* Context pointer for xCreate/xConnect */ |
| 92 | void (*xDestroy)(void *) /* Module destructor function */ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 93 | ){ |
dan | ca8b9ba | 2012-05-16 14:29:11 +0000 | [diff] [blame] | 94 | int rc = SQLITE_OK; |
drh | 2764170 | 2007-08-22 02:56:42 +0000 | [diff] [blame] | 95 | |
| 96 | sqlite3_mutex_enter(db->mutex); |
drh | cc5979d | 2019-08-16 22:58:29 +0000 | [diff] [blame] | 97 | (void)sqlite3VtabCreateModule(db, zName, pModule, pAux, xDestroy); |
dan | ca8b9ba | 2012-05-16 14:29:11 +0000 | [diff] [blame] | 98 | rc = sqlite3ApiExit(db, rc); |
| 99 | if( rc!=SQLITE_OK && xDestroy ) xDestroy(pAux); |
drh | 2764170 | 2007-08-22 02:56:42 +0000 | [diff] [blame] | 100 | sqlite3_mutex_leave(db->mutex); |
| 101 | return rc; |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 102 | } |
| 103 | |
| 104 | |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 105 | /* |
| 106 | ** External API function used to create a new virtual-table module. |
| 107 | */ |
| 108 | int sqlite3_create_module( |
| 109 | sqlite3 *db, /* Database in which module is registered */ |
| 110 | const char *zName, /* Name assigned to this module */ |
danielk1977 | d1ab1ba | 2006-06-15 04:28:13 +0000 | [diff] [blame] | 111 | const sqlite3_module *pModule, /* The definition of the module */ |
| 112 | void *pAux /* Context pointer for xCreate/xConnect */ |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 113 | ){ |
drh | 9ca9573 | 2014-10-24 00:35:58 +0000 | [diff] [blame] | 114 | #ifdef SQLITE_ENABLE_API_ARMOR |
| 115 | if( !sqlite3SafetyCheckOk(db) || zName==0 ) return SQLITE_MISUSE_BKPT; |
| 116 | #endif |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 117 | return createModule(db, zName, pModule, pAux, 0); |
| 118 | } |
| 119 | |
| 120 | /* |
| 121 | ** External API function used to create a new virtual-table module. |
| 122 | */ |
| 123 | int sqlite3_create_module_v2( |
| 124 | sqlite3 *db, /* Database in which module is registered */ |
| 125 | const char *zName, /* Name assigned to this module */ |
| 126 | const sqlite3_module *pModule, /* The definition of the module */ |
| 127 | void *pAux, /* Context pointer for xCreate/xConnect */ |
| 128 | void (*xDestroy)(void *) /* Module destructor function */ |
| 129 | ){ |
drh | 9ca9573 | 2014-10-24 00:35:58 +0000 | [diff] [blame] | 130 | #ifdef SQLITE_ENABLE_API_ARMOR |
| 131 | if( !sqlite3SafetyCheckOk(db) || zName==0 ) return SQLITE_MISUSE_BKPT; |
| 132 | #endif |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 133 | return createModule(db, zName, pModule, pAux, xDestroy); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 134 | } |
| 135 | |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 136 | /* |
drh | 5df8428 | 2019-08-17 19:45:25 +0000 | [diff] [blame] | 137 | ** External API to drop all virtual-table modules, except those named |
| 138 | ** on the azNames list. |
| 139 | */ |
drh | 8c754a3 | 2019-08-19 20:35:30 +0000 | [diff] [blame] | 140 | int sqlite3_drop_modules(sqlite3 *db, const char** azNames){ |
drh | 5df8428 | 2019-08-17 19:45:25 +0000 | [diff] [blame] | 141 | HashElem *pThis, *pNext; |
| 142 | #ifdef SQLITE_ENABLE_API_ARMOR |
mistachkin | 3722b3a | 2019-08-20 02:19:26 +0000 | [diff] [blame] | 143 | if( !sqlite3SafetyCheckOk(db) ) return SQLITE_MISUSE_BKPT; |
drh | 5df8428 | 2019-08-17 19:45:25 +0000 | [diff] [blame] | 144 | #endif |
| 145 | for(pThis=sqliteHashFirst(&db->aModule); pThis; pThis=pNext){ |
| 146 | Module *pMod = (Module*)sqliteHashData(pThis); |
| 147 | pNext = sqliteHashNext(pThis); |
| 148 | if( azNames ){ |
| 149 | int ii; |
| 150 | for(ii=0; azNames[ii]!=0 && strcmp(azNames[ii],pMod->zName)!=0; ii++){} |
| 151 | if( azNames[ii]!=0 ) continue; |
| 152 | } |
| 153 | createModule(db, pMod->zName, 0, 0, 0); |
| 154 | } |
| 155 | return SQLITE_OK; |
| 156 | } |
| 157 | |
| 158 | /* |
drh | cc5979d | 2019-08-16 22:58:29 +0000 | [diff] [blame] | 159 | ** Decrement the reference count on a Module object. Destroy the |
| 160 | ** module when the reference count reaches zero. |
| 161 | */ |
| 162 | void sqlite3VtabModuleUnref(sqlite3 *db, Module *pMod){ |
| 163 | assert( pMod->nRefModule>0 ); |
| 164 | pMod->nRefModule--; |
| 165 | if( pMod->nRefModule==0 ){ |
| 166 | if( pMod->xDestroy ){ |
| 167 | pMod->xDestroy(pMod->pAux); |
| 168 | } |
| 169 | assert( pMod->pEpoTab==0 ); |
| 170 | sqlite3DbFree(db, pMod); |
| 171 | } |
| 172 | } |
| 173 | |
| 174 | /* |
drh | 189d4af | 2006-09-02 20:57:52 +0000 | [diff] [blame] | 175 | ** Lock the virtual table so that it cannot be disconnected. |
| 176 | ** Locks nest. Every lock should have a corresponding unlock. |
| 177 | ** If an unlock is omitted, resources leaks will occur. |
| 178 | ** |
| 179 | ** If a disconnect is attempted while a virtual table is locked, |
| 180 | ** the disconnect is deferred until all locks have been removed. |
| 181 | */ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 182 | void sqlite3VtabLock(VTable *pVTab){ |
| 183 | pVTab->nRef++; |
| 184 | } |
| 185 | |
| 186 | |
| 187 | /* |
| 188 | ** pTab is a pointer to a Table structure representing a virtual-table. |
| 189 | ** Return a pointer to the VTable object used by connection db to access |
| 190 | ** this virtual-table, if one has been created, or NULL otherwise. |
| 191 | */ |
| 192 | VTable *sqlite3GetVTable(sqlite3 *db, Table *pTab){ |
| 193 | VTable *pVtab; |
| 194 | assert( IsVirtual(pTab) ); |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 195 | for(pVtab=pTab->u.vtab.p; pVtab && pVtab->db!=db; pVtab=pVtab->pNext); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 196 | return pVtab; |
drh | 189d4af | 2006-09-02 20:57:52 +0000 | [diff] [blame] | 197 | } |
| 198 | |
| 199 | /* |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 200 | ** Decrement the ref-count on a virtual table object. When the ref-count |
| 201 | ** reaches zero, call the xDisconnect() method to delete the object. |
drh | 189d4af | 2006-09-02 20:57:52 +0000 | [diff] [blame] | 202 | */ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 203 | void sqlite3VtabUnlock(VTable *pVTab){ |
| 204 | sqlite3 *db = pVTab->db; |
| 205 | |
| 206 | assert( db ); |
| 207 | assert( pVTab->nRef>0 ); |
drh | 5f9de6e | 2021-08-07 23:16:52 +0000 | [diff] [blame] | 208 | assert( db->eOpenState==SQLITE_STATE_OPEN |
| 209 | || db->eOpenState==SQLITE_STATE_ZOMBIE ); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 210 | |
| 211 | pVTab->nRef--; |
| 212 | if( pVTab->nRef==0 ){ |
| 213 | sqlite3_vtab *p = pVTab->pVtab; |
drh | cc5979d | 2019-08-16 22:58:29 +0000 | [diff] [blame] | 214 | sqlite3VtabModuleUnref(pVTab->db, pVTab->pMod); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 215 | if( p ){ |
drh | 9978c97 | 2010-02-23 17:36:32 +0000 | [diff] [blame] | 216 | p->pModule->xDisconnect(p); |
danielk1977 | a04a34f | 2007-04-16 15:06:25 +0000 | [diff] [blame] | 217 | } |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 218 | sqlite3DbFree(db, pVTab); |
| 219 | } |
| 220 | } |
| 221 | |
| 222 | /* |
| 223 | ** Table p is a virtual table. This function moves all elements in the |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 224 | ** p->u.vtab.p list to the sqlite3.pDisconnect lists of their associated |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 225 | ** database connections to be disconnected at the next opportunity. |
| 226 | ** Except, if argument db is not NULL, then the entry associated with |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 227 | ** connection db is left in the p->u.vtab.p list. |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 228 | */ |
| 229 | static VTable *vtabDisconnectAll(sqlite3 *db, Table *p){ |
| 230 | VTable *pRet = 0; |
drh | 78b2fa8 | 2021-10-07 12:11:20 +0000 | [diff] [blame] | 231 | VTable *pVTable; |
| 232 | |
| 233 | assert( IsVirtual(p) ); |
| 234 | pVTable = p->u.vtab.p; |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 235 | p->u.vtab.p = 0; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 236 | |
| 237 | /* Assert that the mutex (if any) associated with the BtShared database |
| 238 | ** that contains table p is held by the caller. See header comments |
| 239 | ** above function sqlite3VtabUnlockList() for an explanation of why |
| 240 | ** this makes it safe to access the sqlite3.pDisconnect list of any |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 241 | ** database connection that may have an entry in the p->u.vtab.p list. |
drh | 9bbc2e2 | 2011-04-04 20:40:22 +0000 | [diff] [blame] | 242 | */ |
| 243 | assert( db==0 || sqlite3SchemaMutexHeld(db, 0, p->pSchema) ); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 244 | |
| 245 | while( pVTable ){ |
| 246 | sqlite3 *db2 = pVTable->db; |
| 247 | VTable *pNext = pVTable->pNext; |
| 248 | assert( db2 ); |
| 249 | if( db2==db ){ |
| 250 | pRet = pVTable; |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 251 | p->u.vtab.p = pRet; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 252 | pRet->pNext = 0; |
| 253 | }else{ |
| 254 | pVTable->pNext = db2->pDisconnect; |
| 255 | db2->pDisconnect = pVTable; |
| 256 | } |
| 257 | pVTable = pNext; |
| 258 | } |
| 259 | |
| 260 | assert( !db || pRet ); |
| 261 | return pRet; |
| 262 | } |
| 263 | |
dan | bba02a9 | 2012-05-15 17:15:34 +0000 | [diff] [blame] | 264 | /* |
| 265 | ** Table *p is a virtual table. This function removes the VTable object |
| 266 | ** for table *p associated with database connection db from the linked |
| 267 | ** list in p->pVTab. It also decrements the VTable ref count. This is |
| 268 | ** used when closing database connection db to free all of its VTable |
| 269 | ** objects without disturbing the rest of the Schema object (which may |
| 270 | ** be being used by other shared-cache connections). |
| 271 | */ |
| 272 | void sqlite3VtabDisconnect(sqlite3 *db, Table *p){ |
| 273 | VTable **ppVTab; |
| 274 | |
| 275 | assert( IsVirtual(p) ); |
| 276 | assert( sqlite3BtreeHoldsAllMutexes(db) ); |
| 277 | assert( sqlite3_mutex_held(db->mutex) ); |
| 278 | |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 279 | for(ppVTab=&p->u.vtab.p; *ppVTab; ppVTab=&(*ppVTab)->pNext){ |
dan | bba02a9 | 2012-05-15 17:15:34 +0000 | [diff] [blame] | 280 | if( (*ppVTab)->db==db ){ |
| 281 | VTable *pVTab = *ppVTab; |
| 282 | *ppVTab = pVTab->pNext; |
| 283 | sqlite3VtabUnlock(pVTab); |
| 284 | break; |
| 285 | } |
| 286 | } |
| 287 | } |
| 288 | |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 289 | |
| 290 | /* |
| 291 | ** Disconnect all the virtual table objects in the sqlite3.pDisconnect list. |
| 292 | ** |
| 293 | ** This function may only be called when the mutexes associated with all |
| 294 | ** shared b-tree databases opened using connection db are held by the |
| 295 | ** caller. This is done to protect the sqlite3.pDisconnect list. The |
| 296 | ** sqlite3.pDisconnect list is accessed only as follows: |
| 297 | ** |
| 298 | ** 1) By this function. In this case, all BtShared mutexes and the mutex |
| 299 | ** associated with the database handle itself must be held. |
| 300 | ** |
| 301 | ** 2) By function vtabDisconnectAll(), when it adds a VTable entry to |
| 302 | ** the sqlite3.pDisconnect list. In this case either the BtShared mutex |
| 303 | ** associated with the database the virtual table is stored in is held |
| 304 | ** or, if the virtual table is stored in a non-sharable database, then |
| 305 | ** the database handle mutex is held. |
| 306 | ** |
| 307 | ** As a result, a sqlite3.pDisconnect cannot be accessed simultaneously |
| 308 | ** by multiple threads. It is thread-safe. |
| 309 | */ |
| 310 | void sqlite3VtabUnlockList(sqlite3 *db){ |
| 311 | VTable *p = db->pDisconnect; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 312 | |
| 313 | assert( sqlite3BtreeHoldsAllMutexes(db) ); |
| 314 | assert( sqlite3_mutex_held(db->mutex) ); |
| 315 | |
| 316 | if( p ){ |
drh | 1de92a6 | 2019-10-05 19:24:52 +0000 | [diff] [blame] | 317 | db->pDisconnect = 0; |
drh | ba968db | 2018-07-24 22:02:12 +0000 | [diff] [blame] | 318 | sqlite3ExpirePreparedStatements(db, 0); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 319 | do { |
| 320 | VTable *pNext = p->pNext; |
| 321 | sqlite3VtabUnlock(p); |
| 322 | p = pNext; |
| 323 | }while( p ); |
drh | 189d4af | 2006-09-02 20:57:52 +0000 | [diff] [blame] | 324 | } |
| 325 | } |
| 326 | |
| 327 | /* |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 328 | ** Clear any and all virtual-table information from the Table record. |
| 329 | ** This routine is called, for example, just before deleting the Table |
| 330 | ** record. |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 331 | ** |
| 332 | ** Since it is a virtual-table, the Table structure contains a pointer |
| 333 | ** to the head of a linked list of VTable structures. Each VTable |
| 334 | ** structure is associated with a single sqlite3* user of the schema. |
| 335 | ** The reference count of the VTable structure associated with database |
| 336 | ** connection db is decremented immediately (which may lead to the |
| 337 | ** structure being xDisconnected and free). Any other VTable structures |
| 338 | ** in the list are moved to the sqlite3.pDisconnect list of the associated |
| 339 | ** database connection. |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 340 | */ |
dan | 1feeaed | 2010-07-23 15:41:47 +0000 | [diff] [blame] | 341 | void sqlite3VtabClear(sqlite3 *db, Table *p){ |
drh | 78b2fa8 | 2021-10-07 12:11:20 +0000 | [diff] [blame] | 342 | assert( IsVirtual(p) ); |
drh | 41ce47c | 2022-08-22 02:00:26 +0000 | [diff] [blame] | 343 | assert( db!=0 ); |
| 344 | if( db->pnBytesFreed==0 ) vtabDisconnectAll(0, p); |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 345 | if( p->u.vtab.azArg ){ |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 346 | int i; |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 347 | for(i=0; i<p->u.vtab.nArg; i++){ |
| 348 | if( i!=1 ) sqlite3DbFree(db, p->u.vtab.azArg[i]); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 349 | } |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 350 | sqlite3DbFree(db, p->u.vtab.azArg); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 351 | } |
| 352 | } |
| 353 | |
| 354 | /* |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 355 | ** Add a new module argument to pTable->u.vtab.azArg[]. |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 356 | ** The string is not copied - the pointer is stored. The |
| 357 | ** string will be freed automatically when the table is |
| 358 | ** deleted. |
| 359 | */ |
drh | 0aa3231 | 2019-04-13 04:01:12 +0000 | [diff] [blame] | 360 | static void addModuleArgument(Parse *pParse, Table *pTable, char *zArg){ |
drh | 78b2fa8 | 2021-10-07 12:11:20 +0000 | [diff] [blame] | 361 | sqlite3_int64 nBytes; |
danielk1977 | b7a2f2e | 2006-06-23 11:34:54 +0000 | [diff] [blame] | 362 | char **azModuleArg; |
drh | 0aa3231 | 2019-04-13 04:01:12 +0000 | [diff] [blame] | 363 | sqlite3 *db = pParse->db; |
drh | 78b2fa8 | 2021-10-07 12:11:20 +0000 | [diff] [blame] | 364 | |
| 365 | assert( IsVirtual(pTable) ); |
| 366 | nBytes = sizeof(char *)*(2+pTable->u.vtab.nArg); |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 367 | if( pTable->u.vtab.nArg+3>=db->aLimit[SQLITE_LIMIT_COLUMN] ){ |
drh | 0aa3231 | 2019-04-13 04:01:12 +0000 | [diff] [blame] | 368 | sqlite3ErrorMsg(pParse, "too many columns on %s", pTable->zName); |
| 369 | } |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 370 | azModuleArg = sqlite3DbRealloc(db, pTable->u.vtab.azArg, nBytes); |
danielk1977 | b7a2f2e | 2006-06-23 11:34:54 +0000 | [diff] [blame] | 371 | if( azModuleArg==0 ){ |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 372 | sqlite3DbFree(db, zArg); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 373 | }else{ |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 374 | int i = pTable->u.vtab.nArg++; |
danielk1977 | b7a2f2e | 2006-06-23 11:34:54 +0000 | [diff] [blame] | 375 | azModuleArg[i] = zArg; |
| 376 | azModuleArg[i+1] = 0; |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 377 | pTable->u.vtab.azArg = azModuleArg; |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 378 | } |
| 379 | } |
| 380 | |
| 381 | /* |
| 382 | ** The parser calls this routine when it first sees a CREATE VIRTUAL TABLE |
| 383 | ** statement. The module name has been parsed, but the optional list |
| 384 | ** of parameters that follow the module name are still pending. |
| 385 | */ |
| 386 | void sqlite3VtabBeginParse( |
| 387 | Parse *pParse, /* Parsing context */ |
| 388 | Token *pName1, /* Name of new table, or database name */ |
| 389 | Token *pName2, /* Name of new table or NULL */ |
drh | b421b89 | 2012-01-28 19:41:53 +0000 | [diff] [blame] | 390 | Token *pModuleName, /* Name of the module for the virtual table */ |
| 391 | int ifNotExists /* No error if the table already exists */ |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 392 | ){ |
| 393 | Table *pTable; /* The new virtual table */ |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 394 | sqlite3 *db; /* Database connection */ |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 395 | |
drh | b421b89 | 2012-01-28 19:41:53 +0000 | [diff] [blame] | 396 | sqlite3StartTable(pParse, pName1, pName2, 0, 0, 1, ifNotExists); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 397 | pTable = pParse->pNewTable; |
drh | 748ce21 | 2009-05-20 20:10:47 +0000 | [diff] [blame] | 398 | if( pTable==0 ) return; |
danielk1977 | f1a381e | 2006-06-16 08:01:02 +0000 | [diff] [blame] | 399 | assert( 0==pTable->pIndex ); |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 400 | pTable->eTabType = TABTYP_VTAB; |
danielk1977 | f1a381e | 2006-06-16 08:01:02 +0000 | [diff] [blame] | 401 | |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 402 | db = pParse->db; |
danielk1977 | 70ba164 | 2006-06-21 16:02:42 +0000 | [diff] [blame] | 403 | |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 404 | assert( pTable->u.vtab.nArg==0 ); |
drh | 0aa3231 | 2019-04-13 04:01:12 +0000 | [diff] [blame] | 405 | addModuleArgument(pParse, pTable, sqlite3NameFromToken(db, pModuleName)); |
| 406 | addModuleArgument(pParse, pTable, 0); |
| 407 | addModuleArgument(pParse, pTable, sqlite3DbStrDup(db, pTable->zName)); |
dan | d89b834 | 2014-11-27 11:36:36 +0000 | [diff] [blame] | 408 | assert( (pParse->sNameToken.z==pName2->z && pName2->z!=0) |
| 409 | || (pParse->sNameToken.z==pName1->z && pName2->z==0) |
| 410 | ); |
| 411 | pParse->sNameToken.n = (int)( |
| 412 | &pModuleName->z[pModuleName->n] - pParse->sNameToken.z |
| 413 | ); |
danielk1977 | f1a381e | 2006-06-16 08:01:02 +0000 | [diff] [blame] | 414 | |
| 415 | #ifndef SQLITE_OMIT_AUTHORIZATION |
| 416 | /* Creating a virtual table invokes the authorization callback twice. |
| 417 | ** The first invocation, to obtain permission to INSERT a row into the |
drh | 1e32bed | 2020-06-19 13:33:53 +0000 | [diff] [blame] | 418 | ** sqlite_schema table, has already been made by sqlite3StartTable(). |
danielk1977 | f1a381e | 2006-06-16 08:01:02 +0000 | [diff] [blame] | 419 | ** The second call, to obtain permission to create the table, is made now. |
| 420 | */ |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 421 | if( pTable->u.vtab.azArg ){ |
mistachkin | 7cc5595 | 2018-09-21 23:41:18 +0000 | [diff] [blame] | 422 | int iDb = sqlite3SchemaToIndex(db, pTable->pSchema); |
| 423 | assert( iDb>=0 ); /* The database the table is being created in */ |
danielk1977 | be71889 | 2006-06-23 08:05:19 +0000 | [diff] [blame] | 424 | sqlite3AuthCheck(pParse, SQLITE_CREATE_VTABLE, pTable->zName, |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 425 | pTable->u.vtab.azArg[0], pParse->db->aDb[iDb].zDbSName); |
danielk1977 | f1a381e | 2006-06-16 08:01:02 +0000 | [diff] [blame] | 426 | } |
| 427 | #endif |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 428 | } |
| 429 | |
| 430 | /* |
| 431 | ** This routine takes the module argument that has been accumulating |
| 432 | ** in pParse->zArg[] and appends it to the list of arguments on the |
| 433 | ** virtual table currently under construction in pParse->pTable. |
| 434 | */ |
| 435 | static void addArgumentToVtab(Parse *pParse){ |
drh | b421b89 | 2012-01-28 19:41:53 +0000 | [diff] [blame] | 436 | if( pParse->sArg.z && pParse->pNewTable ){ |
drh | 7c2d87c | 2006-09-02 14:16:59 +0000 | [diff] [blame] | 437 | const char *z = (const char*)pParse->sArg.z; |
danielk1977 | 33b3933 | 2006-06-24 08:51:05 +0000 | [diff] [blame] | 438 | int n = pParse->sArg.n; |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 439 | sqlite3 *db = pParse->db; |
drh | 0aa3231 | 2019-04-13 04:01:12 +0000 | [diff] [blame] | 440 | addModuleArgument(pParse, pParse->pNewTable, sqlite3DbStrNDup(db, z, n)); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 441 | } |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 442 | } |
| 443 | |
| 444 | /* |
| 445 | ** The parser calls this routine after the CREATE VIRTUAL TABLE statement |
| 446 | ** has been completely parsed. |
| 447 | */ |
| 448 | void sqlite3VtabFinishParse(Parse *pParse, Token *pEnd){ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 449 | Table *pTab = pParse->pNewTable; /* The table being constructed */ |
| 450 | sqlite3 *db = pParse->db; /* The database connection */ |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 451 | |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 452 | if( pTab==0 ) return; |
drh | 78b2fa8 | 2021-10-07 12:11:20 +0000 | [diff] [blame] | 453 | assert( IsVirtual(pTab) ); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 454 | addArgumentToVtab(pParse); |
danielk1977 | 33b3933 | 2006-06-24 08:51:05 +0000 | [diff] [blame] | 455 | pParse->sArg.z = 0; |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 456 | if( pTab->u.vtab.nArg<1 ) return; |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 457 | |
| 458 | /* If the CREATE VIRTUAL TABLE statement is being entered for the |
| 459 | ** first time (in other words if the virtual table is actually being |
drh | 1e32bed | 2020-06-19 13:33:53 +0000 | [diff] [blame] | 460 | ** created now instead of just being read out of sqlite_schema) then |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 461 | ** do additional initialization work and store the statement text |
drh | 1e32bed | 2020-06-19 13:33:53 +0000 | [diff] [blame] | 462 | ** in the sqlite_schema table. |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 463 | */ |
| 464 | if( !db->init.busy ){ |
| 465 | char *zStmt; |
danielk1977 | 78efaba | 2006-06-12 06:09:17 +0000 | [diff] [blame] | 466 | char *zWhere; |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 467 | int iDb; |
dan | 7377945 | 2015-03-19 18:56:17 +0000 | [diff] [blame] | 468 | int iReg; |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 469 | Vdbe *v; |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 470 | |
drh | 8e8c889 | 2019-12-10 18:10:12 +0000 | [diff] [blame] | 471 | sqlite3MayAbort(pParse); |
| 472 | |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 473 | /* Compute the complete text of the CREATE VIRTUAL TABLE statement */ |
| 474 | if( pEnd ){ |
drh | b27b7f5 | 2008-12-10 18:03:45 +0000 | [diff] [blame] | 475 | pParse->sNameToken.n = (int)(pEnd->z - pParse->sNameToken.z) + pEnd->n; |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 476 | } |
danielk1977 | 1e53695 | 2007-08-16 10:09:01 +0000 | [diff] [blame] | 477 | zStmt = sqlite3MPrintf(db, "CREATE VIRTUAL TABLE %T", &pParse->sNameToken); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 478 | |
| 479 | /* A slot for the record has already been allocated in the |
drh | 346a70c | 2020-06-15 20:27:35 +0000 | [diff] [blame] | 480 | ** schema table. We just need to update that slot with all |
danielk1977 | 78efaba | 2006-06-12 06:09:17 +0000 | [diff] [blame] | 481 | ** the information we've collected. |
| 482 | ** |
drh | b765411 | 2008-01-12 12:48:07 +0000 | [diff] [blame] | 483 | ** The VM register number pParse->regRowid holds the rowid of an |
drh | 1e32bed | 2020-06-19 13:33:53 +0000 | [diff] [blame] | 484 | ** entry in the sqlite_schema table tht was created for this vtab |
drh | b765411 | 2008-01-12 12:48:07 +0000 | [diff] [blame] | 485 | ** by sqlite3StartTable(). |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 486 | */ |
| 487 | iDb = sqlite3SchemaToIndex(db, pTab->pSchema); |
| 488 | sqlite3NestedParse(pParse, |
drh | a4a871c | 2021-11-04 14:04:20 +0000 | [diff] [blame] | 489 | "UPDATE %Q." LEGACY_SCHEMA_TABLE " " |
danielk1977 | 78efaba | 2006-06-12 06:09:17 +0000 | [diff] [blame] | 490 | "SET type='table', name=%Q, tbl_name=%Q, rootpage=0, sql=%Q " |
drh | b765411 | 2008-01-12 12:48:07 +0000 | [diff] [blame] | 491 | "WHERE rowid=#%d", |
drh | 346a70c | 2020-06-15 20:27:35 +0000 | [diff] [blame] | 492 | db->aDb[iDb].zDbSName, |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 493 | pTab->zName, |
| 494 | pTab->zName, |
drh | b765411 | 2008-01-12 12:48:07 +0000 | [diff] [blame] | 495 | zStmt, |
| 496 | pParse->regRowid |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 497 | ); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 498 | v = sqlite3GetVdbe(pParse); |
drh | 9cbf342 | 2008-01-17 16:22:13 +0000 | [diff] [blame] | 499 | sqlite3ChangeCookie(pParse, iDb); |
danielk1977 | 78efaba | 2006-06-12 06:09:17 +0000 | [diff] [blame] | 500 | |
drh | 01c736d | 2016-05-20 15:15:07 +0000 | [diff] [blame] | 501 | sqlite3VdbeAddOp0(v, OP_Expire); |
drh | f4f31df | 2019-12-21 19:37:09 +0000 | [diff] [blame] | 502 | zWhere = sqlite3MPrintf(db, "name=%Q AND sql=%Q", pTab->zName, zStmt); |
dan | 6a5a13d | 2021-02-17 20:08:22 +0000 | [diff] [blame] | 503 | sqlite3VdbeAddParseSchemaOp(v, iDb, zWhere, 0); |
drh | f4f31df | 2019-12-21 19:37:09 +0000 | [diff] [blame] | 504 | sqlite3DbFree(db, zStmt); |
dan | 7377945 | 2015-03-19 18:56:17 +0000 | [diff] [blame] | 505 | |
| 506 | iReg = ++pParse->nMem; |
drh | 076e85f | 2015-09-03 13:46:12 +0000 | [diff] [blame] | 507 | sqlite3VdbeLoadString(v, iReg, pTab->zName); |
dan | 7377945 | 2015-03-19 18:56:17 +0000 | [diff] [blame] | 508 | sqlite3VdbeAddOp2(v, OP_VCreate, iDb, iReg); |
drh | ddfec00 | 2021-11-04 00:51:53 +0000 | [diff] [blame] | 509 | }else{ |
| 510 | /* If we are rereading the sqlite_schema table create the in-memory |
| 511 | ** record of the table. */ |
danielk1977 | 78efaba | 2006-06-12 06:09:17 +0000 | [diff] [blame] | 512 | Table *pOld; |
| 513 | Schema *pSchema = pTab->pSchema; |
| 514 | const char *zName = pTab->zName; |
drh | ddfec00 | 2021-11-04 00:51:53 +0000 | [diff] [blame] | 515 | assert( zName!=0 ); |
| 516 | sqlite3MarkAllShadowTablesOf(db, pTab); |
drh | acbcb7e | 2014-08-21 20:26:37 +0000 | [diff] [blame] | 517 | pOld = sqlite3HashInsert(&pSchema->tblHash, zName, pTab); |
danielk1977 | 78efaba | 2006-06-12 06:09:17 +0000 | [diff] [blame] | 518 | if( pOld ){ |
drh | 4a642b6 | 2016-02-05 01:55:27 +0000 | [diff] [blame] | 519 | sqlite3OomFault(db); |
danielk1977 | 78efaba | 2006-06-12 06:09:17 +0000 | [diff] [blame] | 520 | assert( pTab==pOld ); /* Malloc must have failed inside HashInsert() */ |
| 521 | return; |
| 522 | } |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 523 | pParse->pNewTable = 0; |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 524 | } |
| 525 | } |
| 526 | |
| 527 | /* |
| 528 | ** The parser calls this routine when it sees the first token |
| 529 | ** of an argument to the module name in a CREATE VIRTUAL TABLE statement. |
| 530 | */ |
| 531 | void sqlite3VtabArgInit(Parse *pParse){ |
| 532 | addArgumentToVtab(pParse); |
danielk1977 | 33b3933 | 2006-06-24 08:51:05 +0000 | [diff] [blame] | 533 | pParse->sArg.z = 0; |
| 534 | pParse->sArg.n = 0; |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 535 | } |
| 536 | |
| 537 | /* |
| 538 | ** The parser calls this routine for each token after the first token |
| 539 | ** in an argument to the module name in a CREATE VIRTUAL TABLE statement. |
| 540 | */ |
| 541 | void sqlite3VtabArgExtend(Parse *pParse, Token *p){ |
danielk1977 | 33b3933 | 2006-06-24 08:51:05 +0000 | [diff] [blame] | 542 | Token *pArg = &pParse->sArg; |
| 543 | if( pArg->z==0 ){ |
| 544 | pArg->z = p->z; |
| 545 | pArg->n = p->n; |
| 546 | }else{ |
drh | 542a176 | 2015-04-19 23:11:10 +0000 | [diff] [blame] | 547 | assert(pArg->z <= p->z); |
drh | b27b7f5 | 2008-12-10 18:03:45 +0000 | [diff] [blame] | 548 | pArg->n = (int)(&p->z[p->n] - pArg->z); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 549 | } |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 550 | } |
| 551 | |
danielk1977 | 78efaba | 2006-06-12 06:09:17 +0000 | [diff] [blame] | 552 | /* |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 553 | ** Invoke a virtual table constructor (either xCreate or xConnect). The |
| 554 | ** pointer to the function to invoke is passed as the fourth parameter |
| 555 | ** to this procedure. |
| 556 | */ |
| 557 | static int vtabCallConstructor( |
| 558 | sqlite3 *db, |
| 559 | Table *pTab, |
danielk1977 | d1ab1ba | 2006-06-15 04:28:13 +0000 | [diff] [blame] | 560 | Module *pMod, |
drh | e410296 | 2006-09-11 00:34:22 +0000 | [diff] [blame] | 561 | int (*xConstruct)(sqlite3*,void*,int,const char*const*,sqlite3_vtab**,char**), |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 562 | char **pzErr |
| 563 | ){ |
dan | 75395cc | 2015-04-10 07:55:07 +0000 | [diff] [blame] | 564 | VtabCtx sCtx; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 565 | VTable *pVTable; |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 566 | int rc; |
drh | 78b2fa8 | 2021-10-07 12:11:20 +0000 | [diff] [blame] | 567 | const char *const*azArg; |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 568 | int nArg = pTab->u.vtab.nArg; |
drh | 4ca8aac | 2006-09-10 17:31:58 +0000 | [diff] [blame] | 569 | char *zErr = 0; |
dan | 75395cc | 2015-04-10 07:55:07 +0000 | [diff] [blame] | 570 | char *zModuleName; |
dan | 41fb5cd | 2012-10-04 19:33:00 +0000 | [diff] [blame] | 571 | int iDb; |
dan | 75395cc | 2015-04-10 07:55:07 +0000 | [diff] [blame] | 572 | VtabCtx *pCtx; |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 573 | |
drh | 78b2fa8 | 2021-10-07 12:11:20 +0000 | [diff] [blame] | 574 | assert( IsVirtual(pTab) ); |
| 575 | azArg = (const char *const*)pTab->u.vtab.azArg; |
| 576 | |
dan | 75395cc | 2015-04-10 07:55:07 +0000 | [diff] [blame] | 577 | /* Check that the virtual-table is not already being initialized */ |
| 578 | for(pCtx=db->pVtabCtx; pCtx; pCtx=pCtx->pPrior){ |
| 579 | if( pCtx->pTab==pTab ){ |
| 580 | *pzErr = sqlite3MPrintf(db, |
| 581 | "vtable constructor called recursively: %s", pTab->zName |
| 582 | ); |
| 583 | return SQLITE_LOCKED; |
| 584 | } |
| 585 | } |
| 586 | |
drh | 3ee1416 | 2017-10-02 13:20:43 +0000 | [diff] [blame] | 587 | zModuleName = sqlite3DbStrDup(db, pTab->zName); |
danielk1977 | 0125683 | 2007-04-18 14:24:32 +0000 | [diff] [blame] | 588 | if( !zModuleName ){ |
mistachkin | fad3039 | 2016-02-13 23:43:46 +0000 | [diff] [blame] | 589 | return SQLITE_NOMEM_BKPT; |
danielk1977 | 0125683 | 2007-04-18 14:24:32 +0000 | [diff] [blame] | 590 | } |
| 591 | |
drh | 3ee1416 | 2017-10-02 13:20:43 +0000 | [diff] [blame] | 592 | pVTable = sqlite3MallocZero(sizeof(VTable)); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 593 | if( !pVTable ){ |
drh | 3ee1416 | 2017-10-02 13:20:43 +0000 | [diff] [blame] | 594 | sqlite3OomFault(db); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 595 | sqlite3DbFree(db, zModuleName); |
mistachkin | fad3039 | 2016-02-13 23:43:46 +0000 | [diff] [blame] | 596 | return SQLITE_NOMEM_BKPT; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 597 | } |
| 598 | pVTable->db = db; |
| 599 | pVTable->pMod = pMod; |
drh | 2928a15 | 2020-01-06 15:25:41 +0000 | [diff] [blame] | 600 | pVTable->eVtabRisk = SQLITE_VTABRISK_Normal; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 601 | |
dan | 41fb5cd | 2012-10-04 19:33:00 +0000 | [diff] [blame] | 602 | iDb = sqlite3SchemaToIndex(db, pTab->pSchema); |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 603 | pTab->u.vtab.azArg[1] = db->aDb[iDb].zDbSName; |
dan | 41fb5cd | 2012-10-04 19:33:00 +0000 | [diff] [blame] | 604 | |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 605 | /* Invoke the virtual table constructor */ |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 606 | assert( &db->pVtabCtx ); |
| 607 | assert( xConstruct ); |
| 608 | sCtx.pTab = pTab; |
| 609 | sCtx.pVTable = pVTable; |
dan | 75395cc | 2015-04-10 07:55:07 +0000 | [diff] [blame] | 610 | sCtx.pPrior = db->pVtabCtx; |
| 611 | sCtx.bDeclared = 0; |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 612 | db->pVtabCtx = &sCtx; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 613 | rc = xConstruct(db, pMod->pAux, nArg, azArg, &pVTable->pVtab, &zErr); |
dan | 75395cc | 2015-04-10 07:55:07 +0000 | [diff] [blame] | 614 | db->pVtabCtx = sCtx.pPrior; |
drh | 4a642b6 | 2016-02-05 01:55:27 +0000 | [diff] [blame] | 615 | if( rc==SQLITE_NOMEM ) sqlite3OomFault(db); |
dan | 75395cc | 2015-04-10 07:55:07 +0000 | [diff] [blame] | 616 | assert( sCtx.pTab==pTab ); |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 617 | |
| 618 | if( SQLITE_OK!=rc ){ |
drh | 4ca8aac | 2006-09-10 17:31:58 +0000 | [diff] [blame] | 619 | if( zErr==0 ){ |
danielk1977 | 1e53695 | 2007-08-16 10:09:01 +0000 | [diff] [blame] | 620 | *pzErr = sqlite3MPrintf(db, "vtable constructor failed: %s", zModuleName); |
drh | 4ca8aac | 2006-09-10 17:31:58 +0000 | [diff] [blame] | 621 | }else { |
danielk1977 | 1e53695 | 2007-08-16 10:09:01 +0000 | [diff] [blame] | 622 | *pzErr = sqlite3MPrintf(db, "%s", zErr); |
drh | b975598 | 2010-07-24 16:34:37 +0000 | [diff] [blame] | 623 | sqlite3_free(zErr); |
drh | fe1368e | 2006-09-10 17:08:29 +0000 | [diff] [blame] | 624 | } |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 625 | sqlite3DbFree(db, pVTable); |
| 626 | }else if( ALWAYS(pVTable->pVtab) ){ |
| 627 | /* Justification of ALWAYS(): A correct vtab constructor must allocate |
| 628 | ** the sqlite3_vtab object if successful. */ |
drh | 5604cc0 | 2014-10-14 20:25:43 +0000 | [diff] [blame] | 629 | memset(pVTable->pVtab, 0, sizeof(pVTable->pVtab[0])); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 630 | pVTable->pVtab->pModule = pMod->pModule; |
drh | cc5979d | 2019-08-16 22:58:29 +0000 | [diff] [blame] | 631 | pMod->nRefModule++; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 632 | pVTable->nRef = 1; |
dan | 75395cc | 2015-04-10 07:55:07 +0000 | [diff] [blame] | 633 | if( sCtx.bDeclared==0 ){ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 634 | const char *zFormat = "vtable constructor did not declare schema: %s"; |
| 635 | *pzErr = sqlite3MPrintf(db, zFormat, pTab->zName); |
| 636 | sqlite3VtabUnlock(pVTable); |
| 637 | rc = SQLITE_ERROR; |
| 638 | }else{ |
| 639 | int iCol; |
drh | c143114 | 2019-10-17 17:54:05 +0000 | [diff] [blame] | 640 | u16 oooHidden = 0; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 641 | /* If everything went according to plan, link the new VTable structure |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 642 | ** into the linked list headed by pTab->u.vtab.p. Then loop through the |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 643 | ** columns of the table to see if any of them contain the token "hidden". |
drh | a371ace | 2012-09-13 14:22:47 +0000 | [diff] [blame] | 644 | ** If so, set the Column COLFLAG_HIDDEN flag and remove the token from |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 645 | ** the type string. */ |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 646 | pVTable->pNext = pTab->u.vtab.p; |
| 647 | pTab->u.vtab.p = pVTable; |
danielk1977 | 034ca14 | 2007-06-26 10:38:54 +0000 | [diff] [blame] | 648 | |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 649 | for(iCol=0; iCol<pTab->nCol; iCol++){ |
drh | d756486 | 2016-03-22 20:05:09 +0000 | [diff] [blame] | 650 | char *zType = sqlite3ColumnType(&pTab->aCol[iCol], ""); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 651 | int nType; |
| 652 | int i = 0; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 653 | nType = sqlite3Strlen30(zType); |
drh | d756486 | 2016-03-22 20:05:09 +0000 | [diff] [blame] | 654 | for(i=0; i<nType; i++){ |
| 655 | if( 0==sqlite3StrNICmp("hidden", &zType[i], 6) |
| 656 | && (i==0 || zType[i-1]==' ') |
| 657 | && (zType[i+6]=='\0' || zType[i+6]==' ') |
| 658 | ){ |
| 659 | break; |
danielk1977 | 034ca14 | 2007-06-26 10:38:54 +0000 | [diff] [blame] | 660 | } |
| 661 | } |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 662 | if( i<nType ){ |
| 663 | int j; |
| 664 | int nDel = 6 + (zType[i+6] ? 1 : 0); |
| 665 | for(j=i; (j+nDel)<=nType; j++){ |
| 666 | zType[j] = zType[j+nDel]; |
| 667 | } |
| 668 | if( zType[i]=='\0' && i>0 ){ |
| 669 | assert(zType[i-1]==' '); |
| 670 | zType[i-1] = '\0'; |
| 671 | } |
drh | a371ace | 2012-09-13 14:22:47 +0000 | [diff] [blame] | 672 | pTab->aCol[iCol].colFlags |= COLFLAG_HIDDEN; |
drh | 6f6e60d | 2021-02-18 15:45:34 +0000 | [diff] [blame] | 673 | pTab->tabFlags |= TF_HasHidden; |
drh | a21f78b | 2015-04-19 18:32:43 +0000 | [diff] [blame] | 674 | oooHidden = TF_OOOHidden; |
| 675 | }else{ |
| 676 | pTab->tabFlags |= oooHidden; |
danielk1977 | 034ca14 | 2007-06-26 10:38:54 +0000 | [diff] [blame] | 677 | } |
danielk1977 | 034ca14 | 2007-06-26 10:38:54 +0000 | [diff] [blame] | 678 | } |
| 679 | } |
| 680 | } |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 681 | |
| 682 | sqlite3DbFree(db, zModuleName); |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 683 | return rc; |
| 684 | } |
| 685 | |
| 686 | /* |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 687 | ** This function is invoked by the parser to call the xConnect() method |
danielk1977 | fe3fcbe2 | 2006-06-12 12:08:45 +0000 | [diff] [blame] | 688 | ** of the virtual table pTab. If an error occurs, an error code is returned |
| 689 | ** and an error left in pParse. |
| 690 | ** |
| 691 | ** This call is a no-op if table pTab is not a virtual table. |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 692 | */ |
| 693 | int sqlite3VtabCallConnect(Parse *pParse, Table *pTab){ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 694 | sqlite3 *db = pParse->db; |
| 695 | const char *zMod; |
danielk1977 | d1ab1ba | 2006-06-15 04:28:13 +0000 | [diff] [blame] | 696 | Module *pMod; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 697 | int rc; |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 698 | |
drh | 748ce21 | 2009-05-20 20:10:47 +0000 | [diff] [blame] | 699 | assert( pTab ); |
drh | 06b7281 | 2021-11-04 11:34:04 +0000 | [diff] [blame] | 700 | assert( IsVirtual(pTab) ); |
| 701 | if( sqlite3GetVTable(db, pTab) ){ |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 702 | return SQLITE_OK; |
| 703 | } |
| 704 | |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 705 | /* Locate the required virtual table module */ |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 706 | zMod = pTab->u.vtab.azArg[0]; |
drh | acbcb7e | 2014-08-21 20:26:37 +0000 | [diff] [blame] | 707 | pMod = (Module*)sqlite3HashFind(&db->aModule, zMod); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 708 | |
danielk1977 | d1ab1ba | 2006-06-15 04:28:13 +0000 | [diff] [blame] | 709 | if( !pMod ){ |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 710 | const char *zModule = pTab->u.vtab.azArg[0]; |
danielk1977 | a4e7636 | 2006-06-14 06:31:28 +0000 | [diff] [blame] | 711 | sqlite3ErrorMsg(pParse, "no such module: %s", zModule); |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 712 | rc = SQLITE_ERROR; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 713 | }else{ |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 714 | char *zErr = 0; |
danielk1977 | d1ab1ba | 2006-06-15 04:28:13 +0000 | [diff] [blame] | 715 | rc = vtabCallConstructor(db, pTab, pMod, pMod->pModule->xConnect, &zErr); |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 716 | if( rc!=SQLITE_OK ){ |
| 717 | sqlite3ErrorMsg(pParse, "%s", zErr); |
drh | 7524b61 | 2017-08-09 22:55:09 +0000 | [diff] [blame] | 718 | pParse->rc = rc; |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 719 | } |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 720 | sqlite3DbFree(db, zErr); |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 721 | } |
| 722 | |
| 723 | return rc; |
| 724 | } |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 725 | /* |
dan | 2cac207 | 2011-05-25 18:46:22 +0000 | [diff] [blame] | 726 | ** Grow the db->aVTrans[] array so that there is room for at least one |
| 727 | ** more v-table. Return SQLITE_NOMEM if a malloc fails, or SQLITE_OK otherwise. |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 728 | */ |
dan | 2cac207 | 2011-05-25 18:46:22 +0000 | [diff] [blame] | 729 | static int growVTrans(sqlite3 *db){ |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 730 | const int ARRAY_INCR = 5; |
| 731 | |
| 732 | /* Grow the sqlite3.aVTrans array if required */ |
| 733 | if( (db->nVTrans%ARRAY_INCR)==0 ){ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 734 | VTable **aVTrans; |
drh | 0aa3231 | 2019-04-13 04:01:12 +0000 | [diff] [blame] | 735 | sqlite3_int64 nBytes = sizeof(sqlite3_vtab*)* |
| 736 | ((sqlite3_int64)db->nVTrans + ARRAY_INCR); |
danielk1977 | 26783a5 | 2007-08-29 14:06:22 +0000 | [diff] [blame] | 737 | aVTrans = sqlite3DbRealloc(db, (void *)db->aVTrans, nBytes); |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 738 | if( !aVTrans ){ |
mistachkin | fad3039 | 2016-02-13 23:43:46 +0000 | [diff] [blame] | 739 | return SQLITE_NOMEM_BKPT; |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 740 | } |
| 741 | memset(&aVTrans[db->nVTrans], 0, sizeof(sqlite3_vtab *)*ARRAY_INCR); |
| 742 | db->aVTrans = aVTrans; |
| 743 | } |
| 744 | |
dan | 2cac207 | 2011-05-25 18:46:22 +0000 | [diff] [blame] | 745 | return SQLITE_OK; |
| 746 | } |
| 747 | |
| 748 | /* |
| 749 | ** Add the virtual table pVTab to the array sqlite3.aVTrans[]. Space should |
| 750 | ** have already been reserved using growVTrans(). |
| 751 | */ |
| 752 | static void addToVTrans(sqlite3 *db, VTable *pVTab){ |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 753 | /* Add pVtab to the end of sqlite3.aVTrans */ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 754 | db->aVTrans[db->nVTrans++] = pVTab; |
| 755 | sqlite3VtabLock(pVTab); |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 756 | } |
| 757 | |
| 758 | /* |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 759 | ** This function is invoked by the vdbe to call the xCreate method |
| 760 | ** of the virtual table named zTab in database iDb. |
| 761 | ** |
drh | 2e5c505 | 2016-08-27 20:21:51 +0000 | [diff] [blame] | 762 | ** If an error occurs, *pzErr is set to point to an English language |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 763 | ** description of the error and an SQLITE_XXX error code is returned. |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 764 | ** In this case the caller must call sqlite3DbFree(db, ) on *pzErr. |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 765 | */ |
| 766 | int sqlite3VtabCallCreate(sqlite3 *db, int iDb, const char *zTab, char **pzErr){ |
| 767 | int rc = SQLITE_OK; |
| 768 | Table *pTab; |
danielk1977 | d1ab1ba | 2006-06-15 04:28:13 +0000 | [diff] [blame] | 769 | Module *pMod; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 770 | const char *zMod; |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 771 | |
drh | 69c3382 | 2016-08-18 14:33:11 +0000 | [diff] [blame] | 772 | pTab = sqlite3FindTable(db, zTab, db->aDb[iDb].zDbSName); |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 773 | assert( pTab && IsVirtual(pTab) && !pTab->u.vtab.p ); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 774 | |
| 775 | /* Locate the required virtual table module */ |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 776 | zMod = pTab->u.vtab.azArg[0]; |
drh | acbcb7e | 2014-08-21 20:26:37 +0000 | [diff] [blame] | 777 | pMod = (Module*)sqlite3HashFind(&db->aModule, zMod); |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 778 | |
| 779 | /* If the module has been registered and includes a Create method, |
| 780 | ** invoke it now. If the module has not been registered, return an |
| 781 | ** error. Otherwise, do nothing. |
| 782 | */ |
drh | d8b1bfc | 2015-08-20 23:21:34 +0000 | [diff] [blame] | 783 | if( pMod==0 || pMod->pModule->xCreate==0 || pMod->pModule->xDestroy==0 ){ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 784 | *pzErr = sqlite3MPrintf(db, "no such module: %s", zMod); |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 785 | rc = SQLITE_ERROR; |
| 786 | }else{ |
danielk1977 | d1ab1ba | 2006-06-15 04:28:13 +0000 | [diff] [blame] | 787 | rc = vtabCallConstructor(db, pTab, pMod, pMod->pModule->xCreate, pzErr); |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 788 | } |
| 789 | |
drh | 748ce21 | 2009-05-20 20:10:47 +0000 | [diff] [blame] | 790 | /* Justification of ALWAYS(): The xConstructor method is required to |
| 791 | ** create a valid sqlite3_vtab if it returns SQLITE_OK. */ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 792 | if( rc==SQLITE_OK && ALWAYS(sqlite3GetVTable(db, pTab)) ){ |
dan | 2cac207 | 2011-05-25 18:46:22 +0000 | [diff] [blame] | 793 | rc = growVTrans(db); |
| 794 | if( rc==SQLITE_OK ){ |
| 795 | addToVTrans(db, sqlite3GetVTable(db, pTab)); |
| 796 | } |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 797 | } |
| 798 | |
danielk1977 | 9da9d47 | 2006-06-14 06:58:15 +0000 | [diff] [blame] | 799 | return rc; |
| 800 | } |
danielk1977 | be8a783 | 2006-06-13 15:00:54 +0000 | [diff] [blame] | 801 | |
| 802 | /* |
danielk1977 | fe3fcbe2 | 2006-06-12 12:08:45 +0000 | [diff] [blame] | 803 | ** This function is used to set the schema of a virtual table. It is only |
| 804 | ** valid to call this function from within the xCreate() or xConnect() of a |
| 805 | ** virtual table module. |
| 806 | */ |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 807 | int sqlite3_declare_vtab(sqlite3 *db, const char *zCreateTable){ |
dan | 4e23536 | 2015-04-10 16:05:33 +0000 | [diff] [blame] | 808 | VtabCtx *pCtx; |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 809 | int rc = SQLITE_OK; |
drh | 2764170 | 2007-08-22 02:56:42 +0000 | [diff] [blame] | 810 | Table *pTab; |
drh | 6903bf6 | 2017-08-01 20:59:41 +0000 | [diff] [blame] | 811 | Parse sParse; |
drh | ebd1ff6 | 2021-09-24 12:59:33 +0000 | [diff] [blame] | 812 | int initBusy; |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 813 | |
drh | 9ca9573 | 2014-10-24 00:35:58 +0000 | [diff] [blame] | 814 | #ifdef SQLITE_ENABLE_API_ARMOR |
drh | 96c707a | 2015-02-13 16:36:14 +0000 | [diff] [blame] | 815 | if( !sqlite3SafetyCheckOk(db) || zCreateTable==0 ){ |
| 816 | return SQLITE_MISUSE_BKPT; |
| 817 | } |
drh | 9ca9573 | 2014-10-24 00:35:58 +0000 | [diff] [blame] | 818 | #endif |
drh | 2764170 | 2007-08-22 02:56:42 +0000 | [diff] [blame] | 819 | sqlite3_mutex_enter(db->mutex); |
dan | 4e23536 | 2015-04-10 16:05:33 +0000 | [diff] [blame] | 820 | pCtx = db->pVtabCtx; |
dan | 75395cc | 2015-04-10 07:55:07 +0000 | [diff] [blame] | 821 | if( !pCtx || pCtx->bDeclared ){ |
drh | 13f40da | 2014-08-22 18:00:11 +0000 | [diff] [blame] | 822 | sqlite3Error(db, SQLITE_MISUSE); |
drh | 2764170 | 2007-08-22 02:56:42 +0000 | [diff] [blame] | 823 | sqlite3_mutex_leave(db->mutex); |
drh | 413c3d3 | 2010-02-23 20:11:56 +0000 | [diff] [blame] | 824 | return SQLITE_MISUSE_BKPT; |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 825 | } |
dan | 75395cc | 2015-04-10 07:55:07 +0000 | [diff] [blame] | 826 | pTab = pCtx->pTab; |
drh | 44266ec | 2017-02-16 14:48:08 +0000 | [diff] [blame] | 827 | assert( IsVirtual(pTab) ); |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 828 | |
drh | c692df2 | 2022-01-24 15:34:55 +0000 | [diff] [blame] | 829 | sqlite3ParseObjectInit(&sParse, db); |
dan | cf8f289 | 2018-08-09 20:47:01 +0000 | [diff] [blame] | 830 | sParse.eParseMode = PARSE_MODE_DECLARE_VTAB; |
drh | 1a25be1 | 2022-03-14 20:31:57 +0000 | [diff] [blame] | 831 | sParse.disableTriggers = 1; |
drh | ebd1ff6 | 2021-09-24 12:59:33 +0000 | [diff] [blame] | 832 | /* We should never be able to reach this point while loading the |
| 833 | ** schema. Nevertheless, defend against that (turn off db->init.busy) |
| 834 | ** in case a bug arises. */ |
| 835 | assert( db->init.busy==0 ); |
| 836 | initBusy = db->init.busy; |
| 837 | db->init.busy = 0; |
drh | 6903bf6 | 2017-08-01 20:59:41 +0000 | [diff] [blame] | 838 | sParse.nQueryLoop = 1; |
drh | 54bc638 | 2021-12-31 19:20:42 +0000 | [diff] [blame] | 839 | if( SQLITE_OK==sqlite3RunParser(&sParse, zCreateTable) |
drh | 1611826 | 2021-12-31 17:54:48 +0000 | [diff] [blame] | 840 | && ALWAYS(sParse.pNewTable!=0) |
| 841 | && ALWAYS(!db->mallocFailed) |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 842 | && IsOrdinaryTable(sParse.pNewTable) |
drh | 6903bf6 | 2017-08-01 20:59:41 +0000 | [diff] [blame] | 843 | ){ |
drh | 54bc638 | 2021-12-31 19:20:42 +0000 | [diff] [blame] | 844 | assert( sParse.zErrMsg==0 ); |
drh | 6903bf6 | 2017-08-01 20:59:41 +0000 | [diff] [blame] | 845 | if( !pTab->aCol ){ |
| 846 | Table *pNew = sParse.pNewTable; |
| 847 | Index *pIdx; |
| 848 | pTab->aCol = pNew->aCol; |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 849 | sqlite3ExprListDelete(db, pNew->u.tab.pDfltList); |
drh | 7dec804 | 2021-02-04 22:59:19 +0000 | [diff] [blame] | 850 | pTab->nNVCol = pTab->nCol = pNew->nCol; |
drh | 6903bf6 | 2017-08-01 20:59:41 +0000 | [diff] [blame] | 851 | pTab->tabFlags |= pNew->tabFlags & (TF_WithoutRowid|TF_NoVisibleRowid); |
| 852 | pNew->nCol = 0; |
| 853 | pNew->aCol = 0; |
| 854 | assert( pTab->pIndex==0 ); |
drh | e3740f2 | 2017-08-10 15:19:39 +0000 | [diff] [blame] | 855 | assert( HasRowid(pNew) || sqlite3PrimaryKeyIndex(pNew)!=0 ); |
| 856 | if( !HasRowid(pNew) |
| 857 | && pCtx->pVTable->pMod->pModule->xUpdate!=0 |
| 858 | && sqlite3PrimaryKeyIndex(pNew)->nKeyCol!=1 |
| 859 | ){ |
| 860 | /* WITHOUT ROWID virtual tables must either be read-only (xUpdate==0) |
| 861 | ** or else must have a single-column PRIMARY KEY */ |
drh | 6903bf6 | 2017-08-01 20:59:41 +0000 | [diff] [blame] | 862 | rc = SQLITE_ERROR; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 863 | } |
drh | 6903bf6 | 2017-08-01 20:59:41 +0000 | [diff] [blame] | 864 | pIdx = pNew->pIndex; |
| 865 | if( pIdx ){ |
| 866 | assert( pIdx->pNext==0 ); |
| 867 | pTab->pIndex = pIdx; |
| 868 | pNew->pIndex = 0; |
| 869 | pIdx->pTable = pTab; |
| 870 | } |
drh | e98c904 | 2009-06-02 21:31:38 +0000 | [diff] [blame] | 871 | } |
drh | 6903bf6 | 2017-08-01 20:59:41 +0000 | [diff] [blame] | 872 | pCtx->bDeclared = 1; |
| 873 | }else{ |
drh | 54bc638 | 2021-12-31 19:20:42 +0000 | [diff] [blame] | 874 | sqlite3ErrorWithMsg(db, SQLITE_ERROR, |
| 875 | (sParse.zErrMsg ? "%s" : 0), sParse.zErrMsg); |
| 876 | sqlite3DbFree(db, sParse.zErrMsg); |
drh | 6903bf6 | 2017-08-01 20:59:41 +0000 | [diff] [blame] | 877 | rc = SQLITE_ERROR; |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 878 | } |
dan | cf8f289 | 2018-08-09 20:47:01 +0000 | [diff] [blame] | 879 | sParse.eParseMode = PARSE_MODE_NORMAL; |
drh | 6903bf6 | 2017-08-01 20:59:41 +0000 | [diff] [blame] | 880 | |
| 881 | if( sParse.pVdbe ){ |
| 882 | sqlite3VdbeFinalize(sParse.pVdbe); |
| 883 | } |
| 884 | sqlite3DeleteTable(db, sParse.pNewTable); |
drh | c692df2 | 2022-01-24 15:34:55 +0000 | [diff] [blame] | 885 | sqlite3ParseObjectReset(&sParse); |
drh | ebd1ff6 | 2021-09-24 12:59:33 +0000 | [diff] [blame] | 886 | db->init.busy = initBusy; |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 887 | |
drh | 4ac285a | 2006-09-15 07:28:50 +0000 | [diff] [blame] | 888 | assert( (rc&0xff)==rc ); |
drh | 2764170 | 2007-08-22 02:56:42 +0000 | [diff] [blame] | 889 | rc = sqlite3ApiExit(db, rc); |
| 890 | sqlite3_mutex_leave(db->mutex); |
| 891 | return rc; |
danielk1977 | 7e6ebfb | 2006-06-12 11:24:37 +0000 | [diff] [blame] | 892 | } |
| 893 | |
| 894 | /* |
danielk1977 | 9e39ce8 | 2006-06-12 16:01:21 +0000 | [diff] [blame] | 895 | ** This function is invoked by the vdbe to call the xDestroy method |
| 896 | ** of the virtual table named zTab in database iDb. This occurs |
| 897 | ** when a DROP TABLE is mentioned. |
| 898 | ** |
| 899 | ** This call is a no-op if zTab is not a virtual table. |
| 900 | */ |
drh | 748ce21 | 2009-05-20 20:10:47 +0000 | [diff] [blame] | 901 | int sqlite3VtabCallDestroy(sqlite3 *db, int iDb, const char *zTab){ |
danielk1977 | 9e39ce8 | 2006-06-12 16:01:21 +0000 | [diff] [blame] | 902 | int rc = SQLITE_OK; |
| 903 | Table *pTab; |
danielk1977 | 9e39ce8 | 2006-06-12 16:01:21 +0000 | [diff] [blame] | 904 | |
drh | 69c3382 | 2016-08-18 14:33:11 +0000 | [diff] [blame] | 905 | pTab = sqlite3FindTable(db, zTab, db->aDb[iDb].zDbSName); |
drh | 7b108e4 | 2021-11-06 20:25:29 +0000 | [diff] [blame] | 906 | if( ALWAYS(pTab!=0) |
| 907 | && ALWAYS(IsVirtual(pTab)) |
| 908 | && ALWAYS(pTab->u.vtab.p!=0) |
| 909 | ){ |
drh | a68d628 | 2015-03-24 13:32:53 +0000 | [diff] [blame] | 910 | VTable *p; |
mistachkin | 197d59f | 2015-08-20 21:14:31 +0000 | [diff] [blame] | 911 | int (*xDestroy)(sqlite3_vtab *); |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 912 | for(p=pTab->u.vtab.p; p; p=p->pNext){ |
drh | a68d628 | 2015-03-24 13:32:53 +0000 | [diff] [blame] | 913 | assert( p->pVtab ); |
| 914 | if( p->pVtab->nRef>0 ){ |
| 915 | return SQLITE_LOCKED; |
| 916 | } |
| 917 | } |
| 918 | p = vtabDisconnectAll(db, pTab); |
mistachkin | 197d59f | 2015-08-20 21:14:31 +0000 | [diff] [blame] | 919 | xDestroy = p->pMod->pModule->xDestroy; |
drh | a1ca00e | 2019-12-11 15:07:09 +0000 | [diff] [blame] | 920 | if( xDestroy==0 ) xDestroy = p->pMod->pModule->xDisconnect; |
| 921 | assert( xDestroy!=0 ); |
dan | c589acb | 2019-04-30 15:36:32 +0000 | [diff] [blame] | 922 | pTab->nTabRef++; |
drh | a1ca00e | 2019-12-11 15:07:09 +0000 | [diff] [blame] | 923 | rc = xDestroy(p->pVtab); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 924 | /* Remove the sqlite3_vtab* from the aVTrans[] array, if applicable */ |
danielk1977 | 9e39ce8 | 2006-06-12 16:01:21 +0000 | [diff] [blame] | 925 | if( rc==SQLITE_OK ){ |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 926 | assert( pTab->u.vtab.p==p && p->pNext==0 ); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 927 | p->pVtab = 0; |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 928 | pTab->u.vtab.p = 0; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 929 | sqlite3VtabUnlock(p); |
danielk1977 | 9e39ce8 | 2006-06-12 16:01:21 +0000 | [diff] [blame] | 930 | } |
dan | c589acb | 2019-04-30 15:36:32 +0000 | [diff] [blame] | 931 | sqlite3DeleteTable(db, pTab); |
danielk1977 | 9e39ce8 | 2006-06-12 16:01:21 +0000 | [diff] [blame] | 932 | } |
| 933 | |
| 934 | return rc; |
| 935 | } |
| 936 | |
danielk1977 | f9e7dda | 2006-06-16 16:08:53 +0000 | [diff] [blame] | 937 | /* |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 938 | ** This function invokes either the xRollback or xCommit method |
| 939 | ** of each of the virtual tables in the sqlite3.aVTrans array. The method |
| 940 | ** called is identified by the second argument, "offset", which is |
| 941 | ** the offset of the method to call in the sqlite3_module structure. |
| 942 | ** |
| 943 | ** The array is cleared after invoking the callbacks. |
| 944 | */ |
drh | 7209c69 | 2008-04-27 18:40:11 +0000 | [diff] [blame] | 945 | static void callFinaliser(sqlite3 *db, int offset){ |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 946 | int i; |
danielk1977 | 0b83fa8 | 2007-04-19 14:48:37 +0000 | [diff] [blame] | 947 | if( db->aVTrans ){ |
dan | e4bec37 | 2014-12-18 18:25:48 +0000 | [diff] [blame] | 948 | VTable **aVTrans = db->aVTrans; |
| 949 | db->aVTrans = 0; |
drh | 748ce21 | 2009-05-20 20:10:47 +0000 | [diff] [blame] | 950 | for(i=0; i<db->nVTrans; i++){ |
dan | e4bec37 | 2014-12-18 18:25:48 +0000 | [diff] [blame] | 951 | VTable *pVTab = aVTrans[i]; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 952 | sqlite3_vtab *p = pVTab->pVtab; |
| 953 | if( p ){ |
| 954 | int (*x)(sqlite3_vtab *); |
| 955 | x = *(int (**)(sqlite3_vtab *))((char *)p->pModule + offset); |
| 956 | if( x ) x(p); |
| 957 | } |
drh | 346506f | 2011-05-25 01:16:42 +0000 | [diff] [blame] | 958 | pVTab->iSavepoint = 0; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 959 | sqlite3VtabUnlock(pVTab); |
danielk1977 | 0b83fa8 | 2007-04-19 14:48:37 +0000 | [diff] [blame] | 960 | } |
dan | e4bec37 | 2014-12-18 18:25:48 +0000 | [diff] [blame] | 961 | sqlite3DbFree(db, aVTrans); |
danielk1977 | 0b83fa8 | 2007-04-19 14:48:37 +0000 | [diff] [blame] | 962 | db->nVTrans = 0; |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 963 | } |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 964 | } |
| 965 | |
| 966 | /* |
danielk1977 | 3e3a84d | 2008-08-01 17:37:40 +0000 | [diff] [blame] | 967 | ** Invoke the xSync method of all virtual tables in the sqlite3.aVTrans |
| 968 | ** array. Return the error code for the first error that occurs, or |
| 969 | ** SQLITE_OK if all xSync operations are successful. |
| 970 | ** |
dan | 016f781 | 2013-08-21 17:35:48 +0000 | [diff] [blame] | 971 | ** If an error message is available, leave it in p->zErrMsg. |
danielk1977 | f9e7dda | 2006-06-16 16:08:53 +0000 | [diff] [blame] | 972 | */ |
dan | 016f781 | 2013-08-21 17:35:48 +0000 | [diff] [blame] | 973 | int sqlite3VtabSync(sqlite3 *db, Vdbe *p){ |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 974 | int i; |
| 975 | int rc = SQLITE_OK; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 976 | VTable **aVTrans = db->aVTrans; |
danielk1977 | 20b1eaf | 2006-07-26 16:22:14 +0000 | [diff] [blame] | 977 | |
danielk1977 | 20b1eaf | 2006-07-26 16:22:14 +0000 | [diff] [blame] | 978 | db->aVTrans = 0; |
drh | 748ce21 | 2009-05-20 20:10:47 +0000 | [diff] [blame] | 979 | for(i=0; rc==SQLITE_OK && i<db->nVTrans; i++){ |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 980 | int (*x)(sqlite3_vtab *); |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 981 | sqlite3_vtab *pVtab = aVTrans[i]->pVtab; |
| 982 | if( pVtab && (x = pVtab->pModule->xSync)!=0 ){ |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 983 | rc = x(pVtab); |
dan | 016f781 | 2013-08-21 17:35:48 +0000 | [diff] [blame] | 984 | sqlite3VtabImportErrmsg(p, pVtab); |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 985 | } |
| 986 | } |
danielk1977 | 20b1eaf | 2006-07-26 16:22:14 +0000 | [diff] [blame] | 987 | db->aVTrans = aVTrans; |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 988 | return rc; |
danielk1977 | f9e7dda | 2006-06-16 16:08:53 +0000 | [diff] [blame] | 989 | } |
| 990 | |
| 991 | /* |
| 992 | ** Invoke the xRollback method of all virtual tables in the |
| 993 | ** sqlite3.aVTrans array. Then clear the array itself. |
| 994 | */ |
| 995 | int sqlite3VtabRollback(sqlite3 *db){ |
drh | 7209c69 | 2008-04-27 18:40:11 +0000 | [diff] [blame] | 996 | callFinaliser(db, offsetof(sqlite3_module,xRollback)); |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 997 | return SQLITE_OK; |
danielk1977 | f9e7dda | 2006-06-16 16:08:53 +0000 | [diff] [blame] | 998 | } |
| 999 | |
| 1000 | /* |
| 1001 | ** Invoke the xCommit method of all virtual tables in the |
| 1002 | ** sqlite3.aVTrans array. Then clear the array itself. |
| 1003 | */ |
| 1004 | int sqlite3VtabCommit(sqlite3 *db){ |
drh | 7209c69 | 2008-04-27 18:40:11 +0000 | [diff] [blame] | 1005 | callFinaliser(db, offsetof(sqlite3_module,xCommit)); |
danielk1977 | e7ff403 | 2006-06-17 11:30:32 +0000 | [diff] [blame] | 1006 | return SQLITE_OK; |
danielk1977 | f9e7dda | 2006-06-16 16:08:53 +0000 | [diff] [blame] | 1007 | } |
| 1008 | |
| 1009 | /* |
| 1010 | ** If the virtual table pVtab supports the transaction interface |
| 1011 | ** (xBegin/xRollback/xCommit and optionally xSync) and a transaction is |
| 1012 | ** not currently open, invoke the xBegin method now. |
| 1013 | ** |
| 1014 | ** If the xBegin call is successful, place the sqlite3_vtab pointer |
| 1015 | ** in the sqlite3.aVTrans array. |
| 1016 | */ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 1017 | int sqlite3VtabBegin(sqlite3 *db, VTable *pVTab){ |
danielk1977 | f9e7dda | 2006-06-16 16:08:53 +0000 | [diff] [blame] | 1018 | int rc = SQLITE_OK; |
danielk1977 | 20b1eaf | 2006-07-26 16:22:14 +0000 | [diff] [blame] | 1019 | const sqlite3_module *pModule; |
| 1020 | |
| 1021 | /* Special case: If db->aVTrans is NULL and db->nVTrans is greater |
| 1022 | ** than zero, then this function is being called from within a |
| 1023 | ** virtual module xSync() callback. It is illegal to write to |
drh | 748ce21 | 2009-05-20 20:10:47 +0000 | [diff] [blame] | 1024 | ** virtual module tables in this case, so return SQLITE_LOCKED. |
danielk1977 | 20b1eaf | 2006-07-26 16:22:14 +0000 | [diff] [blame] | 1025 | */ |
danielk1977 | 093e0f6 | 2008-11-13 18:00:14 +0000 | [diff] [blame] | 1026 | if( sqlite3VtabInSync(db) ){ |
danielk1977 | 20b1eaf | 2006-07-26 16:22:14 +0000 | [diff] [blame] | 1027 | return SQLITE_LOCKED; |
| 1028 | } |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 1029 | if( !pVTab ){ |
danielk1977 | 20b1eaf | 2006-07-26 16:22:14 +0000 | [diff] [blame] | 1030 | return SQLITE_OK; |
| 1031 | } |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 1032 | pModule = pVTab->pVtab->pModule; |
danielk1977 | 20b1eaf | 2006-07-26 16:22:14 +0000 | [diff] [blame] | 1033 | |
danielk1977 | f9e7dda | 2006-06-16 16:08:53 +0000 | [diff] [blame] | 1034 | if( pModule->xBegin ){ |
| 1035 | int i; |
| 1036 | |
| 1037 | /* If pVtab is already in the aVTrans array, return early */ |
drh | 748ce21 | 2009-05-20 20:10:47 +0000 | [diff] [blame] | 1038 | for(i=0; i<db->nVTrans; i++){ |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 1039 | if( db->aVTrans[i]==pVTab ){ |
danielk1977 | f9e7dda | 2006-06-16 16:08:53 +0000 | [diff] [blame] | 1040 | return SQLITE_OK; |
| 1041 | } |
| 1042 | } |
| 1043 | |
dan | 2cac207 | 2011-05-25 18:46:22 +0000 | [diff] [blame] | 1044 | /* Invoke the xBegin method. If successful, add the vtab to the |
| 1045 | ** sqlite3.aVTrans[] array. */ |
| 1046 | rc = growVTrans(db); |
danielk1977 | 3e3a84d | 2008-08-01 17:37:40 +0000 | [diff] [blame] | 1047 | if( rc==SQLITE_OK ){ |
dan | 2cac207 | 2011-05-25 18:46:22 +0000 | [diff] [blame] | 1048 | rc = pModule->xBegin(pVTab->pVtab); |
| 1049 | if( rc==SQLITE_OK ){ |
dan | 65c4f59 | 2015-09-29 16:41:23 +0000 | [diff] [blame] | 1050 | int iSvpt = db->nStatement + db->nSavepoint; |
dan | 2cac207 | 2011-05-25 18:46:22 +0000 | [diff] [blame] | 1051 | addToVTrans(db, pVTab); |
dan | 914b7e4 | 2016-08-02 11:29:16 +0000 | [diff] [blame] | 1052 | if( iSvpt && pModule->xSavepoint ){ |
| 1053 | pVTab->iSavepoint = iSvpt; |
| 1054 | rc = pModule->xSavepoint(pVTab->pVtab, iSvpt-1); |
| 1055 | } |
dan | 2cac207 | 2011-05-25 18:46:22 +0000 | [diff] [blame] | 1056 | } |
danielk1977 | f9e7dda | 2006-06-16 16:08:53 +0000 | [diff] [blame] | 1057 | } |
danielk1977 | f9e7dda | 2006-06-16 16:08:53 +0000 | [diff] [blame] | 1058 | } |
| 1059 | return rc; |
| 1060 | } |
| 1061 | |
dan | d9495cd | 2011-04-27 12:08:04 +0000 | [diff] [blame] | 1062 | /* |
| 1063 | ** Invoke either the xSavepoint, xRollbackTo or xRelease method of all |
| 1064 | ** virtual tables that currently have an open transaction. Pass iSavepoint |
| 1065 | ** as the second argument to the virtual table method invoked. |
| 1066 | ** |
| 1067 | ** If op is SAVEPOINT_BEGIN, the xSavepoint method is invoked. If it is |
| 1068 | ** SAVEPOINT_ROLLBACK, the xRollbackTo method. Otherwise, if op is |
| 1069 | ** SAVEPOINT_RELEASE, then the xRelease method of each virtual table with |
| 1070 | ** an open transaction is invoked. |
| 1071 | ** |
| 1072 | ** If any virtual table method returns an error code other than SQLITE_OK, |
| 1073 | ** processing is abandoned and the error returned to the caller of this |
| 1074 | ** function immediately. If all calls to virtual table methods are successful, |
| 1075 | ** SQLITE_OK is returned. |
| 1076 | */ |
dan | a311b80 | 2011-04-26 19:21:34 +0000 | [diff] [blame] | 1077 | int sqlite3VtabSavepoint(sqlite3 *db, int op, int iSavepoint){ |
dan | a311b80 | 2011-04-26 19:21:34 +0000 | [diff] [blame] | 1078 | int rc = SQLITE_OK; |
| 1079 | |
| 1080 | assert( op==SAVEPOINT_RELEASE||op==SAVEPOINT_ROLLBACK||op==SAVEPOINT_BEGIN ); |
dan | ea8562e | 2015-04-18 16:25:54 +0000 | [diff] [blame] | 1081 | assert( iSavepoint>=-1 ); |
dan | d9495cd | 2011-04-27 12:08:04 +0000 | [diff] [blame] | 1082 | if( db->aVTrans ){ |
| 1083 | int i; |
| 1084 | for(i=0; rc==SQLITE_OK && i<db->nVTrans; i++){ |
drh | e485522 | 2011-05-24 15:36:01 +0000 | [diff] [blame] | 1085 | VTable *pVTab = db->aVTrans[i]; |
| 1086 | const sqlite3_module *pMod = pVTab->pMod->pModule; |
dan | 341cade | 2011-10-29 11:43:04 +0000 | [diff] [blame] | 1087 | if( pVTab->pVtab && pMod->iVersion>=2 ){ |
dan | d9495cd | 2011-04-27 12:08:04 +0000 | [diff] [blame] | 1088 | int (*xMethod)(sqlite3_vtab *, int); |
dan | 83a635a | 2019-02-04 16:25:40 +0000 | [diff] [blame] | 1089 | sqlite3VtabLock(pVTab); |
dan | d9495cd | 2011-04-27 12:08:04 +0000 | [diff] [blame] | 1090 | switch( op ){ |
| 1091 | case SAVEPOINT_BEGIN: |
| 1092 | xMethod = pMod->xSavepoint; |
drh | 346506f | 2011-05-25 01:16:42 +0000 | [diff] [blame] | 1093 | pVTab->iSavepoint = iSavepoint+1; |
dan | d9495cd | 2011-04-27 12:08:04 +0000 | [diff] [blame] | 1094 | break; |
| 1095 | case SAVEPOINT_ROLLBACK: |
| 1096 | xMethod = pMod->xRollbackTo; |
| 1097 | break; |
| 1098 | default: |
| 1099 | xMethod = pMod->xRelease; |
| 1100 | break; |
| 1101 | } |
drh | 346506f | 2011-05-25 01:16:42 +0000 | [diff] [blame] | 1102 | if( xMethod && pVTab->iSavepoint>iSavepoint ){ |
dan | 341cade | 2011-10-29 11:43:04 +0000 | [diff] [blame] | 1103 | rc = xMethod(pVTab->pVtab, iSavepoint); |
drh | 346506f | 2011-05-25 01:16:42 +0000 | [diff] [blame] | 1104 | } |
dan | 83a635a | 2019-02-04 16:25:40 +0000 | [diff] [blame] | 1105 | sqlite3VtabUnlock(pVTab); |
dan | a311b80 | 2011-04-26 19:21:34 +0000 | [diff] [blame] | 1106 | } |
| 1107 | } |
| 1108 | } |
| 1109 | return rc; |
| 1110 | } |
| 1111 | |
drh | b7f6f68 | 2006-07-08 17:06:43 +0000 | [diff] [blame] | 1112 | /* |
| 1113 | ** The first parameter (pDef) is a function implementation. The |
| 1114 | ** second parameter (pExpr) is the first argument to this function. |
| 1115 | ** If pExpr is a column in a virtual table, then let the virtual |
| 1116 | ** table implementation have an opportunity to overload the function. |
| 1117 | ** |
| 1118 | ** This routine is used to allow virtual table implementations to |
| 1119 | ** overload MATCH, LIKE, GLOB, and REGEXP operators. |
| 1120 | ** |
| 1121 | ** Return either the pDef argument (indicating no change) or a |
| 1122 | ** new FuncDef structure that is marked as ephemeral using the |
| 1123 | ** SQLITE_FUNC_EPHEM flag. |
| 1124 | */ |
| 1125 | FuncDef *sqlite3VtabOverloadFunction( |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1126 | sqlite3 *db, /* Database connection for reporting malloc problems */ |
drh | b7f6f68 | 2006-07-08 17:06:43 +0000 | [diff] [blame] | 1127 | FuncDef *pDef, /* Function to possibly overload */ |
| 1128 | int nArg, /* Number of arguments to the function */ |
| 1129 | Expr *pExpr /* First argument to the function */ |
| 1130 | ){ |
| 1131 | Table *pTab; |
| 1132 | sqlite3_vtab *pVtab; |
| 1133 | sqlite3_module *pMod; |
drh | 2d80151 | 2016-01-14 22:19:58 +0000 | [diff] [blame] | 1134 | void (*xSFunc)(sqlite3_context*,int,sqlite3_value**) = 0; |
drh | dc5ea5c | 2008-12-10 17:19:59 +0000 | [diff] [blame] | 1135 | void *pArg = 0; |
drh | b7f6f68 | 2006-07-08 17:06:43 +0000 | [diff] [blame] | 1136 | FuncDef *pNew; |
drh | 777b17a | 2007-09-20 10:02:54 +0000 | [diff] [blame] | 1137 | int rc = 0; |
drh | b7f6f68 | 2006-07-08 17:06:43 +0000 | [diff] [blame] | 1138 | |
| 1139 | /* Check to see the left operand is a column in a virtual table */ |
drh | 748ce21 | 2009-05-20 20:10:47 +0000 | [diff] [blame] | 1140 | if( NEVER(pExpr==0) ) return pDef; |
drh | b7f6f68 | 2006-07-08 17:06:43 +0000 | [diff] [blame] | 1141 | if( pExpr->op!=TK_COLUMN ) return pDef; |
drh | 477572b | 2021-10-07 20:46:29 +0000 | [diff] [blame] | 1142 | assert( ExprUseYTab(pExpr) ); |
drh | eda079c | 2018-09-20 19:02:15 +0000 | [diff] [blame] | 1143 | pTab = pExpr->y.pTab; |
drh | 63b3a64 | 2022-10-20 13:36:32 +0000 | [diff] [blame] | 1144 | if( NEVER(pTab==0) ) return pDef; |
drh | 44266ec | 2017-02-16 14:48:08 +0000 | [diff] [blame] | 1145 | if( !IsVirtual(pTab) ) return pDef; |
danielk1977 | 595a523 | 2009-07-24 17:58:53 +0000 | [diff] [blame] | 1146 | pVtab = sqlite3GetVTable(db, pTab)->pVtab; |
drh | b7f6f68 | 2006-07-08 17:06:43 +0000 | [diff] [blame] | 1147 | assert( pVtab!=0 ); |
| 1148 | assert( pVtab->pModule!=0 ); |
danielk1977 | 5bd270b | 2006-07-25 15:14:52 +0000 | [diff] [blame] | 1149 | pMod = (sqlite3_module *)pVtab->pModule; |
drh | b7f6f68 | 2006-07-08 17:06:43 +0000 | [diff] [blame] | 1150 | if( pMod->xFindFunction==0 ) return pDef; |
| 1151 | |
rse | b72e88d | 2007-09-20 11:32:18 +0000 | [diff] [blame] | 1152 | /* Call the xFindFunction method on the virtual table implementation |
drh | 9201184 | 2018-05-26 16:00:26 +0000 | [diff] [blame] | 1153 | ** to see if the implementation wants to overload this function. |
| 1154 | ** |
| 1155 | ** Though undocumented, we have historically always invoked xFindFunction |
| 1156 | ** with an all lower-case function name. Continue in this tradition to |
| 1157 | ** avoid any chance of an incompatibility. |
drh | a70034d | 2006-09-18 20:24:02 +0000 | [diff] [blame] | 1158 | */ |
drh | 9201184 | 2018-05-26 16:00:26 +0000 | [diff] [blame] | 1159 | #ifdef SQLITE_DEBUG |
| 1160 | { |
| 1161 | int i; |
| 1162 | for(i=0; pDef->zName[i]; i++){ |
| 1163 | unsigned char x = (unsigned char)pDef->zName[i]; |
| 1164 | assert( x==sqlite3UpperToLower[x] ); |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1165 | } |
drh | a70034d | 2006-09-18 20:24:02 +0000 | [diff] [blame] | 1166 | } |
drh | 9201184 | 2018-05-26 16:00:26 +0000 | [diff] [blame] | 1167 | #endif |
| 1168 | rc = pMod->xFindFunction(pVtab, nArg, pDef->zName, &xSFunc, &pArg); |
drh | a70034d | 2006-09-18 20:24:02 +0000 | [diff] [blame] | 1169 | if( rc==0 ){ |
drh | b7f6f68 | 2006-07-08 17:06:43 +0000 | [diff] [blame] | 1170 | return pDef; |
| 1171 | } |
| 1172 | |
| 1173 | /* Create a new ephemeral function definition for the overloaded |
| 1174 | ** function */ |
drh | ea67883 | 2008-12-10 19:26:22 +0000 | [diff] [blame] | 1175 | pNew = sqlite3DbMallocZero(db, sizeof(*pNew) |
danielk1977 | e25a50b | 2009-07-01 18:04:20 +0000 | [diff] [blame] | 1176 | + sqlite3Strlen30(pDef->zName) + 1); |
drh | b7f6f68 | 2006-07-08 17:06:43 +0000 | [diff] [blame] | 1177 | if( pNew==0 ){ |
| 1178 | return pDef; |
| 1179 | } |
| 1180 | *pNew = *pDef; |
drh | 6ad224e | 2016-02-24 19:57:11 +0000 | [diff] [blame] | 1181 | pNew->zName = (const char*)&pNew[1]; |
| 1182 | memcpy((char*)&pNew[1], pDef->zName, sqlite3Strlen30(pDef->zName)+1); |
drh | 2d80151 | 2016-01-14 22:19:58 +0000 | [diff] [blame] | 1183 | pNew->xSFunc = xSFunc; |
drh | b7f6f68 | 2006-07-08 17:06:43 +0000 | [diff] [blame] | 1184 | pNew->pUserData = pArg; |
drh | d36e104 | 2013-09-06 13:10:12 +0000 | [diff] [blame] | 1185 | pNew->funcFlags |= SQLITE_FUNC_EPHEM; |
drh | b7f6f68 | 2006-07-08 17:06:43 +0000 | [diff] [blame] | 1186 | return pNew; |
| 1187 | } |
| 1188 | |
drh | 4f3dd15 | 2008-04-28 18:46:43 +0000 | [diff] [blame] | 1189 | /* |
| 1190 | ** Make sure virtual table pTab is contained in the pParse->apVirtualLock[] |
| 1191 | ** array so that an OP_VBegin will get generated for it. Add pTab to the |
| 1192 | ** array if it is missing. If pTab is already in the array, this routine |
| 1193 | ** is a no-op. |
| 1194 | */ |
| 1195 | void sqlite3VtabMakeWritable(Parse *pParse, Table *pTab){ |
dan | 65a7cd1 | 2009-09-01 12:16:01 +0000 | [diff] [blame] | 1196 | Parse *pToplevel = sqlite3ParseToplevel(pParse); |
drh | 4f3dd15 | 2008-04-28 18:46:43 +0000 | [diff] [blame] | 1197 | int i, n; |
drh | 748ce21 | 2009-05-20 20:10:47 +0000 | [diff] [blame] | 1198 | Table **apVtabLock; |
| 1199 | |
drh | 4f3dd15 | 2008-04-28 18:46:43 +0000 | [diff] [blame] | 1200 | assert( IsVirtual(pTab) ); |
dan | 65a7cd1 | 2009-09-01 12:16:01 +0000 | [diff] [blame] | 1201 | for(i=0; i<pToplevel->nVtabLock; i++){ |
| 1202 | if( pTab==pToplevel->apVtabLock[i] ) return; |
drh | 4f3dd15 | 2008-04-28 18:46:43 +0000 | [diff] [blame] | 1203 | } |
dan | 65a7cd1 | 2009-09-01 12:16:01 +0000 | [diff] [blame] | 1204 | n = (pToplevel->nVtabLock+1)*sizeof(pToplevel->apVtabLock[0]); |
drh | d924e7b | 2020-05-17 00:26:44 +0000 | [diff] [blame] | 1205 | apVtabLock = sqlite3Realloc(pToplevel->apVtabLock, n); |
drh | 748ce21 | 2009-05-20 20:10:47 +0000 | [diff] [blame] | 1206 | if( apVtabLock ){ |
dan | 65a7cd1 | 2009-09-01 12:16:01 +0000 | [diff] [blame] | 1207 | pToplevel->apVtabLock = apVtabLock; |
| 1208 | pToplevel->apVtabLock[pToplevel->nVtabLock++] = pTab; |
drh | 344c38e | 2008-05-05 13:23:04 +0000 | [diff] [blame] | 1209 | }else{ |
drh | 4a642b6 | 2016-02-05 01:55:27 +0000 | [diff] [blame] | 1210 | sqlite3OomFault(pToplevel->db); |
drh | 4f3dd15 | 2008-04-28 18:46:43 +0000 | [diff] [blame] | 1211 | } |
| 1212 | } |
| 1213 | |
drh | ef45bb7 | 2011-05-05 15:39:50 +0000 | [diff] [blame] | 1214 | /* |
drh | 0b2c140 | 2016-06-03 18:21:04 +0000 | [diff] [blame] | 1215 | ** Check to see if virtual table module pMod can be have an eponymous |
drh | 51be387 | 2015-08-19 02:32:25 +0000 | [diff] [blame] | 1216 | ** virtual table instance. If it can, create one if one does not already |
dan | bd24e8f | 2021-07-08 18:29:25 +0000 | [diff] [blame] | 1217 | ** exist. Return non-zero if either the eponymous virtual table instance |
| 1218 | ** exists when this routine returns or if an attempt to create it failed |
| 1219 | ** and an error message was left in pParse. |
drh | 51be387 | 2015-08-19 02:32:25 +0000 | [diff] [blame] | 1220 | ** |
| 1221 | ** An eponymous virtual table instance is one that is named after its |
| 1222 | ** module, and more importantly, does not require a CREATE VIRTUAL TABLE |
| 1223 | ** statement in order to come into existance. Eponymous virtual table |
| 1224 | ** instances always exist. They cannot be DROP-ed. |
| 1225 | ** |
| 1226 | ** Any virtual table module for which xConnect and xCreate are the same |
| 1227 | ** method can have an eponymous virtual table instance. |
| 1228 | */ |
| 1229 | int sqlite3VtabEponymousTableInit(Parse *pParse, Module *pMod){ |
| 1230 | const sqlite3_module *pModule = pMod->pModule; |
| 1231 | Table *pTab; |
| 1232 | char *zErr = 0; |
drh | 51be387 | 2015-08-19 02:32:25 +0000 | [diff] [blame] | 1233 | int rc; |
| 1234 | sqlite3 *db = pParse->db; |
| 1235 | if( pMod->pEpoTab ) return 1; |
drh | 398f872 | 2015-08-19 13:54:20 +0000 | [diff] [blame] | 1236 | if( pModule->xCreate!=0 && pModule->xCreate!=pModule->xConnect ) return 0; |
drh | 0b2c140 | 2016-06-03 18:21:04 +0000 | [diff] [blame] | 1237 | pTab = sqlite3DbMallocZero(db, sizeof(Table)); |
drh | 51be387 | 2015-08-19 02:32:25 +0000 | [diff] [blame] | 1238 | if( pTab==0 ) return 0; |
drh | 0b2c140 | 2016-06-03 18:21:04 +0000 | [diff] [blame] | 1239 | pTab->zName = sqlite3DbStrDup(db, pMod->zName); |
| 1240 | if( pTab->zName==0 ){ |
| 1241 | sqlite3DbFree(db, pTab); |
| 1242 | return 0; |
| 1243 | } |
drh | 51be387 | 2015-08-19 02:32:25 +0000 | [diff] [blame] | 1244 | pMod->pEpoTab = pTab; |
drh | 79df778 | 2016-12-14 14:07:35 +0000 | [diff] [blame] | 1245 | pTab->nTabRef = 1; |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 1246 | pTab->eTabType = TABTYP_VTAB; |
drh | 51be387 | 2015-08-19 02:32:25 +0000 | [diff] [blame] | 1247 | pTab->pSchema = db->aDb[0].pSchema; |
drh | f38524d | 2021-08-02 16:41:57 +0000 | [diff] [blame] | 1248 | assert( pTab->u.vtab.nArg==0 ); |
drh | 509c3fc | 2015-08-19 19:01:28 +0000 | [diff] [blame] | 1249 | pTab->iPKey = -1; |
drh | 3d8c92d | 2021-04-22 18:02:48 +0000 | [diff] [blame] | 1250 | pTab->tabFlags |= TF_Eponymous; |
drh | 0aa3231 | 2019-04-13 04:01:12 +0000 | [diff] [blame] | 1251 | addModuleArgument(pParse, pTab, sqlite3DbStrDup(db, pTab->zName)); |
| 1252 | addModuleArgument(pParse, pTab, 0); |
| 1253 | addModuleArgument(pParse, pTab, sqlite3DbStrDup(db, pTab->zName)); |
drh | 51be387 | 2015-08-19 02:32:25 +0000 | [diff] [blame] | 1254 | rc = vtabCallConstructor(db, pTab, pMod, pModule->xConnect, &zErr); |
| 1255 | if( rc ){ |
| 1256 | sqlite3ErrorMsg(pParse, "%s", zErr); |
| 1257 | sqlite3DbFree(db, zErr); |
| 1258 | sqlite3VtabEponymousTableClear(db, pMod); |
drh | 51be387 | 2015-08-19 02:32:25 +0000 | [diff] [blame] | 1259 | } |
| 1260 | return 1; |
| 1261 | } |
| 1262 | |
| 1263 | /* |
| 1264 | ** Erase the eponymous virtual table instance associated with |
| 1265 | ** virtual table module pMod, if it exists. |
| 1266 | */ |
| 1267 | void sqlite3VtabEponymousTableClear(sqlite3 *db, Module *pMod){ |
| 1268 | Table *pTab = pMod->pEpoTab; |
drh | d7fd6aa | 2015-10-08 02:44:42 +0000 | [diff] [blame] | 1269 | if( pTab!=0 ){ |
drh | 0b2c140 | 2016-06-03 18:21:04 +0000 | [diff] [blame] | 1270 | /* Mark the table as Ephemeral prior to deleting it, so that the |
| 1271 | ** sqlite3DeleteTable() routine will know that it is not stored in |
| 1272 | ** the schema. */ |
| 1273 | pTab->tabFlags |= TF_Ephemeral; |
| 1274 | sqlite3DeleteTable(db, pTab); |
drh | 51be387 | 2015-08-19 02:32:25 +0000 | [diff] [blame] | 1275 | pMod->pEpoTab = 0; |
| 1276 | } |
| 1277 | } |
| 1278 | |
| 1279 | /* |
drh | ef45bb7 | 2011-05-05 15:39:50 +0000 | [diff] [blame] | 1280 | ** Return the ON CONFLICT resolution mode in effect for the virtual |
| 1281 | ** table update operation currently in progress. |
| 1282 | ** |
| 1283 | ** The results of this routine are undefined unless it is called from |
| 1284 | ** within an xUpdate method. |
| 1285 | */ |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1286 | int sqlite3_vtab_on_conflict(sqlite3 *db){ |
drh | ef45bb7 | 2011-05-05 15:39:50 +0000 | [diff] [blame] | 1287 | static const unsigned char aMap[] = { |
drh | 87f67bf | 2011-05-05 17:41:58 +0000 | [diff] [blame] | 1288 | SQLITE_ROLLBACK, SQLITE_ABORT, SQLITE_FAIL, SQLITE_IGNORE, SQLITE_REPLACE |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1289 | }; |
drh | 9ca9573 | 2014-10-24 00:35:58 +0000 | [diff] [blame] | 1290 | #ifdef SQLITE_ENABLE_API_ARMOR |
| 1291 | if( !sqlite3SafetyCheckOk(db) ) return SQLITE_MISUSE_BKPT; |
| 1292 | #endif |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1293 | assert( OE_Rollback==1 && OE_Abort==2 && OE_Fail==3 ); |
| 1294 | assert( OE_Ignore==4 && OE_Replace==5 ); |
| 1295 | assert( db->vtabOnConflict>=1 && db->vtabOnConflict<=5 ); |
drh | ef45bb7 | 2011-05-05 15:39:50 +0000 | [diff] [blame] | 1296 | return (int)aMap[db->vtabOnConflict-1]; |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1297 | } |
| 1298 | |
drh | ef45bb7 | 2011-05-05 15:39:50 +0000 | [diff] [blame] | 1299 | /* |
| 1300 | ** Call from within the xCreate() or xConnect() methods to provide |
| 1301 | ** the SQLite core with additional information about the behavior |
| 1302 | ** of the virtual table being implemented. |
| 1303 | */ |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1304 | int sqlite3_vtab_config(sqlite3 *db, int op, ...){ |
| 1305 | va_list ap; |
| 1306 | int rc = SQLITE_OK; |
drh | 2928a15 | 2020-01-06 15:25:41 +0000 | [diff] [blame] | 1307 | VtabCtx *p; |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1308 | |
drh | 9ca9573 | 2014-10-24 00:35:58 +0000 | [diff] [blame] | 1309 | #ifdef SQLITE_ENABLE_API_ARMOR |
| 1310 | if( !sqlite3SafetyCheckOk(db) ) return SQLITE_MISUSE_BKPT; |
| 1311 | #endif |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1312 | sqlite3_mutex_enter(db->mutex); |
drh | 2928a15 | 2020-01-06 15:25:41 +0000 | [diff] [blame] | 1313 | p = db->pVtabCtx; |
| 1314 | if( !p ){ |
| 1315 | rc = SQLITE_MISUSE_BKPT; |
| 1316 | }else{ |
| 1317 | assert( p->pTab==0 || IsVirtual(p->pTab) ); |
| 1318 | va_start(ap, op); |
| 1319 | switch( op ){ |
| 1320 | case SQLITE_VTAB_CONSTRAINT_SUPPORT: { |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1321 | p->pVTable->bConstraint = (u8)va_arg(ap, int); |
drh | 2928a15 | 2020-01-06 15:25:41 +0000 | [diff] [blame] | 1322 | break; |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1323 | } |
drh | 2928a15 | 2020-01-06 15:25:41 +0000 | [diff] [blame] | 1324 | case SQLITE_VTAB_INNOCUOUS: { |
| 1325 | p->pVTable->eVtabRisk = SQLITE_VTABRISK_Low; |
| 1326 | break; |
| 1327 | } |
| 1328 | case SQLITE_VTAB_DIRECTONLY: { |
| 1329 | p->pVTable->eVtabRisk = SQLITE_VTABRISK_High; |
| 1330 | break; |
| 1331 | } |
| 1332 | default: { |
| 1333 | rc = SQLITE_MISUSE_BKPT; |
| 1334 | break; |
| 1335 | } |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1336 | } |
drh | 2928a15 | 2020-01-06 15:25:41 +0000 | [diff] [blame] | 1337 | va_end(ap); |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1338 | } |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1339 | |
drh | 13f40da | 2014-08-22 18:00:11 +0000 | [diff] [blame] | 1340 | if( rc!=SQLITE_OK ) sqlite3Error(db, rc); |
dan | b061d05 | 2011-04-25 18:49:57 +0000 | [diff] [blame] | 1341 | sqlite3_mutex_leave(db->mutex); |
| 1342 | return rc; |
| 1343 | } |
| 1344 | |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 1345 | #endif /* SQLITE_OMIT_VIRTUALTABLE */ |