drh | dc04c58 | 2002-02-24 01:55:15 +0000 | [diff] [blame] | 1 | /* |
| 2 | ** 2002 February 23 |
| 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 the C functions that implement various SQL |
| 13 | ** functions of SQLite. |
| 14 | ** |
| 15 | ** There is only one exported symbol in this file - the function |
| 16 | ** sqliteRegisterBuildinFunctions() found at the bottom of the file. |
| 17 | ** All other code has file scope. |
| 18 | ** |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 19 | ** $Id: func.c,v 1.170 2007/08/29 12:31:26 danielk1977 Exp $ |
drh | dc04c58 | 2002-02-24 01:55:15 +0000 | [diff] [blame] | 20 | */ |
drh | b659e9b | 2005-01-28 01:29:08 +0000 | [diff] [blame] | 21 | #include "sqliteInt.h" |
drh | dc04c58 | 2002-02-24 01:55:15 +0000 | [diff] [blame] | 22 | #include <ctype.h> |
drh | d3a149e | 2002-02-24 17:12:53 +0000 | [diff] [blame] | 23 | #include <stdlib.h> |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 24 | #include <assert.h> |
danielk1977 | 8820805 | 2004-05-25 01:13:20 +0000 | [diff] [blame] | 25 | #include "vdbeInt.h" |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 26 | |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 27 | |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 28 | /* |
| 29 | ** Return the collating function associated with a function. |
| 30 | */ |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 31 | static CollSeq *sqlite3GetFuncCollSeq(sqlite3_context *context){ |
| 32 | return context->pColl; |
| 33 | } |
| 34 | |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 35 | /* |
| 36 | ** Implementation of the non-aggregate min() and max() functions |
| 37 | */ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 38 | static void minmaxFunc( |
| 39 | sqlite3_context *context, |
| 40 | int argc, |
| 41 | sqlite3_value **argv |
| 42 | ){ |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 43 | int i; |
drh | 268380c | 2004-02-25 13:47:31 +0000 | [diff] [blame] | 44 | int mask; /* 0 for min() or 0xffffffff for max() */ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 45 | int iBest; |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 46 | CollSeq *pColl; |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 47 | |
drh | 89425d5 | 2002-02-28 03:04:48 +0000 | [diff] [blame] | 48 | if( argc==0 ) return; |
drh | c44af71 | 2004-09-02 15:53:56 +0000 | [diff] [blame] | 49 | mask = sqlite3_user_data(context)==0 ? 0 : -1; |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 50 | pColl = sqlite3GetFuncCollSeq(context); |
| 51 | assert( pColl ); |
danielk1977 | c572ef7 | 2004-05-27 09:28:41 +0000 | [diff] [blame] | 52 | assert( mask==-1 || mask==0 ); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 53 | iBest = 0; |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 54 | if( sqlite3_value_type(argv[0])==SQLITE_NULL ) return; |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 55 | for(i=1; i<argc; i++){ |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 56 | if( sqlite3_value_type(argv[i])==SQLITE_NULL ) return; |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 57 | if( (sqlite3MemCompare(argv[iBest], argv[i], pColl)^mask)>=0 ){ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 58 | iBest = i; |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 59 | } |
| 60 | } |
drh | f447950 | 2004-05-27 03:12:53 +0000 | [diff] [blame] | 61 | sqlite3_result_value(context, argv[iBest]); |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 62 | } |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 63 | |
drh | 268380c | 2004-02-25 13:47:31 +0000 | [diff] [blame] | 64 | /* |
| 65 | ** Return the type of the argument. |
| 66 | */ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 67 | static void typeofFunc( |
| 68 | sqlite3_context *context, |
| 69 | int argc, |
| 70 | sqlite3_value **argv |
| 71 | ){ |
danielk1977 | 35bb9d0 | 2004-05-24 12:55:54 +0000 | [diff] [blame] | 72 | const char *z = 0; |
danielk1977 | 35bb9d0 | 2004-05-24 12:55:54 +0000 | [diff] [blame] | 73 | switch( sqlite3_value_type(argv[0]) ){ |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 74 | case SQLITE_NULL: z = "null"; break; |
| 75 | case SQLITE_INTEGER: z = "integer"; break; |
| 76 | case SQLITE_TEXT: z = "text"; break; |
| 77 | case SQLITE_FLOAT: z = "real"; break; |
| 78 | case SQLITE_BLOB: z = "blob"; break; |
danielk1977 | 35bb9d0 | 2004-05-24 12:55:54 +0000 | [diff] [blame] | 79 | } |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 80 | sqlite3_result_text(context, z, -1, SQLITE_STATIC); |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 81 | } |
| 82 | |
drh | 5708d2d | 2005-06-22 10:53:59 +0000 | [diff] [blame] | 83 | |
| 84 | /* |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 85 | ** Implementation of the length() function |
| 86 | */ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 87 | static void lengthFunc( |
| 88 | sqlite3_context *context, |
| 89 | int argc, |
| 90 | sqlite3_value **argv |
| 91 | ){ |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 92 | int len; |
| 93 | |
| 94 | assert( argc==1 ); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 95 | switch( sqlite3_value_type(argv[0]) ){ |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 96 | case SQLITE_BLOB: |
| 97 | case SQLITE_INTEGER: |
| 98 | case SQLITE_FLOAT: { |
drh | f447950 | 2004-05-27 03:12:53 +0000 | [diff] [blame] | 99 | sqlite3_result_int(context, sqlite3_value_bytes(argv[0])); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 100 | break; |
| 101 | } |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 102 | case SQLITE_TEXT: { |
drh | 2646da7 | 2005-12-09 20:02:05 +0000 | [diff] [blame] | 103 | const unsigned char *z = sqlite3_value_text(argv[0]); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 104 | if( z==0 ) return; |
drh | 4a91911 | 2007-05-15 11:55:09 +0000 | [diff] [blame] | 105 | len = 0; |
| 106 | while( *z ){ |
| 107 | len++; |
| 108 | SQLITE_SKIP_UTF8(z); |
| 109 | } |
drh | f447950 | 2004-05-27 03:12:53 +0000 | [diff] [blame] | 110 | sqlite3_result_int(context, len); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 111 | break; |
| 112 | } |
| 113 | default: { |
| 114 | sqlite3_result_null(context); |
| 115 | break; |
| 116 | } |
| 117 | } |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 118 | } |
| 119 | |
| 120 | /* |
| 121 | ** Implementation of the abs() function |
| 122 | */ |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 123 | static void absFunc(sqlite3_context *context, int argc, sqlite3_value **argv){ |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 124 | assert( argc==1 ); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 125 | switch( sqlite3_value_type(argv[0]) ){ |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 126 | case SQLITE_INTEGER: { |
danielk1977 | f93bbbe | 2004-05-27 10:30:52 +0000 | [diff] [blame] | 127 | i64 iVal = sqlite3_value_int64(argv[0]); |
drh | 52fc849 | 2006-02-23 21:43:55 +0000 | [diff] [blame] | 128 | if( iVal<0 ){ |
| 129 | if( (iVal<<1)==0 ){ |
| 130 | sqlite3_result_error(context, "integer overflow", -1); |
| 131 | return; |
| 132 | } |
| 133 | iVal = -iVal; |
| 134 | } |
danielk1977 | f93bbbe | 2004-05-27 10:30:52 +0000 | [diff] [blame] | 135 | sqlite3_result_int64(context, iVal); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 136 | break; |
| 137 | } |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 138 | case SQLITE_NULL: { |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 139 | sqlite3_result_null(context); |
| 140 | break; |
| 141 | } |
| 142 | default: { |
danielk1977 | f93bbbe | 2004-05-27 10:30:52 +0000 | [diff] [blame] | 143 | double rVal = sqlite3_value_double(argv[0]); |
drh | 52fc849 | 2006-02-23 21:43:55 +0000 | [diff] [blame] | 144 | if( rVal<0 ) rVal = -rVal; |
danielk1977 | f93bbbe | 2004-05-27 10:30:52 +0000 | [diff] [blame] | 145 | sqlite3_result_double(context, rVal); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 146 | break; |
| 147 | } |
| 148 | } |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 149 | } |
| 150 | |
| 151 | /* |
drh | f764e6f | 2007-05-15 01:13:47 +0000 | [diff] [blame] | 152 | ** Implementation of the substr() function. |
| 153 | ** |
| 154 | ** substr(x,p1,p2) returns p2 characters of x[] beginning with p1. |
| 155 | ** p1 is 1-indexed. So substr(x,1,1) returns the first character |
| 156 | ** of x. If x is text, then we actually count UTF-8 characters. |
| 157 | ** If x is a blob, then we count bytes. |
| 158 | ** |
| 159 | ** If p1 is negative, then we begin abs(p1) from the end of x[]. |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 160 | */ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 161 | static void substrFunc( |
| 162 | sqlite3_context *context, |
| 163 | int argc, |
| 164 | sqlite3_value **argv |
| 165 | ){ |
drh | 2646da7 | 2005-12-09 20:02:05 +0000 | [diff] [blame] | 166 | const unsigned char *z; |
| 167 | const unsigned char *z2; |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 168 | int len; |
drh | f764e6f | 2007-05-15 01:13:47 +0000 | [diff] [blame] | 169 | int p0type; |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 170 | i64 p1, p2; |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 171 | |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 172 | assert( argc==3 ); |
drh | f764e6f | 2007-05-15 01:13:47 +0000 | [diff] [blame] | 173 | p0type = sqlite3_value_type(argv[0]); |
| 174 | if( p0type==SQLITE_BLOB ){ |
| 175 | len = sqlite3_value_bytes(argv[0]); |
| 176 | z = sqlite3_value_blob(argv[0]); |
| 177 | if( z==0 ) return; |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 178 | assert( len==sqlite3_value_bytes(argv[0]) ); |
drh | f764e6f | 2007-05-15 01:13:47 +0000 | [diff] [blame] | 179 | }else{ |
| 180 | z = sqlite3_value_text(argv[0]); |
| 181 | if( z==0 ) return; |
drh | 4a91911 | 2007-05-15 11:55:09 +0000 | [diff] [blame] | 182 | len = 0; |
| 183 | for(z2=z; *z2; len++){ |
| 184 | SQLITE_SKIP_UTF8(z2); |
| 185 | } |
drh | f764e6f | 2007-05-15 01:13:47 +0000 | [diff] [blame] | 186 | } |
danielk1977 | 51ad0ec | 2004-05-24 12:39:02 +0000 | [diff] [blame] | 187 | p1 = sqlite3_value_int(argv[1]); |
| 188 | p2 = sqlite3_value_int(argv[2]); |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 189 | if( p1<0 ){ |
drh | 89425d5 | 2002-02-28 03:04:48 +0000 | [diff] [blame] | 190 | p1 += len; |
drh | 653bc75 | 2002-02-28 03:31:10 +0000 | [diff] [blame] | 191 | if( p1<0 ){ |
| 192 | p2 += p1; |
| 193 | p1 = 0; |
| 194 | } |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 195 | }else if( p1>0 ){ |
| 196 | p1--; |
| 197 | } |
| 198 | if( p1+p2>len ){ |
| 199 | p2 = len-p1; |
| 200 | } |
drh | f764e6f | 2007-05-15 01:13:47 +0000 | [diff] [blame] | 201 | if( p0type!=SQLITE_BLOB ){ |
drh | 4a91911 | 2007-05-15 11:55:09 +0000 | [diff] [blame] | 202 | while( *z && p1 ){ |
| 203 | SQLITE_SKIP_UTF8(z); |
| 204 | p1--; |
drh | f764e6f | 2007-05-15 01:13:47 +0000 | [diff] [blame] | 205 | } |
drh | 4a91911 | 2007-05-15 11:55:09 +0000 | [diff] [blame] | 206 | for(z2=z; *z2 && p2; p2--){ |
| 207 | SQLITE_SKIP_UTF8(z2); |
drh | f764e6f | 2007-05-15 01:13:47 +0000 | [diff] [blame] | 208 | } |
drh | 4a91911 | 2007-05-15 11:55:09 +0000 | [diff] [blame] | 209 | sqlite3_result_text(context, (char*)z, z2-z, SQLITE_TRANSIENT); |
drh | f764e6f | 2007-05-15 01:13:47 +0000 | [diff] [blame] | 210 | }else{ |
| 211 | if( p2<0 ) p2 = 0; |
| 212 | sqlite3_result_blob(context, (char*)&z[p1], p2, SQLITE_TRANSIENT); |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 213 | } |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 214 | } |
| 215 | |
| 216 | /* |
| 217 | ** Implementation of the round() function |
| 218 | */ |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 219 | static void roundFunc(sqlite3_context *context, int argc, sqlite3_value **argv){ |
danielk1977 | 51ad0ec | 2004-05-24 12:39:02 +0000 | [diff] [blame] | 220 | int n = 0; |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 221 | double r; |
drh | 592ac8c | 2005-08-13 03:07:47 +0000 | [diff] [blame] | 222 | char zBuf[500]; /* larger than the %f representation of the largest double */ |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 223 | assert( argc==1 || argc==2 ); |
danielk1977 | 51ad0ec | 2004-05-24 12:39:02 +0000 | [diff] [blame] | 224 | if( argc==2 ){ |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 225 | if( SQLITE_NULL==sqlite3_value_type(argv[1]) ) return; |
danielk1977 | 51ad0ec | 2004-05-24 12:39:02 +0000 | [diff] [blame] | 226 | n = sqlite3_value_int(argv[1]); |
| 227 | if( n>30 ) n = 30; |
| 228 | if( n<0 ) n = 0; |
| 229 | } |
drh | d589a92 | 2006-03-02 03:02:48 +0000 | [diff] [blame] | 230 | if( sqlite3_value_type(argv[0])==SQLITE_NULL ) return; |
drh | 4f26d6c | 2004-05-26 23:25:30 +0000 | [diff] [blame] | 231 | r = sqlite3_value_double(argv[0]); |
drh | e866fcb | 2005-07-09 02:38:06 +0000 | [diff] [blame] | 232 | sqlite3_snprintf(sizeof(zBuf),zBuf,"%.*f",n,r); |
drh | 502b962 | 2006-04-07 13:26:42 +0000 | [diff] [blame] | 233 | sqlite3AtoF(zBuf, &r); |
| 234 | sqlite3_result_double(context, r); |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 235 | } |
drh | dc04c58 | 2002-02-24 01:55:15 +0000 | [diff] [blame] | 236 | |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 237 | static void *contextMalloc(sqlite3_context *context, int nByte){ |
| 238 | char *z = sqlite3_malloc(nByte); |
| 239 | if( !z && nByte>0 ){ |
| 240 | sqlite3_result_error_nomem(context); |
| 241 | } |
| 242 | return z; |
| 243 | } |
| 244 | |
drh | dc04c58 | 2002-02-24 01:55:15 +0000 | [diff] [blame] | 245 | /* |
| 246 | ** Implementation of the upper() and lower() SQL functions. |
| 247 | */ |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 248 | static void upperFunc(sqlite3_context *context, int argc, sqlite3_value **argv){ |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 249 | char *z1; |
| 250 | const char *z2; |
drh | 9310ef2 | 2007-04-27 17:16:20 +0000 | [diff] [blame] | 251 | int i, n; |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 252 | if( argc<1 || SQLITE_NULL==sqlite3_value_type(argv[0]) ) return; |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 253 | z2 = (char*)sqlite3_value_text(argv[0]); |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 254 | n = sqlite3_value_bytes(argv[0]); |
| 255 | /* Verify that the call to _bytes() does not invalidate the _text() pointer */ |
| 256 | assert( z2==(char*)sqlite3_value_text(argv[0]) ); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 257 | if( z2 ){ |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 258 | z1 = contextMalloc(context, n+1); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 259 | if( z1 ){ |
drh | 5bb3eb9 | 2007-05-04 13:15:55 +0000 | [diff] [blame] | 260 | memcpy(z1, z2, n+1); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 261 | for(i=0; z1[i]; i++){ |
| 262 | z1[i] = toupper(z1[i]); |
| 263 | } |
| 264 | sqlite3_result_text(context, z1, -1, sqlite3_free); |
| 265 | } |
drh | dc04c58 | 2002-02-24 01:55:15 +0000 | [diff] [blame] | 266 | } |
| 267 | } |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 268 | static void lowerFunc(sqlite3_context *context, int argc, sqlite3_value **argv){ |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 269 | char *z1; |
| 270 | const char *z2; |
drh | 9310ef2 | 2007-04-27 17:16:20 +0000 | [diff] [blame] | 271 | int i, n; |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 272 | if( argc<1 || SQLITE_NULL==sqlite3_value_type(argv[0]) ) return; |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 273 | z2 = (char*)sqlite3_value_text(argv[0]); |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 274 | n = sqlite3_value_bytes(argv[0]); |
| 275 | /* Verify that the call to _bytes() does not invalidate the _text() pointer */ |
| 276 | assert( z2==(char*)sqlite3_value_text(argv[0]) ); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 277 | if( z2 ){ |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 278 | z1 = contextMalloc(context, n+1); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 279 | if( z1 ){ |
drh | 5bb3eb9 | 2007-05-04 13:15:55 +0000 | [diff] [blame] | 280 | memcpy(z1, z2, n+1); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 281 | for(i=0; z1[i]; i++){ |
| 282 | z1[i] = tolower(z1[i]); |
| 283 | } |
| 284 | sqlite3_result_text(context, z1, -1, sqlite3_free); |
| 285 | } |
drh | dc04c58 | 2002-02-24 01:55:15 +0000 | [diff] [blame] | 286 | } |
| 287 | } |
| 288 | |
| 289 | /* |
drh | fbc9908 | 2002-02-28 03:14:18 +0000 | [diff] [blame] | 290 | ** Implementation of the IFNULL(), NVL(), and COALESCE() functions. |
jplyon | b6c9e6e | 2004-01-19 04:53:24 +0000 | [diff] [blame] | 291 | ** All three do the same thing. They return the first non-NULL |
| 292 | ** argument. |
drh | 3212e18 | 2002-02-28 00:46:26 +0000 | [diff] [blame] | 293 | */ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 294 | static void ifnullFunc( |
| 295 | sqlite3_context *context, |
| 296 | int argc, |
| 297 | sqlite3_value **argv |
| 298 | ){ |
drh | fbc9908 | 2002-02-28 03:14:18 +0000 | [diff] [blame] | 299 | int i; |
| 300 | for(i=0; i<argc; i++){ |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 301 | if( SQLITE_NULL!=sqlite3_value_type(argv[i]) ){ |
drh | f447950 | 2004-05-27 03:12:53 +0000 | [diff] [blame] | 302 | sqlite3_result_value(context, argv[i]); |
drh | fbc9908 | 2002-02-28 03:14:18 +0000 | [diff] [blame] | 303 | break; |
| 304 | } |
| 305 | } |
drh | 3212e18 | 2002-02-28 00:46:26 +0000 | [diff] [blame] | 306 | } |
| 307 | |
| 308 | /* |
drh | f9ffac9 | 2002-03-02 19:00:31 +0000 | [diff] [blame] | 309 | ** Implementation of random(). Return a random integer. |
| 310 | */ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 311 | static void randomFunc( |
| 312 | sqlite3_context *context, |
| 313 | int argc, |
| 314 | sqlite3_value **argv |
| 315 | ){ |
drh | 52fc849 | 2006-02-23 21:43:55 +0000 | [diff] [blame] | 316 | sqlite_int64 r; |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 317 | sqlite3Randomness(sizeof(r), &r); |
drh | 874abbe | 2006-02-23 21:51:12 +0000 | [diff] [blame] | 318 | if( (r<<1)==0 ) r = 0; /* Prevent 0x8000.... as the result so that we */ |
| 319 | /* can always do abs() of the result */ |
drh | 52fc849 | 2006-02-23 21:43:55 +0000 | [diff] [blame] | 320 | sqlite3_result_int64(context, r); |
drh | f9ffac9 | 2002-03-02 19:00:31 +0000 | [diff] [blame] | 321 | } |
| 322 | |
| 323 | /* |
drh | 137c728 | 2007-01-29 17:58:28 +0000 | [diff] [blame] | 324 | ** Implementation of randomblob(N). Return a random blob |
| 325 | ** that is N bytes long. |
drh | 63cf66f | 2007-01-29 15:50:05 +0000 | [diff] [blame] | 326 | */ |
drh | 137c728 | 2007-01-29 17:58:28 +0000 | [diff] [blame] | 327 | static void randomBlob( |
drh | 63cf66f | 2007-01-29 15:50:05 +0000 | [diff] [blame] | 328 | sqlite3_context *context, |
| 329 | int argc, |
| 330 | sqlite3_value **argv |
| 331 | ){ |
drh | 137c728 | 2007-01-29 17:58:28 +0000 | [diff] [blame] | 332 | int n; |
| 333 | unsigned char *p; |
drh | 63cf66f | 2007-01-29 15:50:05 +0000 | [diff] [blame] | 334 | assert( argc==1 ); |
| 335 | n = sqlite3_value_int(argv[0]); |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 336 | if( n<1 ){ |
| 337 | n = 1; |
| 338 | } |
| 339 | if( n>SQLITE_MAX_LENGTH ){ |
drh | a0206bc | 2007-05-08 15:15:02 +0000 | [diff] [blame] | 340 | sqlite3_result_error_toobig(context); |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 341 | return; |
| 342 | } |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 343 | p = contextMalloc(context, n); |
drh | 02d8583 | 2007-05-07 19:31:15 +0000 | [diff] [blame] | 344 | if( p ){ |
| 345 | sqlite3Randomness(n, p); |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 346 | sqlite3_result_blob(context, (char*)p, n, sqlite3_free); |
drh | 02d8583 | 2007-05-07 19:31:15 +0000 | [diff] [blame] | 347 | } |
drh | 63cf66f | 2007-01-29 15:50:05 +0000 | [diff] [blame] | 348 | } |
| 349 | |
| 350 | /* |
drh | 6ed41ad | 2002-04-06 14:10:47 +0000 | [diff] [blame] | 351 | ** Implementation of the last_insert_rowid() SQL function. The return |
danielk1977 | 24b03fd | 2004-05-10 10:34:34 +0000 | [diff] [blame] | 352 | ** value is the same as the sqlite3_last_insert_rowid() API function. |
drh | 6ed41ad | 2002-04-06 14:10:47 +0000 | [diff] [blame] | 353 | */ |
danielk1977 | 51ad0ec | 2004-05-24 12:39:02 +0000 | [diff] [blame] | 354 | static void last_insert_rowid( |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 355 | sqlite3_context *context, |
danielk1977 | 51ad0ec | 2004-05-24 12:39:02 +0000 | [diff] [blame] | 356 | int arg, |
| 357 | sqlite3_value **argv |
| 358 | ){ |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 359 | sqlite3 *db = sqlite3_user_data(context); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 360 | sqlite3_result_int64(context, sqlite3_last_insert_rowid(db)); |
drh | 6ed41ad | 2002-04-06 14:10:47 +0000 | [diff] [blame] | 361 | } |
| 362 | |
rdc | f146a77 | 2004-02-25 22:51:06 +0000 | [diff] [blame] | 363 | /* |
danielk1977 | b28af71 | 2004-06-21 06:50:26 +0000 | [diff] [blame] | 364 | ** Implementation of the changes() SQL function. The return value is the |
| 365 | ** same as the sqlite3_changes() API function. |
rdc | f146a77 | 2004-02-25 22:51:06 +0000 | [diff] [blame] | 366 | */ |
danielk1977 | b28af71 | 2004-06-21 06:50:26 +0000 | [diff] [blame] | 367 | static void changes( |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 368 | sqlite3_context *context, |
| 369 | int arg, |
| 370 | sqlite3_value **argv |
| 371 | ){ |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 372 | sqlite3 *db = sqlite3_user_data(context); |
drh | f447950 | 2004-05-27 03:12:53 +0000 | [diff] [blame] | 373 | sqlite3_result_int(context, sqlite3_changes(db)); |
rdc | b0c374f | 2004-02-20 22:53:38 +0000 | [diff] [blame] | 374 | } |
rdc | f146a77 | 2004-02-25 22:51:06 +0000 | [diff] [blame] | 375 | |
| 376 | /* |
danielk1977 | b28af71 | 2004-06-21 06:50:26 +0000 | [diff] [blame] | 377 | ** Implementation of the total_changes() SQL function. The return value is |
| 378 | ** the same as the sqlite3_total_changes() API function. |
rdc | f146a77 | 2004-02-25 22:51:06 +0000 | [diff] [blame] | 379 | */ |
danielk1977 | b28af71 | 2004-06-21 06:50:26 +0000 | [diff] [blame] | 380 | static void total_changes( |
| 381 | sqlite3_context *context, |
danielk1977 | 51ad0ec | 2004-05-24 12:39:02 +0000 | [diff] [blame] | 382 | int arg, |
| 383 | sqlite3_value **argv |
| 384 | ){ |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 385 | sqlite3 *db = sqlite3_user_data(context); |
danielk1977 | b28af71 | 2004-06-21 06:50:26 +0000 | [diff] [blame] | 386 | sqlite3_result_int(context, sqlite3_total_changes(db)); |
rdc | b0c374f | 2004-02-20 22:53:38 +0000 | [diff] [blame] | 387 | } |
| 388 | |
drh | 6ed41ad | 2002-04-06 14:10:47 +0000 | [diff] [blame] | 389 | /* |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 390 | ** A structure defining how to do GLOB-style comparisons. |
danielk1977 | d02eb1f | 2004-06-06 09:44:03 +0000 | [diff] [blame] | 391 | */ |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 392 | struct compareInfo { |
| 393 | u8 matchAll; |
| 394 | u8 matchOne; |
| 395 | u8 matchSet; |
| 396 | u8 noCase; |
danielk1977 | d02eb1f | 2004-06-06 09:44:03 +0000 | [diff] [blame] | 397 | }; |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 398 | |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 399 | static const struct compareInfo globInfo = { '*', '?', '[', 0 }; |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 400 | /* The correct SQL-92 behavior is for the LIKE operator to ignore |
| 401 | ** case. Thus 'a' LIKE 'A' would be true. */ |
| 402 | static const struct compareInfo likeInfoNorm = { '%', '_', 0, 1 }; |
| 403 | /* If SQLITE_CASE_SENSITIVE_LIKE is defined, then the LIKE operator |
| 404 | ** is case sensitive causing 'a' LIKE 'A' to be false */ |
| 405 | static const struct compareInfo likeInfoAlt = { '%', '_', 0, 0 }; |
danielk1977 | d02eb1f | 2004-06-06 09:44:03 +0000 | [diff] [blame] | 406 | |
| 407 | /* |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 408 | ** Compare two UTF-8 strings for equality where the first string can |
| 409 | ** potentially be a "glob" expression. Return true (1) if they |
| 410 | ** are the same and false (0) if they are different. |
drh | 0ac6589 | 2002-04-20 14:24:41 +0000 | [diff] [blame] | 411 | ** |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 412 | ** Globbing rules: |
drh | 0ac6589 | 2002-04-20 14:24:41 +0000 | [diff] [blame] | 413 | ** |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 414 | ** '*' Matches any sequence of zero or more characters. |
danielk1977 | d02eb1f | 2004-06-06 09:44:03 +0000 | [diff] [blame] | 415 | ** |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 416 | ** '?' Matches exactly one character. |
| 417 | ** |
| 418 | ** [...] Matches one character from the enclosed list of |
| 419 | ** characters. |
| 420 | ** |
| 421 | ** [^...] Matches one character not in the enclosed list. |
| 422 | ** |
| 423 | ** With the [...] and [^...] matching, a ']' character can be included |
| 424 | ** in the list by making it the first character after '[' or '^'. A |
| 425 | ** range of characters can be specified using '-'. Example: |
| 426 | ** "[a-z]" matches any single lower-case letter. To match a '-', make |
| 427 | ** it the last character in the list. |
| 428 | ** |
| 429 | ** This routine is usually quick, but can be N**2 in the worst case. |
| 430 | ** |
| 431 | ** Hints: to match '*' or '?', put them in "[]". Like this: |
| 432 | ** |
| 433 | ** abc[*]xyz Matches "abc*xyz" only |
drh | 0ac6589 | 2002-04-20 14:24:41 +0000 | [diff] [blame] | 434 | */ |
danielk1977 | 7c6303c | 2004-11-17 16:41:29 +0000 | [diff] [blame] | 435 | static int patternCompare( |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 436 | const u8 *zPattern, /* The glob pattern */ |
| 437 | const u8 *zString, /* The string to compare against the glob */ |
danielk1977 | 7c6303c | 2004-11-17 16:41:29 +0000 | [diff] [blame] | 438 | const struct compareInfo *pInfo, /* Information about how to do the compare */ |
| 439 | const int esc /* The escape character */ |
danielk1977 | 51ad0ec | 2004-05-24 12:39:02 +0000 | [diff] [blame] | 440 | ){ |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 441 | int c, c2; |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 442 | int invert; |
| 443 | int seen; |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 444 | u8 matchOne = pInfo->matchOne; |
| 445 | u8 matchAll = pInfo->matchAll; |
| 446 | u8 matchSet = pInfo->matchSet; |
| 447 | u8 noCase = pInfo->noCase; |
danielk1977 | 7c6303c | 2004-11-17 16:41:29 +0000 | [diff] [blame] | 448 | int prevEscape = 0; /* True if the previous character was 'escape' */ |
danielk1977 | d02eb1f | 2004-06-06 09:44:03 +0000 | [diff] [blame] | 449 | |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 450 | while( (c = sqlite3Utf8Read(zPattern,0,&zPattern))!=0 ){ |
danielk1977 | 7c6303c | 2004-11-17 16:41:29 +0000 | [diff] [blame] | 451 | if( !prevEscape && c==matchAll ){ |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 452 | while( (c=sqlite3Utf8Read(zPattern,0,&zPattern)) == matchAll |
| 453 | || c == matchOne ){ |
| 454 | if( c==matchOne && sqlite3Utf8Read(zString, 0, &zString)==0 ){ |
| 455 | return 0; |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 456 | } |
danielk1977 | ad7dd42 | 2004-06-06 12:41:49 +0000 | [diff] [blame] | 457 | } |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 458 | if( c==0 ){ |
| 459 | return 1; |
| 460 | }else if( c==esc ){ |
| 461 | c = sqlite3Utf8Read(zPattern, 0, &zPattern); |
| 462 | if( c==0 ){ |
| 463 | return 0; |
| 464 | } |
| 465 | }else if( c==matchSet ){ |
| 466 | assert( esc==0 ); /* This is GLOB, not LIKE */ |
| 467 | assert( matchSet<0x80 ); /* '[' is a single-byte character */ |
| 468 | while( *zString && patternCompare(&zPattern[-1],zString,pInfo,esc)==0 ){ |
drh | 4a91911 | 2007-05-15 11:55:09 +0000 | [diff] [blame] | 469 | SQLITE_SKIP_UTF8(zString); |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 470 | } |
| 471 | return *zString!=0; |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 472 | } |
| 473 | while( (c2 = sqlite3Utf8Read(zString,0,&zString))!=0 ){ |
| 474 | if( noCase ){ |
| 475 | c2 = c2<0x80 ? sqlite3UpperToLower[c2] : c2; |
| 476 | c = c<0x80 ? sqlite3UpperToLower[c] : c; |
| 477 | while( c2 != 0 && c2 != c ){ |
| 478 | c2 = sqlite3Utf8Read(zString, 0, &zString); |
| 479 | if( c2<0x80 ) c2 = sqlite3UpperToLower[c2]; |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 480 | } |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 481 | }else{ |
| 482 | while( c2 != 0 && c2 != c ){ |
| 483 | c2 = sqlite3Utf8Read(zString, 0, &zString); |
| 484 | } |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 485 | } |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 486 | if( c2==0 ) return 0; |
| 487 | if( patternCompare(zPattern,zString,pInfo,esc) ) return 1; |
| 488 | } |
| 489 | return 0; |
| 490 | }else if( !prevEscape && c==matchOne ){ |
| 491 | if( sqlite3Utf8Read(zString, 0, &zString)==0 ){ |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 492 | return 0; |
danielk1977 | d02eb1f | 2004-06-06 09:44:03 +0000 | [diff] [blame] | 493 | } |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 494 | }else if( c==matchSet ){ |
| 495 | int prior_c = 0; |
danielk1977 | 7c6303c | 2004-11-17 16:41:29 +0000 | [diff] [blame] | 496 | assert( esc==0 ); /* This only occurs for GLOB, not LIKE */ |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 497 | seen = 0; |
| 498 | invert = 0; |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 499 | c = sqlite3Utf8Read(zString, 0, &zString); |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 500 | if( c==0 ) return 0; |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 501 | c2 = sqlite3Utf8Read(zPattern, 0, &zPattern); |
| 502 | if( c2=='^' ){ |
| 503 | invert = 1; |
| 504 | c2 = sqlite3Utf8Read(zPattern, 0, &zPattern); |
| 505 | } |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 506 | if( c2==']' ){ |
| 507 | if( c==']' ) seen = 1; |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 508 | c2 = sqlite3Utf8Read(zPattern, 0, &zPattern); |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 509 | } |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 510 | while( c2 && c2!=']' ){ |
| 511 | if( c2=='-' && zPattern[0]!=']' && zPattern[0]!=0 && prior_c>0 ){ |
| 512 | c2 = sqlite3Utf8Read(zPattern, 0, &zPattern); |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 513 | if( c>=prior_c && c<=c2 ) seen = 1; |
| 514 | prior_c = 0; |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 515 | }else{ |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 516 | if( c==c2 ){ |
| 517 | seen = 1; |
| 518 | } |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 519 | prior_c = c2; |
| 520 | } |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 521 | c2 = sqlite3Utf8Read(zPattern, 0, &zPattern); |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 522 | } |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 523 | if( c2==0 || (seen ^ invert)==0 ){ |
| 524 | return 0; |
| 525 | } |
| 526 | }else if( esc==c && !prevEscape ){ |
danielk1977 | 7c6303c | 2004-11-17 16:41:29 +0000 | [diff] [blame] | 527 | prevEscape = 1; |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 528 | }else{ |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 529 | c2 = sqlite3Utf8Read(zString, 0, &zString); |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 530 | if( noCase ){ |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 531 | c = c<0x80 ? sqlite3UpperToLower[c] : c; |
| 532 | c2 = c2<0x80 ? sqlite3UpperToLower[c2] : c2; |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 533 | } |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 534 | if( c!=c2 ){ |
| 535 | return 0; |
| 536 | } |
danielk1977 | 7c6303c | 2004-11-17 16:41:29 +0000 | [diff] [blame] | 537 | prevEscape = 0; |
danielk1977 | d02eb1f | 2004-06-06 09:44:03 +0000 | [diff] [blame] | 538 | } |
danielk1977 | 51ad0ec | 2004-05-24 12:39:02 +0000 | [diff] [blame] | 539 | } |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 540 | return *zString==0; |
drh | 0ac6589 | 2002-04-20 14:24:41 +0000 | [diff] [blame] | 541 | } |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 542 | |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 543 | /* |
| 544 | ** Count the number of times that the LIKE operator (or GLOB which is |
| 545 | ** just a variation of LIKE) gets called. This is used for testing |
| 546 | ** only. |
| 547 | */ |
| 548 | #ifdef SQLITE_TEST |
| 549 | int sqlite3_like_count = 0; |
| 550 | #endif |
| 551 | |
danielk1977 | 3f6b087 | 2004-06-17 05:36:44 +0000 | [diff] [blame] | 552 | |
| 553 | /* |
| 554 | ** Implementation of the like() SQL function. This function implements |
| 555 | ** the build-in LIKE operator. The first argument to the function is the |
| 556 | ** pattern and the second argument is the string. So, the SQL statements: |
| 557 | ** |
| 558 | ** A LIKE B |
| 559 | ** |
| 560 | ** is implemented as like(B,A). |
| 561 | ** |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 562 | ** This same function (with a different compareInfo structure) computes |
| 563 | ** the GLOB operator. |
danielk1977 | 3f6b087 | 2004-06-17 05:36:44 +0000 | [diff] [blame] | 564 | */ |
| 565 | static void likeFunc( |
| 566 | sqlite3_context *context, |
| 567 | int argc, |
| 568 | sqlite3_value **argv |
| 569 | ){ |
drh | beb818d | 2007-05-08 15:34:47 +0000 | [diff] [blame] | 570 | const unsigned char *zA, *zB; |
drh | 85892bd | 2007-05-10 13:23:22 +0000 | [diff] [blame] | 571 | int escape = 0; |
drh | beb818d | 2007-05-08 15:34:47 +0000 | [diff] [blame] | 572 | |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 573 | zB = sqlite3_value_text(argv[0]); |
| 574 | zA = sqlite3_value_text(argv[1]); |
| 575 | |
drh | beb818d | 2007-05-08 15:34:47 +0000 | [diff] [blame] | 576 | /* Limit the length of the LIKE or GLOB pattern to avoid problems |
| 577 | ** of deep recursion and N*N behavior in patternCompare(). |
| 578 | */ |
danielk1977 | b56fe1f | 2007-05-09 08:24:44 +0000 | [diff] [blame] | 579 | if( sqlite3_value_bytes(argv[0])>SQLITE_MAX_LIKE_PATTERN_LENGTH ){ |
drh | beb818d | 2007-05-08 15:34:47 +0000 | [diff] [blame] | 580 | sqlite3_result_error(context, "LIKE or GLOB pattern too complex", -1); |
| 581 | return; |
| 582 | } |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 583 | assert( zB==sqlite3_value_text(argv[0]) ); /* Encoding did not change */ |
drh | beb818d | 2007-05-08 15:34:47 +0000 | [diff] [blame] | 584 | |
danielk1977 | 7c6303c | 2004-11-17 16:41:29 +0000 | [diff] [blame] | 585 | if( argc==3 ){ |
| 586 | /* The escape character string must consist of a single UTF-8 character. |
| 587 | ** Otherwise, return an error. |
| 588 | */ |
| 589 | const unsigned char *zEsc = sqlite3_value_text(argv[2]); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 590 | if( zEsc==0 ) return; |
drh | ee85813 | 2007-05-08 20:37:38 +0000 | [diff] [blame] | 591 | if( sqlite3Utf8CharLen((char*)zEsc, -1)!=1 ){ |
danielk1977 | 7c6303c | 2004-11-17 16:41:29 +0000 | [diff] [blame] | 592 | sqlite3_result_error(context, |
| 593 | "ESCAPE expression must be a single character", -1); |
| 594 | return; |
| 595 | } |
drh | 6615095 | 2007-07-23 19:12:41 +0000 | [diff] [blame] | 596 | escape = sqlite3Utf8Read(zEsc, 0, &zEsc); |
danielk1977 | 7c6303c | 2004-11-17 16:41:29 +0000 | [diff] [blame] | 597 | } |
danielk1977 | 3f6b087 | 2004-06-17 05:36:44 +0000 | [diff] [blame] | 598 | if( zA && zB ){ |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 599 | struct compareInfo *pInfo = sqlite3_user_data(context); |
| 600 | #ifdef SQLITE_TEST |
| 601 | sqlite3_like_count++; |
| 602 | #endif |
drh | beb818d | 2007-05-08 15:34:47 +0000 | [diff] [blame] | 603 | |
danielk1977 | b56fe1f | 2007-05-09 08:24:44 +0000 | [diff] [blame] | 604 | sqlite3_result_int(context, patternCompare(zB, zA, pInfo, escape)); |
danielk1977 | 51ad0ec | 2004-05-24 12:39:02 +0000 | [diff] [blame] | 605 | } |
drh | 8912d10 | 2002-05-26 21:34:58 +0000 | [diff] [blame] | 606 | } |
| 607 | |
| 608 | /* |
| 609 | ** Implementation of the NULLIF(x,y) function. The result is the first |
| 610 | ** argument if the arguments are different. The result is NULL if the |
| 611 | ** arguments are equal to each other. |
| 612 | */ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 613 | static void nullifFunc( |
| 614 | sqlite3_context *context, |
| 615 | int argc, |
| 616 | sqlite3_value **argv |
| 617 | ){ |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 618 | CollSeq *pColl = sqlite3GetFuncCollSeq(context); |
| 619 | if( sqlite3MemCompare(argv[0], argv[1], pColl)!=0 ){ |
drh | f447950 | 2004-05-27 03:12:53 +0000 | [diff] [blame] | 620 | sqlite3_result_value(context, argv[0]); |
drh | 8912d10 | 2002-05-26 21:34:58 +0000 | [diff] [blame] | 621 | } |
drh | 0ac6589 | 2002-04-20 14:24:41 +0000 | [diff] [blame] | 622 | } |
| 623 | |
drh | 647cb0e | 2002-11-04 19:32:25 +0000 | [diff] [blame] | 624 | /* |
| 625 | ** Implementation of the VERSION(*) function. The result is the version |
| 626 | ** of the SQLite library that is running. |
| 627 | */ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 628 | static void versionFunc( |
| 629 | sqlite3_context *context, |
| 630 | int argc, |
| 631 | sqlite3_value **argv |
| 632 | ){ |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 633 | sqlite3_result_text(context, sqlite3_version, -1, SQLITE_STATIC); |
drh | 647cb0e | 2002-11-04 19:32:25 +0000 | [diff] [blame] | 634 | } |
| 635 | |
drh | 137c728 | 2007-01-29 17:58:28 +0000 | [diff] [blame] | 636 | /* Array for converting from half-bytes (nybbles) into ASCII hex |
| 637 | ** digits. */ |
| 638 | static const char hexdigits[] = { |
| 639 | '0', '1', '2', '3', '4', '5', '6', '7', |
| 640 | '8', '9', 'A', 'B', 'C', 'D', 'E', 'F' |
| 641 | }; |
danielk1977 | d641d64 | 2004-11-18 15:44:29 +0000 | [diff] [blame] | 642 | |
drh | 4739470 | 2003-08-20 01:03:33 +0000 | [diff] [blame] | 643 | /* |
| 644 | ** EXPERIMENTAL - This is not an official function. The interface may |
| 645 | ** change. This function may disappear. Do not write code that depends |
| 646 | ** on this function. |
| 647 | ** |
| 648 | ** Implementation of the QUOTE() function. This function takes a single |
| 649 | ** argument. If the argument is numeric, the return value is the same as |
| 650 | ** the argument. If the argument is NULL, the return value is the string |
| 651 | ** "NULL". Otherwise, the argument is enclosed in single quotes with |
| 652 | ** single-quote escapes. |
| 653 | */ |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 654 | static void quoteFunc(sqlite3_context *context, int argc, sqlite3_value **argv){ |
drh | 4739470 | 2003-08-20 01:03:33 +0000 | [diff] [blame] | 655 | if( argc<1 ) return; |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 656 | switch( sqlite3_value_type(argv[0]) ){ |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 657 | case SQLITE_NULL: { |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 658 | sqlite3_result_text(context, "NULL", 4, SQLITE_STATIC); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 659 | break; |
drh | 4739470 | 2003-08-20 01:03:33 +0000 | [diff] [blame] | 660 | } |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 661 | case SQLITE_INTEGER: |
| 662 | case SQLITE_FLOAT: { |
drh | f447950 | 2004-05-27 03:12:53 +0000 | [diff] [blame] | 663 | sqlite3_result_value(context, argv[0]); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 664 | break; |
| 665 | } |
danielk1977 | 3f41e97 | 2004-06-08 00:39:01 +0000 | [diff] [blame] | 666 | case SQLITE_BLOB: { |
danielk1977 | 3f41e97 | 2004-06-08 00:39:01 +0000 | [diff] [blame] | 667 | char *zText = 0; |
danielk1977 | 3f41e97 | 2004-06-08 00:39:01 +0000 | [diff] [blame] | 668 | char const *zBlob = sqlite3_value_blob(argv[0]); |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 669 | int nBlob = sqlite3_value_bytes(argv[0]); |
| 670 | assert( zBlob==sqlite3_value_blob(argv[0]) ); /* No encoding change */ |
danielk1977 | 3f41e97 | 2004-06-08 00:39:01 +0000 | [diff] [blame] | 671 | |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 672 | if( 2*nBlob+4>SQLITE_MAX_LENGTH ){ |
drh | a0206bc | 2007-05-08 15:15:02 +0000 | [diff] [blame] | 673 | sqlite3_result_error_toobig(context); |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 674 | return; |
| 675 | } |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 676 | zText = (char *)contextMalloc(context, (2*nBlob)+4); |
| 677 | if( zText ){ |
danielk1977 | 3f41e97 | 2004-06-08 00:39:01 +0000 | [diff] [blame] | 678 | int i; |
| 679 | for(i=0; i<nBlob; i++){ |
| 680 | zText[(i*2)+2] = hexdigits[(zBlob[i]>>4)&0x0F]; |
| 681 | zText[(i*2)+3] = hexdigits[(zBlob[i])&0x0F]; |
| 682 | } |
| 683 | zText[(nBlob*2)+2] = '\''; |
| 684 | zText[(nBlob*2)+3] = '\0'; |
| 685 | zText[0] = 'X'; |
| 686 | zText[1] = '\''; |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 687 | sqlite3_result_text(context, zText, -1, SQLITE_TRANSIENT); |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 688 | sqlite3_free(zText); |
danielk1977 | 3f41e97 | 2004-06-08 00:39:01 +0000 | [diff] [blame] | 689 | } |
| 690 | break; |
| 691 | } |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 692 | case SQLITE_TEXT: { |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 693 | int i,j; |
| 694 | u64 n; |
drh | 2646da7 | 2005-12-09 20:02:05 +0000 | [diff] [blame] | 695 | const unsigned char *zArg = sqlite3_value_text(argv[0]); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 696 | char *z; |
| 697 | |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 698 | if( zArg==0 ) return; |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 699 | for(i=0, n=0; zArg[i]; i++){ if( zArg[i]=='\'' ) n++; } |
| 700 | if( i+n+3>SQLITE_MAX_LENGTH ){ |
drh | a0206bc | 2007-05-08 15:15:02 +0000 | [diff] [blame] | 701 | sqlite3_result_error_toobig(context); |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 702 | return; |
| 703 | } |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 704 | z = contextMalloc(context, i+n+3); |
| 705 | if( z ){ |
| 706 | z[0] = '\''; |
| 707 | for(i=0, j=1; zArg[i]; i++){ |
| 708 | z[j++] = zArg[i]; |
| 709 | if( zArg[i]=='\'' ){ |
| 710 | z[j++] = '\''; |
| 711 | } |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 712 | } |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 713 | z[j++] = '\''; |
| 714 | z[j] = 0; |
| 715 | sqlite3_result_text(context, z, j, sqlite3_free); |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 716 | } |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 717 | } |
drh | 4739470 | 2003-08-20 01:03:33 +0000 | [diff] [blame] | 718 | } |
| 719 | } |
| 720 | |
drh | 137c728 | 2007-01-29 17:58:28 +0000 | [diff] [blame] | 721 | /* |
| 722 | ** The hex() function. Interpret the argument as a blob. Return |
| 723 | ** a hexadecimal rendering as text. |
| 724 | */ |
| 725 | static void hexFunc( |
| 726 | sqlite3_context *context, |
| 727 | int argc, |
| 728 | sqlite3_value **argv |
| 729 | ){ |
| 730 | int i, n; |
| 731 | const unsigned char *pBlob; |
| 732 | char *zHex, *z; |
| 733 | assert( argc==1 ); |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 734 | pBlob = sqlite3_value_blob(argv[0]); |
drh | 137c728 | 2007-01-29 17:58:28 +0000 | [diff] [blame] | 735 | n = sqlite3_value_bytes(argv[0]); |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 736 | if( n*2+1>SQLITE_MAX_LENGTH ){ |
drh | a0206bc | 2007-05-08 15:15:02 +0000 | [diff] [blame] | 737 | sqlite3_result_error_toobig(context); |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 738 | return; |
| 739 | } |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 740 | assert( pBlob==sqlite3_value_blob(argv[0]) ); /* No encoding change */ |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 741 | z = zHex = contextMalloc(context, n*2 + 1); |
| 742 | if( zHex ){ |
| 743 | for(i=0; i<n; i++, pBlob++){ |
| 744 | unsigned char c = *pBlob; |
| 745 | *(z++) = hexdigits[(c>>4)&0xf]; |
| 746 | *(z++) = hexdigits[c&0xf]; |
| 747 | } |
| 748 | *z = 0; |
| 749 | sqlite3_result_text(context, zHex, n*2, sqlite3_free); |
drh | 137c728 | 2007-01-29 17:58:28 +0000 | [diff] [blame] | 750 | } |
drh | 137c728 | 2007-01-29 17:58:28 +0000 | [diff] [blame] | 751 | } |
| 752 | |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 753 | /* |
drh | 8cff382 | 2007-05-02 02:08:28 +0000 | [diff] [blame] | 754 | ** The zeroblob(N) function returns a zero-filled blob of size N bytes. |
| 755 | */ |
| 756 | static void zeroblobFunc( |
| 757 | sqlite3_context *context, |
| 758 | int argc, |
| 759 | sqlite3_value **argv |
| 760 | ){ |
drh | 98640a3 | 2007-06-07 19:08:32 +0000 | [diff] [blame] | 761 | i64 n; |
drh | 8cff382 | 2007-05-02 02:08:28 +0000 | [diff] [blame] | 762 | assert( argc==1 ); |
drh | 98640a3 | 2007-06-07 19:08:32 +0000 | [diff] [blame] | 763 | n = sqlite3_value_int64(argv[0]); |
| 764 | if( n>SQLITE_MAX_LENGTH ){ |
| 765 | sqlite3_result_error_toobig(context); |
| 766 | }else{ |
| 767 | sqlite3_result_zeroblob(context, n); |
| 768 | } |
drh | 8cff382 | 2007-05-02 02:08:28 +0000 | [diff] [blame] | 769 | } |
| 770 | |
| 771 | /* |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 772 | ** The replace() function. Three arguments are all strings: call |
| 773 | ** them A, B, and C. The result is also a string which is derived |
| 774 | ** from A by replacing every occurance of B with C. The match |
| 775 | ** must be exact. Collating sequences are not used. |
| 776 | */ |
| 777 | static void replaceFunc( |
| 778 | sqlite3_context *context, |
| 779 | int argc, |
| 780 | sqlite3_value **argv |
| 781 | ){ |
| 782 | const unsigned char *zStr; /* The input string A */ |
| 783 | const unsigned char *zPattern; /* The pattern string B */ |
| 784 | const unsigned char *zRep; /* The replacement string C */ |
| 785 | unsigned char *zOut; /* The output */ |
| 786 | int nStr; /* Size of zStr */ |
| 787 | int nPattern; /* Size of zPattern */ |
| 788 | int nRep; /* Size of zRep */ |
drh | 2e6400b | 2007-05-08 15:46:18 +0000 | [diff] [blame] | 789 | i64 nOut; /* Maximum size of zOut */ |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 790 | int loopLimit; /* Last zStr[] that might match zPattern[] */ |
| 791 | int i, j; /* Loop counters */ |
| 792 | |
| 793 | assert( argc==3 ); |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 794 | zStr = sqlite3_value_text(argv[0]); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 795 | if( zStr==0 ) return; |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 796 | nStr = sqlite3_value_bytes(argv[0]); |
| 797 | assert( zStr==sqlite3_value_text(argv[0]) ); /* No encoding change */ |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 798 | zPattern = sqlite3_value_text(argv[1]); |
drh | 709cff3 | 2007-04-27 01:18:02 +0000 | [diff] [blame] | 799 | if( zPattern==0 || zPattern[0]==0 ) return; |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 800 | nPattern = sqlite3_value_bytes(argv[1]); |
| 801 | assert( zPattern==sqlite3_value_text(argv[1]) ); /* No encoding change */ |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 802 | zRep = sqlite3_value_text(argv[2]); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 803 | if( zRep==0 ) return; |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 804 | nRep = sqlite3_value_bytes(argv[2]); |
| 805 | assert( zRep==sqlite3_value_text(argv[2]) ); |
drh | 2e6400b | 2007-05-08 15:46:18 +0000 | [diff] [blame] | 806 | nOut = nStr + 1; |
| 807 | assert( nOut<SQLITE_MAX_LENGTH ); |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 808 | zOut = contextMalloc(context, (int)nOut); |
drh | 2e6400b | 2007-05-08 15:46:18 +0000 | [diff] [blame] | 809 | if( zOut==0 ){ |
| 810 | return; |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 811 | } |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 812 | loopLimit = nStr - nPattern; |
| 813 | for(i=j=0; i<=loopLimit; i++){ |
| 814 | if( zStr[i]!=zPattern[0] || memcmp(&zStr[i], zPattern, nPattern) ){ |
| 815 | zOut[j++] = zStr[i]; |
| 816 | }else{ |
drh | 4a50aac | 2007-08-23 02:47:53 +0000 | [diff] [blame] | 817 | u8 *zOld; |
drh | 2e6400b | 2007-05-08 15:46:18 +0000 | [diff] [blame] | 818 | nOut += nRep - nPattern; |
| 819 | if( nOut>=SQLITE_MAX_LENGTH ){ |
drh | a0206bc | 2007-05-08 15:15:02 +0000 | [diff] [blame] | 820 | sqlite3_result_error_toobig(context); |
danielk1977 | 17374e8 | 2007-05-08 14:39:04 +0000 | [diff] [blame] | 821 | sqlite3_free(zOut); |
| 822 | return; |
| 823 | } |
drh | 4a50aac | 2007-08-23 02:47:53 +0000 | [diff] [blame] | 824 | zOld = zOut; |
drh | 2e6400b | 2007-05-08 15:46:18 +0000 | [diff] [blame] | 825 | zOut = sqlite3_realloc(zOut, (int)nOut); |
| 826 | if( zOut==0 ){ |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 827 | sqlite3_result_error_nomem(context); |
drh | 4a50aac | 2007-08-23 02:47:53 +0000 | [diff] [blame] | 828 | sqlite3_free(zOld); |
drh | 2e6400b | 2007-05-08 15:46:18 +0000 | [diff] [blame] | 829 | return; |
| 830 | } |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 831 | memcpy(&zOut[j], zRep, nRep); |
| 832 | j += nRep; |
| 833 | i += nPattern-1; |
| 834 | } |
| 835 | } |
drh | 2e6400b | 2007-05-08 15:46:18 +0000 | [diff] [blame] | 836 | assert( j+nStr-i+1==nOut ); |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 837 | memcpy(&zOut[j], &zStr[i], nStr-i); |
| 838 | j += nStr - i; |
| 839 | assert( j<=nOut ); |
| 840 | zOut[j] = 0; |
| 841 | sqlite3_result_text(context, (char*)zOut, j, sqlite3_free); |
| 842 | } |
| 843 | |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 844 | /* |
| 845 | ** Implementation of the TRIM(), LTRIM(), and RTRIM() functions. |
| 846 | ** The userdata is 0x1 for left trim, 0x2 for right trim, 0x3 for both. |
| 847 | */ |
| 848 | static void trimFunc( |
| 849 | sqlite3_context *context, |
| 850 | int argc, |
| 851 | sqlite3_value **argv |
| 852 | ){ |
| 853 | const unsigned char *zIn; /* Input string */ |
| 854 | const unsigned char *zCharSet; /* Set of characters to trim */ |
| 855 | int nIn; /* Number of bytes in input */ |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 856 | int flags; /* 1: trimleft 2: trimright 3: trim */ |
| 857 | int i; /* Loop counter */ |
| 858 | unsigned char *aLen; /* Length of each character in zCharSet */ |
| 859 | const unsigned char **azChar; /* Individual characters in zCharSet */ |
| 860 | int nChar; /* Number of characters in zCharSet */ |
| 861 | |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 862 | if( sqlite3_value_type(argv[0])==SQLITE_NULL ){ |
| 863 | return; |
| 864 | } |
| 865 | zIn = sqlite3_value_text(argv[0]); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 866 | if( zIn==0 ) return; |
drh | 1f0feef | 2007-05-15 13:27:07 +0000 | [diff] [blame] | 867 | nIn = sqlite3_value_bytes(argv[0]); |
| 868 | assert( zIn==sqlite3_value_text(argv[0]) ); |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 869 | if( argc==1 ){ |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 870 | static const unsigned char lenOne[] = { 1 }; |
drh | 8cff382 | 2007-05-02 02:08:28 +0000 | [diff] [blame] | 871 | static const unsigned char *azOne[] = { (u8*)" " }; |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 872 | nChar = 1; |
drh | 8cff382 | 2007-05-02 02:08:28 +0000 | [diff] [blame] | 873 | aLen = (u8*)lenOne; |
| 874 | azChar = azOne; |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 875 | zCharSet = 0; |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 876 | }else if( (zCharSet = sqlite3_value_text(argv[1]))==0 ){ |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 877 | return; |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 878 | }else{ |
| 879 | const unsigned char *z; |
| 880 | for(z=zCharSet, nChar=0; *z; nChar++){ |
drh | 4a91911 | 2007-05-15 11:55:09 +0000 | [diff] [blame] | 881 | SQLITE_SKIP_UTF8(z); |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 882 | } |
| 883 | if( nChar>0 ){ |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 884 | azChar = contextMalloc(context, nChar*(sizeof(char*)+1)); |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 885 | if( azChar==0 ){ |
| 886 | return; |
| 887 | } |
| 888 | aLen = (unsigned char*)&azChar[nChar]; |
| 889 | for(z=zCharSet, nChar=0; *z; nChar++){ |
| 890 | azChar[nChar] = z; |
drh | 4a91911 | 2007-05-15 11:55:09 +0000 | [diff] [blame] | 891 | SQLITE_SKIP_UTF8(z); |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 892 | aLen[nChar] = z - azChar[nChar]; |
| 893 | } |
| 894 | } |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 895 | } |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 896 | if( nChar>0 ){ |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 897 | flags = (int)sqlite3_user_data(context); |
| 898 | if( flags & 1 ){ |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 899 | while( nIn>0 ){ |
| 900 | int len; |
| 901 | for(i=0; i<nChar; i++){ |
| 902 | len = aLen[i]; |
| 903 | if( memcmp(zIn, azChar[i], len)==0 ) break; |
| 904 | } |
| 905 | if( i>=nChar ) break; |
| 906 | zIn += len; |
| 907 | nIn -= len; |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 908 | } |
| 909 | } |
| 910 | if( flags & 2 ){ |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 911 | while( nIn>0 ){ |
| 912 | int len; |
| 913 | for(i=0; i<nChar; i++){ |
| 914 | len = aLen[i]; |
| 915 | if( len<=nIn && memcmp(&zIn[nIn-len],azChar[i],len)==0 ) break; |
| 916 | } |
| 917 | if( i>=nChar ) break; |
| 918 | nIn -= len; |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 919 | } |
| 920 | } |
drh | d1e3a61 | 2007-04-27 21:59:52 +0000 | [diff] [blame] | 921 | if( zCharSet ){ |
| 922 | sqlite3_free(azChar); |
| 923 | } |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 924 | } |
| 925 | sqlite3_result_text(context, (char*)zIn, nIn, SQLITE_TRANSIENT); |
| 926 | } |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 927 | |
drh | d24cc42 | 2003-03-27 12:51:24 +0000 | [diff] [blame] | 928 | #ifdef SQLITE_SOUNDEX |
| 929 | /* |
| 930 | ** Compute the soundex encoding of a word. |
| 931 | */ |
drh | 137c728 | 2007-01-29 17:58:28 +0000 | [diff] [blame] | 932 | static void soundexFunc( |
| 933 | sqlite3_context *context, |
| 934 | int argc, |
| 935 | sqlite3_value **argv |
| 936 | ){ |
drh | d24cc42 | 2003-03-27 12:51:24 +0000 | [diff] [blame] | 937 | char zResult[8]; |
drh | 4c755c0 | 2004-08-08 20:22:17 +0000 | [diff] [blame] | 938 | const u8 *zIn; |
drh | d24cc42 | 2003-03-27 12:51:24 +0000 | [diff] [blame] | 939 | int i, j; |
| 940 | static const unsigned char iCode[] = { |
| 941 | 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, |
| 942 | 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, |
| 943 | 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, |
| 944 | 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, |
| 945 | 0, 0, 1, 2, 3, 0, 1, 2, 0, 0, 2, 2, 4, 5, 5, 0, |
| 946 | 1, 2, 6, 2, 3, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, |
| 947 | 0, 0, 1, 2, 3, 0, 1, 2, 0, 0, 2, 2, 4, 5, 5, 0, |
| 948 | 1, 2, 6, 2, 3, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, |
| 949 | }; |
| 950 | assert( argc==1 ); |
drh | 4c755c0 | 2004-08-08 20:22:17 +0000 | [diff] [blame] | 951 | zIn = (u8*)sqlite3_value_text(argv[0]); |
drh | bdf67e0 | 2006-08-19 11:34:01 +0000 | [diff] [blame] | 952 | if( zIn==0 ) zIn = (u8*)""; |
drh | d24cc42 | 2003-03-27 12:51:24 +0000 | [diff] [blame] | 953 | for(i=0; zIn[i] && !isalpha(zIn[i]); i++){} |
| 954 | if( zIn[i] ){ |
drh | bdf67e0 | 2006-08-19 11:34:01 +0000 | [diff] [blame] | 955 | u8 prevcode = iCode[zIn[i]&0x7f]; |
drh | d24cc42 | 2003-03-27 12:51:24 +0000 | [diff] [blame] | 956 | zResult[0] = toupper(zIn[i]); |
| 957 | for(j=1; j<4 && zIn[i]; i++){ |
| 958 | int code = iCode[zIn[i]&0x7f]; |
| 959 | if( code>0 ){ |
drh | bdf67e0 | 2006-08-19 11:34:01 +0000 | [diff] [blame] | 960 | if( code!=prevcode ){ |
| 961 | prevcode = code; |
| 962 | zResult[j++] = code + '0'; |
| 963 | } |
| 964 | }else{ |
| 965 | prevcode = 0; |
drh | d24cc42 | 2003-03-27 12:51:24 +0000 | [diff] [blame] | 966 | } |
| 967 | } |
| 968 | while( j<4 ){ |
| 969 | zResult[j++] = '0'; |
| 970 | } |
| 971 | zResult[j] = 0; |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 972 | sqlite3_result_text(context, zResult, 4, SQLITE_TRANSIENT); |
drh | d24cc42 | 2003-03-27 12:51:24 +0000 | [diff] [blame] | 973 | }else{ |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 974 | sqlite3_result_text(context, "?000", 4, SQLITE_STATIC); |
drh | d24cc42 | 2003-03-27 12:51:24 +0000 | [diff] [blame] | 975 | } |
| 976 | } |
| 977 | #endif |
| 978 | |
drh | fdb83b2 | 2006-06-17 14:12:47 +0000 | [diff] [blame] | 979 | #ifndef SQLITE_OMIT_LOAD_EXTENSION |
| 980 | /* |
| 981 | ** A function that loads a shared-library extension then returns NULL. |
| 982 | */ |
| 983 | static void loadExt(sqlite3_context *context, int argc, sqlite3_value **argv){ |
danielk1977 | 65fd59f | 2006-06-24 11:51:33 +0000 | [diff] [blame] | 984 | const char *zFile = (const char *)sqlite3_value_text(argv[0]); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 985 | const char *zProc; |
drh | fdb83b2 | 2006-06-17 14:12:47 +0000 | [diff] [blame] | 986 | sqlite3 *db = sqlite3_user_data(context); |
| 987 | char *zErrMsg = 0; |
| 988 | |
| 989 | if( argc==2 ){ |
danielk1977 | 65fd59f | 2006-06-24 11:51:33 +0000 | [diff] [blame] | 990 | zProc = (const char *)sqlite3_value_text(argv[1]); |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 991 | }else{ |
| 992 | zProc = 0; |
drh | fdb83b2 | 2006-06-17 14:12:47 +0000 | [diff] [blame] | 993 | } |
drh | 7a521cf | 2007-04-25 18:23:52 +0000 | [diff] [blame] | 994 | if( zFile && sqlite3_load_extension(db, zFile, zProc, &zErrMsg) ){ |
drh | fdb83b2 | 2006-06-17 14:12:47 +0000 | [diff] [blame] | 995 | sqlite3_result_error(context, zErrMsg, -1); |
| 996 | sqlite3_free(zErrMsg); |
| 997 | } |
| 998 | } |
| 999 | #endif |
| 1000 | |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1001 | #ifdef SQLITE_TEST |
| 1002 | /* |
| 1003 | ** This function generates a string of random characters. Used for |
| 1004 | ** generating test data. |
| 1005 | */ |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 1006 | static void randStr(sqlite3_context *context, int argc, sqlite3_value **argv){ |
drh | bbd82df | 2004-02-11 09:46:30 +0000 | [diff] [blame] | 1007 | static const unsigned char zSrc[] = |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1008 | "abcdefghijklmnopqrstuvwxyz" |
| 1009 | "ABCDEFGHIJKLMNOPQRSTUVWXYZ" |
| 1010 | "0123456789" |
| 1011 | ".-!,:*^+=_|?/<> "; |
| 1012 | int iMin, iMax, n, r, i; |
drh | bbd82df | 2004-02-11 09:46:30 +0000 | [diff] [blame] | 1013 | unsigned char zBuf[1000]; |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1014 | if( argc>=1 ){ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 1015 | iMin = sqlite3_value_int(argv[0]); |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1016 | if( iMin<0 ) iMin = 0; |
| 1017 | if( iMin>=sizeof(zBuf) ) iMin = sizeof(zBuf)-1; |
| 1018 | }else{ |
| 1019 | iMin = 1; |
| 1020 | } |
| 1021 | if( argc>=2 ){ |
drh | f9b596e | 2004-05-26 16:54:42 +0000 | [diff] [blame] | 1022 | iMax = sqlite3_value_int(argv[1]); |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1023 | if( iMax<iMin ) iMax = iMin; |
drh | 1dba727 | 2004-01-16 13:58:18 +0000 | [diff] [blame] | 1024 | if( iMax>=sizeof(zBuf) ) iMax = sizeof(zBuf)-1; |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1025 | }else{ |
| 1026 | iMax = 50; |
| 1027 | } |
| 1028 | n = iMin; |
| 1029 | if( iMax>iMin ){ |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 1030 | sqlite3Randomness(sizeof(r), &r); |
drh | bbd82df | 2004-02-11 09:46:30 +0000 | [diff] [blame] | 1031 | r &= 0x7fffffff; |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1032 | n += r%(iMax + 1 - iMin); |
| 1033 | } |
drh | 1dba727 | 2004-01-16 13:58:18 +0000 | [diff] [blame] | 1034 | assert( n<sizeof(zBuf) ); |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 1035 | sqlite3Randomness(n, zBuf); |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1036 | for(i=0; i<n; i++){ |
drh | bbd82df | 2004-02-11 09:46:30 +0000 | [diff] [blame] | 1037 | zBuf[i] = zSrc[zBuf[i]%(sizeof(zSrc)-1)]; |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1038 | } |
| 1039 | zBuf[n] = 0; |
drh | 2646da7 | 2005-12-09 20:02:05 +0000 | [diff] [blame] | 1040 | sqlite3_result_text(context, (char*)zBuf, n, SQLITE_TRANSIENT); |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1041 | } |
drh | 0e3d747 | 2004-06-19 17:33:07 +0000 | [diff] [blame] | 1042 | #endif /* SQLITE_TEST */ |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1043 | |
drh | 0e3d747 | 2004-06-19 17:33:07 +0000 | [diff] [blame] | 1044 | #ifdef SQLITE_TEST |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1045 | /* |
| 1046 | ** The following two SQL functions are used to test returning a text |
| 1047 | ** result with a destructor. Function 'test_destructor' takes one argument |
| 1048 | ** and returns the same argument interpreted as TEXT. A destructor is |
| 1049 | ** passed with the sqlite3_result_text() call. |
| 1050 | ** |
| 1051 | ** SQL function 'test_destructor_count' returns the number of outstanding |
| 1052 | ** allocations made by 'test_destructor'; |
| 1053 | ** |
| 1054 | ** WARNING: Not threadsafe. |
| 1055 | */ |
| 1056 | static int test_destructor_count_var = 0; |
| 1057 | static void destructor(void *p){ |
| 1058 | char *zVal = (char *)p; |
| 1059 | assert(zVal); |
| 1060 | zVal--; |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1061 | sqlite3_free(zVal); |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1062 | test_destructor_count_var--; |
| 1063 | } |
| 1064 | static void test_destructor( |
| 1065 | sqlite3_context *pCtx, |
| 1066 | int nArg, |
| 1067 | sqlite3_value **argv |
| 1068 | ){ |
| 1069 | char *zVal; |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1070 | int len; |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 1071 | sqlite3 *db = sqlite3_user_data(pCtx); |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1072 | |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1073 | test_destructor_count_var++; |
| 1074 | assert( nArg==1 ); |
| 1075 | if( sqlite3_value_type(argv[0])==SQLITE_NULL ) return; |
drh | b21c8cd | 2007-08-21 19:33:56 +0000 | [diff] [blame] | 1076 | len = sqlite3ValueBytes(argv[0], ENC(db)); |
danielk1977 | c6cc77d | 2007-08-16 10:36:33 +0000 | [diff] [blame] | 1077 | zVal = sqlite3MallocZero(len+3); |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1078 | zVal[len] = 0; |
| 1079 | zVal[len-1] = 0; |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1080 | assert( zVal ); |
| 1081 | zVal++; |
drh | b21c8cd | 2007-08-21 19:33:56 +0000 | [diff] [blame] | 1082 | memcpy(zVal, sqlite3ValueText(argv[0], ENC(db)), len); |
danielk1977 | 14db266 | 2006-01-09 16:12:04 +0000 | [diff] [blame] | 1083 | if( ENC(db)==SQLITE_UTF8 ){ |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1084 | sqlite3_result_text(pCtx, zVal, -1, destructor); |
drh | 6c62608 | 2004-11-14 21:56:29 +0000 | [diff] [blame] | 1085 | #ifndef SQLITE_OMIT_UTF16 |
danielk1977 | 14db266 | 2006-01-09 16:12:04 +0000 | [diff] [blame] | 1086 | }else if( ENC(db)==SQLITE_UTF16LE ){ |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1087 | sqlite3_result_text16le(pCtx, zVal, -1, destructor); |
| 1088 | }else{ |
| 1089 | sqlite3_result_text16be(pCtx, zVal, -1, destructor); |
drh | 6c62608 | 2004-11-14 21:56:29 +0000 | [diff] [blame] | 1090 | #endif /* SQLITE_OMIT_UTF16 */ |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1091 | } |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1092 | } |
| 1093 | static void test_destructor_count( |
| 1094 | sqlite3_context *pCtx, |
| 1095 | int nArg, |
| 1096 | sqlite3_value **argv |
| 1097 | ){ |
| 1098 | sqlite3_result_int(pCtx, test_destructor_count_var); |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1099 | } |
drh | 0e3d747 | 2004-06-19 17:33:07 +0000 | [diff] [blame] | 1100 | #endif /* SQLITE_TEST */ |
danielk1977 | 3f6b087 | 2004-06-17 05:36:44 +0000 | [diff] [blame] | 1101 | |
drh | 0e3d747 | 2004-06-19 17:33:07 +0000 | [diff] [blame] | 1102 | #ifdef SQLITE_TEST |
| 1103 | /* |
| 1104 | ** Routines for testing the sqlite3_get_auxdata() and sqlite3_set_auxdata() |
| 1105 | ** interface. |
| 1106 | ** |
| 1107 | ** The test_auxdata() SQL function attempts to register each of its arguments |
| 1108 | ** as auxiliary data. If there are no prior registrations of aux data for |
| 1109 | ** that argument (meaning the argument is not a constant or this is its first |
| 1110 | ** call) then the result for that argument is 0. If there is a prior |
| 1111 | ** registration, the result for that argument is 1. The overall result |
| 1112 | ** is the individual argument results separated by spaces. |
| 1113 | */ |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1114 | static void free_test_auxdata(void *p) {sqlite3_free(p);} |
danielk1977 | 3f6b087 | 2004-06-17 05:36:44 +0000 | [diff] [blame] | 1115 | static void test_auxdata( |
| 1116 | sqlite3_context *pCtx, |
| 1117 | int nArg, |
| 1118 | sqlite3_value **argv |
| 1119 | ){ |
| 1120 | int i; |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 1121 | char *zRet = contextMalloc(pCtx, nArg*2); |
danielk1977 | 3f6b087 | 2004-06-17 05:36:44 +0000 | [diff] [blame] | 1122 | if( !zRet ) return; |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 1123 | memset(zRet, 0, nArg*2); |
danielk1977 | 3f6b087 | 2004-06-17 05:36:44 +0000 | [diff] [blame] | 1124 | for(i=0; i<nArg; i++){ |
drh | 2646da7 | 2005-12-09 20:02:05 +0000 | [diff] [blame] | 1125 | char const *z = (char*)sqlite3_value_text(argv[i]); |
danielk1977 | 3f6b087 | 2004-06-17 05:36:44 +0000 | [diff] [blame] | 1126 | if( z ){ |
| 1127 | char *zAux = sqlite3_get_auxdata(pCtx, i); |
| 1128 | if( zAux ){ |
| 1129 | zRet[i*2] = '1'; |
| 1130 | if( strcmp(zAux, z) ){ |
danielk1977 | e0fc526 | 2007-07-26 06:50:05 +0000 | [diff] [blame] | 1131 | free_test_auxdata((void *)zRet); |
danielk1977 | 3f6b087 | 2004-06-17 05:36:44 +0000 | [diff] [blame] | 1132 | sqlite3_result_error(pCtx, "Auxilary data corruption", -1); |
| 1133 | return; |
| 1134 | } |
| 1135 | }else{ |
| 1136 | zRet[i*2] = '0'; |
danielk1977 | a1644fd | 2007-08-29 12:31:25 +0000 | [diff] [blame] | 1137 | zAux = contextMalloc(pCtx, strlen(z)+1); |
| 1138 | if( zAux ){ |
| 1139 | strcpy(zAux, z); |
| 1140 | sqlite3_set_auxdata(pCtx, i, zAux, free_test_auxdata); |
| 1141 | } |
danielk1977 | 3f6b087 | 2004-06-17 05:36:44 +0000 | [diff] [blame] | 1142 | } |
| 1143 | zRet[i*2+1] = ' '; |
| 1144 | } |
| 1145 | } |
| 1146 | sqlite3_result_text(pCtx, zRet, 2*nArg-1, free_test_auxdata); |
| 1147 | } |
drh | 0e3d747 | 2004-06-19 17:33:07 +0000 | [diff] [blame] | 1148 | #endif /* SQLITE_TEST */ |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1149 | |
danielk1977 | 01427a6 | 2005-01-11 13:02:33 +0000 | [diff] [blame] | 1150 | #ifdef SQLITE_TEST |
| 1151 | /* |
| 1152 | ** A function to test error reporting from user functions. This function |
| 1153 | ** returns a copy of it's first argument as an error. |
| 1154 | */ |
| 1155 | static void test_error( |
| 1156 | sqlite3_context *pCtx, |
| 1157 | int nArg, |
| 1158 | sqlite3_value **argv |
| 1159 | ){ |
drh | 2646da7 | 2005-12-09 20:02:05 +0000 | [diff] [blame] | 1160 | sqlite3_result_error(pCtx, (char*)sqlite3_value_text(argv[0]), 0); |
danielk1977 | 01427a6 | 2005-01-11 13:02:33 +0000 | [diff] [blame] | 1161 | } |
| 1162 | #endif /* SQLITE_TEST */ |
| 1163 | |
drh | 0ac6589 | 2002-04-20 14:24:41 +0000 | [diff] [blame] | 1164 | /* |
drh | d3a149e | 2002-02-24 17:12:53 +0000 | [diff] [blame] | 1165 | ** An instance of the following structure holds the context of a |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1166 | ** sum() or avg() aggregate computation. |
| 1167 | */ |
| 1168 | typedef struct SumCtx SumCtx; |
| 1169 | struct SumCtx { |
drh | 8c08e86 | 2006-02-11 17:34:00 +0000 | [diff] [blame] | 1170 | double rSum; /* Floating point sum */ |
| 1171 | i64 iSum; /* Integer sum */ |
| 1172 | i64 cnt; /* Number of elements summed */ |
| 1173 | u8 overflow; /* True if integer overflow seen */ |
| 1174 | u8 approx; /* True if non-integer value was input to the sum */ |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1175 | }; |
| 1176 | |
| 1177 | /* |
drh | a97fdd3 | 2006-01-12 22:17:50 +0000 | [diff] [blame] | 1178 | ** Routines used to compute the sum, average, and total. |
| 1179 | ** |
| 1180 | ** The SUM() function follows the (broken) SQL standard which means |
| 1181 | ** that it returns NULL if it sums over no inputs. TOTAL returns |
| 1182 | ** 0.0 in that case. In addition, TOTAL always returns a float where |
| 1183 | ** SUM might return an integer if it never encounters a floating point |
drh | c806d85 | 2006-05-11 13:25:39 +0000 | [diff] [blame] | 1184 | ** value. TOTAL never fails, but SUM might through an exception if |
| 1185 | ** it overflows an integer. |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1186 | */ |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 1187 | static void sumStep(sqlite3_context *context, int argc, sqlite3_value **argv){ |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1188 | SumCtx *p; |
drh | 3d1d95e | 2005-09-08 10:37:01 +0000 | [diff] [blame] | 1189 | int type; |
drh | 3f219f4 | 2005-09-08 19:45:57 +0000 | [diff] [blame] | 1190 | assert( argc==1 ); |
drh | 4f26d6c | 2004-05-26 23:25:30 +0000 | [diff] [blame] | 1191 | p = sqlite3_aggregate_context(context, sizeof(*p)); |
drh | 29d7210 | 2006-02-09 22:13:41 +0000 | [diff] [blame] | 1192 | type = sqlite3_value_numeric_type(argv[0]); |
drh | 3d1d95e | 2005-09-08 10:37:01 +0000 | [diff] [blame] | 1193 | if( p && type!=SQLITE_NULL ){ |
drh | 739105c | 2002-05-29 23:22:23 +0000 | [diff] [blame] | 1194 | p->cnt++; |
drh | 29d7210 | 2006-02-09 22:13:41 +0000 | [diff] [blame] | 1195 | if( type==SQLITE_INTEGER ){ |
drh | 8c08e86 | 2006-02-11 17:34:00 +0000 | [diff] [blame] | 1196 | i64 v = sqlite3_value_int64(argv[0]); |
| 1197 | p->rSum += v; |
| 1198 | if( (p->approx|p->overflow)==0 ){ |
| 1199 | i64 iNewSum = p->iSum + v; |
| 1200 | int s1 = p->iSum >> (sizeof(i64)*8-1); |
| 1201 | int s2 = v >> (sizeof(i64)*8-1); |
| 1202 | int s3 = iNewSum >> (sizeof(i64)*8-1); |
| 1203 | p->overflow = (s1&s2&~s3) | (~s1&~s2&s3); |
| 1204 | p->iSum = iNewSum; |
drh | 29d7210 | 2006-02-09 22:13:41 +0000 | [diff] [blame] | 1205 | } |
| 1206 | }else{ |
drh | 8c08e86 | 2006-02-11 17:34:00 +0000 | [diff] [blame] | 1207 | p->rSum += sqlite3_value_double(argv[0]); |
drh | 29d7210 | 2006-02-09 22:13:41 +0000 | [diff] [blame] | 1208 | p->approx = 1; |
drh | 3f219f4 | 2005-09-08 19:45:57 +0000 | [diff] [blame] | 1209 | } |
drh | 739105c | 2002-05-29 23:22:23 +0000 | [diff] [blame] | 1210 | } |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1211 | } |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 1212 | static void sumFinalize(sqlite3_context *context){ |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1213 | SumCtx *p; |
drh | abfcea2 | 2005-09-06 20:36:48 +0000 | [diff] [blame] | 1214 | p = sqlite3_aggregate_context(context, 0); |
drh | c2bd913 | 2005-09-08 20:37:43 +0000 | [diff] [blame] | 1215 | if( p && p->cnt>0 ){ |
drh | 8c08e86 | 2006-02-11 17:34:00 +0000 | [diff] [blame] | 1216 | if( p->overflow ){ |
| 1217 | sqlite3_result_error(context,"integer overflow",-1); |
| 1218 | }else if( p->approx ){ |
| 1219 | sqlite3_result_double(context, p->rSum); |
drh | c2bd913 | 2005-09-08 20:37:43 +0000 | [diff] [blame] | 1220 | }else{ |
drh | 8c08e86 | 2006-02-11 17:34:00 +0000 | [diff] [blame] | 1221 | sqlite3_result_int64(context, p->iSum); |
drh | c2bd913 | 2005-09-08 20:37:43 +0000 | [diff] [blame] | 1222 | } |
drh | 3d1d95e | 2005-09-08 10:37:01 +0000 | [diff] [blame] | 1223 | } |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1224 | } |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 1225 | static void avgFinalize(sqlite3_context *context){ |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1226 | SumCtx *p; |
drh | abfcea2 | 2005-09-06 20:36:48 +0000 | [diff] [blame] | 1227 | p = sqlite3_aggregate_context(context, 0); |
drh | 739105c | 2002-05-29 23:22:23 +0000 | [diff] [blame] | 1228 | if( p && p->cnt>0 ){ |
drh | 8c08e86 | 2006-02-11 17:34:00 +0000 | [diff] [blame] | 1229 | sqlite3_result_double(context, p->rSum/(double)p->cnt); |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1230 | } |
| 1231 | } |
drh | a97fdd3 | 2006-01-12 22:17:50 +0000 | [diff] [blame] | 1232 | static void totalFinalize(sqlite3_context *context){ |
| 1233 | SumCtx *p; |
| 1234 | p = sqlite3_aggregate_context(context, 0); |
drh | 8c08e86 | 2006-02-11 17:34:00 +0000 | [diff] [blame] | 1235 | sqlite3_result_double(context, p ? p->rSum : 0.0); |
drh | a97fdd3 | 2006-01-12 22:17:50 +0000 | [diff] [blame] | 1236 | } |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1237 | |
| 1238 | /* |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1239 | ** The following structure keeps track of state information for the |
| 1240 | ** count() aggregate function. |
| 1241 | */ |
| 1242 | typedef struct CountCtx CountCtx; |
| 1243 | struct CountCtx { |
drh | fc6ad39 | 2006-02-09 13:38:19 +0000 | [diff] [blame] | 1244 | i64 n; |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1245 | }; |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1246 | |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1247 | /* |
| 1248 | ** Routines to implement the count() aggregate function. |
| 1249 | */ |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 1250 | static void countStep(sqlite3_context *context, int argc, sqlite3_value **argv){ |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1251 | CountCtx *p; |
drh | 4f26d6c | 2004-05-26 23:25:30 +0000 | [diff] [blame] | 1252 | p = sqlite3_aggregate_context(context, sizeof(*p)); |
drh | 9c05483 | 2004-05-31 18:51:57 +0000 | [diff] [blame] | 1253 | if( (argc==0 || SQLITE_NULL!=sqlite3_value_type(argv[0])) && p ){ |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1254 | p->n++; |
| 1255 | } |
| 1256 | } |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 1257 | static void countFinalize(sqlite3_context *context){ |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1258 | CountCtx *p; |
drh | abfcea2 | 2005-09-06 20:36:48 +0000 | [diff] [blame] | 1259 | p = sqlite3_aggregate_context(context, 0); |
drh | fc6ad39 | 2006-02-09 13:38:19 +0000 | [diff] [blame] | 1260 | sqlite3_result_int64(context, p ? p->n : 0); |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1261 | } |
| 1262 | |
| 1263 | /* |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1264 | ** Routines to implement min() and max() aggregate functions. |
| 1265 | */ |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 1266 | static void minmaxStep(sqlite3_context *context, int argc, sqlite3_value **argv){ |
danielk1977 | 8820805 | 2004-05-25 01:13:20 +0000 | [diff] [blame] | 1267 | Mem *pArg = (Mem *)argv[0]; |
drh | 9eb516c | 2004-07-18 20:52:32 +0000 | [diff] [blame] | 1268 | Mem *pBest; |
| 1269 | |
| 1270 | if( sqlite3_value_type(argv[0])==SQLITE_NULL ) return; |
| 1271 | pBest = (Mem *)sqlite3_aggregate_context(context, sizeof(*pBest)); |
danielk1977 | 3aeab9e | 2004-06-24 00:20:04 +0000 | [diff] [blame] | 1272 | if( !pBest ) return; |
drh | 268380c | 2004-02-25 13:47:31 +0000 | [diff] [blame] | 1273 | |
danielk1977 | 8820805 | 2004-05-25 01:13:20 +0000 | [diff] [blame] | 1274 | if( pBest->flags ){ |
drh | 9eb516c | 2004-07-18 20:52:32 +0000 | [diff] [blame] | 1275 | int max; |
| 1276 | int cmp; |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 1277 | CollSeq *pColl = sqlite3GetFuncCollSeq(context); |
danielk1977 | 7e18c25 | 2004-05-25 11:47:24 +0000 | [diff] [blame] | 1278 | /* This step function is used for both the min() and max() aggregates, |
| 1279 | ** the only difference between the two being that the sense of the |
| 1280 | ** comparison is inverted. For the max() aggregate, the |
| 1281 | ** sqlite3_user_data() function returns (void *)-1. For min() it |
| 1282 | ** returns (void *)db, where db is the sqlite3* database pointer. |
| 1283 | ** Therefore the next statement sets variable 'max' to 1 for the max() |
| 1284 | ** aggregate, or 0 for min(). |
| 1285 | */ |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 1286 | max = sqlite3_user_data(context)!=0; |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 1287 | cmp = sqlite3MemCompare(pBest, pArg, pColl); |
danielk1977 | 8820805 | 2004-05-25 01:13:20 +0000 | [diff] [blame] | 1288 | if( (max && cmp<0) || (!max && cmp>0) ){ |
drh | b21c8cd | 2007-08-21 19:33:56 +0000 | [diff] [blame] | 1289 | sqlite3VdbeMemCopy(pBest, pArg); |
danielk1977 | 8820805 | 2004-05-25 01:13:20 +0000 | [diff] [blame] | 1290 | } |
drh | 268380c | 2004-02-25 13:47:31 +0000 | [diff] [blame] | 1291 | }else{ |
drh | b21c8cd | 2007-08-21 19:33:56 +0000 | [diff] [blame] | 1292 | sqlite3VdbeMemCopy(pBest, pArg); |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1293 | } |
| 1294 | } |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 1295 | static void minMaxFinalize(sqlite3_context *context){ |
danielk1977 | 8820805 | 2004-05-25 01:13:20 +0000 | [diff] [blame] | 1296 | sqlite3_value *pRes; |
drh | abfcea2 | 2005-09-06 20:36:48 +0000 | [diff] [blame] | 1297 | pRes = (sqlite3_value *)sqlite3_aggregate_context(context, 0); |
| 1298 | if( pRes ){ |
| 1299 | if( pRes->flags ){ |
| 1300 | sqlite3_result_value(context, pRes); |
| 1301 | } |
| 1302 | sqlite3VdbeMemRelease(pRes); |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1303 | } |
| 1304 | } |
drh | dd5baa9 | 2002-02-27 19:50:59 +0000 | [diff] [blame] | 1305 | |
drh | 4e5ffc5 | 2004-08-31 00:52:37 +0000 | [diff] [blame] | 1306 | |
drh | d3a149e | 2002-02-24 17:12:53 +0000 | [diff] [blame] | 1307 | /* |
drh | a2ed560 | 2002-02-26 23:55:31 +0000 | [diff] [blame] | 1308 | ** This function registered all of the above C functions as SQL |
| 1309 | ** functions. This should be the only routine in this file with |
| 1310 | ** external linkage. |
drh | dc04c58 | 2002-02-24 01:55:15 +0000 | [diff] [blame] | 1311 | */ |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 1312 | void sqlite3RegisterBuiltinFunctions(sqlite3 *db){ |
drh | 5719628 | 2004-10-06 15:41:16 +0000 | [diff] [blame] | 1313 | static const struct { |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1314 | char *zName; |
drh | 268380c | 2004-02-25 13:47:31 +0000 | [diff] [blame] | 1315 | signed char nArg; |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 1316 | u8 argType; /* ff: db 1: 0, 2: 1, 3: 2,... N: N-1. */ |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1317 | u8 eTextRep; /* 1: UTF-16. 0: UTF-8 */ |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 1318 | u8 needCollSeq; |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 1319 | void (*xFunc)(sqlite3_context*,int,sqlite3_value **); |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1320 | } aFuncs[] = { |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1321 | { "min", -1, 0, SQLITE_UTF8, 1, minmaxFunc }, |
| 1322 | { "min", 0, 0, SQLITE_UTF8, 1, 0 }, |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 1323 | { "max", -1, 1, SQLITE_UTF8, 1, minmaxFunc }, |
| 1324 | { "max", 0, 1, SQLITE_UTF8, 1, 0 }, |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1325 | { "typeof", 1, 0, SQLITE_UTF8, 0, typeofFunc }, |
| 1326 | { "length", 1, 0, SQLITE_UTF8, 0, lengthFunc }, |
| 1327 | { "substr", 3, 0, SQLITE_UTF8, 0, substrFunc }, |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1328 | { "abs", 1, 0, SQLITE_UTF8, 0, absFunc }, |
| 1329 | { "round", 1, 0, SQLITE_UTF8, 0, roundFunc }, |
| 1330 | { "round", 2, 0, SQLITE_UTF8, 0, roundFunc }, |
| 1331 | { "upper", 1, 0, SQLITE_UTF8, 0, upperFunc }, |
| 1332 | { "lower", 1, 0, SQLITE_UTF8, 0, lowerFunc }, |
| 1333 | { "coalesce", -1, 0, SQLITE_UTF8, 0, ifnullFunc }, |
| 1334 | { "coalesce", 0, 0, SQLITE_UTF8, 0, 0 }, |
| 1335 | { "coalesce", 1, 0, SQLITE_UTF8, 0, 0 }, |
drh | 137c728 | 2007-01-29 17:58:28 +0000 | [diff] [blame] | 1336 | { "hex", 1, 0, SQLITE_UTF8, 0, hexFunc }, |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1337 | { "ifnull", 2, 0, SQLITE_UTF8, 1, ifnullFunc }, |
| 1338 | { "random", -1, 0, SQLITE_UTF8, 0, randomFunc }, |
drh | 137c728 | 2007-01-29 17:58:28 +0000 | [diff] [blame] | 1339 | { "randomblob", 1, 0, SQLITE_UTF8, 0, randomBlob }, |
drh | 94a9836 | 2004-09-13 13:13:18 +0000 | [diff] [blame] | 1340 | { "nullif", 2, 0, SQLITE_UTF8, 1, nullifFunc }, |
danielk1977 | f461889 | 2004-06-28 13:09:11 +0000 | [diff] [blame] | 1341 | { "sqlite_version", 0, 0, SQLITE_UTF8, 0, versionFunc}, |
| 1342 | { "quote", 1, 0, SQLITE_UTF8, 0, quoteFunc }, |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 1343 | { "last_insert_rowid", 0, 0xff, SQLITE_UTF8, 0, last_insert_rowid }, |
| 1344 | { "changes", 0, 0xff, SQLITE_UTF8, 0, changes }, |
| 1345 | { "total_changes", 0, 0xff, SQLITE_UTF8, 0, total_changes }, |
drh | 26b6d90 | 2007-03-17 13:27:54 +0000 | [diff] [blame] | 1346 | { "replace", 3, 0, SQLITE_UTF8, 0, replaceFunc }, |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 1347 | { "ltrim", 1, 1, SQLITE_UTF8, 0, trimFunc }, |
| 1348 | { "ltrim", 2, 1, SQLITE_UTF8, 0, trimFunc }, |
| 1349 | { "rtrim", 1, 2, SQLITE_UTF8, 0, trimFunc }, |
| 1350 | { "rtrim", 2, 2, SQLITE_UTF8, 0, trimFunc }, |
| 1351 | { "trim", 1, 3, SQLITE_UTF8, 0, trimFunc }, |
| 1352 | { "trim", 2, 3, SQLITE_UTF8, 0, trimFunc }, |
drh | 8cff382 | 2007-05-02 02:08:28 +0000 | [diff] [blame] | 1353 | { "zeroblob", 1, 0, SQLITE_UTF8, 0, zeroblobFunc }, |
drh | d24cc42 | 2003-03-27 12:51:24 +0000 | [diff] [blame] | 1354 | #ifdef SQLITE_SOUNDEX |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 1355 | { "soundex", 1, 0, SQLITE_UTF8, 0, soundexFunc}, |
drh | d24cc42 | 2003-03-27 12:51:24 +0000 | [diff] [blame] | 1356 | #endif |
drh | fdb83b2 | 2006-06-17 14:12:47 +0000 | [diff] [blame] | 1357 | #ifndef SQLITE_OMIT_LOAD_EXTENSION |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 1358 | { "load_extension", 1, 0xff, SQLITE_UTF8, 0, loadExt }, |
| 1359 | { "load_extension", 2, 0xff, SQLITE_UTF8, 0, loadExt }, |
drh | fdb83b2 | 2006-06-17 14:12:47 +0000 | [diff] [blame] | 1360 | #endif |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1361 | #ifdef SQLITE_TEST |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 1362 | { "randstr", 2, 0, SQLITE_UTF8, 0, randStr }, |
| 1363 | { "test_destructor", 1, 0xff, SQLITE_UTF8, 0, test_destructor}, |
| 1364 | { "test_destructor_count", 0, 0, SQLITE_UTF8, 0, test_destructor_count}, |
| 1365 | { "test_auxdata", -1, 0, SQLITE_UTF8, 0, test_auxdata}, |
| 1366 | { "test_error", 1, 0, SQLITE_UTF8, 0, test_error}, |
drh | 193a6b4 | 2002-07-07 16:52:46 +0000 | [diff] [blame] | 1367 | #endif |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1368 | }; |
drh | 5719628 | 2004-10-06 15:41:16 +0000 | [diff] [blame] | 1369 | static const struct { |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1370 | char *zName; |
drh | 268380c | 2004-02-25 13:47:31 +0000 | [diff] [blame] | 1371 | signed char nArg; |
drh | 268380c | 2004-02-25 13:47:31 +0000 | [diff] [blame] | 1372 | u8 argType; |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 1373 | u8 needCollSeq; |
danielk1977 | 0ae8b83 | 2004-05-25 12:05:56 +0000 | [diff] [blame] | 1374 | void (*xStep)(sqlite3_context*,int,sqlite3_value**); |
| 1375 | void (*xFinalize)(sqlite3_context*); |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1376 | } aAggs[] = { |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 1377 | { "min", 1, 0, 1, minmaxStep, minMaxFinalize }, |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 1378 | { "max", 1, 1, 1, minmaxStep, minMaxFinalize }, |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 1379 | { "sum", 1, 0, 0, sumStep, sumFinalize }, |
drh | a97fdd3 | 2006-01-12 22:17:50 +0000 | [diff] [blame] | 1380 | { "total", 1, 0, 0, sumStep, totalFinalize }, |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 1381 | { "avg", 1, 0, 0, sumStep, avgFinalize }, |
| 1382 | { "count", 0, 0, 0, countStep, countFinalize }, |
| 1383 | { "count", 1, 0, 0, countStep, countFinalize }, |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1384 | }; |
| 1385 | int i; |
| 1386 | |
| 1387 | for(i=0; i<sizeof(aFuncs)/sizeof(aFuncs[0]); i++){ |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 1388 | void *pArg; |
| 1389 | u8 argType = aFuncs[i].argType; |
| 1390 | if( argType==0xff ){ |
| 1391 | pArg = db; |
| 1392 | }else{ |
| 1393 | pArg = (void*)(int)argType; |
danielk1977 | c572ef7 | 2004-05-27 09:28:41 +0000 | [diff] [blame] | 1394 | } |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 1395 | sqlite3CreateFunc(db, aFuncs[i].zName, aFuncs[i].nArg, |
danielk1977 | f9d64d2 | 2004-06-19 08:18:07 +0000 | [diff] [blame] | 1396 | aFuncs[i].eTextRep, pArg, aFuncs[i].xFunc, 0, 0); |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 1397 | if( aFuncs[i].needCollSeq ){ |
| 1398 | FuncDef *pFunc = sqlite3FindFunction(db, aFuncs[i].zName, |
| 1399 | strlen(aFuncs[i].zName), aFuncs[i].nArg, aFuncs[i].eTextRep, 0); |
| 1400 | if( pFunc && aFuncs[i].needCollSeq ){ |
| 1401 | pFunc->needCollSeq = 1; |
| 1402 | } |
| 1403 | } |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1404 | } |
drh | 1f01ec1 | 2005-02-15 21:36:18 +0000 | [diff] [blame] | 1405 | #ifndef SQLITE_OMIT_ALTERTABLE |
| 1406 | sqlite3AlterFunctions(db); |
| 1407 | #endif |
drh | 198bf39 | 2006-01-06 21:52:49 +0000 | [diff] [blame] | 1408 | #ifndef SQLITE_OMIT_PARSER |
danielk1977 | f744bb5 | 2005-12-06 17:19:11 +0000 | [diff] [blame] | 1409 | sqlite3AttachFunctions(db); |
drh | 198bf39 | 2006-01-06 21:52:49 +0000 | [diff] [blame] | 1410 | #endif |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 1411 | for(i=0; i<sizeof(aAggs)/sizeof(aAggs[0]); i++){ |
drh | 309b338 | 2007-03-17 17:52:42 +0000 | [diff] [blame] | 1412 | void *pArg = (void*)(int)aAggs[i].argType; |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 1413 | sqlite3CreateFunc(db, aAggs[i].zName, aAggs[i].nArg, SQLITE_UTF8, |
danielk1977 | f9d64d2 | 2004-06-19 08:18:07 +0000 | [diff] [blame] | 1414 | pArg, 0, aAggs[i].xStep, aAggs[i].xFinalize); |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 1415 | if( aAggs[i].needCollSeq ){ |
| 1416 | FuncDef *pFunc = sqlite3FindFunction( db, aAggs[i].zName, |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1417 | strlen(aAggs[i].zName), aAggs[i].nArg, SQLITE_UTF8, 0); |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 1418 | if( pFunc && aAggs[i].needCollSeq ){ |
| 1419 | pFunc->needCollSeq = 1; |
| 1420 | } |
| 1421 | } |
drh | 268380c | 2004-02-25 13:47:31 +0000 | [diff] [blame] | 1422 | } |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 1423 | sqlite3RegisterDateTimeFunctions(db); |
danielk1977 | 1e53695 | 2007-08-16 10:09:01 +0000 | [diff] [blame] | 1424 | if( !db->mallocFailed ){ |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 1425 | int rc = sqlite3_overload_function(db, "MATCH", 2); |
| 1426 | assert( rc==SQLITE_NOMEM || rc==SQLITE_OK ); |
| 1427 | if( rc==SQLITE_NOMEM ){ |
danielk1977 | 1e53695 | 2007-08-16 10:09:01 +0000 | [diff] [blame] | 1428 | db->mallocFailed = 1; |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 1429 | } |
| 1430 | } |
danielk1977 | fd9e1f3 | 2005-05-22 10:44:34 +0000 | [diff] [blame] | 1431 | #ifdef SQLITE_SSE |
drh | 3752785 | 2006-03-16 16:19:56 +0000 | [diff] [blame] | 1432 | (void)sqlite3SseFunctions(db); |
danielk1977 | fd9e1f3 | 2005-05-22 10:44:34 +0000 | [diff] [blame] | 1433 | #endif |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 1434 | #ifdef SQLITE_CASE_SENSITIVE_LIKE |
| 1435 | sqlite3RegisterLikeFunctions(db, 1); |
| 1436 | #else |
| 1437 | sqlite3RegisterLikeFunctions(db, 0); |
| 1438 | #endif |
| 1439 | } |
| 1440 | |
| 1441 | /* |
| 1442 | ** Set the LIKEOPT flag on the 2-argument function with the given name. |
| 1443 | */ |
drh | d64fe2f | 2005-08-28 17:00:23 +0000 | [diff] [blame] | 1444 | static void setLikeOptFlag(sqlite3 *db, const char *zName, int flagVal){ |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 1445 | FuncDef *pDef; |
| 1446 | pDef = sqlite3FindFunction(db, zName, strlen(zName), 2, SQLITE_UTF8, 0); |
| 1447 | if( pDef ){ |
drh | d64fe2f | 2005-08-28 17:00:23 +0000 | [diff] [blame] | 1448 | pDef->flags = flagVal; |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 1449 | } |
| 1450 | } |
| 1451 | |
| 1452 | /* |
| 1453 | ** Register the built-in LIKE and GLOB functions. The caseSensitive |
| 1454 | ** parameter determines whether or not the LIKE operator is case |
| 1455 | ** sensitive. GLOB is always case sensitive. |
| 1456 | */ |
| 1457 | void sqlite3RegisterLikeFunctions(sqlite3 *db, int caseSensitive){ |
| 1458 | struct compareInfo *pInfo; |
| 1459 | if( caseSensitive ){ |
| 1460 | pInfo = (struct compareInfo*)&likeInfoAlt; |
| 1461 | }else{ |
| 1462 | pInfo = (struct compareInfo*)&likeInfoNorm; |
| 1463 | } |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 1464 | sqlite3CreateFunc(db, "like", 2, SQLITE_UTF8, pInfo, likeFunc, 0, 0); |
| 1465 | sqlite3CreateFunc(db, "like", 3, SQLITE_UTF8, pInfo, likeFunc, 0, 0); |
| 1466 | sqlite3CreateFunc(db, "glob", 2, SQLITE_UTF8, |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 1467 | (struct compareInfo*)&globInfo, likeFunc, 0,0); |
drh | d64fe2f | 2005-08-28 17:00:23 +0000 | [diff] [blame] | 1468 | setLikeOptFlag(db, "glob", SQLITE_FUNC_LIKE | SQLITE_FUNC_CASE); |
| 1469 | setLikeOptFlag(db, "like", |
| 1470 | caseSensitive ? (SQLITE_FUNC_LIKE | SQLITE_FUNC_CASE) : SQLITE_FUNC_LIKE); |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 1471 | } |
| 1472 | |
| 1473 | /* |
| 1474 | ** pExpr points to an expression which implements a function. If |
| 1475 | ** it is appropriate to apply the LIKE optimization to that function |
| 1476 | ** then set aWc[0] through aWc[2] to the wildcard characters and |
| 1477 | ** return TRUE. If the function is not a LIKE-style function then |
| 1478 | ** return FALSE. |
| 1479 | */ |
drh | d64fe2f | 2005-08-28 17:00:23 +0000 | [diff] [blame] | 1480 | int sqlite3IsLikeFunction(sqlite3 *db, Expr *pExpr, int *pIsNocase, char *aWc){ |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 1481 | FuncDef *pDef; |
danielk1977 | cdbd8ef | 2007-05-12 06:11:12 +0000 | [diff] [blame] | 1482 | if( pExpr->op!=TK_FUNCTION || !pExpr->pList ){ |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 1483 | return 0; |
| 1484 | } |
| 1485 | if( pExpr->pList->nExpr!=2 ){ |
| 1486 | return 0; |
| 1487 | } |
drh | 2646da7 | 2005-12-09 20:02:05 +0000 | [diff] [blame] | 1488 | pDef = sqlite3FindFunction(db, (char*)pExpr->token.z, pExpr->token.n, 2, |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 1489 | SQLITE_UTF8, 0); |
drh | d64fe2f | 2005-08-28 17:00:23 +0000 | [diff] [blame] | 1490 | if( pDef==0 || (pDef->flags & SQLITE_FUNC_LIKE)==0 ){ |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 1491 | return 0; |
| 1492 | } |
| 1493 | |
| 1494 | /* The memcpy() statement assumes that the wildcard characters are |
| 1495 | ** the first three statements in the compareInfo structure. The |
| 1496 | ** asserts() that follow verify that assumption |
| 1497 | */ |
| 1498 | memcpy(aWc, pDef->pUserData, 3); |
| 1499 | assert( (char*)&likeInfoAlt == (char*)&likeInfoAlt.matchAll ); |
| 1500 | assert( &((char*)&likeInfoAlt)[1] == (char*)&likeInfoAlt.matchOne ); |
| 1501 | assert( &((char*)&likeInfoAlt)[2] == (char*)&likeInfoAlt.matchSet ); |
drh | d64fe2f | 2005-08-28 17:00:23 +0000 | [diff] [blame] | 1502 | *pIsNocase = (pDef->flags & SQLITE_FUNC_CASE)==0; |
drh | 55ef4d9 | 2005-08-14 01:20:37 +0000 | [diff] [blame] | 1503 | return 1; |
drh | dc04c58 | 2002-02-24 01:55:15 +0000 | [diff] [blame] | 1504 | } |