blob: 0c3cd7b2212570c64fc8d2764ff48e75e09f7d1d [file] [log] [blame]
drh4f26d6c2004-05-26 23:25:30 +00001/*
2** 2004 May 26
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**
13** This file contains code use to implement APIs that are part of the
14** VDBE.
danielk1977822a5162008-05-16 04:51:54 +000015**
drhac80db72009-04-14 12:58:20 +000016** $Id: vdbeapi.c,v 1.163 2009/04/14 12:58:20 drh Exp $
drh4f26d6c2004-05-26 23:25:30 +000017*/
18#include "sqliteInt.h"
19#include "vdbeInt.h"
20
danielk197767e3da72008-08-21 12:19:44 +000021#if 0 && defined(SQLITE_ENABLE_MEMORY_MANAGEMENT)
danielk1977dfb316d2008-03-26 18:34:43 +000022/*
23** The following structure contains pointers to the end points of a
24** doubly-linked list of all compiled SQL statements that may be holding
25** buffers eligible for release when the sqlite3_release_memory() interface is
26** invoked. Access to this list is protected by the SQLITE_MUTEX_STATIC_LRU2
27** mutex.
28**
29** Statements are added to the end of this list when sqlite3_reset() is
30** called. They are removed either when sqlite3_step() or sqlite3_finalize()
31** is called. When statements are added to this list, the associated
32** register array (p->aMem[1..p->nMem]) may contain dynamic buffers that
33** can be freed using sqlite3VdbeReleaseMemory().
34**
35** When statements are added or removed from this list, the mutex
36** associated with the Vdbe being added or removed (Vdbe.db->mutex) is
37** already held. The LRU2 mutex is then obtained, blocking if necessary,
38** the linked-list pointers manipulated and the LRU2 mutex relinquished.
39*/
40struct StatementLruList {
41 Vdbe *pFirst;
42 Vdbe *pLast;
43};
44static struct StatementLruList sqlite3LruStatements;
45
46/*
47** Check that the list looks to be internally consistent. This is used
48** as part of an assert() statement as follows:
49**
50** assert( stmtLruCheck() );
51*/
drh26e4a8b2008-05-01 17:16:52 +000052#ifndef NDEBUG
danielk1977dfb316d2008-03-26 18:34:43 +000053static int stmtLruCheck(){
54 Vdbe *p;
55 for(p=sqlite3LruStatements.pFirst; p; p=p->pLruNext){
56 assert(p->pLruNext || p==sqlite3LruStatements.pLast);
57 assert(!p->pLruNext || p->pLruNext->pLruPrev==p);
58 assert(p->pLruPrev || p==sqlite3LruStatements.pFirst);
59 assert(!p->pLruPrev || p->pLruPrev->pLruNext==p);
60 }
61 return 1;
62}
drh26e4a8b2008-05-01 17:16:52 +000063#endif
danielk1977dfb316d2008-03-26 18:34:43 +000064
65/*
66** Add vdbe p to the end of the statement lru list. It is assumed that
67** p is not already part of the list when this is called. The lru list
68** is protected by the SQLITE_MUTEX_STATIC_LRU mutex.
69*/
70static void stmtLruAdd(Vdbe *p){
danielk197759f8c082008-06-18 17:09:10 +000071 sqlite3_mutex_enter(sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_LRU2));
danielk1977dfb316d2008-03-26 18:34:43 +000072
73 if( p->pLruPrev || p->pLruNext || sqlite3LruStatements.pFirst==p ){
danielk197759f8c082008-06-18 17:09:10 +000074 sqlite3_mutex_leave(sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_LRU2));
danielk1977dfb316d2008-03-26 18:34:43 +000075 return;
76 }
77
78 assert( stmtLruCheck() );
79
80 if( !sqlite3LruStatements.pFirst ){
81 assert( !sqlite3LruStatements.pLast );
82 sqlite3LruStatements.pFirst = p;
83 sqlite3LruStatements.pLast = p;
84 }else{
85 assert( !sqlite3LruStatements.pLast->pLruNext );
86 p->pLruPrev = sqlite3LruStatements.pLast;
87 sqlite3LruStatements.pLast->pLruNext = p;
88 sqlite3LruStatements.pLast = p;
89 }
90
91 assert( stmtLruCheck() );
92
danielk197759f8c082008-06-18 17:09:10 +000093 sqlite3_mutex_leave(sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_LRU2));
danielk1977dfb316d2008-03-26 18:34:43 +000094}
95
96/*
97** Assuming the SQLITE_MUTEX_STATIC_LRU2 mutext is already held, remove
98** statement p from the least-recently-used statement list. If the
99** statement is not currently part of the list, this call is a no-op.
100*/
101static void stmtLruRemoveNomutex(Vdbe *p){
102 if( p->pLruPrev || p->pLruNext || p==sqlite3LruStatements.pFirst ){
103 assert( stmtLruCheck() );
104 if( p->pLruNext ){
105 p->pLruNext->pLruPrev = p->pLruPrev;
106 }else{
107 sqlite3LruStatements.pLast = p->pLruPrev;
108 }
109 if( p->pLruPrev ){
110 p->pLruPrev->pLruNext = p->pLruNext;
111 }else{
112 sqlite3LruStatements.pFirst = p->pLruNext;
113 }
114 p->pLruNext = 0;
115 p->pLruPrev = 0;
116 assert( stmtLruCheck() );
117 }
118}
119
120/*
121** Assuming the SQLITE_MUTEX_STATIC_LRU2 mutext is not held, remove
122** statement p from the least-recently-used statement list. If the
123** statement is not currently part of the list, this call is a no-op.
124*/
125static void stmtLruRemove(Vdbe *p){
danielk197759f8c082008-06-18 17:09:10 +0000126 sqlite3_mutex_enter(sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_LRU2));
danielk1977dfb316d2008-03-26 18:34:43 +0000127 stmtLruRemoveNomutex(p);
danielk197759f8c082008-06-18 17:09:10 +0000128 sqlite3_mutex_leave(sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_LRU2));
danielk1977dfb316d2008-03-26 18:34:43 +0000129}
130
131/*
132** Try to release n bytes of memory by freeing buffers associated
133** with the memory registers of currently unused vdbes.
134*/
135int sqlite3VdbeReleaseMemory(int n){
136 Vdbe *p;
137 Vdbe *pNext;
138 int nFree = 0;
139
danielk197759f8c082008-06-18 17:09:10 +0000140 sqlite3_mutex_enter(sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_LRU2));
danielk1977dfb316d2008-03-26 18:34:43 +0000141 for(p=sqlite3LruStatements.pFirst; p && nFree<n; p=pNext){
142 pNext = p->pLruNext;
143
144 /* For each statement handle in the lru list, attempt to obtain the
145 ** associated database mutex. If it cannot be obtained, continue
146 ** to the next statement handle. It is not possible to block on
147 ** the database mutex - that could cause deadlock.
148 */
149 if( SQLITE_OK==sqlite3_mutex_try(p->db->mutex) ){
150 nFree += sqlite3VdbeReleaseBuffers(p);
151 stmtLruRemoveNomutex(p);
152 sqlite3_mutex_leave(p->db->mutex);
153 }
154 }
danielk197759f8c082008-06-18 17:09:10 +0000155 sqlite3_mutex_leave(sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_LRU2));
danielk1977dfb316d2008-03-26 18:34:43 +0000156
157 return nFree;
158}
159
160/*
161** Call sqlite3Reprepare() on the statement. Remove it from the
162** lru list before doing so, as Reprepare() will free all the
163** memory register buffers anyway.
164*/
165int vdbeReprepare(Vdbe *p){
166 stmtLruRemove(p);
167 return sqlite3Reprepare(p);
168}
169
170#else /* !SQLITE_ENABLE_MEMORY_MANAGEMENT */
171 #define stmtLruRemove(x)
172 #define stmtLruAdd(x)
173 #define vdbeReprepare(x) sqlite3Reprepare(x)
174#endif
175
176
shaneeec556d2008-10-12 00:27:53 +0000177#ifndef SQLITE_OMIT_DEPRECATED
drhd89bd002005-01-22 03:03:54 +0000178/*
179** Return TRUE (non-zero) of the statement supplied as an argument needs
180** to be recompiled. A statement needs to be recompiled whenever the
181** execution environment changes in a way that would alter the program
182** that sqlite3_prepare() generates. For example, if new functions or
183** collating sequences are registered or if an authorizer function is
184** added or changed.
drhd89bd002005-01-22 03:03:54 +0000185*/
186int sqlite3_expired(sqlite3_stmt *pStmt){
187 Vdbe *p = (Vdbe*)pStmt;
188 return p==0 || p->expired;
189}
shaneeec556d2008-10-12 00:27:53 +0000190#endif
drhd89bd002005-01-22 03:03:54 +0000191
drhe30f4422007-08-21 16:15:55 +0000192/*
193** The following routine destroys a virtual machine that is created by
194** the sqlite3_compile() routine. The integer returned is an SQLITE_
195** success/failure code that describes the result of executing the virtual
196** machine.
197**
198** This routine sets the error code and string returned by
199** sqlite3_errcode(), sqlite3_errmsg() and sqlite3_errmsg16().
200*/
201int sqlite3_finalize(sqlite3_stmt *pStmt){
202 int rc;
203 if( pStmt==0 ){
204 rc = SQLITE_OK;
205 }else{
206 Vdbe *v = (Vdbe*)pStmt;
danielk1977238746a2009-03-19 18:51:06 +0000207 sqlite3 *db = v->db;
drh18472fa2008-10-07 15:25:48 +0000208#if SQLITE_THREADSAFE
drh86f8c192007-08-22 00:39:19 +0000209 sqlite3_mutex *mutex = v->db->mutex;
drh7e8b8482008-01-23 03:03:05 +0000210#endif
drh86f8c192007-08-22 00:39:19 +0000211 sqlite3_mutex_enter(mutex);
danielk1977dfb316d2008-03-26 18:34:43 +0000212 stmtLruRemove(v);
drhe30f4422007-08-21 16:15:55 +0000213 rc = sqlite3VdbeFinalize(v);
danielk1977238746a2009-03-19 18:51:06 +0000214 rc = sqlite3ApiExit(db, rc);
drh86f8c192007-08-22 00:39:19 +0000215 sqlite3_mutex_leave(mutex);
drhe30f4422007-08-21 16:15:55 +0000216 }
217 return rc;
218}
219
220/*
221** Terminate the current execution of an SQL statement and reset it
222** back to its starting state so that it can be reused. A success code from
223** the prior execution is returned.
224**
225** This routine sets the error code and string returned by
226** sqlite3_errcode(), sqlite3_errmsg() and sqlite3_errmsg16().
227*/
228int sqlite3_reset(sqlite3_stmt *pStmt){
229 int rc;
230 if( pStmt==0 ){
231 rc = SQLITE_OK;
232 }else{
233 Vdbe *v = (Vdbe*)pStmt;
234 sqlite3_mutex_enter(v->db->mutex);
drhc890fec2008-08-01 20:10:08 +0000235 rc = sqlite3VdbeReset(v);
danielk1977dfb316d2008-03-26 18:34:43 +0000236 stmtLruAdd(v);
drhe30f4422007-08-21 16:15:55 +0000237 sqlite3VdbeMakeReady(v, -1, 0, 0, 0);
238 assert( (rc & (v->db->errMask))==rc );
danielk1977238746a2009-03-19 18:51:06 +0000239 rc = sqlite3ApiExit(v->db, rc);
drhe30f4422007-08-21 16:15:55 +0000240 sqlite3_mutex_leave(v->db->mutex);
241 }
242 return rc;
243}
244
245/*
246** Set all the parameters in the compiled SQL statement to NULL.
247*/
248int sqlite3_clear_bindings(sqlite3_stmt *pStmt){
249 int i;
250 int rc = SQLITE_OK;
drh7297d1f2008-05-09 14:39:44 +0000251 Vdbe *p = (Vdbe*)pStmt;
drh18472fa2008-10-07 15:25:48 +0000252#if SQLITE_THREADSAFE
drh7e8b8482008-01-23 03:03:05 +0000253 sqlite3_mutex *mutex = ((Vdbe*)pStmt)->db->mutex;
254#endif
255 sqlite3_mutex_enter(mutex);
drh7297d1f2008-05-09 14:39:44 +0000256 for(i=0; i<p->nVar; i++){
257 sqlite3VdbeMemRelease(&p->aVar[i]);
258 p->aVar[i].flags = MEM_Null;
drhe30f4422007-08-21 16:15:55 +0000259 }
drh7e8b8482008-01-23 03:03:05 +0000260 sqlite3_mutex_leave(mutex);
drhe30f4422007-08-21 16:15:55 +0000261 return rc;
262}
263
264
drh4f26d6c2004-05-26 23:25:30 +0000265/**************************** sqlite3_value_ *******************************
266** The following routines extract information from a Mem or sqlite3_value
267** structure.
268*/
269const void *sqlite3_value_blob(sqlite3_value *pVal){
270 Mem *p = (Mem*)pVal;
271 if( p->flags & (MEM_Blob|MEM_Str) ){
drhb21c8cd2007-08-21 19:33:56 +0000272 sqlite3VdbeMemExpandBlob(p);
drh1f0feef2007-05-15 13:27:07 +0000273 p->flags &= ~MEM_Str;
274 p->flags |= MEM_Blob;
drh4f26d6c2004-05-26 23:25:30 +0000275 return p->z;
276 }else{
277 return sqlite3_value_text(pVal);
278 }
279}
280int sqlite3_value_bytes(sqlite3_value *pVal){
drhb21c8cd2007-08-21 19:33:56 +0000281 return sqlite3ValueBytes(pVal, SQLITE_UTF8);
drh4f26d6c2004-05-26 23:25:30 +0000282}
283int sqlite3_value_bytes16(sqlite3_value *pVal){
drhb21c8cd2007-08-21 19:33:56 +0000284 return sqlite3ValueBytes(pVal, SQLITE_UTF16NATIVE);
drh4f26d6c2004-05-26 23:25:30 +0000285}
286double sqlite3_value_double(sqlite3_value *pVal){
drh6a6124e2004-06-27 01:56:33 +0000287 return sqlite3VdbeRealValue((Mem*)pVal);
drh4f26d6c2004-05-26 23:25:30 +0000288}
289int sqlite3_value_int(sqlite3_value *pVal){
drhb27b7f52008-12-10 18:03:45 +0000290 return (int)sqlite3VdbeIntValue((Mem*)pVal);
drh4f26d6c2004-05-26 23:25:30 +0000291}
drhefad9992004-06-22 12:13:55 +0000292sqlite_int64 sqlite3_value_int64(sqlite3_value *pVal){
drh6a6124e2004-06-27 01:56:33 +0000293 return sqlite3VdbeIntValue((Mem*)pVal);
drh4f26d6c2004-05-26 23:25:30 +0000294}
295const unsigned char *sqlite3_value_text(sqlite3_value *pVal){
drhb21c8cd2007-08-21 19:33:56 +0000296 return (const unsigned char *)sqlite3ValueText(pVal, SQLITE_UTF8);
drh4f26d6c2004-05-26 23:25:30 +0000297}
drh6c626082004-11-14 21:56:29 +0000298#ifndef SQLITE_OMIT_UTF16
drh4f26d6c2004-05-26 23:25:30 +0000299const void *sqlite3_value_text16(sqlite3_value* pVal){
drhb21c8cd2007-08-21 19:33:56 +0000300 return sqlite3ValueText(pVal, SQLITE_UTF16NATIVE);
drh4f26d6c2004-05-26 23:25:30 +0000301}
danielk1977d8123362004-06-12 09:25:12 +0000302const void *sqlite3_value_text16be(sqlite3_value *pVal){
drhb21c8cd2007-08-21 19:33:56 +0000303 return sqlite3ValueText(pVal, SQLITE_UTF16BE);
danielk1977d8123362004-06-12 09:25:12 +0000304}
305const void *sqlite3_value_text16le(sqlite3_value *pVal){
drhb21c8cd2007-08-21 19:33:56 +0000306 return sqlite3ValueText(pVal, SQLITE_UTF16LE);
danielk1977d8123362004-06-12 09:25:12 +0000307}
drh6c626082004-11-14 21:56:29 +0000308#endif /* SQLITE_OMIT_UTF16 */
drh4f26d6c2004-05-26 23:25:30 +0000309int sqlite3_value_type(sqlite3_value* pVal){
drhf4479502004-05-27 03:12:53 +0000310 return pVal->type;
drh4f26d6c2004-05-26 23:25:30 +0000311}
312
313/**************************** sqlite3_result_ *******************************
314** The following routines are used by user-defined functions to specify
315** the function result.
316*/
317void sqlite3_result_blob(
318 sqlite3_context *pCtx,
319 const void *z,
320 int n,
danielk1977d8123362004-06-12 09:25:12 +0000321 void (*xDel)(void *)
drh4f26d6c2004-05-26 23:25:30 +0000322){
drh5708d2d2005-06-22 10:53:59 +0000323 assert( n>=0 );
drh32bc3f62007-08-21 20:25:39 +0000324 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drhb21c8cd2007-08-21 19:33:56 +0000325 sqlite3VdbeMemSetStr(&pCtx->s, z, n, 0, xDel);
drh4f26d6c2004-05-26 23:25:30 +0000326}
327void sqlite3_result_double(sqlite3_context *pCtx, double rVal){
drh32bc3f62007-08-21 20:25:39 +0000328 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drh4f26d6c2004-05-26 23:25:30 +0000329 sqlite3VdbeMemSetDouble(&pCtx->s, rVal);
330}
331void sqlite3_result_error(sqlite3_context *pCtx, const char *z, int n){
drh32bc3f62007-08-21 20:25:39 +0000332 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drh69544ec2008-02-06 14:11:34 +0000333 pCtx->isError = SQLITE_ERROR;
drhb21c8cd2007-08-21 19:33:56 +0000334 sqlite3VdbeMemSetStr(&pCtx->s, z, n, SQLITE_UTF8, SQLITE_TRANSIENT);
drh4f26d6c2004-05-26 23:25:30 +0000335}
danielk1977a1686c92006-01-23 07:52:37 +0000336#ifndef SQLITE_OMIT_UTF16
drh4f26d6c2004-05-26 23:25:30 +0000337void sqlite3_result_error16(sqlite3_context *pCtx, const void *z, int n){
drh32bc3f62007-08-21 20:25:39 +0000338 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drh69544ec2008-02-06 14:11:34 +0000339 pCtx->isError = SQLITE_ERROR;
drhb21c8cd2007-08-21 19:33:56 +0000340 sqlite3VdbeMemSetStr(&pCtx->s, z, n, SQLITE_UTF16NATIVE, SQLITE_TRANSIENT);
drh4f26d6c2004-05-26 23:25:30 +0000341}
danielk1977a1686c92006-01-23 07:52:37 +0000342#endif
drhf4479502004-05-27 03:12:53 +0000343void sqlite3_result_int(sqlite3_context *pCtx, int iVal){
drh32bc3f62007-08-21 20:25:39 +0000344 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drh4f26d6c2004-05-26 23:25:30 +0000345 sqlite3VdbeMemSetInt64(&pCtx->s, (i64)iVal);
346}
347void sqlite3_result_int64(sqlite3_context *pCtx, i64 iVal){
drh32bc3f62007-08-21 20:25:39 +0000348 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drh4f26d6c2004-05-26 23:25:30 +0000349 sqlite3VdbeMemSetInt64(&pCtx->s, iVal);
350}
351void sqlite3_result_null(sqlite3_context *pCtx){
drh32bc3f62007-08-21 20:25:39 +0000352 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drhf4479502004-05-27 03:12:53 +0000353 sqlite3VdbeMemSetNull(&pCtx->s);
drh4f26d6c2004-05-26 23:25:30 +0000354}
355void sqlite3_result_text(
356 sqlite3_context *pCtx,
357 const char *z,
358 int n,
danielk1977d8123362004-06-12 09:25:12 +0000359 void (*xDel)(void *)
drh4f26d6c2004-05-26 23:25:30 +0000360){
drh32bc3f62007-08-21 20:25:39 +0000361 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drhb21c8cd2007-08-21 19:33:56 +0000362 sqlite3VdbeMemSetStr(&pCtx->s, z, n, SQLITE_UTF8, xDel);
drh4f26d6c2004-05-26 23:25:30 +0000363}
drh6c626082004-11-14 21:56:29 +0000364#ifndef SQLITE_OMIT_UTF16
drh4f26d6c2004-05-26 23:25:30 +0000365void sqlite3_result_text16(
366 sqlite3_context *pCtx,
367 const void *z,
368 int n,
danielk1977d8123362004-06-12 09:25:12 +0000369 void (*xDel)(void *)
drh4f26d6c2004-05-26 23:25:30 +0000370){
drh32bc3f62007-08-21 20:25:39 +0000371 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drhb21c8cd2007-08-21 19:33:56 +0000372 sqlite3VdbeMemSetStr(&pCtx->s, z, n, SQLITE_UTF16NATIVE, xDel);
danielk1977d8123362004-06-12 09:25:12 +0000373}
374void sqlite3_result_text16be(
375 sqlite3_context *pCtx,
376 const void *z,
377 int n,
378 void (*xDel)(void *)
379){
drh32bc3f62007-08-21 20:25:39 +0000380 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drhb21c8cd2007-08-21 19:33:56 +0000381 sqlite3VdbeMemSetStr(&pCtx->s, z, n, SQLITE_UTF16BE, xDel);
danielk1977d8123362004-06-12 09:25:12 +0000382}
383void sqlite3_result_text16le(
384 sqlite3_context *pCtx,
385 const void *z,
386 int n,
387 void (*xDel)(void *)
388){
drh32bc3f62007-08-21 20:25:39 +0000389 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drhb21c8cd2007-08-21 19:33:56 +0000390 sqlite3VdbeMemSetStr(&pCtx->s, z, n, SQLITE_UTF16LE, xDel);
drh4f26d6c2004-05-26 23:25:30 +0000391}
drh6c626082004-11-14 21:56:29 +0000392#endif /* SQLITE_OMIT_UTF16 */
drh4f26d6c2004-05-26 23:25:30 +0000393void sqlite3_result_value(sqlite3_context *pCtx, sqlite3_value *pValue){
drh32bc3f62007-08-21 20:25:39 +0000394 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drhb21c8cd2007-08-21 19:33:56 +0000395 sqlite3VdbeMemCopy(&pCtx->s, pValue);
drh4f26d6c2004-05-26 23:25:30 +0000396}
drhb026e052007-05-02 01:34:31 +0000397void sqlite3_result_zeroblob(sqlite3_context *pCtx, int n){
drh32bc3f62007-08-21 20:25:39 +0000398 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drhb026e052007-05-02 01:34:31 +0000399 sqlite3VdbeMemSetZeroBlob(&pCtx->s, n);
400}
drh69544ec2008-02-06 14:11:34 +0000401void sqlite3_result_error_code(sqlite3_context *pCtx, int errCode){
402 pCtx->isError = errCode;
403}
drh4f26d6c2004-05-26 23:25:30 +0000404
drha0206bc2007-05-08 15:15:02 +0000405/* Force an SQLITE_TOOBIG error. */
406void sqlite3_result_error_toobig(sqlite3_context *pCtx){
drh32bc3f62007-08-21 20:25:39 +0000407 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drhbb4957f2008-03-20 14:03:29 +0000408 pCtx->isError = SQLITE_TOOBIG;
409 sqlite3VdbeMemSetStr(&pCtx->s, "string or blob too big", -1,
410 SQLITE_UTF8, SQLITE_STATIC);
drha0206bc2007-05-08 15:15:02 +0000411}
412
danielk1977a1644fd2007-08-29 12:31:25 +0000413/* An SQLITE_NOMEM error. */
414void sqlite3_result_error_nomem(sqlite3_context *pCtx){
415 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
416 sqlite3VdbeMemSetNull(&pCtx->s);
drh69544ec2008-02-06 14:11:34 +0000417 pCtx->isError = SQLITE_NOMEM;
danielk1977a1644fd2007-08-29 12:31:25 +0000418 pCtx->s.db->mallocFailed = 1;
419}
drh4f26d6c2004-05-26 23:25:30 +0000420
421/*
422** Execute the statement pStmt, either until a row of data is ready, the
423** statement is completely executed or an error occurs.
drhb900aaf2006-11-09 00:24:53 +0000424**
425** This routine implements the bulk of the logic behind the sqlite_step()
426** API. The only thing omitted is the automatic recompile if a
427** schema change has occurred. That detail is handled by the
428** outer sqlite3_step() wrapper procedure.
drh4f26d6c2004-05-26 23:25:30 +0000429*/
drhb900aaf2006-11-09 00:24:53 +0000430static int sqlite3Step(Vdbe *p){
drh9bb575f2004-09-06 17:24:11 +0000431 sqlite3 *db;
drh4f26d6c2004-05-26 23:25:30 +0000432 int rc;
433
danielk1977a185ddb2007-11-15 16:04:15 +0000434 assert(p);
435 if( p->magic!=VDBE_MAGIC_RUN ){
drhf1bfe9a2007-10-17 01:44:20 +0000436 return SQLITE_MISUSE;
437 }
438
danielk1977efaaf572006-01-16 11:29:19 +0000439 /* Assert that malloc() has not failed */
drh17435752007-08-16 04:30:38 +0000440 db = p->db;
drhc456e572008-08-11 18:44:58 +0000441 if( db->mallocFailed ){
442 return SQLITE_NOMEM;
443 }
danielk1977261919c2005-12-06 12:52:59 +0000444
danielk1977a21c6b62005-01-24 10:25:59 +0000445 if( p->pc<=0 && p->expired ){
drh7950acd2009-04-10 23:11:31 +0000446 if( ALWAYS(p->rc==SQLITE_OK) ){
danielk1977a21c6b62005-01-24 10:25:59 +0000447 p->rc = SQLITE_SCHEMA;
448 }
drhb900aaf2006-11-09 00:24:53 +0000449 rc = SQLITE_ERROR;
450 goto end_of_step;
danielk1977a21c6b62005-01-24 10:25:59 +0000451 }
drh4f26d6c2004-05-26 23:25:30 +0000452 if( sqlite3SafetyOn(db) ){
453 p->rc = SQLITE_MISUSE;
454 return SQLITE_MISUSE;
455 }
danielk19771d850a72004-05-31 08:26:49 +0000456 if( p->pc<0 ){
drh15ca1df2006-07-26 13:43:30 +0000457 /* If there are no other statements currently running, then
458 ** reset the interrupt flag. This prevents a call to sqlite3_interrupt
459 ** from interrupting a statement that has not yet started.
460 */
461 if( db->activeVdbeCnt==0 ){
462 db->u1.isInterrupted = 0;
463 }
464
drh19e2d372005-08-29 23:00:03 +0000465#ifndef SQLITE_OMIT_TRACE
drh19e2d372005-08-29 23:00:03 +0000466 if( db->xProfile && !db->init.busy ){
467 double rNow;
danielk1977b4b47412007-08-17 15:53:36 +0000468 sqlite3OsCurrentTime(db->pVfs, &rNow);
drhb27b7f52008-12-10 18:03:45 +0000469 p->startTime = (u64)((rNow - (int)rNow)*3600.0*24.0*1000000000.0);
drh19e2d372005-08-29 23:00:03 +0000470 }
471#endif
drhc16a03b2004-09-15 13:38:10 +0000472
danielk19771d850a72004-05-31 08:26:49 +0000473 db->activeVdbeCnt++;
drhad4a4b82008-11-05 16:37:34 +0000474 if( p->readOnly==0 ) db->writeVdbeCnt++;
danielk19771d850a72004-05-31 08:26:49 +0000475 p->pc = 0;
danielk1977dfb316d2008-03-26 18:34:43 +0000476 stmtLruRemove(p);
danielk19771d850a72004-05-31 08:26:49 +0000477 }
drhb7f91642004-10-31 02:22:47 +0000478#ifndef SQLITE_OMIT_EXPLAIN
drh4f26d6c2004-05-26 23:25:30 +0000479 if( p->explain ){
480 rc = sqlite3VdbeList(p);
drhb7f91642004-10-31 02:22:47 +0000481 }else
482#endif /* SQLITE_OMIT_EXPLAIN */
483 {
drh4f26d6c2004-05-26 23:25:30 +0000484 rc = sqlite3VdbeExec(p);
485 }
486
487 if( sqlite3SafetyOff(db) ){
488 rc = SQLITE_MISUSE;
489 }
490
drh19e2d372005-08-29 23:00:03 +0000491#ifndef SQLITE_OMIT_TRACE
492 /* Invoke the profile callback if there is one
493 */
danielk19776ab3a2e2009-02-19 14:39:25 +0000494 if( rc!=SQLITE_ROW && db->xProfile && !db->init.busy && p->zSql ){
drh19e2d372005-08-29 23:00:03 +0000495 double rNow;
496 u64 elapseTime;
497
danielk1977b4b47412007-08-17 15:53:36 +0000498 sqlite3OsCurrentTime(db->pVfs, &rNow);
drhb27b7f52008-12-10 18:03:45 +0000499 elapseTime = (u64)((rNow - (int)rNow)*3600.0*24.0*1000000000.0);
500 elapseTime -= p->startTime;
danielk19776ab3a2e2009-02-19 14:39:25 +0000501 db->xProfile(db->pProfileArg, p->zSql, elapseTime);
drh19e2d372005-08-29 23:00:03 +0000502 }
503#endif
504
drh80cc85b2008-07-23 21:07:25 +0000505 db->errCode = rc;
danielk1977357864e2009-03-25 15:43:08 +0000506 if( SQLITE_NOMEM==sqlite3ApiExit(p->db, p->rc) ){
507 p->rc = SQLITE_NOMEM;
drhb900aaf2006-11-09 00:24:53 +0000508 }
danielk1977357864e2009-03-25 15:43:08 +0000509end_of_step:
510 /* At this point local variable rc holds the value that should be
511 ** returned if this statement was compiled using the legacy
512 ** sqlite3_prepare() interface. According to the docs, this can only
513 ** be one of the values in the first assert() below. Variable p->rc
514 ** contains the value that would be returned if sqlite3_finalize()
515 ** were called on statement p.
516 */
517 assert( rc==SQLITE_ROW || rc==SQLITE_DONE || rc==SQLITE_ERROR
518 || rc==SQLITE_BUSY || rc==SQLITE_MISUSE
519 );
520 assert( p->rc!=SQLITE_ROW && p->rc!=SQLITE_DONE );
521 if( p->isPrepareV2 && rc!=SQLITE_ROW && rc!=SQLITE_DONE ){
522 /* If this statement was prepared using sqlite3_prepare_v2(), and an
523 ** error has occured, then return the error code in p->rc to the
524 ** caller. Set the error code in the database handle to the same value.
525 */
526 rc = db->errCode = p->rc;
527 }
528 return (rc&db->errMask);
drhb900aaf2006-11-09 00:24:53 +0000529}
530
531/*
532** This is the top-level implementation of sqlite3_step(). Call
533** sqlite3Step() to do most of the work. If a schema error occurs,
534** call sqlite3Reprepare() and try again.
535*/
536#ifdef SQLITE_OMIT_PARSER
537int sqlite3_step(sqlite3_stmt *pStmt){
danielk1977a185ddb2007-11-15 16:04:15 +0000538 int rc = SQLITE_MISUSE;
539 if( pStmt ){
540 Vdbe *v;
541 v = (Vdbe*)pStmt;
542 sqlite3_mutex_enter(v->db->mutex);
543 rc = sqlite3Step(v);
544 sqlite3_mutex_leave(v->db->mutex);
545 }
drhb21c8cd2007-08-21 19:33:56 +0000546 return rc;
drhb900aaf2006-11-09 00:24:53 +0000547}
548#else
549int sqlite3_step(sqlite3_stmt *pStmt){
danielk1977a185ddb2007-11-15 16:04:15 +0000550 int rc = SQLITE_MISUSE;
551 if( pStmt ){
552 int cnt = 0;
553 Vdbe *v = (Vdbe*)pStmt;
554 sqlite3 *db = v->db;
555 sqlite3_mutex_enter(db->mutex);
556 while( (rc = sqlite3Step(v))==SQLITE_SCHEMA
557 && cnt++ < 5
danielk197765a2ea12009-03-19 07:58:31 +0000558 && (rc = vdbeReprepare(v))==SQLITE_OK ){
danielk1977a185ddb2007-11-15 16:04:15 +0000559 sqlite3_reset(pStmt);
560 v->expired = 0;
danielk19778e556522007-11-13 10:30:24 +0000561 }
drh7950acd2009-04-10 23:11:31 +0000562 if( rc==SQLITE_SCHEMA && ALWAYS(v->isPrepareV2) && ALWAYS(db->pErr) ){
danielk1977a185ddb2007-11-15 16:04:15 +0000563 /* This case occurs after failing to recompile an sql statement.
564 ** The error message from the SQL compiler has already been loaded
565 ** into the database handle. This block copies the error message
566 ** from the database handle into the statement and sets the statement
567 ** program counter to 0 to ensure that when the statement is
568 ** finalized or reset the parser error message is available via
569 ** sqlite3_errmsg() and sqlite3_errcode().
570 */
571 const char *zErr = (const char *)sqlite3_value_text(db->pErr);
drh633e6d52008-07-28 19:34:53 +0000572 sqlite3DbFree(db, v->zErrMsg);
danielk1977a185ddb2007-11-15 16:04:15 +0000573 if( !db->mallocFailed ){
574 v->zErrMsg = sqlite3DbStrDup(db, zErr);
575 } else {
576 v->zErrMsg = 0;
577 v->rc = SQLITE_NOMEM;
578 }
579 }
580 rc = sqlite3ApiExit(db, rc);
581 sqlite3_mutex_leave(db->mutex);
danielk19778e556522007-11-13 10:30:24 +0000582 }
danielk197776e8d1a2006-01-18 18:22:43 +0000583 return rc;
drh4f26d6c2004-05-26 23:25:30 +0000584}
drhb900aaf2006-11-09 00:24:53 +0000585#endif
drh4f26d6c2004-05-26 23:25:30 +0000586
587/*
drheb2e1762004-05-27 01:53:56 +0000588** Extract the user data from a sqlite3_context structure and return a
589** pointer to it.
590*/
591void *sqlite3_user_data(sqlite3_context *p){
592 assert( p && p->pFunc );
593 return p->pFunc->pUserData;
594}
595
596/*
drhfa4a4b92008-03-19 21:45:51 +0000597** Extract the user data from a sqlite3_context structure and return a
598** pointer to it.
599*/
600sqlite3 *sqlite3_context_db_handle(sqlite3_context *p){
601 assert( p && p->pFunc );
602 return p->s.db;
603}
604
605/*
drhb7481e72006-09-16 21:45:14 +0000606** The following is the implementation of an SQL function that always
607** fails with an error message stating that the function is used in the
608** wrong context. The sqlite3_overload_function() API might construct
609** SQL function that use this routine so that the functions will exist
610** for name resolution but are actually overloaded by the xFindFunction
611** method of virtual tables.
612*/
613void sqlite3InvalidFunction(
614 sqlite3_context *context, /* The function calling context */
danielk197762c14b32008-11-19 09:05:26 +0000615 int NotUsed, /* Number of arguments to the function */
616 sqlite3_value **NotUsed2 /* Value of each argument */
drhb7481e72006-09-16 21:45:14 +0000617){
618 const char *zName = context->pFunc->zName;
619 char *zErr;
danielk197762c14b32008-11-19 09:05:26 +0000620 UNUSED_PARAMETER2(NotUsed, NotUsed2);
drhbc6160b2009-04-08 15:45:31 +0000621 zErr = sqlite3_mprintf(
drhb7481e72006-09-16 21:45:14 +0000622 "unable to use function %s in the requested context", zName);
623 sqlite3_result_error(context, zErr, -1);
danielk19771e536952007-08-16 10:09:01 +0000624 sqlite3_free(zErr);
drhb7481e72006-09-16 21:45:14 +0000625}
626
627/*
drheb2e1762004-05-27 01:53:56 +0000628** Allocate or return the aggregate context for a user function. A new
629** context is allocated on the first call. Subsequent calls return the
630** same context that was returned on prior calls.
drheb2e1762004-05-27 01:53:56 +0000631*/
632void *sqlite3_aggregate_context(sqlite3_context *p, int nByte){
drhb21c8cd2007-08-21 19:33:56 +0000633 Mem *pMem;
drh825c6622005-09-08 19:01:05 +0000634 assert( p && p->pFunc && p->pFunc->xStep );
drhb21c8cd2007-08-21 19:33:56 +0000635 assert( sqlite3_mutex_held(p->s.db->mutex) );
636 pMem = p->pMem;
drha10a34b2005-09-07 22:09:48 +0000637 if( (pMem->flags & MEM_Agg)==0 ){
638 if( nByte==0 ){
danielk19775f096132008-03-28 15:44:09 +0000639 sqlite3VdbeMemReleaseExternal(pMem);
640 pMem->flags = MEM_Null;
drha10a34b2005-09-07 22:09:48 +0000641 pMem->z = 0;
drheb2e1762004-05-27 01:53:56 +0000642 }else{
danielk19775f096132008-03-28 15:44:09 +0000643 sqlite3VdbeMemGrow(pMem, nByte, 0);
drha10a34b2005-09-07 22:09:48 +0000644 pMem->flags = MEM_Agg;
drh3c024d62007-03-30 11:23:45 +0000645 pMem->u.pDef = p->pFunc;
danielk19775f096132008-03-28 15:44:09 +0000646 if( pMem->z ){
647 memset(pMem->z, 0, nByte);
648 }
drheb2e1762004-05-27 01:53:56 +0000649 }
650 }
drhabfcea22005-09-06 20:36:48 +0000651 return (void*)pMem->z;
drheb2e1762004-05-27 01:53:56 +0000652}
653
654/*
danielk1977682f68b2004-06-05 10:22:17 +0000655** Return the auxilary data pointer, if any, for the iArg'th argument to
656** the user-function defined by pCtx.
657*/
658void *sqlite3_get_auxdata(sqlite3_context *pCtx, int iArg){
drhb21c8cd2007-08-21 19:33:56 +0000659 VdbeFunc *pVdbeFunc;
660
661 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
662 pVdbeFunc = pCtx->pVdbeFunc;
danielk1977682f68b2004-06-05 10:22:17 +0000663 if( !pVdbeFunc || iArg>=pVdbeFunc->nAux || iArg<0 ){
664 return 0;
665 }
drhf92c7ff2004-06-19 15:40:23 +0000666 return pVdbeFunc->apAux[iArg].pAux;
danielk1977682f68b2004-06-05 10:22:17 +0000667}
668
669/*
670** Set the auxilary data pointer and delete function, for the iArg'th
671** argument to the user-function defined by pCtx. Any previous value is
672** deleted by calling the delete function specified when it was set.
673*/
674void sqlite3_set_auxdata(
675 sqlite3_context *pCtx,
676 int iArg,
677 void *pAux,
678 void (*xDelete)(void*)
679){
680 struct AuxData *pAuxData;
drhf92c7ff2004-06-19 15:40:23 +0000681 VdbeFunc *pVdbeFunc;
danielk1977e0fc5262007-07-26 06:50:05 +0000682 if( iArg<0 ) goto failed;
danielk1977682f68b2004-06-05 10:22:17 +0000683
drhb21c8cd2007-08-21 19:33:56 +0000684 assert( sqlite3_mutex_held(pCtx->s.db->mutex) );
drhf92c7ff2004-06-19 15:40:23 +0000685 pVdbeFunc = pCtx->pVdbeFunc;
686 if( !pVdbeFunc || pVdbeFunc->nAux<=iArg ){
danielk197731dad9d2007-08-16 11:36:15 +0000687 int nAux = (pVdbeFunc ? pVdbeFunc->nAux : 0);
drhf92c7ff2004-06-19 15:40:23 +0000688 int nMalloc = sizeof(VdbeFunc) + sizeof(struct AuxData)*iArg;
danielk197726783a52007-08-29 14:06:22 +0000689 pVdbeFunc = sqlite3DbRealloc(pCtx->s.db, pVdbeFunc, nMalloc);
drh17435752007-08-16 04:30:38 +0000690 if( !pVdbeFunc ){
drh17435752007-08-16 04:30:38 +0000691 goto failed;
692 }
drh53f733c2005-09-16 02:38:09 +0000693 pCtx->pVdbeFunc = pVdbeFunc;
danielk197731dad9d2007-08-16 11:36:15 +0000694 memset(&pVdbeFunc->apAux[nAux], 0, sizeof(struct AuxData)*(iArg+1-nAux));
drh998da3a2004-06-19 15:22:56 +0000695 pVdbeFunc->nAux = iArg+1;
696 pVdbeFunc->pFunc = pCtx->pFunc;
danielk1977682f68b2004-06-05 10:22:17 +0000697 }
698
drhf92c7ff2004-06-19 15:40:23 +0000699 pAuxData = &pVdbeFunc->apAux[iArg];
danielk1977682f68b2004-06-05 10:22:17 +0000700 if( pAuxData->pAux && pAuxData->xDelete ){
701 pAuxData->xDelete(pAuxData->pAux);
702 }
703 pAuxData->pAux = pAux;
704 pAuxData->xDelete = xDelete;
danielk1977e0fc5262007-07-26 06:50:05 +0000705 return;
706
707failed:
708 if( xDelete ){
709 xDelete(pAux);
710 }
danielk1977682f68b2004-06-05 10:22:17 +0000711}
712
shaneeec556d2008-10-12 00:27:53 +0000713#ifndef SQLITE_OMIT_DEPRECATED
danielk1977682f68b2004-06-05 10:22:17 +0000714/*
drheb2e1762004-05-27 01:53:56 +0000715** Return the number of times the Step function of a aggregate has been
716** called.
717**
drhcf85a512006-02-09 18:35:29 +0000718** This function is deprecated. Do not use it for new code. It is
719** provide only to avoid breaking legacy code. New aggregate function
720** implementations should keep their own counts within their aggregate
721** context.
drheb2e1762004-05-27 01:53:56 +0000722*/
723int sqlite3_aggregate_count(sqlite3_context *p){
shanee34c6472009-03-05 04:23:47 +0000724 assert( p && p->pMem && p->pFunc && p->pFunc->xStep );
drhabfcea22005-09-06 20:36:48 +0000725 return p->pMem->n;
drheb2e1762004-05-27 01:53:56 +0000726}
shaneeec556d2008-10-12 00:27:53 +0000727#endif
drheb2e1762004-05-27 01:53:56 +0000728
729/*
drh4f26d6c2004-05-26 23:25:30 +0000730** Return the number of columns in the result set for the statement pStmt.
731*/
732int sqlite3_column_count(sqlite3_stmt *pStmt){
733 Vdbe *pVm = (Vdbe *)pStmt;
drh1bcdb0c2004-08-28 14:49:46 +0000734 return pVm ? pVm->nResColumn : 0;
drh4f26d6c2004-05-26 23:25:30 +0000735}
736
737/*
738** Return the number of values available from the current row of the
739** currently executing statement pStmt.
740*/
741int sqlite3_data_count(sqlite3_stmt *pStmt){
742 Vdbe *pVm = (Vdbe *)pStmt;
drhd4e70eb2008-01-02 00:34:36 +0000743 if( pVm==0 || pVm->pResultSet==0 ) return 0;
drh4f26d6c2004-05-26 23:25:30 +0000744 return pVm->nResColumn;
745}
746
747
748/*
749** Check to see if column iCol of the given statement is valid. If
750** it is, return a pointer to the Mem for the value of that column.
751** If iCol is not valid, return a pointer to a Mem which has a value
752** of NULL.
753*/
754static Mem *columnMem(sqlite3_stmt *pStmt, int i){
drh32bc3f62007-08-21 20:25:39 +0000755 Vdbe *pVm;
756 int vals;
757 Mem *pOut;
758
759 pVm = (Vdbe *)pStmt;
drhd4e70eb2008-01-02 00:34:36 +0000760 if( pVm && pVm->pResultSet!=0 && i<pVm->nResColumn && i>=0 ){
drh32bc3f62007-08-21 20:25:39 +0000761 sqlite3_mutex_enter(pVm->db->mutex);
762 vals = sqlite3_data_count(pStmt);
drhd4e70eb2008-01-02 00:34:36 +0000763 pOut = &pVm->pResultSet[i];
drh32bc3f62007-08-21 20:25:39 +0000764 }else{
shanefbd60f82009-02-04 03:59:25 +0000765 /* ((double)0) In case of SQLITE_OMIT_FLOATING_POINT... */
766 static const Mem nullMem = {{0}, (double)0, 0, "", 0, MEM_Null, SQLITE_NULL, 0, 0, 0 };
drh9b4ea4a2009-04-10 20:32:00 +0000767 if( pVm && ALWAYS(pVm->db) ){
drh27641702007-08-22 02:56:42 +0000768 sqlite3_mutex_enter(pVm->db->mutex);
769 sqlite3Error(pVm->db, SQLITE_RANGE, 0);
770 }
drh32bc3f62007-08-21 20:25:39 +0000771 pOut = (Mem*)&nullMem;
drh4f26d6c2004-05-26 23:25:30 +0000772 }
drh32bc3f62007-08-21 20:25:39 +0000773 return pOut;
drh4f26d6c2004-05-26 23:25:30 +0000774}
775
danielk19772e588c72005-12-09 14:25:08 +0000776/*
777** This function is called after invoking an sqlite3_value_XXX function on a
778** column value (i.e. a value returned by evaluating an SQL expression in the
779** select list of a SELECT statement) that may cause a malloc() failure. If
780** malloc() has failed, the threads mallocFailed flag is cleared and the result
781** code of statement pStmt set to SQLITE_NOMEM.
782**
drh32bc3f62007-08-21 20:25:39 +0000783** Specifically, this is called from within:
danielk19772e588c72005-12-09 14:25:08 +0000784**
785** sqlite3_column_int()
786** sqlite3_column_int64()
787** sqlite3_column_text()
788** sqlite3_column_text16()
789** sqlite3_column_real()
790** sqlite3_column_bytes()
791** sqlite3_column_bytes16()
792**
793** But not for sqlite3_column_blob(), which never calls malloc().
794*/
795static void columnMallocFailure(sqlite3_stmt *pStmt)
796{
797 /* If malloc() failed during an encoding conversion within an
798 ** sqlite3_column_XXX API, then set the return code of the statement to
799 ** SQLITE_NOMEM. The next call to _step() (if any) will return SQLITE_ERROR
800 ** and _finalize() will return NOMEM.
801 */
danielk197754f01982006-01-18 15:25:17 +0000802 Vdbe *p = (Vdbe *)pStmt;
drh32bc3f62007-08-21 20:25:39 +0000803 if( p ){
804 p->rc = sqlite3ApiExit(p->db, p->rc);
805 sqlite3_mutex_leave(p->db->mutex);
806 }
danielk19772e588c72005-12-09 14:25:08 +0000807}
808
drh4f26d6c2004-05-26 23:25:30 +0000809/**************************** sqlite3_column_ *******************************
810** The following routines are used to access elements of the current row
811** in the result set.
812*/
danielk1977c572ef72004-05-27 09:28:41 +0000813const void *sqlite3_column_blob(sqlite3_stmt *pStmt, int i){
danielk19772e588c72005-12-09 14:25:08 +0000814 const void *val;
danielk19772e588c72005-12-09 14:25:08 +0000815 val = sqlite3_value_blob( columnMem(pStmt,i) );
danielk1977c9cf9012007-05-30 10:36:47 +0000816 /* Even though there is no encoding conversion, value_blob() might
817 ** need to call malloc() to expand the result of a zeroblob()
818 ** expression.
819 */
820 columnMallocFailure(pStmt);
danielk19772e588c72005-12-09 14:25:08 +0000821 return val;
danielk1977c572ef72004-05-27 09:28:41 +0000822}
drh4f26d6c2004-05-26 23:25:30 +0000823int sqlite3_column_bytes(sqlite3_stmt *pStmt, int i){
danielk19772e588c72005-12-09 14:25:08 +0000824 int val = sqlite3_value_bytes( columnMem(pStmt,i) );
825 columnMallocFailure(pStmt);
826 return val;
drh4f26d6c2004-05-26 23:25:30 +0000827}
828int sqlite3_column_bytes16(sqlite3_stmt *pStmt, int i){
danielk19772e588c72005-12-09 14:25:08 +0000829 int val = sqlite3_value_bytes16( columnMem(pStmt,i) );
830 columnMallocFailure(pStmt);
831 return val;
drh4f26d6c2004-05-26 23:25:30 +0000832}
833double sqlite3_column_double(sqlite3_stmt *pStmt, int i){
danielk19772e588c72005-12-09 14:25:08 +0000834 double val = sqlite3_value_double( columnMem(pStmt,i) );
835 columnMallocFailure(pStmt);
836 return val;
drh4f26d6c2004-05-26 23:25:30 +0000837}
838int sqlite3_column_int(sqlite3_stmt *pStmt, int i){
danielk19772e588c72005-12-09 14:25:08 +0000839 int val = sqlite3_value_int( columnMem(pStmt,i) );
840 columnMallocFailure(pStmt);
841 return val;
drh4f26d6c2004-05-26 23:25:30 +0000842}
drhefad9992004-06-22 12:13:55 +0000843sqlite_int64 sqlite3_column_int64(sqlite3_stmt *pStmt, int i){
danielk19772e588c72005-12-09 14:25:08 +0000844 sqlite_int64 val = sqlite3_value_int64( columnMem(pStmt,i) );
845 columnMallocFailure(pStmt);
846 return val;
drh4f26d6c2004-05-26 23:25:30 +0000847}
848const unsigned char *sqlite3_column_text(sqlite3_stmt *pStmt, int i){
danielk19772e588c72005-12-09 14:25:08 +0000849 const unsigned char *val = sqlite3_value_text( columnMem(pStmt,i) );
850 columnMallocFailure(pStmt);
851 return val;
drh4f26d6c2004-05-26 23:25:30 +0000852}
drhd1e47332005-06-26 17:55:33 +0000853sqlite3_value *sqlite3_column_value(sqlite3_stmt *pStmt, int i){
danielk1977d0ffa1e2008-10-13 10:37:49 +0000854 Mem *pOut = columnMem(pStmt, i);
855 if( pOut->flags&MEM_Static ){
856 pOut->flags &= ~MEM_Static;
857 pOut->flags |= MEM_Ephem;
858 }
drh32bc3f62007-08-21 20:25:39 +0000859 columnMallocFailure(pStmt);
danielk1977d0ffa1e2008-10-13 10:37:49 +0000860 return (sqlite3_value *)pOut;
drhd1e47332005-06-26 17:55:33 +0000861}
drh6c626082004-11-14 21:56:29 +0000862#ifndef SQLITE_OMIT_UTF16
drh4f26d6c2004-05-26 23:25:30 +0000863const void *sqlite3_column_text16(sqlite3_stmt *pStmt, int i){
danielk19772e588c72005-12-09 14:25:08 +0000864 const void *val = sqlite3_value_text16( columnMem(pStmt,i) );
865 columnMallocFailure(pStmt);
866 return val;
drh4f26d6c2004-05-26 23:25:30 +0000867}
drh6c626082004-11-14 21:56:29 +0000868#endif /* SQLITE_OMIT_UTF16 */
drh4f26d6c2004-05-26 23:25:30 +0000869int sqlite3_column_type(sqlite3_stmt *pStmt, int i){
drh32bc3f62007-08-21 20:25:39 +0000870 int iType = sqlite3_value_type( columnMem(pStmt,i) );
871 columnMallocFailure(pStmt);
872 return iType;
drh4f26d6c2004-05-26 23:25:30 +0000873}
874
drh29d72102006-02-09 22:13:41 +0000875/* The following function is experimental and subject to change or
876** removal */
877/*int sqlite3_column_numeric_type(sqlite3_stmt *pStmt, int i){
878** return sqlite3_value_numeric_type( columnMem(pStmt,i) );
879**}
880*/
881
drh5e2517e2004-09-24 23:59:12 +0000882/*
883** Convert the N-th element of pStmt->pColName[] into a string using
884** xFunc() then return that string. If N is out of range, return 0.
drhe590fbd2005-05-20 19:36:01 +0000885**
886** There are up to 5 names for each column. useType determines which
887** name is returned. Here are the names:
888**
889** 0 The column name as it should be displayed for output
890** 1 The datatype name for the column
891** 2 The name of the database that the column derives from
892** 3 The name of the table that the column derives from
893** 4 The name of the table column that the result column derives from
894**
895** If the result is not a simple column reference (if it is an expression
896** or a constant) then useTypes 2, 3, and 4 return NULL.
drh5e2517e2004-09-24 23:59:12 +0000897*/
898static const void *columnName(
899 sqlite3_stmt *pStmt,
900 int N,
901 const void *(*xFunc)(Mem*),
902 int useType
903){
drh32bc3f62007-08-21 20:25:39 +0000904 const void *ret = 0;
drh5e2517e2004-09-24 23:59:12 +0000905 Vdbe *p = (Vdbe *)pStmt;
drh32bc3f62007-08-21 20:25:39 +0000906 int n;
drhc6c7fd52009-04-08 23:05:28 +0000907 sqlite3 *db = p->db;
drh32bc3f62007-08-21 20:25:39 +0000908
drh9b4ea4a2009-04-10 20:32:00 +0000909 assert( db!=0 );
910 n = sqlite3_column_count(pStmt);
911 if( N<n && N>=0 ){
912 N += useType*n;
913 sqlite3_mutex_enter(db->mutex);
914 assert( db->mallocFailed==0 );
915 ret = xFunc(&p->aColName[N]);
916 /* A malloc may have failed inside of the xFunc() call. If this
917 ** is the case, clear the mallocFailed flag and return NULL.
918 */
919 if( db->mallocFailed ){
920 db->mallocFailed = 0;
921 ret = 0;
drh32bc3f62007-08-21 20:25:39 +0000922 }
drh9b4ea4a2009-04-10 20:32:00 +0000923 sqlite3_mutex_leave(db->mutex);
drh5e2517e2004-09-24 23:59:12 +0000924 }
danielk197700fd9572005-12-07 06:27:43 +0000925 return ret;
drh5e2517e2004-09-24 23:59:12 +0000926}
927
drh4f26d6c2004-05-26 23:25:30 +0000928/*
929** Return the name of the Nth column of the result set returned by SQL
930** statement pStmt.
931*/
932const char *sqlite3_column_name(sqlite3_stmt *pStmt, int N){
danielk1977955de522006-02-10 02:27:42 +0000933 return columnName(
934 pStmt, N, (const void*(*)(Mem*))sqlite3_value_text, COLNAME_NAME);
drh4f26d6c2004-05-26 23:25:30 +0000935}
drhe590fbd2005-05-20 19:36:01 +0000936#ifndef SQLITE_OMIT_UTF16
937const void *sqlite3_column_name16(sqlite3_stmt *pStmt, int N){
danielk1977955de522006-02-10 02:27:42 +0000938 return columnName(
939 pStmt, N, (const void*(*)(Mem*))sqlite3_value_text16, COLNAME_NAME);
drhe590fbd2005-05-20 19:36:01 +0000940}
941#endif
drh4f26d6c2004-05-26 23:25:30 +0000942
943/*
drh3f913572008-03-22 01:07:17 +0000944** Constraint: If you have ENABLE_COLUMN_METADATA then you must
945** not define OMIT_DECLTYPE.
946*/
947#if defined(SQLITE_OMIT_DECLTYPE) && defined(SQLITE_ENABLE_COLUMN_METADATA)
948# error "Must not define both SQLITE_OMIT_DECLTYPE \
949 and SQLITE_ENABLE_COLUMN_METADATA"
950#endif
951
952#ifndef SQLITE_OMIT_DECLTYPE
953/*
drh6c626082004-11-14 21:56:29 +0000954** Return the column declaration type (if applicable) of the 'i'th column
drhe590fbd2005-05-20 19:36:01 +0000955** of the result set of SQL statement pStmt.
drh6c626082004-11-14 21:56:29 +0000956*/
957const char *sqlite3_column_decltype(sqlite3_stmt *pStmt, int N){
danielk1977955de522006-02-10 02:27:42 +0000958 return columnName(
959 pStmt, N, (const void*(*)(Mem*))sqlite3_value_text, COLNAME_DECLTYPE);
drh6c626082004-11-14 21:56:29 +0000960}
drh6c626082004-11-14 21:56:29 +0000961#ifndef SQLITE_OMIT_UTF16
danielk197776d505b2004-05-28 13:13:02 +0000962const void *sqlite3_column_decltype16(sqlite3_stmt *pStmt, int N){
danielk1977955de522006-02-10 02:27:42 +0000963 return columnName(
964 pStmt, N, (const void*(*)(Mem*))sqlite3_value_text16, COLNAME_DECLTYPE);
drh4f26d6c2004-05-26 23:25:30 +0000965}
drh6c626082004-11-14 21:56:29 +0000966#endif /* SQLITE_OMIT_UTF16 */
drh3f913572008-03-22 01:07:17 +0000967#endif /* SQLITE_OMIT_DECLTYPE */
drh4f26d6c2004-05-26 23:25:30 +0000968
danielk19774b1ae992006-02-10 03:06:10 +0000969#ifdef SQLITE_ENABLE_COLUMN_METADATA
drhe590fbd2005-05-20 19:36:01 +0000970/*
971** Return the name of the database from which a result column derives.
972** NULL is returned if the result column is an expression or constant or
973** anything else which is not an unabiguous reference to a database column.
974*/
975const char *sqlite3_column_database_name(sqlite3_stmt *pStmt, int N){
danielk1977955de522006-02-10 02:27:42 +0000976 return columnName(
977 pStmt, N, (const void*(*)(Mem*))sqlite3_value_text, COLNAME_DATABASE);
drhe590fbd2005-05-20 19:36:01 +0000978}
979#ifndef SQLITE_OMIT_UTF16
980const void *sqlite3_column_database_name16(sqlite3_stmt *pStmt, int N){
danielk1977955de522006-02-10 02:27:42 +0000981 return columnName(
982 pStmt, N, (const void*(*)(Mem*))sqlite3_value_text16, COLNAME_DATABASE);
drhe590fbd2005-05-20 19:36:01 +0000983}
984#endif /* SQLITE_OMIT_UTF16 */
985
986/*
987** Return the name of the table from which a result column derives.
988** NULL is returned if the result column is an expression or constant or
989** anything else which is not an unabiguous reference to a database column.
990*/
991const char *sqlite3_column_table_name(sqlite3_stmt *pStmt, int N){
danielk1977955de522006-02-10 02:27:42 +0000992 return columnName(
993 pStmt, N, (const void*(*)(Mem*))sqlite3_value_text, COLNAME_TABLE);
drhe590fbd2005-05-20 19:36:01 +0000994}
995#ifndef SQLITE_OMIT_UTF16
996const void *sqlite3_column_table_name16(sqlite3_stmt *pStmt, int N){
danielk1977955de522006-02-10 02:27:42 +0000997 return columnName(
998 pStmt, N, (const void*(*)(Mem*))sqlite3_value_text16, COLNAME_TABLE);
drhe590fbd2005-05-20 19:36:01 +0000999}
1000#endif /* SQLITE_OMIT_UTF16 */
1001
1002/*
1003** Return the name of the table column from which a result column derives.
1004** NULL is returned if the result column is an expression or constant or
1005** anything else which is not an unabiguous reference to a database column.
1006*/
1007const char *sqlite3_column_origin_name(sqlite3_stmt *pStmt, int N){
danielk1977955de522006-02-10 02:27:42 +00001008 return columnName(
1009 pStmt, N, (const void*(*)(Mem*))sqlite3_value_text, COLNAME_COLUMN);
drhe590fbd2005-05-20 19:36:01 +00001010}
1011#ifndef SQLITE_OMIT_UTF16
1012const void *sqlite3_column_origin_name16(sqlite3_stmt *pStmt, int N){
danielk1977955de522006-02-10 02:27:42 +00001013 return columnName(
1014 pStmt, N, (const void*(*)(Mem*))sqlite3_value_text16, COLNAME_COLUMN);
drhe590fbd2005-05-20 19:36:01 +00001015}
1016#endif /* SQLITE_OMIT_UTF16 */
danielk19774b1ae992006-02-10 03:06:10 +00001017#endif /* SQLITE_ENABLE_COLUMN_METADATA */
drhe590fbd2005-05-20 19:36:01 +00001018
1019
drh4f26d6c2004-05-26 23:25:30 +00001020/******************************* sqlite3_bind_ ***************************
1021**
1022** Routines used to attach values to wildcards in a compiled SQL statement.
1023*/
1024/*
1025** Unbind the value bound to variable i in virtual machine p. This is the
1026** the same as binding a NULL value to the column. If the "i" parameter is
1027** out of range, then SQLITE_RANGE is returned. Othewise SQLITE_OK.
1028**
drh488e7b62008-10-06 12:46:43 +00001029** A successful evaluation of this routine acquires the mutex on p.
1030** the mutex is released if any kind of error occurs.
1031**
drh4f26d6c2004-05-26 23:25:30 +00001032** The error code stored in database p->db is overwritten with the return
1033** value in any case.
1034*/
1035static int vdbeUnbind(Vdbe *p, int i){
1036 Mem *pVar;
drh488e7b62008-10-06 12:46:43 +00001037 if( p==0 ) return SQLITE_MISUSE;
1038 sqlite3_mutex_enter(p->db->mutex);
1039 if( p->magic!=VDBE_MAGIC_RUN || p->pc>=0 ){
1040 sqlite3Error(p->db, SQLITE_MISUSE, 0);
1041 sqlite3_mutex_leave(p->db->mutex);
drh4f26d6c2004-05-26 23:25:30 +00001042 return SQLITE_MISUSE;
1043 }
1044 if( i<1 || i>p->nVar ){
1045 sqlite3Error(p->db, SQLITE_RANGE, 0);
drh488e7b62008-10-06 12:46:43 +00001046 sqlite3_mutex_leave(p->db->mutex);
drh4f26d6c2004-05-26 23:25:30 +00001047 return SQLITE_RANGE;
1048 }
1049 i--;
drh290c1942004-08-21 17:54:45 +00001050 pVar = &p->aVar[i];
danielk1977d8123362004-06-12 09:25:12 +00001051 sqlite3VdbeMemRelease(pVar);
drh4f26d6c2004-05-26 23:25:30 +00001052 pVar->flags = MEM_Null;
1053 sqlite3Error(p->db, SQLITE_OK, 0);
1054 return SQLITE_OK;
1055}
1056
1057/*
drh5e2517e2004-09-24 23:59:12 +00001058** Bind a text or BLOB value.
drh4f26d6c2004-05-26 23:25:30 +00001059*/
drh5e2517e2004-09-24 23:59:12 +00001060static int bindText(
drh605264d2007-08-21 15:13:19 +00001061 sqlite3_stmt *pStmt, /* The statement to bind against */
1062 int i, /* Index of the parameter to bind */
1063 const void *zData, /* Pointer to the data to be bound */
1064 int nData, /* Number of bytes of data to be bound */
1065 void (*xDel)(void*), /* Destructor for the data */
drhb27b7f52008-12-10 18:03:45 +00001066 u8 encoding /* Encoding for the data */
drh4f26d6c2004-05-26 23:25:30 +00001067){
1068 Vdbe *p = (Vdbe *)pStmt;
1069 Mem *pVar;
1070 int rc;
1071
1072 rc = vdbeUnbind(p, i);
drh488e7b62008-10-06 12:46:43 +00001073 if( rc==SQLITE_OK ){
1074 if( zData!=0 ){
1075 pVar = &p->aVar[i-1];
1076 rc = sqlite3VdbeMemSetStr(pVar, zData, nData, encoding, xDel);
1077 if( rc==SQLITE_OK && encoding!=0 ){
1078 rc = sqlite3VdbeChangeEncoding(pVar, ENC(p->db));
1079 }
1080 sqlite3Error(p->db, rc, 0);
1081 rc = sqlite3ApiExit(p->db, rc);
drh27641702007-08-22 02:56:42 +00001082 }
drh488e7b62008-10-06 12:46:43 +00001083 sqlite3_mutex_leave(p->db->mutex);
drh4f26d6c2004-05-26 23:25:30 +00001084 }
drh605264d2007-08-21 15:13:19 +00001085 return rc;
drh4f26d6c2004-05-26 23:25:30 +00001086}
drh5e2517e2004-09-24 23:59:12 +00001087
1088
1089/*
1090** Bind a blob value to an SQL statement variable.
1091*/
1092int sqlite3_bind_blob(
1093 sqlite3_stmt *pStmt,
1094 int i,
1095 const void *zData,
1096 int nData,
1097 void (*xDel)(void*)
1098){
1099 return bindText(pStmt, i, zData, nData, xDel, 0);
1100}
drh4f26d6c2004-05-26 23:25:30 +00001101int sqlite3_bind_double(sqlite3_stmt *pStmt, int i, double rValue){
1102 int rc;
1103 Vdbe *p = (Vdbe *)pStmt;
drh4f26d6c2004-05-26 23:25:30 +00001104 rc = vdbeUnbind(p, i);
1105 if( rc==SQLITE_OK ){
drh290c1942004-08-21 17:54:45 +00001106 sqlite3VdbeMemSetDouble(&p->aVar[i-1], rValue);
drh488e7b62008-10-06 12:46:43 +00001107 sqlite3_mutex_leave(p->db->mutex);
drh4f26d6c2004-05-26 23:25:30 +00001108 }
danielk1977f4618892004-06-28 13:09:11 +00001109 return rc;
drh4f26d6c2004-05-26 23:25:30 +00001110}
1111int sqlite3_bind_int(sqlite3_stmt *p, int i, int iValue){
drhefad9992004-06-22 12:13:55 +00001112 return sqlite3_bind_int64(p, i, (i64)iValue);
drh4f26d6c2004-05-26 23:25:30 +00001113}
drhefad9992004-06-22 12:13:55 +00001114int sqlite3_bind_int64(sqlite3_stmt *pStmt, int i, sqlite_int64 iValue){
drh4f26d6c2004-05-26 23:25:30 +00001115 int rc;
1116 Vdbe *p = (Vdbe *)pStmt;
1117 rc = vdbeUnbind(p, i);
1118 if( rc==SQLITE_OK ){
drh290c1942004-08-21 17:54:45 +00001119 sqlite3VdbeMemSetInt64(&p->aVar[i-1], iValue);
drh488e7b62008-10-06 12:46:43 +00001120 sqlite3_mutex_leave(p->db->mutex);
drh4f26d6c2004-05-26 23:25:30 +00001121 }
1122 return rc;
1123}
drh605264d2007-08-21 15:13:19 +00001124int sqlite3_bind_null(sqlite3_stmt *pStmt, int i){
1125 int rc;
1126 Vdbe *p = (Vdbe*)pStmt;
drh605264d2007-08-21 15:13:19 +00001127 rc = vdbeUnbind(p, i);
drh488e7b62008-10-06 12:46:43 +00001128 if( rc==SQLITE_OK ){
1129 sqlite3_mutex_leave(p->db->mutex);
1130 }
drh605264d2007-08-21 15:13:19 +00001131 return rc;
drh4f26d6c2004-05-26 23:25:30 +00001132}
1133int sqlite3_bind_text(
1134 sqlite3_stmt *pStmt,
1135 int i,
1136 const char *zData,
1137 int nData,
danielk1977d8123362004-06-12 09:25:12 +00001138 void (*xDel)(void*)
drh4f26d6c2004-05-26 23:25:30 +00001139){
drh5e2517e2004-09-24 23:59:12 +00001140 return bindText(pStmt, i, zData, nData, xDel, SQLITE_UTF8);
drh4f26d6c2004-05-26 23:25:30 +00001141}
drh6c626082004-11-14 21:56:29 +00001142#ifndef SQLITE_OMIT_UTF16
drh4f26d6c2004-05-26 23:25:30 +00001143int sqlite3_bind_text16(
1144 sqlite3_stmt *pStmt,
1145 int i,
1146 const void *zData,
1147 int nData,
danielk1977d8123362004-06-12 09:25:12 +00001148 void (*xDel)(void*)
drh4f26d6c2004-05-26 23:25:30 +00001149){
drh5e2517e2004-09-24 23:59:12 +00001150 return bindText(pStmt, i, zData, nData, xDel, SQLITE_UTF16NATIVE);
drh4f26d6c2004-05-26 23:25:30 +00001151}
drh6c626082004-11-14 21:56:29 +00001152#endif /* SQLITE_OMIT_UTF16 */
danielk197726e41442006-06-14 15:16:35 +00001153int sqlite3_bind_value(sqlite3_stmt *pStmt, int i, const sqlite3_value *pValue){
1154 int rc;
drh29def562009-04-14 12:43:33 +00001155 switch( pValue->type ){
drh29def562009-04-14 12:43:33 +00001156 case SQLITE_INTEGER: {
1157 rc = sqlite3_bind_int64(pStmt, i, pValue->u.i);
1158 break;
1159 }
1160 case SQLITE_FLOAT: {
1161 rc = sqlite3_bind_double(pStmt, i, pValue->r);
1162 break;
1163 }
1164 case SQLITE_BLOB: {
1165 if( pValue->flags & MEM_Zero ){
1166 rc = sqlite3_bind_zeroblob(pStmt, i, pValue->u.nZero);
1167 }else{
1168 rc = sqlite3_bind_blob(pStmt, i, pValue->z, pValue->n,SQLITE_TRANSIENT);
1169 }
1170 break;
1171 }
1172 case SQLITE_TEXT: {
drhac80db72009-04-14 12:58:20 +00001173 rc = bindText(pStmt,i, pValue->z, pValue->n, SQLITE_TRANSIENT,
1174 pValue->enc);
1175 break;
1176 }
1177 default: {
1178 rc = sqlite3_bind_null(pStmt, i);
drh29def562009-04-14 12:43:33 +00001179 break;
1180 }
danielk197726e41442006-06-14 15:16:35 +00001181 }
1182 return rc;
1183}
drhb026e052007-05-02 01:34:31 +00001184int sqlite3_bind_zeroblob(sqlite3_stmt *pStmt, int i, int n){
1185 int rc;
1186 Vdbe *p = (Vdbe *)pStmt;
1187 rc = vdbeUnbind(p, i);
1188 if( rc==SQLITE_OK ){
1189 sqlite3VdbeMemSetZeroBlob(&p->aVar[i-1], n);
drh488e7b62008-10-06 12:46:43 +00001190 sqlite3_mutex_leave(p->db->mutex);
drhb026e052007-05-02 01:34:31 +00001191 }
1192 return rc;
1193}
drh75f6a032004-07-15 14:15:00 +00001194
1195/*
1196** Return the number of wildcards that can be potentially bound to.
1197** This routine is added to support DBD::SQLite.
drh75f6a032004-07-15 14:15:00 +00001198*/
1199int sqlite3_bind_parameter_count(sqlite3_stmt *pStmt){
drh92febd92004-08-20 18:34:20 +00001200 Vdbe *p = (Vdbe*)pStmt;
1201 return p ? p->nVar : 0;
drh75f6a032004-07-15 14:15:00 +00001202}
drh895d7472004-08-20 16:02:39 +00001203
1204/*
drhfa6bc002004-09-07 16:19:52 +00001205** Create a mapping from variable numbers to variable names
1206** in the Vdbe.azVar[] array, if such a mapping does not already
1207** exist.
drh895d7472004-08-20 16:02:39 +00001208*/
drhfa6bc002004-09-07 16:19:52 +00001209static void createVarMap(Vdbe *p){
drh895d7472004-08-20 16:02:39 +00001210 if( !p->okVar ){
drh0f5ea0b2009-04-09 14:02:44 +00001211 int j;
1212 Op *pOp;
drh605264d2007-08-21 15:13:19 +00001213 sqlite3_mutex_enter(p->db->mutex);
drh0f5ea0b2009-04-09 14:02:44 +00001214 /* The race condition here is harmless. If two threads call this
1215 ** routine on the same Vdbe at the same time, they both might end
1216 ** up initializing the Vdbe.azVar[] array. That is a little extra
1217 ** work but it results in the same answer.
1218 */
1219 for(j=0, pOp=p->aOp; j<p->nOp; j++, pOp++){
1220 if( pOp->opcode==OP_Variable ){
1221 assert( pOp->p1>0 && pOp->p1<=p->nVar );
1222 p->azVar[pOp->p1-1] = pOp->p4.z;
drh895d7472004-08-20 16:02:39 +00001223 }
1224 }
drh0f5ea0b2009-04-09 14:02:44 +00001225 p->okVar = 1;
drh605264d2007-08-21 15:13:19 +00001226 sqlite3_mutex_leave(p->db->mutex);
drh895d7472004-08-20 16:02:39 +00001227 }
drhfa6bc002004-09-07 16:19:52 +00001228}
1229
1230/*
1231** Return the name of a wildcard parameter. Return NULL if the index
1232** is out of range or if the wildcard is unnamed.
1233**
1234** The result is always UTF-8.
1235*/
1236const char *sqlite3_bind_parameter_name(sqlite3_stmt *pStmt, int i){
1237 Vdbe *p = (Vdbe*)pStmt;
1238 if( p==0 || i<1 || i>p->nVar ){
1239 return 0;
1240 }
1241 createVarMap(p);
drh895d7472004-08-20 16:02:39 +00001242 return p->azVar[i-1];
1243}
drhfa6bc002004-09-07 16:19:52 +00001244
1245/*
1246** Given a wildcard parameter name, return the index of the variable
1247** with that name. If there is no variable with the given name,
1248** return 0.
1249*/
1250int sqlite3_bind_parameter_index(sqlite3_stmt *pStmt, const char *zName){
1251 Vdbe *p = (Vdbe*)pStmt;
1252 int i;
1253 if( p==0 ){
1254 return 0;
1255 }
1256 createVarMap(p);
drh6a8903c2004-12-10 18:00:04 +00001257 if( zName ){
1258 for(i=0; i<p->nVar; i++){
1259 const char *z = p->azVar[i];
1260 if( z && strcmp(z,zName)==0 ){
1261 return i+1;
1262 }
drhfa6bc002004-09-07 16:19:52 +00001263 }
1264 }
1265 return 0;
1266}
drhf8db1bc2005-04-22 02:38:37 +00001267
drh51942bc2005-06-12 22:01:42 +00001268/*
drhf8db1bc2005-04-22 02:38:37 +00001269** Transfer all bindings from the first statement over to the second.
drhf8db1bc2005-04-22 02:38:37 +00001270*/
shane145834a2008-09-04 12:03:42 +00001271int sqlite3TransferBindings(sqlite3_stmt *pFromStmt, sqlite3_stmt *pToStmt){
drhf8db1bc2005-04-22 02:38:37 +00001272 Vdbe *pFrom = (Vdbe*)pFromStmt;
1273 Vdbe *pTo = (Vdbe*)pToStmt;
drh0f5ea0b2009-04-09 14:02:44 +00001274 int i;
1275 assert( pTo->db==pFrom->db );
1276 assert( pTo->nVar==pFrom->nVar );
drh27641702007-08-22 02:56:42 +00001277 sqlite3_mutex_enter(pTo->db->mutex);
drh0f5ea0b2009-04-09 14:02:44 +00001278 for(i=0; i<pFrom->nVar; i++){
drh643167f2008-01-22 21:30:53 +00001279 sqlite3VdbeMemMove(&pTo->aVar[i], &pFrom->aVar[i]);
drhf8db1bc2005-04-22 02:38:37 +00001280 }
drh27641702007-08-22 02:56:42 +00001281 sqlite3_mutex_leave(pTo->db->mutex);
drh0f5ea0b2009-04-09 14:02:44 +00001282 return SQLITE_OK;
drhf8db1bc2005-04-22 02:38:37 +00001283}
drh51942bc2005-06-12 22:01:42 +00001284
shaneeec556d2008-10-12 00:27:53 +00001285#ifndef SQLITE_OMIT_DEPRECATED
drh51942bc2005-06-12 22:01:42 +00001286/*
shane145834a2008-09-04 12:03:42 +00001287** Deprecated external interface. Internal/core SQLite code
1288** should call sqlite3TransferBindings.
drh0f5ea0b2009-04-09 14:02:44 +00001289**
1290** Is is misuse to call this routine with statements from different
1291** database connections. But as this is a deprecated interface, we
1292** will not bother to check for that condition.
1293**
1294** If the two statements contain a different number of bindings, then
1295** an SQLITE_ERROR is returned. Nothing else can go wrong, so otherwise
1296** SQLITE_OK is returned.
shane145834a2008-09-04 12:03:42 +00001297*/
1298int sqlite3_transfer_bindings(sqlite3_stmt *pFromStmt, sqlite3_stmt *pToStmt){
drh0f5ea0b2009-04-09 14:02:44 +00001299 Vdbe *pFrom = (Vdbe*)pFromStmt;
1300 Vdbe *pTo = (Vdbe*)pToStmt;
1301 if( pFrom->nVar!=pTo->nVar ){
1302 return SQLITE_ERROR;
1303 }
shane145834a2008-09-04 12:03:42 +00001304 return sqlite3TransferBindings(pFromStmt, pToStmt);
1305}
shaneeec556d2008-10-12 00:27:53 +00001306#endif
shane145834a2008-09-04 12:03:42 +00001307
1308/*
drh51942bc2005-06-12 22:01:42 +00001309** Return the sqlite3* database handle to which the prepared statement given
1310** in the argument belongs. This is the same database handle that was
1311** the first argument to the sqlite3_prepare() that was used to create
1312** the statement in the first place.
1313*/
1314sqlite3 *sqlite3_db_handle(sqlite3_stmt *pStmt){
1315 return pStmt ? ((Vdbe*)pStmt)->db : 0;
1316}
drhbb5a9c32008-06-19 02:52:25 +00001317
1318/*
1319** Return a pointer to the next prepared statement after pStmt associated
1320** with database connection pDb. If pStmt is NULL, return the first
1321** prepared statement for the database connection. Return NULL if there
1322** are no more.
1323*/
1324sqlite3_stmt *sqlite3_next_stmt(sqlite3 *pDb, sqlite3_stmt *pStmt){
1325 sqlite3_stmt *pNext;
1326 sqlite3_mutex_enter(pDb->mutex);
1327 if( pStmt==0 ){
1328 pNext = (sqlite3_stmt*)pDb->pVdbe;
1329 }else{
1330 pNext = (sqlite3_stmt*)((Vdbe*)pStmt)->pNext;
1331 }
1332 sqlite3_mutex_leave(pDb->mutex);
1333 return pNext;
1334}
drhd1d38482008-10-07 23:46:38 +00001335
1336/*
1337** Return the value of a status counter for a prepared statement
1338*/
1339int sqlite3_stmt_status(sqlite3_stmt *pStmt, int op, int resetFlag){
1340 Vdbe *pVdbe = (Vdbe*)pStmt;
1341 int v = pVdbe->aCounter[op-1];
1342 if( resetFlag ) pVdbe->aCounter[op-1] = 0;
1343 return v;
1344}